Data Import Procedure

Procedure for Data Import can be different depending on Data Export approach.

The procedure described here shows the case of a complete preparation when the to-be translated data is kept to a minimum.

• Place the Data Translation file (from the translation office) into the corresponding project folder.
• Open the Data Export file used for backup.
• Open the Data Translation file (from the translation office).
• Copy content from the Data Translation file into the Data Export file.
• Insert a new Column (1) into the Data Export file (for example after the "Translation" column).
• Using the VLOOKUP function search the Data Translation content based on the German data. As a result, get the valid translation or “NA” in case when translation is not available.
• Copy the valid translation data as a result of VLOOKUP search.
• Optional: because both original translation and Data Translation are available it is possible to compare them and choose the one which is more suitable.
• Add one more column (2) into the file sheet.
• Fill-in the column (2) with data from the column (1), in case if it blank use the original translation.
• Filter the new column (2) for empty values and verify the source texts (in language DE). Insofar as these are merely technical terms, e.g. "& 1", "RESB", etc. is all okay. If, however, there are still real terms, they may still have to be revised and translation to be entered into the new column (2).
• Copy source texts (technical in language DE) into the still empty fields.
• Remove filter from column (2); Mark the complete values ​​from the new column (2) and copy them into the original column "Translation" as a text.
• Delete the two additional columns (1) and (2).
• Filter the column for the exceeded length (directly after the column with the actual lengths) using the value "X". The exceeded length translations to be reviewed manually again and retranslated (considering the length).
• Remove the filter.
• Change date in the first column to the current date - Format YYYYMMD.
• Save the file for backup.
• Import the file with the ST Import tool. Please note that only the language (s) should be used for which the translation was made. Depending on the size of the data file, the import may take several minutes.
• Create Transport Request using the SAP standard tool. Limit the data using the date (from the data file).
• Carry out release and transport into the Quality system using the STMS transaction.
• If test has been successful, the Transport Request can be transported into the Production system.

Fiori translations import:

• select the appropriate languages according to the languages provided in the excel file
• in the file area please provide the path to the excel file
• please close all the instances of the excel running in the background
• press execute (F8)
• for a couple of seconds an excel file will open, please do not close it
• a display log will appear with the information about how many fiori entries were inserted or modified in the /DBME/TMA_TRNSL table
• confirm the display log
• a table will appear where you can inspect the translations which have been imported, from here you can choose which files would you like to save into fiori files
• select and press save
• a small window will appear which will ask for the path for the fiori files to save, depending on how many languages there were in the excel file there will be 2 or 3 files to save