Tuesday, July 29, 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 Hollier
# Ross Mon, 22nd October 2012
Any chance of adding scatter graphs?
Regards
Ross
Like | Dislike | 0 Reply | Reply with quote | Quote
# Webmaster 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

  • Joes Quicklist Weblinks (JQW)

    • Thu 17-Jul-14
      Hi, thanks a lot. But I have got a problem with download it. Error: "File could not be found Important!
      Kat  
    • Tue 15-Jul-14
      Hi Artur, I forgot to get back to you sooner. I was going to include a set of instructions to do this ...
      Webmaster  
    • Mon 14-Jul-14
      Hi Skarosg, Not sure if we took this to e-mail but I noticed your site is displaying the images now.
      Webmaster  
    • Fri 11-Jul-14
      Hi, How can I put user name and category of weblink in module, near the date? Thanks..
      Artur
  • Joes Word Cloud (JWC)

    • Tue 17-Jun-14
      I'm using JE 3.1.19 stable.
      alve89