Documentation Center

The Data Record

The data records provide the field values that correspond to the field names as defined in the header record. The important aspects of data records are listed below.
  • Values for entry attributes are only collected on the first record for each term entry.
  • A new term entry is recognized when one or more blank lines are encountered. A blank line is a line with only whitespace followed by an end of line. All records that follow are assumed to belong to the same term entry until another blank line is encountered or end of file is reached.
  • Timestamp values for all WorldServer defined term and term entry attribute values must use the following format: mm/dd/yy hh:mm am/pm (or the equivalent format for the Regional Setting you have selected).

Additional Notes

Although the ordering of the fields is not important for importing term data, SDL recommends the following field ordering to make viewing and editing of data in a spreadsheet easier. This is the field ordering that is used by the WorldServer CSV Term Export Function.

Field #Field NameField Description
1LanguageThe Locale of the term.
2TermThe text value of the term.
3-NUser definedAll user-defined term attributes.
N+1Created OnCreation time of the term.
N+2Created ByUser who created the term.
N+3Modified OnModification time of the term.
N+4Modified ByUser who modified the term.
(N+4)+IUser definedAll user-defined term entry attributes.
(N+4)+I+1Created On-EntryCreation time of the term entry.
(N+4)+I+2Created By-EntryUser who created the term entry.
(N+4)+I+3Modified On-EntryModification time of the term entry.
(N+4)+I+4Modified By-EntryUser who modified the term entry.

Also, CSV files exported by WorldServer include two special system-defined attributes as the last two field values of the record – namely Entry Id and Term Id. These values are private to WorldServer exported CSV files. The values of these fields should not be altered. CSV term import files created by means other than through the WorldServer export function must not include these fields.