Creating a Cross-Language .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 be translated into any target language, create a cross-language .csv file on the basis of <object type> + <object name> as follows:

Procedure

Open Microsoft Excel 2010.
In cell 1A, enter the object type ID of the first object to be included in the local list.

For example: DTEL
In cell 1B, enter the technical name of the first object to be included in the local list.

For example: SPRAS
In cell 2A, enter the object type ID of the second object to be included in the local list.

For example: MESS
In cell 2B, enter the technical name of the second object to be included in the local list.
For example:
```
BC                    001
```
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 local list can be translated into any target language.