Testopia:Documentation:CSV2XML - Revision history

Ghendricks: Replaced content with 'NOEDITSECTION Back to the Testopia Main Page ==What's New!== csv2xml is now defunct as of Testopia 2.3. You can use the tr_importer.cgi to upload csv or xm…'

2009-10-27T20:48:07Z

Replaced content with '__NOEDITSECTION__ Back to the Testopia Main Page ==What's New!== csv2xml is now defunct as of Testopia 2.3. You can use the tr_importer.cgi to upload csv or xm…'

@@ Line 3: / Line 3: @@
 ==What's New!==
-{| border=1 cellpadding=4
+csv2xml is now defunct as of Testopia 2.3. You can use the tr_importer.cgi to upload csv or xml directly from within a test plan (file -> import -> cases).
-==Getting Started==
+see import_example.csv and testopia.xsd in the extensions/testopia directory for more details.

Dkoenig at 21:16, 22 December 2006

2006-12-22T21:16:24Z

← Older revision		Revision as of 21:16, 22 December 2006
Line 36:		Line 36:
	*cleanupsteps - added to Break Down section.		*cleanupsteps - added to Break Down section.
	*component - component for test case.		*component - component for test case.
	*description - summary unless testcasename is defined. ~~added~~ to Action section if -tcdb flag used.		*description - summary unless testcasename is defined. Added to Action section if -tcdb flag used.
	*environment - split apart at each comma to become a tag.		*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.		*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 and by default field 4 becomes the category and fields 5 and beyond are tags.
	*longdescription - added to Action section if -tcdb flag used.		*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.		*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.		*passfaildefinition - added to Expected Results section.
	*priority - becomes the priority. I just a number P is prepended.		*priority - becomes the priority. If just a number P is prepended.
	*result - see passfaildefinition.		*result - see passfaildefinition.
	*resdetails - added to Action section if -tcdb flag used.		*resdetails - added to Action section if -tcdb flag used.
Line 49:		Line 49:
	*summary - see testcasename.		*summary - see testcasename.
	*tags - see attributes.		*tags - see attributes.
	*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.		*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.		Any columns other than those described above are ignored.
Line 59:		Line 59:
	==Extend Characters==		==Extend Characters==

	The parser Class::CSV->parse() does not accept extend characters and will error if extend characters are found. A subset of extend characters are converted to HTML entities when the .work file is created. Additional conversions for extend characters may need to be added at the top of the remvoe_field_list() method in tr_csv2xml.pl if you see the Failed to parse line error described ~~int he~~ Errors section.		The parser Class::CSV->parse() does not accept extend characters and will error if extend characters are found. A subset of extend characters are converted to HTML entities when the .work file is created. Additional conversions for extend characters may need to be added at the top of the remvoe_field_list() method in tr_csv2xml.pl if you see the Failed to parse line error described in the Errors section.

	==Errors==		==Errors==

Dkoenig at 21:02, 22 December 2006

2006-12-22T21:02:31Z

← Older revision		Revision as of 21:02, 22 December 2006
Line 51:		Line 51:
	*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.		*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.

			==.work file==

			The parser Class::CSV->parse() is passed a field list and needs a data file without header information. The .work file is created from the CSV supplied without the header line.

			==Extend Characters==

	~~Any columns other than those~~ described ~~above are ignored~~.		The parser Class::CSV->parse() does not accept extend characters and will error if extend characters are found. A subset of extend characters are converted to HTML entities when the .work file is created. Additional conversions for extend characters may need to be added at the top of the remvoe_field_list() method in tr_csv2xml.pl if you see the Failed to parse line error described int he Errors section.

			==Errors==

	~~==Samples==~~		* Failed to parse line: "..." is a error from Class::CSV->parse() and could be cuase by extend characters. Save the error message into a file and use the Linux utility od -c to see if any extend characters are included in the file.

	<br>Back to the [[Testopia \|Testopia Main Page]]		<br>Back to the [[Testopia \|Testopia Main Page]]

Dkoenig at 20:24, 22 December 2006

2006-12-22T20:24:06Z

← Older revision		Revision as of 20:24, 22 December 2006
Line 12:		Line 12:

	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.		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.

			Usage is tr_csv2xml.pl [ -tcdb] input.csv output.xml.

			The flag -tcdb is used for CSV derived from a propriety Test Case Database that had a few bugs in it's export format which included:

			* Does not escape " used in a field with "". May use \" instead of "" but not always.
			* Runs the CSV across multiple lines.
			* In some cases a line may be missing the last field.

			Most user's will not want to use the -tcdb flag.

	==CSV File Format==		==CSV File Format==
Line 19:		Line 29:
	For example: "Testcase Name","Attributes","Priority","Description","Folder","Creator","Owner","Pass/Fail Definition","Setup Steps","Cleanup Steps","Steps"		For example: "Testcase Name","Attributes","Priority","Description","Folder","Creator","Owner","Pass/Fail Definition","Setup Steps","Cleanup Steps","Steps"

	~~Columns~~ and ~~their actions~~		Each column header is converted to lower case, white space is removed and the '/'s are removed and the result is compared against the following values to determine how the field should be handled.

			*author - see owner.
			*attributes - comma seperated list used to create a tag.
	*category - category for test case.		*category - category for test case.
	*cleanupsteps - added to Break Down section.		*cleanupsteps - added to Break Down section.
Line 31:		Line 43:
	*passfaildefinition - added to Expected Results section.		*passfaildefinition - added to Expected Results section.
	*priority - becomes the priority. I just a number P is prepended.		*priority - becomes the priority. I just a number P is prepended.
			*result - see passfaildefinition.
	*resdetails - added to Action section if -tcdb flag used.		*resdetails - added to Action section if -tcdb flag used.
	*setupsteps - added to Set Up section.		*setupsteps - added to Set Up section.
	*steps - added to Action section.		*steps - added to Action section.
			*summary - see testcasename.
			*tags - see attributes.
	*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.		*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.

Dkoenig at 23:18, 21 December 2006

2006-12-21T23:18:27Z

@@ Line 11: / Line 11: @@
 ==Getting Started==
-The script csv2xml.pl is provided in your Bugzilla home directory to convert Testopia CSV files into Testopia XML files for import.
+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.
 ==Samples==
 <br>Back to the [[Testopia |Testopia Main Page]]

Dkoenig at 23:04, 21 December 2006

2006-12-21T23:04:32Z

New page

__NOEDITSECTION__
Back to the [[Testopia |Testopia Main Page]]

==What's New!==
{| border=1 cellpadding=4
| 2006-11-21 ||
* Page created
|-
|}

==Getting Started==

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

==Samples==

<br>Back to the [[Testopia |Testopia Main Page]]