|
Revision 117
(checked in by jcothran, 5 years ago)
|
--
|
| Line | |
|---|
| 1 |
The following scripts are used to collect recent met(niwolmet) and water(niwolwq) data for the northinlet station from NERRS cdmo web service ( http://cdmo.baruch.sc.edu/webservices/index.html ) and convert this data into SQL INSERT statements which are used to populate a Xenia schema database. |
|---|
| 2 |
|
|---|
| 3 |
The below cron is run every 5 minutes past the hour. It uses the php script getServiceNI.php to get an xml response from a soap request using the php nusoap library( http://trac.seacoos.org/datamgmt/browser/docs/usc/nautilus/usr2/prod/buoys/perl/xml/nusoap ). |
|---|
| 4 |
|
|---|
| 5 |
This xml response is then edited some to remove header lines and xml elements which include namespaces that are problematic for the XML::LibXML package to handle. |
|---|
| 6 |
|
|---|
| 7 |
This edited xml is then parsed for the timestamp and measurement values present in each row. The parsed data is used to create a SQL INSERT statement which is used to populate the database. |
|---|
| 8 |
|
|---|
| 9 |
The same processes are run against a control array list of the platforms of interest (platform array) shown at the beginning of both the php and perl script. |
|---|
| 10 |
|
|---|
| 11 |
|
|---|
| 12 |
#get data |
|---|
| 13 |
05 * * * * cd /usr2/prod/buoys/perl/xenia; php getServiceNI.php; perl processServiceNIDB.pl northinlet >> /tmp/northinlet.log 2>&1 |
|---|
