I would like to share a Excel macro which I have created for simplifying file import to Projectwise from XLS. This script allows to browse for folder and fill the file list in Excel spreadsheet.
After file list is loaded the columns will be filled with filename and path to source file. 2nd row is reserved for Excel formulas or default attribute values. This row will remain empty and is used to fill down the values/formula for other columns.
.
Values marked in green are mandatory for each row. If some files are not needed for import then one of these cells can be deleted and it will not import in Projectwise afterwards and also will be logged as an error in log file. Other cells can be filled manually.
It is possible to append more files to list by executing the macro again using icon in upper left corner:
To restart and clear sheet use other custom icon in upper left corner:
Attached file contains only general attributes. To be able to fill your custom attributes also it is needed to copy these from your PW environments. Create a Excel template using PW Excel Export-Import tool and copy additional columns from created template and also replace Sheet2.
you are welcome
Cool, I will give this a try. Thanks for posting.