CSV File conversion utility

Completed Posted Feb 14, 2008 Paid on delivery
Completed Paid on delivery

Overview: We need a small web based program written in PHP that will process a group of three csv files for a specific date and combine the necessary information to create a new single csv file. This new file will be compressed in a ZIP file and made available for immediate download.

Here is how we would like the process to flow:

1- When the PHP script is ran, it will scan the local directory for csv files. CSV file names will always contain the date in positions 6-13 formatted as yyyymmdd. For each date there will be three separate files that will differ only in the last three characters in the file name (ctf,lnf,nft) An example of files for a specific date (Feb 13, 2008) would be: [url removed, login to view], [url removed, login to view], [url removed, login to view]

2- A listing of dates available to process is presented to the user.

3- User clicks on a specific date to process.

4- The three files that make up a specific date are read and loaded into an array for conversion.

5- The new file is created, zipped and stored in a local folder “complete”.

6- If the new file is created successfully the original three csv files will be moved to a local directory “processed”

7- The user is presented with a message that the new file has been created and ready for download. A link is provided to download the new file.

8- If an error occurs that prevents the ZIP file from being properly generated, the original three files must remain unchanged. A log file should be created that will list file name, and if possible the error received as well as a time stamp.

We will provide file layouts and samples for the csv files on both ends as well as detailed information on which fields will need to be moved from one file to another. The final zip file has a specific naming convention that we will provide.

PHP

Project ID: #225864

About the project

16 proposals Remote project Active Feb 15, 2008

Awarded to:

almazX

please check pm

$100 USD in 2 days
(4 Reviews)
4.4

16 freelancers are bidding on average $132 for this job

value4u

Hi, please see your PMB. Thanks.

$200 USD in 3 days
(272 Reviews)
8.2
NickolaS

Hi, please, check your PM

$150 USD in 0 days
(327 Reviews)
7.5
kernelbd

We could do this easily. Please check PMB. Thanks.

$120 USD in 0 days
(84 Reviews)
6.3
bdsources

Will be fun!

$240 USD in 5 days
(14 Reviews)
5.6
vlip

Hello. I will do my best to help you. Thanks, Eugene.

$100 USD in 3 days
(23 Reviews)
4.1
SimStim

Please check PM, thanks

$99 USD in 2 days
(29 Reviews)
4.2
UKFreelance

I could complete this job for you within a couple of days. Your spec is very specific which is how I like to work. I'm a professional web developer freelancing out of office hours. If you are interested in a p More

$250 USD in 2 days
(1 Review)
3.7
Ellemer

I can help you

$185 USD in 2 days
(7 Reviews)
3.0
nooc

Hi Ready to start. Just give the word.

$70 USD in 1 day
(3 Reviews)
2.6
Aserdp

Hi, I have developed many php scripts for csv manipulation. Will be happy to get this script done for you. Thank You

$100 USD in 1 day
(9 Reviews)
2.2
joewisedesign

should not be a problem

$150 USD in 5 days
(0 Reviews)
0.0
Measum

I am php programmer.I have more than 6 years experience of programming in php with mysql. I also has a similar experience for a dubai client.

$30 USD in 5 days
(0 Reviews)
0.0
wisechain

we are a small group of developers with a long list of projects so far, so its any easy task for us. I hope u 'll find us more co-operative. many times we have handled these kind of scripts with .csv & xml Regards.

$100 USD in 3 days
(0 Reviews)
0.0
kunwar786786

by this project u can find me as reliable programmer for ur future projects. thanks

$100 USD in 2 days
(0 Reviews)
0.0