| This module creates a new MySQL or MariaDB table from a CSV import: |
| |
| Table head: |
| Name: | Name of the new table. |
| Comment: | Comment to be stored for the new table. |
| Next autoindex: | First AUTOINCREMENT value for new table. |
| Engine: | Database format of the new table. |
| Collation: | Character set and collation of the new table. |
| Row format: | Format in which the table rows should be managed in the database. |
| |
| Import columns: |
| CSV field: | Selection of which fields of the CSV file should be used for the import. |
| Column Name: | Edit field names. |
| Column type: | Editing of the field types. The field types are assigned automatically by analyzing the CSV file, but can be changed. |
| Length: | Edit field lengths. The field lengths are automatically calculated by analyzing the CSV file, but can be changed. The minimum lengths are specified for character strings.
Editing can be activated for all field types, otherwise default values are used. |
| Null Value: | Specifies whether NULL values should be allowed for the fields. |
| Additional column options may appear: |
| Default value: | Here you have the option of specifying standard values for the fields. |
| Option: | Field options according to field type. |
| Collation: | Collation for string fields. |
| Comment: | Comment for table field. |
| Index: | Index creation for fields during table creation. |
| Combine: | Specifies whether fields should be combined into an index. |
| Values: | Shows the values of the first 20 rows of the import file. |
| |
| Import options: |
| Reload CSV file: | Creation form is reloaded with the selected import options. If another CSV file is selected, it will be hoshloaded. |
| First row contains headings: | The first line of the CSV file is used to name the field headings. |
| Field names in lower case: | Field titles are in lower case. |
| Original names as column names: | When loading this form, adopted field names are normalized. This can be prevented here. |
| Data import options: |
| Import data from CSV: | The data from the CSV file is copied to the new table. |
| Get data from line: | The data from the CSV file is copied to the new table from the specified line. |
| Accept data lines: | The specified number of rows will be imported. The number of lines in the import file is calculated when the form is started. |
| Add auto increment: | Add AUTO_INCREMENT value in this table specifying the name. A BIGINT value can also be selected for this. The default is INT. |
| 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 SCV file: | Selection of the character encoding of the CSV file if it is to be converted. |
| |
| Server options: |
| Data directory target table: | Path to the directory on the server where the data files are to be saved. |
| Index directory target table: | Path to the directory on the server in which the index files are to be stored (MyISAM only). |
| |
| Create table in database: | Table is created and displayed in the menu. An import log is output. |
| Download generation as SQL script: | The creation of the table and data import are downloaded in a SQL file. |
