Testopia:Documentation:CSV2XML

Back to the Testopia Main Page

What's New!

2006-11-21

Page created

Getting Started

The script tr_csv2xml.pl is provided in your Bugzilla home directory to convert Testopia CSV files into Testopia XML files for import using tr_importxml.pl.

CSV File Format

The first line of the CSV should contain a list of columns in the file separated by commas.

For example: "Testcase Name","Attributes","Priority","Description","Folder","Creator","Owner","Pass/Fail Definition","Setup Steps","Cleanup Steps","Steps"

Columns and their actions

• category - category for test case.
• cleanupsteps - added to Break Down section.
• component - component for test case.
• description - summary unless testcasename is defined. added to Action section if -tcdb flag used.
• environment - split apart at each comma to become a tag.
• folder - only processed if -tcdb option is supplied. split apart at each '/'. based on each teams input one field becomes the category and others tags. each team defines which sub folders they want to use.
• longdescription - added to Action section if -tcdb flag used.
• owner (required) - in TCDB this is a ID that is mapped to a email address from the file tcdbUsers.
• passfaildefinition - added to Expected Results section.
• priority - becomes the priority. I just a number P is prepended.
• resdetails - added to Action section if -tcdb flag used.
• setupsteps - added to Set Up section.
• steps - added to Action section.
• testcasename - becomes the summary. if testcasename is not supplied the description is the summary. if testcasename and description are both null a error is generated. added to Action section if -tcdb flag used.

Any columns other than those described above are ignored.

Samples

Back to the Testopia Main Page