There is no direct upgrade from Mango M2M 1.13.0 but you can export your JSON configuration and import it into your new Mango Automation 2.2.2. For graphic views there are a few modification you need to do with a find and replace on the JSON. The MA importer will pride you with some error and tips for what needs to be corrected. You can also email your JSON to us and we will modify it to be compatible with MA 2.2.2.

If it's really important to also move over your history values it is possible but it's a much more difficult procedure involving copying data between the pointValues tables.

Joel.

It's in the user settings page for Mango 2.0.6/2.0.7. I can't speak to previous versions.

here is one simple example:
one day one PARTITION

alert table pointvalues
PARTITION BY RANGE (ts) (
PARTITION b140601 VALUES LESS THAN (1401552000000),
PARTITION b140701 VALUES LESS THAN (1404144000000),
PARTITION b140801 VALUES LESS THAN (1406822400000)
PARTITION b140801 VALUES LESS MAXVALUE
)

Most of the available data is documented in the help question mark on the page. I went to the source code for the 'firstValue' attribute, which is not listed in the help document. The public repo can be seen at www.github.com/infiniteautomation

Hi, I am using the following to get the temp from an NTC

T = t1.past(MINUTE).average; THERMISTORNOMINAL = 10000; // temp. for nominal resistance (almost always 25 C) TEMPERATURENOMINAL = 25; // The beta coefficient of the thermistor (usually 3000-4000) BCOEFFICIENT = 3435; // the value of the 'other' resistor SERIESRESISTOR = 14910; average = 1023.00 / T - 1.00; average = SERIESRESISTOR / average; steinhart = average / THERMISTORNOMINAL; // (R/Ro) steinhart = Math.log(steinhart); // ln(R/Ro) steinhart /= BCOEFFICIENT; // 1/B * ln(R/Ro) steinhart += 1.0 / (TEMPERATURENOMINAL + 273.15); // + (1/To) steinhart = 1.0 / steinhart; // Invert steinhart -= 273.15; // convert to C return steinhart ;

Trouble is that when even for the past one hour where there is **NO **t1 value received, the average function still returns the average based on whatever was stored earlier. I was expecting that in case of no data, the average function based on time would return a NULL.

Any thoughts / suggestions ?

Recently i have started getting graphs rendering only half in the** data_point_details.shtm?** page. I.e. only the top half is rendered, the bottom half in completely blank.

how do i troubleshoot this issue?

Ah, i didn't know you were using Derby. Could have been just a load issue?

Joel, Bob - thanks for the deatils. the hw you have pointed to looks impressive, but is way too expensive for what i have in mind.

Let me elaborate, i am looking for something very simple like a 2 relay device which can be controlled over wireless directly by mango. someting < $30. Looking at the links you have posted and also my own googling, this seems highly unlikely.

this triggers an idea which i want to bounce off you. Using Arduino and the Rf modules which come for it, do you think it is a practical possibility to implement the MODBUS serial protocol over wireless using nRF24L01 modules and arduino MCU? I wanted your opinion on the praticality before i start investing some time in taking this forward.