I receive a line:0 error when importing a test case

[ginger.oliver]

I am attempting to import a test case using the import template provided by Agile Central.  WHen I upload the file, I receive this error: 

Attachment(s)

TestCaseImportTemplate.csv.zip   279 B 1 version

[David LeDeaux]

Hi Ginger,

 

What does your Excel look like when you open that file?  For me, it's putting everything into one column:

 

This is because the file is tab delimited in spite of the extension being CSV.

 

A quick way to fix this,

1. Select Column A
2. Click the Data tab
3. Click Text to Columns

 

Choose Delimited and click Next:

 

 

 

Choose Tab and click Finish

 

 

Now you should have something like this:

[ginger.oliver]

Hi, David,

The file downloads in columns automatically.

 

 

Thank you,

Ginger

[David LeDeaux]

Hi Ginger,

 

I was doing some searching around this and found an old community post that alludes to this being an issue still with CSV vs tab delimited files:

Product Announcement - New Test Case Import 

 

Take a look at the "some things to note" section.

 

Basically, the issue lies with Excel. When you edit any CSV file and proceed to Save the file, Excel defaults to Text format which removes the comma's from the CSV file. To avoid this, you would select Save As and change Text to CSV - this ensures that the commas are preserved and the columns are properly formatted.