CiviCRM Community Forums (archive)

I am running CiviCRM 3.2 on Drupal 6 loaded on a OSX snowleopard server. Hosting locally solved the import time out issues I was having when it was with dreamhost, but now I am having import errors dealing with the External Identifier.

I am importing without duplicate check onto a clean just loaded database. Despite this I am getting the error "external identifier already exists" on 2500 of the 2525 contact records I am trying to load.

When I looked at the error file it appears that although the import mapping is set correctly that the external identifier field is getting switched with the notes field. Any suggestions?
   
Upon further examination it appears that during the import there is blank column inserted in the data table that pushes all values one column over, thus replacing the external identifier column out of sync.

UPDATE: I tried importing the external identifier as the internal contact ID. Import shows all contact records as loaded, but then none of the records show on any searched or reports.

I have tried it with xt. identifier as first column and still the same error. I am not sure what you mean by making sure that the "latest column has a fixed value set" or "notes with new lines" Can you elaborate?

I inserted a dummy column with a value of '0' as the first column, ext. ident. as the second and still the same error. I do not have an internal contact ID for import files. Could this be the problem?

I also tried uploading a test file on the sandbox site. Worked there but same file will not import on my site.