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.

Recommended Answers

All 2 Replies

I hope i am clear.

Not particularly. Please post your php and shell code here.

Please post your php and shell code here.

I don't have shell script. I have php file to read CSV and XML file.

Well i need help in shell script which can give expected operations.

What i have:

#!/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

done

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.