Documentation Center

Specifying column headers

This page is displayed when you convert from spreadsheet and database exchange format. Here you define the field type of each of the column header fields that usually appear in the top row or the first line of a tab-delimited text file (*.txt), comma-separated value file (*.csv), or Microsoft Excel file (*.xls).

About this task

You can define fields as language fields or descriptive fields. For a language field, you must choose a language locale.

For a descriptive field, you must choose the type of field from the following choices:

  • Text
  • Number
  • Boolean
  • Date
  • Picklist
  • Multimedia file

Procedure

  1. From the list under Available column header fields, select the field whose field type you want to specify.
  2. Select Language field, Descriptive field or Concept ID as appropriate. Use the relevant drop-down list to choose the language locale for index fields or the type of field for descriptive fields.
  3. Select Concept ID if the field should be used as an entry ID in a termbase. Columns in spreadsheets have to be assigned a data type. It should only be used for a column containing integer numbers and only for one column in a spreadsheet.
  4. Continue until you have defined the field type for each of the column header fields.
  5. Select Next. The Create Entry Structure page appears.