Comma-Separated Values (CSV Files)

Arrays

GalilTools uses Commas-Separated Values (CSV) format for representing array data.


GalilTools Upload Arrays...

Uploading arrays from a Galil controller to the host PC will save the arrays as a text file in CSV format. When Downloading arrays from the host PC to the controller, GalilTools expects an input file in CSV format. The following is an example CSV file containing 2 arrays where "one" has 3 elements and "ten" has 4 elements:

one,ten
0,0
1,10
2,20
,0

The name of each array is in the first row of the data, separated by commas, and the columns from left to right are saved by GalilTools in alphabetical order based upon the array name. Element zero of each array is on the following line, followed by the rest of the array table data. Note that the shorter array "one" includes a place-holder comma



Hint: When Uploading array data from the controller to the PC, all arrays defined on the controller are saved. When Downloading array data to the controller, the CSV data is "appended" to the arrays on the controller (arrays with the same name on the controller as in the CSV file will be overwritten on the controller). See DA in the command reference to remove arrays from the controller.


CSV is widely supported and can be opened in any text editor such as Notepad and spreadsheets such as Microsoft Excel or OpenOffice.org Calc.



Microsoft Excel with .csv file opened

Axis and I/O Data

Below is an example of how to import axis data stored in controller arrays to a spreadsheet application such as Microsoft Excel. In this example, the Record Array (RA) feature of the controller is used to cache data during a move while the GalilTools Scope graphs the data in real time. Once the arrays are filled, the data can be Uploaded from the controller and graphed in a spreadsheet application.

The Galil code profiles movement and stores pertinent data to internal arrays while the GalilTools Scope plots the data in real time.


After the motion completes, the array data can be Uploaded and graphed in a spreadsheet. Note the similarities between the GalilTools Scope and Excel graph.




Table of Contents