Skip to main content

Export to CSV

Use this method to export segments to a CSV file (as a ZIP archive). You can export projects, jobs, resources and even multiple resources and apply a wide range of filters.

URL

(POST) /api/resources/segments/io/csv

PARAMETERS

The message body contains a JSON object.


Generic export properties:


scope

The scope object tells the system what data to export. Examples:

Export a project memory, translation memory or term base by specifying its resource ID:

CODE
{ "type": "DocumentSet", "dsid": 157 }

Export a project memory by specifying its project ID:

CODE
{ "type": "Project", "projectid": 7726 }

See all available scopes here.


Mandatory

object

locales

The list of all locales that you want to export.

CODE
"locales": [ "de-DE", "de-AT", "fr-FR" ]
Mandatory, string[]
query

An optional filter to apply to the exported data. Sample use cases are:

  • Exclude any translations in red status
  • Export translations with certain custom fields only
  • etc.

The query properties and features are described here. Example of exporting texts in neutral (0) or green (1) status thus excluding red status (2):

CODE
"query": {
    "languages": [
       { "loc": ["en", "de", "fr"], "status": { 0, 1 } }
    ]
}

IMPORTANT:

The query has 2 functions: On the one hand it filters the segments and on the other hand it removes any translations that do not match the filter.

In the example above, the query first identifies segments where at least one of the 3 languages is not in red status. In a second step, the system removes any languages that are in red status.


Optional,

object

src

The source locale. It is highly recommended to set this value if you know it. Otherwise, the system chooses the first entry in locales.

Optional, string

minimumTexts

Optional number of languages a segment must have at a minimum to be exported. By default this is 1.

  • 1: Includes monolingual (untranslated) segments
  • 2: The segment must have at least 2 language versions
  • ...


Optional, int
skipTargetIsSource

Optional, default is false. If true then translations are removed from the export if the text is identical to the source text.


Optional, bool
excludeCommentTypes

Optional. List of numeric comments categories. If set then only comments of these categories are included in the export.

Categories are sequentially numbered and start at 0.

Optional, int[]

markupRemoveOptional, default is false. If true then markup is removed from texts. See also property below.Optional, bool
markupReplaceChar

Optional, default is null. When you set markupRemove to true then any markup will be replaced by this character.

Note: You must specify a single character such as: "markupReplaceChar": " "

Optional, char
localesMappings

Optional dictionary to transform or modify language codes prior to saving to file. The following example, transforms fully qualified locales from the resource into simpler ones:

CODE
"localesMappings": {
    "de-DE": "de",
    "fr-FR": "fr"
}


Locales not in the dictionary are left unchanged. If you map multiple original locales to the same output locale, the system will retain only one of the "clashing" languages.


Optional, object


CSV specific options


htmlEncode

Optional, default is false. If true then content is HTML encoded.

When to use true and when to use false?

Any markup will be output like in this example

  • "Hello <b>world</b>".

This is all fine unless the text contains < or > characters as well. Look at this example:

  • "Hello I <b>think</b> that 2 < 3"

By setting "htmlEncode" to true you will get instead:

  • "Hello I <b>think</b> that 2 &lt; 3"

Using "true" simply means that you can clearly distinguish between markup and the use of < > & as part of the actual text.


Optional, bool

RESULTS

This API method is an "asynchronous" operation. It either immediately returns the result or instead an operation ID which you need to periodically poll until the operation has finished.

Upon the first call you typically get an "operationid". Use this to further poll the operation status. See full explanation here: Asynchronous operation

When the operation is finished you get the reference to the file:

CODE
{
    "trm": {
        "status": "Finished"
		...
    },
    "custom": {
        "fileref": "52e77705f6904233b0c33b2e5d7c4a80",
        "filename": "export.zip",
        "segments": 10
    }
}


Once the operation is finished, download the file with fileref and this API method:

CODE
(GET) /api/media/get/{fileref}


EXAMPLES

Export a translation memory with ID 112334 and with all default parameters:

CODE
(POST) /api/resources/segments/io/csv


BODY:
{
	"scope": { "type": "DocumentSet", "dsid": 112334 },
	"locales": [ "en", "fr" ]
}






JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.