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 » having problem converting csv to xml in stylus
Conferences Close Tree View
+ Stylus Studio Feature Requests (1123)
- Stylus Studio Technical Forum (13808)
-> + X14 Enterprise - Web Services ... (3)
-> + Saxon edition in X14 Enterpris... (2)
-> + How to create PDF documents wi... (2)
-> + WSCall doesn't work from xquer... (4)
-> + Issues with converter (8)
-> + xsd null strings - option to i... (2)
-> + wrapping table rows and mismat... (3)
-> + Report Designer: Is it possibl... (4)
-> + Message Baplie 1.5 with 1.911 ... (2)
-> + saved merged view in diff engi... (2)
-> + Cannot see needed element to m... (2)
-> + Matching problem in function (3)
-> - Funny warning message (1)
-> - Missing rows and text when con... (1)
-> + Another JSON problem (2)
-> + JSON problem (8)
-> + WebDav Custom properties (2)
-> + jvm not registering in the too... (2)
-> + How to turn off error about mi... (6)
-> + XML Attribute Element output f... (2)
-> + ddtek:wscall not returning all... (7)
-> - Trial Only Lasted 7 of the 14 ... (1)
-> + tree view without leaves (fiel... (3)
-> + XML to Text File (2)
-> + Stylus Studio Processor Debugg... (3)
-> + Java XMLPipeline result to str... (6)
-> + Attribute - XSD, DataDirect, X... (7)
-> + .NET XslCompliedTransform pro... (3)
-> + How to increase JVM Heap Size? (10)
-> + How in XSD do I reference the ... (2)
-> + Conversion of negative numbers (2)
-> + XSLT mapper (2)
-> - Converting csv file with embed... (1)
-> + WSDL completion inquiry (2)
-> - Move License (1)
-> + XML to Excel conversion and vi... (8)
-> + “spell checker” and “well-form... (2)
-> + Relational DB Icon Not appeari... (2)
-> + How come AUP doesn't respond (4)
-> - Software activation does not w... (1)
-> + Stylus studio continually cras... (2)
-> + Error running on Windows 7 (3)
-> + Creating xml start and end tag... (4)
-> + Keeping track of position afte... (3)
-> + splitting a row into multiple ... (3)
-> + Where is Convert to XML? (2)
-> + Built-In XSLT Processor Missin... (4)
-> - Converting XSL to XSL-FO (1)
-> - Can we compare two XML Schema ... (1)
-> - Stylus Studio EDI Conversion /... (1)
-> + Installation Issue Windows XP ... (2)
-> + Converting CSV with component ... (2)
-> - how to edit a xsl file, so tha... (1)
-> - Cannot save file to Webdav (1)
-> + How to copy Column Names on Gr... (3)
-> - XML when to use (1)
-> - Attribute vs data elements (1)
-> - Attribute Group (1)
-> - EDI conversion from command li... (1)
-> - WSDL schema - import of xsd (1)
-> + Get Date (2)
-> + help calling https web service (5)
-> - Newbie looking out for BizTalk... (1)
-> + Publishing XML pipeline as Web... (2)
-> - annotation within sequence ele... (1)
-> - backmapping using Saxonica 9.1... (1)
-> + JVM detection not finding JDK ... (2)
-> - stylus studio version 2011 pro... (1)
-> - WSDL 2.0 (1)
-> + Special characters in xml (2)
-> + cannot connect to mysql commun... (2)
-> + create a report from an existi... (2)
-> + Content not allowed in prolog (2)
-> + DB IInformix with database loc... (8)
-> + Stylus Report Designer (XML Re... (4)
-> - error: cos-nonambig: Content m... (1)
-> - UNIX .csv conversion and java ... (1)
-> + Nillable element, Validation e... (2)
-> + EDI Converter Error (2)
-> - CSV FILE INTO CARGO-IMP MESSAG... (1)
-> + BUG: Validation in piple will ... (2)
-> + Is there a 64-Bit Stylus Studi... (2)
-> + BUG: Read structure on SQL Ser... (3)
-> + [Customer Toyoto Motors Europe... (2)
-> - Get a schema for a JSON file (1)
-> + UNOC:4 forces converter to inp... (2)
-> - java class for xs:any elements (1)
-> + changing component separator (3)
-> + Output view disappeared (6)
-> + How to convert deeply nested X... (2)
-> + javax.net.ssl.SSLException (4)
-> + error converting .csv in a uni... (10)
-> + Menu bar disappeared (2)
-> - No Topic (1)
-> - What does "XML" stand for? So... (1)
-> - So XML is just HTML on steroid... (1)
-> + XHTML to XML conversion (2)
-> - Stylus Studio with DDTek xml c... (1)
-> + Installation fails (3)
-> + Is there a keyboard shortcut t... (2)
-- Previous [121-140] [141-160] [161-180] Next
+ Website Feedback (243)
+ XSLT Help and Discussion (7447)
+ XQuery Help and Discussion (1861)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (361)
+ Stylus Studio Announcements (113)
Topic  
Postnext
cheryl culwellSubject: having problem converting csv to xml in stylus
Author: cheryl culwell
Date: 12 Oct 2010 10:24 AM
I have a csv file which needs to be converted to XML format; I have the schema from the state of ND that needs to be used. How can I get stylus 'mapped?' so that this will happen automatically at some point during the month for reporting to the state? I have sent the csv file and the ND state schema. Thanks in advance for your assistance.


UnknownnnewNorthDakotaForm5XMLQuery.csv
csv file for nd schema

UnknowneReport36.xsd
north dakota xml schema

Postnext
Ivan PedruzziSubject: having problem converting csv to xml in stylus
Author: Ivan Pedruzzi
Date: 13 Oct 2010 10:53 PM


Have a look at this video tutorial, you need to set the CSV as source and the XML schema as destination

http://www.stylusstudio.com/videos/xml_to_csv/xml_to_csv.html


Ivan

Postnext
cheryl culwellSubject: having problem converting csv to xml in stylus
Author: cheryl culwell
Date: 22 Oct 2010 12:03 PM
When I try to use the csv file as the source document, I get the following error


Unknownerroroncsv.docx
error which displays

Unknownnew5xmlformnd.csv
this is my csv document
Postnext
Ivan PedruzziSubject: having problem converting csv to xml in stylus
Author: Ivan Pedruzzi
Date: 22 Oct 2010 11:25 PM

mimetype docx is not supported by the forum, could you please zip your attachment?

Thanks!
Ivan
Postnext
cheryl culwellSubject: having problem converting csv to xml in stylus
Author: cheryl culwell
Date: 25 Oct 2010 10:13 AM
I am sending the zipped error attachment. Thanks


Unknownerroroncsv.zip
Postnext
Ivan PedruzziSubject: having problem converting csv to xml in stylus
Author: Ivan Pedruzzi
Date: 26 Oct 2010 12:10 AM

Cheryl,

Did you open the CSV file using "Open Using XML Converter" in the open file dialog?


Ivan
Postnext
cheryl culwellSubject: having problem converting csv to xml in stylus
Author: cheryl culwell
Date: 26 Oct 2010 08:39 AM
Ivan,
It doesn't give me that option, it immediately displays the error as soon as I try to open the file.
Posttop
Ivan PedruzziSubject: having problem converting csv to xml in stylus
Author: Ivan Pedruzzi
Date: 26 Oct 2010 09:49 PM

The check box is at the bottom of the Open File Dialog

See attached screen shot

Ivan

   
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-2011 All Rights Reserved.