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?
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 WilliamsSolution ConsultantBentley Systems, IncorporatedPortland, OR, USA (Pacific Time UTC-08:00)
Answer Verified By: Jamie Stevens
Thanks for the quick response. This was exactly what I was looking for.
With respect to the "words get in the way", you are bang on. I tested the solution above and compared it with the output from the Import/Export Tool and the DocumentGUID and ObjectID are identical.