parse xml file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting parse xml file
# 1  
Old 10-19-2010
parse xml file

Hello all,

Given the following extract from a xml file with multiple <JOB> .... </JOB> entries

Code:
  <JOB
   APPLICATION="APP"
   APR="0"
   AUG="0"
   AUTHOR="AUT"
   AUTOARCH="0"
   CMDLINE="/tmp/test1 %%var"
   CONFIRM="1"
   CREATION_DATE="20100430"
   CREATION_TIME="130739"
   CREATION_USER="user"
   CRITICAL="0"
   CYCLIC="0"
   CYCLIC_TYPE="Interval"
   DAYS_AND_OR="OR"
   DEC="0"
   DESCRIPTION="This is a test for job1"
   FEB="0"
   IND_CYCLIC="START"
   INTERVAL="00000M"
   JAN="0"
   JOBNAME="TESTJOB"
   JUL="0"
   JUN="0"
   MAR="0"
   MAXDAYS="0"
   MAXRERUN="0"
   MAXRUNS="0"
   MAXWAIT="20"
   MAY="0"
   MEMNAME="JOB1"
   MULTY_AGENT="N"
   NODEID="SERVER1"
   NOV="0"
   OCT="0"
   OWNER="root"
   RETRO="0"
   SEP="0"
   SHIFT="IGNOREJOB"
   SHIFTNUM="+00"
   SYSDB="0"
   TAG_RELATIONSHIP="OR"
   TASKTYPE="Command"
   USE_INSTREAM_JCL="N"
>
   <QUANTITATIVE NAME="DRIVE1" QUANT="1"/>
   <OUTCOND NAME="JOB1-OK" ODATE="ODAT" SIGN="ADD"/>
   <AUTOEDIT EXP="%%SYSTEM=server1"/>
  </JOB>
  <JOB>
  ...........
   JOBNAME="TESTJOB2"
>
   .......
   <INCOND AND_OR="AND" NAME="JOB1-KO" ODATE="ODAT" />
  </JOB>

Can someone help me having the following output if I grep for exemple the keywork JOB1. Note: this keywork whill only be grepped in lines containing the tag INCOND and OUTCOND and then print the following output:
Code:
TESTJOB OUTCOND JOB1-OK
TESTJOB2 INCOND AND JOB1-KO

Thanks in advance for the attention

Regards,
# 2  
Old 10-19-2010
Assuming the following simplified XML document (example1.xml) where I have removed most of the attributes to make the things easier to follow:
Code:
<JOBS>
   <JOB INTERVAL="00000M" JAN="0" JOBNAME="TESTJOB" JUL="0">
       <QUANTITATIVE NAME="DRIVE1" QUANT="1"/>
       <OUTCOND NAME="JOB1-OK" ODATE="ODAT" SIGN="ADD"/>
       <AUTOEDIT EXP="%%SYSTEM=server1"/>
   </JOB>
   <JOB INTERVAL="00000G" JAN="0" JOBNAME="TESTJOB2" JUL="0">
       <QUANTITATIVE NAME="DRIVE1" QUANT="1"/>
       <INCOND AND_OR="AND" NAME="JOB1-KO" ODATE="ODAT" />
       <AUTOEDIT EXP="%%SYSTEM=server1"/>
   </JOB>
</JOBS>

the following XSLT 1.0 stylesheet (example1.xsl) will output what you specified
Code:
<xsl:stylesheet version="1.0"
   xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

   <xsl:param name="search"></xsl:param>

   <xsl:output method="text"/>

   <xsl:template match="/">
       <xsl:apply-templates select="//OUTCOND" />
       <xsl:apply-templates select="//INCOND" />
   </xsl:template>

   <xsl:template match="OUTCOND">
      <xsl:if test='contains(@NAME, $search)'>
         <xsl:value-of select="../@JOBNAME" />
         <xsl:text> OUTCOND </xsl:text>
         <xsl:value-of select="@NAME" />
         <xsl:text>
</xsl:text>
      </xsl:if>
   </xsl:template>

   <xsl:template match="INCOND">
      <xsl:if test='contains(@NAME, $search)'>
         <xsl:value-of select="../@JOBNAME" />
         <xsl:text> INCOND </xsl:text>
         <xsl:value-of select="@AND_OR" />
         <xsl:text> </xsl:text>
         <xsl:value-of select="@NAME" />
         <xsl:text>
</xsl:text>
      </xsl:if>
   </xsl:template>

</xsl;stylesheet>

Here is how you would perform the transformation using xsltproc where the search term is JOB1
Code:
$ xsltproc -param search "'JOB1'" example.xsl example.xml
TESTJOB OUTCOND JOB1-OK
TESTJOB2 INCOND AND JOB1-KO
$

This User Gave Thanks to fpmurphy For This Post:
# 3  
Old 10-20-2010
Perfect!
I didn't know xsltproc, thanks for your great help and time fpmurphy! Smilie

---------- Post updated 20th Oct 2010 at 11:16 AM ---------- Previous update was 19th Oct 2010 at 08:03 PM ----------

EDIT:
xsltproc is very powerfull and in order to improve my results I added the following code in your example.xsl :
Code:
   <xsl:template match="/">
       <xsl:apply-templates select="//QUANTITATIVE" />
   </xsl:template>

   <xsl:template match="QUANTITATIVE">
      <xsl:if test='contains(@NAME, $search)'>
         <xsl:value-of select="../@JOBNAME" />
         <xsl:text> </xsl:text>
         <xsl:value-of select="@NAME" />
         <xsl:text> </xsl:text>
         <xsl:value-of select="@QUANT" />
         <xsl:text> </xsl:text>
         <xsl:text>
</xsl:text>
      </xsl:if>
   </xsl:template>

This new code is working fine, the only thing is that when I do a command xsltproc -param search "'KEYWORD'" if KEYWORD exists in (OUTCOND or INCOND) and in QUANTITATIVE template it will print all matching results at the same time.

Is there a way to pass a parameter via xsltproc command line or something in order to print only (OUTCOND or INCOND) or QUANTITATIVE with just one example.xsl file ?

A solution would be to create multiples .xsl files but I would rather prefer having just one. Any idea fpmurphy or someone else ? Smilie

Thanks for the attention!

Last edited by cabrao; 10-20-2010 at 07:16 AM.. Reason: New question
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Parse xml file

I am trying to create a shell script that will parse an xml file (file attached). awk '/Id v=/ { print }' Test.xml | sed 's!<Id v=\"\(.*\)\"/>!\1!' > output.txt An output.txt file is created but it is empty. It should contain the value 222159 in it. Thanks. (7 Replies)
Discussion started by: cmccabe
7 Replies

2. Shell Programming and Scripting

Parse XML File.

HI Guys I have Below XML File : <xn:SubNetwork id="XYZ"> <xn:SubNetwork id="C01"> <xn:MeContext id="CO1"> <xn:ManagedElement id="1"> <un:RncFunction id="1"> <un:UtranCell id="NY431"> ... (2 Replies)
Discussion started by: pareshkp
2 Replies

3. UNIX for Dummies Questions & Answers

Parse xml file

HI Guys, Input .XML <xn:MeContext id="L0307"> <xn:ManagedElement id="1"> <xn:VsDataContainer id="1"> <xn:attributes> <xn:vsDataType>vsDataENodeBFunction</xn:vsDataType> ... (3 Replies)
Discussion started by: pareshkp
3 Replies

4. Programming

Parse XML file

How do I get the field info for tags ID, NAME, DESCRIPTION. Below is my current code put I can't get beyond the first_child of the file. use strict; use warnings; use XML::Simplehttp://images.intellitxt.com/ast/adTypes/icon1.png; use... (1 Reply)
Discussion started by: leemalloy
1 Replies

5. Emergency UNIX and Linux Support

How to parse the following xml file

Hi, I have the following file Example.xml <?xml version="1.0" encoding="iso-8859-1"?> <html><set label="09/07/29" value="1241.90"/> </html> Can any one help me in parsing this xml file I want to retrive the attribute values of the tag set Example I want to... (3 Replies)
Discussion started by: Raji_gadam
3 Replies

6. Shell Programming and Scripting

Parse an XML task list to create each task.xml file

I have an task definition listing xml file that contains a list of tasks such as <TASKLIST <TASK definition="Completion date" id="Taskname1" Some other <CODE name="Code12" <Parameter pname="Dog" input="5.6" units="feet" etc /Parameter> <Parameter... (3 Replies)
Discussion started by: MissI
3 Replies

7. Shell Programming and Scripting

How can I parse xml file?

How can I parse file containing xml ? I am sure that its best to use perl - but my perl is not very good - can someone help? Example below contents of file containing the xml - I basically want to parse the file and have each field contained in a variable.. ie. I want to store the account... (14 Replies)
Discussion started by: frustrated1
14 Replies

8. Shell Programming and Scripting

Parse String in XML file

Hello All, I am new to this and I need to parse an XML file. Here's the XML Input File: <Report version="1.2"> <summary fatals="0" testcases="1" expected_fails="0" unexpected_passes="0" warnings="9" tests="21" errors="0" fails="1" passes="20" /> <testresult... (4 Replies)
Discussion started by: racbern
4 Replies

9. Shell Programming and Scripting

Parse XML file

Hi, I need to parse the following XML data enclosed in <a> </a> XML tag using shell script. <X> ..... </X> <a> <b> <c>data1</c> <c>data2</c> </b> <d> <c>data3</c> </d> </a> <XX> ... </XX> (5 Replies)
Discussion started by: viki
5 Replies

10. Shell Programming and Scripting

How to parse a XML file using PERL and XML::DOm

I need to know the way. I have got parsing down some nodes. But I was unable to get the child node perfectly. If you have code please send it. It will be very useful for me. (0 Replies)
Discussion started by: girigopal
0 Replies
Login or Register to Ask a Question

Featured Tech Videos