Data Import Problem - Processed: 0, inserts 0, updates 0, errors 0, empty and ignored 0, ignored errors 0

[Gnani1]

Lately, we are working on integration to automate the data import from the vendor on the daily basis. The file that is being pushed to the MID server is not processing successfully. Although there are no errors, but, no records are processing with the file.But, when we copy the data to a different file with the same columns headers it works good.

The issue, when we use the file from "Load data" module.

Processed: 0, inserts 0, updates 0, errors 0, empty and ignored 0, ignored errors 0  (0:00:00.030).

Please help.

[Ankur Bawiskar]

Hi,

Is that file getting attached to the data source before the transform begins. Can you check the import set table whether the load into this table worked or not?

How are you  fetching the file form mid server?

It either means file is not fetched properly and hence nothing processed or file itself was empty.

Regards

Ankur

[Gnani1]

HI Ankur,

Thanks for your reply, there is data in the file.  We tried to copy the file from MID server on the local disk and tried to load the same file, even then no records are processing.

Yes. the file is getting attached to the datasource, the data is not getting loaded into the import set table.

[Ankur Bawiskar]

Hi,

So that is the issue since data is not loaded in import set table it is telling processed as 0.

If you manually load the data using Load all records is it working fine?

Also how are you attaching the file to the data source? Is the file format being attached same as the format i.e. xls or csv etc

Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Gnani1]

Hi Anukur,

Even if we manually load the data from that specific file it is not working. we need to copy the data into another file and we will load that.

We tried to load the data from the specific file from "Load Data", even then it is same issue. 

We always copy the data frrom the specific file and put it into another template and load it.