| This module imports CSV data into tables: |
| |
| CSV field: | Fields of the CSV file that can be used for the import. |
| Table field: | Assignment of the table fields. |
| Values: | Preview of the import values. |
| |
| Reload CSV file: | Import form is reloaded with the selected import options. If another CSV file is selected, it will be uploaded. |
| First row contains headings: | The first line of the CSV file is used to map the field headings and omit for import. |
| Get data from line: | The data from the CSV file is copied to the new table from the specified line. |
| Accept data rows: | The specified number of rows will be imported. The number of lines in the import file is calculated when the form is started. |
| Store empty strings as NULL: | If NULL is allowed for the inherited field, otherwise store empty strings. |
| REPLACE instead of INSERT: | Import option if a UNIQUE index is created for the table. The default is INSERT IGNORE
REPLACE causes the last data record to be used in the case of duplicate values. |
| Character encoding of the CSV file: | Selection of the character encoding of the CSV file if it is to be converted. |
| Save import scheme: | The field mappings are saved. With the next import with the same file format, these are automatically adopted. |
