Excel/CSV based translation file
When we almost finished the project, the customer provided us with an Excel file that contained the translations for all the text and labels in the forms. The file had 4 tabs for each form and each tab had six columns. The first column contained the base text in English and the following five columns contained the translation for that text. That's when I thought wouldn't it be great if the Excel file could be used as the main translation file. Using this main translation file a CSV file can then be exported from Excel for each form. Using this CSV file and an Adobe form template it should be possible to automate translation of the form in six (or even more depending on the number of columns) languages.
Automated translation proces
The steps for the automated translation I came up with were as follows:
- Read the CSV file
- Determine languages based on first line in CSV
- Read the source form (technically this is just an XML file)
- In the XML file, find and replace the the value of the first column in the CSV with the specified translation for all languages and all lines in the CSV.
- Save the result form by using the filename <source filename>-<language name>
Easy to use desktop tool
In the video below you can see the FormTranslator in action. If you are interested in the Adobe Form translator please feel free to contact me.