I have an old coldfusion script that I wrote that takes a specific piped text file from an url and does some case switch to do some conditional changes on the incoming data, then uploads it to a SQL server table. Pretty basic stuff. It worked for a long time, then tried and am getting incorrect number of columns error, and I do not have time. Should not be more than 2 hours work (tops) for a proficient coder, as I have the bsic of it complete and I can give you a db script to build the table to work with on your development end. Basic I need:
pipe file will contain around a 1000 records or so
needs to have some data switched before inserting (numbers into state abbreviations, etc, I have these parts to send you) you can cannibalize the old code as much as you want.
I need it to be robust, so that if the file scales to 3000 or 5000 records it will still work.
That is about it.
Approximate start date of the project after selecting a bid
Immediate (within 1-2 days)
The following was added to the description on
Tue Oct 4 17:07:38 2005 , after the project was originally posted.
I am not saying that the records are going to come in via URL. The script will be pulling the data from an url via CFHTTP.