XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Technical Forum » Utilizing Stylus Studio for automated CSV, DBF and XLS conversion to XML
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> - Stylus Studio - Registrar en o... (1)
-> + Stylus Studio - Registrar en o... (2)
-> + Can a pipeline send a file by ... (2)
-> + After Updateing WIN10 to WIN11... (12)
-> + Where do I add the custom java... (3)
-> + Where is the Diagram tab? (5)
-> + Applying XSLT to Word DOCX/XML (2)
-> - CSV conversion via ConvertToXM... (1)
-> + Text symbols in SS not same as... (4)
-> + Exposing xquery as webservice ... (6)
-> + Syntax Identifier (2)
-> + Saving a Converted XML as an X... (5)
-> + Output document cannot be pars... (4)
-> - Archiving output from conversi... (1)
-> + EDIFACT guideline from Stylus ... (3)
-> + CSV file putting all the data ... (5)
-> + Can't install Home version 64b... (5)
-> + presale - Can I covers this sc... (5)
-> + Problem with UNB (5)
-> + Splitting EDIFACT files pipeli... (4)
-- [1-20] [21-40] [41-60] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
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
   
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.