Working with Translation CSV files for Multiple Languages

   MaestroPreviously known as Transact Maestro.  |   Form Builder |  v18.05 This feature was introduced in v18.05.

Translation can be applied to Maestro forms in many ways. Maestro allows you to not only edit single CSV translation files but to also export the CSV file that contains all languages that are configured for a form, and editing or adding multiple languages at the same time. 

To export, edit and upload the CSV file with all configured languages, follow the steps below:

  1. Open a form with multiple languages configured.
  2. Select Translation.
  3. Click New Language if you want to add new languages to the CSV file. If you do not want to add any new languages, skip to Step 6.
  4. Enter a Label and Code for the new language, for example, Hindi (Label) and hi (Code).
  5. Click OK.
  6. Click Export from the Combined Language Section of the window.
  7. Open the CSV file in any CSV file editor tool (e.g. MS Excel)
    The screenshot below displays an example translation CSV file with the German language highlighted. Each column contains a different language. A blank column will be created for the newly created language.  
  8. Edit the CSV file to contain the translations for the newly created language or edit any of the languages that have already been configured.
  9. Note

    Maestro currently does not support multiple sheets on a single spreadsheet so when you edit the CSV file, it is recommended that you DO NOT create/use multiple sheets in a single CSV file.

  10. Save the CSV file. The name of the file is not important but the file type (CSV) is.
  11. Note

    If your translation uses non-ASCII characters, you need to "Save as" a UTF-8 CSV File.

    Note

    ASCII characters include the digits 0 to 9, lowercase letter a to z, uppercase letters A to Z, and punctuation symbols (e.g. %,$,*,&). More information on ASCII can be found at https://www.computerhope.com/jargon/a/ascii.htm

  12. Click Import from the Combined Language File option.
  13. Select the edited CSV file from your computer.
  14. Save your form. Once you save and build the form, the changes you made to the translation CSV file will be reflected in the form.