Hi James,<div>Reading csv files is relatively straighforward. BUT: the only time formats we support are JD and c-time "seconds since Jan 1, 1970".</div><div><br></div><div>Once the data are read, it is trivial to display the X-axis in sensible time formats.</div>
<div><br></div><div>I have as a very important medium term priority convincing kst to be able to read more general time formats. I hope to have this done by spring 2012 (famous last words...)</div><div><br></div><div>Barth</div>
<div><br><div class="gmail_quote">On Thu, Jan 26, 2012 at 12:59 PM, James Taylor <span dir="ltr"><<a href="mailto:james@oakseed.demon.co.uk">james@oakseed.demon.co.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi,<br>
<br>
Thanks for kst! I can see that it will be wonderful once I crack this<br>
problem I'm having with time formats.<br>
<br>
I'm trying to work with the CSV output from the dstat system monitoring<br>
utility. I do not seem to be able to get kst to correctly interpret the<br>
time format that dstat outputs, and even if I could, I cannot work out<br>
how to make it use that as the X-axis in all the graphs each time I load<br>
a new CSV file.<br>
<br>
The dstat command I'm using is actually this:<br>
<br>
dstat -tlpcmgfdny --tcp --nocolor --output dstat.csv >> dstat.log &<br>
<br>
which generates lots of columns of data, but here is a simple example of<br>
the dstat output of just a few columns:<br>
<br>
dstat -tlc<br>
<br>
----system---- ---load-avg--- ----total-cpu-usage----<br>
date/time | 1m 5m 15m |usr sys idl wai hiq siq<br>
27-01 00:36:34|1.88 1.21 0.99| 66 14 20 0 0 0<br>
27-01 00:36:35|1.81 1.21 0.99| 55 17 27 0 0 1<br>
27-01 00:36:36|1.81 1.21 0.99| 57 21 21 0 0 1<br>
27-01 00:36:37|1.81 1.21 0.99| 71 17 12 0 0 0<br>
27-01 00:36:38|1.81 1.21 0.99| 61 17 21 0 0 1<br>
27-01 00:36:39|1.81 1.21 0.99| 54 14 32 0 0 0<br>
27-01 00:36:40|2.14 1.29 1.01| 49 17 34 0 0 0<br>
27-01 00:36:41|2.14 1.29 1.01| 60 10 29 0 0 1<br>
27-01 00:36:42|2.14 1.29 1.01| 57 43 0 0 0 0<br>
27-01 00:36:43|2.14 1.29 1.01| 51 26 22 0 0 1<br>
27-01 00:36:44|2.14 1.29 1.01| 59 12 29 0 0 0<br>
27-01 00:36:45|2.13 1.30 1.02| 54 16 28 2 0 0<br>
27-01 00:36:46|2.13 1.30 1.02| 64 23 13 0 0 0<br>
<br>
The above is the screen output but the CSV file has the same data<br>
including the time in that same format. This time format is not<br>
recognised by kst, or I don't understand how to make it happen. I could<br>
write a small filter in Perl to change the date into a format that kst<br>
recognised if only I knew exactly what that should be. A nice standard<br>
format would be RFC-3339 for example. Can kst handle that?<br>
<br>
Once I have a format that kst understands I want to be able to plot the<br>
values in the other columns with the time on the x-axis, because the<br>
time steps are not always regular so plotting against INDEX does not<br>
show accurate results. I need to plot again time.<br>
<br>
Can you point me in the right direction please?<br>
<br>
Thank you.<br>
<br>
Yours,<br>
<span class="HOEnZb"><font color="#888888">--<br>
James Taylor<br>
<br>
<br>
<br>
_______________________________________________<br>
Kst mailing list<br>
<a href="mailto:Kst@kde.org">Kst@kde.org</a><br>
<a href="https://mail.kde.org/mailman/listinfo/kst" target="_blank">https://mail.kde.org/mailman/listinfo/kst</a><br>
</font></span></blockquote></div><br><br clear="all"><div><br></div>-- <br><span style="font-family:arial,sans-serif;font-size:13px;border-collapse:collapse;color:rgb(136,136,136)">C. Barth Netterfield<br>University of Toronto<br>
416-845-0946</span><div><span style="font-family:arial,sans-serif;font-size:13px;border-collapse:collapse;color:rgb(136,136,136)"><br></span></div><br>
</div>