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 » XSLT Help and Discussion » Newbie Question - Generating XML from XSL File?
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
- XSLT Help and Discussion (7625)
-> + Use of before and after string (3) Sticky Topic
-> - How do I substitute element ty... (1)
-> + How does one add working days ... (4)
-> - Help, I have existing XLT and... (1)
-> + Need help on XSLT issue - (2)
-> + EDI to XML Conversion (7)
-> - XML To JSON Conversion using X... (1)
-> + Formatting Paragraphs to same ... (2)
-> - Grouping of records (1)
-> + Problems with xsd 1.1 (4)
-> + XML to HL7 mapping (3)
-> + XSLT 3 and Iterate (2)
-> + XSL-FO to PDF preview (3)
-> + java.lang.RuntimeException: Er... (2)
-> + Create Acroforms with Stylus X... (2)
-> + How to change XSLT parameter s... (3)
-> + how to change format of the da... (2)
-> + Search "Next 8 Results " doesn... (2)
-> - Support for Git (1)
-> + newbee (8)
-- [1-20] [21-40] [41-60] Next
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Andrea McVeySubject: Newbie Question - Generating XML from XSL File?
Author: Andrea McVey
Date: 11 Feb 2005 11:34 AM
Hi,
I have recently started using Stylus Studio and have very little experience with xml. I am using an xml data file as the source document and an existing schema. I have mapped all the fields and run the preview to view the first record in the dataset. After saving the preview and running it into my database, the entry worked perfectly.

Here is my dilemma...
I have not been able to figure out how to create an xml file that will load all the records. The preview only listed the first (which worked), but all the others are being dropped. How do I generate xml from this xsl?

I am facing a serious time crunch, so any help would be appreciated.
Thanks,
Andrea
Postnext
Ivan PedruzziSubject: Newbie Question - Generating XML from XSL File?
Author: Ivan Pedruzzi
Date: 11 Feb 2005 12:28 PM
Andrea

My guess is that you are not looping on the repeting elements you
would like to generate.

Take a look to the sampleBooksToCatalog.xsl example to have an idea
c:\Program Files\Stylus Studio XML Professional Edition\examples\simpleMappings\sampleBooksToCatalog.xsl

hope this helps
Ivan
Postnext
Andrea McVeySubject: Newbie Question - Generating XML from XSL File?
Author: Andrea McVey
Date: 11 Feb 2005 12:56 PM
I have taken a look at the sample and tried to implement it into my code, but I just end up with gobbleydeguck.

I have attached my code. Basically, I need it to write one record into eExact/Accounts/Account (plus the subdirectories) per record in my source xml.
Any suggestions?
Thanks again,
Andrea



<?xml version='1.0' ?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<eExact>
<Accounts>
<Account type="C" status="A">
<xsl:for-each select="dataroot/StudentInfoTest/ID">
<xsl:attribute name="code">
<xsl:value-of select="."/>
</xsl:attribute>
<Name>
<xsl:value-of select="dataroot/StudentInfoTest/Full_x0020_Name"/>
</Name>
<Phone>
<xsl:value-of select="dataroot/StudentInfoTest/Home_x0020_Phone"/>
</Phone>
<Addresses>
<Address>
<Addressee>
<Name>
<xsl:value-of select="dataroot/StudentInfoTest/Full_x0020_Name"/>
</Name>
</Addressee>
<AddressLine1>
<xsl:value-of select="dataroot/StudentInfoTest/Address"/>
</AddressLine1>
<PostalCode>
<xsl:value-of select="dataroot/StudentInfoTest/Postal_x0020_Code"/>
</PostalCode>
<City>
<xsl:value-of select="dataroot/StudentInfoTest/City"/>
</City>
<State code="ON">
<Description>Ontario</Description>
</State>
<Country code="CA">
<Description>Canada</Description>
</Country>
<Phone>
<xsl:value-of select="dataroot/StudentInfoTest/Home_x0020_Phone"/>
</Phone>
</Address>
</Addresses>
<Contacts>
<Contact default="1">
<LastName>
<xsl:value-of select="dataroot/StudentInfoTest/Last_x0020_Name"/>
</LastName>
<FirstName>
<xsl:value-of select="dataroot/StudentInfoTest/First_x0020_Name"/>
</FirstName>
<Addresses>
<Address>
<Addressee>
<Name>
<xsl:value-of select="dataroot/StudentInfoTest/Full_x0020_Name"/>
</Name>
</Addressee>
<AddressLine1>
<xsl:value-of select="dataroot/StudentInfoTest/Address"/>
</AddressLine1>
<PostalCode>
<xsl:value-of select="dataroot/StudentInfoTest/Postal_x0020_Code"/>
</PostalCode>
<City>
<xsl:value-of select="dataroot/StudentInfoTest/City"/>
</City>
<State code="ON">
<Description>Ontario</Description>
</State>
<Country code="CA">
<Description>Canada</Description>
</Country>
<Phone>
<xsl:value-of select="dataroot/StudentInfoTest/Home_x0020_Phone"/>
</Phone>
</Address>
</Addresses>
<Manager number="206336" code="206">
<LastName/>
</Manager>
<Language code="AE">
<Description>American English</Description>
</Language>
<JobDescription>Student</JobDescription>
</Contact>
</Contacts>
<Manager/>
<FreeFields>
<FreeTexts>
<FreeText number="1">
<xsl:value-of select="dataroot/StudentInfoTest/Program_x0020_of_x0020_Study"/>
</FreeText>
</FreeTexts>
</FreeFields>
</xsl:for-each>
</Account>
</Accounts>
</eExact>
</xsl:template>
</xsl:stylesheet>

Posttop
Andrea McVeySubject: Newbie Question - Generating XML from XSL File?
Author: Andrea McVey
Date: 11 Feb 2005 02:17 PM
Woohoo!

I got it to work. I had the tag set at the wrong level. Once I moved it under <Accounts>, it worked fine.
Thanks for your help!
Andrea
   
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.