Mini Datalogger Project

[takai]

The wiichuck is a i2c 2-wire bus. Plus power and ground. Setup there im using a $2 adaptor to drive it which picks up on an analog line as 5v highfor power.

[punkture]

takai or mwp can i send you some code for a picaxe to verify its correct? its all wired up fine but looks like the lcd isnt initialised, its paralell in 4-bit mode with D0-D3 grounded as well as R/W. all the rest is per its manual. sorry but picaxe.uk hasnt approved for posting yet =(

[MWP]

Ive never used a picaxe before, no point in me looking at it.

[takai]

I havnt used PICs for about 10 years. Not much use here.

[MWP]

Chris, can you give your CSV's a header like the following:

#STARTING: 1291775902
#NAME: dack_gps
#FORMAT: time_ns;gps_time;fix;latitude;longitude;altitude;speed;hdop;sats
#DBFORMAT: bigint;float;tinyint;double;double;float;float;float;tinyint
1291776044073712390;24029.300000;2;-35.230307;137.550502;66.900000;0.310000;0.970000;8
1291776044172830562;24029.400000;2;-35.230307;137.550502;66.900000;0.340000;0.970000;8
1291776044281324208;24029.500000;2;-35.230307;137.550502;66.900000;0.340000;0.900000;9
1291776044377279300;24029.600000;2;-35.230307;137.550502;66.900000;0.340000;0.900000;9

"#" at start of line is a comment line.
The following 4 lines must be present in the top 10 lines of the file.
#STARTING logging start time in seconds since epoch (local unix time).
#NAME must a mysql friendly table name.
#FORMAT must have mysql freindly column names. "time_ns" must be present and first.
#DBFORMAT must be valid mysql data format types.

The import script creates the DB tables from the info above so the data stored in the CSV's can be quite flexible.
Obviously, after the first imported CSV, all following using the same table have to have the same format.

[edit]
Updated the above...

PHP csv->mysql import script is working

/home/mark/eeeDash# ./import_to_db.php
Starting import...
Data location: /home/mark/eeeDash/data
Processing: 1291775902-dack-im.csv - creating table "dack_im", no data in table, inserted 10573, done.
Processing: 1291775902-dack-mt.csv - creating table "dack_mt", no data in table, inserted 5042, done.
Processing: 1291775902-dack-gps.csv - creating table "dack_gps", no data in table, inserted 10828, done.
Processing: 1291775902-dack-wlan.csv - creating table "dack_wlan", no data in table, inserted 0, done.

[punkture]

woooo i succesfully interfaced my lcd =)

[takai]

Yeah i can do that easily MWP. Although ditch the tinyint fields for int fields. Mysql runs much faster with ints than tinyints at the saving of buggerall space

[punkture]

has anybody used a megasquirt? are they effective? or would they be runnign a 3sgte..theres a fair few 'success' stories and huge user base

[OnAll-FOUR]

punkture, wrong thread mate. do some searching in technical section of google.

[takai]

Oh yeah, this arrived today:


Wont be used for this project, but just to give an idea of how small they can get

[StuC]

This shit is cool - you gonna make these to sell Chirs or sell as DIY packages with code, instructions and parts list etc???

[takai]

Nah, ill just post the code available. Let people build their own.

[OnAll-FOUR]

Are you getting these through a website?

[takai]

There are a bunch of resellers for the Arduino. Ive been using both Sparkfun in the US as well as LittleBird locally. This last one came from RobotGear.
Pricing varies a little bit, but all have had good service