CSV2TCXML Quick Start Guide
This new CSV2TCXML tool is shipped from TC11.6 and TC12.1 onwards.
CSV2TCXML Features
CSV2TCXML tool is used for converting csv file(s) containing Teamcenter Meta data into TCXML file which can then be imported
into Teamcenter in fastest way.
Highlight Features
• Supports standard .csv files.
• Supports many encodings beyond ASCII and UTF8. (Refer to Appendix A of the CSV2TCXML User Guide.)
• The utility is highly configurable using the csv2tcxml.ini file and supporting .ini files.
• Can create multiple objects of the same class in one row using the object name.
• No longer requires the csv2tcxml_mapping.txt file for linking. Linking rules in the header are used.
• Many more templates can now be supported with the extendable framework.
• Additional features such as attribute propagation and class aggregation.
CSV2TCXML Install
• Send an email to PLMS customer support with customer sold-to id and customer info and ask for a migration site id for
your migration purpose.
• Open csv2tcxml.ini from TC_DATA/csv2tcxml folder and set the following parameter with value:
source_site=<Valid Migration ID from Customer Support>
• Open Teamcenter command prompt and go to TC_DATA/csv2tcxml folder and execute following command:
csv2tcxml install [username password group]
Teamcenter credential is optional. If you are going to work with ImanFile, you’d better give the admin credential so that
the tool can fetch volume information from the system. Then in your input, you don’t need to specify ImanFile’s volume
and sd path. Otherwise, you must set those attributes by yourself.
CSV Column Names
Column name should be in the format – ClassName:AttributeName.
To find which class has which attribute and the attribute information, open csv2tcxml/model/datamodel.html.
Unrestricted
CSV2TCXML Quick Start Guide
This offline web page is generated during install. Please note that the tool will only create objects that have key defined along with
its helper objects. If a class has no key definition, it may not be created. Please refer to the User Guide for detailed information.
If you are working with classification object – icm0, you can give extra command option -c or -classification to the install command
to generate another page – csv2tcxml/model/classification.html. Refer to User Guide section 7.9 for more details. This feature is
introduced in TC12.2.
CSV Conversion
Open Teamcenter command prompt and run the conversion command from anywhere in case you give the full path to the script:
csv2tcxml items.csv
csv2tcxml bom.csv –p exist=Item
Import TCXML
Open Teamcenter command prompt and execute the following command:
tcxml_import -u=<> -p=<> -g=dba -bulk_load -file=<xml-file-name>
If TCXML has admin objects that does not exist in the TC server, import may fail. The suggestion is to create the admin objects
before importing your data.
Sample CSV Files
There are many sample csv files in csv2tcxml/examples folder. Those samples are grouped by template. You may find something
useful there. Explore example folder before starting your own work.
CSV2TCXML Supported Classes
Following are the main OOTB classes supported by this tool – it is not a complete list. Subclasses are supported automatically if
they don’t have special business logic.
Template Classes
Foundation Item, ItemRevision, Anchor, PSBOMView, PSBOMViewRevision, PSOccurrence,
PSOccurrenceThread, Dataset, RevisionAnchor, Form, ImanRelation, ImanFile,
ProjectObjectRelation, PSOccurrenceNotes, Effectivity, GDEOccurrence, GDEbvr,
GeneralDesignElement, ReleaseStatus, Fnd0TableRow, MEAppearancePathRoot,
MEAppearancePathNode, AbsOccurrence, AbsOccData, Fnd0OARRule,
Fnd0OARFunction, Fnd0AdminLOVValue, Fnd0LogicalBlock, Fnd0LogicConn, icm0
Mdl0DefaultGeometry, Mdl0ElementThread, Mdl0AttachAttrGroup,
Appmodel
Mdl0AttributeGroup, Mdl0ManagedAttrGroup
Cpd0CollaborativeDesign, Cpd0DesignElement, Cpd0ShapeDesign,
Cpd
Cpd0ShapeDesignRevision, Cpd0DesignItemInstance
Ptn0Partition, Ptn0PartitionItem, Ptn0PartitionItemRevision, Ptn0SchemeFunctional,
Partition Ptn0Membership, Ptn0ChildParentLink, Ptn0PartitionTemplateModel(Tc12.2)
Mdc0PortArtifact, Mdc0OrderedElementGroup, Mdc0ConnectionElement,
Mdc0mdconnectivity
Mdc0ConditionalElementGroup
Pdm0ExternalType, Pdm0ExternalModel, Pdm0RelatedModel, Pdm0ImportRecord
Pdm0plantdatamgmt
Cfg0ProductItem, Cfg0FamilyGroup, Cfg0FeatureFamily, Cfg0Feature
Cfg0configurator (TC12.2)
SSP0ServicePlan, SSP0ServiceReq, SSP0WorkCard, SSP0ServicePartition
ServicePlanning (Tc13.2)
Unrestricted
