Understanding logged data

Inquiry and support for Freematics products
Jesas
Posts: 4
Joined: Fri Feb 03, 2017 7:11 pm

Re: Understanding logged data

Post by Jesas »

Hello protomor
Thank you very much for your link.
I tested it, but it throw this error: "Input string was not in a correct format" As you commented, it can be because the csv file does not contain GPS data.
Here is the csv I load:
http://mysharegadget.com/754814913
Thank you in advance.
Jesas
protomor
Posts: 99
Joined: Wed Oct 14, 2015 9:17 am

Re: Understanding logged data

Post by protomor »

https://drive.google.com/file/d/0ByBda7 ... sp=sharing

Let's give this one a shot. I don't get why your csv starts with a "#". that was really weird. Your PIDs also come in 2 digit form. I was always expecting 3. Anyway. This should get it working for the most part. It does bomb on torque export and kml export (obviously) because both rely on GPS data. It doesn't look as sexy when you don't have the GPS data. I have added a few new features for it.

Also, why don't your PIDs log with their pid names? I don't think I added in code for that but my logs say things like "RPM" and "CLT" instead of "10C"
nscoffey
Posts: 2
Joined: Thu Feb 16, 2017 3:53 am

Re: Understanding logged data

Post by nscoffey »

I've created an Excel file with some VBA that will import raw Freematics data, make a trip log, and export .csv files in a more readable format. It has only been tested on my car's data. It will ignore files that don't have date/time information but I could probably rewrite to look at another value (such as RPM).

Feel free to try it out and let me know if it works for you.

Blog Post:
https://nicolascoffey.wordpress.com/201 ... rter-v1-0/

Download:
https://app.box.com/s/s63qunax815lgjb866lrplq8lydyuvkv
protomor
Posts: 99
Joined: Wed Oct 14, 2015 9:17 am

Re: Understanding logged data

Post by protomor »

It doesn't seem to work with my csv files. But I also log lots of stuff and sometimes don't have GPS data. I have an error somewhere in the first quarter of the file "With Worksheets(wbName).Range("B:B")"

Does this spit out graphs and stuff?
protomor
Posts: 99
Joined: Wed Oct 14, 2015 9:17 am

Re: Understanding logged data

Post by protomor »

Anyone get a chance to try out my stuff? Latest version here: https://drive.google.com/file/d/0ByBda7 ... sp=sharing
nscoffey
Posts: 2
Joined: Thu Feb 16, 2017 3:53 am

Re: Understanding logged data

Post by nscoffey »

protomor wrote:
> It doesn't seem to work with my csv files. But I also log lots of stuff and
> sometimes don't have GPS data. I have an error somewhere in the first
> quarter of the file "With
> Worksheets(wbName).Range("B:B")"
>
> Does this spit out graphs and stuff?

Lack of GPS data will cause it to break (due to lack of day/time info). Do you have a sample of your data? I could probably tweak the code to accept files without GPS data.

It does not spit out graphs, but it does export a .csv file that would make it very easy to create graphs (data is formatted in a table).
Post Reply