Log file is .txt instead of .csv

  • 925 Views
  • Last Post 27 August 2016
PizzaManagaement posted this 26 August 2016

When I try to send myself my history log, it only sends as a .txt file. How can I send as a .csv?

This is an example of a portion of the text file:

*****

meta-info header:travel file

file version:2

app version:1.8.2

time:1472247317348

type:1

name:1

gps:true;id=latitude,type=0;id=longitude,type=0;id=speed,type=1;id=time,type=0;id=altitude,type=0;id=accuracy,type=0

cmdDesc:010C=Engine RPM;UnitType=rpm;Unit=1

cmdDesc:010D=Speed;UnitType=mil/h;Unit=1

cmdDesc:0111=Throttle Position;UnitType=%;Unit=1

cmdDesc:0110=MAF air flow rate;UnitType=grams/sec;Unit=1

cmdDesc:0#04=Fuel Economy Average (inverse);UnitType=mil/gal;Unit=1

cmdDesc:0#02=Fuel Economy (inverse);UnitType=mil/gal;Unit=1

*****

1472247317445;0110;5.03

1472247317446;gps;33.992538:-118.472202:0.0:1472247138:1.957040:65.0

1472247317667;0111;17.65

1472247317772;010D;0

1472247317774;0#04;Insufficient distance

1472247317775;0#02;0

1472247317918;gps;33.992559:-118.472224:0.0:1472247317:1.957040:116.0

1472247318077;010C;808

1472247318174;0110;5.00

1472247318250;0111;17.65

1472247318388;010D;0

1472247318391;0#04;Insufficient distance

1472247318392;0#02;0

1472247318549;010C;812

1472247318647;0110;4.98

1472247318739;0111;17.65

1472247318852;010D;0

1472247318854;0#04;Insufficient distance

1472247318856;0#02;0

1472247318982;010C;818

...

 

inCarDoc posted this 27 August 2016

Cut off the header, that is portion of text marked by lines of ****, the remaining part is csv formatted with semicolon (;) as a separator. One could use Excel import from text routine where specify correct start line (first data line after header) and column separator (;)

 

The second column could be used in Excel to filter a specific observation characteristic. Meaning of characteristics ID's are described in a Header. For example if you want select Speed, use 010D as filter to select appropriate data.

Thanks!