XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + Grouping (2)
-> + Best Practice for Pipeline err... (2)
-> + pdf generation (4)
-> + Problems excuting a Pipeline w... (2)
-> + XML serializer (3)
-> + Supported EDIFACT versions (5)
-> - Anyone know XActimate ESX file... (1)
-> + Stylus Studio with OpenJDK (2)
-> - Encoding error when importing ... (1)
-> - SEO Service in Delhi, India (1)
-> - HP Printer Support (1)
-> + Stylus Studio X16 Professional... (5)
-> + Stylus Studio X16 Enterprise -... (4)
-> - Overly complicated formatting ... (1)
-> + java apparently running, canno... (2)
-> + Stylus on Citrix - unable to v... (6)
-> + XSLT and XPath Questions (New ... (13)
-> + EDIFACT D96A CONTRL XML schema (2)
-> + JDK dropdown box empty and Jav... (2)
-> + Replacing XSD files in Report (4)
-> + Cannot locate WYSIWIG tab on X... (3)
-> + EDI X12 xml schema with segmen... (2)
-> + Error Message (4)
-> + jvm disabled message keeps pop... (2)
-> + XTSE0620: An xsl:param element... (3)
-> + Fail in installing “Apache FOP... (5)
-> - Jenkins: about the path of bui... (1)
-> + problem with Stylus X15 XML RE... (2)
-> + Cannot remove a row into a tab... (6)
-> + prevent the meta data from bei... (3)
-> + Unable to auto detect JRE in X... (2)
-> - Unable to auto detect JRE in X... (1)
-> - where to find information (1)
-> + X16 - XPath 3.0, XQuery 3.0, X... (2)
-> - Test (1)
-> + XSLT debugger shows [symbol u... (3)
-> - How do i use *.conv to process... (1)
-> - How do i use *.conv to process... (1)
-> + Not able to configure JVM in ... (5)
-> + Converting Cobol flat file to ... (2)
-> + Problem with uninstall - Windo... (2)
-> + Function current() is not reco... (6)
-> + API or web version (2)
-> + How to use Saxon for X16 on WI... (9)
-> + Error in SS X14 syntax highlig... (2)
-> + Option not available (2)
-> + XML Diff functionality and sor... (3)
-> + Convert Oagis XML file to TXT (4)
-> + DataDirect xqresultsequence is... (2)
-> - xfile Legacy file format suppo... (1)
-> + TPFDF (3)
-> + Help needed with SLSRPT - EDIF... (2)
-> - keeps crashing after I try and... (1)
-> + Can SS do this? (14)
-> - CargoImp support (1)
-> + No Preview Displayed - File is... (3)
-> - Stylus Studio X16 build 1974l ... (1)
-> + Help! Help!Help! Regading form... (2)
-> + FileNotFoundException generati... (6)
-> + FO External Graphic Producing ... (2)
-> + Use of Java methodes (4)
-> + get generated XQuery output on... (2)
-> - right construct for involving ... (1)
-> + SS JRE Version has "Stylus Stu... (3)
-> + Trying to validate an XSD: co... (3)
-> + Disable "Output" windows (4)
-> + Stylus Studio V16 X64 update d... (2)
-> + Could not load the Java Virtua... (2)
-> + .NET XslCompileTransform strip... (6)
-> + XML Report Preview and Save Ev... (8)
-> + X16 Enterprise 32bit crash on ... (5)
-> - MSXML6.0 SAX Parser, "Index re... (1)
-> + MSXML6.0 DOM Parser stops afte... (4)
-> + How to disable checking for up... (2)
-> + XML Publisher requires duplica... (4)
-> + Modifying Field Name in XML (4)
-> + Java Runtime Environmnet Libra... (2)
-> + Passing Parameters and Multipl... (4)
-> + Total Newbie Question... where... (3)
-> + XML Pipeline (2)
-> + Encoding problem in text previ... (5)
-> + New Installation on windows 20... (4)
-> - Exception while calling Java m... (1)
-> + Jars to be included for callin... (2)
-> + SXXP0003: Error reported by XM... (2)
-> + Validation error (5)
-> + Windows 10, latest Java, new t... (2)
-> + using help crashes stylus stud... (3)
-> + Web Service Call error (5)
-> + javax.xml.xquery.XQException: ... (2)
-> + Trang translator is not availa... (2)
-> + Replacement for flat2xml (2)
-> + CONV CSV Display Problem (3)
-> + StylusValidator.exe Command Li... (3)
-> + Cannot run Java built in valid... (2)
-> + Windows 10??? (3)
-> + Stylus Custom XML Conversion (... (8)
-> + X14 enterprise and saxon 9.4.0... (3)
-> + Open an XML document in the XM... (3)
-> + How to generate mapping report... (4)
-- [1-20] [21-40] [41-60] 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
Paulo AfonsoSubject: Create XML from XSD schema file, based on SQL Server 2012 data
Author: Paulo Afonso
Date: 13 Dec 2013 08:13 AM
Hi all

Our needs for a particular Add-on of our product. We want to communicate to our customer and supplier thru XSD Schema/XML:
a) Based on XSD schema XML file, connect to several columns on several tables and database, and produce a XML file.
b) First we try SSIS solutions but for each XSD we must develop a VB or C# solution, is not the impossible, but we are looking/searching for a tools that design XQuery for we import and execute that for each XSD schematic file, our costumer send to us.
c) We have a web site, design/development/testing with ASP.NET MVC C# on VS 2012, and SQL Server 2012
d) Our views are also using JQuery UI and JQuery tools also.

So we did the download and we like the UI and products, but we can't found an example to do what we wand, because of that we put this topic for any one send clue or path for cut time for my testing.

Paulo Afonso


DocumentNoname(66).

Postnext
Yitzhak KhabinskySubject: Create XML from XSD schema file, based on SQL Server 2012 data
Author: Yitzhak Khabinsky
Date: 13 Dec 2013 09:51 AM
Originally Posted: 13 Dec 2013 09:44 AM
Hello,

Your question is really about high level design to generate, validate and transmit data feeds in XML format.
Everything could be easily done by using combined power of both MS SQL Server SSIS 2012 and Stylus Studio.
I am doing it on daily basis.

Here it the outline of steps you need:
1. Run one generic SSIS Data flow task with the XML Destination.
It will produce one raw XML file on the file system.
2. For each customer/supplier run SSIS XSLT transformation Task in a loop.
XSLT is designed, developed and tested in Stylus Studio.
This step will produce desired data feeds in the XML format.
3. Run XSD validation SSIS task against the XSD contract.
XSD is designed, developed and tested in Stylus Studio.
4. Run SSIS FTP/SFTP task to transmit the XML data feed to the final destination.

This way you will have a reliable ETL engine/solution without developing a VB or C# based application or components.
All future changes will be done in XSLT and XSD layers which are text files in Stylus Studio.

Postnext
Ivan PedruzziSubject: Create XML from XSD schema file, based on SQL Server 2012 data
Author: Ivan Pedruzzi
Date: 13 Dec 2013 10:48 AM
Hi Paulo,

One option would be using the DataDirect XQuery engine which allows to query relational data and produce XML.

Have a look at the tutorial here
http://www.stylusstudio.com/videos/ddxqdemo/datadirectxquery.html

The documentation is located under the Stylus Studio folder
c:\Program Files (x86)\Stylus Studio X15 XML Enterprise Suite\Components\DataDirect XQuery\books\ddxquery\ddxqug\ddxqug.pdf

We can setup a conference call, at your convenience to discuss your requirements.


Ivan Pedruzzi
Stylus Studio Team
stylussupport@ivitechnolgoies.com

Posttop
Paulo AfonsoSubject: Create XML from XSD schema file, based on SQL Server 2012 data
Author: Paulo Afonso
Date: 18 Dec 2013 04:50 AM
Thanks I will procedure as you advice.

Paulo

   
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.