SSDN - Can Stylus Studio be used to send data from an Excel file to a server?

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Wayne Davies

Subject: Can Stylus Studio be used to send data from an Excel file to a server?
Author: Wayne Davies
Date: 24 Oct 2006 10:51 AM
Originally Posted: 24 Oct 2006 10:45 AM

I'm trying to develop a soap interface (or something simular)is this possible?

What I want to do is:

I work for a Recycling company in the UK.
We have set-up a store locate type system to be put onto our company website. Using a company called streetmap.biz
The way we've decided to use it is a little different as it does not find store but Service providers in a particular area. It searches by the type of services they do and give your the nearest first.

The user chooses the search critrea as shown in "searchscreen.gif"
and then brings back the results as shown in "resultscreen.gif"

The data is held on the streetmap.biz server and we sent them the original data in an excel format and they uploaded this for free. We are looking to update this data frequently (at least once a week but possibly more often) and they would charge each time they upload. We were told that we could use a SOAP interface.

I have no knowledge of XML or SOAP is it possible to send the data from Our systems to the other companies server?

as you can tell from my less than articulate questioning I am not very technically minded!

thanks in addvance

Wayne

Ivan Pedruzzi

Subject: Can Stylus Studio be used to send data from an Excel file to a server?
Author: Ivan Pedruzzi
Date: 24 Oct 2006 10:22 PM

Hi Wayne,

Once you have the WSDL document that describes the Web Service you want to access, you can use Web Service Call Composer to create the call and XQuery to invoke the service.

Have a look to the video tutorial
http://www.stylusstudio.com/videos/ws-xquery1/ws-xquery1.html

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

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.