Closed (fixed)
Project:
Migrate
Version:
7.x-2.5
Component:
Documentation
Priority:
Normal
Category:
Support request
Assigned:
Unassigned
Reporter:
Created:
21 Mar 2013 at 15:52 UTC
Updated:
19 Jul 2013 at 15:34 UTC
I have a CSV file with around 1900 lines. All but 8 of them import. I'm trying to determine which lines are not importing. I've tried using queueMessage, but that doesn't seem to be called.
Any guidance would be great.
Comments
Comment #1
sunflower commentedI have been wondering this same thing as well. I have a SQL table I am importing from and I'd like to know which records were not imported. Any pointers will be greatly appreciated.
Comment #2
stevenpatzIn my case, I was able to determine that the column I had marked as 'unique' had 8 items that were not. But this was through trial and error.
Comment #3
mikeryanThe message table should list failed items (in the UI, click on the Messages column). Also, the map table lists every source ID that was attempted to be imported, with the needs_update column indicating what happened to it (the values are the MigrateMap::STATUS_* constants - 0 means successfully imported, 1 means marked to be updated on the next import, 2 means ignored i.e., FALSE was returned from prepareRow, and 3 means an error).
If the problem is that your source keys were not unique, I don't see that Migrate can help you much there.
Comment #4
stevenpatzYeah the source keys were not unique, but the only thing the messages column told me was that the username was deduped ( all but one of the non-unique keys was for the same user). The process of elimination came in when I removed the dupes from the source file and still had one that was not importing ( and messages were empty ). That last one had a source key that was the same as another user but that was the only field that was the same.
Also when I checked the map table, the STATUS was always 0, even though there was one row that had not been imported.
Comment #5
mikeryanAdded the situation to the FAQ.