Logo   Scale Log Report

Home

Log In...
New User...
All Users...

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.

Reports for individual people are available:

Person 1
Person 3974
Person 4614
Person 4630
Person 4658

Person 1IDTime (server local)KGlbsMScale SequenceScale Time (GMT)
 4732008-11-25 09:04:51200440.91.78  
 4722008-11-25 09:04:47200440.91.78  
 4712008-11-25 09:03:59200440.91.78  
 4702008-11-24 22:57:05200440.91.78  
 4692008-11-24 22:55:10200440.91.78  
 4602008-11-17 11:00:51152.3335.8 1 
 2472007-10-23 14:38:50152.3335.8 1 
Person 3974IDTime (server local)KGlbsMScale SequenceScale Time (GMT)
 4742008-11-30 21:12:04152.3335.8 1 
 4592008-08-07 20:48:0153.5117.9 22008-08-08 00:47:41
 4582008-08-06 16:27:18108.5239.2 572008-08-06 17:17:04
 4572008-07-28 07:07:0170.7155.9 562008-07-28 11:06:41
 4562008-07-28 07:06:4770.7155.9 552008-07-28 11:05:54
 4552008-07-28 06:04:5870.3155.0 542008-07-28 10:04:34
 4542008-07-28 03:44:2153.0116.8 532008-07-27 10:53:00
 4532008-07-28 03:44:1270.6155.6 522008-07-26 08:17:18
 4522008-07-24 08:09:4982.1181.0 512008-07-24 12:09:27
 4512008-07-24 08:05:5360.5133.4 502008-07-24 12:05:33
 4502008-07-24 08:05:402.55.5 492008-07-24 12:04:52
 4492008-07-24 06:34:2359.4131.0 482008-07-24 10:33:51
 4482008-07-24 06:32:0570.7155.9 472008-07-24 10:31:35
 4472008-07-24 06:27:2770.6155.6 462008-07-24 10:27:05
 4462008-07-24 04:26:4770.3155.0 452008-07-24 08:26:08
 4452008-07-24 01:25:1153.4117.7 442008-07-24 05:24:52
 4442008-07-24 01:22:3469.4153.0 432008-07-24 05:21:33
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)

                                                                                                                                                       
Erallo Work Log for Michael Newman. Send comments and corrections to:
Webmaster: mnewman@dragonnorth.com