Forum Discussion

McWolf82's avatar
McWolf82
Copper Contributor
Jun 22, 2022

Import CSV - Missing on or more required headers

First thing first, I'm not a DevOps expert, we have a customer who uses DevOps and did an export to CSV regarding testcases.

They edit the CSV with Excel by going to Data, From Text/CSV and open te CSV, they remove the ID's that are part of the ID column, save the file again as CSV and try to import in DevOps.

 

The following error message occurs:

 

In the CSV file I see all the headers mentioned, but somehow DevOps thinks different.

I've already found some articles on the internet regarding exactly the same issue, but not a solution I'm looking for.

 

What can we do/try to solve this issue?

 

azure devops
devops

3 Replies

  • Pxor90's avatar
    Pxor90
    Copper Contributor
    Jun 20, 2023

    McWolf82 I am following the discussion carefully. My problem is similar: azure signals me an error on the order of the required fields. I've seen numerous videos on the subject, and they all use the fields in that order (second image). 

     

    • McWolf82's avatar
      McWolf82
      Copper Contributor
      Jun 20, 2023

      Pxor90 Hi, the issue we had was regarding regional settings and after we changed that the problem was solved.

       

      https://support.talkdesk.com/hc/en-us/articles/360047099811-CSV-Files-and-Regional-Settings#:~:text=Windows%2010%20%2D%20click%20on%20Start,enter%20a%20comma%20(%20%2C%20).

      • Pxor90's avatar
        Pxor90
        Copper Contributor
        Jun 20, 2023
        Hi, thanks for the support, we also solved it. The problem was related to the "language" settings of the system which caused a disagreement with the CVS fields (marking them as out of order). By changing the system language to US and making sure the CSV separator is (,) and not (;) the upload was successful.

Resources