The Translation Code Import source format lets you add and update Translation Codes in batch. Add it from the Source Format Library.

While it can be more efficient to manage Translation Codes individually, Slate also allows for the batch management of Translation Codes. This functionality can be especially useful when working with large Translation Code lists/values. You will want to follow the steps outlined below and we strongly recommend uploading Translation Codes in batch to a Test Environment first.

Activate the Translation Code Import Format

First, activate the Translation Code Import source format. Adding this format will allow you to use the Upload Dataset module to batch manage your Translation Codes.

1. Click Database in the Slate navigation bar and select Source Format Library in the Import section.
   
   

2. Locate the line for Translation Code Import (with Excel in the Format column) and click the Add link. The Add Source Format from Library popup appears.
   
   

3. Click Add. Confirm on the popup by clicking OK. The Prompt Import page appears.
   

Adding New Translation Codes

Download the template Excel spreadsheet with accepted column headers. Add your new Translation Codes. For example, if you need to create/add translation codes to your coordinator_title Translation Key, you can add rows your Excel document with “coordinator_title” in the Key column. More information about each column is available at the end of this article.

Upload Dataset

Upload the Excel file using the Upload Dataset module.

1. Click Database in the Slate navigation bar and select Sources / Upload Dataset in the Import and Data Processing section. The Sources / Upload Dataset page appears.
   
   

2. Click Upload Dataset
   
   

3. Enter the following configurations:

   • File Format: Select the Translation Code Import (Excel) format. (This is the format you activated from the source format library.

   • Folder: If using folders (recommended), select the desired folder for the import, or select Other and enter a new folder name.

   • Add Files: Add your Excel file to this area by clicking Add Files or by dragging your file from your Windows File Explorer and dropping it into the "Drag files here" area.

4. When all desired files have been added, click Upload.
   
   
   Once the import has completed, the Status will update to "Completed." The Rows Imported value will display 0 because the Translation Code Import source format does not update person or dataset records. As long as the import's status is Completed, the data is updated. Check the Translation Codes to confirm expected changes.

Updating Translation Codes

If you are updating existing translation codes, export the list of Translation Codes in your database using the Current Translation Code List query which can be found in the Standard Query Library.

Make your desired edits, but be sure not to edit or remove the Translation Code ID within the ID column. For example if updating the export values for the coordinator_title Translation Key, you would simply edit the values within the Export column:

Translation Code Import File Column Descriptions

The following table describes the columns and provides value instructions for the Translation Code Import file: