Datalogging and Live display

[peadar]

First off i'd like to say i was a complete novice when i downloaded the package, but was up and running within weeks.

This is what we've accomplished so far:

We've succesfully installed a datalogger in test mode which will eventually be mounted on a vehicle to monitor various temperature readings, pressure sensors, and pulse counters.
This data will be given to the driver in a live graphical format
We're using a datataker DT80 for the job.

From there we've fed all this info into Mango through ModBUS IP, which then pushes the data out through a GPRS connection to a second Instance of Mango at the depot.

Administration at the Depot can then view a live display of the truck's activities and job reference.

Also on the recieving end, the data is parsed through Advanced Data Logger which puts the history into a MSSQL database for later analysis.

I'd like to know if Mango can put the Data into a MSSQL database itself, but for now, the Advanced logger does the job nicely.

Hats off to you guys...this is an exceptional piece of software...
It was easy to install, configure, and use...
only once in a while do you come across something as flexible and intuitive as this...Well Done!!

I'll keep you posted as to how the live install goes in April

[mlohbihler]

Hi peadar,

Thanks for the feedback. Mango can save directly to a MySQL database in a couple of ways. You can convert your database from Derby to MySQL, either by creating a fresh Mango instance with mysql settings in the env.properties file, or by converting an existing instance using instructions which you can find in these forums.

Or, you can create a SQL data source that will write data to any database for which you have a driver (although the mysql driver ships with Mango).

The first approach is less configuration. The second approach allows you to write to an arbitrary database structure.

[peadar]

genius..! i'll give it a go...i'll probably go with the mysql route for now.

i guess i can integrate into my existing mssql at a later date if needs be...

thanks again

[narenblr]

Mango through ModBUS IP, which then pushes the data out through a GPRS connection to a second Instance of Mango at the depot. >>>

Are you using Mango Publisher feature to publish to the Second instance of Mango or some thing else?

[peadar]

thats right. Using the http publisher feature. Just made sure all the parameter names match and it all works seamlessly...