Exporting Multiple Document Properties [Not Using Import/Export to Excel Tool]

Question related to exporting document property data from our Datasource (not the actual files).

Looking to extract document properties for about ~12,500 files, for use on another task. The amount of documents will continue to grow as the Project develops.

The document properties I am looking for are Object GUID, File Name, Folder Name, Folder ID, Created By, File Updated and File Path.

Performing this task using the standard Import/Export To Excel tool in PW takes ~ 55-60 minutes. (Searching for files using Saved Search, highlighting documents and adding to the list, running through the wizard and finally letting the process run). This process is run multiple times a week, so I am hoping I can speed it up or optimize it.

Looking at the PowerShell commands, 

Get-PWDocumentsBySearch - This can be used to obtain some of the document properties, but is missing Object GUID & Created/Updated.

Is there something that would help get the missing properties?

Also, would this be possible/quicker if querying the database directly on the server? 

Thanks

Parents
  • Jamie, I suspect that using the -Slow parameter will meet your needs.

    Here's a test I tried using a saved search that returns just one document:

    and the same search, but with the -Slow parameter:

    Looks like you can get all the properties that you want this way.

    As I like to say, "words get in the way", so some of the properties that you are asking for "go by" different names in the results such "Object Id" I'm assuming to be the "DocumentGUID" (or is it the "DocumentId"?), but I could be wrong...

    Dan Williams
    Solution Consultant
    Bentley Systems, Incorporated
    Portland, OR, USA (Pacific Time UTC-08:00)

    Answer Verified By: Jamie Stevens 

Reply
  • Jamie, I suspect that using the -Slow parameter will meet your needs.

    Here's a test I tried using a saved search that returns just one document:

    and the same search, but with the -Slow parameter:

    Looks like you can get all the properties that you want this way.

    As I like to say, "words get in the way", so some of the properties that you are asking for "go by" different names in the results such "Object Id" I'm assuming to be the "DocumentGUID" (or is it the "DocumentId"?), but I could be wrong...

    Dan Williams
    Solution Consultant
    Bentley Systems, Incorporated
    Portland, OR, USA (Pacific Time UTC-08:00)

    Answer Verified By: Jamie Stevens 

Children