[Babase] Fecal Data Uploaded
Lacey Maryott
lacey.maryott at duke.edu
Tue Jul 24 10:08:31 EDT 2007
Lacey Maryott wrote:
> Hello again,
> As of now, the newest data has been successfully uploaded into the
> Fecal Schema tables tmprep2 and tmpresults2. I am waiting on one
> small piece of information from Laurence which will be added to this
> data, which affects the line with sid # 15001, but other than that the
> data is all there.
>
That outstanding issue for sid # 15001 as well as one for line 15000
have both now been fixed, and the fecal schema is completely updated.
Karl, I used update statements to change the values for these fields. I
documented what I did here at duke, and have saved it for the time when
we decide how exactly we want to document changes to babase 2.0, whether
it will be in the old babase changelog, or in a new one. This is
probably a decision that could be made once Susan is back in town and it
can be discussed amongst everyone.
> Also, something to note for future uploads of this data, Karl
> enlightened me to the fact that foxpro was sometimes picky about which
> null values it would accept, and that that was probably why the ' -
> - ' is placed in all those date fields in which there is no date
> available. However, babase 2.0 doesn't accept these as "proper date
> format" and would prefer a blank cell to the dashes. I have saved
> both the prep and results data sheets without these dashes if
> Princeton would like to have these to work from. With babase 2.0, we
> will have to ensure that these dashes don't reappear :).
>
> I think thats all! :)
>
> Cheers,
> Lacey
>
--
Lacey Maryott
Alberts Lab
Department of Biology
Duke University
ph: 919-660-7306
fax: 919-660-7293
Lacey.Maryott at duke.edu
More information about the Babase
mailing list