XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Rock ChampSubject: Utilizing Stylus Studio for automated CSV, DBF and XLS conversion to XML
Author: Rock Champ
Date: 03 Aug 2006 06:01 PM
I am wondering how stylus can help me perform the following action efficiently.

I would like to convert incoming .csv, .dbf and .xls files to XML which would then relate to my existing database by way of an XSLT file as each file that comes in has different named headers and locations of columns. WHen this data is searched it is returned conformed to one standard display.

Any ideas of the most efficient way of doing this is greatly appreciated.
If i am way off please let me know as well :)

RC

Postnext
Ivan PedruzziSubject: Utilizing Stylus Studio for automated CSV, DBF and XLS conversion to XML
Author: Ivan Pedruzzi
Date: 03 Aug 2006 06:48 PM

Please have a look to the XML Adapters
http://www.stylusstudio.com/deployment/

...and the video tutorial at
http://www.stylusstudio.com/videos/deployment1/deployment1.html

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

Postnext
Rock ChampSubject: Utilizing Stylus Studio for automated CSV, DBF and XLS conversion to XML
Author: Rock Champ
Date: 16 Aug 2006 12:15 PM
Ivan,

Thanks for your response, i have looked over the video and even read through some of the documentation all to no avail. I can do it manually, but wanted to know what/how to have a process run to automatically convert the .csv/.xls/.dbf file to an xml file.

Thanks again for your response.

RC

Posttop
Ivan PedruzziSubject: Utilizing Stylus Studio for automated CSV, DBF and XLS conversion to XML
Author: Ivan Pedruzzi
Date: 16 Aug 2006 03:12 PM

The documentation and tutorials provides several examples of Java code that shows how to use the XML converters

Like this one
http://www.stylusstudio.com/xml_adapters.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 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! 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

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
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.