Sunday, December 21, 2014
   
Text Size
Login

Joe's CSV Chart Generator (JCG)

TESTED ON:

- Windows XP, Windows Server 2003, Windows 7

SCREENSHOTS:

CSV Chart Generator  CSV Chart Generator CSV Chart Generator

LICENSE:

These scripts are offered freely and in good faith. Please do not pass this off as your own work or try to sell it without due credit. Check back with us at joellipman.com for updates/fixes. If you want more support/work done to it, you could consider a donation :c)

BACKGROUND:

Originally dubbed EventViewer Chart Generator. As the name suggests, I was looking for a free program that can take an exported CSV list from a standard MS Windows eventlog or eventviewer log and generate a chart from the data. What my program does is convert all the data into a settings and data file that can be used by the charting system AMCharts.com.

AMCharts.com provide a flash-based interactive chart which you can zoom in and out of, includes almost every type of chart you can think of (though this program only uses chart types: Area, Bar, Column, Line and Pie). Note that AMCharts.com is free as long as you leave the copyright information. If you want to remove the copyright text that displays on the charts, you need to buy the products of AMCharts.com. I have no afiliation with these and I myself don't put any copyright information on the end product.  

I needed a program to:
+ Group all the data by a specified column
+ Generate interactive flash charts

The program was intended to chart EventViewer "Security" logs but I quickly found that I could make it group and chart any Comma Separated Value file.

CHANGELOG:


  1.  Version 1.0 
  2.       + This is version 1.0 unless people have suggestions I don't see the need to release service packs and updates. 

OTHER NOTES:

This program does not install other files nor is a setup. It was created in AutoHotkey and the download includes the source file if you want to check it doesn't have any malicious code.

INSTALLATION:

  1. Download the csvchartgenerator.zip from www.joellipman.com/features/downloads.html > downloads > Programs > JL Tools > Joe's CSV Chart Generator (requires registration)
  2. Unzip the file (should create a folder)
  3. Run CsvChartGenerator.exe (or if you have AutoHotkey installed, run the CsvChartGenerator.ahk file)

FUTURE CONSIDERATIONS:

  • Any suggestions on improving this product would be much appreciated

SCREENSHOTS:

CSV Chart Generator  CSV Chart Generator CSV Chart Generator

Comments   

Ross H
# Ross Mon, 22nd October 2012
Any chance of adding scatter graphs?
Regards
Ross
Like | Dislike | 0 Reply | Reply with quote | Quote
# Joel Fri, 26th October 2012
Hi Ross,

Thanks for your enquiry. That sounds like a great idea but amcharts have evolved since I wrote this program and I will need to revisit the capabilities of the version I am using with this program (the FREE version). I have no doubt their commercial version include these but I need to use their FREE version due to license restrictions.

Cheers!
Like | Dislike | 0 Reply | Reply with quote | Quote
Add Comment

Name:

Email:

Website:

Message:


Latest Posts

  • Basic Android App using Google Maps and Current Location

    • Wed 17-Dec-14
      Is that how it's spelt? setContentVie( "View". If not try going to build and "clean project". Also ...
      Joel L.  
    • Tue 16-Dec-14
      I have problem in "cannot resolved R" " setContentVie(R .layout.activit y_maps);" :cry: How to solve ...
      LucasR
  • Migrate Joomla! 1.5.x to 2.5.x+

    • Thu 18-Dec-14
      Interesting report LLiSEIL! I'll definitely have to review it when Joomla 3.5 comes out. Error 1: is ...
      Joel L.  
    • Tue 16-Dec-14
      * Categories: - duplicates, I suppose from the multiple times I launched the script. - love the notes ...
      LLiSEIL  
    • Tue 16-Dec-14
      SQL ERror 3 > -- Step 2) Import articles from J15 and insert as articles in J30 INSERT INTO `newbase_j25`.d ...
      LLiSEIL