Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise PowerShell Extensions Forum Re-Importing Project Access Control Excel "Error: Column 'ProjectName' does not belong to underlying table 'Directory' "
    • Sign In

    • State Not Answered
    • Replies 0 replies
    • Subscribers 65 subscribers
    • Views 176 views
    • Users 0 members are here
    • PWPS
    • ProjectWise
    • pwps_dab
    • ProjectWise Programming
    • ProjectWise PowerShell Modules

    Re-Importing Project Access Control Excel "Error: Column 'ProjectName' does not belong to underlying table 'Directory' "

    Bhanu Chauhan
    Offline Bhanu Chauhan over 2 years ago

    I exported a Work Area access control details to Excel using Export-PWAccessControlToExcel command for all levels.

    Now, when I try to re-import the same after making some changes to access controls, I get the below error.

    Error: Column 'ProjectName' does not belong to underlying table 'Directory' 

    + Import-PWProjectAccessControl @Splat -Verbose
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : NotSpecified: (:) [Import-PWProjectAccessControl], ArgumentException
    + FullyQualifiedErrorId : System.ArgumentException,PWPS_DAB.ImportPWProjectAccessControl

    Code using for importing Access control excel

    $pwFolder = Get-PWFolders -FolderPath 'relevant path' -JustOne

    $Splat = @{
    InputFolder = $pwFolder
    ImportFilePathName = "C:\Users\XXX\Desktop\Powershell\TestAccessReport.xlsx"
    }
    Import-PWProjectAccessControl @Splat -Verbose

    • 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