Batch Transforming help

Play the video

Subject: Batch Transforming help
From: "Gary E. Daniels" <gdaniels@xxxxxxxxxxx>
Date: Thu, 27 Apr 2006 16:01:53 -0500

Hello. Newbie here looking for some guidance. I've been searching for a way to "batch"

transform a number of XML files. The information I've found appears to be the solution, but

I am having trouble understanding it. I need some step-by-step instructions. I am able to

"read" the contents of a folder or directory and have them appear in an XML file as shown

below (using HXDLG program files):

FILE #1

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hdlg:filesystem SYSTEM "http://www.hdlg.info/XML/filesystem.dtd">
<hdlg:filesystem xmlns:hdlg="http://www.hdlg.info/XML/filesystem">
   <hdlg:folder name="xmlbatch" url="file:/c:/xmlbatch/">
      <hdlg:file name="90500377.xml" size="2617748" type="unknown"

url="file:/c:/xmlbatch/90500377.xml">
      </hdlg:file>
      <hdlg:file name="90500385.xml" size="2425096" type="unknown"

url="file:/c:/xmlbatch/90500385.xml">
      </hdlg:file>
      <hdlg:file name="90500388.xml" size="2659608" type="unknown"

url="file:/c:/xmlbatch/90500388.xml">
      </hdlg:file>
      <hdlg:file name="90500412.xml" size="2319619" type="unknown"

url="file:/c:/xmlbatch/90500412.xml">
      </hdlg:file>
      <hdlg:file name="90500417.xml" size="3388378" type="unknown"

url="file:/c:/xmlbatch/90500417.xml">
      </hdlg:file>
      <hdlg:file name="90500452.xml" size="2629500" type="unknown"

url="file:/c:/xmlbatch/90500452.xml">
      </hdlg:file>
      <hdlg:file name="90500464.xml" size="2452754" type="unknown"

url="file:/c:/xmlbatch/90500464.xml">
      </hdlg:file>
   </hdlg:folder>
</hdlg:filesystem>

The following XSL Stylesheet is one I use to transform these files (90500377.xml,

90500385.xml, etc) one at a time:

FILE #2

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">

<xsl:output method="xml"/>

<xsl:template match="filename"/>
<xsl:template match="mimetype"/>
<xsl:template match="mimedata"/>

<xsl:template match="AppraisalForm">

 

<!-- Select specific Node or Form based on its id --><xsl:if test="@id='W1S'">
File #<xsl:copy-of select="field[@id='4']"/>|
Address <xsl:copy-of select="field[@id='1001']"/>|
City <xsl:copy-of select="field[@id='1002']"/>|
</xsl:if>

<xsl:if test="@id='W2S'"> Water <xsl:copy-of select="field[@id='14116']"/>| Sewer <xsl:copy-of select="field[@id='14126']"/>| Heat <xsl:copy-of select="field[@id='14127']"/>| </xsl:if>

 <xsl:if test="@id='W4S'"> OAR SP <xsl:copy-of select="field[@id='60293']"/>| GIM SP <xsl:copy-of select="field[@id='60291']"/>| Sale Date <xsl:copy-of select="field[@id='60016']"/>| </xsl:if>

<xsl:if test="@id='W5S'"> Vac Percent <xsl:copy-of select="field[@id='80090']"/>| </xsl:if>

<xsl:if test="@id='W7S'"> Year <xsl:copy-of select="field[@id='150955'][1]"/>| Source <xsl:copy-of select="field[@id='152539']"/>| Rental Inc <xsl:copy-of select="field[@id='150982']"/>| Laundry <xsl:copy-of select="field[@id='150984']"/>| </xsl:if>

<xsl:if test="@id='WSA'"> OAR Val <xsl:copy-of select="field[@id='97015']/value"/>| GIM Val <xsl:copy-of select="field[@id='97000']/value"/>| Value <xsl:copy-of select="field[@id='150615']/value"/>| </xsl:if>

</xsl:template></xsl:stylesheet>

How do I modify the above XSL Stylesheet (FILE #2) to batch transform the files in FILE #1? I have been using XFactor (Saxon) to load the single files and transform them. Will I need

to run the batch process from the command line? If so, I need to know what I need to type

in the command line and also what folders (directories) I need to create and what files need

to be placed into those folders (directories).

Or, is there an inexpensive editing/parser program that has batch processing capabilities?

Thanks in advance for your assistance.

Gary

Gary E. Daniels
Cornerstone Appraisal Company
500 Selkirk Drive
Schaumburg, IL. 60194
847 882-5892  Fax 847 882-5963
mailto:gdaniels@xxxxxxx
http://www.askdata.net

Current Thread
Accessing xml node data using variable. Thanks, exactly my problem too. David Riggs - 23 Apr 2006 07:25:19 -0000 Gary E. Daniels - 27 Apr 2006 21:02:17 -0000 <= andrew welch - 28 Apr 2006 09:14:28 -0000 Message not available Gary E. Daniels - 28 Apr 2006 17:16:24 -0000 andrew welch - 28 Apr 2006 18:15:41 -0000

<- Previous	Index	Next ->
Accessing xml node data using, David Riggs	Thread	Re: Batch Transforming help, andrew welch
Re: sum up float values probl, Dimitre Novatchev	Date	RE: Batch Transforming help, cknell
	Month

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Cast Your Vote

We need your help – Vote for DataDirect XML Products!

Best SOA or XML site

Winners and finalists announced at SOA World Conference in November.

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Subscribe in XML format

RSS 2.0
Atom 0.3


	Stylus Studio® Developer Network \| Contact Us \| Email this page