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 import table
must not be NULL or Empty
Referential Intergrity | RI Failed on Column GroupName of the import table.
'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 to a
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