Delimited - EnterWorks_Process_Exchange_(EPX) - 10.5

EnterWorks Process Exchange (EPX)

Product type
Software
Portfolio
Verify
Product family
EnterWorks
Product
Precisely EnterWorks > EnterWorks Process Exchange (EPX)
Precisely EnterWorks
Precisely EnterWorks > EnterWorks
Version
10.5
Language
English
Product name
Precisely EnterWorks
Title
EnterWorks Process Exchange (EPX)
Copyright
2023
First publish date
2007
ft:lastEdition
2024-01-18
ft:lastPublication
2024-01-18T18:45:39.198479

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.
Note: A blank Export Items field produces the same result as Case 1. Cases 1 and 4 ignore the Export File Key input, while cases 2 and 3 use it to replace the wildcard keyword in the exported key names.
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.

Note: If you do not specify Export File Key and Value data, all the work item property keys and values will be written to the export file.

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.

Note: When the BIC is used in a clustered environment, make sure the folders and/or files that will be indicated are existing in and pointing to where the BIC Manager server is installed.

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.