Here's a LOT of data -- hopefully this will provide everything needed.

As you can see below, a simple string being put into a simple text

file is failing:

This is the test datafile. The first line is skipped during input,

as is verified by the successful insertion of the data into various

other tables in ASA --

NameX,PurposeX,1,AccountX,PriceX,DateX

Consumery Loansy, Mortgagey Cedary Gladey Drivey,22,2021913,$678.90 ,1/3/1909

Suburbany Banky, Uncategorizedy *28723,5,2021913,$765.43 , 04/30/1909

BPy Chasey, Credity Cardy 0695 24% *90695,0,2021913,$1.00 , 05/03/1909

The types of these fields (Table.Column) are:

company.Name: (nvarchar(50), null allowed)

company.MonthsConsideredNew: (tinyint, not null)

Contact.LongText05: (nvarchar(50), text, null allowed)

Here's a SUCCESSFUL run using Account, also one of the largest tables:

Data Operation:

INSERT INTO Account (Text206, CompanyID) VALUES ('Consumery Loansy', '22')

Data Operation:

INSERT INTO Account (Text206, CompanyID) VALUES ('Suburbany Banky', '5')

Data Operation:

INSERT INTO Account (Text206, CompanyID) VALUES ('BPy Chasey', '0')

Data Operation:

INSERT INTO Account (Text206, CompanyID) VALUES ('Consumery Loansy', '22')

Data Operation:

INSERT INTO Account (Text206, CompanyID) VALUES ('Suburbany Banky', '5')

Data Operation:

INSERT INTO Account (Text206, CompanyID) VALUES ('BPy Chasey', '0')

You have just uploaded fully-screened, processed and verified records.

Here are more FAILURES with company and Contact:

Data Operation (These are the queries submitted to 'mssql_query'):

INSERT INTO company (Name, MonthsConsideredNew) VALUES ('Consumery Loansy', '22')

Data Operation:

INSERT INTO company (Name, MonthsConsideredNew) VALUES ('Suburbany Banky', '5')

Data Operation:

INSERT INTO company (Name, MonthsConsideredNew) VALUES ('BPy Chasey', '0')

Data Operation:

INSERT INTO Contact (LongText05) VALUES ('Consumery Loansy')

Fatal error: Uncaught exception 'import_exception' with message 'Datafield Mismatch' in

C:\mpower\slipstream\trunk\www\administrator\uploader-inserter\Xsettings.php: 53

Stack trace:

#0 C:\mpower\slipstream\trunk\www\administrator\uploader-inserter\class\msdb.php(25):

throw_exception()

#1 C:\mpower\slipstream\trunk\www\administrator\uploader-inserter\class\msdb.php(49):

msdb->call('Datafield Misma...')

#2 C:\mpower\slipstream\trunk\www\administrator\uploader-inserter\class\table_loader.php(45):

msdb->insert('INSERT INTO Con...')

#3 C:\mpower\slipstream\trunk\www\administrator\uploader-inserter\Xpage_data_import.php(94):

table_loader->save_datasets('INSERT INTO Con...')#4 {main} thrown in C:\mpower\slipstream\trunk\www\administrator\uploader-inserter\Xsettings.php on line 53Here is Second Run with the order of the Tables Reversed

("Contact" first, then company"):

Data Operation:

INSERT INTO Contact (LongText05, AccountID) VALUES ('Mortgagey Cedary Gladey Drivey', '22')Fatal error: Uncaught exception 'import_exception' with message 'Datafield Mismatch' in C:\mpower\slipstream\trunk\www\administrator\uploader-inserter\Xsettings.php:53 Stack trace:

#0 C:\mpower\slipstream\trunk\www\administrator\uploader-inserter\class\msdb.php(25):

throw_exception()#1 C:\mpower\slipstream\trunk\www\administrator\uploader-inserter\class\msdb.php(49): msdb->call('Datafield Misma...')#2 C:\mpower\slipstream\trunk\www\administrator\uploader-inserter\class\table_loader.php(45):

msdb->insert('INSERT INTO Con...')

#3 C:\mpower\slipstream\trunk\www\administrator\uploader-inserter\Xpage_data_import.php(93):

table_loader->save_datasets('INSERT INTO Con...')

#4 {main} thrown in C:\mpower\slipstream\trunk\www\administrator\uploader-inserter\Xsettings.php on line 53