Translation Code Import Source Format
  • 04 Apr 2024
  • 1 minute read
  • Dark
    Light
  • PDF

Translation Code Import Source Format

  • Dark
    Light
  • PDF

Article summary

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

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.

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.

The following table describes these columns and provides value instructions:

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);
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

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

Attachments

Was this article helpful?

What's Next