import appears to work but 0 records processed

karenk
Kilo Explorer

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?

7 REPLIES 7

nichoffman
Kilo Expert

I have the same behavior. But what even more disturbing is that if I reprocess manually the Import Set, it transforms correctly.


Has anyone had the same issue?


How are you importing this DATA?



And have you mapped data fields correctly?


Hello Ashutosh, thanks a lot for your fast answer.



I'm importing data from a FTP server.


Connexion to the server, importation of data and manual transformation all work fine.


Field mapping is also correct as I tested it with manual imports.



My issue happens only when running the import from a schedule (whether I execute with the 'Execute Now' UI Action or waiting for the schedule to run). And after I get the Import Set to be completed, I can reprocess it and it works fine every time.


Even I face the same issue. Only after reprocessing the import set, the data get transformed correctly.



Any solution on this?