| Author |
Message |
![[Post New]](/forum/templates/default/images/icon_minipost_new.gif) 01/03/2010 17:30:30
|
peadar
Initiate
Joined: 01/03/2010 17:08:43
Messages: 17
Location: ireland
Offline
|
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
|
peadar |
|
|
 |
![[Post New]](/forum/templates/default/images/icon_minipost_new.gif) 02/03/2010 09:52:33
|
mlohbihler
Master
![[Avatar]](/forum/images/avatar/eccbc87e4b5ce2fe28308fd9f2a7baf3.png)
Joined: 01/03/2007 22:48:52
Messages: 1847
Offline
|
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.
|
Best regards,
Matthew Lohbihler |
|
|
 |
![[Post New]](/forum/templates/default/images/icon_minipost_new.gif) 02/03/2010 10:14:39
|
peadar
Initiate
Joined: 01/03/2010 17:08:43
Messages: 17
Location: ireland
Offline
|
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
|
peadar |
|
|
 |
![[Post New]](/forum/templates/default/images/icon_minipost_new.gif) 08/03/2010 07:13:31
|
narenblr
Initiate
Joined: 06/10/2009 01:17:36
Messages: 28
Location: Bangalore, India
Offline
|
>>> 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?
|
|
|
 |
![[Post New]](/forum/templates/default/images/icon_minipost_new.gif) 08/03/2010 11:56:53
|
peadar
Initiate
Joined: 01/03/2010 17:08:43
Messages: 17
Location: ireland
Offline
|
thats right. Using the http publisher feature. Just made sure all the parameter names match and it all works seamlessly...
|
peadar |
|
|
 |
|
|