Error in transforming data

[Robert Hames]

I'm attempting to transform an Excel spreadsheet into a custom table. I have a date received in the spreadsheet, and its format is yyyy-dd-MM, and I have a field map for it mapping u_date_received to u_date_received with same format. I have the transform to Enforce Mandatory fields with the option of "Only Mapped Fields". I have also tried it with Enforce Mandatory fields set to "No" with the same result.

When I run the transform, I get an error on every row telling me that date received is a mandatory field. There is data in the spreadsheet for every row, and the format matches.

There are screenshots below from the spreadsheet, the field map and the error I'm receiving on every row.

Anyone have any ideas as to what could be wrong?

[SanjivMeher]

Can you check the import table to see if data was uploaded to that field?

Also, if you mark 'Rub Business Rule' on transform map unchecked, does it load fine?

[Robert Hames]

I looked in the import table, and found something odd. There are two "Date Received" fields, even though there was only one defined in the transform map. One has the correct date of the first row, and one is empty. (see below)

[Robert Hames]

I should have also said that I had "Run Business Rules" unchecked when I ran the transform.

[SanjivMeher]

Ok...Looks like this import table was modified manually.

Ideally when you do the import, fields are created automatically and all the fields are set to string. Also there shouldn't be mandatory fields on an import table. 

I would delete these fields and reload the data to create the field by system and then map it in transform map.