Hello, Community.
I have a list of files from the consultant that are for use. I need to feed the list of these files into ProjectWise , retireve only these files and export them.
Is there a way to feed Projectwise an Excel Spreadsheet with the list of files to be searched ? Apparently, buffer for the value is too small, and I am not sure I can feed comma/semicolumn separated values directly to a buffer.
Please, advise
any update with this question?I do have the same problem. I have a spreadsheet that list about a hundred files with specific attributes and version. i need to search all these in every folder with the correct version. Is there a way in projectwise to use a spread sheet to find all these files so i can add them in a flatset and zip file. at the moment im search it one by one
Ideally you would want to script this with PowerShell and pwps_dab.It could then return a list of matching Name, versions etc... and the folder path.
Alternatively, if you're using the new version of PWE (4.434 or newer) you could use the FILTER columns after doing a search for all documents.I'd suggest you limit the search as much as you can. To your project or client folder depending in your layout, otherwise you might be listing hundres of thousands of documents across your entire datasource.Once the search is complete you can use the filter columns to search for any view you have setup.
Hi Alex, thanks for your reply. unfortunately i dont have power shell or pwps_dab exerience. i might need to check this with our projectwise administrator if he is able to create a powershell script.
on the otherhand. the excel spreadsheet i have that has all the list of files with specific version are stored in different folder location hence i was thinking if its possible for projectwise without scripting to use a spreadsheet to locate all these files.
Hey Rold,
Unfortunately, I've not come across something in ProjectWise that can do that :(
You can make searching for the files quicker using the filters though (again on 3.4xx versions of ProjectWise Explorer)If you do a Document search and leave it open, it will search and list ALL documents in ProjectWise.This will take a few minutes depending on your document count/connection to server, but once the list is complete you can then use the filters to instantly filter and unfilter (typing in names of documents or versions, etc).
This will be much quicker then manually browsing through projects.
The more you can narrow down the search the better, even if you know the files are MicroStation drawings (filter file name by *.dgn)Then in the list that returns thousands of files you can use the filter at the top.