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 » XQuery Help and Discussion » Best Way To Generate Complex XML Doc From Spreadsheet - Help!
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
- XQuery Help and Discussion (2017)
-> + problem converting json to XML... (2)
-> + Problem base64 decoding string... (3)
-> + Problems posting multipart for... (5)
-> + trouble with download of price... (2)
-> + Problem with http-post not bei... (3)
-> + path problem, xps_file:writeAl... (9)
-> + Xquery update support? (2)
-> + problem with Stylus studio try... (5)
-> + adding dtd reference to xml ou... (4)
-> + xquery escaping ambarsand when... (3)
-> + Whitespace problem when return... (5)
-> + Problem with namespace prefix ... (5)
-> - Sending via SFTP returns unexp... (1)
-> + Query and Sftp clent (4)
-> + xquery and try - catch (3)
-> + Query + ddtek:http-post optio... (5)
-> + Example files referenced in do... (3)
-> + Automatic Error Detection and ... (3)
-> + Working with result of ddtek:h... (2)
-> + Problems with FTP upload via X... (3)
-> + What path notation works when ... (6)
-> - Xquery Exception (1)
-> + [java] [Fatal Error] Test.xml:... (2)
-> + unable to produce correct XML ... (2)
-> + where can I find stylusxql uti... (3)
-> + Trouble Mapping Multiple Eleme... (3)
-> - input parameter (1)
-> - set element value (1)
-> + Xquery Performance Issue (21)
-> + Run Xquery Program using Java (3)
-> + XQuery XML to CSV (3)
-> + XQuery MySQL connector (4)
-> + XQuery with JDBC connection is... (3)
-> + Create FTP Server (2)
-> + XQuery Nested Loop Lookup (5)
-> + Xpath using a Variable for [@I... (2)
-> - My xqDoc option is disabled. (1)
-> + Xpath ancestor selection (4)
-> + Exception: sequence of more th... (2)
-> + XQUF usage (3)
-> - xquery rule execution (1)
-> + Loving XQuery (3)
-> + Cross Referencing Country Name... (4)
-> + Creating a Pivot Table with xQ... (2)
-> + Error Please Help (3)
-> - Error Please Help (1)
-> + XPath descendant question (2)
-> + java/lang/OutOfMemoryError Run... (2)
-> + Xquery key value lookup (8)
-> + Improve xQuery Performance (3)
-> + MS SQL Server - Disable order ... (10)
-> + proper use of fn:distinct-valu... (2)
-> + Ignore DTD (7)
-> - Thanks Ivan (1)
-> + Trying to get 2nd value of nod... (5)
-> + Outer joins (4)
-> + Figured Out Issues From Last P... (2)
-> - Best Way To Generate Complex X... (3)
-> ->Best Way To Generate Comp...
-> ->Best Way To Generate Comp...
-> + count in xquery (4)
-> + left/right presentation (3)
-> + new to stylus - connecting to ... (2)
-> + XQuery problem with namespaces (4)
-> + .conv and xquery problem (3)
-> + Can pass text into CONV file (2)
-> + doc-available not working as e... (4)
-> + ddtekjava write to file only e... (5)
-> + arrayindexoutofbounds with ddt... (7)
-> + XSD: Structure definition depe... (2)
-> + Fatal Error whitespace expecte... (3)
-> + Executing a pipeline sequence ... (2)
-> - Data Transfer (1)
-> + Specifying the SEF File Locati... (4)
-> + Multiply numbers... (2)
-> + Using Generated Java-Code... (5)
-> + Mapper does not show all nodes... (5)
-> - Xul tree search using XQuery X... (1)
-> + converting XML to CSV (2)
-> - datadirect licenses (1)
-> + generate a uuid (2)
-> + Help to write Xquery (2)
-> + XQuery java ddtek:serialize-to... (2)
-> + EDI to XML Automation (2)
-> + Generating XQUERY to use in Or... (2)
-> + Stylus is not easy to learn XQ... (2)
-> - java.lang.OutOfMemoryError (1)
-> + how to save to xml format (2)
-> + Formating a date in xquery (2)
-> + two xml statements when mappin... (5)
-> + XQuery (2)
-> + saxon-license.lic Not Found (2)
-> + hands off conversion to final ... (2)
-> + fn:substring in XQuery to Orac... (4)
-> + Using Saxon with XQuery to ins... (4)
-> + Can't SAVE or DO a SAVE AS Fro... (2)
-> + Saxon Unexpected token < e o f... (2)
-> + Inserting and selecting data i... (2)
-> - convert sql statement into xml... (1)
-> + need help in converting this a... (2)
-> + IS IT POSSIBLE TO DO AN XQUERY... (2)
-> + XQUERY RESULTS NOT IN PROPER F... (2)
-> + how to get data from database ... (2)
-> + tree view in xquery (2)
-> + Need help with SelectsingleNod... (5)
-> - counting in query (1)
-> + WebApplication with Xquery (3)
-> + Limit to number of elements in... (3)
-> + Automate xquery Conversion (2)
-> + ddtek:wscall problem (2)
-> - Problem with case sensitive (1)
-> + Is this the formal tech suppor... (2)
-> + problem with Conditional Expre... (5)
-> - problem with Conditional Expre... (1)
-> + connect to mysql for xquery? (2)
-> - NOOB Help (1)
-> - Getting rid of empty namespace... (1)
-> + Xquery not yielding results (3)
-> - fn:replace() inserting spaces ... (1)
-> + Xquery XML document with spcei... (7)
-> + XLS (MS Excel) to XML Converte... (3)
-> + Little Help :))) (2)
-> + Xquery tag position (2)
-> - Can I connect to MonetDB/XQuer... (1)
-> + Is there a way to format a num... (2)
-> + Please help convert SQL query ... (3)
-> + Connect to SQL Server Express ... (3)
-> - Convert HTML to XML within C# ... (1)
-> + return different result based ... (7)
-> + Java Heap Space (2)
-> + XQuery Results export to multi... (3)
-> + NO RETURN (5)
-> + Part of a csv into a current X... (3)
-> + How to escape ampersand in xqu... (2)
-> + How to Convert CSV lines to in... (5)
-> + Data connection Stylus Studio ... (2)
-> + Nested XQuery FLOWRs with RDBM... (3)
-> + observing xquery at work (2)
-> + alternative for 'exists' (4)
-> + Xquery and webpages how? (2)
-> + Help with another DataDirect p... (5)
-> + How to resolve XPTY0004 error (3)
-> + Search a sequence of siblings ... (3)
-> + DataDirect process getting XPS... (2)
-> + Find the parent who doesn't ha... (3)
-> + Help with a basic FLWOR query (3)
-> + xQuery Efficient Performance B... (5)
-> + How to break down a sequence a... (3)
-> + Xquery returning odd number fo... (2)
-> + Problems with Java date parame... (3)
-> + Xquery filter on multiple valu... (2)
-> + Xquery filter by using contain... (5)
-> + multiple xslt execution using ... (2)
-> + How to access to global variab... (6)
-> + "Value can not be converted to... (4)
-> + (simple) problem with xquery (3)
-> + Version of xQuery Included wit... (3)
-> + xQuery 1.0 Produces XPTY0004 E... (3)
-> + Replace Node with Set of Nodes (2)
-> + Unable to Use File Name as Ext... (5)
-> + EDI to XSD and validation (2)
-> + Sample XQuery extension using ... (2)
-> + Another EDI problem (7)
-> + Removing xmls:od and xmls:xsi ... (2)
-> + Configuring MarkLogic with Sty... (10)
-> + EDI to XML (7)
-> + Can't write to SQL-Server (4)
-> + XQuery and SQL-Server (2)
-> + Connection to MS SQL Server in... (2)
-> + copy/modify with Stylus Studio... (5)
-> - copy/modify with Stylus Studio... (1)
-> + [SQLServer JDBC Driver]Value c... (5)
-> + wild card chracter usage in XS... (2)
-> + Xquery with SQL NEWID function (4)
-> + Change Only One Line (5)
-> + Format DB xQuery results (3)
-> + Adding MsSQL Database to XQuer... (3)
-> + Need help with using XQuery in... (2)
-> + please help! simple XML transf... (2)
-> + xquery for invoice data (3)
-> + Xquery to cross reference two ... (3)
-> + how to list distinct value? (5)
-> + Reading XML Files Across Netwo... (8)
-> + I want to automatically check ... (4)
-> + Parent tags (5)
-> + Remove Empty tags (2)
-> + dynamic function call | dynami... (3)
-> + Can I define a function like f... (3)
-> + remove empty tags (4)
-> + Loops (7)
-> + flat to XML with xQuery (4)
-> + Xquery for timer based events. (2)
-> + Cleaning up Word 2007 xml (3)
-> + Xquery string-pad function (5)
-> + DB to XML Data Source (2)
-> + XML Streaming not working (2)
-> + XQuery General Question (11)
-> + ERROR XQueryMediator Error dur... (2)
-> + Print Date in XML File (2)
-> + Aritmetic in Xquery (2)
-> + Use content of node as node na... (2)
-> + Better way to do this? (3)
-> + Get output line by line!! (2)
-> + Use of if-then-else (2)
-> + Manipulation of XQuery output!... (4)
-> + Subtract times (6)
-> + Using xQuery to call a Convers... (3)
-> + How to add a custom class to t... (3)
-> + How to get rid of multiple occ... (2)
-> + Problem with conditional JOINi... (8)
-> + XQuery editor whitin Stylus St... (3)
-> + Get rid of spaces in returned ... (4)
-> + Can XQuery be embeded in a Jav... (2)
-> + Need help on converting <br... (3)
-> + postgresql (3)
-> + No format-number functionsupp... (4)
-> + Swapping elements using XQuery... (2)
-> + Trying to contact DataDirect d... (3)
-> + External Java functions with b... (5)
-> + Looking for xQuery help (6)
-> + Built-in processor & filtered ... (2)
-> + Multiple Sibling Matches (2)
-> + Issue with data($element) (4)
-> + convert text to xml from more ... (2)
-> + xquery syntax (2)
-> + SQL Table To XML using XQuery (4)
-> + delimiting values of attribute... (3)
-> + empty child nodes (9)
-> + Illegal XML characters (4)
-> + Complete SQL Server database t... (34)
-> + Prevent xquery from converting... (8)
-> + Another edi question. (6)
-> + Running xquery with a source c... (4)
-> + xml to edi segment count quest (3)
-> + Running xquery from the comman... (7)
-> + How to change the node name in... (5)
-> + How to loop through a set of e... (10)
-> + Can I pass a parameter/vaiable... (3)
-> + generating an XML file (3)
-> + generating log files of Xquery... (2)
-> + Stylus Studio crashes when edi... (3)
-> + Checking for Values in an Arra... (3)
-> + Adding embedded functions (11)
-> + multiple DTPs at the same leve... (2)
-> + java.lang.OutOfMemoryError: Ja... (3)
-> + xml validation against wsdl (2)
-> + Using same Xquery (4)
-> + Changing name value pairs to t... (4)
-> + removing unwanted attributes r... (4)
-> + Repeated Crashing of System (2)
-> + Create multiple XML Files (5)
-> + Best xQuery engine? (2)
-> + Xquery outputs XML attributes ... (4)
-> + DataDirect SequeLink as a DB-t... (2)
-> + Using same xquery for 2 xml fi... (5)
-> + Performance of XQuery (2)
-> + fail to use Saxon Process for ... (4)
-> + Conditional statements in xque... (2)
-> + Option Declaration Using Saxon (2)
-> + Multiple option declarations (2)
-> + Importing modules with a Custo... (3)
-> + Possible bug: Problem with aut... (5)
-> + getting the value of an attrib... (4)
-> + Memory problems using xQuery (6)
-> + Adding a namespace (6)
-> + [DataDirect][XQuery][err:FODC0... (9)
-> + Mapping Trouble (4)
-> + Two level grouping (5)
-> + Error: A parameter of the oper... (3)
-> + Grouping in xQurey (Nested For... (7)
-> + err:XPST0005 - Error at line 9... (4)
-> + Error at line 1, column 126. U... (6)
-> + Strange output (2)
-> - word count for each category (1)
-> + Need help with this xquery (2)
-> + XML DOM (3)
-> + License issues related to XQue... (3)
-> + XQuery, ddtek:wscall, and an e... (9)
-> + How to give sub equation nos (3)
-> + XML DOM (3)
-> + forcing empty elements to have... (4)
-> + SQL Server 2005 XQuery help (4)
-> + Type error (5)
-> + MarkLogic queries (2)
-> + relative uri (3)
-> + Recursive Template Funcion Fro... (2)
-> - Create RDF for xml (1)
-> + Schema validation errors (2)
-> + KEYWORD EXTRACTION FROM XML DO... (6)
-> + Newbie struggling with nested ... (4)
-> + Path evaluation bug (?) concer... (2)
-> + XPath query (3)
-> + make sequence (4)
-> + XPath Query Editor Schema-Awar... (3)
-> + Newbe To This Form of programm... (2)
-> + Connection to remote database (2)
-> + Addnamespace using xquery (4)
-> + FATAL ERROR: Invalid document ... (3)
-> + FLOWR Loop Counter (5)
-> + Stylus Studio XML generation f... (2)
-> + Potential bugs? (2)
-> + hierarchical XML into tables (2)
-> + Incremental line counts (4)
-> + preceding-sibling syntax help ... (2)
-> + Creating hierarchical identifi... (5)
-> + Convert decimal to Hex. (3)
-> + XQuery automated comparison of... (3)
-> + validating schemas (2)
-> + very simple fn:string() proble... (5)
-> + Need help with a XSL file (2)
-> + Problems with conversion from ... (3)
-> + MS Sql Server (2)
-> + XQuery equivalent of xsl:resul... (2)
-> + tokenizing a string - problem ... (3)
-> + XQuery and eXist error process... (2)
-> + Deploying an xquery file with ... (2)
-> + Newbie struggling with simple ... (4)
-> + summing up the figure in the n... (8)
-> + Variable as part of a tag? (2)
-> + xquery element tag name (2)
-> + xquery - question for count fu... (3)
-> + get multiple values from multi... (4)
-> + Is it possible to add new data... (7)
-> + Can't connect to DB - MS SQL S... (16)
-> + sequence distinct values (4)
-> + XSQL QUERY (2)
-> + External xquery functions (2)
-> + Error in Xquery V3.0 (7)
-> + Problem getting distinct value... (2)
-> + XQuery reference book recommen... (2)
-> + it's possible to have a where ... (2)
-> + XSLT sorting parent nodes by m... (2)
-> + Catalyst EDI Mapping (2)
-> + h2 element is there but XQuery... (2)
-> + Adding the XML header to an ou... (2)
-> + Newbie question regarding dyna... (2)
-> + Group parent elements in targe... (5)
-> + Need XPath to return just imme... (4)
-> + XQUERY Java run-time error (4)
-> + dbxml and collection() (2)
-> + Nothing returned when namespac... (3)
-> + XQERY and Stylus Studio suppor... (3)
-> + x12 837 convert to xml fail wi... (3)
-> + Choose more than one attribute (2)
-> + XQuery Engine (4)
-> + finding nodes in source docume... (2)
-> + unable to create any xquery (3)
-> + counter in xquery (5)
-> + How to change JVM settings -Xm... (4)
-> + Postgresql (3)
-> + Can I call an xquery file from... (5)
-> + How to output a text with a mi... (3)
-> + Mapping - How Include the Sche... (6)
-> + XQuery beginner problem (2)
-> + No output from StylusFile Conv... (3)
-> + getting all nodes leading up t... (3)
-> + Java exception when apply regu... (5)
-> + X12 resources not reachable (T... (13)
-> + XQuery error on Oracle views (5)
-> + Results multiplied by number o... (3)
-> - Continous sequence check (1)
-> + No results for second row of s... (14)
-> + Problems connecting to DB2/400... (6)
-> + External Class : Invalid linki... (8)
-> + Error during SQL execution: [O... (2)
-> + Warnings when running Schema a... (2)
-> + XQuery basics (2)
-> + XPath Query Editor - not visib... (3)
-> + Document loading and unloading (3)
-> + Xpath to return xmlns (3)
-> + How to execute xQuery and exec... (3)
-> + Schema Aware Saxon (5)
-> + Want to execute a XQuery by AP... (7)
-> + Use a user-defined adapter as ... (2)
-> + RDB collections versus DB-to-X... (5)
-> + XMLTABLE WITH COLUMN OF ALL NO... (5)
-> + Xquery question (4)
-> - XQuery 1.0 is now a Proposed R... (1)
-> + I can't seem to get my xml "re... (7)
-> + Custom pipeline elements (4)
-> + FIND ALL ELEMENTS WITH SAME NA... (3)
-> - CONCATENATE COMPLEX TYPE ELEME... (1)
-> + XQuery & MySQL (4)
-> - Referring elements from an imp... (1)
-> + Selecting operator from XML to... (5)
-> + copy-namespaces mode (5)
-> + XQuery and Javascript 1.5+ on ... (2)
-> + XQuery sort & extract data (4)
-> + [DataDirect][XQuery]No value h... (9)
-> + About typing system for XQuery... (5)
-> + root() vs // - saxon and built... (3)
-> + XQuery or XPath "between" func... (4)
-> + Xpath Query Editor button grey... (3)
-> + Processing Instructions, Built... (4)
-> + XPath parser in Java (3)
-> + XQuery "declare xmlspace prese... (10)
-> + Save results of XQuery as CSV? (7)
-> + Cleanup and combine question (3)
-> + xquery function from within xs... (4)
-> + Saxon XQuery error (4)
-> + xquery and 1gb xml files (3)
-> + How can i output key words suc... (5)
-> + Viewing XQuery (4)
-> - Webinar: Using XQuery and Data... (1)
-> + Java code generated by Xquery ... (6)
-> + Multiple items in return (2)
-> + Confused using match (2)
-> + Counting distinct node types (7)
-> + XQUERY Newbie question (3)
-> + Receiving a function as a para... (7)
-> + Xpath Version - and Doc for Re... (2)
-> + Convert namespace? (2)
-> + Can I search for one line and ... (3)
-> + Reading Data from Soap Respons... (2)
-> + Access To XML Query Question (4)
-> + Xquery find avg and count (3)
-> + Bug using global variables in ... (3)
-> - Problem uploading XSLT to xml ... (1)
-> + Bug? HTMLTidy does not support... (2)
-> + Finding a string within an XML... (4)
-> + Store query result in java.lan... (2)
-> + Comparing databases and XML. (3)
-> + namespace information with XQu... (4)
-> + Single row to multiple row tra... (3)
-> + Webservice call failed (2)
-> + Stylus Studio has encountered ... (2)
-> + My XQUERY on Berkley DBXML s... (2)
-> + Filtering multiple values from... (5)
-> + SaxonB8.4 testing (8)
-> + Problem with oracle large tabl... (3)
-> + incorrect syntax? (3)
-> + XQUERY-based app usage (4)
-> + position() and last() in XQuer... (3)
-> + Returning Values (5)
-> + new to XQuery- "expected cardi... (2)
-> + using XQuery to keep all data ... (2)
-> + search in XQuery (6)
-> + Defined source and destination... (2)
-> + Stopping running xquery in R2 (4)
-> + XQuery where can i use it? (5)
-> + Scheduling the conversion (2)
-> + Converting Oracle table to XML... (5)
-> - Formating and Indentation Pres... (1)
-> + Omiting the XML declaration fr... (4)
-> + Define function (4)
-> + External Java class problems (15)
-> + C++/COM API for XQuery (3)
-> + PROBLEM AT THE DECLARATION OF ... (3)
-> - Cobol Flat file to XML (1)
-> + xpath question (2)
-> + XQST0059 cannot locate the req... (6)
-> + How to generate XML with proce... (2)
-> + ODBC Connection refused (12)
-> + node search and replace (3)
-> + generate xml file on web serve... (5)
-> + How to navigate to a ref node (5)
-> + How to query when a default na... (2)
-> + full xpath to a node (3)
-> + Performance bench (2)
-> + how to run xquery using java (2)
-> + [ convert dtd to xsd ] (3)
-> + How to map a recursive node? (9)
-> + java class implementing extern... (3)
-> + context to context reference (2)
-> + Problems with Replace (7)
-> + Use of special characters in X... (5)
-> + How to write XML Parser IN VC+... (2)
-> + Xquery (5)
-> + Trivial XQUERY application que... (2)
-> + XML as a data model (2)
-> + XQuery (2)
-> + Relative path (2)
-> + Support for xml is-idref (4)
-> + Accessing the document context... (3)
-> + Getting recursion return type ... (4)
-> + Parsing XMLFormatted as String... (5)
-> + XQuery Replace (2)
-> - How to join the two table usin... (1)
-> + Update variable value inside b... (5)
-> + Run XQuery on XMLDB databases (2)
-> + Treatment of reserved characte... (6)
-> + XQuery Core (6)
-> + Built-In Saxon 8.4 processor (3)
-> + dynamic order by clause (3)
-> + Dynamical xpath (3)
-> + How to use xquery? :) (2)
-> + Converting SQL query to XQuery (4)
-> - New XQuery Primer: Learn XQuer... (1)
-> - XQuery Co-Author and XML Indus... (1)
-> + sequence to collect (3)
-> + user defined functions in xque... (2)
-> + Need second set of eyes to deb... (2)
-> - Xquery calling Java function f... (1)
-> + Xquery on existing XML files i... (2)
-> + Need Help Resorting (11)
-> + "for" clause question (2)
-> + New XQuery Video: Using DataDi... (2)
-> + data() function not returning... (2)
-> + XSL-FO using RenderX's XEP on ... (4)
-> + Xquery to find sample data fil... (4)
-> + Xquery to find sample data fil... (4)
-> + Error with Berkeley XML DB and... (13)
-> + Berkeley XML DB & Professional... (3)
-> + question (2)
-> + Writing UDDI API's in XQuery (2)
-> - DataDirect XQuery Enables XQue... (1)
-> + Xquery to MS/SQL? (8)
-> + Left Outer Join in XQuery (2)
-> - New XQJ Tutorial and Example F... (1)
-> + asked (2)
-> - generate XML file from tables ... (1)
-> - XQuery interest growing: DevX (1)
-> + New to XQuery question (2)
-> - Help Support XQuery in the Mic... (1)
-> + Xquery and Web Service Caller (4)
-> + XQuery from JavaScript? (4)
-> + Find Maximum Numeric Value in ... (2)
-> + Can you use XQuery and SQL/XML... (2)
-> + XQuery and Relational Data map... (2)
-> + STyluus and C# (MS) (2)
-> - XQuery making headlines (again... (1)
-> + XQuery Syntax (2)
-> - XQuery in Outer Space (1)
-> + import several modules in a xq... (2)
-> - Developers Flock to XQuery Spe... (1)
-> + UPDATE (2)
-> + global variable (4)
-> + XQuery on all XML Files in a D... (12)
-> + Stylus Studio Interoperability... (5)
-> - Genereating values in a combob... (1)
-> - SQL Server 2005 "Yukon" (1)
-> - XQuery Drivers (1)
-> - Database Trends and Applicatio... (1)
-> - Why XQuery? How new XML Standa... (1)
-> - Develop, Edit and Debug XQuery... (1)
-> + Native XML Database Tools (3)
-> - XQuery in Bank Systems and Tec... (1)
-> + User functions (5)
-> + Setting Values for External Va... (4)
-> - XQuery 2005 Road Show (1)
-> - XQuery Introduction (1)
-> - New XQuery Developer Awards Pr... (1)
-> + Convert String to xml document... (2)
-> + import de modules (7)
-> + String to XML conversion in a ... (2)
-> + DML language (2)
-> + Newbie Xquery problem to solve (7)
-> - What is XQuery? (1)
-> - XQuery Talk: Priscilla Walmsle... (1)
-> + Learn XQJ : The XQuery API for... (3)
-> + XQuery to consolidate modular ... (6)
-> + problem with xquery (4)
-> + use cases (5)
-> - XQuery and XQJ Talk with Jason... (1)
-> + append the output of the xquer... (3)
-> + Problem with command line argu... (4)
-> - Can you associate hundreds of ... (1)
-> + PARAMETER VALUES IN STYLUS STU... (2)
-> + Problem with stylusxql calls (5)
-> - Join us for Eggs & XML at the ... (1)
-> + More about Java extensions and... (2)
-> + Stylus Studio Crashes with Jav... (6)
-> - An Interview with Jason Hunter... (1)
-> + attribute order in query resul... (3)
-> - Interview with XQuery Guru Dr.... (1)
-> + SequenceType matching failed" ... (2)
-> + XQuery tutorial (3)
-> - W3C Releases Public Working Dr... (1)
-> + Problem with a function (3)
-> + Problem with Stylus Studio 5.3 (5)
-> + Studio Studio crashes (7)
-> + STYLUSXQL (8)
-> + Execute a Query From the Comma... (2)
-> + Import Modules. (8)
-> + User-Defined Functions (3)
-> + new to Xquery (3)
-> + XQuery engines (4)
-> + APIs or OCXs (2)
-- [1-20] [21-40] [41-60] Next
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Wilhelm BeckSubject: Best Way To Generate Complex XML Doc From Spreadsheet - Help!
Author: Wilhelm Beck
Date: 20 Jul 2012 07:05 PM
Originally Posted: 20 Jul 2012 06:44 PM
Best Way To Generate Complex XML Doc From Spreadsheet - Help!

Hello! So, first off I'm not really a "real" programmer. I handle a lot of tech stuff at the company I'm with though, and I'm pretty good at dabbling. I usually figure out how to do what I need to do when I need to do it, and I rarely can't figure things out! I know plenty of HTML, how to work with CSS style sheets, all kinds of fancy Excel formulas, XML etc.

Sooo, the thing is, I now kind of need to figure out something new, and it's a little more in depth than other things I've tried to do in the past and I'm not sure the best way to go about it.

So here's the score. I work for a record label, and we provide metadata for album releases to numerous sites in XML. We've been doing this for years, and the way most XML files display in Grid mode in Stylus has made it so easy to just copy and paste from Excel I've never seen the need to figure out a "proper" or more automated system. In the long haul I probably should have because it would have saved time in the long run, but we really custom tailor our XML to each sites system to optimize it, which requires a human touch anyway.

Enter a new site we're delivering directly to. Their XML is very complicated and lethargic. There's a lot of duplicated data in different tags that shouldn't really exist, but are required. It's to the point of ridiculousness really. It'd be waaay too much work to manually enter things, even with find/replace.

So I started looking for a solution to automate it. I have kind of found a way. Basically I used Stylus to convert a CSV for an album to XML that looks like this

<root>
<fieldnames>
<UPC>UPC</UPC>
<catalog>Catalog Number</catalog>
<tracknumber>Track Number</tracknumber>
<release>Release Date</release>
<albumtitle>Title</albumtitle>
<artist>Artist</artist>
<tracktitle>Track Title</tracktitle>
<isrc>ISRC USM2U</isrc>
<description>Description</description>
<time1>Track Times</time1>
<field>Source Master</field>
<field>Notes</field>
<field>Song Writers</field>
</fieldnames>
<Row>
<UPC>XXXXXXXXX</UPC>
<catalog> CD119</catalog>
<tracknumber>01</tracknumber>
<release>4/10/2003</release>
<albumtitle>XXXXXXXXXX</albumtitle>
<artist>YYYYYYYYYYYYY</artist>
<tracktitle>ZZZZZZZZZZZZ</tracktitle>
<isrc>XXXXXXXXXX</isrc>
<time1>2:49</time1>
<time2>0:02:49</time2>
<time3>169</time3>
<field>169000</field>
</Row>

Then that repeats for all tracks

Then I found Xquery code

{
let $doc := .
for $v in $doc//root/Row,
$a in $doc//root/Row/tracknumber/text()
where matches($a, '01')
and $v/tracknumber/text() = $a
return $v/UPC/text()
}

Which can pull data from whatever field based off of the track number. This would allow it to pull the track name, track time, etc on a per track basis. So in essence I could setup

<File>
<FileName>{
let $doc := .
for $v in $doc//root/Row,
$a in $doc//root/Row/tracknumber/text()
where matches($a, '2')
and $v/tracknumber/text() = $a
return $v/UPC/text()
}_01_01_FLAC.flac</FileName>
<FilePath>resources</FilePath>
<HashSum>
<HashSum>CHECKSUM SONG 01</HashSum>
<HashSumAlgorithmType>MD5</HashSumAlgorithmType>
</HashSum>
</File>

Etc for each field that would pull the appropriate data in a query that features the actual XML in there as well, so the end result of a full query would be a valid XML document.

The downside is that I have to have a manual set of XML code like the above in each spot where I need to fill something. If I created a query with say 30 tracks it would be enough to always auto fill all our albums... Except it would also leave a bunch of XML with empty fields if there were less than 30 tracks.

So I'm wondering 2 things. Should I even use Xquery. It really seems like a ghetto hack way of going about this, especially because of having to manually create a CSV and import that album by album. If not, what should I use? We have Access, and MS SQL floating around. It seems like if I could get similar functionality as far as kicking out text out of either of those that alone would advance the cause considerably since they natively handle Excel files. Especially if I could make it automatically recognize when the UPC field changed in a single big long Excel spreadsheet but kick out separate text (XML) documents.

As far as if Xquery is a valid way of going about this, can I embed the actual XML code portion in an "if then" sort of situation where it would NOT create data in the final query result if the track number didn't exist in the source XML created from the CSV? Or is there no way to include straight XML inside of code like that?

If that is possible, I think even the ghetto Xquery way would be workable, otherwise there will be a lot of manual deletion in this big complex XML document that will have to be deleted out. That would still be easier than doing it completely manually, but certainly not optimal.

As far as Access or SQL... I've never done anything much in there, but have worked with people who have done all kinds of awesome stuff with them. I know that SQL especially can create all of kinds of text being populated from spreadsheets.

It seems to me like there must be some kind of way to make one of them generate the XML tag I need, then pull from a particular field in a spreadsheet that's in the system, and only do it until the data ends or it reaches a new UPC in the spreadsheet. Perhaps create a separate table with all the XML start tags and end tags, so it's actually pulling everything from certain fields in spreadsheets to create the final product?

I know this is a bit long winded, so sorry for that. I should have been a Russian novelist ;) And I'm sure this is pretty novice stuff, but I've found programmers are usually quite willing to help in the past. Since this must be pretty simple, I'm hoping I can figure this out and permanently expand my bag of tricks! All I really need is a way to auto pull fields based on perhaps a UPC/track number combo, and have it end when data stops. I could even set this up for all the other sites we deliver to and streamline things even more!

Any thoughts or suggestions are welcome, and thank all of you in advance for your help!!!
Postnext
Ivan PedruzziSubject: Best Way To Generate Complex XML Doc From Spreadsheet - Help!
Author: Ivan Pedruzzi
Date: 20 Jul 2012 08:19 PM

Let's try keep things as simple as possible.

If everything required by the target schema is available in the input data, no human intervention should be required.

In which format you keep the data for the albums: CSV, Excel, a database?

Our XQuery processor can access all the above without additional steps.

Can you share a sample of the list of albums and target XML Schema?

If you don't want to post on the public forum send it to
stylussupport@ivitechnologies.com

Hope this helps
Ivan Pedruzzi
Stylus Studio Team
Posttop
Wilhelm BeckSubject: Best Way To Generate Complex XML Doc From Spreadsheet - Help!
Author: Wilhelm Beck
Date: 20 Jul 2012 09:35 PM
Originally Posted: 20 Jul 2012 09:33 PM
Hi Ivan!

Thanks for responding! We keep our data in a simple Excel file, and convert it to other formats as needed. Someday a big fancy database system would be good, but for now it works!

It's columns are the fields (UPC, Artist, Album Name Etc), with the rows being the same data repeated where it's the same (UPC, Artist etc) and the track numbers, times, and so on different on every succeeding row. Example below, with some fields omitted.

UPC Catalog Number Track Number Release Date Title
UPC 01 CD100 01 4/10/2003 Song Title 1
UPC 01 CD100 02 4/10/2003 Song Title 2
UPC 02 CD101 01 5/10/2003 Song Title 1
UPC 02 CD101 02 5/10/2003 Song Title 2

An example of how I converted the spreadsheet into XML is below. If there's a better way, or it is unnecessary that would be amazing! Being able to pull straight from Excel, or even a CSV, into Xquery would be great.

<?xml version="1.0" encoding="utf-8"?>
<root>
<fieldnames>
<UPC>UPC</UPC>
<catalog>Catalog Number</catalog>
<tracknumber>Track Number</tracknumber>
<release>Release Date</release>
<albumtitle>Title</albumtitle>
<artist>Artist</artist>
<tracktitle>Track Title</tracktitle>
<isrc>ISRC USM2U</isrc>
<description>Description</description>
<time1>Track Times</time1>
<field>Source Master</field>
<field>Notes</field>
<field>Song Writers</field>
</fieldnames>
<Row>
<UPC>A UPC NUMBER</UPC>
<catalog>CD119</catalog>
<tracknumber>01</tracknumber>
<release>4/10/2003</release>
<albumtitle>An Album Title</albumtitle>
<artist>An Artist Name</artist>
<tracktitle>Track 01</tracktitle>
<isrc>THE ISRC</isrc>
<time1>2:49</time1>
<time2>0:02:49</time2>
<time3>169</time3>
<field>169000</field>
</Row>
<Row>
<UPC>A UPC NUMBER</UPC>
<catalog>CD119</catalog>
<tracknumber>02</tracknumber>
<release>4/10/2003</release>
<albumtitle>An Album Title</albumtitle>
<artist>An Artist Name</artist>
<tracktitle>Track 01</tracktitle>
<isrc>THE ISRC</isrc>
<time1>3:57</time1>
<time2>0:03:57</time2>
<time3>237</time3>
<field>237000</field>
</Row>
</root>

Then I will post a full sample of the schema it needs to go into

<?xml version="1.0" encoding="UTF-8"?>
<ern:NewReleaseMessage MessageSchemaVersionId="2010/ern-main/32" LanguageAndScriptCode="en" xs:schemaLocation="http://ddex.net/xml/2010/ern-main/32 http://ddex.net/xml/2010/ern-main/32/ern-main.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema-instance" xmlns:ern="http://ddex.net/xml/2010/ern-main/32">
<MessageHeader>
<MessageThreadId>20120707113545146</MessageThreadId>
<MessageId>THIS IS THE UPC1</MessageId>
<MessageSender>
<PartyId>PADPIDA2012070305K</PartyId>
<PartyName>
<FullName>DON'T NEED THIS!</FullName>
</PartyName>
</MessageSender>
<MessageRecipient>
<PartyId>PADPIDA2010120902Y</PartyId>
<PartyName>
<FullName>DON'T NEED THIS!</FullName>
</PartyName>
</MessageRecipient>
<MessageCreatedDateTime>2012-07-07T11:35:45</MessageCreatedDateTime>
<MessageControlType>LiveMessage</MessageControlType>
</MessageHeader>
<UpdateIndicator xmlns="">OriginalMessage</UpdateIndicator>
<ResourceList>
<SoundRecording>
<SoundRecordingType>MusicalWorkSoundRecording</SoundRecordingType>
<SoundRecordingId>
<ISRC>ISRC01</ISRC>
</SoundRecordingId>
<ResourceReference>A1</ResourceReference>
<ReferenceTitle>
<TitleText>SONG TITLE 01</TitleText>
</ReferenceTitle>
<Duration>PT0H3M16S</Duration>
<CreationDate>2012-07-07</CreationDate>
<SoundRecordingDetailsByTerritory>
<TerritoryCode>Worldwide</TerritoryCode>
<Title TitleType="DisplayTitle">
<TitleText>SONG TITLE 01</TitleText>
</Title>
<DisplayArtist>
<PartyName>
<FullName>MAIN ARTIST 01</FullName>
</PartyName>
</DisplayArtist>
<LabelName>Label Name Records</LabelName>
<OriginalResourceReleaseDate>2012-07-07</OriginalResourceReleaseDate>
<PLine>
<Year>2012</Year>
<PLineText>2012 Label Name Records</PLineText>
</PLine>
<Genre>
<GenreText>Jazz</GenreText>
<SubGenre>Avant Garde Jazz</SubGenre>
</Genre>
<ParentalWarningType>NotExplicit</ParentalWarningType>
<TechnicalSoundRecordingDetails>
<TechnicalResourceDetailsReference>T1</TechnicalResourceDetailsReference>
<AudioCodecType UserDefinedValue="FLAC">UserDefined</AudioCodecType>

<NumberOfChannels>2</NumberOfChannels>
<SamplingRate UnitOfMeasure="kHz">44100</SamplingRate>
<BitsPerSample>16</BitsPerSample>
<IsPreview>false</IsPreview>
<File>
<FileName>THIS IS THE UPC_01_01_FLAC.flac</FileName>
<FilePath>resources</FilePath>
<HashSum>
<HashSum>CHECKSUM SONG 01</HashSum>
<HashSumAlgorithmType>MD5</HashSumAlgorithmType>
</HashSum>
</File>
</TechnicalSoundRecordingDetails>
</SoundRecordingDetailsByTerritory>
</SoundRecording>
<SoundRecording>
<SoundRecordingType>MusicalWorkSoundRecording</SoundRecordingType>
<SoundRecordingId>
<ISRC>ISRC02</ISRC>
</SoundRecordingId>
<ResourceReference>A2</ResourceReference>
<ReferenceTitle>
<TitleText>SONG TITLE 02</TitleText>
</ReferenceTitle>
<Duration>PT0H2M48S</Duration>
<CreationDate>2012-07-07</CreationDate>
<SoundRecordingDetailsByTerritory>
<TerritoryCode>Worldwide</TerritoryCode>
<Title TitleType="DisplayTitle">
<TitleText>SONG TITLE 02</TitleText>
</Title>
<DisplayArtist>
<PartyName>
<FullName>MAIN ARTIST 01</FullName>
</PartyName>
</DisplayArtist>
<LabelName>Label Name Records</LabelName>
<OriginalResourceReleaseDate>2012-07-07</OriginalResourceReleaseDate>
<PLine>
<Year>2012</Year>
<PLineText>2012 Label Name Records</PLineText>
</PLine>
<Genre>
<GenreText>Jazz</GenreText>
<SubGenre>Avant Garde Jazz</SubGenre>
</Genre>
<ParentalWarningType>NotExplicit</ParentalWarningType>
<TechnicalSoundRecordingDetails>
<TechnicalResourceDetailsReference>T2</TechnicalResourceDetailsReference>
<AudioCodecType UserDefinedValue="FLAC">UserDefined</AudioCodecType>

<SamplingRate UnitOfMeasure="kHz">44100</SamplingRate>
<BitsPerSample>16</BitsPerSample>
<IsPreview>false</IsPreview>
<File>
<FileName>THIS IS THE UPC_01_02_FLAC.flac</FileName>
<FilePath>resources</FilePath>
<HashSum>
<HashSum>CHECKSUM SONG 02</HashSum>
<HashSumAlgorithmType>MD5</HashSumAlgorithmType>
</HashSum>
</File>
</TechnicalSoundRecordingDetails>
</SoundRecordingDetailsByTerritory>
</SoundRecording>
<Image>
<ImageType>FrontCoverImage</ImageType>
<ImageId>
<ProprietaryId Namespace="DON'T NEED THIS!">THIS IS THE UPC.jpg</ProprietaryId>
</ImageId>
<ResourceReference>A101</ResourceReference>
<ImageDetailsByTerritory>
<TerritoryCode>Worldwide</TerritoryCode>
<TechnicalImageDetails>
<TechnicalResourceDetailsReference>T101</TechnicalResourceDetailsReference>
<ImageCodecType>JPEG</ImageCodecType>
<ImageHeight>1499</ImageHeight>
<ImageWidth>1484</ImageWidth>
<File>
<FileName>THIS IS THE UPC.jpg</FileName>
<FilePath>resources</FilePath>
<HashSum>
<HashSum>CHECKSUM ART 01</HashSum>
<HashSumAlgorithmType>MD5</HashSumAlgorithmType>
</HashSum>
</File>
</TechnicalImageDetails>
</ImageDetailsByTerritory>
</Image>
</ResourceList>
<ReleaseList>
<Release>
<ReleaseId>
<ICPN IsEan="false">THIS IS THE UPC</ICPN>
</ReleaseId>
<ReleaseReference>R0</ReleaseReference>
<ReferenceTitle>
<TitleText>The Jazz Age Volume 6</TitleText>
</ReferenceTitle>
<ReleaseResourceReferenceList>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A1</ReleaseResourceReference>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A2</ReleaseResourceReference>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A3</ReleaseResourceReference>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A4</ReleaseResourceReference>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A5</ReleaseResourceReference>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A6</ReleaseResourceReference>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A7</ReleaseResourceReference>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A8</ReleaseResourceReference>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A9</ReleaseResourceReference>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A10</ReleaseResourceReference>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A11</ReleaseResourceReference>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A12</ReleaseResourceReference>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A13</ReleaseResourceReference>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A14</ReleaseResourceReference>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A15</ReleaseResourceReference>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A16</ReleaseResourceReference>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A17</ReleaseResourceReference>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A18</ReleaseResourceReference>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A19</ReleaseResourceReference>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A20</ReleaseResourceReference>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A21</ReleaseResourceReference>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A22</ReleaseResourceReference>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A23</ReleaseResourceReference>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A24</ReleaseResourceReference>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A25</ReleaseResourceReference>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A26</ReleaseResourceReference>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A27</ReleaseResourceReference>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A28</ReleaseResourceReference>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A29</ReleaseResourceReference>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A30</ReleaseResourceReference>
<ReleaseResourceReference ReleaseResourceType="SecondaryResource">A101</ReleaseResourceReference>
</ReleaseResourceReferenceList>
<ReleaseType>Album</ReleaseType>
<ReleaseDetailsByTerritory>
<TerritoryCode>Worldwide</TerritoryCode>
<DisplayArtistName>MAIN ARTIST 01</DisplayArtistName>
<LabelName>Label Name Records</LabelName>
<Title TitleType="DisplayTitle">
<TitleText>The Jazz Age Volume 6</TitleText>
</Title>
<DisplayArtist>
<PartyName>
<FullName>MAIN ARTIST 01</FullName>
</PartyName>
<ArtistRole>MainArtist</ArtistRole>
</DisplayArtist>
<ParentalWarningType>NotExplicit</ParentalWarningType>
<ResourceGroup>
<ResourceGroup>
<SequenceNumber>1</SequenceNumber>
<ResourceGroupContentItem>
<SequenceNumber>1</SequenceNumber>
<ResourceType>SoundRecording</ResourceType>
<ReleaseResourceReference>A1</ReleaseResourceReference>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>2</SequenceNumber>
<ResourceType>SoundRecording</ResourceType>
<ReleaseResourceReference>A2</ReleaseResourceReference>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>3</SequenceNumber>
<ResourceType>SoundRecording</ResourceType>
<ReleaseResourceReference>A3</ReleaseResourceReference>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>4</SequenceNumber>
<ResourceType>SoundRecording</ResourceType>
<ReleaseResourceReference>A4</ReleaseResourceReference>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>5</SequenceNumber>
<ResourceType>SoundRecording</ResourceType>
<ReleaseResourceReference>A5</ReleaseResourceReference>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>6</SequenceNumber>
<ResourceType>SoundRecording</ResourceType>
<ReleaseResourceReference>A6</ReleaseResourceReference>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>7</SequenceNumber>
<ResourceType>SoundRecording</ResourceType>
<ReleaseResourceReference>A7</ReleaseResourceReference>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>8</SequenceNumber>
<ResourceType>SoundRecording</ResourceType>
<ReleaseResourceReference>A8</ReleaseResourceReference>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>9</SequenceNumber>
<ResourceType>SoundRecording</ResourceType>
<ReleaseResourceReference>A9</ReleaseResourceReference>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>10</SequenceNumber>
<ResourceType>SoundRecording</ResourceType>
<ReleaseResourceReference>A10</ReleaseResourceReference>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>11</SequenceNumber>
<ResourceType>SoundRecording</ResourceType>
<ReleaseResourceReference>A11</ReleaseResourceReference>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>12</SequenceNumber>
<ResourceType>SoundRecording</ResourceType>
<ReleaseResourceReference>A12</ReleaseResourceReference>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>13</SequenceNumber>
<ResourceType>SoundRecording</ResourceType>
<ReleaseResourceReference>A13</ReleaseResourceReference>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>14</SequenceNumber>
<ResourceType>SoundRecording</ResourceType>
<ReleaseResourceReference>A14</ReleaseResourceReference>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>15</SequenceNumber>
<ResourceType>SoundRecording</ResourceType>
<ReleaseResourceReference>A15</ReleaseResourceReference>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>16</SequenceNumber>
<ResourceType>SoundRecording</ResourceType>
<ReleaseResourceReference>A16</ReleaseResourceReference>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>17</SequenceNumber>
<ResourceType>SoundRecording</ResourceType>
<ReleaseResourceReference>A17</ReleaseResourceReference>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>18</SequenceNumber>
<ResourceType>SoundRecording</ResourceType>
<ReleaseResourceReference>A18</ReleaseResourceReference>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>19</SequenceNumber>
<ResourceType>SoundRecording</ResourceType>
<ReleaseResourceReference>A19</ReleaseResourceReference>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>20</SequenceNumber>
<ResourceType>SoundRecording</ResourceType>
<ReleaseResourceReference>A20</ReleaseResourceReference>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>21</SequenceNumber>
<ResourceType>SoundRecording</ResourceType>
<ReleaseResourceReference>A21</ReleaseResourceReference>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>22</SequenceNumber>
<ResourceType>SoundRecording</ResourceType>
<ReleaseResourceReference>A22</ReleaseResourceReference>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>23</SequenceNumber>
<ResourceType>SoundRecording</ResourceType>
<ReleaseResourceReference>A23</ReleaseResourceReference>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>24</SequenceNumber>
<ResourceType>SoundRecording</ResourceType>
<ReleaseResourceReference>A24</ReleaseResourceReference>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>25</SequenceNumber>
<ResourceType>SoundRecording</ResourceType>
<ReleaseResourceReference>A25</ReleaseResourceReference>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>26</SequenceNumber>
<ResourceType>SoundRecording</ResourceType>
<ReleaseResourceReference>A26</ReleaseResourceReference>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>27</SequenceNumber>
<ResourceType>SoundRecording</ResourceType>
<ReleaseResourceReference>A27</ReleaseResourceReference>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>28</SequenceNumber>
<ResourceType>SoundRecording</ResourceType>
<ReleaseResourceReference>A28</ReleaseResourceReference>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>29</SequenceNumber>
<ResourceType>SoundRecording</ResourceType>
<ReleaseResourceReference>A29</ReleaseResourceReference>
</ResourceGroupContentItem>
<ResourceGroupContentItem>
<SequenceNumber>30</SequenceNumber>
<ResourceType>SoundRecording</ResourceType>
<ReleaseResourceReference>A30</ReleaseResourceReference>
</ResourceGroupContentItem>
</ResourceGroup>
</ResourceGroup>
<Genre>
<GenreText>Jazz</GenreText>
<SubGenre>Avant Garde Jazz</SubGenre>
</Genre>
<OriginalReleaseDate>2012-07-07</OriginalReleaseDate>
<Keywords>KEYWORDS!!!</Keywords>
</ReleaseDetailsByTerritory>
<PLine>
<Year>2012</Year>
<PLineText>2012 Label Name Records</PLineText>
</PLine>
<CLine>
<Year>2012</Year>
<CLineText>2012 Label Name Records</CLineText>
</CLine>
</Release>
<Release>
<ReleaseId>
<ISRC>ISRC01</ISRC>
</ReleaseId>
<ReleaseReference>R1</ReleaseReference>
<ReferenceTitle>
<TitleText>SONG TITLE 01</TitleText>
</ReferenceTitle>
<ReleaseResourceReferenceList>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A1</ReleaseResourceReference>
</ReleaseResourceReferenceList>
<ReleaseType>TrackRelease</ReleaseType>
<ReleaseDetailsByTerritory>
<TerritoryCode>Worldwide</TerritoryCode>
<DisplayArtistName>MAIN ARTIST 01</DisplayArtistName>
<LabelName>Label Name Records</LabelName>
<Title TitleType="DisplayTitle">
<TitleText>SONG TITLE 01</TitleText>
</Title>
<DisplayArtist>
<PartyName>
<FullName>MAIN ARTIST 01</FullName>
</PartyName>
<ArtistRole>MainArtist</ArtistRole>
</DisplayArtist>
<ParentalWarningType>NotExplicit</ParentalWarningType>
<Genre>
<GenreText>Jazz</GenreText>
<SubGenre>Avant Garde Jazz</SubGenre>
</Genre>
<OriginalReleaseDate>2012-07-07</OriginalReleaseDate>
</ReleaseDetailsByTerritory>
<PLine>
<Year>2012</Year>
<PLineText>2012 Label Name Records</PLineText>
</PLine>
<CLine>
<Year>2012</Year>
<CLineText>2012 Label Name Records</CLineText>
</CLine>
</Release>
<Release>
<ReleaseId>
<ISRC>ISRC02</ISRC>
</ReleaseId>
<ReleaseReference>R2</ReleaseReference>
<ReferenceTitle>
<TitleText>SONG TITLE 02</TitleText>
</ReferenceTitle>
<ReleaseResourceReferenceList>
<ReleaseResourceReference ReleaseResourceType="PrimaryResource">A2</ReleaseResourceReference>
</ReleaseResourceReferenceList>
<ReleaseType>TrackRelease</ReleaseType>
<ReleaseDetailsByTerritory>
<TerritoryCode>Worldwide</TerritoryCode>
<DisplayArtistName>MAIN ARTIST 01</DisplayArtistName>
<LabelName>Label Name Records</LabelName>
<Title TitleType="DisplayTitle">
<TitleText>SONG TITLE 02</TitleText>
</Title>
<DisplayArtist>
<PartyName>
<FullName>MAIN ARTIST 01</FullName>
</PartyName>
<ArtistRole>MainArtist</ArtistRole>
</DisplayArtist>
<ParentalWarningType>NotExplicit</ParentalWarningType>
<Genre>
<GenreText>Avant Garde Jazz</GenreText>
<SubGenre>Avant Garde Jazz</SubGenre>
</Genre>
<OriginalReleaseDate>2012-07-07</OriginalReleaseDate>
</ReleaseDetailsByTerritory>

<PLine>
<Year>2012</Year>
<PLineText>2012 Label Name Records</PLineText>
</PLine>
<CLine>
<Year>2012</Year>
<CLineText>2012 Label Name Records</CLineText>
</CLine>
</Release>

</ReleaseList>
<DealList>
<ReleaseDeal>
<DealReleaseReference>R1</DealReleaseReference>
<Deal>
<DealTerms>
<CommercialModelType>AsPerContract</CommercialModelType>
<Usage>
<UseType UserDefinedValue="DSP NameMusicBasic">UserDefined</UseType>
</Usage>
<TerritoryCode>US</TerritoryCode>
<PriceInformation>
<PriceRangeType Namespace="DSP Name">.7</PriceRangeType>
</PriceInformation>
<ValidityPeriod>
<StartDate>2012-07-07</StartDate>
</ValidityPeriod>
<PreOrderReleaseDate>2012-07-07</PreOrderReleaseDate>
</DealTerms>
</Deal>
<EffectiveDate>2012-07-07</EffectiveDate>
</ReleaseDeal>
<ReleaseDeal>
<DealReleaseReference>R1</DealReleaseReference>
<Deal>
<DealTerms>
<CommercialModelType>AsPerContract</CommercialModelType>
<Usage>
<UseType UserDefinedValue="DSP NameMusicBasic">UserDefined</UseType>
</Usage>
<TerritoryCode>US</TerritoryCode>
<PriceInformation>
<PriceRangeType Namespace="DSP Name">.7</PriceRangeType>
</PriceInformation>
<ValidityPeriod>
<StartDate>2012-07-07</StartDate>
</ValidityPeriod>
<PreOrderReleaseDate>2012-07-07</PreOrderReleaseDate>
</DealTerms>
</Deal>
<EffectiveDate>2012-07-07</EffectiveDate>
</ReleaseDeal>
<ReleaseDeal>
<DealReleaseReference>R2</DealReleaseReference>
<Deal>
<DealTerms>
<CommercialModelType>AsPerContract</CommercialModelType>
<Usage>
<UseType UserDefinedValue="DSP NameMusicBasic">UserDefined</UseType>
</Usage>
<TerritoryCode>US</TerritoryCode>
<ValidityPeriod>
<StartDate>2012-07-07</StartDate>
</ValidityPeriod>
<PreOrderReleaseDate>2012-07-07</PreOrderReleaseDate>
</DealTerms>
</Deal>
<EffectiveDate>2012-07-07</EffectiveDate>
</ReleaseDeal>
</DealList>
</ern:NewReleaseMessage>

I told you it was long, repetitive and lethargic! Many sites we've uploaded to would have had 1/10th the fluff to get the same end results, which is why with the DDEX (an org trying to standardize how music related metadata is delivered) compliant XML stuff it is no longer feasible to do manually.

That schema would fully encompass a 2 track album, it's audio files, and it's art and validate correctly. Obviously I have "generic" values in all the fields. But it's all pretty straight forward. Our UPC needs to go where the schema needs a UPC, our track title where it requests that etc.

That little query code I posted in the first post will pull the correct data from my XML version version of our album data, however I can't seem to make it have the schema's XML tags inside of the Xquery code, where I might be able to make it's existence conditional based on finding a valid track number (which seems to be the best way to differentiate I've been able to come up with). There's probably some easy way to do this, but until a week ago I'd never even looked at Xquery code! So I think I'm doing OKAY :)

I don't need the whole thing written for me, I think if I can get one example of the code that could do the above, I could adapt it to all the other fields just fine.

So, as I said, any suggestions on how I could improve this process is certainly very welcome!!!

>
>Let's try keep things as
>simple as possible.
>
>If everything required by the
>target schema is available in
>the input data, no human
>intervention should be
>required.
>
>In which format you keep the
>data for the albums: CSV,
>Excel, a database?
>
>Our XQuery processor can
>access all the above without
>additional steps.
>
>Can you share a sample of the
>list of albums and target XML
>Schema?
>
>If you don't want to post on
>the public forum send it to
>stylussupport@ivitechnologies.
>com
>
>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.