Skip to main content
Developer Communities Admin
Community Manager
September 15, 2026

Trying to import a .csv file that has quotes around the fields and getting an error message ""InvalidMapperConfiguration: You can ignore bad data by setting BadDataFound to null.".

  • September 15, 2026
  • 2 replies
  • 0 views

Originally posted by Steve Bryson on October 24, 2025 at 2:22 PM.

 

Trying to import a .csv file that has quotes around the fields and getting an error message ""InvalidMapperConfiguration: You can ignore bad data by setting BadDataFound to null.". Take the quotes out and it imports fine. Unfortunately, vendor is not able to remove the quotes. I thought this might be handled in the IDL but we are not able to modify the source schema. Anyone have any thoughts?

    2 replies

    Developer Communities Admin
    Community Manager
    September 15, 2026

    Originally replied by Steve Bryson on Oct 27, 2025, 7:22 PM.

     

    This error was actually the result of an incorrect End of Line of Carriage Return & Line Feed (CRLF) when it should have been Line Feed (LF) Only.

    Developer Communities Admin
    Community Manager
    September 15, 2026

    Originally replied by Lexi Woodward on Oct 28, 2025, 9:19 AM.

     

    Thank you for posting your question and confirming you found a solution!

     

    For future reference: Integration Studio does allow importing of file when the entirety of each source field is quoted, however quotes in the middle of the field are problematic. For example:

     

    this,is "bad" quoting,here

    this,"is ""ok"" quoting",here

    "this","is","also","ok","quoting"