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

Merge option in Import Access Control from a CSV

Mohammad Masud
Offline

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

Parents
  • 0 Offline

    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.

  • 0 Offline 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?

Reply
  • 0 Offline 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?

Children
No Data

Communities
Support and Services
Training and Learning
Social Media