CSV file not displayed in the data records column
3 answers
After I upload a CSV file via the "Create Test Data" option and save, I don't see the data displayed below in tabular format. It also does not populate Test Data droplist in the test case screen. What am I doing wrong?
I'm guessing that you aren't seeing the data displayed in the Data Records table when creating the Test Data is caused by the CSV file having lines that contain more commas then other lines and RQM is having trouble parsing it. Make sure all lines have the same number of commas. If a field in the CSV file does need a comma in it's value, then that field should be surrounded by double quotes.
Also, make sure the first line in the CSV file has the column definitions that define the type of each column. See:
http://publib.boulder.ibm.com/infocenter/rqmhelp/v2r0/topic/com.ibm.rational.test.qm.doc/topics/t_create_datapools.html
And if the CSV file contains non-ASCII characters, then the encoding must be UTF-8.
If this doesn't help, let us know your RQM version.
OK, I've got it to preview. Now I just need to be able to select the test data on the Test Script screen. Right now it is saying unassigned in the test data droplist.
Once your Test Data has been successfully created and you see it listed on the Construction->View Test Data page, then the next time you create a test script or edit an existing test script, then you should see that test data listed in the drop down.
If the Script Editor page were open when you added the Test Data, then you would need to close and reopen the Script Editor, in order for the newly created Test Data to show in the drop down.
If you have closed and reopened the Script Editor and the Test Data still doesn't show, then that sounds like a defect. You still haven't indicated your version of RQM, but I would recommend going to the latest available fixpack for your release and applying the latest fixpack. You may also want to try another browser (IE vs FF) to see if that makes a difference.