Question:
What is the difference between CSV and text files, if they are used with Active Import for index extension?
Answer:
A CSV file always has commas (Comma Separated Values) as delimiters between fields of a data record. If a field of a data record is bracketed in quotation marks, these are removed when the values are read. That means that an entry written as „DocuWare" or as DocuWare will both be transferred as DocuWare into the selected database field.
In contrast to a CSV file, text files with delimiters can contain any delimiters for the record fields. Quotation marks surrounding field entries are therefore always read. That means a field entry which appears as „DocuWare" will also be transferred as „DocuWare" – with the quotation marks intact – into a selected field.
When setting up an indexing extension, the first data string of the file must be completely filled out. If this is not the case, those fields which do not have a value entered will not be added.