Translate Exported Data Model Objects or Classic UI Messages - EnterWorks - EnterWorks Process Exchange (EPX) - Precisely EnterWorks - 10.5

To translate an exported data model object or Messages, you will load their exported .csv file into Excel. Do not simply select the .csv file and open it in Excel because Excel may format the data in ways you do not want it to.

To translate a data model object:

5. Open a new Excel file.

6. Select the Data tab.

7. In the Get External Data section of the data tab, select From Text/CSV.

8. In the file explorer that appears select the exported file(s) and click the Import button.

9. The Text Import Wizard will appear. Configure the settings:

• File Origin: select Unicode (UTF-8).

• Delimiter: select Comma.

10. Excel may have inserted a header row into the data that has column names like Column1, Column 2, and Column3. If it did not insert a header row, click Load to load the data.

If Excel has inserted a header row, remove it:

1. Click Transform Data. The Transformation window will appear.

2. Open the Use First Row as Headers dropdown and select Use First Row as Headers. The header row will now be the first row of your imported data.

3. Click Close and Load. The data will be loaded into the worksheet in table format.

4. If you do not want the data in table format, you can convert it. Select the table, then on the Table Design tab, select Convert to Range.

11. The first column or columns in the .csv file are used by EnterWorks to define the data model element. Do not edit these columns. The only columns you should edit are the columns labeled with a language name. The first language column is the default language’s column, which is English. Subsequent columns will be for the other languages that were included in the export.

    Replace the values in the language columns as desired.

12. Save the file. If Excel allows you to save the file in CSV UTF-8 format, you can save yourself a step by saving the file in CSV UTF-8 format. Otherwise save the file in Unicode Text format.

13. Open the file in Notepad++ and edit convert it so it can be uploaded to EnterWorks:

    1. Open the Encoding dropdown list on the ribbon and select Convert to UTF-8. This converts the file into UTF-8 (without BOM) format. You must do this even if when you saved the file from Excel you saved it as CSV UTF-8 format because Excel saves it as UTF-8 BOM format.

    2. If the file was a Unicode Text file (instead of CSV UTF-8), you must convert the tab delimiters to commas:

       1. Select all the text and click Ctrl-F.

       2. Select the Replace tab.

       3. In the search mode section, select the Extended radio button.

       4. In Find what enter: \t

       5. In Replace with section enter a comma only: ,

       6. Click Replace All.

    3. When Messages are exported, blank lines are converted to double commas. If this is a Messages file, you must replace those double commas with a non-empty value string.

       1. Select all the text and click Ctrl-F.

       2. Select the Replace tab.

       3. In Find what enter two commas only, with no space between them: ,,

       4. In Replace with section enter straight-double-quote straight-double-quote comma comma with no spaces between them: "",,

       5. Click Replace All.

    4. Save the file with a .csv extension. If this is a Messages file, make sure the text “Messages” without the quotes is in the file name.