Personal tools
You are here: Home Products GS-911 Support How-tos How to import and view the CSV realtime data
Document Actions

How to import and view the CSV realtime data

In GS-911, real-time data can be logged to a .CSV file. This file is semicolon (";") separated.
To graph or otherwise manipulate the real-time data, the CSV file has to be imported into either Microsoft Excel or OpenOffice Calc. (opensource free download from http://www.openoffice.org) or similar software.

As these log files are separated using a semicolon ";" Excel might have trouble importing this the first time, depending on the regional setting in your version of Microsoft Windows.

In order for Excel to import these CSV files seamlessly, you have to set the "list separator" to semicolon ";" under the Regional Options.

For Windows XP:
"HOW TO: Change Date, Time, Number, and Currency Value Displays in Windows XP"
Aternatively : Control Panel -> Regiaonal and Language Options -> In Regianl Options Tab, click Customize button -> Modify "List separator" -> click Apply button -> click Apply again...

For Windows Vista:
In Windows Vista, go to Control Panel, then choose, Clock language and Regions, then Regional and Language, when the next window pops up the TAB at the top named FORMATS is alredy displayed, click on the button near the bottom CUSTOMIZE THIS FORMAT. Here you will find the List Separator.


A good alternative to to Excel or OpenOffice would be LiveGraph (http://www.live-graph.org).  The picture below shows a typical screenshot of LiveGraph.

LiveGraph.png

You can open the .CSV by clicking the Open button (circled red above).

However before opening a GS-911 CSV file in LiveGraph, it has to be edited into the correct format for LiveGraph to use!
  1. Use any text editor (such as notepad) to edit the .csv file
  2. the first line of the file has to be "##;##" (this tells LiveGraph that it should use a semicolon as delimiter)
  3. all other lines above the column headings should start with a hash "#" (this makes them comments, as the first data LiveGraph requires are the headings)
A correctly edited file should look as follows:

logfile4livegraph.png



Copyright (c) HEX Code 2009