l10n_import_export

Exports property values of objects from the database to an XML file for translation purposes. It is also used to import the translated property values from the XML file to the database. Syntax l10n_import_export [-u=user-id {-p=password | -pf=password-file} -g=group] [-mode= export | import] -classificationObjectId=class-ID -transferMode=transfer-mode -type=type-name -properties=list-of-property-names -file=file-name -noTransExist -locale=locale-name -master -status=localization-status [-startDate="DD-MMM-YYYY HH:MM"-endDate="DD-MMM-YYYY HH:MM"] [-savedQueryName=saved-query-name -entryCount=entry-count -entryNames= entry-names -entryValues=entry-values] [-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. -mode Specifies whether the user is performing an import or export operation. It takes one of the two values, -import or -export. -transfermode Specifies the name of the transfer mode used to export the objects. This transfer mode specifies the traversal rules, filter rules, and property sets to be used for export. It determines what is exported from the system. If not specified, a default transfer mode is used (TIEUnconfiguredExportDefault). -type Specifies the type for which the instances have to be exported from the database: bldb0 (view), icm0 (classification type), smlb0 (class),stxt (key LOV type), unct_dict (dictionary attribute). -properties Specifies the list of properties (separated by a comma) for which the values must be exported from the database. -file Specifies the file name. It acts as an output XML file while exporting objects from the database and acts as an input XML file while importing objects to the database. -noTransExist Specifies that no translations exist. This option should only be used with the -mode=export option. This option should be used along with the -locale option to export objects for a given type that do not have translations for the specified locale. -locale Specifies the locale. When this option is used with the -mode=export and -noTransExist options, it exports all objects for a given type that have no translations for the specified locale. When this option is used with the -mode=export and -master options, it exports all objects for a given type that have the specified locale as the master locale. -master Exports master values to XML file. This option should only be used with the -mode=export option. -status Specifies the status of the localization. This option is used with the -mode=export option to specify the localization status of the property values that must be exported to the XML file for translations. This option is used with the -mode=import option to specify the localization status that needs to be set on the property values that are being imported to the database. This option takes one of the following localization statuses: A (approved), P (pending), R (in review), I (invalid), or M (master). -startDate Specifies the start date in the date range using format DD-MMM-YYYY HH:MM, for example, 28-OCT-2010 12:01. -endDate Specifies the end date in the date range using format DD-MMM-YYYY HH:MM, for example, 28-OCT-2010 12:01. -savedQueryName Specifies the saved query name that already exists in the database. This option can be used with the -mode=export option to export the specified list of localizable properties on objects returned by the saved query. -entryCount Specifies the entry count of an input to the saved query. -entryNames Specifies the list of entry names separated by commas. -entryValues Specifies the list of entry values separated by commas. -classificationObjectId Specifies the ID of the classification object that needs to be exported. -h Displays help for this utility. Environment As specified in Setting up a Teamcenter command-line environment. Files As specified in Log files produced by Teamcenter. Restrictions None. Examples To search for Item objects that have translations so that translations can be done for a new language (for example, Japanese): Copy l10n_import_export -mode=export -type=Item -locale=ja_JP -noTransExist -file=abc To find all Item objects that were created in the month of January 2010: Copy l10n_import_export -mode=export -type=Item -file=abc -startDate=01-JAN-2010 12:01 -endDate=31-JAN-2010 12:01 To import the objects in the Japanese localized file to the database and set the status to pending (P): Copy l10n_import_export -mode=import -file=xyz_ja_JP.xml -status=P To localize the object_name property and description for new items, first create a saved query in the rich client to search for the new items (for example, findNewItems) and then export the items using the saved query as an option: Copy l10n_import_export -mode=export -savedQueryName=findNewItems -type=Item -properties=object_name,description -file=abc To export Item objects where the master locale of the object_name property is Japanese: Copy l10n_import_export -mode=export -type=Item -properties=object_name -locale=jp_JP -master -file=abc Only one XML file (for the Japanese locale) is created as output - abc_jp_JP.xml. All item instances that have the master locale as Japanese for the object_name property are included in this file. To export Item objects where the localization status of the object_name property is pending (P): Copy l10n_import_export -mode=export -status=P -type=Item -properties=object_name -file=abc Only one XML file (for the Japanese locale) is created as output (abc_jp_JP.xml). All the item instances that have the master locale as Japanese for the object_name property are included in this file. Related Topics Teamcenter Localization