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 » CSV set up to support predefined XML
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + Specifying EDI Delimiters (2)
-> + Defining 'connection string' f... (9)
-> + Help Programatically Convertin... (2)
-> + Using adapter URL in pipeline. (7)
-> + How to enable EDI functionalit... (2)
-> + Unable to open file with '%2F'... (2)
-> + How to create a dependency gra... (2)
-> + If block (2)
-> + Mapping multiple files within ... (7)
-> + StylusStudio vs Altova vs BizT... (4)
-> + Command line execution (7)
-> + CSS and Styling in X15 (2)
-> + Ignores debug breakpoints in X... (5)
-> + Cursor dissapearing in Text vi... (5)
-> + compile error xquery java styl... (3)
-> + Stylus Studio Setup: Applicati... (10)
-> + Stylus StudioX15 Crashing whe... (4)
-> + Upgrade Stylus 14 to 15 (2)
-> + ACE Broker Download v2.5 (2)
-> + Help creating custom convertor (7)
-> + Problem saving Documentation (5)
-> + Registry keys for Stylus x15 (8)
-> + How to add a value when conver... (10)
-> + Stylus Studio Pro & Ent X15r1 ... (2)
-> + You need to install Java 2 SDK... (4)
-> - How to disable automatic and m... (1)
-> + Does Stylus Studio / DataDirec... (4)
-> + Stylus Studio fails with 'The ... (12)
-> + Struzzo.exe side by side confi... (7)
-> + unable to use converter (5)
-> + How to enable XSD 1.1 for Saxo... (3)
-> + XSD v.1.1 validation and Xerce... (8)
-> + FATAL ERROR: unsupported XML v... (2)
-> + Java Runtime Environment boot ... (2)
-> + Associate XML with Schema (3)
-> + JVM not found in stylus studio... (2)
-> + Change newline to Linux (on Wi... (4)
-> + Indent XML Tags only partially... (2)
-> + dealing with invalid character... (2)
-> + Unable to call Webservice thro... (2)
-> + XML to CSV Video create csv te... (5)
-> + Try to test this product, (2)
-> + How to migrate license? (3)
-> - kepp your settings on X15 upda... (1)
-> + No Topic (2)
-> + XSD validation scalability iss... (2)
-> + Installing documentation in ai... (4)
-> + Stylus Studio is currently una... (2)
-> + Change from SS Pro 2011 to SS ... (2)
-> + Problem with pipeline function... (2)
-> + Min and Max Occurs for Choices... (2)
-> + XSLT without Preview window ou... (3)
-> + How to achieve this transforma... (2)
-> + Licence Authentication Failed (2)
-> - using Oracle V2 for validation... (1)
-> + Steps needed to execute standa... (2)
-> + xsi:noNamespaceSchemaLocation ... (8)
-> + Using Saxon 9.4 and integrated... (4)
-> + "net XML Parser (5)
-> + How to undo in Stylus Studio X... (2)
-> + .RENAME section not loaded cor... (3)
-> + Stylus StudioŽ X14 Release 2 X... (2)
-> + The JVM initialization failed ... (2)
-> + XML schema to XML does not wor... (4)
-> + missing ExtraLines (3)
-> + EDI validation tool (2)
-> + Registering Custom Tool from c... (5)
-> + Setting Default XML Validation... (2)
-> + Project Directory in Custom Do... (3)
-> + Problem with Saxon 9.4.0.4 AVT... (5)
-> + XML To HL7 (3)
-> + Siblings not repeating when mi... (7)
-> + Nesting of records from fixed ... (5)
-> + Licensing (3)
-> - CSV set up to support predefin... (10)
-> ->CSV set up to support pre...
-> ->CSV set up to support pre...
-> ->CSV set up to support pre...
-> ->CSV set up to support pre...
-> ->CSV set up to support pre...
-> ->CSV set up to support pre...
-> ->CSV set up to support pre...
-> ->CSV set up to support pre...
-> ->CSV set up to support pre...
-> + Scripting conversion (2)
-> + Edi/Euritmo automatic conversi... (4)
-> + Have new stylesheet automatica... (3)
-> + Text file to CSV to xml (9)
-> + EDIFACT to XML (4)
-> + About Stylus Studio... dialog ... (5)
-> + Set Stylus as default editor f... (3)
-> + CSV to XML (11)
-> + Indent XML tags no longer work... (9)
-> + XSL code completion moe like o... (3)
-> + xsl:fo - unable to use any fon... (5)
-> + Bug when calling a ms script f... (13)
-> - url schema (1)
-> + Quickbooks invoice to XML (4)
-> + X14 locks up, Unresponsive (4)
-> + Fields missing from middle of ... (2)
-> + Cannot install trial (2)
-> + Text File with Page breaks - H... (8)
-> + Complex transactional CSV mapp... (2)
-> + XML Report (2)
-> - Create an XML feed for videos (1)
-> + word doc (2)
-> + Saving to a UNC path (7)
-> + sharing violation (3)
-> + Convert XML to XML (6)
-- Previous [181-200] [201-220] [221-240] 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 HendricksSubject: CSV set up to support predefined XML
Author: Steve Hendricks
Date: 21 Jun 2012 11:22 PM
Hi,
I'm using the trial version. We're trying to bring a CSV format into a predefined XSD. I've attached it as well as the XML that was manual put together. How should I form the CSV to map to the XSD and generate the correct XML? There are repeating components and maybe subcomponents (terminology)? I've looked at the component and subcomponent delimiters but the documentation isn't very clear. Thank you for the help.

Regards,

Steve


UnknownDots_Catalog_Product_Only.xsd
XSD

UnknownDots_Catalog_Product_Only.xml
XML
Postnext
Ivan PedruzziSubject: CSV set up to support predefined XML
Author: Ivan Pedruzzi
Date: 22 Jun 2012 09:10 AM

Could you share a sample of your CSV input?


Ivan Pedruzzi
Stylus Studio Team
Postnext
Steve HendricksSubject: CSV set up to support predefined XML
Author: Steve Hendricks
Date: 22 Jun 2012 09:21 AM
Hi,
That's the basis of my question. The data will come from a variety of sources however be linked at the Product level via the Style. If you use the Grid tab inside of Stylus Studio, you'll see breakdown of Product. I want to create the CSV that will map to the schema and obviously need to know how to process the CSV via a converter. I hope that answers your question. Thanks for the help.
Postnext
Ivan PedruzziSubject: CSV set up to support predefined XML
Author: Ivan Pedruzzi
Date: 22 Jun 2012 01:32 PM

Ideally it would be better to go from your multiple sources to XML
but you may need the flat file for some other reasons.

The project attached is one of many ways to go.

The flat file format use the first column to specify the record type and use pipe as separator character.

Product|Drop V Neck|DOTS|This pretty v neck tank is perfect for casual wear.|Y|11767JT4348||$5.00||||||74||COLOR_NAME|SIZE_NAME|1
CategoryToProduct|1-1-1|1|Y
ProductVariant|82673302|5.00|LIME PUNCH|99|XL|353|0104|Y|Y
...

XML Converters turns it into XML

<table>
<row>
<column.0>Product</column.0>
<column.1>Drop V Neck</column.1>
<column.2>DOTS</column.2>

The XSLT transformation generates the final result and the post XML schema validation step checks the output

An alternative solution would be generating separate flat files for product, CategoryToProduct, ProductVariant, etc. and using IDs to rebuild the hierarchy in XML.





Ivan Pedruzzi
Stylus Studio Team


DocumentDots_Catalog_Product_Only.zip
Postnext
Steve HendricksSubject: CSV set up to support predefined XML
Author: Steve Hendricks
Date: 22 Jun 2012 03:48 PM
Ivan,
Thanks for the response. I'll give it a try and report back. Enjoy the weekend.

Steve
Postnext
Steve HendricksSubject: CSV set up to support predefined XML
Author: Steve Hendricks
Date: 27 Jun 2012 10:18 AM
Hi,
Everything is going well. The templates were well defined. As a result, we'll move forward with purchasing the product. Great job on the technical support. The "other guys" were not as helpful. The only question right now is setting up the XLST functions. I've dropped in a for-each select in place but I need to create the condition for selection. Here's the before and after. I had to type in the after. Is there a graphical way to do it versus typing?

Before
<xsl:for-each select="table/row">

After
<xsl:for-each select="table/row[column.0 = 'Store']">
Postnext
Ivan PedruzziSubject: CSV set up to support predefined XML
Author: Ivan Pedruzzi
Date: 27 Jun 2012 04:05 PM

Happy to hear.

Predicates are supported but they are hidden by default to avoid overloading of the graphical representation. You can turn it on under tools>options>XSLT.


In addition the mapping tool allows you to use the "if" statement inside the for-each body.

Hope this helps
Ivan Pedruzzi
Stylus Studio Team
Postnext
Steve HendricksSubject: CSV set up to support predefined XML
Author: Steve Hendricks
Date: 27 Jun 2012 11:48 PM
Hi,
Got pretty far along with creating a new XLST but got stuck with a repeating elements. I've attached the txt file, conv, xsl and xsd via a zip file. When I do the preview, it generates fine until it gets to the lower level and then it creates weirdness inside of StoreEvent. It repeats as "StoreEvents/Store/StoreEvents/StoreEvent/Title/Description"

I want it to be "StoreEvents/StoreEvent/Title/Description".

I also noticed that my root level "StoreImport" doesn't appear in the Target Document within the mapper. It shows Dots_Store_Location.xsd/Stores/.../Store/ActiveFlag. I think it should be showing Dots_Store_Location.xsd/StoreImport/Stores/.../Store/ActiveFlag

I can't relate the apply templates in the match row/column.0 = StoreEvent to Stores as it gives me an Invalid Linking Operation. Thoughts?


UnknownDots_Store_Locations.zipx
Reference files for post
Postnext
Ivan PedruzziSubject: CSV set up to support predefined XML
Author: Ivan Pedruzzi
Date: 28 Jun 2012 02:31 PM
Have a look at template here

<xsl:template match="row[column.0 = 'StoreEvent']">
<StoreEvent>
<Title>
<xsl:value-of select="column.1"/>
</Title>
<Description>
<xsl:value-of select="column.2"/>
</Description>
</StoreEvent>
<xsl:apply-templates select="following-sibling::row[1][column.0 = 'StoreEvent']"/>
</xsl:template>

Hope this helps
Ivan Pedruzzi
Stylus Studio Team
Posttop
Steve HendricksSubject: CSV set up to support predefined XML
Author: Steve Hendricks
Date: 05 Jul 2012 10:48 PM
Everything worked fine. Thanks for the help.

   
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.