Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Unix Script to read the XML file from Website

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Unix Script to read the XML file from Website
# 1  
Old 01-30-2011
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...
# 2  
Old 01-30-2011
Code:
wget -o /Your_Unix_DIR/fx.xml http://www.westpac.co.nz/olcontent/olcontent.nsf/fx.xml

# 3  
Old 01-31-2011
Code:
wget http://www.westpac.co.nz/olcontent/olcontent.nsf/fx.xml -O "xml.txt"
awk 'BEGIN{FS="[ <>]"}{if($0 ~ "</rate>") print $6}' xml.txt >> out.txt

# 4  
Old 01-31-2011
Hi All,

I have executed the get_Fx.sh script file in (HP-UX B.11.31 U ia64 3519845154) version.


get_Fx.sh Code:

#!/bin/sh
wget http://www.westpac.co.nz/olcontent/olcontent.nsf/fx.xml -O "xml.txt"
awk 'BEGIN{FS="[ <>]"}{if($0 ~ "</rate>") print $6}' xml.txt >> /dev/exchangerates/fromsource/fx.xml

I am getting below error.

get_Fx.sh[2]: wget: not found.
get_Fx.sh[3]: /dev/exchangerates/fromsource/fx.xml: Cannot create the specified file.
{xyz@abc01:/dev/exchangerates/fromsource}
# 5  
Old 01-31-2011
Then you need install wget or curl, google on web to find out the way to install it.
# 6  
Old 01-31-2011
Quote:
Originally Posted by phani333
/dev/exchangerates/fromsource/fx.xml: Cannot create the specified file.
permission denied?try to change to "root"
# 7  
Old 02-01-2011
HI,

I have checked with my Unix Team and it seems they need lot of approvals to install WGET on the unix system. Can I achive the same using FTP script?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

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

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

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

4. Shell Programming and Scripting

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

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

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. Shell Programming and Scripting

feasibility of opening a website link from unix and get a response in the form of xml or html

i just wanted to know whether is it possible to open a website link and get a response in the form of xml or html format... the website is of local network... for example something like this wget http://blahblah.samplesite.com/blachblahcblach/User/jsp/ShowPerson.jsp?empid=123456 ... (2 Replies)
Discussion started by: vivek d r
2 Replies

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

9. Shell Programming and Scripting

Need help in creating a Unix Script to parse xml file

Hi All, My requirement is create an unix script to parse the xml file and display the values of the Elements/value between the tags on console. Like say, I would like to fetch the value of errorCode from the below xml which is 'U007' and display it. Can we use SED command for this? I have tried... (10 Replies)
Discussion started by: Anil.Wmg
10 Replies

10. Shell Programming and Scripting

Sample Unix script file to convert .xml to .csv

Dear all, Can you send me a script file the changes .xml to .csv file. Thanks, Srinivasa (4 Replies)
Discussion started by: srinivasaphani
4 Replies
Login or Register to Ask a Question