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.

It looks like you also deleted /opt/mango/ftl You could copy this directory from a complete Mango

@phildunlap said in Mango v3: exact thanks phildunlap , what i meant is if i installed mango service on a virtual operating system (lets say windows server 2012 on vmware environment) will mango handle communicate with mod-bus serial devices. regards;

@Desmond if you didn't already hear, we have released v3 - https://forum.infiniteautomation.com/topic/2741/mango-automation-3-0-released

Also take a look at the "date pickers and presets" example.

@fenyoster That was the problem, as you said! The double slash is failed! jdbc:mysql:// Many Thanks! Best Regards, Fenyo

Good suggestion. Thank you.

It would export without errors, but one of the items in the list of points would be the text: "dataPointId":null I was just curious if that was related to the issue. Glad you got it working!

This issue has happened again, and the same folder caused the problem. ASCII File Reader has been off for a long time, so that did not prevent the issue from re-occurring. edit: This is happening on Mango v3, but not on Mango v1 or on an Ubuntu install.

When you are using the Mango NoSQL database the data is not stored in the pointvalues table and rather in the NoSQL database. See this video for more information: The .data files are the NoSQL files where the data is stored. The number like 692.data refers to the date range within the file and the folder number it is in is the data point ID that relates to the dataPoint table. http://help.infiniteautomation.com/support/solutions/articles/14000022517-enterprise-nosql-database

Hi Felicia, I'm still not sure I understand. Why couldn't you use the XID field in the manner you are describing?

Hi Desmond, The SQL data source allows you to pull data from an SQL database table into data points, and then you could do anything with that information you could do with any other data point. I would consider the solution in (1), but I wonder what data you are storing in the jsondata table that you would be pulling into Excel? Why would you choose to place the data there, as opposed to in data points? If you really want the raw text from the table, you could be saving that information directly into an Alphanumeric virtual point and then pulling that into Excel.

I would check to make sure that you are using Oracle JDK rather than OpenJDK. Mango will work with OpenJDK but I've noticed that things run slow. The speed of your database and how many data points & events you have in the database can have an affect as well. We are planning to release Mango 3.0 in the next couple months that will have a whole new UI which is much faster and offer many more features. We should have a preview of this soon.

ASCII File is the simplest (line by line regex). SSH can read files too. The Data File data source can import files whole.

Hi Mircea, Submit the GUID and MangoES serial number if you have it at: http://infiniteautomation.com/index.php/support?layout=edit&id=50

Thanks this worked.

@phildunlap Thanks Phil, I wrote an excel sheet that automated the alias generation. I'll check out that ftl file and see what I can do.

Hi Mircea, This has been a known issue for a while: https://github.com/infiniteautomation/ma-core-public/issues/760 it looks like it may be fairly simple to fix.