Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

parse xml file

Login to Discuss or Reply to this Discussion in Our Community

 
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:
cabrao
# 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 06: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