man hk_importcsv (Commandes) - imports a csv file. hk_importcsv is part of the hk_classes package

NAME

hk_importcsv - imports a csv file. hk_importcsv is part of the hk_classes package

hk_importcsv -d driver -b database -t tablename [OPTIONS] CSV-file

hk_importcsv imports a csv file and creates the table if necessary.

-b, --database=DATABASE: database name
--between=BETWEEN: column separator, default is ','
-d, --driver=DRIVERNAME: set the SQL-driver (e.g. mysql). You can get a list of all existing SQL-drivers with -l or --list
--delimiter=TEXTDELIMITER: the text delimiter, default is '"'
--df=dateformat: date format, may contain M D Y, example: D.M.Y
--tf=timeformat: time format, may contain h m s , example: h:m:s
--dtf=datetimeformat: datetime format, may contain M D Y h m s, example: D.M.Y h:m:s
--locale=locale: locale of the import file, influences the number appearance
--charset=charset: charset of the import file
--noautoincdetection: avoids detection of auto_inc data type
-f, --filter=FILTER: filter of the datasource. It has the same syntax as the WHERE clause of a SQL statement, just without the 'WHERE'. Example: "author_id = 5"
-h, --host=HOST: name or IP-number of the host
-l, --list: List available database drivers
--noheader: if set the column names will not be included in the first row
-p, --password=PASSWORD: user password at the SQL server
-r, --port=PORT: TCP-port on host
-t, --table=TABLE NAME: the name of the table
-u, --user=USERNAME: user name at the sql-server
-w, --overwrite: overwrites the table if it already exists
--version: version and author of hk_classes

hk_importcsv returns 0 if everything was ok, or 1 if an error occured. A clear text error message will be written to stderr.

Horst Knorr <hk_classes@knoda.org>