Import set table not populating when importing from data source with excel file

[s_renjarnbo]

Hi

I am fairly new to the concept of loading data into import set tables. I have though worked with transform maps etc before.

I am facing an issue where I cannot load data from a data source with an excel file attached.

Below is my data source record:

When I click "load all records" the import reports a success but nothing is imported to the import set table, see below:

There is no entries in the import log

Below is the result from the import set:

I am reasonably sure that column headers in excel sheet match the fields in the import set table (there are 2 new columns in the excel file but those should just be added in the table as I understand)

I have tried playing around with the content of the file, formatting columns as "general" or "text", inserting a table etc but I cannot get it to work.

I have searched but cannot find a question/solution that fits my issue.

I think that I have tried all that comes to MY mind 🙂 and still it does not work.

Can someone point me in a direction to where I can troubleshoot next.

BTW we are on Washington Patch 3 hotfix1

Regards

Søren

[ColinAngstadt1]

Calm down