[Babase] New run of conversion
Leah Gerber
lgerber at duke.edu
Wed Mar 15 12:17:31 EST 2006
Karl O. Pinc wrote:
> I'm running the conversion now with the new data supplied by
> Leah. The errors and loadscript file
> will be in /biology/groups/babase/
> when it finishes. Should be there tomorrow
> morning first thing. There may be new program
> errors as I've messed with the programming.
>
> The data's going into the babase_test db, but I'll
> have to manually construct the members, repstats,
> etc files.
>
> FYI, the OS upgrade did not happen. Hunter has
> rescheduled it, probably for Thursday.
>
Karl, I took a quick look at the new error file. The following error
shows up
psql:<stdin>:192: ERROR: date/time field value out of range: "1995--1-0-"
HINT: Perhaps you need a different "datestyle" setting.
There is one thing I forgot to mention to you.
The ranked "by" dates that i gave you are in the format month/day/year/
Could this be causing the error? Perhaps the dates wen in incorrectly.
I could not force excel to give the dates in a different format.
Leah
More information about the Babase
mailing list