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, all
I have a story to help. Scripting control to publishers. Want to write control scripts for publishers By enabling / disable the publisher
such as
1.Scripting control to Data sources.

var d = 'DP_835f4865-3de8-47cc-9c7b-3121b7a65bf9'; //Change to your data source's XID
RuntimeManager.enableDataSource(d);

2.Scripting control to Data point.

var d = 'DP_835f4865-3de8-47cc-9c7b-3121b7a65bf9'; //Change to your data source's XID
RuntimeManager.enableDataPoint(d);

I try to write like this and it is not available.

var d = 'DP_835f4865-3de8-47cc-9c7b-3121b7a65bf9'; //Change to your data source's XID
RuntimeManager.enablePublishers(d);

error RuntimeManager.enablePublishers is not a function

Hi All,
I want to write a script in Meta Data Source.What I Want
I want to get the last value of every 30 days, for example
2019-01-01 8:00 to 2019-01-02 8:00 equals 1 day
...
2019-01-30 8:00 to 2019-01-31 8:00 equals 1 day
And I will make all the values together.But I don't know how to write the script as I need them.help me please

@phildunlap MANGOES 16GB. How many datapoints are supported?

1.Are there any errors during startup in the log?
-I think there is no problem with booting because this system can work for 1-2 months. After about 1-2 months, this problem occurs.

2.What types are most of your data sources?

• 50 data sources (Modbus tcp and meta data source)

3.How many points do you have?

• 2000 - 3000 datapoint

Hi All,
I can not use MangoES Version 3.3.4. I went to see webmin found that CPU 100%. I'm not sure if this is a problem.I wanted to know what was going on and how to fix it to get back to normal.
Thank you.

@phildunlap Sorry,I may explain the problem incorrectly.The problem I found really was to download the Excel file.
Excel file cannot be opened because I download excel file without a file extension.

1.I want to know the problem is that MangoES v.3.4.4 or My Computer PC ?
2.How can I fix the problem?

pic1

pic2

I tried this pic1 and the script print OOXML but I can't dowload excel file like pic2. How can I do it?

@phildunlap I have tested it. Create an new excel template file and upload it back to it's not working. I use Firefox browser to load Excel file and it still does not work.

@phildunlap I use MangoES v.3.4.4. I'm using this template with other mangoES, I can use it normally.But I used to work with this can not be used normally as I attached the picture.

@phildunlap

1. upload template .xls or .xlsx cannot open
2. If I try to follow the 2, what do I do?

@craigweb Try changing the name to .xlsx. It works.
Is there no way to change the name?

Hi all,
I can't openan Excel file that has been Loaded. the loaded file format is not the format of the excel file.

@phildunlap @Jared-Wiltshire

Can not add tag data source
You should check the ma.log for an error when it says status 500. Offhand I would guess you should delete your Mango/work/jsp directory on the machine that is giving you that 500 error.

i check ma.log.

WARN  2018-06-15T19:35:26,493 (com.serotonin.m2m2.web.mvc.spring.exception.ExceptionUtils.logWebException:56) - 
REQUEST URL
http://192.168.100.199/data_source_properties.shtm

REQUEST PARAMETERS
   dsid=2


REQUEST HEADERS
   Cookie=MANGO80=1ufyl8p6kezag2myi5xleqv6a; XSRF-TOKEN=ef0c6800-d270-43a3-9c2e-e356f0e16a3d
   X-Requested-With=XMLHttpRequest
   Accept=*/*
   Connection=keep-alive
   User-Agent=Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36
   Referer=http://192.168.100.199/data_sources.shtm
   Host=192.168.100.199
   Accept-Encoding=gzip, deflate
   Accept-Language=th-TH,th;q=0.9
   Content-Type=application/x-www-form-urlencoded


REQUEST ATTRIBUTES
   org.springframework.web.context.request.async.WebAsyncManager.WEB_ASYNC_MANAGER=org.springframework.web.context.request.async.WebAsyncManager@1d0f7ea
   javax.servlet.error.status_code=500
   org.springframework.web.servlet.DispatcherServlet.CONTEXT=WebApplicationContext for namespace 'springDispatcher-servlet': startup date [Fri Jun 15 19:25:40 ICT 2018]; parent: Root WebApplicationContext
   javax.servlet.jsp.jstl.fmt.localizationContext.request=org.springframework.web.servlet.support.JstlUtils$SpringLocalizationContext@144ba27
   org.springframework.web.servlet.HandlerMapping.introspectTypeLevelMapping=false
   __spring_security_session_mgmt_filter_applied=true
   modulePath=/modules/internal
   org.springframework.web.servlet.DispatcherServlet.LOCALE_RESOLVER=org.springframework.web.servlet.i18n.SessionLocaleResolver@417648
   org.springframework.web.servlet.HandlerMapping.bestMatchingPattern=/data_source_properties.shtm
   org.springframework.web.servlet.DispatcherServlet.OUTPUT_FLASH_MAP=FlashMap [attributes={}, targetRequestPath=null, targetRequestParams={}]
   javax.servlet.error.exception_type=class org.apache.jasper.JasperException
   commPorts=[ - /dev/rs485-1]
   org.springframework.web.servlet.DispatcherServlet.FLASH_MAP_MANAGER=org.springframework.web.servlet.support.SessionFlashMapManager@2fdc6c
   lang=th
   lastUpgrade=1528942750
   availableLanguages=[]
   javax.servlet.http.HttpServletResponse=org.springframework.security.web.header.HeaderWriterFilter$HeaderWriterResponse@b405e4
   _csrf=org.springframework.security.web.csrf.DefaultCsrfToken@511d17
   __spring_security_filterSecurityInterceptor_filterApplied=true
   javax.servlet.error.servlet_name=springDispatcher
   javax.servlet.error.message=org.apache.jasper.JasperException: An exception occurred processing JSP page /WEB-INF/jsp/dataSourceProperties.jsp at line 78

I use MangoES. I can not open google map on mangoES. But I can test it on other MangoES. Can use google map.
I do not know where to set it.

Same Key API

Other MangoES

ma.log

WARN 2018-06-15T19:55:52,271 (com.infiniteautomation.mango.rest.v2.ServerRestV2Controller.postClientError:222) - Client error [user=admin, cause=Possibly unhandled rejection: {"requireType":"scripterror","requireModules":["https://cdnjs.cloudflare.com/ajax/libs/angular-i18n/1.7.2/angular-locale_th.js"],"originalError":{"isTrusted":true}}, location=http://192.168.0.199/ui/, userAgent=Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:60.0) Gecko/20100101 Firefox/60.0, language=th, date=2018-06-15T19:55:49.737+07:00, timezone=Asia/Bangkok] Error: Script error for "https://cdnjs.cloudflare.com/ajax/libs/angular-i18n/1.7.2/angular-locale_th.js" http://requirejs.org/docs/errors.html#scripterror at makeError (http://192.168.0.199/modules/mangoUI/web/mangoUi~ngMango~ngMangoServices.js?v=8e197a301817e1747ef0:39:108173) at onScriptError (http://192.168.0.199/modules/mangoUI/web/mangoUi~ngMango~ngMangoServices.js?v=8e197a301817e1747ef0:39:123472)
WARN 2018-06-15T19:55:53,068 (com.infiniteautomation.mango.rest.v2.ServerRestV2Controller.postClientError:222) - Client error [user=admin, cause=Possibly unhandled rejection: {"requireType":"scripterror","requireModules":["https://cdnjs.cloudflare.com/ajax/libs/angular-i18n/1.7.2/angular-locale_th.js"],"originalError":{"isTrusted":true}}, location=http://192.168.0.199/ui/administration/home, userAgent=Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:60.0) Gecko/20100101 Firefox/60.0, language=th, date=2018-06-15T19:55:50.346+07:00, timezone=Asia/Bangkok] Error: Script error for "https://cdnjs.cloudflare.com/ajax/libs/angular-i18n/1.7.2/angular-locale_th.js" http://requirejs.org/docs/errors.html#scripterror at makeError (http://192.168.0.199/modules/mangoUI/web/mangoUi~ngMango~ngMangoServices.js?v=8e197a301817e1747ef0:39:108173) at onScriptError (http://192.168.0.199/modules/mangoUI/web/mangoUi~ngMango~ngMangoServices.js?v=8e197a301817e1747ef0:39:123472)
WARN 2018-06-15T19:56:29,119 (com.infiniteautomation.mango.rest.v2.ServerRestV2Controller.postClientError:222) - Client error [user=admin, cause=Possibly unhandled rejection: {"requireType":"scripterror","requireModules":["https://cdnjs.cloudflare.com/ajax/libs/angular-i18n/1.7.2/angular-locale_en.js"],"originalError":{"isTrusted":true}}, location=http://192.168.0.199/ui/dashboard, userAgent=Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:60.0) Gecko/20100101 Firefox/60.0, language=th, date=2018-06-15T19:56:26.387+07:00, timezone=Asia/Bangkok] Error: Script error for "https://cdnjs.cloudflare.com/ajax/libs/angular-i18n/1.7.2/angular-locale_en.js" http://requirejs.org/docs/errors.html#scripterror at makeError (http://192.168.0.199/modules/mangoUI/web/mangoUi~ngMango~ngMangoServices.js?v=8e197a301817e1747ef0:39:108173) at onScriptError (http://192.168.0.199/modules/mangoUI/web/mangoUi~ngMango~ngMangoServices.js?v=8e197a301817e1747ef0:39:123472)
WARN 2018-06-15T19:57:10,753 (com.serotonin.m2m2.web.mvc.spring.security.MangoAccessDeniedHandler.handle:54) - Denying access to Mango resource /rest/v2/server/client-error to IP 192.168.0.5 

Can not add tag data source

hi all.

     Can Publishers send events to the tag? type Publishers is HTTP Sender

Thank you

@jared-wiltshire When do you want it to blink between green and grey? When the point value is true?
Ans. Yes. point value is true.blink between green and grey. Where can I set up?

Thank you

Hi @phildunlap I want you to help me.
<ma-switch-img id="963fcec0-a854-4b84-8fd9-287efaa10f72" default-src="/rest/v2/file-stores/default/gray-led-circle-3-md.png" src-false="/rest/v2/file-stores/default/red-led-circle-3-hi.png" src-true="/rest/v2/file-stores/default/led-green-hi.png" point-xid="internal_mango_num_data_points"></ma-switch-img>

If the value is true, show the green light. If the value is false, show the red light.If the value is default, show the grey light.I want the light to blink between green and gray.Where do I set it? Or any component that works the way I want it?

Thankyou.

@phildunlap
Thank you for support

@phildunlap I see blue help you say. I'll put event into an excel file. I still do not understand. Can you please show me some examples?

Thank you.

@phildunlap
I want to click export in the image. Then excel report form attached.I can use Report template function of excel reports like this image.

Hi, all

         I'm looking for a way to make an event alarm report, but I can not find it. I do not know how to send an alarm event to an excel report.

thank all