Export all CAD files from Windchill

The first question is WHY?

PTC does not make it easy to export a lot of files from Windchill. I have done it for about 30 assemblies which ranged in size from a hundred components to over 2000 components. It is not an easy task as even putting the top level drawing in your workspace, which is the only place to export from, does not always grab all related files. I had  to do the download to workspace, then open the file in Creo to get all related files in the workspace for export.

The scripts should not be too hard if you know the Windchill table structure. I am not an Oracle/SQL person, but have seen scripts to do this in the community. Remember that the file name on disk in the vault is an encrypted name and you would have to rename it to the real name when exported with revision and iteration.

If practical depending on quantity, add everything (latest) to one workspace, and the export to local disk all in one folder, giving all the native CAD files directly.  May run out of RAM and may need to do in chunks.

If this doesn't work, it's possible to create and run two simple querries against the database:

- Find the child object(s) if they exist for every object (e.g. if a drawing, list the related model(s); if an assembly, list the related children.  Gets messy very fast because of family tables, etc., etc. but can be done.

- Find the vaulted file name (e.g. 000025cd53ba) for each cad object.

With this, one can laboriously find related files when needed.

This is an actual migration project.

The best solution is to build a script tooling.