Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise PowerShell Extensions Forum Merge option in Import Access Control from a CSV
    • Sign In

    • State Not Answered
    • Replies 2 replies
    • Subscribers 65 subscribers
    • Views 876 views
    • Users 0 members are here
    • PWPowerShell
    • Permission

    Merge option in Import Access Control from a CSV

    Mohammad Masud
    Offline Mohammad Masud over 5 years ago

    Hi,

    Hope this finds you well. I have a couple of questions regarding the Import-PWAccessControlFromExcel cmdlet.

    - Import access control from a csv using PowerShell cmdlet (Import-PWAccessControlFromExcel) currently does not offer a merge/replace option. So which option does it take by default- merge or replace? Any plan on enabling the merge/replace switch in near future?

    - While importing access controls for an entire project and all its sub-folders, is it enough to provide the parent root folder (level-1) as its input folder where the input csv includes access controls for the entire project? Is there any reason why a subfolder may not import the access controls?

    Thanks in advance for your help.

    Mohammad

    • Sign in to reply
    • Cancel
    Parents
    • Brian Flaherty
      0 Offline Brian Flaherty Thu, Jun 7 2018 4:37 PM

      Unfortunately, there isn't a Merge or Replace option available within the ProjectWise SDK for this and that is how we create the PowerShell cmdlets.  I would think that it replaces all of the access control. Someone, please correct me if I am wrong.

      If a folder name does not match up exactly to what is in the CSV or XLSX file, then the access control will not be updated. 

      If using this tool is not doing what you need, you should be able to create a PowerShell script file to get and set access control.

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Mohammad Masud
      0 Offline Mohammad Masud Thu, Jun 7 2018 5:32 PM in reply to Brian Flaherty

      Thanks for your response. Another question I have is- what happens to changes in existing members (groups, ul's etc.) when you choose the merge option (in manual import)? Does it override the existing ones with new settings that come from the csv or keep the old ones? 

      For instance a folder may currently have a read-write permission for group A. The imported csv has read-only permission for group A in the same folder. If I choose to import the csv with merge option, what would be the new permission setting for group A?

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    Reply
    • Mohammad Masud
      0 Offline Mohammad Masud Thu, Jun 7 2018 5:32 PM in reply to Brian Flaherty

      Thanks for your response. Another question I have is- what happens to changes in existing members (groups, ul's etc.) when you choose the merge option (in manual import)? Does it override the existing ones with new settings that come from the csv or keep the old ones? 

      For instance a folder may currently have a read-write permission for group A. The imported csv has read-only permission for group A in the same folder. If I choose to import the csv with merge option, what would be the new permission setting for group A?

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

    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