en-USnl-NL
You are here:   GoBetwino
  |  Login

Get real-time data directly into your DNN portal!

Minimize
Visual Data's JumpStart has developed an easy way to get 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 three 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.
  • The "WINSCP" open source FTP application to send the files to the server on wich my DNN portal resides.
  • and a couple of BAT and TXT files that are used as commandlines to get the WINSCP send the files and do some other housekeeping stuff.
See the help pages that I created to show you how this is done!
Get all the code from the GoBetwino downloadpage! (You need to be registered... Its free!)

 The Arduino microprocessor

The Arduino microcontroller

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

Arduino sensoring system

Minimize
The ARDUINO project is an open source hardware system that alows you to build your own sensoring equipment.
It is an electronics prototyping platform based on flexible, easy-to-use hardware and software. It's intended for artists, designers, hobbyists, and anyone interested in creating interactive objects or environments.

GoBetwino Interface System

Minimize
The GOBETWINO application enables an ARDUINO to communicate with other Microsoft applications.
Gobetwino is kind of a "genreric proxy" for Arduino. It's a program running on a PC (Windows only - sorry), that will act on behalf of Arduino and do some of the things that Arduino can't do on its own.  So it works like a go between, hence the name.