Administering standard text

Importing standard text library structures from a legacy system

If you have a standard text library structure in a system other than Teamcenter, you can re-create this structure in Teamcenter using the tcexcel_import utility. You define the full library structure containing folders and standard text elements in a Microsoft Excel spreadsheet and save it to a tab-delineated file. This file is then used as input for the tcexcel_import utility that creates the structure and attaches documents to the standard text elements. In the spreadsheet, you specify the paths to the documents that are to be attached to the standard text elements. The textual content for each of the standard text elements can come from:

TXT files containing only rich text.
DOCX files containing tables, images, formatting, header and footer content.

After import, a standard text librarian can modify the library structure and an author can modify the documents and save the modifications.

The following is an example of an input file with a simple library structure. The first four columns represent the structure of the standard text library. The last column, the StxFilePath column, contains the path to the document that will be attached to the standard text element.

Header1	Item	Item	Item	StxFilePath
Header2	Mes0MESTXLibrary	Mes0MESTXFolder	Mes0MESTXElement
Header3	Mes0MESTXLibrary	Mes0MESTXFolder	Mes0MESTXElement
Title	Root	Sub1	Sub2	Sub3
	Library
		Safety instructions
			STX1	D:\temp\goggles.docx
			STX2	D:\temp\boots.docx
			STX3	D:\temp\helmet.docx
		Folder2
			STX4	D:\temp\magnet.docx
			STX5	D:\temp\table_example.docx
			STX6	D:\temp\rich_text_example.docx
			STX7	D:\temp\helmet.docx
			STX8	D:\temp\helmet.docx

Note

This example imports only DOCX files, but both DOCX and TXT files are supported.

You can import this structure into Teamcenter by saving the Microsoft Excel spreadsheet as a text file and import that file into Teamcenter using the following tcexcel_import utility call:

tcexcel_import -u=username -p=password -g=dba -i=path-to-txt-file

The resulting structure appears as follows in Teamcenter.

Note that the standard text elements have documents attached. You can modify these documents, save them, and continue to work with them in the customary fashion.

Note

You can only use the tcexcel_import utility to create new library structures. You cannot use it to update structures.