Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise PowerShell Extensions Forum Speed of retrieving list of documents
    • Sign In

    • State Verified Answer
    • Replies 3 replies
    • Subscribers 64 subscribers
    • Views 358 views
    • Users 0 members are here
    • pwps_dab

    Speed of retrieving list of documents

    Michael Reilly
    Offline Michael Reilly 4 months ago

    I have a folder with 680 documents.  There's no sub folders.  Two of the files are nearly 1 gig each (but I don't think that should matter).

    I've tried both Get-PWDocumentsBySearch (with -slow because I need the custom attributes) and Get-PWDocumentsByGUIDs 

    It's taking between 5 and 10 min to create the list of files.  Is that timeframe normal, and is there a faster way?

    • Sign in to reply
    • Cancel

    Top Replies

    • MWBSI
      MWBSI Thu, May 4 2023 10:29 PM +1 verified
      Get-PWDocumentsBySearchExtended and its ColumnsToReturn parameter may be of some value to you. Mark Weisman | Bentley Systems
    • Robert McMillan
      Offline Robert McMillan Thu, May 4 2023 11:27 PM +1
      Can also do something like this to get the documents without the -Slow or -GetAttributes switches and then use the document object method .GetCustomAttributes() to populate the CustomAttributes hash table…
    Parents
    • MWBSI
      +1 MWBSI Thu, May 4 2023 10:29 PM

      Get-PWDocumentsBySearchExtended and its ColumnsToReturn parameter may be of some value to you.

      Mark Weisman | Bentley Systems

      Answer Verified By: Michael Reilly 

      • Cancel
      • Vote Up +1 Vote Down
      • Sign in to reply
      • Reject Answer
      • Cancel
    Reply
    • MWBSI
      +1 MWBSI Thu, May 4 2023 10:29 PM

      Get-PWDocumentsBySearchExtended and its ColumnsToReturn parameter may be of some value to you.

      Mark Weisman | Bentley Systems

      Answer Verified By: Michael Reilly 

      • Cancel
      • Vote Up +1 Vote Down
      • Sign in to reply
      • Reject Answer
      • Cancel
    Children
    • Michael Reilly
      0 Offline Michael Reilly Thu, May 4 2023 10:56 PM in reply to MWBSI

      Thanks, that's seconds instead of minutes.  Still takes a couple on min to update the attributes, but that's bearable.

      • 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