Import segments to resource

token

The token obtained on connection

A JSON object containing all import parameters.

IMPORTANT: Make sure to URL encode this json content before adding to the URL.

filetoken

A reference to the previously uploaded file to import.

Prior to calling the present method you need to upload your file using this method:

• Uploading a file

It returns the file token.

This object defines the destination resource.

USE CASE 1

Use this approach if you want the system to add content to an existing resource or create a new one if it does not yet exist. Properties are:

• name: Name of the destination resource. If the resource does not yet exist, a new resource with this name will be created.
• type: Type of resource, either "TranslationMemory" or "TerminologyDatabase". If the resource already exists, the type must match the destination!
• importname: Optional name given to this specific import. All imported segments are grouped with this name. If not specified, then the system assigns the current date as the name.

USE CASE 2

If you want to upload a file to resource with specific ID, then a single property is sufficient to do an import:

• id: ID of the destination resource.
• importname: Optional name given to this specific import. All imported segments are grouped with this name. If not specified, then the system assigns the current date as the name.

A JSON object detailing how content is imported. See below.

See example here: Import segments to resource - Examples

type

A code for the file type. Any of:

• TMX - A .tmx file
• TBX - A .tbx file
• CSV - A .csv file
• SpreadSheet - An Excel file .xls, .xlsx
• AlignAssist - An Align Assist file .ftm
• TradosWorkbenchExportFile - A .twbx file

The code is case sensitive.

False (default): Import records even if not translated.

True: Import records only if translated.

bool?, Optional

If true then either skip (set replaceExisting to false) or merge (set replaceExisting to true) records in the file if they already exist in the resource.

The comparison is done in the specified source language.

Default is false.

If true then replace records in the resource from the file if they are identical (in the source language).

If you set this to true you also need to set "skipIdenticals" to true.

Default is false.

Remove any markup in segments in the imported file. Recommended if the markup is too verbose or significantly different from markup typically generated in Wordbee Translator.

Even with markup suppressed, Wordbee permits to leverage content - There are various settings with resources to cope with markup differences.

Default is false.

If markup is removed then this specifies the character to use as a replacement.

If null then markup is simply removed. If a blank " " then markup is replaced by a blank, and so on.

Defaut is null.

If you map fields from the file to segment custom fields, then this option instructs the system to refresh picklist options after the update.

For example, picklist custom fields let you delimit the allowed values to choose from. You can have the list of options be updated from the data contained in the file. Use with care!

Default: false.

If the file contains the result of a text alignment process then set this property to true.

This tells the system that the order in which segments are imported is relevant. The system will then also import the context of each segment (text before and after).

A dictionary that lists all the languages that shall be imported from the file, as well as which languages must exist in the TMX for a record to be imported (and not skipped).

Example:

"locales": {
	"en-US": true,
	"fr-FR": false,
	"es-ES": false
}

The boolean indicates if the language must be present with a file record to be imported. Typically, at minimum, you set the source language to true.

The source language code.

In the above example this probably is "en-US".

The language used to compare imported records with existing resource records. It is in this language that the system looks for identicals.

In most cases this is the same as the source language.

A list of all languages that shall be imported from the file.

Example:

"locales": [
	"en-US",
	"fr-FR",
	"es-ES"
]

The source language code. This language must be part of the locales list.

The language used to compare imported records with existing resource records. It is in this language that the system looks for identicals.

In most cases this is the same as the source language.

The encoding of the file. If not specified the system uses "utf-8".

Optional list of TBX properties that shall be imported as comments. The allowed numeric values are:

• 0 - Notes
• 1 - Descrip: Provides descriptive information about the node
• 2 - Admin: Contains information of an administrative nature for the node in question, such as the source of information, or the project or client for which it applies.
• 3 - Transac: Transactional information.
• 4 - Contains information about a "transaction" (eg: adding of a term, modification etc). Adds XML notes "transactionType", "responsibility", "date"
• 5 - TermNote: A meta data-category used for describing terms

A list of all languages that shall be imported from the file.

Example:

"locales": [
	"en-US",
	"fr-FR",
	"es-ES"
]

The source language code. This language must be part of the locales list.

The file's extension, such as ".xsl", "xslx", ".ods" etc.

Only valid Microsoft Excel or Open Office spreadsheet file extensions are permitted.

Specifies the columns and their content in the spreadsheet.

This property is an array of objects, each having these fields:

• idx: The index of the column in the spreadsheet, starting at 0 (most left column)
• type: The type of column, any of these string values:
  • "Locale": Contains text in a language, see locale field below.
  • "Label": Content is mapped to a segment label in Wordbee. The cell text must match an existing segment label title.
  • "Comments": Content is imported as a comment to the segment.
  • "Custom": Content is mapped to a segment custom field in Wordbee.
• locale: Required if type is "Locale" or "Custom" (if you reference a language specific custom field).
• issrc: Set to true if the locale above is the source language. Required only if type is "Locale".
• cfid: The string identifier (such as CustomStr3) of the custom field. Required only if type is "Custom".

Example:

 "columns": [
    { "idx": 0, "type": "Locale", "locale": "en", "issrc": true },
    { "idx": 1, "type": "Locale", "locale": "fr", "issrc": false },
    { "idx": 2, "type": "Comments", "locale": "fr" },
    { "idx": 3, "type": "Custom", "cfid": "CustomStr2", "locale": "fr" }
  ]

Specifies if content is HTML code. If true then the system interprets the content as HTML and protects any markup.

Example text: "Hello <b>world</b>". If isHtml is true then the system will import <b> and </b> as protected markup. If isHtml is false, the text will be imported as is without change.

Default: false.

The first row containing content. If the spreadsheet has a header row then set this to 1.

Default: 0

Optionally delimit the sheets to import. If not specified then content from all sheets will be imported.

Default: First sheet only.

Sheets are referenced by their sequential index: 0 = first sheet, 1 = second sheet...

If isHtml is set to true then you should set this property to true as well.

If false then all tags are renamed to T1, T2, etc.

Default: false

Recommendation: Set value to true if isHtml is true.

Specifies the columns and their content in the spreadsheet.

This property is an array of objects, each having these fields:

• idx: The index of the column in the spreadsheet, starting at 0 (most left column)
• type: The type of column, any of these string values:
  • "Locale": Contains text in a language, see locale field below.
  • "Label": Content is mapped to a segment label in Wordbee. The cell text must match an existing segment label title.
  • "Comments": Content is imported as a comment to the segment.
  • "Custom": Content is mapped to a segment custom field in Wordbee.
• locale: Required if type is "Locale" or "Custom" (if you reference a language specific custom field).
• issrc: Set to true if the locale above is the source language. Required only if type is "Locale".
• cfid: The string identifier (such as CustomStr3) of the custom field. Required only if type is "Custom".

Example:

 "columns": [
    { "idx": 0, "type": "Locale", "locale": "en", "issrc": true },
    { "idx": 1, "type": "Locale", "locale": "fr", "issrc": false },
    { "idx": 2, "type": "Comments", "locale": "fr" },
    { "idx": 3, "type": "Custom", "cfid": "CustomStr2", "locale": "fr" }
  ]

Specifies if content is HTML code. If true then the system interprets the content as HTML and protects any markup.

Example text: "Hello <b>world</b>". If isHtml is true then the system will import <b> and </b> as protected markup. If isHtml is false, the text will be imported as is without change.

Default: false.

Indicates if the first row in the file contains a header (and is thus not to be imported).

Default: true

The encoding of the file. If not specified the system uses "utf-8".

Default: "utf-8"

The column separator character.

Default: "," (comma)

A dictionary that lists all the languages that shall be imported from the file, as well as which languages must exist in the TWBX file for a record to be imported (and not skipped).

Example:

"locales": {
	"en-US": true,
	"fr-FR": false,
	"es-ES": false
}

The boolean indicates if the language must be present with a file record to be imported. Typically, at minimum, you set the source language to true.

The source language code.

In the above example this probably is "en-US".