XML-Server: What are data types used in the CSV import definitions?
Issue:
What are the data types used in CSV import definitions ?
Solution:
In the CSV file you can only define text values. Some of the text values
require a specified format so they can be imported as valid values.
- Text
Used for storing
text and numbers. These are left aligned.
- Numstr (Numerical strings)
Used for storing numbers as strings. In the file
these are right aligned.
- Date
Always formated
as DDMMYYYY, or 17022005 for 17 February 2005.
- J/N or N/J
These
fields contain the value 'J' (yes) or 'N' (no) and may therefore contain no
other values or lower case letters. The first letter indicates the default
value.
- Number
This can be a
whole or a decimal number. The decimal separator must be a full stop '.', for
negative values the number must be preceded by a minus sign '-'.
Related topics
| Main Category: |
Support Product Know How |
Document Type: |
Support - On-line help |
| Category: |
On-line help files |
Security level: |
All - 0 |
| Sub category: |
Details |
Document ID: |
10.623.348 |
| Assortment: |
Exact Globe+
|
Date: |
26-09-2022 |
| Release: |
|
Attachment: |
|
| Disclaimer |