import appears to work but 0 records processed

[karenk]

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?

[Harish KM]

version of servicenow?

[ajaypradeep]

Helsinki patch 7

[nichoffman]

Are you importing from an FTP?

I had the same issue when loading the file from an FTP and using the "Load 20 Records" functionnality. It worked only when I load all the records.