[Babase] Re: New Psion File and Ranks and Gremlins

Karl O. Pinc kop at meme.com
Sat May 5 13:08:40 EDT 2007


On 05/05/2007 11:39:59 AM, Leah Gerber wrote:
> 
> -----"Karl O. Pinc" <kop at meme.com> wrote: -----
> 
> To: Leah Gerber <leah.gerber at duke.edu>
> From: "Karl O. Pinc" <kop at meme.com>
> Date: 05/05/2007 12:34PM
> Subject: Re: New Psion File and Ranks and Gremlins
> 
> 
> On 05/05/2007 10:51:21 AM, Leah Gerber wrote:
> > Hi Karl,
> >
> > I am at Susan's lab working with Lacey. We just looked into the
> psion
> > problem. There was one file that had the wrong setup id. Who knows
> how
> > that
> > happened! Gremlins! I changed the file back to July 03 instead of
> July
> > 13
> > and transferred it to papio. Next conversion it should be resolved.
> 
> There's no corresponding problem in the foxpro data?
> 
> We have NO idea how this could have happened and it only seems to be
> one
> file. The psion either had a nervous breakdown or something happened
> when
> the field team downloaded the data. Seeing as it is only one file we
> just
> changed it to the correct setup id. Should be resolved as far as the
> conversion goes and we will get Susan to look into why this happened
> in the
> first place.

The conversion only looks to the raw psion data files in the rare
case when no points are taken, so if the psion has been loaded
into foxpro you'll need to do an UPDATE statement in foxpro to
fix it there too.

> 
> > Also looked at the rank problem. Somehow when I appended the ranks
> the
> > gremlins took over again. allof the files I appended together look
> > right
> > but the final file is missing decimals....weird. I am going to try
> to
> > append them together again and see if it gets resolved. Any idea why
> > this
> > could happen? Hopefully I can send you a new ranks table in a few
> > minutes.
> 
> Cool.  The only thing I can think of is one of the dbf files having
> the wrong data type, integer instead of floating point, and that
> forcing everything to integer.  Or something.
> 
> I figured out what happened. I had appended one file for Alto's group
> and
> the group is 1 with no decimals. It then caused all of the other
> decimals
> to leave....so I am the gremlin! It is fixed and I have transferred a
> new
> ranks file and also a new version of the dumptext for ranks.
> 
> Can you run a new conversion? Hopefully many many errors will be gone
> and
> then we will deal with the conversion errors.

Yes.  If you and Lacey are going to run the UPDATEs that force
the agonisim and grooming to the first of the month, and do that
today, I'll wait for that data.  Otherwise, I'll start the conversion
and you can tell Tabby to fix that problem and we'll run another
conversion when that's fixed.


Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein



More information about the Babase mailing list