Use this option if you want to set the separator for values in files to be exported. The Delimiter dropdown list is enabled when you select the Delimited option.
Delimiter
From the Delimiter dropdown list, select the field delimiters for files to be exported (e.g., Comma, Tab, Semicolon, Space, or Other Delimiter). If you select Other Delimiter, enter the delimiter in the text box to the right of the Delimiter text box. If one or more of the work item property values contains the selected delimiter, you can enclose the values the BIC exports in double quotes.
Document Style
The Document Style box allows user to select a document style when exporting a file in a delimited format. This enables the BIC to format the output text file according to the chosen document style. The document style formats are similar to what is described under the Import Delimited section.
Include System Properties in Export
The Include system properties in export checkbox is enabled when selecting the Delimited option. If this checkbox is selected, the system properties are included in the delimited file exported from EPX.
Encode Carriage Return/Line Feed Option
Click the Encode CRLF as: option to enable the text box to get the symbols or characters to be encoded as carriage return/line feed.
Export Items
The Export Items box changes based on the format to which information is exported. When you select Delimited, you can configure the Export File Key and Value text cells. Click Add to enable text cells in which you can type values. Click Remove to delete text cells.
The Export Items box contains the following:
- Export File Key – Enter the names of the keys for the values you want to export.
- Value – enter the names of the work item property table keys that you want to export. All key names must be enclosed in % (percent signs); for example, %address.street%. Constants, wildcards ( * ), and EPX work item attributes can also be used as values. In using wildcards, the output to export file depends on four cases shown in the table below.
| Case | Description | Example | Export file output |
| 1 | Asterisk is the only argument. | * | All workitem properties |
| 2 | Asterisk is the starting argument. | *text | Items with key names ending in "text" |
| 3 | Asterisk is the ending argument. | text* | Items with key names beginning in "text" |
| 4 | Enclosed within asterisks | *text* | Items with key names containing "text" |
To export all workitem properties, set a single asterisk ( * ) as the only argument in the Value table.
To export items with key names ending in "text", put an asterisk in the beginning of the argument.
Consequently, put an asterisk in the end of the argument if the key names should begin in text. For items with key names containing text, enclose the text argument within asterisks. Refer to the table above for examples of using wildcards as export item values.
XML
Selecting the XML option activates the XSL text box and the Browse button.
XSL File
The Work Item Import and Export BIC uses the structure of the work item hash table as the default structure for the XML document that you export. You can directly type a path and file name for the XSL file that the BIC uses to format or transform the exported file. You can also click Browse and select the file and path for the XSL file in the <EPX>\bin\agents\<hostname> directory on the File Open dialog box.
Below is an example of an XSL style sheet that can be used to transform an XML file into an HTML-formatted file:
<?xml version="1.0"
encoding="ISO-8859-1"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/WorkItem/Personal">
<html>
<body>
<h2>My Sample StyleSheet</h2>
<table border="1" width="250">
<tr>
<td align="center" colspan="2">
<B>Personal Information</B></td>
</tr>
<tr>
<th align="center">Field</th>
<th align="center">Value</th>
</tr>
<tr>
<td>FirstName</td>
<td><xsl:value-of
select="FirstName"/></td>
</tr>
<tr>
<td>LastName</td>
<td><xsl:value-of
select="LastName"/></td>
</tr>
<tr>
<td>MiddleInitial</td>
<td><xsl:value-of
select="MiddleInitial"/></td>
</tr>
<tr>
<td>DateOfBirth</td>
<td><xsl:value-of select="DateOfBirth"/></td>
</tr>
<tr>
<td>Sex</td>
<td><xsl:value-of select="Sex"/></td>
</tr>
</table>
<br></br>
</body>
</html>
</xsl:template>
</xsl:stylesheet>Below are the contents of an exported HTML file that was formatted using XSL file shown above:
Here is another example of an XSL style sheet that can be used to transform an XML file into another XML-formatted file:
<?xml version="1.0" encoding="ISO-8859-1"
?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<Product>
<SPSC_Code>
<xsl:value-of select="WorkItem/SPSC_Code" />
</SPSC_Code>
<Supplier_ID>
<xsl:value-of select="WorkItem/Supplier_ID" />
</Supplier_ID>
<Long_Desc>
<xsl:value-of select="WorkItem/Long_Desc" />
</Long_Desc>
<Expiration_Date>
<xsl:value-of select="WorkItem/Expiration_Date"
/>
</Expiration_Date>
</Product>
</xsl:template>
</xsl:stylesheet> Below are the contents of an exported XML file that was formatted using XSL file shown above:
<?xml version="1.0" encoding="UTF-8" ?>
<Product>
<SPSC_Code>11112222</SPSC_Code>
<Supplier_ID>aaa1</Supplier_ID>
<Long_Desc>ddd1</Long_Desc>
<Expiration_Date>08/19/2003</Expiration_Date>
</Product> DTD Generation
Specify the type of DTD Generation you want to use in the XSL file. The following are the DTD Generation options:
- Internal – selecting this option will embed the DTD with the XML file.
- External – select this option if you want to create a separate DTD file.
- None – select this option if you do not want to create a DTD file.
Root Element Name
The default Root Element Name is WorkItem because this is where the work item property keys and values are to be exported and contained. The default root element tag name can be overridden by entering a value in the Root element name field.
Include System Properties in Export
The Include system properties in export checkbox is enabled only when you select XML as the output format. If this checkbox is selected, the system properties are included in the XML file exported from EPX.
Click the Encode CRLF as: option enables the text box to get the symbols or character to be encoded as carriage return/line feed.
Export Items
For the XML export format, Export Items allows you to conditionally choose the work item properties to export and its corresponding XML tag. You can add more than one export item. If no export items are specified, all work items will be exported. The resulting XML file reflects the nesting structure of the work item properties.
Click Add and enter the export item. Click the Remove button to delete an export item.
The Export Items box contains the following columns:
- XML Element – Enter the names of the XML tags for the values you want to export. The XML tag names must be valid. You can specify nested tags by using slashes "/" to separate the parent node with the child node.
- Value – Enter the names of the work item property table keys you want to export. You must enclose all of the key names in percent signs (%), e.g., %address.street%.
Constants, wildcards ( * ), and EPX work item attributes can also be used as values. In using wildcards, the output to export file depends on four cases shown in the table below.
| Case | Description | Example | Export file output |
| 1 | Asterisk is the only argument. | * | All workitem properties |
| 2 | Asterisk is the starting argument. | *text | Items with key names ending in "text" |
| 3 | Asterisk is the ending argument. | text* | Items with key names beginning in "text" |
| 4 | Enclosed within asterisks | *text* | Items with key names containing "text" |
To export all workitem properties, set a single asterisk ( ‘*' ) to be the only argument in the Value table.
To export items with key names ending in "text", put an asterisk in the beginning of the argument.
Put an asterisk in the end of the argument if the key names should begin in text. For items with key names containing text, enclose the text argument within asterisks. Refer to the table above for examples of using wildcards as export item values.
Selecting the Fixed option enables the Include keys in export checkbox.
Include Keys in Export
The Include keys in export checkbox is available only when you select Fixed as export format. The Clicking this checkbox includes hash table keys in the delimited file exported from EPX.
Clicking the Encode CRLF as: option enables the text box to get the symbols or characters to be encoded as carriage return/line feed.
Export Items
The Export Items box changes based on the format to which information is exported. When you select Fixed format, the following columns appear:
- Export File Key – Enter the names of work item properties you want to export. You can enter EPX System keys and constants.
- Value – enter the names of the work item property table keys that you want to export. You can also type constants and EPX work item attributes. You must enclose the key names in the % character, for example, %sys.server.name%.
Fixed format does not accept wildcards as export item values.
- Starting Column – enter the numeric value for the position that the exported value's first character will occupy in the export file. The starting column must be specified for each file key.
Click Add to enable text cells. Click Remove to delete text cells.