When I try and re-import from an exported permissions excel file, projectWise returns me the error message `Unable to import from excel. Make sure Excel 2003 or newer is installed'. I have installed office 2010 and 2016 and get the same result, I have tried importing the xlsx and the csv and I get the same result. I have attempted to do the import using ProjectWise V8i and ProjectWise CONNECT and I get the same result.
#can successfully export the access control to xlsxExport-PWAccessControlToExcel -ExportFolder $Path -ExportFileName "H999995_accesscontrol" -InputFolder $ProjectToArchive -AllLevels
#can successfully export the access control to csvExport-PWAccessControlToExcel -ExportFolder $Path -ExportFileName "H999995_accesscontrol" -InputFolder $ProjectToArchive -ExportFileExtension 'csv' -AllLevels
#unable to import the access control from xlsxImport-PWAccessControlFromExcel -ImportFileNamePath 'C:\temp\Export\PWArchive\H999995_accesscontrol.xlsx' -InputFolder 'Projects\Hatch Internal\SiteABC\H999995'
#unable to import the access control from csvImport-PWAccessControlFromExcel -ImportFileNamePath 'C:\temp\Export\PWArchive\H999995_accesscontrol.csv' -InputFolder 'Projects\Hatch Internal\SiteABC\H999995'
Kind regardsGavin Chapman
gavin.chapman@hatch.com
are you modifying the excel file at all?
Does reimporting the exact excel file you export work (does it work if you manually import the excel file?
Only thing I see different from how I do it is I put -InputFolder first? shouldn't matter with named attributes but maybe. Also I'm importing an xlsx file I created with manual export, not the Export-PWAccessControlToExcel cmd. And finally, are you using the latest PWPS_DAB install?
I use:
$result = Import-PWAccessControlFromExcel -InputFolder $ProjFolder -ImportFileNamepath $PermissionsXLS
I'm not sure which versions of ProjectWise and Office are currently supported, but in the past if you weren't using one of the unsupported versions of Office that message would show up, even if your Office version was newer than the indicated version. It really should have said, "Only Office 2003 and Office 2007 are supported." That was changed at some point in recent years, for at least some of the utilities that leverage Office.
the server i run my script on has Excel 2016 installed on it, but i'm not sure that is required for the PowerShell version of the export/import. ACL import/export works for me both from PW Explorer on this server and Powershell.
These are the other versions I'm using:
Name Version ---- ------- PowerShell 5.1.14409.1012 CLR 4.0.30319.42000 ProjectWise 10.00.01.71 PWPS 0.0.0.6 PWPS_DAB 1.2.20.0
it seems that I cant even do it manually in ProjectWise explorer using excel 2010 or using excel 2016
I don't really want to go and install an old Office 2007, and I am sure that in the SIG demo that office 2016 was said to be supported, it seems that my problem might not be with the PowerShell DAB that I downloaded, but rather with ProjectWise explorer since I cant even do the import manually through the explorer.