Tableau Online for I3 Trip info, SoC etc.

[AlabamaJones]

Hi,

Gespielt mit der Verwendung von Connected drive-Daten für Trend-SoC, kWh / 100Km usw.
Abrufen von Connectedrive-Daten mit Python -> Google Tabellen -> Tableau Online.
Nach jeder Fahrt wird ein Eintrag speichert.

Schau hier Live-Beispiel an:

https://public.tableau.com/profile/poul ... ublish=yes

mfg

[Karl8901]

Toll, das würde mich auch interessieren. Wie funktioniert das genau? Brauche ich dafür einen eigenen Server? Hast Du ne Anleitung dafür?

[AlabamaJones]

Hi,

I can give my notes from my Python Code telling some about whats needed. The Python code itself is a few 100 lines. I do not know how i can upload it here but i will send you a PN with it.

# Poul W. Nielsen 2018-07-29
# beta version - usage on your own responsibility
# Get data from your BMW cacr on BMWConnected Data Portal and moves them to a Google Sheet. The Google sheet can be used by e.g. the free Tableau Online for fancy dashboards.
# It will only store and entry if there has been updated.
# If automation is needed you most set up a Tske Scheduled job on a windows computer.
# call with i3toGoogle <VIN> <USERNAME> <PASSWORD> <GOOGLESHEET>
# if <GOOGLESHEET> is set to NONE progrma will return values only on screen - Good for testing w.o. Google Sheets
# <VIN> is 16 char VIN
# USERNAME / PWD your BMW CD account
#prerequisites:
# create Google Sheets and call it BMWI3 Make headerlines in row 1 as:
# vin updateTime mileage ssoc_hv_percent soc socMax lastTripKm actDistWoCharging lasttripkWH00 lasttripRegenAvg
# (you most have a free google account)

# make pygsheet authorization json file, name it I3toGoogleSheet.json and place in same folder as program.
# see https://github.com/nithinmurali/pygsheets and - see about "Obtain OAuth2" under Basic Usage )

# If you want to use Tableau you must make a tableau Online Account. make a copy of My tableu Public and change datasource to your own google BMWI3 sheet
# Otherwise you can just read the data in the Google Sheet or any other visualization tool you prefer

#If programming/want to make changes to program etc. (only relevant if you're not running the compiled executable)
# Python 3.6.x
# pip3 install https://github.com/nithinmurali/pygshee ... taging.zip
# pip3 install pyinstaller
# pip3 install requests
# pip3 install wheel
# pip3 install --upgrade oauth2client
# pip3 install https://github.com/nithinmurali/pygshee ... master.zip
# python -m pip install --upgrade pip