That would be a great (easy) way to do it.
I don't think I can set up an xls datasource on Linux, can I?
At 08:08 AM 10/16/00 -0500, Billy Cravens wrote:
>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.
---------------------------------------------------------------------------
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.
