Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: UNIX Shell script to work with .xml file
Top Forums Shell Programming and Scripting UNIX Shell script to work with .xml file Post 302902013 by waiting4u on Saturday 17th of May 2014 11:17:43 AM
Old 05-17-2014
RedHat UNIX Shell script to work with .xml file
Hi Team,

Could you please help me on below query:
I want to retrieve XML elements from one .xml file. This .xml file has commented tags as well. so i am planning to write Unix command/script which 1.will chekc for this .xml file
2. it will ignore the commented XML lines. i.e. XML tags between
<!-- and -->
3. and it will check for uncommented tags and will retrieve the values as below: and i need to check for the uncommented tags individually and there are duplicate tags with different values.
(I am providing belwo my XML content as below)
Please help to advise.

Required output:
----------------
Code:
port="8080" 
protocol="HTTP/1.1"
connectionTimeout="300000"
redirectPort="8443" 
maxThreads="200" 
minSpareThreads="4"        
maxSpareThreads="50" 
maxKeepAliveRequests="1" 

port="8009" 
protocol="AJP/1.3" 
redirectPort="8443"

name="jdbc/CLH" 
auth="Container" 
type="javax.sql.DataSource"
driverClassName="net.sourceforge.jtds.jdbc.Driver"
initialSize="10" 
maxActive="100" 
maxIdle="20" 
maxWait="10000"
validationQuery="select 1"
testOnBorrow="true"
factory="org.apache.commons.dbcp.BasicDataSourceFactory"
url="jdbc:jtds:sqlserver://xx.xxx.xx.xx:xxxx/Chase"
username="xxxxx" 
password="xxxxxx"

---------------
XML file has content as below:

Code:
<!-- SingleSignOn valve, share authentication between web applications
            Documentation at: /docs/config/valve.html -->
     <!--
        <Valve className="org.apache.catalina.authenticator.SingleSignOn" />
        -->
     <!-- Access log processes all example.
             Documentation at: /docs/config/valve.html
             Note: The pattern used is equivalent to using pattern="common" -->
    
     <Connector port="8080" protocol="HTTP/1.1"
               connectionTimeout="300000"
               redirectPort="8443" maxThreads="200" minSpareThreads="4"        maxSpareThreads="50" maxKeepAliveRequests="1" />

    <Connector port="8009" protocol="AJP/1.3" redirectPort="8443" />

    <Resource name="jdbc/CLH" auth="Container" type="javax.sql.DataSource"
              driverClassName="net.sourceforge.jtds.jdbc.Driver"
              initialSize="10" maxActive="100" maxIdle="20" maxWait="10000"
              validationQuery="select 1"
              testOnBorrow="true"
              factory="org.apache.commons.dbcp.BasicDataSourceFactory"
              url="jdbc:jtds:sqlserver://xx.xxx.xx.xx:xxxx/Chase"
              username="xxxxx" password="xxxxxx"  />

    <Resource name="UserDatabase" auth="Container"
              type="org.apache.catalina.UserDatabase"
              description="User database that can be updated and saved"
              factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
              pathname="conf/tomcat-users.xml" />

<Resource name="jdbc/MINT" auth="Container" type="javax.sql.DataSource"
               maxActive="3" maxIdle="1" maxWait="10000"
               username="XXX" password="XXX" driverClassName="oracle.jdbc.OracleDriver"
               url="jdbc:oracle:thin:@XXXX:XXX:XXX"
               factory="org.apache.commons.dbcp.BasicDataSourceFactory"/>

-----------------------------
Please could you help to advise.

Thanks..
Last edited by vgersh99; 05-17-2014 at 01:23 PM.. Reason: code tags, please!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Converting Text File into XML using Unix Shell Scripts

Hi everyone, If someone out there could help me out with this problem. I would really appreciate it. I am trying to convert a file into xml format using Unix shell scripts. The file has fields with each field having a certain number of bytes, but the fields are not delimited by anything... (10 Replies)
Discussion started by: Laud12345
10 Replies

2. UNIX for Dummies Questions & Answers

need to invoke a shell script from xml file.

hi all, forgive me if this question is not relevant to this section. i have a shell file that will automatically deploy the files that are necessary and will compile them. i need to automate this management process through cruise control, for this i need to know whether it is possible for me to... (2 Replies)
Discussion started by: sais
2 Replies

3. Shell Programming and Scripting

i want to nvoke a xml file from a shell script

hi all , i have a shell script that performs all the steps required for deployment of a tar file .. there is a tool that helps me in finding out what files should go in that tar file... this tool is fully in xml as it invokes ant ( a build tool in java ).... i want to invoke that xml file from a... (1 Reply)
Discussion started by: sais
1 Replies

4. Shell Programming and Scripting

How to remove xml namespace from xml file using shell script?

I have an xml file: <AutoData xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <Table1> <Data1 10 </Data1> <Data2 20 </Data2> <Data3 40 </Data3> <Table1> </AutoData> and I have to remove the portion xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" only. I tried using sed... (10 Replies)
Discussion started by: Gary1978
10 Replies

5. Shell Programming and Scripting

Shell Script Xml file wallpaper

Hello, I have a custom background in my Fedora 14 OS. which changes every 10 mins, I was able to edit an Xml file for this purpose. The structure of the Xml file looks as follows : <!-- This animation will start at time shown above. --> <static> <duration>600.0</duration> ... (3 Replies)
Discussion started by: ajayram
3 Replies

6. Shell Programming and Scripting

Shell Script to read XML file

Hi unix Gurus, I am really new to Unix Scripting. Please help me to create a shell script which reads the xml file and from that i need to fetch a particular information. For example <SOURCE BUSINESSNAME ="" DATABASETYPE ="Teradata" DBDNAME ="DWPROD3" DESCRIPTION ="" NAME... (5 Replies)
Discussion started by: SmilePlease
5 Replies

7. Red Hat

How to read an xml file through shell script?

Hey , can we read an xml file and make changes in it through shell script. Thanks (4 Replies)
Discussion started by: ramsavi
4 Replies

8. Shell Programming and Scripting

How to pass the parameter in xml file in UNIX shell script?

Hi, I have an XML file like the following... <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <ONDEMAND_JOB VERSION="5.1" LOCALE="en_US"> <IMPORT_JOBSET TC_CONNECTION_NAME="default" ENVIRONMENT="PRD" USERNAME="Administrator" PASSWORD="AdminPassword" CALENDAR="Main Monthly Calendar"... (2 Replies)
Discussion started by: Debalina Roy
2 Replies

9. Shell Programming and Scripting

How to pass the parameter in xml file in UNIX shell script?

Hi, I have an XML file like the following... <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <ONDEMAND_JOB VERSION="5.1" LOCALE="en_US"> <IMPORT_JOBSET TC_CONNECTION_NAME="default" ENVIRONMENT="PRD" USERNAME="Administrator" PASSWORD="AdminPassword" CALENDAR="Main Monthly Calendar"... (3 Replies)
Discussion started by: Debalina Roy
3 Replies

10. UNIX for Beginners Questions & Answers

UNIX shell script required to read two columns from xml

Hello All, I am new to unix scripting. I need to read FROMINSTANCE, FROMFIELD from below XML code and need to write a script for insert into SQ_EPIC values( "DID", "PROJECT_NAME") Select DID, PROJECT_NAME from EPIC<CONNECTOR TOINSTANCETYPE="Source Qualifier" TOINSTANCE="SQ_EPIC" TOFIELD="DID"... (7 Replies)
Discussion started by: sekhar.lsb
7 Replies
All times are GMT -4. The time now is 06:25 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy