XML Import-Export Forum :: XML - Failed importing records

This thread was displayed: 0 times


Starting with 17th May 2007, Adobe Systems will stop offering support for any version of the discontinued InterAKT products. As a result, we will not answer to new support incidents starting with May 17th, 2007. Pending support incidents will still be followed in order to be closed. The product forums will remain open and be transformed in user-to-user forums. The general forums will be made read-only and not allow new posts or comments.

For more information about the affected products visit: www.interaktonline.com/Support/

View Threaded Show descending
Randy Kreisel
03-20-2007 01:24:38 GMT +2

I have a customer with a legacy access database that I can not modify.

Some of their field names are not the right convention (i.e. spaces and special characters).

I am getting the following error on import:

Developer Details:

Failed checking unique field. SELECT Service Record ID FROM Workorders WHERE Service Record ID=1381 (IMPORT_SQL_ERROR)
 
I think the error is caused by a key field named: service record (with a space between).
 
How can I work with this?
 
Randy
Back | Reply | Quote | Top
Razvan Racasanu[InterAKT]Adobe Systems Romania staff
03-20-2007 12:30:41 GMT +2

Hello,

Unfortunately XML Import-Export does not support field names with spaces in them or reserved words.

Regards,
Razvan RACASANU
Reply | Quote | Top
Messages 1 to 1 from 1
XML Import-Export 1.8.6
© Adobe Systems Romania. All rights reserved.