🏴: Difference between revisions

From Noisebridge
Jump to navigation Jump to search
m (Undo revision 63066 by 185.38.14.215 (talk))
(CAN to SQLite)
Line 19: Line 19:


== "app notes" ==
== "app notes" ==
'''some features ONLY work in chrome, and there are some issues on linux with chromium'''


*Fix double scroll bars
*Fix double scroll bars
*Add better grabbers for bit selection
*Add better grabbers for bit selection
*Make segment selection clearer in plot
*Make segment selection clearer in plot
*Show multi-signal overlay
*Show multi-signal overlay


Line 41: Line 42:
1:400  SMOOTH_CRUISE_PING    bit 20 some kind of flag/watchdog triggers at regular interval when moving above min speed
1:400  SMOOTH_CRUISE_PING    bit 20 some kind of flag/watchdog triggers at regular interval when moving above min speed
       X_COUNT_UP_10_SEC    also contains 10 second incremental count in last byte.
       X_COUNT_UP_10_SEC    also contains 10 second incremental count in last byte.
</pre>




== hack'n around ==
You can use the save log button to get a csv file of the data, this only works with chrome and some versions of chromium.
The following converts the csv file to a sqlite3 database file name 'data.db', with a table named 'can' containing all the records.
<pre>
import sqlite3
import pandas
conn = sqlite3.connect('data.db')
df = pandas.read_csv('data.csv')
df.to_sql('can', conn, if_exists='append', index=False)
</pre>
</pre>

Revision as of 16:14, 9 January 2018

Hack teh Cabañas here https://community.comma.ai/cabana/?demo=1337

"Cabana" is a tool for deciphering CAN data, which is what cars use for talking to themselves.


Get a 🐼 here: https://shop.comma.ai/products/panda-obd-ii-dongle

Build a 🐼 here: DIY Panda




🏴


"app notes"

some features ONLY work in chrome, and there are some issues on linux with chromium

  • Fix double scroll bars
  • Add better grabbers for bit selection
  • Make segment selection clearer in plot
  • Show multi-signal overlay


dumpster dive data

Messages sorted by highest event count, with a descriptive'ish name and unique ID.


acura_ilx_2016_can.dbc

Identified bit that looks like some kind of watchdog or interupt trigger when vehicle is moving above min speed.

ID     Signal                Note
1:400  SMOOTH_CRUISE_PING    bit 20 some kind of flag/watchdog triggers at regular interval when moving above min speed
       X_COUNT_UP_10_SEC     also contains 10 second incremental count in last byte.


hack'n around

You can use the save log button to get a csv file of the data, this only works with chrome and some versions of chromium.

The following converts the csv file to a sqlite3 database file name 'data.db', with a table named 'can' containing all the records.

import sqlite3
import pandas
conn = sqlite3.connect('data.db')
df = pandas.read_csv('data.csv')
df.to_sql('can', conn, if_exists='append', index=False)