×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How to do a search in windchill assemblies using a macro?

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

RE: How to do a search in windchill assemblies using a macro?

Don't even try that from with Creo, even using your workspace.
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?

(OP)
Thank you very much for your answer

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?

The tables in Windchill can be examined for this information. The Admin for your system should have enough SQL experience to get the desired information directly from the Windchill tables.

RE: How to do a search in windchill assemblies using a macro?

The list returned will be too large to view/manipulate.

"Wildfires are dangerous, hard to control, and economically catastrophic."

Ben Loosli

RE: How to do a search in windchill assemblies using a macro?

(OP)
Shall you very please elaborate? Why very large? Does it dep on the number of files or something else?

RE: How to do a search in windchill assemblies using a macro?

It will depend on how many files you have in Windchill. For me, it would be over 1,000,000!

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login



News


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close