tcexcel_import

Populates structures in Teamcenter based on definitions in a Microsoft Excel spreadsheet. The main purpose of this utility is to import process structures, such as build sequences or process plans, but the utility can also import any type of product, process, plant, and resource information. Additionally, the utility supports: Linking between multiple structures Assigning relations (consumed, required, work area, and resources) Attaching forms and filling out attribute values Modifying ownership Defining activities (with time information) Attaching variant information The tcexcel_import utility is designed for data creation only. You can set the description on items and revisions during creation. Once you create an item, you can only update the item description. The basic steps to use this utility are: Create an Excel spreadsheet containing the structure that you want to import. Save the spreadsheet as a tab delineated .txt file. Run the tcexcel_import utility using the tab delineated .txt file as input. The utility converts the .txt file to a .pim file and uses the .pim file as input to create the structure in Teamcenter. This documentation describes the .pim file syntax that is normally created automatically from the .txt file in addition to the parameters for calling the utility. Syntax tcexcel_import [-u=user-id {-p=password | -pf=password-file} -g=group] -i=input-file1[;input-file2...] [-d=debug-level] [-o={on | off}] [-t=item-type] [-s=dummy-status] [-pr={precise | imprecise}] [-m=marker-file-name] [-f=file-format-help] [-psfile] [-parser_only] [-delimiter=delimiter-character] [-h] Arguments -u Specifies the user ID. This is a user with Teamcenter administration privileges. Note If Security Services single sign-on (SSO) is enabled for your server, the -u and -p arguments are authenticated externally through SSO rather than being authenticated against the Teamcenter database. If you do not supply these arguments, the utility attempts to join an existing SSO session. If no session is found, you are prompted to enter a user ID and password. -p Specifies the password. This argument is mutually exclusive with the -pf argument. -pf Specifies the password file. For more information about managing password files, see Manage password files. This argument is mutually exclusive with the -p argument. -g Specifies the group associated with the user. If used without a value, the user's default group is assumed. -i Specifies input files. At least one file name is required. Additional file names are separated with a semicolon (;). -d Sets debug level. Default value is 0, no debug messages. Set this value to 5 or above to generate debug messages. Each level displays progressively more messages. The content of the messages is dependent on the type of structure that is loaded. -o Toggles overwrite mode on or off. Default is to overwrite. -t Specifies default item type. Default is item. -s Specifies dummy release status for working revisions. Default is DUMMY_STATUS. -pr Specifies precise mode. Default is imprecise. Set this value to precise to create a precise structure. -m Specifies marker file name. Default value is marker.txt. -f Displays a help message describing file format. -psfile Specifies if the file specified by the -i option is a PIM file. -parser_only Specifies to stop after preparsing of Excel files with Header4. -delimiter Specifies delimiter character. Default is #. Note The character used as the -delimiter should not be used in the input file. For example, if the delimiter character is #, the following line will not process correctly – "SHEET, COP #22 AWG". -unique_working_revision Specifies that it is an error to have more than one revision with no status. Only the working revision will be the one with no status. -align_bv_owner=<1/0> Specifies that the bv and bvr should have the same owner as the parent item/revision. Default is 1. -clr If a prior marker file is present, then delete it before processing. -add_note If note types MEConsumedInfo, MERequiredInfo, MEWorkareaInfo, and MEResourceInfo are desired -allow_h4_duplicates If the same item name appears, the default is to ignore it. Set this option to override that behavior. -h Displays help for this utility. Input file format For information regarding file format and valid data fields, see the Importing structures using the tcexcel_import utility section in the Manufacturing Process Planner documentation. Related Topics Manufacturing Process Planning ─ Usage Part Planner