Import from Excel Dialog Box

Import from Excel Dialog Box

The Import from Excel dialog box is used to import translated text data from a Microsoft Excel spreadsheet into the active RC-WinTrans translation project.

The Excel spreadsheet from which data is to be imported must have already been exported from RC-WinTrans once before. The first row of an Excel spreadsheet containing data exported by RC-WinTrans is used for the column headers that identify the data of each column. An import from an Excel spreadsheet without these column headers is not possible with the MS Excel Import/Export Add-On.

Imported translations are used as the translations for items with a matching source text and, optionally, with a matching ID (resource name), source file name, and/or resource type.

Even when the Excel sheet contains more then one target language, only one target language can be imported at a time.

Figure: The Import from Excel File dialog box.

Dialog Box Elements

File name Groupbox

–

File name Field

Displays the name of the Excel spreadsheet from which to import data.

–

Open File Button

Opens the selected Excel spreadsheet with the MS Excel application. Use this command to view the document.

·	Source language and Target language Fields Indicate the active source and target languages for the translation project.

Import for Groupbox

–

Selected item(s)

Check this option to import all items (translation units) currently (multiple-)selected in RC-WinTrans' Text Table view.

–

Selected file

Check this option to import translations for all the items in the file currently active within the translation project. The name of the active file is shown in the field below the option element.

–

Project (all files)

Check this option to import translations for all the items in the active translation project.

Imported Items Groupbox

–	State: "Translated" Check this option to set the "translated" translation status for items that have had a translation imported and assigned.
–	State: "For Review" Check this option to set the "review-translation" translation status for items that have had a translation imported and assigned.
–	State: do not change Check this option to leave the translation status unchanged for items that have had a translation imported and assigned.
–	Set temporary marker (blue dot) Check this option to set a temporary marker (blue dot) for items that have had a translation imported and assigned.
–	Overwrite existing translation Check this option if you want existing translation texts to be overwritten by the import process.

Match Groupbox

–	Item ID / Name Check this option to specify that the item IDs ("Resname" and "Main Resname") must match in order for a translation to be imported.
–	Source file name Check this option to specify that the name of the source file must match in order for a translation to be imported.
–	Resource type Check this option to specify that the resource type must match in order for a translation to be imported.
–	Source text This option is enabled. The source text is always compared to import an items translation.
–	Ignore ampersand (&) Check this option to ignore the ampersand (hot key specifier) when comparing the source text.

^ TOP ^