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 » Stylus vs Altova Mapforce - Stylus steps to acheive similar result?
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + What Pipeline standard do you ... (4)
-> + How can i increase sylus memor... (2)
-> - Tutorial & Tech support needed (1)
-> + Generate HTML Documentation fr... (3)
-> + Use of saxonsa outside stylus ... (2)
-> + Schema to DTD (6)
-> + Trial version requires interne... (4)
-> - APACHE FOP text box (1)
-> + Cannot create SQL Server datas... (11)
-> + StylusValidator Crashes (2)
-> + XML diff with optimize Change ... (2)
-> + how do I get the .xsl page to ... (3)
-> + Can't Use WYSIWYG from the Fil... (6)
-> + EDI Help (2)
-> + XInclude support (3)
-> + Editor options and customized ... (3)
-> + Licensed version connectes to ... (6)
-> + handling abstract types in the... (5)
-> + XML not validating against its... (4)
-> + SS gets into state where the "... (6)
-> + Download Link from Order email... (2)
-> + Stylus Studio doesn't run (2)
-> + Indent XML Tags uses pretty sh... (2)
-> + Some questions on supported pl... (3)
-> + Apache FOP Border (2)
-> + line numbers, line-wrap.. (11)
-> + Not Able to Load Siebel Web Se... (3)
-> + XSLT node or nodeset as scenar... (4)
-> - tree view parsing error: Expec... (1)
-> + reactivating the license key f... (2)
-> + XSL FO region-body border (2)
-> + WhiteSpace facet default (2)
-> - Web Service Call (1)
-> + DB to XML convertion (6)
-> + Converting: How to handle data... (2)
-> + Toss Character Exception (2)
-> + EDI conversion COM segment (5)
-> - SS passing invalid CALS table ... (1)
-> + Carrier Related EDI SAP questi... (2)
-> + How to generate 1 output XML f... (2)
-> + Urgent Eval: How2 w/ Possibly ... (4)
-> + Preview Problems (7)
-> + Mapping to EDIFACT ORDERS UNT0... (8)
-> + Deploying Conversion XML to ED... (2)
-> + Use EDI Adapter within Sap BC (3)
-> + Uninstall->instal entepr. 2007 (2)
-> - xml data to sql 2000 table (1)
-> - Convert from Oracle DB to XML ... (1)
-> + NTFShardlink broken (5)
-> + Can't get catalog to work (3)
-> + Only One of each EDI segment g... (3)
-> + convert (2)
-> + convert (4)
-> + EDIFACT to XSD problem (3)
-> + quark xpress tags (2)
-> + Duplicating nodes allows to cr... (2)
-> + Duplicated, unused nodes are r... (3)
-> + Converting to XML from a varie... (5)
-> + xsd:import's with escaped char... (8)
-> + Viewing the FO Sample Applicat... (3)
-> + Stylus Studio - Window tiling (3)
-> + Question about XML->Java Objec... (2)
-> + SVG web-based editor (2)
-> + conversion process for the pdf... (2)
-> + GUI Mapper does not create pro... (4)
-> + JavaScript working inside prev... (4)
-> + Stylus Studio Crashes when I a... (4)
-> + SVG ImageReader for FOP (2)
-> + Web Service Call Using HTTPS (8)
-> + Meditech database (2)
-> + How to connect to Informix (5)
-> + long filenames in Berkeley XML... (3)
-> + Opening multiple documents = m... (3)
-> + MySQL Connectivity (2)
-> + using .xsd to create forms (3)
-> + Convert-to-XML Engine could no... (2)
-> + editor questions (2)
-> + Cannot connect to SQL server (7)
-> + Convert Cobol file to XML (2)
-> + XML Diff problem (4)
-> + running XSLT - time + memory m... (7)
-> + New wsdl creation (4)
-> + DB to XML Parameters (2)
-> + Help (html in xml) need to out... (8)
-> + Stylesheet questions (2)
-> + Verion 1.0 XPATH for testing "... (5)
-> + Berkely XML DB file system (2)
-> + WYSIWYG in 2007 demo (2)
-> + EDIFACT code list problem (3)
-> + XQuery over a Berkeley XML DB ... (3)
-> + Href and display linked ref. (2)
-> + How my applications can gener... (11)
-> + CLASSPATH (2)
-> + Fixed order of attributes (2)
-> + merging XML files (13)
-> - The Struzzo.exe hung with no G... (1)
-> + Problem Registering Old Versio... (4)
-> + CHART.XML + CHART.XSL to CHART... (17)
-> + Aplication not loading (6)
-> + Can Stylus Studio be used to s... (2)
-- Previous [1801-1820] [1821-1840] [1841-1860] 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
steve reidSubject: Stylus vs Altova Mapforce - Stylus steps to acheive similar result?
Author: steve reid
Date: 14 Sep 2006 06:02 AM
Hi all,
Im deciding which xml prog to buy and I'm now testing Stylus Studio and need some help in the steps I should be taking.

I have a csv file. It needs to be converted to xml then be validated against a pre-designed schema file.

In Altova mapforce I imported the schema file, imported the csv file and mapped or connected the two files together with lines, and the output looked good.

How do I do this in Stylus? Im not looking for detail just a quick - you need to do A, then B then C and you have your xml file.

Thanks
Steven
Postnext
Minollo I.Subject: Stylus vs Altova Mapforce - Stylus steps to acheive similar result?
Author: Minollo I.
Date: 14 Sep 2006 01:22 PM
In Stylus Studio v2006 you can achieve the CSV->XML->XSLT steps simply creating a new XSLT and opening the XML source for the XSLT through a conversion (File > Open, select the CSV file and check the "Convert to XML box"). The validation step is not automatically available in this sequence.

In the coming Stylus Studio v2007, you can create an XML Pipeline and have a CSV conversion node connected to a Validate node, that in turn feeds an XSLT transformation node (or an error node if validation fails). The whole pipeline process can then been generated as Java code.
Postnext
steve reidSubject: Stylus vs Altova Mapforce - Stylus steps to acheive similar result?
Author: steve reid
Date: 15 Sep 2006 10:07 AM
Thanks for the info! Im almost there having done as you said above, but Im having trouble with the mapping section and wondered if someone can help. Im a newb so it should be pretty simple!

My CSV and resulting XML doc is laid out like this, with the first line being the header:

OFFICE OFFICE_CODE NAME AGE
A 123 john 28
A 123 james 36
A 123 jim 54

I need the xml mapper to map to an xml document like this:

<headingset>
<office>A</office>
<office_code>123</office>
<heading>
<name>john</name>
<age>28</age>
</heading>
<heading>
<name>james</name>
<age>36</age>
</heading>
<heading>
<name>jim</name>
<age>54</age>
</headingset>

but im not having much luck! I cant seem to get the xml file to "split" correctly. Should I be arranging the csv to a more appropriate format at the csv to xml coversion stage or should I be trying to arrange in my desired order using the xslt mapper? Been trying for hours now with no luck!
Any help appreciated
Steve
Posttop
Tony LavinioSubject: Stylus vs Altova Mapforce - Stylus steps to acheive similar result?
Author: Tony Lavinio
Date: 19 Sep 2006 03:51 PM
The best way to do it would be a two-stage approach.
The first step uses Convert-to-XML to create the
'XML equivalent' of the original file.
Then you use XSLT to rearrange and group.
Some pointers on grouping can be found at the excellent pages
under the "Complex Tasks" heading at
http://www.jenitennison.com/xslt/index.html
Especially look at the Grouping pages.

   
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.