CSV to XML - ESI Distribution Target

svs — Fri, 04 May 2018 13:40:14 GMT

Guys ,Do you have sample XSL Stylesheets that can convert the XML Data (ESI Response from Distribution Target) to CSV Data. I'm trying a configire a Flat File Unidirectioanl integration of Windchill 10.1 and JobScope ERP for one of our customers . Attahced is the XML Response

Re: CSV to XML - ESI Distribution Target

Murali — Fri, 04 Oct 2013 15:31:23 GMT

Hi Sriram,

By using Altova XML tool, you can do it..

Please let me know, if you need more details.

warm regards

Murali

www.prism-ind.com

India:+91 888-00-77476

Re: CSV to XML - ESI Distribution Target

RahulKalaskar — Fri, 01 Nov 2013 07:40:35 GMT

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.

Select File as the type of target.

Specify values for the Number, Name, Description and other required attributes of the target.

Change the value of the taskURI attribute to com/ptc/windchill/esi/export/ExportToCSVFile.xml.

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

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 "

topic CSV to XML - ESI Distribution Target in Windchill

CSV to XML - ESI Distribution Target

Re: CSV to XML - ESI Distribution Target

Re: CSV to XML - ESI Distribution Target