Bulk Uploading Translated Content

Source:

Published:

Keywords: bulk upload, translated content, Touchpoint, multilingual, import, export, Excel, Agenda Sessions

Document ID: touchpoint-support_certain_com_hc_en-us_articles_4430635936023-Bulk-Uploading-Translated-Content

Overview

This article explains how to bulk upload translated content in Touchpoint.

Bulk uploading is available when an event has multiple languages enabled.

The bulk-uploading process exports content from the primary language, translates the content in a spreadsheet, and imports the translations back into Touchpoint.

Steps for bulk uploading translated content

1. Export the existing content from the Touchpoint CMS.

2. The export will be an Excel workbook with the first tab titled "Agenda Sessions."

3. The other tabs are labeled with the supplemental languages selected for the Touchpoint event.

4. DO NOT remove or reorder the rows on any spreadsheet in this workbook.

5. The import process matches content by row.

6. On each of the supplemental language spreadsheets, you will see a "Hint" column.

7. There is a column for each of the translatable fields on that feature.

8. The Hint column is simply included for your reference when entering the translated content in the spreadsheet.

9. The translatable field columns will be blank on the export.

10. Enter the translated content in each row, then save the workbook to your computer.

11. Import the saved workbook into Touchpoint.

12. Start by going to the feature you wish to import, then click the Import button in the upper right, and select Excel.

13. Click Choose File, select the Excel file from your computer, then click Save.

14. You will be asked to Select Sheet from the Excel workbook.

15. Select the first sheet with the feature name (for example, "Agenda Sessions") — NOT any of the sheets labeled as the supplemental languages.

16. On the field mappings page, make sure the ID field is mapped to ID, and the translatable fields are mapped to their corresponding fields (for example, Name is mapped to Name and Description is mapped to Description). All other fields you can select to IGNORE. Then click Confirm.

17. On the next screen, double-check your field mappings one more time, then click Import.

18. This will start the import process.

19. If there are any errors found while uploading the spreadsheet, you will see the errors on the screen.

20. Once the import is complete, you will see a message that says "# records have been successfully imported."

21. You can check that the translations uploaded correctly by clicking Edit next to a translated item in the Touchpoint CMS.

22. You should see the translated content below each translatable field on the edit screen.

Related articles