When you define a header column in your data file, the header value consists of 2 parts. The first part is the name of the field you want to upload the values into, and the second part is the field definition, which defines the type of values to upload. E.g.
In the above example, column B contains the header value document filecontent. This means we want to upload the document field in our table, and the filecontent definition indicates we want to upload the contents of the files listed in that column.
Similarly, referenceID datanumber means to upload the integer values of that column into the referenceID field, and comment datatext uploads text values from that column into the comment field.
These are the available field definitions you can use:
Field definition |
Description |
filecontent |
The values in the column are file names, and their content will be uploaded into the specified field.
There can only be 1 column using the filecontent definition. |
datanumber |
The values in the column will be uploaded as integer values into the specified field. |
datatext |
The values in the column will be uploaded as text values into the specified field. |
keynumber |
The values in the column will be used as integer key values to update the table. |
keytext |
The values in the column will be used as text key values to update the table. |