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 » Apply xsl to multiple files
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + DBF converter with the Cyrilli... (3)
-> + Stylus Studio caching document... (3)
-> + Stylus Studio Online help inst... (9)
-> + specific colors (2)
-> + Formatting problems when creat... (2)
-> - Headers and Footers (1)
-> + XML output's a URL in Browser ... (2)
-> + Generating Java Code for XML (3)
-> + format dates in publisher (2)
-> + grouping in Stylus Studio Publ... (5)
-> + Can schema documentation title... (3)
-> + Stylus can not find the right ... (2)
-> + Problem to create Schema from ... (5)
-> - Design a DTD to represent the ... (1)
-> + Surround SCM integration (3)
-> + Converting a csv file to xml u... (5)
-> + Legacy Format Handling (3)
-> + Size limit for XML documents (2)
-> + Can Stylus Studio easily expor... (3)
-> + Problem convert excel to xml (5)
-> + convert X12 EDI into XML in a... (2)
-> + Capturing the return data for ... (3)
-> + stamps.com wsdl issues (3)
-> + Preview issues (2)
-> + Stylus Studio X14 - XML to EDI... (3)
-> + Stylus Studio X14 - Overrides ... (4)
-> + Anyway to specify namespace pr... (6)
-> + StylusStudio 2010 crashes when... (6)
-> + Version Upgrade (2)
-> + How to write a if -else statem... (4)
-> + URGENT URGENT URGENT ! (EDIF... (3)
-> + X14 Saxon document uri problem (5)
-> + namespace problem on XML gener... (7)
-> + Stylus Studio Tool Bars (2)
-> + X14 Enterprise - Web Services ... (3)
-> + Saxon edition in X14 Enterpris... (2)
-> + How to create PDF documents wi... (2)
-> + WSCall doesn't work from xquer... (4)
-> + Issues with converter (8)
-> + xsd null strings - option to i... (2)
-> + wrapping table rows and mismat... (3)
-> + Report Designer: Is it possibl... (4)
-> + Message Baplie 1.5 with 1.911 ... (2)
-> + saved merged view in diff engi... (2)
-> + Cannot see needed element to m... (2)
-> + Matching problem in function (3)
-> - Funny warning message (1)
-> - Missing rows and text when con... (1)
-> + Another JSON problem (2)
-> + JSON problem (8)
-> + WebDav Custom properties (2)
-> + jvm not registering in the too... (2)
-> + How to turn off error about mi... (6)
-> + XML Attribute Element output f... (2)
-> + ddtek:wscall not returning all... (7)
-> - Trial Only Lasted 7 of the 14 ... (1)
-> + tree view without leaves (fiel... (3)
-> + XML to Text File (2)
-> + Stylus Studio Processor Debugg... (3)
-> + Java XMLPipeline result to str... (6)
-> + Attribute - XSD, DataDirect, X... (7)
-> + .NET XslCompliedTransform pro... (3)
-> + How to increase JVM Heap Size? (10)
-> + How in XSD do I reference the ... (2)
-> + Conversion of negative numbers (2)
-> + XSLT mapper (2)
-> - Converting csv file with embed... (1)
-> + WSDL completion inquiry (2)
-> - Move License (1)
-> + XML to Excel conversion and vi... (8)
-> + “spell checker” and “well-form... (2)
-> + Relational DB Icon Not appeari... (2)
-> + How come AUP doesn't respond (4)
-> - Software activation does not w... (1)
-> + Stylus studio continually cras... (2)
-> + Error running on Windows 7 (3)
-> + Creating xml start and end tag... (4)
-> + Keeping track of position afte... (3)
-> + splitting a row into multiple ... (3)
-> + Where is Convert to XML? (2)
-> + Built-In XSLT Processor Missin... (4)
-> - Converting XSL to XSL-FO (1)
-> - Can we compare two XML Schema ... (1)
-> - Stylus Studio EDI Conversion /... (1)
-> + Installation Issue Windows XP ... (2)
-> + Converting CSV with component ... (2)
-> - how to edit a xsl file, so tha... (1)
-> - Cannot save file to Webdav (1)
-> + How to copy Column Names on Gr... (3)
-> - XML when to use (1)
-> - Attribute vs data elements (1)
-> - Attribute Group (1)
-> - EDI conversion from command li... (1)
-> - WSDL schema - import of xsd (1)
-> + Get Date (2)
-> + help calling https web service (5)
-> - Newbie looking out for BizTalk... (1)
-> + Publishing XML pipeline as Web... (2)
-> - annotation within sequence ele... (1)
-> - backmapping using Saxonica 9.1... (1)
-- Previous [301-320] [321-340] [341-360] 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
Tim TSubject: Apply xsl to multiple files
Author: Tim T
Date: 14 Sep 2005 02:50 PM
Originally Posted: 14 Sep 2005 10:05 AM
I am currently using Stylus Studio Professional, and have created a new XML mapping project.<br> <br> The mapper was great, and I successfully mapped one schema to another, and the scenarios work fine for testing on several files. My question is this:<br> Can I apply the XSL to all of my 2000 files in a batch process?<br> <br> I don't mind creating/running a script, batch file, command line, or whatever, but I could not find the solution on the forums or in the help file.<br> <br> Additionally, all of my tag in the original file contain "my:" (i.e. <my:example>true</my:example>; they're InfoPath files). When I run the scenario, they are removed, along with the InfoPath header. I can and do replace them after the fact in a text editor, but can I have this in there from the start in Stylus Studio?<br> <br> Thanks for any help and feedback on this,<br> -Tim
Postnext
Tim TSubject: Apply xsl to multiple files
Author: Tim T
Date: 14 Sep 2005 02:59 PM
Perhaps my original post was a bit unclear; I am still quite new to this process and the terminology, and I imagine my naiveté occludes my view of a solution.

My main goal and priority is to be able to apply an xsl file created using the Stylus Studio mapper to multiple files. More specifically, I have 2000 files, which would be time prohibitive to create a scenario for each file.

Any help or advice would be greatly appreciated.

-Tim
Postnext
Tony LavinioSubject: Apply xsl to multiple files
Author: Tony Lavinio
Date: 14 Sep 2005 04:09 PM
In the bin directory where you installed Stylus Studio, there is a
program called StylusXslt.exe which will run XSLT from the command
line so you can use this in a batch file or 'for' statement.

As far as the my: prefix goes, the mapper will sometimes rearrange
namespace prefixes, but should not in any way affect the actual parsing
of the XML. If you think there is a problem, you can post the problem
(fixed and broken) sheets here by using the "Attach File" checkbox that
is above the "Message" box when you reply, or by emailing them to
stylus-field-report (at) stylusstudio.com for us to take a look at.
Postnext
Ivan PedruzziSubject: Apply xsl to multiple files
Author: Ivan Pedruzzi
Date: 14 Sep 2005 04:18 PM
Hi Tim

Here are few quick steps to run a transformation batch

- Save the script at the bottom of this message as C:\xslt-batch.vbs
- in Stylus Studio go to Tools -> Options -> Application Settings -> Custom Tools
- click new and name it xslt-batch
- fill the fields below as follow

Command: cscript.exe
Arguments: "c:\xslt-batch.vbs" "c:\Temp\batch\source" "${FilePath}" "c:\Temp\batch\target"

the second argument is the source directory
the fourth argument is the target directory

- click OK
- now open your XSLT then click Tools -> xslt-batch
Stylus will run the current stylesheet against all files in the source directory and will generate the output in the target directory.

Hope this helps
Ivan Pedruzzi
Stylus Studio Team


sourceDirectory = WScript.arguments(0)
xsltPath = WScript.arguments(1)
targetDir = WScript.arguments(2)
Set fso = CreateObject("Scripting.FileSystemObject")
Set WshShell = CreateObject("WScript.Shell")
prg = """c:\Program Files\Stylus Studio 6 XML Enterprise Edition\bin\msxsl.exe"""

WScript.echo "batch start"
WScript.echo "Source directory " + sourceDirectory
WScript.echo "XSLT " + xsltPath
WScript.echo "Target Directory " + targetDir

if fso.FolderExists(targetDir) and fso.FileExists(xsltPath) then
Set folder = fso.GetFolder(sourceDirectory)
For Each f1 in folder.Files
outPath = """" + targetDir + "\" + f1.name + """"
Set oExec = WshShell.Exec(prg + " " + f1.Path + " """ + xsltPath + """ -o " + outPath)
Do While oExec.Status = 0
WScript.Sleep 100
Loop
WScript.echo + f1.Path + " --> " + outPath
Next
end if
WScript.echo "batch finish"
Postnext
Tim TSubject: Apply xsl to multiple files
Author: Tim T
Date: 14 Sep 2005 04:34 PM
Thanks for the replies, this should set me in the right direction. Hopefully I'll have it all done for my boss by Monday:)

As far as the "my:" prefix goes, it parses the xml perfectly, only it omits the prefix in the output. Additionally, the "my:" prefix is not in the xsl. Can I add in the prefix on the xsl prior to transformation, along with the additional header info?

-Tim
Posttop
Tony LavinioSubject: Apply xsl to multiple files
Author: Tony Lavinio
Date: 14 Sep 2005 11:38 PM
Yes, you should be able to add any namespace prefix to the XSLT
and see it represented in the output.
   
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.