Module Name: Advanced CSV File Importer
Module path: import/csv_file
Name: Advanced CSV File Importer
Path: modules/import/csv_file.py
Author: Ethan Robish (@EthanRobish)
Description:
Imports values from a CSV file into a database table.
Options:
| Name |
Current Value |
Required |
Description |
| COLUMN_SEPARATOR |
, |
yes |
character that separates each column value |
| FILENAME |
|
yes |
path and filename for csv input |
| HAS_HEADER |
True |
yes |
whether or not the first row in the csv file should be interpreted as column names |
| QUOTE_CHARACTER |
|
no |
character that surrounds each column value |
| TABLE |
|
yes |
table to import the csv values |
Comments:
* Only a few options are available until a valid filename is set. Then, the file is analyzed and more options become available for configuring where each CSV entry is imported.
* This module is very powerful and can seriously pollute a database. Backing up the database before importing is encouraged.