| Home |
| Log In... |
| Dragonnorth... |
Overview
The Erallo Scale logging system captures weights in a patients home and logs them automatically on a web server. This system is a proof of concept system. The data capture and reporting is robust. The presentation of the data is simplistic.
The scale 
is observed by the rabbit development module 
which uses standard 802.11 Wireless networking to send the weights to
a database running on a server.
See the Instructions on how to set up and use the scale.
Weight Reports
A tab delimited report for Excel is only available when all of the data for a person or group of people is reported. First Get the full report and then a link to the tab delimited report for Excel will appear.
| Person 3974 | ID | Time (server local) | KG | lbs | M | Scale Sequence | Scale Time (GMT) |
|---|---|---|---|---|---|---|---|
| 361 | 2007-11-16 07:52:02 | 158.1 | 32 | 2007-11-16 12:51:39 | |||
| 360 | 2007-11-16 07:35:08 | 71.8 | 158.3 | 31 | 2007-11-16 12:34:44 | ||
| 359 | 2007-11-15 23:27:17 | 72.6 | 160.1 | 30 | 2007-11-16 04:26:30 | ||
| 358 | 2007-11-15 23:21:41 | 75.2 | 165.8 | 29 | 2007-11-16 04:20:54 | ||
| 357 | 2007-11-15 23:19:10 | 75.4 | 166.2 | 28 | 2007-11-16 04:18:47 | ||
| 356 | 2007-11-15 06:37:06 | 71.6 | 157.8 | 27 | 2007-11-15 11:36:33 | ||
| 355 | 2007-11-14 21:59:45 | 75.8 | 167.1 | 26 | 2007-11-15 02:58:38 | ||
| 354 | 2007-11-14 09:03:58 | 62.0 | 136.7 | 25 | 2007-11-14 14:03:26 | ||
| 353 | 2007-11-14 09:03:16 | 71.1 | 156.7 | 24 | 2007-11-14 14:02:41 | ||
| 352 | 2007-11-14 07:12:48 | 71.2 | 157.0 | 23 | 2007-11-14 12:12:02 | ||
| 351 | 2007-11-13 08:29:30 | 71.7 | 158.1 | 22 | 2007-11-13 13:28:58 | ||
| 350 | 2007-11-13 06:44:14 | 71.6 | 157.8 | 21 | 2007-11-13 11:43:25 | ||
| 349 | 2007-11-12 08:45:40 | 72.0 | 158.7 | 20 | 2007-11-12 13:45:09 | ||
| 348 | 2007-11-11 06:42:19 | 72.0 | 158.7 | 19 | 2007-11-11 11:41:47 | ||
| 347 | 2007-11-10 06:36:57 | 71.8 | 158.3 | 18 | 2007-11-10 11:36:27 | ||
| 346 | 2007-11-10 00:07:25 | 75.0 | 165.3 | 17 | 2007-11-10 05:06:55 | ||
| 345 | 2007-11-09 08:26:28 | 72.5 | 159.8 | 16 | 2007-11-09 13:25:59 | ||
| 344 | 2007-11-09 06:58:34 | 72.0 | 158.7 | 15 | 2007-11-09 11:58:00 | ||
| 343 | 2007-11-09 06:11:24 | 72.0 | 158.7 | 14 | 2007-11-09 11:10:55 | ||
| 342 | 2007-11-08 23:01:57 | 75.4 | 166.2 | 13 | 2007-11-09 04:00:54 | ||
| 341 | 2007-11-08 22:59:26 | 76.0 | 167.5 | 12 | 2007-11-09 03:58:57 | ||
| 340 | 2007-11-08 21:21:44 | 66.5 | 146.6 | 8 | 2007-11-09 02:21:20 | ||
| 339 | 2007-11-08 21:18:04 | 63.4 | 139.8 | 7 | 2007-11-09 02:17:39 | ||
| 338 | 2007-11-08 21:15:30 | 57.5 | 126.8 | 6 | 2007-11-09 02:15:06 | ||
| More... | |||||||
Logging Data
The scale logs data by making a request request to the page http://www.dragonnorth.com/scalelog.php each correct reference will log a sample in the ScaleLog table. Required arguments are 'PersonID' and 'Password'. All arguments except 'Password' are placed in the table.
Example URL:
http://www.dragonnorth.com/scalelog.php?PersonID=1&Password=foo&KG=152.3&ScaleSequence=1
All GET and POST variables to the page are placed in a single table in the database. Many rows in the database table are created for each sample logged, one row for each GET/POST variable to the logging page. Each variable name and value is placed in a row of the logging table along with a sequence number that identifies which entries were logged as a group.
The following insert is used:
INSERT INTO ScaleLog (ServerSequence,PersonID,ServerTime,FieldName,FieldValue)
Webmaster: mnewman@dragonnorth.com