Re: Updating product information

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 40743
interpreted = N
texte = I do not know what a CSV file is exactly but here's my way of solving that problem with my databases.If you have a modified date field in the CSV file and the webcat databases that is updated with that date each time it is updated you can compare those modified dates and replace only results that have a higher modified date than your webcat DB modified date.Alisha Outridge Spec Simple, Inc. Where the World of Design Connects...On Thursday, June 20, 2002, at 01:28 PM, Ben Swihart wrote:> 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 + C > > In 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 digest@talk.smithmicro.com> > Web Archive of this list is at: http://search.smithmicro.com/ > ------------------------------------------------------------- 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)
I do not know what a CSV file is exactly but here's my way of solving that problem with my databases.If you have a modified date field in the CSV file and the webcat databases that is updated with that date each time it is updated you can compare those modified dates and replace only results that have a higher modified date than your webcat DB modified date.Alisha Outridge Spec Simple, Inc. Where the World of Design Connects...On Thursday, June 20, 2002, at 01:28 PM, Ben Swihart wrote:> 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 + C > > In 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 digest@talk.smithmicro.com> > Web Archive of this list is at: http://search.smithmicro.com/ > ------------------------------------------------------------- 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/ Alisha Outridge

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:

Trouble with formula.db + more explanation (1997) How do I access a shopping cart once it had been moved intothe Completed Orders folder? (2000) Problems with [Applescript] (1997) GrandTotal not right (1997) OR-searching (2000) Execute Applescript (1997) $Quit, $CloseDatabase corrections (1997) [WriteFile] problems (1997) RE: Emailer Set Up (1997) Using [showif] (2000) WebCatalog for Postcards ? (1997) [format xs] freeze (1997) Errata: WCS Newbie question (1997) Or Searches (2004) (1997) OT: Way off-topic: Qmail and Linux (2003) Protecting Images (2003) 3.0 [TEXT] variables (1998) Can't Update records (1997) lookup command (1997)