Problems importing data to DA

[Michael_Samuels]

I'm trying to use the import function of DA populate my Address Manager Targets, but haven't had much luck.

The following is the file which I'm trying to use (cut & pasted from the dataload.xml sample) and the error which I'm receiving:

Thanks in advance for your help


Import File:
































________________________________


Eventlog Error:

Event Type:Error
Event Source:Accelerator Service Processor
Event Category:None
Event ID:41998
Date:11/1/2006
Time:2:00:58 PM
User:N/A
Computer:CHALBKVS11
Description:
APP AS - Customer ID: 2 - Error:
An Error has occured when getting the dataload log

Description:
System.Data.SqlClient.SqlException: An Error has occured when uploading the data :
Cannot insert the value NULL into column 'CaseID', table 'EVDiscovery.dbo.tblIntTarget'; column does not allow nulls. INSERT fails.

The statement has been terminated.
at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
at System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping)
at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)
at KVS.Accelerator.Application.DataLoad.UpdateLog(DataloadLogDS aDSLog)
Reason: An Error has occured when uploading the data :
Cannot insert the value NULL into column 'CaseID', table 'EVDiscovery.dbo.tblIntTarget'; column does not allow nulls. INSERT fails.

The statement has been terminated.
Stack: at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
at System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping)
at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)
at KVS.Accelerator.Application.DataLoad.UpdateLog(DataloadLogDS aDSLog)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

[TonySterling]

You can try the following:

[Michael_Samuels]

Seems like that got me closer. I received the following error:

Error: The element 'Department' has invalid child element 'ApplicationTarget'. List of possible elements expected: 'DepartmentGroup DepartmentMember DepartmentTarget DepartmentTargetGroup VaultStore DepartmentHotWordCategory'. Line: 8 POSITION: 2

Here's the exact .xml file:

[TonySterling]

Taking another look the Depart line shouldn't need to be in there. I know I have successfully imported address before, let me take a look and see if I can find my xml.

[Michael_Samuels]

Tony,

I didn't think so either. These .XML files certainly can be temperamental!

Thanks for helping out!

Mike

[TonySterling]

Hey Mike,
I just imported this file successfully. Hopefully it will work for you too! ;)

I am running DA 6, btw.

[Michael_Samuels]

Beau-ti-ful!

Thanks!
Mike