Get real-time data directly into your DNN portal!

    JumpStart DNN is the answer on rapid development of administrative applications in the DotNetNuke portal.
    Create stunning DotNetNuke applications! Just design your database in the FREE DatabaseBuilder and upload this to JumpStart DNN.
    Your application will be send to you by mail within a couple of seconds!

Visual Data's JumpStart has developed an easy way to ger sensor readings directly into your DNN database.

The businesscase:
I have a sensoring system that measures light intensity and temperature in real time.
I need these data into my database in my DNN portal to enable me to investigate on how the daylight and temperature interact with each other.
(Not very senisble, but what the heck! it's all for the demo!)
So I need two tables in my database: one DayLight table and one Temperature table.
And I need a way to get the data from the sensors directly into the database.

The working process:
The sensor readings will be stored in a textfile, and this textfile will be closed after a predefind number of readings is reached.
Then the file will be send to my DNN portal where the sensor reading module will automatically read the textfile and write the data into the database at the moment I open the page where this module resides.

How this is done?
There are two main components that are added to my DotNetNuke portal:

• An "Arduino"  microcomputer that makes up the sensoring system.
• The "GoBetwino" interface that takes care of the filetransport between the Arduino and my DNN portal.

 See the help pages that I created to show you how this is done!

A part of the Arduino code..... void logData( int value1, String sensorname, String remark) {    char buffer[5];    Serial.print("#S|VDWLOGFILE|[");    Serial.print(sensorname);    Serial.print(";");     Serial.print(itoa((value1), buffer, 10));    Serial.print(";");    Serial.print(remark + "; LC: " + strLineCount);    Serial.println("]#");    readSerialString(serInString,1000);    Serial.flush();

A part of the GoBetwino working results... 6-4-2012 12:19:20   Serial port : COM5 opened at 9600 baud 6-4-2012 12:19:20   The log file: C:\arduino-0023\VDW_SensorTechniek\gobetwino.log does not exist, can not log data. 6-4-2012 12:19:23   Commandstring recieved : #S|COPYFILE|[]# 6-4-2012 12:19:23   Command parsed OK 6-4-2012 12:19:23   Executing command : COPYFILE 6-4-2012 12:19:23   copying C:\arduino-0023\VDW_SensorTechniek\Sensors\OutPutFiles\NewVDW_LogFile.txt.txt to C:\arduino-0023\VDW_SensorTechniek\Sensors\OutPutFiles\VDW_LogFile.txt finished 6-4-2012 12:19:23   Commandstring recieved : #S|VDWLOGFILE|[ =================================================================]# 6-4-2012 12:19:23   Command parsed OK 6-4-2012 12:19:23   Executing command : VDWLOGFILE 6-4-2012 12:19:23   Data logged to C:\arduino-0023\VDW_SensorTechniek\Sensors\OutPutFiles\VDW_LogFile.txt 6-4-2012 12:19:23   Commandstring recieved : #S|VDWLOGFILE|[ == Visual Data Webservices and Visual Data's Jumpstart]# 6-4-2012 12:19:23   Command parsed OK 6-4-2012 12:19:23   Executing command : VDWLOGFILE 6-4-2012 12:19:23   Data logged to C:\arduino-0023\VDW_SensorTechniek\Sensors\OutPutFiles\VDW_LogFile.txt 6-4-2012 12:19:23   Commandstring recieved : #S|VDWLOGFILE|[ == This file contains 2 sensor objects]# 6-4-2012 12:19:23   Command parsed OK

    You design your database in a “DatabaseBuilder” helper application. This application can be dowloaded FREE from the Downloadpage on the website.
    The Downloadpage also contains databaseBuilders for complete applications like the "VisitorAnaysis" tool.


                     
                         Visit our website and learn more: www.vd-jumpstart.com

 Yes!

And the proof is there. I released a project for my client that uses this feature this week, and it works awsome.

More news to come soon.

Cheers,

Jos