Zymonic Toolkit System

This page contains all of the options for: sudo zymonic_toolkit.pl System

See the manual page for the system toolkit for further details.

=Synchronize CSV= This 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. sudo zymonic_toolkit.pl System synchronize_csv [PARAMETERS]

Example
Command to run: sudo zymonic_toolkit.pl System synchronize_csv --system test_system --table_zname zz_countrylist --field_sequence "country,alpha2code,alpha3code,countrycode,countryintdial,currencycode" --update_type "UpdateOrInsert" --username admin --zpass ! --csv_path "/tmp/country.csv" Data in `/tmp/country.csv`: United Kingdom of Great Britain and Northern Ireland,GB,GBR,826,44,GBP

Insert
Insert any data from the csv file into the specified table including any duplicates. Data should be in the same order as the field sequence specified, keyfields are ignored.

Update
Update any matching data from the csv file in the specified table. Data should be in the same order as the field sequence specified, keyfields are used in combination to identify the correct records. By default duplicate records in the table will be set as deleted. No action will be taken if the records aren't found in the table.

Delete
Delete any records from the csv file in the specified table. Data should be in the same order as the field sequence specified, keyfields are used in combination to identify the correct records. Option hard_delete can be used to remove the records from the table completely instead of just marking them as deleted in the DB.

UpdateOrInsert
Update any matching data from the csv file in the specified table, and insert non-matching records. Data should be in the same order as the field sequence specified, keyfields are used in combination to identify the correct records. By default duplicate records in the table will be set as deleted.

InsertIfNotFound
Insert any data from the csv file into the specified table unless the data is already in the table. Data should be in the same order as the field sequence specified, keyfields are used in combination to identify the correct records.

=Get System Option= This command returns the value of a system option for a given system and option name.

sudo zymonic_toolkit.pl System get_sys_opt [PARAMETERS]

Example
sudo zymonic_toolkit.pl System get_sys_opt --system test_system --option filter_report_max_results