Hi Sriram,
Please folllw the below steps for generating CSV file in Distribution target.:
5.1.2 Delivering a .csv file to a file type distribution target
This requires carrying out the steps outlined in the following sections.
5.1.2.1 Create a custom I*E task for delivering a .csv file
Create a copy of the file <Windchill>/tasks/com/ptc/windchill/esi/export/ExportToFile.xml in <Windchill>/tasks/com/ptc/windchill/esi/export/ExportToCSVFile.xml.
Open the file in your preferred editor and change the value of the FILE_NAME parameter of the Write-To-File webject from "<%=responseFilePrefix%>${@FORM[]TransactionID[0]}.xml" to "<%=responseFilePrefix%>${@FORM[]TransactionID[0]}.csv"
The portion of the file that invokes the webject would then appear as shown below:
<ie:webject name="Write-To-File" type="EXT" use="com.ptc.windchill.esi.lite.tgt.webject.WriteToFile">
<ie:param name="FILE_NAME" data="<%=responseFilePrefix%>${@FORM[]TransactionID[0]}.csv"/>
<ie:param name="PATH" data="${@FORM[]Path[0]}"/>
<ie:param name="XSL_URL" data="${@FORM[]XSL_URL[0]}"/>
<ie:param name="XSL_DBUSER" data="${@FORM[]XSL_DBUSER[0]}"/>
<ie:param name="XSL_PASSWD" data="${@FORM[]XSL_PASSWD[0]}"/>
<ie:param name="XSL_PARAM" data="${@FORM[]XSL_PARAM[0]}"/>
<ie:param name="CONTENT" data="${@FORM[]CONTENT[0]}"/>
<ie:param name="GROUP_OUT" data="${@FORM[]group_out[0]}" default="output"/>
</ie:webject>
Create an XSL stylesheet that converts the ESI response data (in XML) to csv.
5.1.2.2 Define a file type distribution target to deliver a .csv file to
Use the Manage Distribution UI to create a distribution target.
o
Select File as the type of target.
o
Specify values for the Number, Name, Description and other required attributes of the target.
o
Change the value of the taskURI attribute to com/ptc/windchill/esi/export/ExportToCSVFile.xml.
o
Set the XSL URL attribute to point to the XSL stylesheet created in the previous section.
Example:
file://C:/XSLS/ESIResponseToCSV.xsl
http://www.myorg.com/XSLS/ESIResponseToCSV.xsl
o
Click Finish to save the target.
Associate the above created distribution target to a business object (such as a part) and release it. This will result in a .csv file being delivered to the location specified by the Path attribute.
Warm Regards,
RAHUL KALASKAR
If you want more details then follow the guide
" ERP Connector Customizer‟s Guide "
