CSV Exports & Imports for Translation

Platform content that supports the CSV export/import process:

• Course session content (resources, menu-items, forms, polls, quizzes)
• Course catalog content and application forms
• Track catalog content and application forms
• Profile forms
• Post-registration forms

The general workflow is:

1. Export the platform content as a CSV file (or a ZIP folder of multiple CSV files)
2. Send the CSV file to the 3rd-party translation firm
3. They translate the content column in the CSV file, while preserving the id and type columns
4. Receive the translated CSV file from the 3rd-party translation firm
5. Import the translated CSV file for the new language

See below for step-by-step instructions on how to do so for each type of platform content.

Translating the Course Session Content

Export Session Resources, Menu-Items, Forms, Polls, Quizzes for Translation

1. Navigate to the Admin Portal page for the course session (i.e. the page listing all enrollments)
2. Click the Export button on the right side of the page.
3. Select the Resource Translations menu item.
4. The zip file, Session_Resource_Translations_MM-DD-YYYY.zip, will be automatically downloaded to your computer. This zip file will contain a copy of each existing translation for the session resources, menu items, forms, polls, and quizzes. Extract the contents of the zip file to a location on your computer and find the CSV for the default language.
5. The CSV file will contain 3 columns: id, type, and content. The translation team should only make changes to the content column. You CANNOT CHANGE the data in the id and type columns. See example output below:

Import Translations for Session Resources, Menu-Items, Forms, Polls, Quizzes

1. After the CSV file has been updated to include the translated data in the content column, navigate back to the Admin Portal page for the course session (i.e. the page listing all enrollments).
2. Click on the Settings tab.
3. Scroll down to find the Import Translations section.
4. Select the language of your translation from the Language dropdown.
5. Click the Browse button.
6. Navigate to the updated CSV file in your file browser and click to open.
7. Click the Import button.
8. Make sure your platform language is set to the language matching the imported translation and navigate to the course session. You should see the translated content.

Translating the Course Catalog Content

Export Catalog Content, Application Form for Translation

1. Navigate to the Admin Portal page for the course (i.e. the page listing all course sessions)
2. Click on the Settings tab.
3. Scroll down to find the Translations -> Export course data for translation section.
4. Click the Export button.
5. The zip file, Course_Translations_MM-DD-YYYY.zip, will be automatically downloaded to your computer. This zip file will contain a copy of each existing translation for the course details, catalog listing, and application form. Extract the contents of the zip file to a location on your computer and find the CSV for the default language.
6. The CSV file will contain 3 columns: id, type, and content. The translation team should only make changes to the content column. You CANNOT CHANGE the data in the id and type columns. See example output below:

Import Translations for Catalog Content, Application Form

1. After the CSV file has been updated to include the translated data for the content column, navigate back to the Admin Portal page for the course (i.e. the page listing all course sessions).
2. Click on the Settings tab.
3. Scroll down to find the Translations -> Import translation data for course section.
4. Select the language of your translation from the Language dropdown.
5. Click the Browse button.
6. Navigate to the updated CSV file in your file browser and click to open.
7. Click the Import button.
8. Make sure your platform language is set to the language matching the imported translation and navigate to the catalog listing page. You should see the translated content.

Translating the Track Catalog Content

Export Catalog Content, Application Form for Translation

1. Navigate to the Admin Portal page for the track (i.e. the page listing all courses for the track)
2. Click on the Settings tab.
3. Scroll down to find the Translations - Export track data for translation section.
4. Click the Export button.
5. The zip file, Track_Translations_MM-DD-YYYY.zip, will be automatically downloaded to your computer. This zip file will contain a copy of each existing translation for the track details, catalog content, and application form. Extract the contents of the zip file to a location on your computer and find the CSV for the default language.
6. The CSV file will contain 3 columns: id, type, and content. The translation team should only make changes to the content column. You CANNOT CHANGE the data in the id and type columns. See example output below:

Import Translations for Catalog Content, Application Form

1. After the CSV file has been updated to include the translated data for the content column, navigate back to the Admin Portal page for the track (i.e. the page listing all courses).
2. Click on the Settings tab.
3. Scroll down to find the Translations -> Import translation data for track section.
4. Select the language of your translation from the Language dropdown.
5. Click the Browse button.
6. Navigate to the updated CSV file in your file browser and click to open.
7. Click the Import button.
8. Make sure your platform language is set to the language matching the imported translation and navigate to the catalog listing page. You should see the translated content.

Translating the Profile Form

Export Profile Form for Translation

1. Navigate to the Admin Portal page for the organization's profile form.
2. Click the Export button on the right side of the page.
3. Select the Profile Form Translations menu item.
4. The CSV file, Profile_Form_Translations_MM-DD-YYYY.csv, will be automatically downloaded to your computer.
5. The CSV file will contain 3 columns: id, type, and content. The translation team should only make changes to the content column. You CANNOT CHANGE the data in the id and type columns. See example output below:

Import Translations for Profile Form

1. After the CSV file has been updated to include the translated data for the content column, navigate back to the Admin Portal page for the organization's profile form.
2. Scroll down to find the Translations -> Import translation data for profile form section.
3. Select the language of your translation from the Language dropdown.
4. Click the Browse button.
5. Navigate to the updated CSV file in your file browser and click to open.
6. Click the Import button.
7. Make sure your platform language is set to the language matching the imported translation and navigate to your profile page. You should see the translated content.

Translating the Post-Registration Form

Export Post-Registration Form for Translation

1. Navigate to the Admin Portal page for the organization's post-registration form.
2. Click the Export button on the right side of the page.
3. Select the Post-Registration Form Translations menu item.
4. The CSV file, Post_Registration_Form_Translations_MM-DD-YYYY.csv, will be automatically downloaded to your computer.
5. The CSV file will contain 3 columns: id, type, and content. The translation team should only make changes to the content column. You CANNOT CHANGE the data in the id and type columns. See example output below:

Import Translations for Post-Registration Form

1. After the CSV file has been updated to include the translated data for the content column, navigate back to the Admin Portal page for the organization's post-registration form.
2. Scroll down to find the Translations -> Import translation data for post-registration form section.
3. Select the language of your translation from the Language dropdown.
4. Click the Browse button.
5. Navigate to the updated CSV file in your file browser and click to open.
6. Click the Import button.
7. Make sure your platform language is set to the language matching the imported translation and navigate to the post-registration form on your settings page. You should see the translated content.