Updating product information

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 40742
interpreted = N
texte = A client has as CSV file that has products. He goes to the web, uses our webdna online file uploader to upload his product inventory. My question: Is there a way for me to only accept the NEW products? I realize it would be easiest if the client could just overwrite the database each time, but for my needs, I really need to compare the new data with the old data:A = (Products in old data file that are also in new data file) B = (Products in old data file that are not in new data file) C = (Products in new data file that are not in old data file)Final data should be:A - B + CIn english: I want his database to only contain products that are present in the new uploaded file, but I don't want to overwrite any of the existing products that are in stock becauase they may have made web-only changes to them.Any idea how to approach this problem? Ben Swihart, Web Designer and SysAdmin Gotricities Network ------------------------------------------------------------- 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:

    
  1. Re: Updating product information (Brian Fries 2002)
  2. Re: Updating product information (Clint Davis 2002)
  3. Re: Updating product information (Ben Swihart 2002)
  4. Re: Updating product information (Brian Fries 2002)
  5. Re: Updating product information (Alisha Outridge 2002)
  6. Re: Updating product information (Alisha Outridge 2002)
  7. Updating product information (Ben Swihart 2002)
A client has as CSV file that has products. He goes to the web, uses our webdna online file uploader to upload his product inventory. My question: Is there a way for me to only accept the NEW products? I realize it would be easiest if the client could just overwrite the database each time, but for my needs, I really need to compare the new data with the old data:A = (Products in old data file that are also in new data file) B = (Products in old data file that are not in new data file) C = (Products in new data file that are not in old data file)Final data should be:A - B + CIn english: I want his database to only contain products that are present in the new uploaded file, but I don't want to overwrite any of the existing products that are in stock becauase they may have made web-only changes to them.Any idea how to approach this problem? Ben Swihart, Web Designer and SysAdmin Gotricities Network ------------------------------------------------------------- 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/ Ben Swihart

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:

WebCatalog 3.0.8 is on FTP... (2000) question: webmerchant connection (1997) redirect not passing vars (2004) shipping calcs (1998) oops private message leaked into talk list (1997) encrypt/decrypt password with authenticate (2002) Claris HomePage messes up the code (1997) WebCat2b13MacPlugin - [math][date][/math] problem (1997) RE: IIS 4 (1998) [countWords]? (1997) Searching multiple fields from one form field (1997) Frames and WebCat (1997) AAgghh!! Help, please. SSL strikes again. (1997) Caching [include] files ... (1997) Configuring E-mail (1997) Migrating to NT (1997) SetHeader (1999) Multiple cart additions (1997) 2.0 Info (1997) Single Link browsing (1997)