The Translation Code Import source format lets you to add and update Translation Codes in batch. Add it from the Source Format Library.
Why am I seeing 0 rows imported?
the Rows Imported value displays 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.
Accepted column headers
Download a template Excel spreadsheet with accepted column headers.
Export the list of Translation Codes in your database with the Current Translation Code List query. Find this query in the Standard Query Library.
The following section describes these columns and provides value instructions:
ID
- Description
- Translation Code ID
- Data Type
- GUID
- Option Values
- To update an existing Translation Code, use the GUID of the existing code. To create a new Translation Code, leave this blank.
Active
- Description
- Active Status
- Data Type
- Bit
- Option Values
- 1 = Active; 0 = Inactive
Default
- Description
- 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.
- Data Type
- Bit
- Option Values
- 1 = Default; 0 = Not Default
Key
- Description
- Translation Code Key
- Data Type
- String
Type
- Description
- The type of values to be compared. Leave this blank for Default Translation Codes. Required for all other Translation Codes.
- Data Type
- String
- Option Values
-
string = String (Discrete Values);
real = Real Number (Inclusive Range of Values);
int = Integer (Inclusive Range of Values);
date = Date (Inclusive Range of Values);
datetime = DateTime (Inclusive Range of Values)
minValue
- Description
- 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.
- Data Type
- String
maxValue
- Description
- For string value types, leave this blank. For all other value types, enter the maximum value for the comparison value.
- Data Type
- String
- Option Values
- 1 = Default; 0 = Not Default
Exports 1-5
- Description
- Export Values 1 through 5.
- Data Type
- String