Novi Survey supports the export and import of translation for multi-lingual surveys.

The translation import-export tool is available under tool Translate Text in the ribbon menu for the survey list.

Export translation

This function will create an excel spreadsheet with the following content

• Header line with a survey id. The header line is of the form ## Survey=xyz ##. The header line is used to relate the file to the proper survey when it is imported. The header line should not be modified.
• A data table with several columns
• The first column in the data table contains the text for the base/default language for the survey. The default language is specified in the survey setup screen for the survey. The name of the column for the base language is ## language-code ##. The next column contains the text, if any, for the language for which the messages should be translated. The next column, titled ## ITEM TYPE ## is used to process the file when it is imported and should not be changed. The next column, titled ## NEED TRANSLATION ## indicates whether a translation is available in the selected language for the message in the base language. All other columns in the file can be ignored when using the export function.
• All special content, HTML markup, and HTML codes in the translation is shown as red text. In general, this text should be unmodified to ensure proper import and formatting of the translation. HTML markup and HTML codes may be modified in the translation if necessary.

Import translation

In the file generated by the export, translated messages should be entered by the translator in the appropriate (i.e., 2nd) column.

Note that the translator should not change any of the text for the base language, which is found in the first column of the data table generated by the export (see above).

In the data table, the translator may enter comments in  column ## TRANSLATOR COMMENT ##. These comments are for the use by the translator and the survey owner. Comments are not stored in the system or used by the import process.

Only the cells in the column for the translation and the translator comments should be filled-in by the translator.

Upon selection of the file with the translation, Novi Survey will process the file. The survey id in the header of the file will be matched to the current contextual survey. If the survey id in the file does not match the contextual survey or if the file format is not recognized or the file data is corrupted, an error message is shown. If there are errors detected in the file imported, a new file will be provided that contains details regarding the error encountered. The errors will be listed in the data table under columns:

• ## OBSOLETE ## : the message specified in the base language is no longer used in the survey
• ## TRANSLATION REJECTED ## : the translation for the message was rejected
• ## REJECTION REASON ## : provides details why the translation for a message was rejected

If the file can be processed successfully, the language for the translation is shown and a button 'Import translation' is available. Pressing the button will import and save the translation for the survey. This operation cannot be undone.