Skip to main content
ricardo
ricardo
Contributor ⭐️⭐️
June 27, 2018
Solved

Can ́t "fetch mappings" of a data job which insert data into a MDA Object from a CSV file with semic

  • June 27, 2018
  • 1 reply
  • 65 views
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?
    Best answer by kunal_bhat
    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   

     

    1 reply

    kunal_bhat
    kunal_bhatAnswer
    Helper ⭐️⭐️⭐️
    June 28, 2018
    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   

     
    Terms & ConditionsAccessibility statement