Importing and Exporting from Windchill

Here is some more background on what I am dealing with on a daily basis:

I use an offsite CAD service provider that creates Pro/E drawings for me. They convert a lot of 2D hand drawings. I send them a lot of family table parts, such as hardware through an FTP site. They create the drawings and models, and then send them back.

I eventually get the files into my workspace and check them in. The assemblies range in size from a few parts to 1500. The top level assemblies are about 4000 parts, but I don’t send these out.

You've got a lot of topics here so let me take a stab at it. Others please join in. There is a TPI on importting data into a workspace that predates the"Import to Workspace" functionality. I've documented this internally for my users but basically it follows Pro/E load order. First identify anything in the assembly that you know has not changed (like FT hardware). Remove them from the folder leaving ONLY new or modifed files. Load the top level drawing or assembly. You can use a search path for the questionable items or items you know have not changed. Pro/E will load all models if finds from that folder and ASSUME they are modified. If it cannot find a model, it will pull from Windchill. Next it will look at search paths. This will avoid the 8000 items in the workspace (all instances).

For family tables, please see my video on reducing large family tables. It explains a lot.

I've been playing with the workspace import more and more but I am not an expert. I know that it removes all items from session. That is by design. Same is true for switching workspaces. I remember a few PLMs asking my opinion on this matter many years ago. It simplifies the number of use cases to deal with and issues that can arise when bringing data in. I do believe that the options in the workspace import allow you to sift through the items you are bringing in but accepting defaults is not working out for you.

You might want to look into offline workspaces for your supplier. I have not used them but they are a way of taking data out and disconnecting for a while.

As for ghost, watch out for suppressed components, renames and external references. Drawings will keep a hold on old names, expecially assembly drawings. There is a conflict option, cleanup_drawing_dependencies that will allow you to remove them but only when bringing in the drawing from an outside folder. It will remove all missing references but you get no ghosts. Watch out for purple dimensions and missing leaders.

Here is the link to the FT video: Video Link : 1672

Here are my steps for bringing in Pro/E data:

1. If there are CAD files that you are modifying that already exist in PDMLink, ensure that those are downloaded and checked out to the current Workspace.
2. Put the CAD files you wish to bring into the workspace (new or modified) in a new folder on your hard drive. Backup works well to ensure the dependents are moved as well.
3. Create a subfolder in this new folder.
4. Move all CAD files except top level parent files or items that you know are new or modfied to that subfolder. This hides the common or questionable models from the retrieval process.
5. Erase all models from the Wildfire session.
6. Open the config.pro (Tools - Options) and create a "search_path" entry to the subfolder created in step 3. Apply setting. This is a temporary search path so it does not need to be saved to your local config.pro file.
7. Open and browse to folder in step 2 and open the top level parent files. When Wildfire retrieves the dependents, any file that is in that folder will be loaded. Next it will pull from PDMLink. Any other files will be pulled from the subfolder due to the search path setting.
8. Save models. This will save them to the workspace. You might see conflict messages about items already being in the workspace. This is ok. What you should look out for is conflicts related to milspec library parts. If you see those cancel the save and mark those models as read-only (Lock). Repeat the save.

It is important to know the Wildfire Retrieval order:

If connected to PDMLink Workspace:

1. In Session (in memory) - not possible to reload a model once it is in memory.
2. Directory where parent item was loaded from. If components exist in folder with assembly that is retrieve it is loaded too from that location.
3. Active PDMLink Workspace
4. Active PDMLink Server (CommonSpace) - This will cause Wildfire to download and add required model to the Workspace.
5. Local Working Directory
6. Search Paths and Pro/Library folders

If not connected to PDMLink workspace but using local drives:

1. In Session (in memory) - not possible to reload a model once it is in memory.
2. Directory where parent item was loaded from. If components exist in folder with assembly that is retrieve it is loaded too from that location.
3. Local Working Directory
4. Search Paths and Pro/Library folders

Hey,

I experience the same issue with 11.2 Windchill Quality. Bassically I can see each data line transported "by hand" from my excel file to the windchill database. I've 270000 datalines in my excel sheet, containing all information (parentassemblies, part etc....)....it is extremly slow and unreliable. Looking into the SQL database, it seems like that the whole structure is represented in one single table.....that doesn't seem to be a good relationship (it should be at least two ....one lists all parentassemblies, one lists all parts).

I haven't found a way to write directly the data into the Windchill SQL table (admin.system). There is somewhere a hidden check/relationship I haven't found yet, because if I enter the data in the SQL database and assign it to the project, it doesn't show up in the Windchill application.

Maybe I need to organize my excel sheet in a different form? Is there the need that the tree-structure of the assemblies is already in a certain order/sequence?

Kind regards,

Tobias