[Kst] Combine date / time columns to one x-axis

[Alexander Poddey]

Hi Peter & Nicolas

my problem seems to be that I have only kst 1.7 on my debian squeeze.
I can import the sensor data using the seperator '; '.
Importing Date and time fields fails for all choices c-time and seconds.
Formated time seems not to be supported in 1.7.
I have access to the c-code which writes the data and could combine date and 
time to anything. what would be the preferred way to see date/time correctly 
on the x-axis?

thx
Alex

> On 20.11.2012 23:58, Nicolas Brisset wrote:
> > Hi Alexander,
> >
> > sorry for not answering before. With 2.0.7 (beta4 currently available for
> > Windows on sf.net, otherwise from svn) you could merge time and date if
> > the columns were separated only by whitespace (no semicolon). We'll have
> > to see whether we can also accept a semicolon or other separator, it
> > should be feasible.
>
> In case of reading the date the delimiteris not important, only that there
> is only one space between date and time. Here the needed options in the
> Ascii dialog:
>   - "Data starts at line:" 2
>   - "Read field names from line:" 1
>   - select "Custom Delemiter" and set it to ;
>   - Interpret Date as Formatted Time
>   - use "Time Format" dd.MM.yyyy; hh:mm:ss;
>
> Load all vectors but "Date" and "Time", then "Create XY plots" -> "Create
> from field" -> Date
>
> Double click on the Time axis:
>   - Interpret as "Standard C time"
>   - Display as -> select a format, e.g. QDateTime format string
>   - check "For Offset to axis Minimum"
>
> > In order to do so, in the ASCII configuration dialog you have to set in
> > the General options Interpret Column1 as Formatted String and use as
> > Time/Date format: dd.MM.yyyy hh:mm:ss Doing so Column1 gets read as C
> > time, and you can then turn on C time interpretation and time display
> > options in the X axis dialog (double-click on the values on an X axis,
> > then select multiple to select all plot, then select time
> > interpretation/display options).
> >
> > I hope that's clear, if not don't hesitate to ask for details.
> >
> > Nicolas
> >
> > ----- Mail original -----
> >
> >> De: "Alexander Poddey" <alexander.poddey at gmx.net>
> >> À: kst at kde.org
> >> Envoyé: Samedi 17 Novembre 2012 08:15:57
> >> Objet: [Kst] Combine date / time columns to one x-axis
> >>
> >> Hi all,
> >>
> >> from a controller, I have data with separate date / time column
> >>
> >> Date;Time;Sens1;Sens2;Sens3;Sens4;Sens5
> >> 01.11.2012; 00:03:10; 7.8; 71.8; 55.1; 58.3; 22.6
> >> 01.11.2012; 00:08:10; 7.8; 71.8; 55.1; 58.1; 22.7
> >> 01.11.2012; 00:13:10; 7.8; 71.8; 55.1; 57.8; 22.6
> >> 01.11.2012; 00:18:10; 7.9; 71.7; 55.1; 57.5; 22.7
> >>
> >> is it possible to combine the first two cloumns as x-axis and plot
> >> x,y1,y2
> >> etc.?
> >> The data is equiapced; perhaps it might be easier to plot as
> >> equispaced
> >> y-values, using date & time as labels?
> >>
> >> Thx
> >> Alex
> >>
> >>
> >> _______________________________________________
> >> Kst mailing list
> >> Kst at kde.org
> >> https://mail.kde.org/mailman/listinfo/kst
> >
> > _______________________________________________
> > Kst mailing list
> > Kst at kde.org
> > https://mail.kde.org/mailman/listinfo/kst
>
> _______________________________________________
> Kst mailing list
> Kst at kde.org
> https://mail.kde.org/mailman/listinfo/kst