nested xml to csv using xmlstarlet -


i trying access content xml file (downloaded local weather service), has following format:

product/observations product/observations/station[@wmo-id='95936' , @bom-id='086338' , @tz='australia/melbourne' , @stn-name='melbourne (olympic park)' , @stn-height='7.53' , @type='aws' , @lat='-37.8255' , @lon='144.9816' , @forecast-district-id='vic_pw007' , @description='melbourne (olympic park)'] product/observations/station/period[@index='0' , @time-utc='2015-05-29t09:20:00+00:00' , @time-local='2015-05-29t19:20:00+10:00' , @wind-src='omd'] product/observations/station/period/level[@index='0' , @type='surface'] product/observations/station/period/level/element[@units='celsius' , @type='apparent_temp'] product/observations/station/period/level/element[@units='celsius' , @type='delta_t'] product/observations/station/period/level/element[@units='km/h' , @type='gust_kmh'] product/observations/station/period/level/element[@units='knots' , @type='wind_gust_spd'] product/observations/station/period/level/element[@units='celsius' , @type='air_temperature'] product/observations/station/period/level/element[@units='celsius' , @type='dew_point'] product/observations/station/period/level/element[@units='hpa' , @type='pres'] product/observations/station/period/level/element[@units='hpa' , @type='qnh_pres'] product/observations/station/period/level/element[@units='%' , @type='rel-humidity'] product/observations/station/period/level/element[@type='wind_dir'] product/observations/station/period/level/element[@units='deg' , @type='wind_dir_deg'] product/observations/station/period/level/element[@units='km/h' , @type='wind_spd_kmh'] product/observations/station/period/level/element[@units='knots' , @type='wind_spd']

my interest accessing values associated each element.

i've been experimenting xmlstarlet, , following script can batch process , extract of @wmo-id related xml file.

#!/bin/bash inp=$1 outp=$2 xml="xmlstarlet" xpath="/product/observations/station/period/level" $xml sel -t -t -m $xpath -v "concat(../../@wmo-id,',',../..@stn-name)"     -n $inp > $outp exit 0

i tried use following extract data 1 of elements no data:

#!/bin/bash xmlfile=$1 xml="xmlstarlet" xpath="/product/observations/stations/period/level"  $xml sel -t -t -m $xpath -v "concat(element[@type='apparent_temp'])" -n $xmlfile  exit 0

can advise on missing?


Comments

Post a Comment

Popular posts from this blog

node.js - Using Node without global install -

i'm working on few node & electron (atom shell) projects , i'm curious how them work without user having install node globally. i've seen few applications including node directory in project contains node.exe binary. how go setting node project use binary? edit: thought should add, i've searched everywhere answer this, unrelated results.
Read more

How to access a php class file from PHPFox framework into javascript code written in simple HTML file? -

i've website developed using phpfox v3.0.7 . now i'm trying implement 'sse(server sent events)' 1 of php files. reference i'm giving below necessary code part of file. file titled process.class.php , present @ location /var/www/module/notification/include/service/process.class.php present on server having ip http://34.124.40.142/ . <?php /** * [phpfox_header] */ header('content-type: text/event-stream'); header('cache-control: no-cache'); defined('phpfox') or exit('no dice!'); /** * * * @copyright [phpfox_copyright] * @author raymond benc * @package phpfox_service * @version $id: service.class.php 67 2009-01-20 11:32:45z raymond_benc $ */ class notification_service_process extends phpfox_service { /** * class constructor */ public function __construct() { $this->_stable = phpfox::gett('notification'); } public function add($...
Read more

java - Null response to php query in android, even though php works properly -

Image
table i'm trying retrieve above data using 2 php files below. want pass email parameter , return bets user = email. work fine when tested advanced rest client, problem not php. however, when try through android 2 java classes below, null pointer exception (logcat below) , json object returned null. i'm not sure error is, think i'm not passing parameter php , that's why it's producing null response. logcat 05-31 15:10:50.227 26074-26074/com.example.albert.betterapp e/androidruntime﹕ fatal exception: main process: com.example.albert.betterapp, pid: 26074 java.lang.runtimeexception: unable start activity componentinfo{com.example.albert.betterapp/com.example.albert.betterapp.displayallbets}: java.lang.nullpointerexception @ android.app.activitythread.performlaunchactivity(activitythread.java:2292) @ android.app.activitythread.handlelaunchactivity(activitythread.java:2350) @ android.app.activitythread.acce...
Read more