Forum Discussion
McWolf82
Jun 22, 2022Copper Contributor
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?
- Pxor90Copper ContributorHi, 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.