CSV Import Script Usage
The CSV import script searches the data store for nodes of a specified kind which have keys matching rows in the supplied csv data. Where the keys match, the node is updated, or deleted and recreated depending on the options selected.
The CSV import script is used from the command line. It is used as follows:
Where filenames is a list of csv files to import.
See CSV Import Examples for example of using the CSV importer.
The supported options are described in the Table below.
| Long option |
Description |
| --create |
Only new nodes are created, existing nodes are not updated. |
| --datastore=name |
The name of the data store service. The default is tideway. |
| --delete |
Matching nodes will be deleted, no other nodes will be affected. |
| --force |
Disables the validation checks which are performed against the taxonomy to check the specified node-kind and attribute/relationship keys. In this case, ALL keys, attributes and relationship links will be strings. |
| -h, --help |
Displays a help message on the standard options and exits. |
| --keys=keys |
Comma separated list of key columns to use for the data key. |
| --kind=kind |
The kind of node to create, update, or clear. |
| --logbackupcount=n |
Number of backup logs files preserved. The default is 0 which means that no previous logs are preserved. If a value is specified, the existing log is renamed logname.log.1 suffix and the new log written as logname.log. The same happens with later logs until the first is called logname.log.n. where n is the value specified. The next time a new log is written, the oldest is deleted. The rollover time is midnight. |
| --logfile=filename |
The name of the log file into which log messages are written. |
| --loglevel=level |
Specify a logging level. This can be one of the following:
- debug - log all messages
- info - log critical, error, warning, and information messages.
- warn - log critical, error, and warning messages.
- error - log critical and error messages.
- crit - log only critical messages.
|
| --partition=name |
The name of the partition to query or 'All' for all partitions. The default is all partitions. |
--password=password
-p |
The password of the Foundation user being used to import data. If you do not specify a password at the command line, the tool prompts you for the password. |
| --search=name |
Name of the search service. |
| --taxonomy=name |
Name of the taxonomy service. |
| --update |
Only existing nodes are updated, new nodes are not created. |
--username=name
-u |
The Foundation username to use to import data. |
| --verbose |
Output verbose messages while processing. This is useful for diagnosing errors. |
| -v, --version |
Displays Tideway Foundation version information and exits. |
Tideway Blog