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)
-> + Varying Length Multiple Record... (2)
-> + Flat Flie to xml - validation (2)
-> + File Association (2)
-> + Generate XSL to transform from... (2)
-> + Installation Problem (3)
-> + compile error with generated j... (4)
-> + Help with Result of "Create Sc... (2)
-> + Region start position (line ve... (3)
-> + XSLT Mapper calling wrong temp... (3)
-> + Convert XSL to XSL:FO (5)
-> + Problem after downloading the ... (2)
-> + Moving node up / down (4)
-> + License transfer problem (2)
-> + Long element names in EDIFACT ... (4)
-> + Convert XML Schema to DB Table... (2)
-> + Connecting to DB2/400 through ... (2)
-> - Uninstall doesn't work (1)
-> + Pound (#) symbols appear inste... (3)
-> + Multiple file regions - dynami... (3)
-> + Cannot start Stylus studio pro... (2)
-> + XQuery missing Data when run (3)
-> + I need Help with a symple type... (2)
-> + Error while opening XML file f... (4)
-> + xquery variable substitution (2)
-> + Tab delemited Flat file to XML (17)
-> + Error on XSchema validation: "... (3)
-> + How to delete a file from a pr... (3)
-> + Generate Java Binding Classes (2)
-> + stylusstudio2008 suddenly stop... (2)
-> + Please Help (2)
-> - Looking in one tag to get the ... (1)
-> + Entity 'nbsp' was not found (2)
-> + Create 1 xml file for each lin... (4)
-> + SchemaLocation attribute (3)
-> + page break (4)
-> + name attribute of wsdl:fault e... (3)
-> + Cannot use my custom converter (3)
-> + java.lang.ClassNotFoundExcepti... (16)
-> + Witch product to buy (2)
-> + Trial version giving errors (2)
-> + Building and Integrating modul... (2)
-> + How to deploy pipeline (4)
-> + Is it possible to create xml f... (4)
-> + XML - CSV - XML Help! (2)
-> - xml file with many xsl style s... (1)
-> + Crash when using XML with DOCT... (2)
-> + Calling .Net classes from XSL ... (6)
-> + datadirect coverter result dif... (4)
-> + .net ConverterFactory().Create... (2)
-> + Dynamically created xsl used i... (4)
-> + Help with XSD attributes (3)
-> + Duplicated XML tag name in XML... (2)
-> + XML Publisher Repeater Bug wit... (4)
-> + HTML / FO selection (2)
-> + Command line interface to gene... (2)
-> + Provider org.apache.xerces.jax... (3)
-> + Problems with xsl:variable (2)
-> + any way to stop auto declarati... (2)
-> + Holding information in memory (9)
-> + Error whenever we try to read ... (4)
-> + Evaluation Versio Stylus Studi... (3)
-> + Convert linefeed-separated tex... (2)
-> + Transferring Stylus Studio fro... (3)
-> + Activation working on only one... (4)
-> + Populating Database from XML (2)
-> + Inserting Annotation (3)
-> + Project Window (2)
-> + DTD to Schema conversion gener... (2)
-> - Can't add multiple faults to a... (1)
-> + Soap fault name element (2)
-> + xml files supported outside of... (2)
-> + how to allow null values for d... (2)
-> + xml report query (5)
-> + Stylus Studio automatically ad... (3)
-> + Can we can stylus studio autom... (2)
-> + is it possible to insert into ... (3)
-> + Java Heap Space error (4)
-> + custom validation engines (3)
-> + W3C schema for enumerated taxo... (3)
-> + Using Stylus to generate elect... (2)
-> + WSDL editor and drop downs in ... (2)
-> + XSLT Mapper "forgetting" setti... (2)
-> + StylusStudio Crash: Error: Get... (7)
-> + Error in installation (2)
-> + Applying constraints & naming ... (5)
-> + Windows Installer prevents ins... (5)
-> + XML Schema to XML producing in... (8)
-> + calling javascript function in... (2)
-> + Repairin .xml file (2)
-> + HIgh CPU on a laptop after hib... (2)
-> - conditional rendering in XSL.. (1)
-> + Way to replace codes by labels... (4)
-> + Strange 'invisible' characters (4)
-> + syntax (2)
-> + Problem using mySQL (2)
-> + accessing Javascript variable ... (2)
-> + problem when openning files (2)
-> + Free Form Text (2)
-> + Cant open the database (4)
-> + Problem using MS Access (4)
-- Previous [1021-1040] [1041-1060] [1061-1080] 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.