Volkswagen e-Golf Forum

It is currently Tue Mar 19, 2019 3:47 am

All times are UTC - 8 hours [ DST ]




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Export trip and consumption data from Car-Net
PostPosted: Thu Nov 29, 2018 9:17 am 
Offline

Joined: Sat Nov 17, 2018 5:08 pm
Posts: 42
Location: Boston area, MA
Has anyone out there figured out a way to export trip and consumption data from Car-Net to, say, a spreadsheet or some other useful file format?

I haven't seen anything obvious, and given how limited and baffling the app is (e.g. not possible to set up a notification for when your car is fully charged, but you can enable a notification for when your non-existent sunroof is open), I suspect it's not possible, but I thought I'd at least ask.

_________________
2018 VW e-Golf SEL Premium (w/ DAP) - Silver White w/ black interior


Top
 Profile  
 
 Post subject: Re: Export trip and consumption data from Car-Net
PostPosted: Mon Feb 18, 2019 3:02 pm 
Offline

Joined: Sun Nov 19, 2017 12:18 am
Posts: 27
At least for US customers, when logged into the carnet.vw.com, selecting the "Trips" tab, all the data for the charts is in a hidden HTML form element, in JSON format. You can find the "view page source" in whatever browser you use, and search for "_tripstatisticsportlet_WAR_tripstatisticsportlet_tripsJson" to find the HTML form element. The data is in the value attribute, but with lots of stuff encoded as html entities (like   for the space character). More straight forward is to get at it via the javascript console, where you can enter:

Code:
document.querySelector('#_tripstatisticsportlet_WAR_tripstatisticsportlet_tripsJson').value


and press return to get the value with the HTML entity encoding resolved. The format is JSON array of objects that look like:

Code:
  {
    "vehicleStatisticsId": "24541342",
    "dateTime": "Jan 25, 2019 at 3:53 PM PST",
    "tripDate": "Jan 25, 2019",
    "distance": 14.91,
    "averageSpeed": 29.2,
    "totalConsumption": 4.5,
    "travelTime": 31
  }


This data contains up to 6 months of data in one big array, loaded once when you load the "Trips" tab.

My understanding is that in the US, carnet is based on Hughes Telematics systems, which was purchased by Verizon in 2012 (see https://www.verizonconnect.com/solution ... agnostics/). At one point I found some code for talking to a Hughes telematics API, but I'm not finding that at the moment, though I'm sure I saved the link somewhere.

I wouldn't be surprised if in other markets, Carnet implementation is completely different.


Top
 Profile  
 
 Post subject: Re: Export trip and consumption data from Car-Net
PostPosted: Mon Feb 18, 2019 3:31 pm 
Offline

Joined: Sat Nov 17, 2018 5:08 pm
Posts: 42
Location: Boston area, MA
Thanks so much! Works like a charm to get the JSON and then convert it manually into Excel format. Your instructions made it easy. Much appreciated.

How hard would it have been for VW to put in a button on that page to download the data as XLSX or CSV format, btw? Car-Net has so much untapped potential...

_________________
2018 VW e-Golf SEL Premium (w/ DAP) - Silver White w/ black interior


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC - 8 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Volkswagen e-Golf Forum - part of the MyElectricCarForums.com Group