Zymonic Toolkit System

Synchronize_csv
Command general info

This is a new toolkit command which replaces “upload_csv” called “synchronize_csv”. New command can be used to relatively quickly: insert, update, update/insert and delete records in a Zymonic table based on a csv. Usage is as follows.

Usage

sudo zymonic_toolkit.pl System synchronize_csv [parameters below]

Required parameters

--system             -  System the destination table is in --table_zname     -  ZName of destination table to be altered --field_sequence - Comma delimited list of field znames in the order the data appears in the csv --csv_path          -  File path to the csv file with the data --username         -  Username for the systems GUI --zpass                -  Corresponding password for the username

Optional parameters:

--state                -    State to set the inserted records to for the GUI. Most likely should be the state saved records are set to. --keyfields         -    Comma delimited list of fields to be used to match existing records in the table when updating/deleting. May be primary key, or a list of fields which combined are unique. Not needed for Insert. --delete_others  -    Defaults to no. If set to “yes”, will set records from the table which aren’t in the csv file as deleted. --update_type       Defaults to “Insert”. Mode to run the command in options: -Insert - insert records from the csv as long as they pass validation -Update – update records in the table matching the csv based on the keyfields supplied -UpdateOrInsert – updates matching records, inserts others -Delete – delete records in table matching csv --batch_size       -  Defaults to 100. Varies the size batch that the code passes the data through in internally only changes performance, 100 was found to be a good number.