Import from Text File

 

The Import from Text File command is used to import the text data of the source and target texts from

ANSI- or Unicode- (UTF-16-LE) encoded text files (file extension: .txt) into an RC-WinTrans translation project.  Access this command via the Import toolbar button (shown right) or from
the File menu.

 

See also:  "Import/Export (Overview)."

 

 

Data Format Requirements

The form of the text data must be such that one line contains the source text (first) and the target text (second) where both are separated by a separator character.  The source and target texts should not be in quotation marks.  If the texts are surrounded by question marks and contain quotation marks themselves, the quotation marks need to be doubled.

 

Example

Two lines with an English source text and a German target text.  A semicolon is used as a separator character:

"&File";"Datei"

"File ""1""";"Datei ""1"""

 

The first line of the text file must declare the used languages in the same format as above, as in:

"en-us";"de"

 

 

Figure 1:  The Import from Excel page in the Extended View bar.

 

 

Import from Text File Page

The Import from Text File page (called up after the Import from Text File command has been selected) displays the name of the project and the number of items selected for the import (see note below). The name of the import file must be specified here.  The Import button activates the Import Assistant to guide users through the process of selecting the target language(s) and setting the import options.

 

NOTE:  The items to be exported must be selected in the Text Table view before executing the Import command.  Select all the items in the Text Table view (CTRL+A key combination) if you want to import data for all items.

 

The Import from Excel page contains the following elements:

Project name Display

The name of the current project.

File name Field

The name of the file from which to import the selected data.  This can be the name of an existing text file or of a new one, but a file name must be specified.  You can browse for a specific file using the Select file button.

NOTE:  The last selected file will automatically be entered in the field when the Import from Text File page is called up.

Select file Button

Opens a dialog box where you can browse for a specific Excel spreadsheet to use for the import.

Import Button

Opens the Import Assistant to customize the import operation.

View file Button

Opens the specified import file with the Windows "Notepad" application.

 

 

Import Assistant

The Import Assistant lets you adjust the import options to suit your particular requirements.  Select the desired options and press the OK button to proceed with the import.  The Import Assistant also shows a preview of the import file in which the "Source" and "Target" columns can be assigned (if they are not already).

 

 

Figure 2:  The Import Assistant for importing data from a text file.

 

 

The Import Assistant consists of the following elements:

 

Import Options Groupbox

Import non-translated items only Checkbox

Select this option to import data for non-translated items only.  This option is useful if you've selected many items in the Text Table view and don't want to filter the items.

Import hotkeys Checkbox

Select this option to import hotkeys that are listed in a separate column in the import text file. If this option is not selected, the hotkeys will be ignored and the target texts will be imported without the hotkeys.

 


 

Match Groupbox

Main resource name Checkbox

If selected, translations will only be imported from the text file when the items' source text and main resource name are the same.  The main resource name column must be set if this option is checked.

Resource name Checkbox

If selected, translations will only be imported from the text file when the items' source text and resource name are the same.  The resource name column must be set if this option is checked.

Resource type Checkbox

If selected, translations will only be imported from the text file when the items' source text and resource type are the same.  The resource type column must be set if this option is checked.

Source file name Checkbox

If selected, translations will only be imported from the text file when items have the same source text and source file name.  The source file name column must be set if this option is checked.

 


 

Separator Groupbox

Use the radio buttons to set a tab character, comma, or semicolon as the designated separator between source and target text items.

 


 

Skip first rows Field

The number entered here specifies how many of the (first/top) rows of the text file are not relevant for the import and will not be shown in the preview.  The number can be edited directly in the field or increased/decreased by clicking on the up/down arrow buttons.

 


 

Preview Area

The preview provides an overview of the text file being used for the import.

 

aSSIgNing Columns:  The Import Assistant tries to identify the headers in the text file.  If this identification is successful the name of the column is displayed in the preview.  The text "<skip>" is shown in the column header when the column cannot be identified or when it is not relevant for the export. To assign a column, right mouse-click on the header to open a local menu where you can select the correct value (Figure 3).

 

 

Figure 3:  Assign a value to a selected column in the local menu called up with a right mouse-click on the column header in the Import Assistant's Preview area.

 

 

Related topics...

 

 

^ TOP ^