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 datapoint synchronize datasource in mysql datasource.rather than time.
-
if mysql as datasoruce.how can synchronize the data source. (for example,when insert into a row data ,the datapoint will add a row.Rather than the time to change. That is, the data about the changes in the source data, the corresponding data points are also changed, rather than minutes, seconds, to collect data.
-
Hello Edmund,
The data points created from a MySQL data source has a setting for the time over ride. Enter the column name of cell that you want to use as the timestamp. Then in the Logging properties section choose "When point timestamp changes" from the Logging Type drop down list.
I hope this helps.
Cheers
Brian
-
but when I use your way for test .and I find have no data was displayed.as attachment.
https://www.dropbox.com/s/2hmbl8y2hdk0etu/1.jpg?dl=0
I donot know whether my understanding is error.when I want to get to 'w'data for mysql.and it is normal from mysql.but when I input 'datetime' in Time override column,datetime is column in mysql. or I try to input 'id' in Time override column.the result is same .no result be display.
-
Hello Edmond,
How is the timestamp formatted in the datetime column of your MySQL table? Our system is set to use: 'yyyy-mm-dd hh:mm:ss' It may not work if your datetime column is formatted differently from the Mango system.Cheers
Brian
-
As attachment https://www.dropbox.com/s/g3h5mtywr3jljyq/2.jpg?dl=0
the format is same as mango.
-
Hello Edmond,
I am sorry, I am not sure why it is not working for you as it is for me. I hope someone else can help you with this. -
Hi edmond, can you post your select statement from your SQL data source? What datatype of sql column is your datetime?
