[EMAIL PROTECTED] wrote: > What If some non technical person > tried to upload a *.csv file with bad data? > > Thoughts?
For the State of California, we create a extensive validation routine making extensive use of file inspection and stored procedures to validate the data as best as possible. When errors are found, a report is generated and returned to the submitting person|organization detailing the problems. The validation routines does things like count the length of the lines in the data files, ours are column delimited. The stored procedures are run against the data that is stored in a temporary table created with a bulk upload of the data file. A history of all errors and changes is kept as well as the original data submitted. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305120 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
