Import a Usage BOM with variants and attribute groups

You can import a Usage BOM with variants and attribute groups from a CSV file into Teamcenter, using the csv2tcxml utility. Refer to the foundation_ReadMe.txt in the TC_DATA\csv2tcxml\tdata\Integration\foundation\ directory for sample files and import commands.

Prerequisites

• Ensure that you have set up the csv2tcxml utility as described in Teamcenter Data Exchange.
• In addition, ensure that the variability data is available in the Teamcenter database.

Procedure

1. In the rich client, set the default value of the opt_tcxml_import_post_action option as true in the SiteConsolidationImportDefault transfer option set.
2. Add the attribute fnd0VariantFormula to the business object PSOccurrence by:
   • Using local_override.xml. For more information on how to use this file, refer to the Extend the framework section in the csv2tcxml_user_guide.pdf and foundation_ReadMe.txt files.
   • Adding an attribute by using BMIDE.
3. Create and import a Usage BOM with variants and attribute groups. You can refer to the following files for a sample template to create your data:
   • TC_DATA\csv2tcxml\tdata\Integration\foundation\AttriGroupItemDemo.csv
   • TC_DATA\csv2tcxml\tdata\Integration\foundation\AttriGroupStructureDemo.csv
4. Once the data is ready for the import, you can convert and import it. Refer to the file csv2tcxml_quick_start.pdf located in the TC_DATA\csv2tcxml directory for conversion and import commands.

Note: When importing Reference Designator values (PSOccurrence.fnd0RefDesignators) using the csv2xml utility for a BOM structure, you must format the Variable Length Array (VLA) entries accurately. The individual Reference Designator values within a single VLA entry are separated by a comma (,). Furthermore, each VLA entry (except for the very last one in a sequence) must also be separated with a comma (,). To avoid conflicts with this internal separator, the csv2xml configuration parameter GMS_tcxml_string_separator must not be set to a comma (,). You can use an alternate character (for example, a tilde (~) or a pipe (|)) for this parameter.

If the total length of the Reference Designator values exceeds the 4000 character limit, these values must be entered into multiple VLA entries, with each section separated by the configured GMS_tcxml_string_separator. The BOMRefDesignatorPackSeparator preference configures how the Reference Designators are displayed in Teamcenter, not their internal storage.