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.
Update on saving NoSQL data to MySQL
-
Re: Migrating NoSQL data store license from one Mango instance to another
Is this feature available now? (i.e. Save NoSQL to MySQL or even CSV)? -
No that was never written. One can do either, but one would have to use a scripting data source and perhaps supporting points to make it happen.
//Export all data for point cxtPnt into an SQL table... var pvd = com.serotonin.m2m2.Common.databaseProxy.newPointValueDao(); pvd.getPointValuesBetween( cxtPnt.getDataPointWrapper().getId(), 0, java.lang.Long.MAX_VALUE, function(pvt) { sqlContextPoint.set('(' + pvt.getValue().toString() + ',' + pvt.getTime() + ')', pvt.getTime()); //sqlContextPoint is an 'update tables only' point on an SQL data source });And there would be a similar way to write those out to a file or wherever.
