- 22 Apr 2025
- 3 minute read
- Print
- DarkLight
- PDF
Translation Code Import Source Format
- Updated 22 Apr 2025
- 3 minute read
- Print
- DarkLight
- PDF
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.
Click Database in the Slate navigation bar and select Source Format Library in the Import section.
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.
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.
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.
Click Upload Dataset
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.
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:
Column Header | Description | Data Type | Option Values |
---|---|---|---|
ID | Translation Code ID | GUID | To update an existing Translation Code, use the GUID of the existing code. To create a new Translation Code, leave this blank. |
Active | Active Status | Bit | 1 = Active; 0 = Inactive |
Default | If the Translation Code is Default, then its export values are used if the comparison value does not match any other Translation Codes within the Key group. | Bit | 1 = Default; 0 = Not Default |
Key | Translation Code Key | String | |
Type | The type of values to be compared. Leave this blank for Default Translation Codes. Required for all other Translation Codes. | String | string = String (Discrete Values); |
minValue | For string value types, this is the value that the comparison value must equal. For all other value types, this is the minimum value for the comparison value. Leave this blank for Default Translation Codes. Required for all other Translation Codes. | String | N/A |
maxValue | For string value types, leave this blank. For all other value types, enter the maximum value for the comparison value. | String | 1 = Default; 0 = Not Default |
Exports 1-5 | Export Values 1 through 5. | String | N/A |