Re: [Emerald] import into emerald 2.5

Jean Gionet ( (no email) )
Mon, 11 Oct 1999 20:52:42 -0400

Anybody?

-J

----- Original Message -----
From: Jean Gionet <overboard@cyberbeach.net>
To: <emerald@iea-software.com>
Sent: Saturday, October 09, 1999 9:57 PM
Subject: Re: [Emerald] import into emerald 2.5

> Hi Dale,
>
> Still playing with this Import Utility.
> SQLServer 6.5 SP5 - Emerald 2.2.32 (Current)
> SQLServer 7.0 SP1 - Emerald 2.5.278 (NEW & EMPTY)
>
> I'm getting these errors right now with the Import Utility.
>
> When I hit VERIFY I get:
>
> Error Log
>
============================================================================
> ====
> Test | Description
> --------------------------------------------------------------------------

--> --------------------------------------------> Completeness          | Row:7905 The Column 'LastName' from the importtable> must not be NULL or Empty> Referential Intergrity | RI Failed on Column GroupName of the importtable.> 'All' Does not match any records from Gr> Referential Intergrity | RI Failed on Column BillingCycle of the import> table. 'Normal' Does not match any records from> 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>>> After when I hit IMPORT I get:> "Your data import failed 3 test producing 48 individual errors. Alth...blah> blah blah">> I hit IGNORE... then I get:> "An Emerald Database error occured. If you dec blah blah...> [Microsoft][ODBC SQL Server Driver] The conversion of a char data type toa> datetime data type resulted in a> out-of-range datetime value. - INSERT INTO MasterAccounts(FirstName, blah> blah..> VALUES("Kurt Schafer","Cyber Beach Communications", blah blah blah..> ,'Kurt',getdate(),'Conversion')>> I hit IGNORE again and it keeps on popping up more ERROR messages..>> Any ideas or solutions?>> Thanks>> -Jean> CyberBeach>>>> For more information about this list (including removal) go to:> http://www.iea-software.com/support/maillists/liststart>

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