Import javascript library

arvand.owji

when i look at the poll data for the http retriever data source i see the poll time is 0 second. is this right?
2017/09/28 18:46:40.849 0ms
2017/09/28 18:48:40.849 0ms
2017/09/28 18:50:40.849 0ms

arvand.owji

here is the json. The box has access to the url. i confirmed by issuing wget and curl from ssh.

"dataSources":[
{
"xid":"DS_608664",
"name":"CoolPropRet",
"enabled":true,
"type":"HTTP_RETRIEVER",
"alarmLevels":{
"DATA_RETRIEVAL_FAILURE":"URGENT",
"POLL_ABORTED":"URGENT",
"SET_POINT_FAILURE":"URGENT",
"PARSE_EXCEPTION":"URGENT"
},
"purgeType":"YEARS",
"updatePeriodType":"MINUTES",
"quantize":false,
"retries":3,
"setPointUrl":"",
"timeoutSeconds":40,
"updatePeriods":2,
"url":"http://IPADDRESS:85/coolprop4.html",
"editPermission":"",
"purgeOverride":false,
"purgePeriod":1
}
]
}

arvand.owji

and here is the html for coolprop4.html


    
<!DOCTYPE html>
<html>
    <head>
        <title>Set Point Value</title>
        <!-- Add the Mango Favicon -->
        <link rel="icon" href="/images/favicon.ico">

        <!-- Page Style -->
        <style></style>
        <link href="/resources/bootstrap/css/bootstrap.min.css" rel="stylesheet">
        <link href="/modules/dashboards/web/private/css/dashboard.css" rel="stylesheet">

        <!-- Base Library -->
        <script type="text/javascript" src="/resources/loaderConfig.js"></script>
        <script type="text/javascript" src="/resources/require.js"></script>
        <script type="text/javascript" src="/resources/main.js"></script>
        <script type="text/javascript" src="coolprop.js"></script>
        <script type="text/javascript">

        require(['jquery', 'mango/api'],
                function($, MangoAPI) {
					//defaiult numbers for pressure and temperature 
					//The temperatures are in *F and pressures are in   
		   var Pressure = 40;	
		   var Temprature = 500;
          $('#document').ready(function(){
  			
			MangoAPI.defaultApi.getCurrentValue('DP_962596').then(function(currentValue){
				var statusRow = [];
                statusRow.push('System Start time is' + currentValue.value+' minutes ago.');
                statusRow.push(new Date());
				$('#status').append(createRow(statusRow));
				if(currentValue.value>0.1){
					MangoAPI.defaultApi.getCurrentValue('DP_833148').then(function(currentValue){
						Pressure=currentValue.value;
						
						MangoAPI.defaultApi.getCurrentValue('DP_529391').then(function(currentValue){
							
									Temprature=currentValue.value;
									
									var xid = 'DP_274226'; //S_Nitrogen
									var Gas_Type='Nitrogen';
									SetValues(xid,Pressure,Temprature,Gas_Type);
									
									xid = 'DP_540483'; //S_R134a
									Gas_Type='R134a';
									SetValues(xid,Pressure,Temprature,Gas_Type);
									
									xid = 'DP_499589'; //S_R404A 
									Gas_Type='R404A';
									SetValues(xid,Pressure,Temprature,Gas_Type);
									
									xid = 'DP_052405'; //S_R410A 
									Gas_Type='R410A';
									SetValues(xid,Pressure,Temprature,Gas_Type);
									
									xid = 'DP_403680'; //S_R507A 
									Gas_Type='R507A';
									SetValues(xid,Pressure,Temprature,Gas_Type);
						}).fail(MangoAPI.logError);
					}).fail(MangoAPI.logError);	
				}			
			  }).fail(MangoAPI.logError);
		  }); 
		  
		  function SetValues(xid,Pressure,Temprature,Gas_Type){
			    //We need the data type for the point
            	MangoAPI.defaultApi.getPoint(xid).then(function(point){
          		
          		//Check to see if settable
          		if(point.pointLocator.settable === false){
          			var statusRow = [];
                  	statusRow.push(xid + ' not settable.');
                  	statusRow.push(new Date());
                  	//Append a status row
                  	$('#status').append(createRow(statusRow));
                  	return;
					}
              	var pvt = getPointValueTime(point,Pressure,Temprature,Gas_Type);
              	MangoAPI.defaultApi.putValue(xid, pvt).then(function(response){
                    	var statusRow = [];
                    	statusRow.push('Set Value For ' + xid +'('+Gas_Type+')'+' to ' + pvt.value);
                    	statusRow.push(new Date());
                    	//Append a status row
                    	$('#status').append(createRow(statusRow));
              	}).fail(MangoAPI.logError);        		
          	}).fail(MangoAPI.logError);			  
		  }
          
          function createRow(columns){
          	var tr = $('<tr>');
          	for(var i=0; i<columns.length; i++){
          		 var td = $('<td>');
       			  td.text(columns*);
       			  tr.append(td);
          	}
          	return tr;
          }
  
          
          function getPointValueTime(dataPoint,Pressure,Temprature,Gas_Type){
  			
          	var value = null;              
			value= Module.PropsSI('S', 'P', Pressure, 'T', Temprature, Gas_Type);
          	return {
              		value: value,
              		timestamp: new Date().getTime(),
              		annotation: 'Set by custom dashboard',
              		dataType: dataPoint.pointLocator.dataType,
              	};
          }
        });
        </script>
        
    </head>
    <body>
      <div id="main">
        
        <div class="row">
          <div class="col-md-12">
            <table class="table">
              <tr><th>Status</th><th>Time</th></tr>
              <tbody id="status"></tbody>
            </table>
          </div>
        </div>

      </div>
    </body>
</html>

phildunlap

The detail that is missing is the regex you are trying to use to get values from this. You didn't put any data points in your export.

I must say, I'm confused. Why would you have a data source regex'ing a script for constant content? The JavaScript and HTML (or whatever content) are not interpreted beyond the data points you create to parse it.

A 0ms poll isn't that surprising, as it's loading a file locally. Here were my poll times reading the regex Set(.*) for group 1 (which gives me value, Point Value</title>)from that content saved as you describe,

2017/09/28 20:53:15.311 16ms
2017/09/28 20:53:20.311 8ms
2017/09/28 20:53:25.311 0ms
2017/09/28 20:53:30.311 0ms
2017/09/28 20:53:35.311 0ms
2017/09/28 20:53:40.311 0ms
2017/09/28 20:53:45.311 0ms
2017/09/28 20:53:50.311 8ms
2017/09/28 20:53:55.311 4ms
2017/09/28 20:54:00.311 0ms

Because it's doing the same thing every time. It will definitely be 0ms if you don't have any data points.

arvand.owji

@phildunlap I agree. What im trying to do is a bit confusing but here is my attempt for a s simple explanation...
I have a javascript library named coolprop.js that is about 7mb in size and too big to use inside a mango script. So what i ended up to do was to create an html page that:
Step 1: retrieves bunch of data points value by XID then
Step 2: passes those data points value to a function provided by coolprop to do some calculation, then
Step 3: use mango api to assign values calculated in above step to some other Data points.

I then use the url pointed to this html file into httpretriever to simply run this html file every 2 minutes. Once html is ran, it should set the values as detailed out in the above steps. I know the html works because if i run it through my browser, it perfectly does what it suppose to but when i run it through httpretreiver, nothing happens (as if the whole URL is not even being called every 2 minutes). This script used to work before but suddenly stopped working. and unfortunately i cant really debug it. When running in the browser, i can see the output and errors written in the chrome devtool but i have no visibility to errors when using http retriever.

arvand.owji

@phildunlap i hope that my explanation above made sense. Thanks.

phildunlap

The HTTP Retriever doesn't execute or interpret the content it retrieves. You would end up in the same boat as before, where coolprop runs Java out of memory in your instance. That's what this is an effort to circumvent, right?

I think what you're looking for is to have a node js running on a machine with sufficient memory that executes these calculations and sets the values back to Mango through the API.

It is certainly possible, though, that you can leave this page open on the other computer in a browser (something which is executing it). You can create an automatic login for the user and just leave that page open somewhere. It's not the most robust solution, but it should work.

arvand.owji

@phildunlap I understand but are you 100% certain that this wont work? Im pretty sure it was updating the values before.

phildunlap

Are you saying when you had the page open in a browser?

I am certain the HTTP retriever is basically treating it as text content for regex parsing, yes. It doesn't treat it as a webpage and execute its content.

arvand.owji

@phildunlap said in Import javascript library:

Are you saying when you had the page open in a browser?

I am certain the HTTP retriever is basically treating it as text content for regex parsing, yes. It doesn't treat it as a webpage and execute its content.

running the script through another browser is not an option. Any other ways you can think of? Thanks.

arvand.owji

@phildunlap how about running the url through something like phantomjs from command prompt?

phildunlap

I don't have experience with phantomjs but it looks like it might work. It will at least execute the JavaScript. It should be the same idea as using node, right?

arvand.owji

@phildunlap said in Import javascript library:

I don't have experience with phantomjs but it looks like it might work. It will at least execute the JavaScript. It should be the same idea as using node, right?

Well,i just tried phantom and it wont work as it does not have arm distribution. I will tried node.js see what happens.

arvand.owji

@phildunlap now with Node.js i need to convert my html file that references java script inside to full javascript!

arvand.owji

@phildunlap do we have any sample javascripts that cna be used in node.js that use mangoapi? like retrieving values by XID and setting values? Thanks.

phildunlap

Yeah you might be able to get what you're looking for from the tests we've implemented in node: https://github.com/infiniteautomation/node-mango-client

arvand.owji

@phildunlap Thanks. I get this error when i try to run the example:

$node example.js
(node:24509) UnhandledPromiseRejectionWarning: Unhandled promise rejection (rejection id: 1): Error: connect ECONNREFUSED 127.0.0.1:8443

phildunlap

You would have to point it at your running Mango instance and port. It's from this section of example.js:

const client = new MangoClient({
    protocol: 'https',
    host: 'localhost',
    port: 8443,
    rejectUnauthorized: false
});

arvand.owji

@phildunlap said in Import javascript library:

You would have to point it at your running Mango instance and port. It's from this section of example.js:
const client = new MangoClient({
    protocol: 'https',
    host: 'localhost',
    port: 8443,
    rejectUnauthorized: false
});

Its running locally on the same box. shouldnt localhost be enough? Thanks

phildunlap

No. It is using the HTTP API which is over TCP/IP and all TCP/IP connections require an address and a port. Edit: yes localhost is the host if its the same machine (usually, localhost means 127.0.0.1 usually)