• L
    leoboeng

    Yes, I have used these sites to create the expression.

    The expression is correct but there is no update at the correct time.

    I'm guessing that it should if some other configuration, such as context event type that may be wrong.

    posted in Scripting general Discussion read more
  • L
    leoboeng

    Hello, I created a script and wanted it to update every day and every hour in minutes and seconds 59.
    I made the expression cron (59 59 * * *? *), But it is not updating at that exact time I requested.

    Here is the image of the settings, but do you have a suggestion of what it could be?

    0_1533653251389_Capturar232.PNG

    posted in Scripting general Discussion read more
  • L
    leoboeng

    It would be to read device historical values. It does not present "presentValue" for some data types.

    posted in Mango Automation general Discussion read more
  • L
    leoboeng

    ok thank you, I tried with all but 0.0.0.0.

    I started to mess with bacnet now and I'm kind of lost, but thank you !!

    Would not it be possible to pull the value of a TrendLog type variable?

    0_1533319579683_999.PNG

    posted in Mango Automation general Discussion read more
  • L
    leoboeng

    Hello, I'm starting to mess with BacNet IP devices and I'm facing some problems.

    In the part of Backnet Local Devices I put the IP of the Linux server that is running the Mango (192.168.0.23)

    0_1533317127020_666.PNG

    So I went to configure Data Soucer but it does not connect and does not find the points

    0_1533317112337_777.PNG

    I tried both with the ip of the server mango (192.168.0.23) and the Ip of the BacNet-enabled device (182.168.0.241) and neither of them connected.

    Following is information from my Bacnet device:

    0_1533317101547_888.PNG

    posted in Mango Automation general Discussion read more
  • L
    leoboeng

    @craigweb said in Problem with Pie Chart:

    Trying to get the unit on the value seems to be giving more problems than it is worth. Is it not enough to put the unit in the text?

    Hello,

    Yes, but the problem I was facing is that even the decimal place I was able to put rendered, ie the value of the point came with 4 decimal places and just wanted to show 2, but your formula that passed me has already served and worked.

    It would be nice to have the unit follow up but I'll text it.

    Ah, thanks for the help.

    posted in Dashboard Designer & Custom AngularJS Pages read more
  • L
    leoboeng

    I tried the following ways and even then continued showing a pie chart in "white"

    <ma-get-point-value point-xid="DP_530359" point="P_Ativa_A"></ma-get-point-value>    
      
    <ma-pie-chart id="63759ca9-e465-45e3-80b8-89cda82627fe" style="height: 303px; width: 612px; position: absolute; left: 0px; top: 30px;" values="[{ value: parseFloat( P_Ativa_A.renderedValue.split(' ')[0]), text: 'Fase B', color: 'black' },]" options="{depth3D:15,angle:30}"></ma-pie-chart>
    
    <ma-get-point-value point-xid="DP_530359" point="P_Ativa_A"></ma-get-point-value>    
      
    <ma-pie-chart id="63759ca9-e465-45e3-80b8-89cda82627fe" style="height: 303px; width: 612px; position: absolute; left: 0px; top: 30px;" values="[{ value: P_Ativa_A.renderedValue.split(' ')[0], text: 'Fase A (A)', color: 'black' },]" options="{depth3D:15,angle:30}"></ma-pie-chart>
    

    All two codes showed the graphic in "white":

    0_1533298722240_33.PNG

    My points are configured as follows:

    0_1533299292083_22.PNG

    0_1533299271268_111.PNG

    0_1533299278554_12.PNG

    It pulls the data as follows:

    0_1533299315981_12323.PNG

    posted in Dashboard Designer & Custom AngularJS Pages read more
  • L
    leoboeng

    @mattfox said in Problem with Pie Chart:

    if so, this is how I'd do it and just add the unit to the text

    But doing so I would have to take the unit out of the point configuration, correct?

    posted in Dashboard Designer & Custom AngularJS Pages read more
  • L
    leoboeng

    @mattfox said in Problem with Pie Chart:

    So first off, the units come in looking like 5,0490 5.9382 4,0983 the comma for each measurement's decimal place and a space to separate each house.
    Secondly, you only want the units to be 3 significant figures long, without rounding.
    Thirdly, you want to be able to use the Unit on the pie chart.
    I'm I hitting the nail on the head?

    Yes that's right.

    The formatting with 3 significant units but I already got it.

    In the pie chart without the Units of Measurements it is possible to make a "point.renderedValue", but when units are added the pie chart does not work.

    So I used the "Slice", as I was shown, it worked about 2-3 days and today started to present that problem.

    posted in Dashboard Designer & Custom AngularJS Pages read more
  • L
    leoboeng

    @mattfox said in Problem with Pie Chart:

    So you're telling me the data comes in as comma separated values???
    Could you please output the individual points data line by line so I can see how it sits within your markup?

    I have no more in front of the server for this, and even apologize for my English, I'm from Brazil and here the separation is made by commas (,), in the case of you points (.).

    The values ​​come in the following format, for example:

    Electric_current_Phase_A:

    5.0490
    5.9382
    4.0983

    In my formatting by Mango, it shows as follows:

    Electric_current_Phase_A:

    5.04 A
    5.93 A
    4.09 A

    That is why I say that the need for units is important to me, in the case of exemple the Amper (A), and this is what has been complicating my Pie Chart.

    posted in Dashboard Designer & Custom AngularJS Pages read more
  • L
    leoboeng

    @mattfox said in Problem with Pie Chart:

    Then why not just stick to using '.value' rather than using '.renderedValue' and making it more complicated than necessary?

    For it is about electrical measurements and the better visually go accompanied by their units. In addition, the meter pulls data with 4 houses after the comma, for example 5.0892, and I want to work with only 2 houses.

    In the matter of decimals it is quieter because the "point.renderedValue" only works with this type. It stops working when I add the Unit of measurement and this for me is very important because there are other graphs, and lists that work with it, so I can not take it. And it is not at all feasible for me to create 2 points just to make that point distinction with unit of measure and point without unity.

    posted in Dashboard Designer & Custom AngularJS Pages read more
  • L
    leoboeng

    I have already updated the page, restart the server, check the internet and everything ok. I did a chart pie only with the values ​​of the points "point.value" and showed everything correctly. I did not move in any configuration of the point, it was working correctly and the point is still being updated the values, just does not show the graph anymore. So much so that the "Total" is the sum of all the points that compose the char pie.

    I did not make any major changes to the code that was passed to me just added some items that are not part of the chart pie. On the chart pie I just added the caption.

    posted in Dashboard Designer & Custom AngularJS Pages read more
  • L
    leoboeng

    @phildunlap Yes it is a numerical point rendered with unity. They are power measurements, no conversions are made, the values are pulled directly from a ModBus TCP / IP meter.

    posted in Dashboard Designer & Custom AngularJS Pages read more
  • L
    leoboeng

    The code was working perfectly but it stopped working.

    <div class="ma-designer-root" id="69cb3d48-9218-481c-98fd-32a687ea174e" style="width: 1366px; height: 768px; position: relative;">
        <ma-get-point-value point-xid="DP_530359" point="P_Ativa_A"></ma-get-point-value>
        <ma-get-point-value point-xid="DP_807622" point="P_Ativa_B"></ma-get-point-value>
        <ma-get-point-value point-xid="DP_515819" point="P_Ativa_C"></ma-get-point-value>
        <ma-pie-chart id="63759ca9-e465-45e3-80b8-89cda82627fe" style="height: 303px; width: 612px; position: absolute; left: 0px; top: 40px;" values="[ { value: P_Ativa_A.renderedValue.slice(0, P_Ativa_A.renderedValue.indexOf(' ')), text: 'Fase A', color: 'red' }, { value: P_Ativa_B.renderedValue.slice(0, P_Ativa_B.renderedValue.indexOf(' ')), text: 'Fase B', color: 'black' }, { value: P_Ativa_C.renderedValue.slice(0, P_Ativa_B.renderedValue.indexOf(' ')), text: 'Fase C', color: 'white' } ]" options="{depth3D:15,angle:30,legend:{'position':rigth,marginRight:100,autoMargins:false}}"></ma-pie-chart>
        <div id="6da01089-3a57-4adc-820d-c7b16e317f4d" style="position: absolute; left: 248px; top: 14px;">Demanda (kW)</div>
        <ma-point-value id="6da01089-3a57-4adc-820d-c7b16e31734e" style="position: absolute; width: 95.9688px; height: 18px; left: 457px; top: 319px; text-align: center; line-height: normal; font-size: 12px;" point-xid="DP_892466"></ma-point-value>
        <div id="9a443ad1-7ffa-4ea9-b6cf-81afbd5ba0a5" style="position: absolute; left: 409px; top: 317px; font-size: 14px;">Total:</div>
        
        <ma-get-point-value point-xid="DP_147675" point="P_Reativa_A"></ma-get-point-value>
        <ma-get-point-value point-xid="DP_495992" point="P_Reativa_B"></ma-get-point-value>
        <ma-get-point-value point-xid="DP_170532" point="P_Reativa_C"></ma-get-point-value>
        <ma-pie-chart id="51518ce5-4bbd-436c-b152-33b9cab8b661" style="height: 303px; width: 612px; position: absolute; left: 612px; top: 40px;" values="[ { value: P_Reativa_A.renderedValue.slice(0, P_Reativa_A.renderedValue.indexOf(' ')), text: 'Fase A', color: 'red' }, { value: P_Reativa_B.renderedValue.slice(0, P_Reativa_B.renderedValue.indexOf(' ')), text: 'Fase B', color: 'black' }, { value: P_Reativa_C.renderedValue.slice(0, P_Reativa_C.renderedValue.indexOf(' ')), text: 'Fase C', color: 'white' } ]" options="{depth3D:15,angle:30,legend:{'position':rigth,marginRight:100,autoMargins:false}}"></ma-pie-chart>
        <div id="5260430c-4141-4b8c-841c-a295939587e0" style="position: absolute; left: 839px; top: 15px;">Demanda Indutiva (kVAr)</div>
        <div id="8ec6afb5-9c47-4b3f-b2f4-15c313f36895" style="position: absolute; left: 1038px; top: 318px; font-size: 14px;">Total:</div>
        <ma-point-value id="a040eff7-b295-432b-8d1c-ce5e6df3aba3" style="position: absolute; width: 95.9688px; height: 18px; left: 1094px; top: 321px; text-align: center; line-height: normal; font-size: 12px;" point-xid="DP_138259"></ma-point-value>
        
        <ma-get-point-value point-xid="DP_954001" point="A_AtivoDiario_FP"></ma-get-point-value>
        <ma-get-point-value point-xid="DP_940363" point="A_AtivoDiario_P"></ma-get-point-value>
        <ma-pie-chart id="878e8fce-42a5-4291-ab8c-db54f97af9e1" style="height: 420px; width: 641px; position: absolute; left: 0px; top: 342px;" values="[ { value: A_AtivoDiario_FP.renderedValue.slice(0, A_AtivoDiario_FP.renderedValue.indexOf(' ')), text: 'Consumo Fora de Ponta', color: 'red' }, { value: A_AtivoDiario_P.renderedValue.slice(0, A_AtivoDiario_P.renderedValue.indexOf(' ')), text: 'Consumo na Ponta', color: 'black' }]" options="{depth3D:15,angle:30,legend:{'position':rigth,marginRight:100,autoMargins:false}}"></ma-pie-chart>
        <div id="53397a10-40d3-497a-a11c-5f9f1c7a3fa9" style="position: absolute; left: 233px; top: 411px;">Consumo Ativo Diário (kWh)</div>
        <div id="e42746f5-2cc7-43fe-b715-515a85904545" style="position: absolute; left: 454px; top: 734px; font-size: 14px;">Total:</div>
        <ma-point-value id="997cb925-2c57-4d6f-9747-6bd18b41c2d0" style="position: absolute; width: 95.9688px; height: 18px; left: 517px; top: 735px; text-align: center; line-height: normal; font-size: 12px;" point-xid="DP_929069"></ma-point-value>
        
        <ma-get-point-value point-xid="DP_280526" point="A_AtivoMensal_FP"></ma-get-point-value>
        <ma-get-point-value point-xid="DP_738729" point="A_AtivoMensal_P"></ma-get-point-value>
        <ma-pie-chart id="1a248030-0ea5-4a94-a659-f60b1bdce677" style="height: 420px; width: 641px; position: absolute; left: 641px; top: 342px;" values="[ { value: A_AtivoMensal_FP.renderedValue.slice(0, A_AtivoMensal_FP.renderedValue.indexOf(' ')), text: 'Consumo Fora de Ponta', color: 'red' }, { value: A_AtivoMensal_P.renderedValue.slice(0, A_AtivoMensal_P.renderedValue.indexOf(' ')), text: 'Consumo na Ponta', color: 'black' }]" options="{depth3D:15,angle:30,legend:{'position':rigth,marginRight:100,autoMargins:false}}"></ma-pie-chart>
        <div id="fd952897-7ff7-49fd-86da-c31e75633f7f" style="position: absolute; left: 875px; top: 411px;">Consumo Ativo Mensal (kWh)</div>
        <div id="5cb80112-7e0a-47c6-a5d7-e6582422d2ab" style="position: absolute; left: 1098px; top: 734px; font-size: 14px; width: 30.9531px; height: 19px;">Total:</div>
        <ma-point-value id="54931f3a-3721-45c9-a618-c075ef353298" style="position: absolute; width: 95.9688px; height: 18px; left: 1157px; top: 736px; text-align: center; line-height: normal; font-size: 12px;" point-xid="DP_185150"></ma-point-value>
    </div>
    

    0_1533238820830_Capturar.PNG

    0_1533238834648_Capturar2.PNG

    Do you have any idea what the problem might be?

    posted in Dashboard Designer & Custom AngularJS Pages read more
  • L
    leoboeng

    Thank you!!
    And how do I show the rendered value? I tried the following but it did not work:

        <ma-get-point-value point-xid="DP_530359" point="P_Ativa_A"></ma-get-point-value>
        <ma-get-point-value point-xid="DP_807622" point="P_Ativa_B"></ma-get-point-value>
        <ma-get-point-value point-xid="DP_515819" point="P_Ativa_C"></ma-get-point-value>
        <ma-pie-chart id="63759ca9-e465-45e3-80b8-89cda82627fe" style="height: 303px; width: 612px; position: absolute; left: 0px; top: 30px;" values="[ { value: P_Ativa_A.renderedValue, text: 'Fase A', color: 'red' }, { value: P_Ativa_B.renderedValue, text: 'Fase B', color: 'black' }, { value: P_Ativa_C.renderedValue, text: 'Fase C', color: 'white' } ]" options="{depth3D:15,angle:30}"></ma-pie-chart>
    </div>
    

    posted in Dashboard Designer & Custom AngularJS Pages read more
  • L
    leoboeng

    @phildunlap said in Excel Report:

    the top section of /system_settings.shtm

    I just checked the top section of /system_settings.shtm and I actually saw that you are using H2.

    I think it was something of the update, because I made an update and since then it did not work anymore, but before that it was like MYSQL.

    I will pass the database to MYSQL and check if the error will continue.

    posted in User help read more
  • L
    leoboeng

    Hi, I switched to MySQL as recommended, but started to make the same mistake. Follow the error photo

    0_1532435544683_erro relatorio.png

    posted in User help read more
  • L
    leoboeng

    Hi, I'm trying to make a pie chart based on a point but I can not do it. I did the following but it did not work:

    <ma-get-point-value point-xid="DP_698831" point="myPoint"></ma-get-point-value>
    <ma-pie-chart style="height: 300px; width: 600px" values="[ { value: myPoint, text: 'hot', color: '#ff9300' }, { value: 5, text: 'cold', color: '#942192' } ]"
    options="{depth3D:15,angle:30}"></ma-pie-chart>
    

    In the API it says that the value has to be number, someone knows to tell me how do I use the Point value instead of a number?

    posted in Dashboard Designer & Custom AngularJS Pages read more
  • L
    leoboeng

    Ah ok thanks, I typed the wrong password. I already made another user use root only for testing.

    But do you know if I can copy the data from the old database to the new sql? I tried the backups but it did not work if you missed a large part of the setup.

    posted in User help read more