Plotter cvs export, time step

[tiarfin]

Hi to Everybody,
does anybody know which is the time interval used exporting a plotter signal into a csv file?

Thank you very much in advance.
Regards,
Tiarfin

[PEAK-Support]

The Plotter get the Data from the Tracer. So for every signal the X Resolution is depending on the Time when the Signal was received via CAN, or for internal Signals when the Value was changed the last time.
If you have a Trace with 4 Signals, 2 comes on one CAN ID that was received 4 times per Second, and 2 on a CAN ID that was received 10 times per second, then you will see in the CSV:
2 Signals with a Value every 250ms (4 times a second) and 2 Values with a timing of 100ms (10 times a second). So the CSV have for the first two signal less entries (rows) as the other two signals.

[tiarfin]

Thank you very much for the quick reply. If I understand correctly if my can trace sequence is like the following:

;$FILEVERSION=1.3
;$STARTTIME=41102.6044339009
;
; C:\Users\pripta\Desktop\documenti\SOFTWARE\WC2H\EATON\WC2H_PROT_#LEP01007\12.07.2012\TEST_JOYSTICK_DEMAND\joystick_pos.trc
; Start time: 12.07.2012 14:30:23.089.0
;-------------------------------------------------------------------------------
; Bus Name Connection Protocol
; 1 PCANLight_USB_16_EP_CAN1 PCANLight_USB_16@pcan_usb CAN
;-------------------------------------------------------------------------------
; Message Number
; | Time Offset (ms)
; | | Bus
; | | | Type
; | | | | ID (hex)
; | | | | | Reserved
; | | | | | | Data Length Code
; | | | | | | | Data Bytes (hex) ...
; | | | | | | | |
; | | | | | | | |
;---+-- ------+------ +- --+-- ----+--- +- -+-- -+ -- -- -- -- -- -- --
1) 5.241 1 Rx 0100 - 8 00 00 FF 00 00 00 00 00
2) 15.267 1 Rx 0100 - 8 00 00 FF 00 00 00 00 00
3) 25.250 1 Rx 0100 - 8 00 00 FF 00 00 00 00 00
4) 35.276 1 Rx 0100 - 8 00 00 FF 00 00 00 00 00
5) 45.259 1 Rx 0100 - 8 00 00 FF 00 00 00 00 00
6) 55.242 1 Rx 0100 - 8 00 00 FF 00 00 00 00 00
7) 65.268 1 Rx 0100 - 8 00 00 FF 00 00 00 00 00
8) 75.251 1 Rx 0100 - 8 00 00 FF 00 00 00 00 00
9) 85.277 1 Rx 0100 - 8 00 00 FF 00 00 00 00 00
10) 95.260 1 Rx 0100 - 8 00 00 FF 00 00 00 00 00
11) 105.243 1 Rx 0100 - 8 00 00 FF 00 00 00 00 00

This means that the time intervall between a can ID message and the following is of 10ms.
The related plotter csv export file is like the following:

pos_abs_x(X) pos_abs_x(Y) pos_abs_y(X) pos_abs_y(Y)
41102,6141564549 0 41102,6141564549 0
41102,6141565704 0 41102,6141565704 0
41102,6141566865 0 41102,6141566865 0
41102,6141568020 0 41102,6141568020 0
41102,6141569181 0 41102,6141569181 0
41102,6141570336 0 41102,6141570336 0
41102,6141571492 0 41102,6141571492 0
41102,6141572652 0 41102,6141572652 0
41102,6141573807 0 41102,6141573807 0
41102,6141574963 0 41102,6141574963 0
41102,6141576123 0 41102,6141576123 0
41102,6141577279 0 41102,6141577279 0
41102,6141578439 0 41102,6141578439 0
41102,6141579583 0 41102,6141579583 0
41102,6141580748 0 41102,6141580748 0
41102,6141581899 0 41102,6141581899 0
41102,6141583054 0 41102,6141583054 0
41102,6141584215 0 41102,6141584215 0
41102,6141585370 0 41102,6141585370 0
41102,6141586526 0 41102,6141586526 0
41102,6141587686 0 41102,6141587686 0
41102,6141588841 0 41102,6141588841 0

In this case the time signal in (X) is given in [sec] x 10^5 , is this right?

Thanks for the feedback.

Regards,
Tiarfin

[PEAK-Support]

The CSV Export use a special microsoft time-format to convert. Please take a look at these Forum Threads: Convert Plotter PLT files to CSV

The DATE type is implemented using an 8-byte floating-point number. Days are represented by whole number increments starting with 30 December 1899, midnight as time zero. Hour values are expressed as the absolute value of the fractional part of the number. You need to use a custom format inside Windows Excel: TT.MM.JJJJ hh:mm:ss,000

You also could Export the Trace files directly to CSV, and select single Signals to export. This function is implemented since PCAN-Explorer 5 Version 5.2.2.

[tiarfin]

Problem solved, thank you very much.

Regards,
tiarfin

[Yan]

Hi.

Is there a way to subsampling CAN messages before export it to .csv ?
As my CAN frames are numerous and fast, .csv is huge and can't be opened with my old Excel version (65k row limit).

I've see here (http://www.peak-system.com/forum/viewto ... f=50&t=109) there is a way to custom .csv export. I don't find these options (I've PCANExplorer v2.2.1.146, and a button called "Export to CSV" at the top of my .plt figure but I can only choose the path to save the .csv). But seeing snapshots, it seems there is no way to solve my problem with this menu.

Any idea ?
Thanks.

[PEAK-Support]

As my CAN frames are numerous and fast, .csv is huge and can't be opened with my old Excel version (65k row limit).

Hughe CSV Files could be open with free available Open Office Version.

there is a way to custom .csv export. I don't find these options (I've PCANExplorer v2.2.1.146, and a button called "Export to CSV" at the top of my .plt figure but I can only choose the path to save the .csv

If you Update to the latest Version (at the Moment 5.2.2), the feature is available - see Improvements Information for PE 5.2.2. The Update could be done directly from the start screen of your PE5.

PE5 Start Screen with Update Option. Also a RSS Feed for Update Information is available.

PE5-Start.JPG (71.48 KiB) Viewed 20636 times