[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