How to read an xml file through shell script?

 
Thread Tools Search this Thread
Operating Systems Linux Red Hat How to read an xml file through shell script?
# 1  
Old 05-08-2013
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
# 2  
Old 05-08-2013
Yes we can.. What kind of changes you are trying to do?
# 3  
Old 05-08-2013
I have one xml file and in that we have different event source defined and for
each event source we have different file mask . so , i have to read those file
mask and according to that pattern i have to pick files from other folder.
# 4  
Old 05-08-2013
Could you please post the sample input xml file and the o/p format you need?
# 5  
Old 05-08-2013
hey, what i have to do is to search for a file mask type and then to pick
file of that type from the input location, so i need to read that xml through shell script.

Code:
<?xml version="1.0" encoding="UTF-8"?>
<Sources>
  <StopFileName>/export/home/merge/cfg/MergeConfig.xml.stop</StopFileName>
  <DatabaseConnection>
    <TNSName>dgid1rr</TNSName>
    <Username>rte</Username>
    <Password>rted1</Password>
  </DatabaseConnection>
  <Logger>
    <LogMaxSize>1024</LogMaxSize>
    <LogFileNos>5</LogFileNos>
    <LogFilePath>/export/home/dgid1rr/merge/log</LogFilePath>
    <LogFileName>idr_merge_log</LogFileName>
    <LogLevel>Info</LogLevel>
  </Logger>
  <Source id="S1">
    <FileMask>idr_%YYYY%%MM%%DD%_%N%.idr</FileMask>
    <TimeLag>100</TimeLag>
    <Backup>True</Backup>
    <InputFilePath>/export/home/dgid1rr/cdr1/input</InputFilePath>
    <OutputFilePath>/export/home/dgid1rr/merge/cdr1/output</OutputFilePath>
    <BackupFilePath>/export/home/dgid1rr/merge/cdr1/backup</BackupFilePath>
    <ProcessOrder>FileTimestamp</ProcessOrder>
    <Enable>True</Enable>
    <MaxFiles>3</MaxFiles>
    <MaxRecs>25</MaxRecs>
  </Source>
  <Source id="S2">
    <FileMask>idr_%2N%.idr</FileMask>
    <TimeLag>300</TimeLag>
    <Backup>True</Backup>
    <InputFilePath>/export/home/dgid1rr/merge/cdr2/input</InputFilePath>
    <OutputFilePath>/export/home/dgid1rr/merge/cdr2/output</OutputFilePath>
    <BackupFilePath>/export/home/dgid1rr/merge/cdr2/backup</BackupFilePath>
    <ProcessOrder>OSTimestamp</ProcessOrder>
    <Enable>True</Enable>
    <MaxFiles>2</MaxFiles>
  </Source>
</Sources>



like this we can have more sources in the xml as well. and from each
sources , i have to read the file mask and on that basis i have to pick the
file from input directory.

Last edited by radoulov; 05-08-2013 at 07:22 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need get data from XML file through shell script..

hi all, here is the sample log file and these errors are repeated in log file.. i need all the repeated time stamp ,severity and message tags needs to print in output file.. through shell script <log-message> <timestamp>2019-03-13T04:52:49.648-05:00</timestamp> <severity>ERROR</severity>... (17 Replies)
Discussion started by: ravi
17 Replies

2. 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

3. Shell Programming and Scripting

Read xml tags and then remove the tag using shell script

<Start> <Header> This is header section </Header> <Body> <Body_start> This is body section <a> <b> <c> <st>111</st> </c> <d> <st>blank</st> </d> </b> </a> </Body_start> <Body_section> This is body section (3 Replies)
Discussion started by: RJG
3 Replies

4. Shell Programming and Scripting

Read xml file till script finds separation and run again for next input and so on

Hi All, I have one query, I managed to run script with user inputs through command line or with 1 file. But I need to read a txt file/xml file in which user can mention multiple sets of answers and script should run for each set till it reach the EOF. Thanks in advance for example, the file... (3 Replies)
Discussion started by: rv_champ
3 Replies

5. 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

6. UNIX for Advanced & Expert Users

Shell Script to read XML tags and the data within that tag

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... (2 Replies)
Discussion started by: SmilePlease
2 Replies

7. Shell Programming and Scripting

script to read XML file

Dear All, I have one log file and it contains lot of XML as below. ... (1 Reply)
Discussion started by: murtujak
1 Replies

8. Shell Programming and Scripting

Unix Script to read the XML file from Website

Hi Experts, I need a unix shell script which can copy the xml file from the below pasted website and paste in in my unix directory. http://www.westpac.co.nz/olcontent/olcontent.nsf/fx.xml Thanks in Advance... (8 Replies)
Discussion started by: phani333
8 Replies

9. 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

10. UNIX for Advanced & Expert Users

Shell script failing to read large Xml record-urgent critical help

Hi All, I have shell script running on AIX 5.3 box. It has 7 to 8 "sed" commands piped(|) together. It has a an Xml file as its input which has many records internally. There are certain record which which have more than hundered tags.The script is taking a huge amount of time more than 1.5 hrs... (10 Replies)
Discussion started by: aixjadoo
10 Replies
Login or Register to Ask a Question