Page 1 of 1

Charts based on Access DB?

Posted: Thu Dec 18, 2008 2:46 pm
by DJF3
Hi,

After a lot of testing and trying I got stuck..
Goal: Create a chart based on MS Access DB data (.MDB file)
How: Using VB(.net?) on my HomeSeer server

Question: Does anyone have a very simple example that does nothing but:
- Read data from an Access DB
- Generate a chart in your web-browser based on that data

Based on a simple example I can use this to extend it...

Thanks!
DJ

Charts based on Access DB?

Posted: Thu Dec 18, 2008 6:31 pm
by b_weijenberg
If you have the RFXCOM plug-in for Homeseer you will find some examples in the html\RFXUSER directory.
These examples get data from an MS-Access database and the charts are created using ChartDirector. With some modifications you will be able to create the charts using .NET.
http://www.domoticaforum.eu/topic.asp?TOPIC_ID=1751

Charts based on Access DB?

Posted: Thu Dec 18, 2008 8:00 pm
by Rene
I found an open source component very helpful for drawing great looking charts: http://www.visifire.com/

Currently I am in the process of implementing this for my homeseer plugwise plugin, see for a screenshot: http://www.domoticaforum.eu/topic.asp?T ... hichpage=2

Rene.

Charts based on Access DB?

Posted: Fri Dec 19, 2008 11:11 am
by DJF3
Thanks guys, this gave me a few good ideas. The examples in RFXUSER directory indeed are relatively easy to read. The examples of Google Charts and Visifire look very good too.
Merry Xmas!

Charts based on Access DB?

Posted: Fri Dec 19, 2008 6:55 pm
by Bwired
Nice chart component!