ASCII delimited (a.k.a. comma delimited) is a much used exchange file format that is used and recognized by many database programs.

File layout

An ASCII delimited file is a text file with the extension .csv. All fields of a record are on one line, separated typically by commas*. If commas (or the separator character that you specify) or cr/lf (carriage return and line feed) characters occur in a field, that field must be embedded in double quotes. Double quotes that occur in a field must be escaped by being doubled: "", but when you export from Adlib this escaping is automatically applied, so you can use double and single quotes in field contents in your application normally. The fields do not have a name; instead they have a serial number, the first field in each line being 01, the next 02, and so on. The field sequence is always the same. Repeated fields do not occur.

Example:

"954",214,"libraries, museums and conservation"
"9541",12,"cultural organization"
"9542",431,"libraries, public libraries"
"9543",521,"archives (public)"
"9544",3254,"museums"
"9545",2345,"art galleries, art libraries, etc."
"9546",8532,"botanical gardens and zoos"

ASCII delimited files may also have a first line that does not contain field values, but the names of the exported fields, e.g. "author","copy_number","title". This is for instance the case when you export to .csv file using the Export wizard in an Adlib application. But these field names are only included to document the meaning of the exported fields, they have no relevance for the tag mapping, as explained below.
Do note that such a first line is imported as a record too! So before importing a .csv file, you should open it in a text editor and remove any first line containing field names.

Conversion

With Designer, these files can only be imported, not exported; export is not possible because this file format is not suitable for repeated fields. But you can export to this format from an Adlib application; only the first occurrence of a repeated field will be exported.
This type of exchange file has no field names. Instead, the fields are numbered. For the tag mapping in an import job, you enter the serial numbers of the fields in the import file as source tags, and the Adlib tags as destination tags.

Example of a tag pair definition:

If you do not want to import a certain field from a comma-separated file, leave its Destination field in the mapping empty. (Do not map it to <null>, as that will import the relevant field into "tag" <n.)

* You may specify custom field and record separator characters, if the exchange file format requires it.