Thanks for the help I am navigating through the new UI and getting most of it to work as I need. I was able to get the DS import working.

One last question about the JSON importing. I create the Excel reports normally by exporting the report template in csv then manipulating the references in Excel and then back in again using the csv import. How should I now get this excel Report template exported to a csv format and re-imported back into the system as an excel report template?

@Phillip-Weeks I just implemented a Scripting Data source that runs this script and see no errors on Mango 3.6.6?

var dataPoints = JSON.parse(JsonEmport.dataPointQuery("eq(name,Voltage)&limit(1000)")).dataPoints; print(JsonEmport.dataPointQuery("eq(name,Voltage)&limit(1000)"));

I am searching for a point named Voltage

Output:

"dataPoints":[ { "xid":"voltage", "name":"Voltage", "enabled":true, "loggingType":"ON_CHANGE", "intervalLoggingPeriodType":"MINUTES", "intervalLoggingType":"INSTANT", "purgeType":"YEARS", "pointLocator":{ "dataType":"NUMERIC", "changeType":{ "type":"BROWNIAN", "max":100.0, "maxChange":0.01, "min":0.0, "startValue":"1" }, "settable":true }, "eventDetectors":null, "plotType":"STEP", "rollup":"NONE", "unit":"V", "simplifyType":"NONE", "chartColour":"", "chartRenderer":null, "dataSourceXid":"DS_997094", "defaultCacheSize":1, "deviceName":"Dashboard Demo", "discardExtremeValues":false, "discardHighLimit":0.0, "discardLowLimit":0.0, "intervalLoggingPeriod":15, "intervalLoggingSampleWindowSize":0, "overrideIntervalLoggingSamples":false, "preventSetExtremeValues":false, "purgeOverride":false, "purgePeriod":1, "readPermission":"user", "setExtremeHighLimit":1.7976931348623157E308, "setExtremeLowLimit":-1.7976931348623157E308, "setPermission":"", "tags":null, "textRenderer":{ "type":"ANALOG", "useUnitAsSuffix":true, "format":"#.00" }, "tolerance":0.0 } ] }

The cause must be specific to your system. Perhaps that specific point is corrupt? Try another point and if that doesn't work take a look at the logs and see if anything is being output about the error.

Thanks.

@phillip-weeks said in Bulk edit is giving Validation Error:

No BULK edit feature working is a pain since I the export for csv was removed .

There is a bulk edit feature It does work

@phillip-weeks said in Bulk edit is giving Validation Error:

So am I doing something incorrect here?

Yes, it sounds like you are. Check the value of the action column is set to the correct value, it should be CREATE, UPDATE or DELETE. For CREATE you can either set the xid column or leave it blank to autocreate an XID. For UPDATE you should set the originalXid column and the xid column (this is so you can change the XID of points). For DELETE you only need to set the originalXid column.

<div ng-init="dateBar.from = ('2019-12-08T09:16:47.297' | maMoment:'toDate')"></div>

@Phillip-Weeks just a little more info would be helpful for me to pinpoint the Mango code in question.

Are you using NoSQL? What is this script from? Context point in a script? Where is the script? Meta point, Excel Report...

I did a quick check of our database queries and they are correct. I can't see the data you are referring to in the image as that is only a window for times that are not in your test.

Also its nice to put a code block around code as it makes it easier to read.

Thanks.

Thank-you guys .. lots of useful info :)

Perfect thanks Phil

Sorry guys I was not thinking about this correctly of course the watchlist parameter is saved with the default value to the parameter. I was confused. :(

@jflores13 said in Help Using <ma-map & <info-window:

Tried powercycling the MangoES but nothing changes, still blank side menu and weird behaviour in general. Everything is taking way longer to load. Also, in the new data sources page, now my data sources are "not supported yet", not even the virtual data sources. I get multiple errors like this one when loading a data source's page:

OK no idea why but it appears that it can't load the module Javascript files from the backend. Check your Mango instance CPU and memory usage and also disk space. Unless you are just on a shitty connection to the backend?

See if you can get here - /ui/administration/json-store-editor/mangoUI-menu
And post up the contents.

And yeah maybe create a new thread about this.

Certainly! Glad you figured it out!

Glad you got it figured out!

Unknown how this modbus details got into the persistent DS to start with?

These are the points that you emailed about wanting to recreate because they were missing from your backup, yes? If so, then surely you must have created them somehow. Offhand the only way I'm aware of to skirt type checking on points is to insert them via SQL. How did you create the points?

Great. I might look at adding some more options to prevent them appearing and disappearing too quickly.

Success Terry, it was a capital I in an if statement within a script that was causing the invalidation.. Got it working between excel and open office I got it to preserve the " and all but I get what you are saying about not being strictly required and It probably works in Excel too
Thank-you for all your guidance here. The new UI scares a bit me if I can jump back to the legacy screen. lol

@iperry said in Upgraded to 3.6 & Getting error when saving script:

I like the white background when using applications as opposed to the black/grey of the newer layouts (not just Mango) but that is just my preference.

Check out the UI settings under Administration, you can configure the color scheme to your liking.

Great to hear there is nothing holding you back from using the new UI. Please do create a new thread if you find something that could be improved.

You can also use another search engine if you prefer. You can add the term site://forum.infiniteautomation.com while googling, for instance.

OK Thank-you,
I will clear these and rebuild it per this 255char constraint

Hi Phillip,

There's not a simple mechanism I'm aware of for this. The status outputs for the data source and publisher both output packet counts, which don't reflect actual transmitted bytes in all situations (some packets may have fewer values, some packets may have more effective compression, etc). I think if I needed to form a first order approximation of that, I would compare something like ifconfig output from one day to the next via an SSH data source or write that to a file via cron and use the ASCII source. Then the number would at least reflect actually transmitted byte counts instead of uncompressed byte counts.

Put the ng-repeat inside it's element, but make sure that is surrounded by the div with a class of:

class="ma-designer-root"

I've also found it handy to give this div a sensible ID (ie not a UUID generated one) on which you can start doing some styling.

EG:

<style> #main { width: 100%; height: 100%; padding: 0; margin: 0; } </style> <div class="ma-designer-root" style="width: 1366px; height: 768px; position: relative;" id="main"> <p ng-repeat="(name, age) in {'adam':20, 'amalie':22}">{{name}} is {{age}}</p> </div>

HTH

Richard