cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

CSV to XML - ESI Distribution Target

Highlighted
Newbie

CSV to XML - ESI Distribution Target

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

2 REPLIES 2
Highlighted

Re: CSV to XML - ESI Distribution Target

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

Highlighted

Re: CSV to XML - ESI Distribution Target

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 "

Announcements