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

    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