Data loading Script User Guide

The data loading script gives an easy way to create items in the chandler repository.

How to use

1. Define the different items to be created in an Excel or OpenOffice document
2. Export this document into the CSV format:
   • Excel : Save as CSV (Windows)
   • OpenOffice (save as .CSV) choose ',' for the field separator and nothing for text delimiter.
3. Give the CSV file to the data loading script (2 differents ways)
   • By using the "Generate data from a file" dialog invoked from the "Test" menu
   • By the command line using the --createData parameter:

             release/RunChandler --createData=/User/Home/file.csv

The data syntax

• Here's an example Excel file with sample data : test.xls
• Corresponding CSV file for this Excel sheet : test.csv

More ...

• Wildcard caracter '*' : You can use wildcard for all data fields (semi-random data will be generated by the script)
• Empty fields : If you don't fill all the requiered fields the script will use a default value
• If you don't respect the data syntax (too few or bad arguments) the script just skips the bad lines (skipped lines are reported in the log)
• In the syntax : the kind field is not case sensitive
• You can add comments in your Excel file by using # at the begining of the row