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.

Thanks Philip

Stefano,

There is no tool built into the NoSQL module to export the data to an SQL database. Depending on your level of technical skill you could extract the data from the REST api and then import it into an SQL database using many 3rd party tools.

If we are talking about converting data from a Mango instance running on NoSQL to a Mango instance running on MySQL:

You could try to export and import the data using export and import as CSV functionality. You could publish all the data to a new instance running on MySQL using the Persistent TCP module There would also be ways to write Meta Data source scripts and Scripting data source scripts to do this, this again is quite technical so I won't go into it here.

Hi guys, I forget to feedback on your support, the solution you give to me worked like a charm!

Thank you very much!

No worries, the data file data source probably requires the most Java knowledge outside of writing scripts that invoke the code. Even then, the scripts get to benefit from JavaScripts willingness to store any ole' type into a variable, where everything needs to be properly typed and declared in the data file classes. Tricky when there are but few examples and it's closed source!

I would guess there was an informative event raised about a failure to instantiate the poll class, but I couldn't say.

@terrypacker said in Mango API POST /rest/v2/point-values - Import Point Values:

The git issue that was closed was because the task was too overwhelming and not high enough priority.

Apologies Terry, I was unaware what a cluster#$%^ this was. Thank you for your assistance with this, I'll get onto to having a read and will see if I can be of some assistance

Fox

@jleblancmango OK got it to work, when I figure out what I messed up then fixed I
'll post it

I think so, but not sure why we wouldn't see it as well. Maybe a plugin or something?

Can you check the SVG to see if that downloaded a zero pixel plot area (i.e. the <svg> opening tag's height and width are 0)? Maybe try clearing the browser cache?

Hey, Phil!
I know, many thanks for your lots of answers.

Yes, They are stored in the same property on the point locator because they can be. If a numeric point, the value format is interpreted as a java.text.DecimalFormat, and if binary it is simply string matched with what is captured in the value regex (capture group 1)

Perfect! I figured that was the case, just wanted to make sure. I had gotten the last part wrong though, so thanks for explaining that!

That definitely seems like it would be part of the problem. I'm not sure why the POP3 data source didn't expose the port as an option, it's certainly easy to do, so I have opened a git issue about this in the repository the module is in. Somewhat impassable issue until that is configurable

Alright then, I'll be waiting.

Thanks again! Greetings.

The file called Mango Wireshark between 2019-10-03 1904PM to 2035PM I saw it in. Too large for email, as it was when you sent it!

We can see frame 170715 for instance is sent but no Segment ACK is sent in response to it. I don't know if BACnet4J would wait to send the completing fragment until after receiving the ACK, but that's what appears to be happening. We can then see the six second retries. I'm not sure why the request in question is being sent out twice in rapid succession, though.

Feel free to get things running again.

The only thing that occurs to me is that the Mango/databases/mangoTSDB/*/{dataPointId}/{lastShardNumber}.data.rev file could be interesting, but if you already read from the point or whatnot that may have been repaired if it was to do with corruption. You would see something about that data point ID in the Mango/logs/iastsdb-corruption.log file if it had something to do with corruption. May be interesting to check that, too.

Hi Phil, Video is called "Auto Login on Mobile Devices" .
Link is: .

Cheers,
rick

Hi Ian,

You maybe could do it with an HTTP JSON retriever or receiver - you link does not explain the protocol you're trying to interface with. If you have an authentication token you can probably do it with the retriever, and if you can configure it to push messages to your Mango at the /httpds URL
you may be able to use the receiver.

Given that it brings a login screen, you may be better off using a scripting data source with the HttpBuilder doing the HTTP, as you can do more arbitrary things, such as logging into the service. This thread has an HttpBuilder integration with an API: https://forum.infiniteautomation.com/topic/2999/intesis-integration/2

You may also need to use something like var response = JSON.parse(content); in the response function.

Documentation here: https://help.infiniteautomation.com/about-mango-java-script

That is what we were suggesting. I did check the validation a little before suggesting it and thought it should work, but I didn't try it.

Thank you for submitting the capture. We are looking at it and will let you know what we find.

Yes, a couple of people have complained about excel doing that. If you are working on the latest version of mango you can edit multiple data points at the same time which in most cases, you will not need to export and edit.

If not you should use libre office instead of excel. it handles CSVs much better than excel. Another option is to use VS code text editor. You can highlight a text, right-click and choose change all occurrences.

I sent you an email. I was not able to replicate an issue with two data sources sharing a modbus serial connection and disabling them. No it is not the expected behavior.

The JSON Retriever is working great, it is very handy for someone like me that is not that well versed web programming. I really like these kind of wrapper-like data source which make things so much easier.

Glad to hear it!

For an alphanumeric point, I would expect that message if the value at the JSON pointer is not a textual value (a number, null, boolean, etc) sometimes.

@phildunlap Thanks Phil! The naming was just for show, it's named differently in our system for the exact reason you gave. Thanks for the note about permissions, fixed now.