Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise PowerShell Extensions Forum Import-PWAccessControlFromExcel Format
    • Sign In

    • State Verified Answer
    • +1 person also asked this people also asked this
    • Replies 11 replies
    • Subscribers 65 subscribers
    • Views 2375 views
    • Users 0 members are here

    Import-PWAccessControlFromExcel Format

    Peter Willmen
    Offline Peter Willmen over 3 years ago

    Can anybody tell me which version of PWPS_DAB the ability to use a .csv file for the 'Import-PWAccessControlFromExcel' function was removed?

    I need to rollback the version to run some existing scripts as I am getting the following message from 1.20.0.0

    Import-PWAccessControlFromExcel : Invalid file extension 'csv'

    • Sign in to reply
    • Cancel

    Top Replies

    • Brian Flaherty
      Offline Brian Flaherty Mon, Mar 30 2020 7:25 PM in reply to Andrea Scrutton +1 verified
      I resolved the issue with the Import-PWAccessControlFromExcel cmdlet. Should be updated in the next release of the PWPS_DAB module.
    • Aaron Cleveland
      Offline Aaron Cleveland Wed, May 6 2020 11:31 AM in reply to Brian Flaherty +1
      I am glad to see this tool available now as my organization was just looking for a solution for just this problem. My question now is is there a way to apply an excel permission template over multiple…
    Parents
    • Andrea Scrutton
      0 Offline Andrea Scrutton Mon, Mar 30 2020 10:16 AM

      I'm getting that too, thought it was my PowerShell playing up, I've had a few weird issues recently.  I hope this hasn't been removed as we rely on this feature a lot as we use it in our project creation using machines that don't have office installed.

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Brian Flaherty
      +1 Offline Brian Flaherty Mon, Mar 30 2020 7:25 PM in reply to Andrea Scrutton

      I resolved the issue with the Import-PWAccessControlFromExcel cmdlet.  Should be updated in the next release of the PWPS_DAB module. 

      Answer Verified By: Peter Willmen 

      • Cancel
      • Vote Up +1 Vote Down
      • Sign in to reply
      • Verify Answer
      • Reject Answer
      • Cancel
    • Aaron Cleveland
      0 Offline Aaron Cleveland Wed, May 6 2020 11:31 AM in reply to Brian Flaherty

      I am glad to see this tool available now as my organization was just looking for a solution for just this problem.  My question now is is there a way to apply an excel permission template over multiple Work Areas at once?  

      • Cancel
      • Vote Up +1 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Dustin McDuffie
      0 Offline Dustin McDuffie Mon, Jun 15 2020 12:30 PM in reply to Aaron Cleveland

      I too would like to know if this would be possible. We have around 200 Work Areas that need to be updated and it would be nice to apply a permission template across all Work Areas/sub-folders. Brian Flaherty

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Brian Flaherty
      0 Offline Brian Flaherty Mon, Jun 15 2020 5:18 PM in reply to Aaron Cleveland

      You would have to loop through the desired work areas and update them one at a time.

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Dustin McDuffie
      0 Offline Dustin McDuffie Tue, Jun 16 2020 11:50 AM in reply to Brian Flaherty

      Thanks for the feedback Brian, looks like I was able to mass update multiple Work Areas/Folders with this loop.

      $proj_folders = get-pwfolders -folderpath "1-Active Projects" -Slow | Where-Object -Property "Name" -Like -Value "X*"


      $proj_folders | foreach-object -Process {Import-PWProjectAccessControl -InputFolder $PSItem.FullPath -ImportFilePathName 'C:\FilePath.xlsx'}

      Aaron Cleveland this may be helpful for what you're trying to do as well. Brian mentioned in a different thread that having 'Display Descriptions' enabled will cause it to not find the folderID, so that may need to be toggled off for this.

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Brian Flaherty
      0 Offline Brian Flaherty Tue, Jun 16 2020 12:03 PM in reply to Dustin McDuffie

      Excellent. Keep in mind, piping to the Foreach-Object can be a bit slower than if you used a For loop or a foreach loop. Nothing to worry about if you are not seeing performance issues. Thumbsup

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    Reply
    • Brian Flaherty
      0 Offline Brian Flaherty Tue, Jun 16 2020 12:03 PM in reply to Dustin McDuffie

      Excellent. Keep in mind, piping to the Foreach-Object can be a bit slower than if you used a For loop or a foreach loop. Nothing to worry about if you are not seeing performance issues. Thumbsup

      • 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