I like setting up an xls datasource. The user uploads the file, the
filename is changed to your xls datasource file name, and you then query
that spreadsheet. From there, you do your insert into your database.
You could take it a step further and make a file from your xls query
that is compatible with your db's bulk insert command/utility, and do
things that way. Of course, there's a number of issues: file locking,
"dirty" data, etc.
--
Billy Cravens
[EMAIL PROTECTED]
Peter Theobald wrote:
>
> When designing a web site, we usually give clients two ways to administer the site's
>data:
> a) they use a web based admin interface to modify one value at a time
> b) and they have some facility to make larger bulk uploads (and downloads) of data
>
> How do you usually implement the bulk data administration?
>
> Here are the methods we have used:
> 1) The client uses an Excel spreadsheet to list the data. They save the spreadsheet
>as a TAB delimited file and go to an admin web page that allows them to upload the
>file with CFFILE to a web-visible directory. Then the file is parsed with CFHTTP and
>some regular expressions to clean up Excel's TAb delimited format (which is not
>directly compatible with CFHTTP's), or the file is read and parsed with CFFILE. The
>data is inserted/updated into the database a row at a time (which can be slow for
>alot of data).
>
> 2) The client uses an Excel spreadsheet to list the data. They save the spreadsheet
>as a TAB delimited file and go to an admin web page that allows them to upload the
>file with CFFILE. Then a Perl script is called with CFEXECUTE that reformats the data
>file and calls a bulk utility (in our case Sybase BCP) that inserts the data very
>quickly (very fast, but "brittle" if the data is not exactly right).
>
> I'd like to hear what other people have done.
>
> ---------------------------------------------------------------------------
> Peter Theobald, Chief Technology Officer
> LiquidStreaming http://www.liquidstreaming.com
> [EMAIL PROTECTED]
> Phone 1.212.545.1232 x204 Fax 1.212.545.0938
>
> ------------------------------------------------------------------------------
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
