I am trying to import a CSV file to Data extension (by using import option), but getting the invalid field error.

This was worked previously, but now it is failing. Could you please help me to figure out the issue?

My Data Extension

Data Extension details

My CSV file

Id,Email Address

csv file

I am getting the below error while importing the csv. Error details

Recently we migrated our programs to Automation Studio. Is there any relation with Automation Studio and this error?

  • What delimiter is configured in your import definition? Apr 11 '17 at 10:44
  • Is it because your DE column name is Emailaddress and the column name in the .csv is Email Address?
    – Mike
    Mar 13 '18 at 14:27

Appears your delimiter has changed in your test file or the import is expecting a pipe delimiter.

I'm curious why you have the Emailaddress column in your Data Extension set to Text (100) instead of the EmailAddress data type.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.