[Babase] Is Psion wierd or just Foxpro?

Leah Gerber lgerber at duke.edu
Mon Dec 19 16:40:30 EST 2005


Karl,

Here is an example from the original Psion file. This corresponds to 
FPID 308. The last row is the entry you are referring to. When I call 
this line up in fpsamps I do not have a .999th of a second in the 
datetime column.

<HDR>,0112031312MYS,PTSAMPLR_AUG01,SETUP_AUG01,2,03 Dec 2001,LIN,SNS,MYS,FEM
<PNT>,0112031312MYS,13:13:13,W1AN,XXX,XXX,XXX,
<PNT>,0112031312MYS,13:14:08,R2AN,LAN,XXX,XXX,
<PNT>,0112031312MYS,13:15:15,OS,,,,
<PNT>,0112031312MYS,13:16:04,R2OS,NAI,NAI,XXX,
<PNT>,0112031312MYS,13:17:03,R2OS,NAI,NAI,XXX,
<ADL>,0112031312MYS,13:17:36,A,NAI,OS,MYS
<PNT>,0112031312MYS,13:18:17,R2OS,NAI,NAI,XXX,
<PNT>,0112031312MYS,13:19:05,R2OS,NAI,NAI,XXX,
<PNT>,0112031312MYS,13:20:02,R2OS,NAI,NAI,XXX,
<PNT>,0112031312MYS,13:21:00,R2OS,XXX,XXX,XXX,

The row that I have in Foxpro is following:

fpid 	sid 	activity 	posture 	kidcontact 	kidsuckle 	time 	foodcode 
datetime
308 	56 	R 	2 	O 	S 	13:21 	
	12/3/2001 13:21:00 PM


Does this tell you what you need to know? I think if it is a problem 
then it is one on your end because it doesn't seem to be a problem in my 
Foxpro or the original Psion data

Leah.
Karl O. Pinc wrote:

> Cathrine,
>
> Would you please look at some of the raw Psion data
> files and check something for me?  I notice that there
> are some FoxPro Datetime columns with that have a
> .999th of a second.  I suspect this is an oddity
> of the Foxpro datetime representation and that the
> Psion's really are supplying whole seconds, but would
> like to go back to the primary source and check.
>
> I suppose it could also be the utility that I'm using
> to convert out of foxpro's data format.
>
> Here's some Fpids that have a .999th of a second
> in their row's datetime column:
> 18
> 43
> 308
> 678
> 679
> 680
> 681
> 724
> 785
> 849
>
> This does not need to be checked right now as I've figured
> out how to scroodle the data appropriately for the conversion,
> but I would like it checked so that I can be sure that when
> we upload the Psion data the right things are done in the future.
> (There are issues surrounding the transition from one minute
> to the next.)
>
> Thanks.
>
> Karl <kop at meme.com>
> Free Software:  "You don't pay back, you pay forward."
>                  -- Robert A. Heinlein
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase



More information about the Babase mailing list