Creating a Language-Specific .csv File of Translation Objects

Prerequisites

See the list of prerequisites in Creating a csv File for a Local List.

Context

This documentation explains how to create a .csv file using Microsoft Excel 2010. Object names that start with leading zeros can cause problems, because Microsoft Excel 2010 deletes them automatically when you save.

For example, if you enter NA 00002 (for message long text object 00002) in the .csv file, Microsoft Excel 2010 deletes the leading zeros automatically so that object name 00002 changes to 2. As a result, the local list that you create in LXE_MASTER does not allow you to call up translation object NA 00002 for translation.

To prevent this problem from occurring, take all necessary steps in Microsoft Excel 2010 to ensure that leading zeros are not deleted automatically when you save the .csv file.

If you want to create a local list that can only be translated into specified target languages, create a language-specific .csv file on the basis of <target language> + <object type> + <object name> as follows:

Procedure

Open Microsoft Excel 2010.
In cell 1A, enter the target language of the first object to be included in the local list.
For example: enUS
In cell 1B, enter the object type ID of the first object to be included in the local list.
For example: DTEL
In cell 1C, enter the technical name of the first object to be included in the local list.
For example: SPRAS

Note that this entry in row 1 (enUS DTEL SPRAS ) will allow DTEL SPRAS to be translated into enUS, but not into any other language, via the local list that is subsequently created.
In cell 2A, enter the target language of the second object to be included in the local list.
For example: frFR
In cell 2B, enter the object type ID of the second object to be included in the local list.
For example: MESS
In cell 2C, enter the technical name of the second object to be included in the local list.
For example:
```
BC                    001
```
Note that this entry in row 2
```
frFR MESS BC                    001
```
allows
```
frFR MESS BC                    001
```
to be translated into frFR, but not into any other language, via the local list that is subsequently created.
After you have finished entering all of the required objects in the file, choose Save.
The Save As dialog box appears.
Use the input help for the Save as type: field to select CSV (Comma delimited) (*.csv).
Maintain the file name, specify where you want to save the file, and choose Save Okay Yes .

Results

You have created a csv file with which you can create a local list in transaction LXE_MASTER. The translation objects in the local list can only be translated into the target languages specified in the .csv file.