CSV File conversion utility

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.

Skills: PHP

See more: name flow, it positions, group directory, date utility, csv file conversion utility, conversione csv dat, csv file utilities, time stamp, naming, name naming, file, file folder, file conversion, download file, csv, csv php, csv file, conversion\, php process csv, flow user, php file array, php list directory files, php utility, php create csv file, zipped

About the Employer:
( 14 reviews ) Kansas City, United States

Project ID: #225864

Awarded to:


please check pm

$100 USD in 2 days
(4 Reviews)

16 freelancers are bidding on average $132 for this job


Hi, please see your PMB. Thanks.

$200 USD in 3 days
(272 Reviews)

Hi, please, check your PM

$150 USD in 0 days
(327 Reviews)

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

$120 USD in 0 days
(84 Reviews)

Will be fun!

$240 USD in 5 days
(14 Reviews)

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

$100 USD in 3 days
(23 Reviews)

Please check PM, thanks

$99 USD in 2 days
(29 Reviews)

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)

I can help you

$185 USD in 2 days
(7 Reviews)

Hi Ready to start. Just give the word.

$70 USD in 1 day
(3 Reviews)

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)

should not be a problem

$150 USD in 5 days
(0 Reviews)

Hello, I have excellent knowledge of PHP/Mysql and can handle this project without any problems.. My portfolio and websites for review is available at: [login to view URL] Please let me know if I can handle More

$125 USD in 2 days
(0 Reviews)

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)

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)

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

$100 USD in 2 days
(0 Reviews)