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 » DB-to-XML can only get one row insert at a time
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + Disabled Watch and Variable Vi... (4)
-> + Accessing Filemaker DB via ODB... (2)
-> + About XML Graphs (2)
-> + Error when generate java bindi... (2)
-> + Formatting a number to always ... (2)
-> + Bug with graphical mapper (2)
-> + Back Map to XML does not work (2)
-> + Floating Instruction Graphics (2)
-> + Mapping XSD (4)
-> + Output has dashes (Hyphens) th... (7)
-> + Fwd: Error Message (2)
-> + Error Message (5)
-> + EPG XML Generation (2)
-> + Connection to DB2 UDB (8)
-> + Instructions In Mapper (6)
-> + using oracle's orcl:right-trim... (2)
-> + xsl fo, generate links in pdf... (3)
-> + Documentation (annotations) in... (4)
-> + Linking to RDBMS to Applicatio... (2)
-> + Stylus build 653c // Metainfor... (3)
-> + namesspacing external entities (6)
-> + Suppress namespace on every no... (5)
-> + xpath: how do I get what I wan... (6)
-> + Still can't remove SS!! (2)
-> + Convert to XML (3)
-> + EDI Error (10)
-> + (500) internal server error wh... (2)
-> + Space formatting with   (4)
-> + UDDI Browser and WS Call Compo... (4)
-> + cursor weirdness (2)
-> + Open XML files in IE, edit wit... (3)
-> + Generate XML from schema (2)
-> + Line-oriented region problem i... (4)
-> + Using local DB2 database Alias... (2)
-> + Small but annoying display bug... (3)
-> + Blank values in lookup lists (11)
-> + xsd problem in mapper (2)
-> + Deployment License (2)
-> + XML post and web service (2)
-> + Stylus just wont start? (2)
-> - Can'rt remove SS from Windows ... (1)
-> + SenseX stops working on second... (4)
-> + dodgy(non-ascii) characters ca... (8)
-> + Optional values (ZZ1) causes e... (3)
-> + Have problems with displaying ... (9)
-> + Can Stylus Studio be used to m... (3)
-> + Erratic behaviour in EDIFACT a... (2)
-> + Year Calculation (2)
-> + How to ouput a real XLS (3)
-> + EDI 856 to XML - java.io.IOExc... (3)
-> + Problem transform EDI to XML (... (2)
-> + SS becomes unusable... (6)
-> + SS Enterprise 735f under WinXP... (7)
-> + Call Web Service, Nothing retu... (12)
-> + Error while debugging xslt wit... (2)
-> + DESADV D96A Schema vs XML inco... (4)
-> + Das Programm mit mysql ? (4)
-> + RegEx Search and Replace (6)
-> + SequeLink Server - Do I need a... (6)
-> + faultString: (401)Unauthorized... (7)
-> + Previewing XSL with javascript... (2)
-> + removing formating from XML (6)
-> + removing formating from XML (2)
-> + Custom EDI to XML conversion (2)
-> + Getting "Type not found" error... (4)
-> - Converting file and customize ... (1)
-> + formatting problem with xml ex... (2)
-> + Using DTD Entities and XSD (7)
-> + XML Schema (XSD), Adding comme... (2)
-> + DTD schema generation problem (2)
-> + How do i generate a schema fro... (4)
-> + Incomplete request message gen... (2)
-> + Installation issue for Stylus ... (2)
-> + DTD "ANY" isn't honored by val... (2)
-> + Replacing carriage returns wit... (3)
-> + WS with SOAP - problem with pa... (5)
-> + problem converting CSV to XML (2)
-> + validating xml with multiple s... (4)
-> + SOAP problems ! (2)
-> + mapping csv columns to schema (2)
-> - Access DB to XML doc using an ... (1)
-> - DataDirect SequelLink w/MS Acc... (1)
-> + Problem with DB to XML Source ... (3)
-> + problems to work from the comm... (3)
-> + Stylus Studio Enterprise WScal... (4)
-> + Erratic behaviour in EDIFACT a... (14)
-> + XML Pipeline Question (7)
-> + Stylus Studio reports invalid ... (4)
-> - Is there a way to generate a G... (1)
-> + Stylus produced XSLT not trans... (2)
-> + XML Editor spell check - bug w... (4)
-> + API unlocks OK, but fails in n... (4)
-> + EDI to XML conversion for UNOC... (11)
-> + Stylus crashed with recurence ... (2)
-> + terrible perfomance using the ... (4)
-> + XSD to RDBMS, e.g. SQL Server,... (3)
-> + relational database (7)
-> + Stylus Studio 6 wrongfully det... (6)
-> + Having trouble with schema val... (5)
-> + Stylus Studio 2007 Home Editio... (2)
-- Previous [1681-1700] [1701-1720] [1721-1740] 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
jon wadSubject: DB-to-XML can only get one row insert at a time
Author: jon wad
Date: 02 Oct 2006 05:53 AM
Originally Posted: 02 Oct 2006 05:32 AM
hi,
I have followed the video tutorial db-to-xml-update.wmv @
http://www.stylusstudio.com/SSDN/upload/db-to-xml-update.wmv

and I'm wanting to process 160+ progranmme records to a mysql database table.
xml format as follows;

<programmes>
<programme>
<department>business</department>
<programme_title>bachelor of Business</programme_title>
etc...
</programme>
....
</programmes>

I have no problems with opening the datadirect link to the mysql 3.5 ODBC driver. I can create the .rdbxml file map the elements from the programmes.xml file to the created .rdbxml file, but when I run the xslt parser I get only one record showing in the preview and only one record written to the database?

How do i get all of the records into the database?

Do i need a doctype header in the xml source programmes file?

Do I have to have all the elements from the source xml file matching up with every table filed in the destination rdbms (mySQL), as I've only mapped a subset of elements from the source xml file to their relevant table field names?

The source 'programmes' xml file size is 302kb, is this to large to process, have tried cutting this into two parts but still get the same result?

The one programme record I get returned is half way down the source xml programme file list, i.e. it doesn't take the first record in the source programmes xml file?
Postnext
Ivan PedruzziSubject: DB-to-XML can only get one row insert at a time
Author: Ivan Pedruzzi
Date: 02 Oct 2006 07:30 AM
Jon,

If your XSLT generates only one "record" something is wrong with the logic.

May be you forgot to create a repeatable link in your mapping.

If you send to us the files(.xsl, .rdbxml and a sample of input XML) to stylus-field-report@progress.com we will tell you more.

Hope this helps
Ivan Pedruzzi
Stylus Studio Team
Postnext
jon wadSubject: DB-to-XML can only get one row insert at a time
Author: jon wad
Date: 02 Oct 2006 03:37 PM
Ivan,
Thanks for your quick reply. please find attached the .xsl, .rdbxml and sample xml input file (shortened version).

How do I create a repeatable link in my mapping?


DocumentPROGRAMME_ALL_PART1.xml
.xml source file

Documentjaspervers4.rdbxml
.rdbxml file

Unknownjasperver4.xsl
.xsl file
Postnext
Ivan PedruzziSubject: DB-to-XML can only get one row insert at a time
Author: Ivan Pedruzzi
Date: 02 Oct 2006 03:59 PM

See the XSLT attached

Ivan Pedruzzi
Stylus Studio Team


Documentjasperver4-wtih-for-each.xsl
Postnext
jon wadSubject: DB-to-XML can only get one row insert at a time
Author: jon wad
Date: 03 Oct 2006 05:51 AM
Thanks for this Ivan.

As a newbie to xsl is their a feature in stylus studio that will input these xslt functions via some sort of intelli-sense,
or a xpath function library lookup feature?

Regards


Jon
Posttop
Ivan PedruzziSubject: DB-to-XML can only get one row insert at a time
Author: Ivan Pedruzzi
Date: 03 Oct 2006 11:04 AM
Jon,

In the mapping tool you just need to link the repeating element, in this case "PROGRAMME" to the destination repeating element, in this case "row", using the mouse right button, when the pop-up menu appears click "Create Repeatable link"

Have a look to the video tutorial
http://www.stylusstudio.com/videos/xsltedit1/xsltedit1.html
http://www.stylusstudio.com/xslt_mapper.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.