For the Test Case, the publishing process uses an xml file which contains column definitions for all the columns that can be exported from the Developer into the file. The xml file is located in the lang folder within the Test Case publishing style. Each language has an xml file; customize the languages you need. In addition, each format within the Test Case style has its own xml file:
HP Quality Center: ColumnSpec.xml
Oracle Application Testing Suite: OATS_ColumnSpec.xml
IBM Rational Quality Manager: Rational_ColumnSpec.xml
Other: Other_ColumnSpec.xml
To customize the output, edit the .xml file in an editor of your choice. Before you customize the style, it is highly recommended that you make a copy of it and then make your modifications to the copy. See Customize Publishing Styles for more information about copying, renaming, and editing publishing styles.
Important Publishing Note: If you are using Microsoft Office 2003, you must install the Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats. You can download this compatibility pack from the Microsoft Office Download Center. In addition, all Microsoft Office Products must have the latest updates and security fixes.
Include or Exclude Columns
You can specify the columns you want. By default, the columns that are required for import into each format are included. In addition, the .xml file contains definitions for all of the data that can be retrieved from the Developer database. Within each column definition, between the <col> and </col> tags, there is an export parameter with a yes or no value. Yes means that the column will be included in the output.
Note: The Output and Required Fields columns have an additional parameter for fixed width font. These columns contain the information in the Output and Required fields tables. In order to represent the tables properly, table columns are separated by spaces, and each table row is on a separate line. This information is easier to read when it is formatted with a fixed width font such as Courier. Therefore, by default, the fixedWidthFont parameter has a value of Yes for these two fields. If you want these fields to appear in a proportional font, change the parameter to No.
Change the Column Name
Another parameter within the column definition tags is header. This value is the text for the column name. You can change the text in between the <header> and </header> tags to whatever you wish. Do not change the xml:id reference or its value.
Repeat Topic Data
By default, the data in the columns repeats for every row in the topic. If you do not want this information to repeat for every row, you can use the repeat parameter in the <data> tag. A value of Yes causes the data to appear in each row of the topic; a value of No causes the data to appear in the first row of the topic only.
Set a Default Value
You can use the <defaultvalue/> tag to set a default value for a column if the value specified in the <data> tag is blank. Modify the <defaultvalue/> tag so that it has begin and end tags, and enter the text for the default value between tags. For example, <defaultvalue>XYZ Company</defaultvalue>, which places the XYZ Company text in the field if the <data> tag returns a blank value.
Note: The value in the Step column is set to integer in the OATS_ColumnSpec.xml.
Set Column Width
Each column is set with a default width. The <width> tag specifies the width of the column expressed in the number of characters. For example, if the default font is Arial 10, then a column width of 10 displays 10 characters, which is equal to 75 pixels. If the font is changed to Courier New, the column width still displays 10 characters, but the column is resized to 85 pixels. You can edit the value of the <width> tag to suit your needs.