Shell Script Help

[PriteshP23]

Hello,

 

I have one tar.Z file. I have to run shell script daily as it is required to update the database.

 

    customer_yyyymmdd_hhmi.tar.Z

    

    sales_ yyyymmdd_hhmi.csv (5 MB - 20 MB)

    purchase_ yyyymmdd_hhmi.xml (650 MB - 950 MB)

I have made small part of XML file. There are 4 parts. There is PHP Script which is working but i need to change each time file like PART1.xml, PART2.xml etc. 

 

Things to do:

 

1) Extract tar.Z file and Read CSV and XML file.

2) Read whole XML file automatically.

 

I hope i am clear. Thanks in advanced for your time and input.

 

[trq]

You forgot to ask a question / tell us what the problem is.

[PriteshP23]

You forgot to ask a question

 

 

Well, I have already mentioned that "Things to do:"

 

The problem is that i am looking for a shell script which can perform expected operation.

[Irate]

What have you tried so far? Where are you stuck?

[PriteshP23]

Where are you stuck? 

 

 

 

#!/bin/sh
DB_USER="****"
DB_PASS="****"
DB_NAME="****"
echo "##########"
echo $1
echo "##########"
echo
date
cd customer
for i in *-*.php
do 
  echo $i
  php $i $1
  echo
  date

I need something like this. This is just REFERENCE. It is not working.