Re: [Emerald] import into emerald 2.5

Peter Deacon ( peterd@iea-software.com )
Mon, 11 Oct 1999 22:09:30 -0700 (Pacific Daylight Time)

On Mon, 11 Oct 1999, Jean Gionet wrote:

> Version v1.0.106

> I'm still getting the Balance ERRORS though and LoginLimit:
>
> Size Check | Row:110 Size of Balance in Import:9 Emerald max is 8.
> Value:-160.47558
> Size Check | Row:187 Size of Balance in Import:9 Emerald max is 8.
> Value:-136.9586
> Size Check | Row:396 Size of Balance in Import:9 Emerald max is 8.
> Value:-249.2193
> (** "" "" this keeps on going up to Row: 4253)
> Size Check | Row:7039 Size of LoginLimit in Import:2 Emerald max is 1.
> Value:10

Don't worry about these, they'll import ok.

> > The SQL errors sound like a date formatting problem. Could you send me
> > the entire sql string that's failing and a sample date or two...

> not too sure what you mean by the entire SQL string.. ?? do you mean the
> error box that pops up when I hit IMPORT?

The message box with the SQL INSERT error.

Your import table... Does it have columns with dates in them? Are
they stored as datetime or text fields?

ciao,
Peter

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart