How do I copy the view columns and a list of files to Excel Spreadsheet?
User is attempting to make a report using a view. Once the view was created the user did a search for the files they wanted in the report. At this pointed they wanted to copy the list of files along with the view column data to a spreadsheet.
Right mouse click on the files and choose ”Copy list to” , “Clipboard tab separated”
The view columns will become the headers of the columns in Excel.
Create a view that includes the folder properties you wish to capture, then change to that view.
Under your user settings \ Document List make sure you have the option to "Show Subfolders" turned on. I believe this is on by default. When you are in Projectwise and you click a parent folder and the subfolders appear on the right, then you have this setting turned on.
Highlight the Parent folder
Go to Document \ ”Copy list to” , “Clipboard tab separated”
Open an Excel Spreadsheet and paste the data into the spreadsheet.
The view columns will become the headers of the columns in Excel
Note this function will only copy the first level subfolders.
Enumfolders.exe is a new command line utility included with the V8i release of ProjectWise, and is a part of the ProjectWise Administrator install. The application is used to provide a way to report on ProjectWise folders/files. The program is also able to re-curse through the folder structure which allows a complete report of the hierarchal folder structure. This can be very useful for users who want to export the folder/file information from ProjectWise, to a text file for review. It can also be used for viewing the name of files and folders that have been deleted. (Note: this tool does not provide attribute data, only folder and file names)
For more information on Enumfolders see. EnumFolders Technote
I have updated this article to include how to export a list of subfolders.
What if you want to export subfolders within a folder?