It really depends upon the structure of the database, but typically, I'll give the
tables that don't have dependent tables to my clients and tell them to fill 'em up.
---mark
--------------------------------------------------------------
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--------------------------------------------------------------
> -----Original Message-----
> From: Peter Theobald [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, October 15, 2000 9:27 AM
> To: CF-Talk
> Subject: bulk data administration
>
>
> 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?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
