• P
    pradeepdissa

    Hi,

    1. I would like to know if I can read and write Sqlite data base via SQL data type in mango
    2. if it is possible what is the driver class name and connection string
    3. If I install the sqlite database in RAM for fast access of data, still can I connect to that from Mango and how?

    thanks

    posted in How-To read more
  • P
    pradeepdissa

    Hi all,

    I am looking forward to establish Modbus TCP communication between OpenAPC software plc and Mango. However yet no any success.

    In any case if this is not possible please advice me any opensource / free software plc that I can use for developing my my program and to use Mango as my HMI front end.

    my requirement is as follows:

    Modbus I/O Module <========> Software PLC <========> Mango M2M

    Any response is highly valued.

    PD

    posted in How-To read more
  • P
    pradeepdissa

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

    Thank you
    PD

    posted in How-To read more
  • P
    pradeepdissa

    Thanks Joel
    As always you are helpful

    PD

    posted in How-To read more
  • P
    pradeepdissa

    Hi team,

    I want to know that how to set up mango m2m to communicate with Ms Excel.

    ie. my automation program is a n excel program (VBA) and I would like to use Mango as the modbus TCP gateway and Scada HMI.

    for this reason I need to establish a communication between mango and excel for both data read and write.

    I have done this previously with Siemens Desigo using Direct Data Exchange (DDE).

    your support is highly appreciated

    Kindest regards
    Niro

    posted in How-To read more
  • P
    pradeepdissa

    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 !!

    posted in How-To read more
  • P
    pradeepdissa

    Hi Joel,
    thanks for the quick reply

    I had a look into both documents you mentioned at the beginning.
    my requirement is not to have entire mango data base on MYSQL.

    I want to:

    1. setup MYSql data source In data sources. (this step is successful)

    Sql prop.jpg

    1. I can update values into the MYSql database using update statement ,but I don't know that how to read a value from MYSql database into Mango (the statement)

    I tried several ways eg:

    typing "SELECT ......" statement inside the update query area (I may be silly because it self says that "Update statement"

    without typing anything inside the query area.
    nothing is successful. below is what I get

    output.jpg

    Your advice is highly appreciated

    Regards.

    posted in How-To read more
  • P
    pradeepdissa

    Hi I am trying to setup MySQL data base for reading and writing data point values.
    So far I found the method to write data in to the MySQL data base (using "watch list") but I can not find a way to read data into "watch list".
    when I press the statement test button ("Execute" button) in SQL properties page I can see my data. Please help me to configure this .

    Summary:
    what I need is, using a Gambas3 program I will update or read a table in MySQL database (control or monitoring points). I want to use the same database and same data points in mango Scada to read or control

    Thank you all

    posted in How-To read more