How to do a search in windchill assemblies using a macro?
How to do a search in windchill assemblies using a macro?
(OP)
Hi all
I am working with Creo 2 and as one of the first jobs. We need to have a list of all the existing parts and assemblies in our windchill. Since there's a huge amount of files. I'd like to know whether it's possible t to do that within a macro, to read the files from windchill and list the files in another file like excel.
Has anyone done this?
I have seen this question but I didn't understand what they are saying
http://www.eng-tips.com/viewthread.cfm?qid=416872
I am working with Creo 2 and as one of the first jobs. We need to have a list of all the existing parts and assemblies in our windchill. Since there's a huge amount of files. I'd like to know whether it's possible t to do that within a macro, to read the files from windchill and list the files in another file like excel.
Has anyone done this?
I have seen this question but I didn't understand what they are saying
http://www.eng-tips.com/viewthread.cfm?qid=416872
RE: How to do a search in windchill assemblies using a macro?
If you want a list of files in Windchill, use a normal web browser to look at the Windchill data. You can do a search and then export the results to Excel. Windchill will limit your search to 2000 items per page by default.
Overall, that is a suicide search because of the number of hits it will return, especially if your company has been using Windchill for a while. A wildcard search here would be approaching 1 million files returned! We have been on Windchill for 8 years and only have 1 product. I have worked at other companies where we had Windchill folders and or contexts for different groups.
WHY do you need to create a list of all files in Windchill?
"Wildfires are dangerous, hard to control, and economically catastrophic."
Ben Loosli
RE: How to do a search in windchill assemblies using a macro?
what did you mean by " that is a suicide search because of the number of hits it will return" ?
I was willing to open the files one by one and read the relevant information from the files directly
RE: How to do a search in windchill assemblies using a macro?
RE: How to do a search in windchill assemblies using a macro?
"Wildfires are dangerous, hard to control, and economically catastrophic."
Ben Loosli
RE: How to do a search in windchill assemblies using a macro?
RE: How to do a search in windchill assemblies using a macro?
Your best method to get a listing of all files in Windchill and their relationships is to hire someone who knows SQL and have them write some scripts to extract the information directly from the DB.
"Wildfires are dangerous, hard to control, and economically catastrophic."
Ben Loosli