Uploading a new database

This WebDNA talk-list message is from

2001

It keeps the original formatting. numero = 39902
interpreted = N
texte = Hi there,I've set up a facility for clients to upload their own databases... (GASP) This is a concern for a number of reasons:* Clients are inherrently dumb (only joking)* The have to upload a tab-delimited text file, where each record has a unique number (SKU) (it's only two fields though - SKU and email address)* The file must end with a CR ready for the next record (which WebC creates an SKU for)* If they don't create unique numbers...........Each of these has the potential to be a problem. At the moment, they upload the file, it renames the file to db name, flushes databases, and they're ready to go (assuming they've done it correctly).A client just asked if he could use a comma-separated file. No I said. Is there a way of making this more efficient. It would be easier if they could just upload a list without SKUs, and WebCat put them in. Is any of that possible? Any thought or ideas would be greatly appreciated.Regards,TimTim RobinsonArt Directorimagine onlinetim@imagine.com.auhttp://www.imagine.com.au-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

Re: Uploading a new database (Alain Russell 2001) Uploading a new database (Tim Robinson 2001)

Hi there,I've set up a facility for clients to upload their own databases... (GASP) This is a concern for a number of reasons:* Clients are inherrently dumb (only joking)* The have to upload a tab-delimited text file, where each record has a unique number (SKU) (it's only two fields though - SKU and email address)* The file must end with a CR ready for the next record (which WebC creates an SKU for)* If they don't create unique numbers...........Each of these has the potential to be a problem. At the moment, they upload the file, it renames the file to db name, flushes databases, and they're ready to go (assuming they've done it correctly).A client just asked if he could use a comma-separated file. No I said. Is there a way of making this more efficient. It would be easier if they could just upload a list without SKUs, and WebCat put them in. Is any of that possible? Any thought or ideas would be greatly appreciated.Regards,TimTim RobinsonArt Directorimagine onlinetim@imagine.com.auhttp://www.imagine.com.au-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Tim Robinson

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

using showpage and showcart commands (1996) Linux ODBC and the ODBC Bridge (2000) Summing fields (1997) Can a database get stomped by simultaneous access? (1997) [listfiles] (2004) Problem with updating to 2.1.1 (1998) database paths/names, and a typo (1997) Problem displaying search result (1997) expired beta (1997) New Plug-in and Type 11 errors (1997) RE: Adding a product from another site (1997) User that WebCatalog/Unix runs as (2000) Re:Variable Math (1998) International Orders (1998) E-Mail (1998) Generating Report Totals (1997) TaxTotal Problem (1997) [WebDNA] [BULK] The WebDAV Server Module / web services (2012) Quit revisited (1997) Group search doesn't work. (1997)