I have a small .xls file of 20 records to load into location. I load the records into the import set without an issue. I built a transform map and have aligned the fields. I use the mapping assist to see the data fill into specific fields. I click Transform and it appears to work, but the results are that no records were imported.
total=0
inserts=0
updates=0
ignored=0
skipped=0
errors=0
why was the data completely ignored?
