Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise PowerShell Extensions Forum Get-PWDMIncomingRFIsWithProperties BTSTypes
    • Sign In

    • State Not Answered
    • Replies 2 replies
    • Subscribers 65 subscribers
    • Views 533 views
    • Users 0 members are here
    • powershell
    • Deliverables Management
    • pwps_dab
    • PWDM

    Get-PWDMIncomingRFIsWithProperties BTSTypes

    Paul Duffy
    Offline Paul Duffy over 2 years ago

    Does anyone have any experience with using the PWDM cmdlets?

    I currently have a script working that uses the Get-PWDMIncomingRFIsWithProperties to list out all RFIs within a date range and then extract all the information for those by looping through the results and putting the attributes into a data table. All that is working fine, but on exporting to csv or using the New-XLSXWorkbook cmdlet I end up with 4 columns that contain System.Collections that are not readable, they are just objects, as follows;

    BTSTypes.ExternalRecipientInfo,

    System.Collections.Generic.List`1[BTSTypes.IncomingRfiRecipient],

    System.Collections.Generic.List`1[PWDMInterfaceForAW.IncomingRfiAnswer],

    System.Collections.Generic.List`1[PWDMInterfaceForAW.Attachment].

    I understand why they are coming out like this, but I was wondering if anyone can suggest an efficient way to convert the collections to a comma separated string that will be readable in csv and xlsx.

    I am googling to find solutions, but I was hoping someone might have some code they wouldn't mind sharing?

    I'm assuming that the BTSTypes are just a custom version of the System.Collections and can be opened up in a similar way?

    • Sign in to reply
    • Cancel
    • Paul Duffy
      0 Offline Paul Duffy Thu, Nov 5 2020 11:11 AM in reply to Brian Flaherty

      Hi Brian,

      I am exporting the information to an xlsx workbook which will be moved to SharePoint and then plugged into PowerBI to create a tracking dashboard, so unfortunately I do need most of the info, though I might be able to cut some requirements back. I think the list items will be the ones we need to keep though, so the ccRecipients and the Attachments and RFIAnswers. I have fixed the first collection in the list, I didn't realise I hadn't selected the .email for MainRecipient. I can loop through the lists and use joins to stop the objects appearing in the exports, but for 675 RFIs and counting that is quite a lot of processing, but if that is the only way then fair enough.

      Rimantas has said that dashboards for RFIs won't be available until about H2 2021, and we are being pressed for something in the meantime.

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Brian Flaherty
      0 Offline Brian Flaherty Thu, Nov 5 2020 10:27 AM

      There is quite a bit of information captured with each RFI. Are you looking for anything specific?

      • 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