The Data Record
- 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 Name | Field Description |
|---|---|---|
| 1 | Language | The Locale of the term. |
| 2 | Term | The text value of the term. |
| 3-N | User defined | All user-defined term attributes. |
| N+1 | Created On | Creation time of the term. |
| N+2 | Created By | User who created the term. |
| N+3 | Modified On | Modification time of the term. |
| N+4 | Modified By | User who modified the term. |
| (N+4)+I | User defined | All user-defined term entry attributes. |
| (N+4)+I+1 | Created On-Entry | Creation time of the term entry. |
| (N+4)+I+2 | Created By-Entry | User who created the term entry. |
| (N+4)+I+3 | Modified On-Entry | Modification time of the term entry. |
| (N+4)+I+4 | Modified By-Entry | User 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.