CSV to Specific XML with Powershell -

-

i trying use powershell convert csv xml table. there way can specify xml output.

example csv input:  time,temp,humid,dewpt "03/07/2012 12:04:59",72.1,73.2,62.5 "03/07/2012 11:34:53",71.9,73.8,62.5 "03/07/2012 11:04:46",71.8,74.6,62.7 "03/07/2012 10:34:39",72.3,72.6,62.4 "03/07/2012 10:04:33",71.9,72.1,61.9  example xml output: <?xml version="1.0" encoding="utf-8" ?>  - <chart> - <series>   <value xid="0">03/07/2012 00:02:06</value>    <value xid="1">03/07/2012 00:32:17</value>    <value xid="2">03/07/2012 01:02:26</value>    <value xid="3">03/07/2012 01:32:35</value>    <value xid="4">03/07/2012 02:02:42</value>   </series> - <graphs> - <graph gid="0" color="#32cd32" axis="right" title="temperature">   <value xid="0">43.1</value>    <value xid="1">44.0</value>    <value xid="2">43.6</value>    <value xid="3">43.1</value>    <value xid="4">42.7</value>    </graph> - <graph gid="1" color="#ffd700" axis="left" title="humidity">   <value xid="0">64.6</value>    <value xid="1">100.0</value>    <value xid="2">57.7</value>    <value xid="3">71.6</value>    <value xid="4">44.3</value>    </graph>   <graph gid="2" color="#8b008b" axis="left" title="dewpoint">   <value xid="0">30.4</value>   <value xid="1">44</value>   <value xid="2">28.4</value>   <value xid="3">32.9</value>   <value xid="4">22.6</value>   </graph>   </graphs>   </chart>

the data may not line 100%, did not grab each sample piece same place, should drift. possible?

also... maintain large master-csv. every hour 2 records added it. possible make csv-to-xml increment smartly that, or have run script against master-csv each time. know work running against master-csv, worried on time take longer , longer list continues grow. if able add new entries, make go faster.

does work?

 $head = @'  <?xml version="1.0" encoding="utf-8" ?>   <chart>  <series>  '@   $series = @'  '@   $temp_graph = @'  </series>  <graphs>  <graph gid="0" color="#32cd32" axis="right" title="temperature">   '@   $humid_graph = @'  <graph gid="1" color="#ffd700" axis="left" title="humidity">   '@   $dewpt_graph = @'  <graph gid="2" color="#8b008b" axis="left" title="dewpoint">   '@   $end = @'  </graphs>  </chart>  '@   $i = 0   import-csv file.csv |  foreach-object {   $series += @"  <value xid="$i">$($_.time)</value>   "@   $temp_graph += @"  <value xid="$i">$($_.temp)</value>   "@   $humid_graph += @"  <value xid="$i">$($_.humid)</value>   "@   $dewpt_graph += @"  <value xid="$i">$($_.dewpt)</value>   "@   $i++  }  $temp_graph,$humid_graph,$dewpt_graph | foreach {$_ += '<\graph>'  $head + $series + $temp_graph + $humid_graph + $dewpt_graph + $end

Comments

Post a Comment

Popular posts from this blog

jasper reports - Fixed header in Excel using JasperReports -

-
how can create excel report fixed header using japserreports? mean need header fixed when scroll excel file. this possible adding couple properties in jrxml file each report. take @ advanced excel features freeze panes. if wanted freeze after first column header (down left side basically) this: <statictext> <reportelement style="sans_bold" mode="opaque" x="0" y="60" width="104" height="20" forecolor="#ffffff" backcolor="#666666"> <property name="net.sf.jasperreports.export.xls.auto.filter" value="start"/> <property name="net.sf.jasperreports.export.xls.column.width" value="110"/> <property name="net.sf.jasperreports.export.xls.freeze.column.edge" value="left"/> </reportelement> &
Read more

media player - Android: mediaplayer went away with unhandled events -

-
i need duration of audio file series of voice announcements need play app. have added audio files resources , play fine. sample code below works perfect intended purpose: return duration of audio files. here code: float getdurationofaudioresource(locationenum loc, context context){ float duration = 0; try { mediaplayer mp; mp = mediaplayer.create(context, getaudioresource(loc)); duration = mp.getduration(); mp.release(); mp = null; } catch (illegalstateexception e) {e.printstacktrace(); logerror(25, "testdescitem:fault::could not open mediaplayer object audio resource.");} return duration; } here's weird thing. code called in main activity prepares set of audio instructions given test. there no errors within activity. second activity called, long string of errors on logcat. 03-07 13:23:43.820: i/actionlogger(21435): gentest_info_test #0 created. 03-07 13:23:43.830: i/actionlogger(21435): gente
Read more

python - ('The SQL contains 0 parameter markers, but 50 parameters were supplied', 'HY000') or TypeError: 'tuple' object is not callable -

-
import pyodbc,nltk,array cnxn = pyodbc.connect('driver={mysql odbc 5.1 driver};server=127.0.0.1;port=3306;database=information_schema;user=root; password=1234;option=3;') cursor = cnxn.cursor() cursor.execute("use collegedatabase ;") cursor.execute("select * sampledata ; ") cnxn.commit() s=[] j=[] x=[] words = [] w = [] sfq = [] pos=[] entry in cursor: s.append(entry.injury_type),j.append(entry.injury_desc) nltk.tokenize import punktwordtokenizer nltk.corpus import stopwords tokenizer = punktwordtokenizer() english_stops = set(stopwords.words('english')) in range(0,26): # filter stop words tokenizer.tokenize(j[i]) w.append([word word in tokenizer.tokenize(j[i]) if word not in english_stops]) in range(0 , 26):#converting tokenzied text ito string sfq.append(" ".join(w[a])) replacers import regexpreplacer replacer = regexpreplacer() in range (0,26):#pos tagging replacer.repl
Read more