• admin

Bulk Loader Utility for Migration





  • Bulk Loader is a migration utility to upload new or update existing data into Teamcenter.

  • Bulk Loader utilities uses TC XML files in low-level format to load the data into Teamcenter.

  • It also bypasses the business logic rules providing performance enhancement when loading data into Teamcenter.

  • As Bulk loader uses TC XML files (low level code), it is much faster compared to IPS data upload utility which uses ITK.

Prerequisite:


  • Open a Teamcenter command and change directory (CD) to TC_DATA\csv2tcxml_perl directory.

  • Run following command to generate 4 files

tcperl csv2tcxml.perl install <password>

Generated files

- csv2tcxml_all_attrs.txt

- csv2tcxml_required_attrs.txt

- csv2tcxml_datamodel.txt

- csv2tcxml_column_names.txt.

  • The above script should be executed whenever the datamodel is updated to keep the configuration files and datamodel in sync.

  • Open TC_DATA\csv2tcxml_perl\cvs2tcmxl_config.txt file and add appropriate values for the following variables.

source_site = site-id

Defines the site ID of the exporting site. This site must be defined in Teamcenter prior to importing the migrated objects.

Volume = volume-name

Defines the name of the volume where Teamcenter stores the files related to imported datasets.

Sdpath = Directory Path

Defines the operating system directory containing the volume where Teamcenter stores the files related to imported datasets. Provide the name only, do not include the path.

  • csv2tcxml_config.txt file contains descriptions of the most commonly used variables and their default value if they have one.

  • To use the existing variables in the file, uncomment and provide them a default value.

  • TC_DATA\csv2tcxml_perl\csv2tcxml_mapping.txt used to create standalone form and to create the relation between objects.

Note We can override any of the variable values in this file temporarily by adding them into the command line arguments when you type the command.

Use the format:
                argument-name=argument-value.


Steps to do migration using Bulk Upload




  1. Extract data in csv format from source system or middleware table.

  2. Update the configurations cvs2tcxml_config.txt, csv2tcxml_mapping.txt based on the object to be imported.

  3. Convert the csv input files into tcxml file using csv2tcxml.perl script.

  4. Import the data into Teamcenter using the utility tcxml_import.exe.


csv2tcxml_mapping.txt

  • This is used to create standalone form and for creating the relation between objects.

  • Provide the real name of the forms for form creation.

  • Provide the real name of the primary, secondary and relation object in case of secondary object creation with relation.

Supported for:
    Form Creation
    Object Creation + Relation to Primary

cvs2tcxml_config.txt

  1. Provide real name of the item type for item creation.

  2. Provide default group and default user for setting owner in newly created objects.

  3. Provide PUID input file location in case of existing objects in Teamcenter. This is used for creation relation between existing objects.

  4. For setting multifield key.


csv2tcxml.perl

It converts a file formatted from CSV file into a TC XML file that can be imported into a Teamcenter site. csv2tcxml.perl can be used for following options, To generate the datamodel files,

tcperl csv2tcxml.perl install Teamcenter-administrator-password

Split the input files - To split the csv file into multiple files with specified number of record.

tcperl csv2tcxml.perl [split] {file-name} [split-file-integer]

Conversion of csv input into tcxml

tcperl csv2tcxml.perl items.csv
tcperl csv2tcxml.perl relation.csv item=exist (Uses PUID LookUp)

To generate the report, The generated report gives the details about number of records processed and failed, execution time, number of errors and warnings, log file location.

tcperl csv2tcxml.perl [report] {reports input-directory in which log files are exist}

Bulk loader utility (tcxml_import)

  • The tcxml_import utility in bulk loader mode imports legacy data in a TC XML file into Teamcenter.

  • The utility can be run only by a system administrator (Teamcenter user with dba privileges).

  • The objects are imported by providing the -bulk_load argument.

  • In case of any failures during import, a repeat file with failed islands is created in the same location as that of the TC XML input file.


Syntax
tcxml_import [-u=user-id {-p=password | -pf=password-file} -g=group] -file=xml-file-name -bulk_load