Database Script

Completed Posted Jul 31, 2008 Paid on delivery
Completed Paid on delivery

Hello,

We need a script written to work with our website to update stock figures from files that we receive from our supplier, they are updated every 2 minutes from the supplier through ftp and a file is placed for us to do the following:

1. Get all files in the directory in filename order (order is important

as 2 files might both update the same product, the more recent one needs

to be processed 2nd to get an accurate result). Files are named by a

date stamp so are easy enough to order.

2. Loop through each file and update the database accordingly. The

format of the file is pretty simple, each line of the file will contain

something like:

10077|65.00|0.00|30/07/2008|0.00|2.30

where 10077 is the sku, 65.00 is the stock level, 30/7/2008 is when we

expect to receive more and 2.30 is the trade price of the item (you can

ignore to 2 0.00 fields - these might have a number in but this doesn't

matter).

3. Archive/Delete the files that have been processed

Database Administration Engineering MySQL PHP Project Management Software Architecture Software Testing SQL

Project ID: #3101478

About the project

2 proposals Remote project Active Jul 31, 2008

Awarded to:

ashishsalveeug53

See private message.

$22.1 USD in 3 days
(11 Reviews)
3.3

2 freelancers are bidding on average $24 for this job

jackfate

See private message.

$25.5 USD in 3 days
(6 Reviews)
2.7