460393 - Testopia is truncating the characters after the special characters typed in VERDANA font style after importing testcases in CSV format

Status: RESOLVED INCOMPLETE

(Testopia :: Import/Export, defect)

Description

[cibershiva]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.17) Gecko/20080829 Firefox/2.0.0.17
Build Identifier: 

I am using Testopia 2.1 on bugzilla 3.0.4.
I am trying to import the testcases in CSV format which are typed in VERDANA font style. The testcases contains the special characters like single quotes, double quotes etc. After importing the Testcases I found that the characters typed after   single quotes or double quotes are trucated and not seen in testopia. 

Reproducible: Always

Steps to Reproduce:
1. Create Testcases in CSV format with special characters like single quotes or double quotes using the VERDANA font style.
2. Import testcases selecting a plan in a project.
3. Check the imported testcases in the testcases section in the selected Plan
Actual Results:  
Testopia is truncating the characters in the testcase typed after a special single or double quotes written in VERDANA font styles.

Expected Results:  
Testopia should accept all the special characters in all font styles.

Comment 1

[Greg Hendricks]

Testopia uses Text::CSV to parse the csv input. The font doesn't matter as CSV is a plain text style. What Text::CSV does not handle very well is the use of special characters such as fancy quotes or em dashes. Also, care must be taken to escape any quoted text, as it assumes text inside " " is a field. In general if you use a tool such as open office calc or other spreadsheet to export the csv, you will have better luck.

Comment 2

[Greg Hendricks]

Can you attach a sample file where this issue applies? I am so far not able to reproduce.

Comment 3

[Greg Hendricks]

Need more info to continue. Closing for now.