• V
    v8dave

    The best way I found to do this was to create a second sheet and have Mango paste the data into that and then on the first sheet you simply link to the data on the second sheet.

    See sample below. Highlight at least 2-3 rows and then in the formulas tab choose create from selection. These are now what you select in Mango. Format the columns before you upload the Excel file.

    0_1478649010748_ExcelSample.png

    posted in Mango Automation general Discussion read more
  • V
    v8dave

    Is the URL correct? On my system the dashboard appears at:

    /modules/dashboards/web/yourname/

    posted in Mango Automation general Discussion read more
  • V
    v8dave

    Just a quick update, My client finally updated the server to a 4GB memory option and for 24 hours now we have not seen any shutdowns. Previously we would see at least 5-6 in that time.

    posted in Dashboard Designer & Custom AngularJS Pages read more
  • V
    v8dave

    You can't host it on a website. They only allow HTML, PHP etc.

    You can use something like a GoDaddy Virtual Server and we do that and it works but if you do, I suggest you get the 4GB memory option as the cheapest at 1GB will give you lots of out of memory errors depending on how complex your setup is. Best to be safe.

    You can use any text editor that allows an FTP connection to allow you to edit the HTML for the dashboards etc.

    To upload and download files is simple a matter of using an FTP programme.

    posted in User help read more
  • V
    v8dave

    If the machine you are hosting Mango on does not have a FIXED IP you need to look at using DYNDNS or something similar and you need to have either the router detect the IP has changed and update the DYNDNS entry or have some software running on the server looking for the changes. Normally most modern routers have this capability built in.

    You need to setup PORT FORWARDING on your router to allow an external connection to work. Note that some ISP's block certain IP's so you may have to play around to find one that is open. 8080+ should be good in most cases.

    Your issue with the free version will be if you connect from a mobile device as they will give you a different IP each time so you will run out of IP's very quickly. The server being DYNAMIC won't be affected by this as it is the IP address of the devices connecting to the web interface that will have this issue.

    posted in User help read more
  • V
    v8dave

    I have an Excel report and I want to be able to include the data of the report in one of the cells. If I use the =TODAY() formula it will change each time the report is opened and printed.

    How can I set the cell to the data it was created?

    posted in Dashboard Designer & Custom AngularJS Pages read more
  • V
    v8dave

    How do I get the browser charts and anything with time to show the server time and not the time local of the users browser?

    I set the users timezone to use the server timezone but the times all appear as local times in the charts etc.

    posted in Dashboard Designer & Custom AngularJS Pages read more
  • V
    v8dave

    I don't have any boolean points showing on any dashboard displays.

    posted in Dashboard Designer & Custom AngularJS Pages read more
  • V
    v8dave

    I am seeing this error in the log file and not sure whats causing this.

    WARN  2016-08-03 14:34:22,050 (com.serotonin.m2m2.web.mvc.rest.v1.model.pointValue.PointValueRollupCalculator.streamData:108) - Invalid non-numeric rollup type: AVERAGE 
    
    

    Then this appears after it.

    ERROR 2016-08-03 13:08:21,169 (com.serotonin.m2m2.web.mvc.rest.v1.publisher.pointValue.PointValueWebSocketPublisher.pointUpdated:156) - Websocket session is closed, can't send message 
    java.lang.Exception: Websocket session is closed, can't send message
    	at com.serotonin.m2m2.web.mvc.websocket.MangoWebSocketPublisher.sendMessage(MangoWebSocketPublisher.java:132)
    	at com.serotonin.m2m2.web.mvc.rest.v1.publisher.pointValue.PointValueWebSocketPublisher.pointUpdated(PointValueWebSocketPublisher.java:153)
    	at com.serotonin.m2m2.rt.dataImage.DataPointEventMulticaster.pointUpdated(DataPointEventMulticaster.java:94)
    	at com.serotonin.m2m2.rt.dataImage.DataPointRT$EventNotifyWorkItem.execute(DataPointRT.java:613)
    	at com.serotonin.m2m2.rt.maint.BackgroundProcessing$1.run(BackgroundProcessing.java:54)
    	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    	at java.lang.Thread.run(Thread.java:745)
    
    

    After these appear a few times, Mango shutsdown and my cron job restarts it.

    posted in Dashboard Designer & Custom AngularJS Pages read more
  • V
    v8dave

    I am seeing this in the log after it just shuts down.

    ERROR 2016-08-02 17:13:52,639 (org.springframework.web.servlet.mvc.method.annotation.ExceptionHandlerExceptionResolver.doResolveHandlerMethodException:367) - Failed to invoke @ExceptionHandler method: protected org.springframework.http.ResponseEntity<java.lang.Object> com.serotonin.m2m2.web.mvc.rest.v1.exception.RestExceptionHandler.handleMangoError(java.lang.Exception,org.springframework.web.context.request.WebRequest) 
    java.lang.IllegalStateException: Compressed output stream is already assigned.
    

    Is there an issue with more than 1 user logging in under the same user name?

    posted in Dashboard Designer & Custom AngularJS Pages read more