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: [login to view URL], [login to view URL], [login to view URL]
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.
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 professional server, please drop me a message so we can talk further.
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.