Using the Language Pack Management Utility

To aid in the ability to move language packs from one database to the next, Aras has created a Language Pack Management Utility to export and import language values from a database. The Language Pack Management Utility is a command line utility that imports and exports language packs from the Aras Innovator database on a SQL level. The following section explains how to use the utility available in the Language Pack Management Utility folder of the Aras Innovator CD Image or from the Aras Community Projects site at http://www.aras.com/communityProjects/default.aspx.

There are several elements to the Language Pack Management Utility command line tool. First, is the executable file for the Language Pack Management Utility itself, LanguageTool.exe. The details of the various options for running the executable at the command line are as follows:

Usage: LanguageTool.exe [-export/-import] [-config_file:<file path>]

[-folder:<folder path>] [-log_file:<file path>] [-log_level:<log level>

] [-server:<SQL server name>] [-db:<database name>] [-login:<login name>]

[-pwd:<login password>]

Where:

• -export/import: This is the required parameter to indicate if the operation is to export or import a language.
• -config_file: (Optional) The path to the configuration file for current operation, ImportConfig.xml or ExportConfig.xml.
• -folder: (Optional) The path to the data folder. This is the output folder for the export operation or the input folder for the import operation.
• -log_file: (Optional) The path to the log file.
• -log_level: (Optional) The logging level (high, medium, low).
• -server: (Optional) The name of the Microsoft SQL Server instance where the Aras Innovator database is installed.
• -db: (Optional) The name of the Aras Innovator database.
• -login: (Optional) The Aras Innovator login assigned to the Aras Innovator database.
• -password: (Optional) The password for the Aras Innovator login assigned to the Aras Innovator database.

The LanguageTool.exe.config configuration file that is referenced by the Language Pack Management Utility is a straightforward xml file that defines the parameters for the batch load activity.

<?xml version="1.0" encoding="utf-8" ?>

<configuration>

<configSections>

<sectionGroup name="userSettings"

type="System.Configuration.UserSettingsGroup, System,

Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" >

<section name="Aras.Tools.I18N.ExpImpMLData.Properties.Settings"

type="System.Configuration.ClientSettingsSection, System,

Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"

allowExeDefinition="MachineToLocalUser" requirePermission="false"/>

</sectionGroup>

</configSections>

<userSettings>

<Aras.Tools.I18N.ExpImpMLData.Properties.Settings>

<setting name="config_file" serializeAs="String">

<value>C:\German\ImportConfig.xml</value>

</setting>

<setting name="folder" serializeAs="String">

<value>C:\German\data</value>

</setting>

<setting name="log_file" serializeAs="String">

<value>C:\German\log.txt</value>

</setting>

<setting name="log_level" serializeAs="String">

<value>high</value>

</setting>

<setting name="server" serializeAs="String">

<value>localhost</value>

</setting>

<setting name="db" serializeAs="String">

<value>InnovatorSolutions</value>

</setting>

<setting name="login" serializeAs="String">

<value>innovator</value>

</setting>

<setting name="pwd" serializeAs="String">

<value>innovator</value>

</setting>

</Aras.Tools.I18N.ExpImpMLData.Properties.Settings>

</userSettings>

<startup>

<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5.2"/>

</startup>

</configuration>

To help understand how to configure this file, the example above can be broken down line by line:

<setting name="config_file” serializeAs="String">

<value>C:\German\ImportConfig.xml</value>

</setting>

This is the path to the path to a configuration file for current operation, ImportConfig.xml or ExportConfig.xml.

<setting name="folder” serializeAs="String">

<value>C:\German\data</value>

</setting>

The path to the data folder. This is the output folder for the export operation, or the input folder for the import operation.

<setting name="log_file" serializeAs="String">

<value>C:\German\log.txt</value>

</setting>

This is the path to the log file.

<setting name="log_level" serializeAs="String">

<value>high</value>

</setting>

This is the logging level, ‘high’ recommended.

<setting name="server” serializeAs="String">

<value>localhost</value>

</setting>

The name of the Microsoft SQL Server instance where the Aras Innovator database is installed. This value can be found in the Aras Innovator InnovatorServerConfig.xml in DB-Connection tag. (server="localhost”)

<setting name="db” serializeAs="String">

<value> InnovatorSolutions </value>

</setting>

This is the name of the Aras Innovator database in SQL Server. This value can be found in the Aras Innovator InnovatorServerConfig.xml in DB-Connection tag. (database=‘InnovatorSolutions’)

<setting name="login” serializeAs="String">

<value> innovator </value>

</setting>

This is the login assigned to Aras Innovator user of the Aras Innovator database in SQL Server. This value can be found in the Aras Innovator InnovatorServerConfig.xml in DB-Connection tag. (uid=‘innovator’)

<setting name="pwd” serializeAs="String">

<value> innovator </value>

</setting>

This is the name login assigned to the Aras Innovator user of the Aras Innovator database in SQL Server. This value can be found in the Aras Innovator InnovatorServerConfig.xml in DB-Connection tag. (pwd=‘innovator’)

Any of the parameters may be left out as long as the command line equivalent parameter is defined.

In order to export a language pack from the Aras Innovator database, you need to define what languages and ItemTypes to export. The definitions of these settings are found in the ExportConfig.xml.

<export>

<languages list="en, de” />

<itemtype name="Action” />

<itemtype name="Activity Template” />

<itemtype name="Activity Template Task” />

<itemtype name="CommandBarButton” />

<itemtype name="CommandBarDropDown” />

<itemtype name="CommandBarEdit” />

<itemtype name="CommandBarMenu” />

<itemtype name="CommandBarMenuButton” />

<itemtype name="CommandBarMenuCheckbox” />

<itemtype name="CommandBarMenuSeparator” />

<itemtype name="CommandBarSection” />

<itemtype name="CommandBarSeparator” />

<itemtype name="Field” />

<itemtype name="FileSelectorTemplate” />

<itemtype name="Filter Value” />

<itemtype name="Grid Column” />

<itemtype name="History Action” />

<itemtype name="ItemType” >

<properties list="label,label_plural” />

</itemtype>

<itemtype name="Life Cycle State” />

<itemtype name="PM_ProjectGridLayout” />

<itemtype name="Property” >

<properties list="label,default_value” />

</itemtype>

<itemtype name="RelationshipType” />

<itemtype name="Report” />

<itemtype name="SearchMode” />

<itemtype name="SecureMessageViewTemplate” />

<itemtype name="SelfServiceReportHelp” />

<itemtype name="SSVC_Preferences” />

<itemtype name="SSVCPresentationConfiguration” />

<itemtype name="UserMessage” />

<itemtype name="Value” />

<itemtype name="Workflow Map” />

<itemtype name="Workflow Map Path” />

</export>

To help understand how to configure this file, the example above can be broken down line by line:

<languages list="en, de” />

These are the languages by Language Item code property defined in Aras Innovator. The above example shows en (English) and de (German).

<itemtype name="Field” />

Each ItemType defined in this file contains all of its multi-lingual string properties exported from the database.

<properties list=label,label_plural"/>

If you want to select some, but not all multi-lingual string properties, add this tag with the properties to export.

To import a language pack into the Aras Innovator database, you first need to define the Language Item in the database, refer to section Defining a Language. Next, you need to setup the ImportConfig.xml.

<import>

<itemtype name="Action” />

<itemtype name="Activity Template” />

<itemtype name="Activity Template Task” />

<itemtype name="CommandBarButton” />

<itemtype name="CommandBarDropDown” />

<itemtype name="CommandBarEdit” />

<itemtype name="CommandBarMenu” />

<itemtype name="CommandBarMenuButton” />

<itemtype name="CommandBarMenuCheckbox” />

<itemtype name="CommandBarMenuSeparator” />

<itemtype name="CommandBarSection” />

<itemtype name="CommandBarSeparator” />

<itemtype name="Field” />

<itemtype name="FileSelectorTemplate” />

<itemtype name="Filter Value” />

<itemtype name="Grid Column” />

<itemtype name="History Action” />

<itemtype name="ItemType” >

<properties list="label,label_plural” />

</itemtype>

<itemtype name="Life Cycle State” />

<itemtype name="PM_ProjectGridLayout” />

<itemtype name="Property” >

<properties list="label,default_value” />

</itemtype>

<itemtype name="RelationshipType” />

<itemtype name="Report” />

<itemtype name="SearchMode” />

<itemtype name="SecureMessageViewTemplate” />

<itemtype name="SelfServiceReportHelp” />

<itemtype name="SSVC_Preferences” />

<itemtype name="SSVCPresentationConfiguration” />

<itemtype name="UserMessage” />

<itemtype name="Value” />

<itemtype name="Workflow Map” />

<itemtype name="Workflow Map Path” />

</import>

Each ItemType defined in this file should have a corresponding XML file containing the language values in the data folder.