Working with the language pack

You must specify the column in the conversion maps, if you are working with the language pack and you are required to translate the column of a table. For example, in mssql_ConversionMaps.xml, if the COUNTRY_NAME column in the ADDRESS table is required to be translated, you must specify key_translation_cols=”10” as:



<conversion type="sql" name="ADDRESS" key_translation_cols="10" doc_type="CM">

<target_table_name>ADDRESS</target_table_name>

<insert_sql>

 SELECT
 T0.ADDRESS_ID,
 T0.USER_ID,
 T0.ADDRESS_NAME,
 T0.ADDR_LINE_1,
 T0.ADDR_LINE2,
 T0.CITY_NAME,
 T1.STATE_NAME,
 T1.STATE_ABBREV,
 T0.ZIP_CODE,
 T2.COUNTRY_NAME,
 T2.COUNTRY_CODE_ISO,
 CURRENT_TIMESTAMP
 FROM ALCO_ADDRESS T0
 LEFT OUTER JOIN ALCO_STATE T1
 ON T0.STATE_ID = T1.STATE_ID
 LEFT OUTER JOIN ALCO_COUNTRY T2
 ON T0.COUNTRY_ID = T2.COUNTRY_ID
 WHERE T0.CHANGE_TIMESTAMP BETWEEN ##START_DATE## AND ##END_DATE##
 </insert_sql>
 </conversion>

If more than one column is required to be translated, you can separate the numbers with a comma.