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.

Hi etantonio, It is already stored as a file in the Mango/web/modules/excelReports/web/report-data directory with the runtime and template name composing the filename. No, there is no feature to do this currently. You would have to manually export it to CSV from within Excel. We do have some intentions to rework both the Reports and Excel Reports to combine parts of their functionality and I suspect this feature will come up when we do. I'm not sure. I suspect it's related to your browser's locale. I'll explore that a little.

I believe YAJSW should work on Windows XP, but glad you found a solution!

From that statement alone I don't know what you are trying to do. If you haven't seen it, you can set the annotation and the timestamp with the set value. There are three set functions on context points: set(value); //set the value at the timestamp that triggered the script //set a value at a timestamp. If the "saves historic" is not checked on the scripting data source, this will // go through the DataPointRT's savePointValue method, which has some logging subtleties set(value, timestamp); set(value, timestamp, annotation); //just like previous, but with annotation as well So a meta point could have a script like, my.set(p1.value, p1.time, "custom-annotation"); return UNCHANGED; Which would have the meta point have the same value at the same time as the context point, but with the custom annotation.

What exactly are you trying to export? There is a blob column in the data points database table that will make a raw select somewhat difficult to read. Do you really mean to export points, or do you need to write a CSV of point values? Here's a thread where a script reads from CSVs. One could use writers instead of readers to output a CSV instead: https://forum.infiniteautomation.com/topic/2970/is-it-possible-to-read-several-csv-documents-by-scripting Or, if i get a better grasp on the export you're looking for, there's almost certainly a more direct way.

thanks, phildunlap

@phildunlap said in API Docs: No luck :( I've branched this off to it's own thread for clarity, https://forum.infiniteautomation.com/topic/3423/retrieve-last-12-hours-of-data

Hi Peter_John48115, welcome to the forum. I have no idea what you're asking. That appears to mostly be a copied portion of my second post. Were you asking for some clarification?

sorry, I swapped Master ans slave, thanks for proposals, I will try modbus publish function.

You might have to bridge the ethernet adapter on the mangoES with the usb WiFi adapter into br0 then give br0 the ip address of the mango instance. Then you should be able to see the machine from either interface. The default ethernet ip on mine is set in /etc/network/interfaces.d/eth0 You would have to create a bridge interface, add the eth0 and wlan0 or whichever interface it comes up as to the bridge, then give the bridge the IP Address. Cheers Dan

Hi ristola, You can inspect those elements for the CSS class that is creating that checkered pattern, and then add that class to the attribute you'd like it displayed on via an ng-class attribute, like, <div ng-class="{ 'point-disabled': slaveMonitor.value === false }"></div>

@jared-wiltshire Thanks Jared, that works. The upper image the is original, lower image is the modified, both spinning. [image: q1Gpafq.png]

yes, people may need that point status value to control a .gif etc. how about to feedback 0 or some special value for point value to indicate communication failed?

Hi petermcs, I have limited experience in trying, but I believe the answer currently would be "possibly, but only through scripting data sources." I believe the property ID number will be set in your device for the custom property, so if you create a property identifier with the number you have assigned to your custom property, the read may work. In this thread, https://forum.infiniteautomation.com/topic/3117/bacnet-scheduler/5 I got the weekly schedule property identifier, but I could also have instantiated it like, var proptertyIdentifier = new com.serotonin.bacnet4j.type.enumerated.PropertyIdentifier(678); //new property identifier for property number 678 I think you could have it work through the API if you modified com.serotonin.bacnet4j.type.enumerated.PropertyIdentifier to include your custom property numbers, and throughout Mango if declared that and associated to data types and whatnot in com.serotonin.bacnet4j.obj.ObjectProperties

Glad to hear it!

You have created that dashboard in the Dashboard Designer, yes? If you create a menu item as described in the thread I linked to, that menu item will appear in the list of pages for the button to link to, even if you don't have it displaying in the menu.

No. If your disk is full the streams that output to the shards probably only flushed a portion of their contents, leading the last sample in the shard to be incomplete. The database would detect this, and then it would corruption scan it while running as required. Now, if it says BufferOverflowException in the corruption error, then the cause is the same but you will have to use the env.properties setting db.nosql.runCorruptionOnStartupIfDirty=true and restart Mango to repair that particular shard. I imagine we'll handle that case automatically before too long, but it's somewhat uncommon.

Or, if you only want to delete information events, you could set the purge period for those events in the purge settings to be very short and then "Purge now using purge settings" will clear that, or you can wait for the nightly purge to take care of it.

Hi Neves, If the BACnet data source in Mango is running when the panel starts, it should respond to the panel's WhoIs with an IAm. If not, I would wonder if the bind address settings for your local device doesn't get the message at the broadcast address the panel is using. But, that's assuming it's BACnet IP. on MS/TP it should definitely respond if the serial settings are right. Which is it? Also, it sounds like you are able to poll the device if you can get the device object list. So, what's not working? I can see how should Mango restart the panel would need to send another WhoIs if indeed you must respond to its request which Mango should handle if the BACnet data source is running when the WhoIs bounces around the network. I didn't test this and am not sure it does what you want, but I think it would send an unsolicited IAm if it was aware of the device already, (run this in a Mango scripting environment, it will send the request even when the validation button is hit if you've changed the data source xid and device instance number accordingly) //Get the local device config from a configured bacnet data source. var localDeviceConfig = com.serotonin.m2m2.db.dao.DataSourceDao.instance.getByXid("DS_354e2188-4867-431b-9051-bca39b011ed7").getLocalDeviceConfig(); localDeviceConfig = com.serotonin.ma.bacnet.device.LocalDeviceDwr.getLocalDevice(localDeviceConfig); var localDevice = com.serotonin.ma.bacnet.device.LocalDeviceFactory.getLocalDevice(localDeviceConfig, null); //print(localDevice); //Send the request to device number 1234... var remoteDevice = localDevice.getRemoteDeviceBlocking(1234); try { localDevice.send(remoteDevice, localDevice.getIAm()); } finally { com.serotonin.ma.bacnet.device.LocalDeviceFactory.releaseLocalDevice(localDevice, null); } Hope that's helpful. If that is what you need to do, which I'm somewhat suspicious of, then we can talk about trying to detect the panel's restart and then send this message from an event handler. But, I think the local device should have replied to its WhoIs without effort were everything configured ideally.

Huh. Thanks for sharing what solved it for you!