Import a spreadsheet into the database

Procedure

1. Create a Microsoft Excel file with specific headings. The import utility recognizes specific headings and formats in the Excel file and translates them into Teamcenter structures.Sample Excel file:

2. Save the Excel file as a text file.

In Excel, click File→Save to save the Excel file.

Choose File→Save as.

In the Save as type box, select Text (Tab delimited)(*.txt). Sample .txt file saved from the sample Excel file:

If you are updating the text file, you are asked if you want to replace the existing file. Click Yes. Excel displays a message stating that certain features in your file may not conform to a tab-delimited text file.

Click Yes.

Click File→Close to close the Excel text file. If a dialog appears requesting that you save the text file, click No. The text file is saved in the same directory as the Excel file. This is the input for the import utility. Note The pipe character ( | ) is not permitted within the Excel file. It causes an error in the import routine.

The structures from the Excel file are imported into the database and you can open them in Part Planner.

3. Call the tcexcel_import utility to import the Excel file into the Teamcenter database.

Open a Teamcenter shell (Teamcenter command prompt).

Change to the import directory where the Microsoft Excel file is stored.

Call: tcexcel_import -u=user_name -p=password -g=group_name -i=my_excel_file.txt

Sample structure created from the .txt file that was saved from the sample Excel file:

Related Topics

• Creating a simple structure