Page 1 of 2

Export as csv?

Posted: May 7th, 2013, 10:40 am
by skiptownmcat
Is it just me or has this button disappeared in the latest vt version?

Re: Export as csv?

Posted: May 7th, 2013, 2:13 pm
by crashdan
Nope mine is still there.... Make sure you open logs with VT and not by double clicking on a exported VT LOG. It open like a Log view with no export then... Well thats what i saw once

Re: Export as csv?

Posted: January 5th, 2014, 10:26 pm
by sidekick
I'm trying to figure out how to export as CSV and I don't see a button in the logs screen.

EDIT: I found it and it seems to be working fine. Why does it export with so many places after the decimal?

Re: Export as csv?

Posted: January 7th, 2014, 3:41 am
by mituc
Well, I guess this is how some of the values are read and then later interpolated. Basically this is how this thing works:
1. the logging software will read the values for several PIDs at once, but not for all;
2. when exporting to CVS the time values are somehow quantified so that we have a discrete pool of time values;
3. if two consecutive time values when a PID value was read are X and Y, and the CSV quantified time value is Z, where Z is greater than X but less than Y, the logging software will make a linear interpolation for the value of the PID for time Z.
Say, if at second (X=)1 the boost is 10PSI and at second (Y=)2 the boost is 12PSI, then if the logging engine decides to display a line for time Z=1.5s the boost value displayed will be 11PSI. Or fi Z=1.3s then the boost value displayed in the log will be 10.6PSI. Sometimes this results in a lot of decimals, but sometimes the reading itself has a few decimals already (think of a value interpolated based on a voltage curve from a sensor).

This is how I think it works, more or less exact, but pretty close to how it actually works. I'm not sure if the interpolation is always linear (even though it should work with minimal errors at this time resolution).

Re: Export as csv?

Posted: January 8th, 2014, 11:54 am
by Ugnius @ VersaTune
Thanks for the detailed explanation, mituc. That's exactly how it works. The ECU can usually provide one value at a time, so it uses linear interpolation to calculate the values of all parameters at discrete time points.

Re: Export as csv?

Posted: January 23rd, 2014, 10:04 am
by SpeedRebirth
The decimal thingy in logs are actually very irritating. There is no reason for me to see values like 15.59374920
Only makes the logs harder to read. Trim it down to 2 or 3 decimals in the next VT version, PLEASE :)

Re: Export as csv?

Posted: January 24th, 2014, 4:17 pm
by mituc
Reconfigure your spreadsheet program to show less decimals. Mine does that by default (open office). The high number of decimals makes perfect sense in some situations and metric systems.

Re: Export as csv?

Posted: January 27th, 2014, 8:34 am
by manselainen
A small excel macro helps a lot. Insert a table, format columns, add columns & calculations if you want, add header etc.

Re: Export as csv?

Posted: January 31st, 2014, 4:50 pm
by sidekick
So, I've found that if you double click a log file to open it, you don't have the option to export as CSV. If you open it via the "open log file" button in VT, you can export as VT. Kind of annoying, but not the end of the world.

Re: Export as csv?

Posted: June 1st, 2017, 6:30 pm
by Dolfius
Thought I'd necro this thread instead of starting a new one. Very recently became a VT convert. I can't seem to see/find how to export or open log files in CSV format.

Did something change over the years and updates, or am I just really that blind? Any help would be appreciated.