Hi Pradeep,

it is probably possible to exchange data with a Sqlite database using the SQL datasource. Google suggested to me the driver: org.sqlite.JDBC and a connection string: jdbc:sqlite:/path/to/database ... We did not include the jar for Sqlite on the classpath. You will want to add that jar to Mango/overrides/lib/ so that the driver is available. If you are using a Linux system, I would suspect so, as it will still have an addressable file location for the connection string.

Hay
that's awesome. do you also know any other way to push data from mango to excel?

Thank you
PD

Great it did work !!

much appreciate the advise.
I think, I started using Mango M2M (the great Scada product) around 2010. My gratitude goes to the developers.

When I installed Mango on Windows it did work like a charm, but every time I tried installing on Ubuntu gave me a headache. finally I did manged to install on a Ubuntu server (I don't want to allocate more resources just for running a server)

The reason I want to install Mango on Ubuntu desktop version is the Gambas3 is another opensource SDK.

when I did some google research I found that ScadaBR which is a derivative from Mango M2M, but easy to install, and I can install it on Ubuntu desktop.

What soever I still love Mango M2M. much appreciate that if you can direct me to sort out the Mango Ubuntu installtion issue. I know this Forum is not for discussing installation issues.

Anyway thank you once again for helping me
Have a great day !!

There are some very brief but adequate instructions here:
http://store.infiniteautomation.com/core

Mango is just a Java application, so the actual 'install' of Mango consists simply extracting files from a .zip file into a directory of your choosing. That's it!
What you are probably asking for is a step by step guide to installing Ubuntu and the Java JVM, which are both products NOT made by serotonin software, which is why you won't find an install guide! :-)
Otherwise Serotonin would have to make a million guides for every different possible system configuration that anyone might want.

I would suggest that if you need a step by step guide, try searching for these things:

*"How to install Ubuntu 13.10 server"

"How to install JDK6 on Ubuntu 13.10 server"

"How to unzip file in ubuntu"

"How to run .sh file on startup in ubuntu"
*
..Etc.

You could even make a note of the steps you follow and post them here to help others in future.

Hi,

Scripts in MetaPoints:

Context's points - you can add some points to your MetaPoint for access from script. Final value - result, have to save with commnad return value. You cannot save value to other points from script You cannot get others values from points, only last value. You cannot take previous value from Metapoint in your script without simple hack.

Hack for previous value from MetaPoint

create your metapoint with some simply script save your metapoint and activate it and activate datasource - green light go to another screen on Mango - views, lists and return back to MetaDataSource and metapoint. Now you can add this metapoint as source point for your script. disable alarm level - Context point disabled = NONE

I am working in ScadaBR, clone of Mango. Yesterday I modified MetaDataPoints and I added new functions for scripts - last(limit) ... gets last point values and list(from, to) ... gets list of values between ....
It works good.

Attachment: download link

You will first need to define a Modbus data source and add your two points to it. Then take a look at the Meta Data Source. You can use the two modbus data points as input to a meta data point that combines them using javascript.