by bz2012 » Sun Feb 24, 2013 8:51 am
Wish some script wizard would write a script that would access the drives database and export all drives between any two dates to a .csv formatted file, sorted by date.
I have manually gone through a whole year using 'select', copy, paste to text file in edit++, wrote a macro to go through and combine the two data lines per drive into a single line.
Then copied all the stuff from the text file, pasted it to an excel spread sheet, cleaned it up and converted the km to miles, sorted by date.
From the looks of the code, it should be possible to write a script that would grab the drives data and export it.
I am just interested in date/time/milage for each drive. Some users may want the actual gps points. Either should be possible.
Many many months ago, I asked support and they said 'it is in the works'. Somehow I suspect that they have better things to do.
Any volunteers?