Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise PowerShell Extensions Forum Exporting Multiple Document Properties [Not Using Import/Export to Excel Tool]
    • Sign In

    • State Verified Answer
    • Replies 2 replies
    • Subscribers 66 subscribers
    • Views 832 views
    • Users 0 members are here
    • powershell
    • Export
    • SQL
    • Get-PWDocumentsBySearch

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

    Jamie Stevens
    Offline Jamie Stevens over 2 years ago

    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

    • Sign in to reply
    • Cancel

    Top Replies

    • Dan Williams
      Offline Dan Williams Tue, Jan 12 2021 12:13 PM +1 verified
      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…
    • Dan Williams
      +1 Offline Dan Williams Tue, Jan 12 2021 12:13 PM

      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...

      Answer Verified By: Jamie Stevens 

      • Cancel
      • Vote Up +1 Vote Down
      • Sign in to reply
      • Verify Answer
      • Reject Answer
      • Cancel
    • Jamie Stevens
      0 Offline Jamie Stevens Thu, Jan 14 2021 1:15 PM in reply to Dan Williams

      Dan,

      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.

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel

    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies