• Replies 7 replies
  • Subscribers 62 subscribers
  • Views 9670 views
  • Users 0 members are here

Projectwise Audit Trail Action Name

Ben Fullenkamp
I am creating some reports in Access based off the dms_audt table for Projectwise and while it references action code in the table, it doesn't have any obvious link to another table where it actually pulls the "Checked Out" or "Exported" etc... text and it doesn;t seem to follow a logical pattern as to what code relates to what action.  Where does the text for the action name come from and how can I link it to my query so I can show what action the users in the reports are doing?
Parents
  • Offline

    The Action Names are in code vs another table in the database.  The reason for this is so that they can be translated for the various languages that ProjectWise supports.

     

    Let me see if I can get a list of action names to IDs.

     

    HTH,

     

    John

     

        

  • Offline in reply to John Schown

    Give this a try:

    1001 - Document created.

    1002 - Document's general properties modified.

    1003 - Document attributes modified.

    1004 - Document file added.

    1005 - Document file removed.

    1006 - Document file replaced.

    1007 - Document checked-in.

    1008 - Document viewed.

    1009 - Document checked-out.

    1010 - Document copied-out.

    1011 - Document given-out.

    1012 - Document state changed.

    1013 - Document final status set.

    1014 - Document final status removed.

    1015 - New document version created.

    1016 - Document moved.

    1017 - Document copied.

    1018 - Document permissions changed.

    1019 - Redline created or accessed.

    1020 - Document deleted.

    1021 - Document exported.

    1022 - Document freed.

    1023 - Document extracted.

    1024 - Document distributed.

    1025 - Document was sent.

    1026 - Commented by user.

    1027 - Document imported.

    2001 - Document set formed.

    2002 - Document set member added.

    2003 - Document set member removed.

    1 - Project/folder created.

    2 - Project/folder modified.

    3 - Project/folder workflow changed.

    4 - Project/folder deleted.

    5 - Project/folder state changed. 

        

  • in reply to John Schown
    That worked great.  I just created my own table with these values and it seems to correspond perfectly.  Thanks for your help.
Reply Children
No Data

Communities
Support and Services
Training and Learning
Social Media