Data Exchange with MS Excel

 

Exporting Data (RC-WinTrans to Excel Spreadsheet)

The MS Excel Import/Export Add-On can export a set of data value types to an Excel spreadsheet.
Each data value type has its own column in the spreadsheet.

One or more target languages can be exported from a translation project.

NOTE: The item's ID/name and the source file name should be included so that translations from the Excel spreadsheet can be imported back into the translation project.  Including this information allows an item to be accurately identified and translated by the import function.

Exportable data value types:

Value Type

Description

Source Language

The source language text.  This is usually the original source text but can also be the text of a target language used as the source text.

Target Language

The target language text of one or more target languages.

Note

The "Note" text. Exported to a column one, for each exported target language.

Translation Status

The item's translation status at the time of export.  Exported to a column, one for each exported target language.

Resname

The item identifier (ID).  Also called the "resname."

Main Resname

"ID chain"- IDs from the main resource ID down to the item's ID. IDs are joined by a number sign (#).  Use this type to identify an item within the source file with the greatest accuracy.

Restype

The item resource type.

Source File

The name and the path of the source file.

 

 

Importing Data (Excel Spreadsheet to RC-WinTrans Translation Project)

The import function is designed to import data from an Excel spreadsheet as exported by the Excel Import/Export Add-On, i.e., containing the seven data value type columns described in the previous section ("Exporting Data.)"

The input can ignore the data "item ID/name," "source file name" and "resource type" data in the respective Excel spreadsheet columns.  In other words the import can be performed taking only the "source language" and "target language" columns into account.

 

Figure: Options for matching data in the Import from Excel File dialog.

 

Data Identification.

The "item ID/name," "source file name" and "resource type" data is used to identify an item and to match an item in the Excel file to an item in the RC-WinTrans translation project.  If none of these three value types are used for the import then an item will be assigned by comparing the source texts alone.

TIP:  When using the same translation project and Excel spreadsheet to import and export data using the "item ID/name," "source file name" and "resource type" value types is recommended to ensure that items can be assigned correctly.  In other cases it may be necessary to skip the comparison of this data.