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 » Automation using Visual Studio
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + element type must not contain ... (3)
-> + XML to .txt file (7)
-> + Modifying a XSL-FO report (5)
-> + Retrievning multiple values...... (2)
-> + does Stylus Enterprise work wi... (2)
-> + MSSQL to 837P conversion (4)
-> + Generating XML files accesing ... (6)
-> + How to bold text using XSL (6)
-> + Different heading based on pag... (3)
-> + Code folding (2)
-> + Bad param=value pair on comman... (2)
-> + Saving an XML file (2)
-> + stylus adding random non print... (2)
-> + Displaying Base64Binary as Ima... (6)
-> - probleme de representation d'i... (1)
-> + SS 2008 error message not disp... (8)
-> + XQuery external variable conve... (4)
-> + encodings available (3)
-> + stand-alone application file n... (4)
-> + Windows Installer Dialog Box a... (4)
-> + Block search and replace (2)
-> + Problem with validation (3)
-> + ISA12 vs GS08 (5)
-> + Web Service Call failure... an... (11)
-> + Quotes in xpath query (3)
-> + Java Built-in processor no lon... (6)
-> + Dynamic input and output names (8)
-> + Java built-in parser (3)
-> + Contains an invalid path (2)
-> + Wizard XML Schema to XML (2)
-> + XML to EDI (14)
-> + Computer with original install... (2)
-> + using Custom Tool - passing ar... (3)
-> + Non-printable special characte... (3)
-> + Transfer Options (Settings, Pr... (2)
-> + Enterprise Edition, Rel. 3, Bu... (9)
-> + Need help with xsl file and xm... (2)
-> + Upgrading and retaining settin... (4)
-> + saxon9.dll etc. missing (2)
-> - Error on using XQuery File in ... (1)
-> - Strange Dialog Box (1)
-> + Studio Crashes in schema edito... (3)
-> + Xml to XMl Conversion (2)
-> + Unable to create a complex typ... (2)
-> + Error message wen trying run j... (2)
-> - XSLT Mapper question... (1)
-> + Dcument Wizard XSLT Editor Tab... (2)
-> + Beginner Question - XPath with... (2)
-> + Trying to generate .net code w... (2)
-> + duplicate values in variable w... (5)
-> + Java Runtime Environment libra... (4)
-> + programmatically generate XML ... (4)
-> + Help Loading Oracle BI Publish... (4)
-> + [French] xsl <=> report (3)
-> + XML Diff (3)
-> + StylusStudio 2008, saxon saxon... (6)
-> + Msql Table err:FODC0004 Table ... (2)
-> + The evaluation period for Data... (2)
-> + Mysql to XML (2)
-> + Is there a Collapse All nodes ... (2)
-> + flat file conversion with CDAT... (4)
-> + Struzzo.exe eats up %40 CPU ba... (2)
-> + schematron support? (11)
-> + XML Generator did not generate... (2)
-> + Nesting XML files (2)
-> + Web Service Call fails - targe... (5)
-> + getting not valid for content ... (2)
-> - element modem was referenced i... (1)
-> + xerces-c++ xml parser (2)
-> + movie.dtd (2)
-> + HELP! Stylus Studio 2008 Enter... (3)
-> + Xalan problem with xsl:attribu... (2)
-> + Breakpoints being ignored (12)
-> + Need a new key for Stylus Stud... (2)
-> + Global parameters are not reco... (4)
-> + mySQL DB Connection 2 (10)
-> + Using Data Direct xQuery to ag... (4)
-> + stylusXslt command line -- XSL... (15)
-> + XSLT processor using EXSLT fun... (2)
-> + Integrating Omni Mark (2)
-> + EDI Standards to gXML (2)
-> + flat file conversion (3)
-> + EDI to XML: Invalid URI error (3)
-> + Validating and XML Schema (6)
-> + XSD to DDL (MS-SQL/2005) (6)
-> + xml converter cant encode 0x19 (4)
-> + XSD Help Needed (2)
-> + How do you delete a field in a... (2)
-> + Disable page breaks (3)
-> + XSD semantic structure compari... (3)
-> + Studio Crashes On File Open (7)
-> + Which parser is used by Stylus... (2)
-> + How to DIFF XML windows with d... (3)
-> - Automation using Visual Studio (7)
-> ->Automation using Visual S...
-> ->Automation using Visual S...
-> ->Automation using Visual S...
-> ->Automation using Visual S...
-> ->Automation using Visual S...
-> ->Automation using Visual S...
-> + CSV to XML conversion help (2)
-> + XML tree help (3)
-> + java.lang.NullPointerException... (2)
-> + Creating schema from xml - how... (3)
-> + Mismatch between intellisense ... (4)
-> + Using FOP 0.94 in XML Pipeline (2)
-- Previous [1081-1100] [1101-1120] [1121-1140] 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 RobertsSubject: Automation using Visual Studio
Author: Jon Roberts
Date: 19 Mar 2008 12:24 PM
Originally Posted: 19 Mar 2008 12:23 PM
I'm after a little direction, please. I am developing in VB.NET using VS 2005 and am using Stylus Studio 2008 Enterprise to build an interface between EDIFACT messages and SQL 2005 database.

Using SS I can convert EDIFACT to an XML format suitable. This requires two steps - one is the EDI Converter, the second an XQUERY to produce a simplified XML structure that we can use.

Ultimately, I need to automate this. I need to poll / monitor for incoming EDIFACT files (which will be written to a designated folder) and run the SS Pipeline to convert either to XML files that I know I can process (or directly into the SQL DB).

I've tried the .NET API, but this seems to just run the converter, not the XQUERY (I think). I've downloaded Java SDK and tried compiling the Pipeline but get the following compile error:

Classpath:"w:\Development\EDI\";"c:\XTND\ProgramFiles\Stylus Studio 2008 XML Enterprise Suite\Components\XML Converters for Java\lib\XMLConverters.jar";"c:\XTND\ProgramFiles\Stylus Studio 2008 XML Enterprise Suite\Components\DataDirect XQuery\lib\ddxq.jar";"c:\XTND\ProgramFiles\Stylus Studio 2008 XML Enterprise Suite\Components\XML Converters for Java\lib\codehaus\wstx-asl.jar";"W:\Clients\Victoria Group\EDI\EDI2Manifest";"C:\XTND\ProgramFiles\Stylus Studio 2008 XML Enterprise Suite\bin\saxonsa.jar"
Compiling...
EDI2Manifest.java
Exception in thread "Thread-22" java.lang.NoClassDefFoundError: com/sun/tools/javac/Main

Can I call the Pipeline (or at least call the Converter & then the XQUERY) through VB.NET? Or am I better off trying to resolve the issues compiling the Pipeline & just run that as an automated 'black box' task and then just handle the converted XML files in my program?

Any advice would be gratefully received. I have spend some hours reading the forums, but can find anything to fully resolve this for me.

Many thanks
Jon
Postnext
(Deleted User) Subject: Automation using Visual Studio
Author: (Deleted User)
Date: 26 Mar 2008 12:07 PM
Hi Jon,
I think that the compilation step for the Java code is failing because you don't have chosen a valid JDK installation in the Tools | Options | Java Virtual Machine dialog.

Hope this helps,
Alberto
Postnext
Jon RobertsSubject: Automation using Visual Studio
Author: Jon Roberts
Date: 26 Mar 2008 12:15 PM
Hi Alberto,

Many thanks - that's fixed it. However, it has generated a secondary question.

I can now compile the XQUERY and the Pipeline, but now get the message "The evaluation period for DataDirect XQuery has expired. Please contact DataDirect Technologies to purchase a valid license."

Does the stylus studio license not cover compilation & automation? Do I need an additional license for this?

Regards
Jon
Postnext
(Deleted User) Subject: Automation using Visual Studio
Author: (Deleted User)
Date: 26 Mar 2008 12:27 PM
Hi Jon,
Stylus Studio includes a license for the DataDirect XQuery engine when used from inside the IDE; when you build Java code that invokes the DDXQ engine as a standalone (and deployable) application, you need a standalone license of DDXQ (see http://www.xquery.com/buy/ for pricing).
If you don't need the scalability, performance and database access that DDXQ provides, you can always pick a different XQuery processor in the pipeline scenario (e.g. Saxon-B) and re-generate the Java code.

Hope this helps,
Alberto

Postnext
Jon RobertsSubject: Automation using Visual Studio
Author: Jon Roberts
Date: 26 Mar 2008 12:53 PM
Hi Alberto,

Thanks - things are becoming clearer now (& significantly more expensive!). It looks like I'm going to need to buy some additional software, but I need to know what.

My project needs the EDIFACT to XML conversion, which I think means I need the DataDirect XML convertor.

I use the XML generated by the convertor and run it through an XQUERY to simplify it. I then plan to write the resulting simplied XML data into a MS SQL DB.

Does that mean I also need to by the DataDirect XQUERY software or can I then use stylus studio's compiled Java (assuming I've bought the DataDirect convertor).

I'm keen to know what I really need. I will have a little egg on face going back for more budget (having been claiming what a result we'd had finding stylus studio) but can live with that - I don't want to do it twice though (i.e. buy the convertor now & find I need another bit later).

Can you help, please, and let me know what - realistically - I now need to purchase to make this work.

Thanks
Postnext
Jon RobertsSubject: Automation using Visual Studio
Author: Jon Roberts
Date: 27 Mar 2008 05:44 AM
Hi Ivan,

Thanks, but I'm in the UK & it's product info I need, not license info and I'd just prefer to clarify this with a 'techie' first, before getting into discussions with a sales guy (forgive my cynicism, but I've fallen over on that one before!).

Is this correct:

To automate the reading of Edifact files and convert them to XML, I need DataDirect XML Converter. This will allow me to do this in VB.NET using VS 2005.

To automate the running of an XQUERY on the the resulting XML, I can use Saxon and use the Java compiled from Stylus Studio, but this means running two (fairly) separate processes.

I would prefer to run the XQUERY in my VB.NET program (directly after running the converter). Can I do this & if so, do I need additional product for this?

Many thanks.
Jon
Posttop
Ivan PedruzziSubject: Automation using Visual Studio
Author: Ivan Pedruzzi
Date: 27 Mar 2008 11:10 AM

In order to transform XML to XML I would rather use XSLT in your scenario, .NET has built-in support for XSLT, see XslCompiledTransform.

You could also consider Saxonica Saxon XQuery for .NET as well.

Ivan
   
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.