SSDN - How to Convert CSV lines to individual XML file and submit to Web Service

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Angie Kennedy

Subject: How to Convert CSV lines to individual XML file and submit to Web Service
Author: Angie Kennedy
Date: 12 Aug 2009 08:10 PM

Good evening.

I am just getting started evaluating this software and have a question about CSV -> XML File transformations.

I have a scenario where I will be required receive a CSV File with many records. For each record in the file I will need to generate a single XML message.

Each of these XML messages will need to be submitted to a Web Service.

Can you tell me if this is possible in Stylus and if so, how would I go about doing this?

Please let me know if I can provide any additional information.
Thank you......Angie Kennedy

Tony Lavinio

Subject: How to Convert CSV lines to individual XML file and submit to Web Service
Author: Tony Lavinio
Date: 13 Aug 2009 02:52 PM

File|New|XQuery will create a new XQuery.
For the input, choose your CSV file, and open it using the CSV
converter.
This will make it appear as XML to the XQuery engine.

Then, follow the instructions in the blog entry here:
http://blogs.datadirect.com/2008/01/split-up-xml-document.html
except you want the targets to be web services.

The web services call composer should help you with that.

Hope this helps.

Angie Kennedy

Subject: How to Convert CSV lines to individual XML file and submit to Web Service
Author: Angie Kennedy
Date: 17 Aug 2009 05:18 PM

Good afternoon.

I am continuing to work toward the model I described briefly in my first post.

I am able convert CSV to a basic XML; then convert those individual XML to my Complex XML message structure.

I am attempting to create a Web Service call now, but have hit an Error message when testing the Web Service call.

Error: The encoding 'UTF-8' is not supported by the Java runtime

I saw a couple of other tickets about this error, but wasn't sure how to proceed.

Some of my system details:
- Windows XP workstation
- 1.6.0_15 Java HotSpot(TM) Client VM Sun Microsystems Inc.
debug mode port:8000
- Stylus Studio 2009 XML Enterprise Suite Release 2 Build 1386e

Please let me know if I can provide any additional information.
Thank you......Angie Kennedy

Ivan Pedruzzi

Subject: How to Convert CSV lines to individual XML file and submit to Web Service
Author: Ivan Pedruzzi
Date: 18 Aug 2009 03:18 PM

Hi Angie,

Could you please share with us additional details on the web service?

We would like to see the WSDL and if publicly available try the service our self.

If you don't want post on the forum, send an email to
stylus-field-report@progress.com

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

Angie Kennedy

Subject: How to Convert CSV lines to individual XML file and submit to Web Service
Author: Angie Kennedy
Date: 18 Aug 2009 03:48 PM
Originally Posted: 18 Aug 2009 03:46 PM

Hi, absolutely.

I will attach the WSDL File; I will send the Test site to you via Email.

The request that I am working with at this time is Customer_add_request.

Please let me know if I can provied any additional information.
Thank you......Angie Kennedy

slwebsvc.wsdl
Complete WSDL File

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.