get_data

1. Web GUI The default index.php will log in to iqup and get all of the sensor IDs in the 'Sensor' table and list it. Using the form you can query for data, graph it, and/or download it. 2. URL/WGET Use You can also generate graphs and download data using by supplying "?" type parameters in a URL. Acceptable fields: graph: bypass web gui and start graphing. If you use graph you will need to supply the start, end, sensorID(s), and graph type. start: Date/Time or unix timestamp. The following are equivalent:"2017/6/1", "2017/6/1 00:00:00", "1496275200" end: Date/Time or unix timestamp. hour: Return the last hour. Add a value for multiple hours. (ex. hour=2, for the last 2 hours). day: Return the last day. Add a value for multiple days. (ex. day=2, for the last 2 days). week: Return the last week. Add a value for multiple weeks. (ex. week=2, for the last 2 weeks). month: Return the last month. Add a value for multiple months. (ex. month=2, for the last 2 months). sensorID: ',' delimited. (sensorID=LoadcellNE,LoadcellNW,LoadcellS). gtype: 1 - all sensors on one graph, 2 - each sensor has it's own graph, or 3 - data in text format ',' delimited. 5 - data in raw text width: Set graph width. height: Set graph height. fields: If mySQL table fields are not labled 'Timestamp' and 'SensorData'. (fields=Timestamp,SensorData). pagetitle: If you want to set the title of the page. Tab/Window depending on browser. 2.1 How to URL data querys: To get a graph of sensors TE2 and TE3 for June 01, 2017 as raw data: index.php?graph&start=2017/6/1+&end=2017/6/2+&sensorID[]=TE2,TE3&gtype=1 To get the text data of the same sensor (note the gtype is changed to 3) index.php?graph&start=2017/6/1+&end=2017/6/2+&sensorID[]=TE2,TE3&gtype=3 To download the text data using wget use the gtype=5 (raw text). We suggest downloading the data spearately, ie: wget -O TE2.txt "http://irtfweb.ifa.hawaii.edu/~iqup/getdata/index.php?graph&start=2017/6/1+&end=2017/6/2+&sensorID=TE2&gtype=5" wget -O TE3.txt "http://irtfweb.ifa.hawaii.edu/~iqup/getdata/index.php?graph&start=2017/6/1+&end=2017/6/2+&sensorID=TE3&gtype=5" 2.2 How to embed graphs in your web page: This examples shows how to embed a graph of Key Mirror Cooling data for the last 2 hours: index.php?graph&iqup&hour=2&sensorID=TM1,DewPt1,MC_TGO,MC_TAO,MC_TG,MC_ACT,MC_FAN,MC_HEAT&gtype=1&width=900