Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

The information in your link appears to have allowed me to connect with a slight change. I had to change integratedSecurity to false, when it was true I got the error com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. For others out there who may be attempting to connect to a MS SQL (in this case 2008), here are the settings that worked for me. Driver class name: com.microsoft.sqlserver.jdbc.SQLServerDriver Connection string: jdbc:sqlserver://10.165.3.192;database=ExternalLog;integratedSecurity=false; Username: database login UID Password: database login PW Of course, you'll have to customize the connection string to your database server name/IP and database name. Thanks Matt!

How do you know? What error are you getting?

New adjust: Update period = 50ms Timeout (ms) = 100ms retries 2 test with Modbus read data: No response from slave 1 Enable Data Source and Data Points with 1 slave and work fine. Enable Data Source and Data Points with 2 or 3 slaves and i get the follow message: 'Data Source': com.serotonin.modbus4j.exception.ModbusTransportException: com.serotonin.messaging.TimeoutException: request=com.serotonin.modbus4j.serial.rtu.RtuMessageRequest@42ea05a3 get updated readings in 2 second changing retries = 0 sometimes with any munber of slave , when i set some data point, the message triggers again. get updated readings in 1 second In the slave, all routines are executed in 20ms.

Still not sure i understand, but maybe you need something more like this: Float.intBitsToFloat() If not, maybe you can post an example of exactly what x and y are, and what you need them to become.

Mango doesn't not require an internet connection to be used so I'm not sure what the issues is. Are you using a Modbus Serial or IP data source? The modbus serial has a selection for ASCII or RTU under the data source create page. Both serial and IP have a character encoding option for the data points but it depends on the modbus data type drop down list.

Hi Antsu, This is a great question. The data import tool will work but will be a bit time consuming. Do you know how many rows of history data there are for each point; can you export the entire history and view it as csv in excel? Another option would be to export just the pointValues table from the mysql database and import that into the new MA mysql database, the problem is that dataPointid reference may not match up by default so you would need to go through and make sure they match. I've played around with this awhile ago and it can be a bit difficult to get right. Look at the dataPoint table in your old version and the the new version and make sure the id matches. I believe that Mango created the data point ID based on the order it is imported so you can rearrange your data points in your import text so that the point ID's are created the same as in your old version. This is all very theoretical so would like to hear back if any of it works for you. Joel.

oh, wait, this is the forum's ping session

Hi, I'll be available tomorrow after 10 am Colorado time on Skype we can do a screen share if you want to get this all working for you. Thanks, Joel. Skype: Infinite.Automation

Well, we'll look into fixing the script so that spaces aren't an issue, but it seems like 1. may be necessary, yes. Rather than having MA run within Tomcat, we switched things around so that the web server (Jetty) runs within MA.

Thanks Joel, That worked perfectly. Using that information I was able to use the HTML to display large labels too!

Thanks Matthew, that worked and I am back working again. Now to go try and figure out the font stuff Joel gave me.

Well, it's a short term solution with a potentially painful future. You should really be creating modules for everything outside of overrides. If the core doesn't have the hooks you need then we'll add them.

Hi Andrew, If I understand right you want to duplicate the data source, graphic view and watch list for another site within the same instance of Mango. Each point has a device name which is different than the data source. You can edit the device name on the point details settings. By default the device name is set to the name of the data source but if you change the name of the data source it doesn't change the device name. There have been a few improvements in Mango Automation 2.0 from the version f M2M2 that you are using. When you copy a data source you can choose the new data source name and device names before it is created. You can also copy graphic views. You would still need to edit the new graphic view for the new data points. We also have the DGLux dashboards where you could have one dashboard set up for a site and then with a button you could change which site the dashboard displays. So it's one view that changes the data feed. You can get the new files and test them out if you want at:http://infiniteautomation.com/index.php/downloads-categore-list.html if you like them you can then upgrade, just make sure you back everything up before you upgrade in-case something goes wrong in the process. Joel.

This will be fixed in version 2.0, which should be available soon.

@mlohbihler said: Yes. When you delete points the data is "tombstoned", and later purged by a background process. The "null" values showing up there is a bug. Thanks for pointing it out. Ok. Thanks Matthew.

Yes. M2M will be replaced with Mango Automation (nee M2M2). All 1.13.x changes are being ported to that product. It should be ready soon.

Thank you.

Currently, no. Some form of templating will probably make it into Mango Automation soon though.

When I create a new datapoint on a virtual or vmstat data source (but not modbus), there is an error that occurs with current version of chrome (20) but not firefox (13) "can't read property 'style' of null" is the error message, it comes from engine.js. I tried upgrading to dwr 2.0.10 and this didn't resolve, and dwr 3.0 was more than a straight drop in. Chrome 20 with mango 1.7 exhibit the same problem, but I don't believe I ran in to this problem with earlier versions of chrome.

Hi Matthew, I totally agree on the points that you mentioned. I did as I said in my original post and dumped the events table without data from the MySQL data base. I then reimported the empty events table and all works well. Would be nice if the "users" could do something similar as you suggested via "ack all" if They Know What They Are Doing... but that would only be convenience in this case. Marking as solved since there is no priority and procedure works in the few cases where an "ack all" is needed. Thanks Michael