Importer has no errors or warnings, yet fails to import everything
I thought I had the last of our imports run with a fair bit of success (barring a continuing refusal of CollectiveAccess to import dimensions, no matter what I try). We started trying to import our photos, and had a number of them fail due to not having an object to attach to.
Went back to the spreadsheets we imported from, and the objects in question are in those spreadsheets. Then we did some testing and found there were two spreadsheets where 100% of records imported. But there were spreadsheets where 80% of records imported, and some with much less, including one case where more than 70% of the data failed to import, despite no errors/warnings/informational messages. From the logs, everything looked fine (although with more than 9,000 records in some of these spreadsheets, we didn't look line by line to see what it was doing in the logs).
Running the importers again, it's picking up some of the missing records. On rerunning, it will pick up anywhere from a tiny fraction of the records to most.
I'm attaching two of our mappings. Archaeo imported 100% of the records, while Natural History imported less than 30%. Anyone got a moment to look these over and tell me if there's something amiss in the mappings that's the problem?
And if not the mappings, what?