Can ́t "fetch mappings" of a data job which insert data into a MDA Object from a CSV file with semicolon (only with comma)

  • 1
  • Problem
  • Updated 3 months ago
  • In Progress
When i ́m creating a job i have two options of separator: Comma and semicolon, but i can only fetch the mappings with a CSV file using comma.


If i try to use a CSV file with semicolon that ́s what happens:


Here ́s my CSV file with semicolon


If i replace the semicolons with comma it Works fine 

That ́s really a bug or i ́m doing something wrong?
Photo of Ricardo

Ricardo

  • 390 Points 250 badge 2x thumb

Posted 3 months ago

  • 1
Photo of Kunal Bhat

Kunal Bhat, Employee

  • 982 Points 500 badge 2x thumb
Hi Ricardo,


That's definitely a bug, the columns from the CSV aren't getting inferred when the CSV has semicolons.

We'll get that bug fixed in an upcoming release, temporarily there is a workaround though. You could type out all the CSV column names manually in the Source Field section of the Mappings panel. Once you do that and map all fields, you'll get your CURL.

Once the CURL is generated, you can use it to load data from your file having semicolons. 

Alternatively, you can upload the CSV file with the headers being comma separated. Then the CSV columns will be inferred correctly and you can get your CURL. You can then switch back to semicolons in the headers and load data. When the CSV is uploaded in the job creation page, we only use it to infer the headers.

Do reply if this doesn't work for you. 

Thanks,
Kunal