Cells containing only numerals and functions are skipped as it is assumed they do not contain data relevant to the import.
In-context preview can only be generated for a maximum of 200 columns in an imported file. Files with more than 200 columns will display the warning . This limit does not apply to the columns that are marked Hidden in the original file.
File Types
.XLS
.XLSX
.XLT
.XLTX
.XLSM
.XLTM
OpenOffice or LibreOffice documents (.ODT, .ODS, or .ODP) are supported, but saving them in MS Office format before importing to Memsource is recommended.
Google Docs, Sheets, and Slides are automatically converted to .DOCX, .XLSX, or .PPTX, when imported via the Google Drive connector.
Import Options
-
By default, hidden content is not imported.
-
Extract special values/names/attributes of the file which are not usually translatable.
-
In cases where file contains HTML tags (
<b>
,<span>
, etc.)Disables options other than
HTML Import Settings cannot be used to edit the default settings.
Cell flow "Rows, left to right" is applied
-
Apply regular expressions to convert specified text to tags.
Disables options other than
. -
Enter a comma separated list of columns, e.g. A,C,Q
Multilingual files are imported as multiple bilingual jobs with languages mapped before import. They are represented with in the Jobs Table. If imported into several target languages, the Completed file is composed of all target languages.
Hidden sheets are not processed.
Dates and formulas where the displayed cell contents depend on the locale or the underlying values are not exposed for translation but automatically copied to the target columns.
Files are converted to XML on import. Most formatting, graphs and images are lost. Files with conditional formatting rules are not imported.
Some files cannot be converted to multilingual files due to software packages or versions of those packages.
When creating a job, select from the pane before applying Import Options. If not specified, the file will be imported as standard XLSX.
Import Options
Caution
Separators other than commas are not supported and will trigger errors.
-
Imports HTML tags contained within the file. Tags can then be used with
. Paragraph tags<p>
create new segments even if is not selected. When using the HTML subfilter, other options are disabled. -
Text is segmented by a general segmentation rule rather than one segment per cell.
Caution
Applying
to a file that contains target text may result in a different number of segments in the source than in the target. -
Use lowercase or capital letters. For more columns, enter letters separated by commas with no spaces (A,D,G).
-
There is one column for each target language. For more columns, enter letters separated by commas with no spaces (B,E,H).
-
Enter rows to be imported (1,4,7).
-
Specify a context key that is saved with the segment to the Translation Memory and used for match context.
-
Columns are set as context notes (B,C). Notes will be displayed on separate lines.
-
Sets the maximum length of the translation. For more columns, enter letters separated by commas with no spaces (I,J,K).
-
Apply regular expressions to convert specified text to tags.
Comments
Article is closed for comments.