Re: Updating product information

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 40750
interpreted = N
texte = This logic works: A - B + CJust use a combination of searches, deletes, and appends to accomplish the update as you've outlined it below. On 6/20/02 2:35 PM, Ben Swihart wrote:> Unfortunately, this data that I am getting has no date associated with > each record. I'm not sure how, but I think I have to create a new > database that checks the existing database for matching records - and > ignores the new data if there is an existing match. > > - ben > > > > > > > -----Original Message----- > From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf > Of Brian Fries > Sent: Thursday, June 20, 2002 3:07 PM > To: WebCatalog Talk > Subject: Re: Updating product information > > > Or better yet, use the [math]{[date]}[/math] format for your dates. > This makes life so much easier in so many ways when dealing with > dates in dbs. > > - brian > > > At 2:02 PM 6/20/02, Alisha Outridge wrote: >> Also, use the date format [date %Y%m%d] (ie 20020620) so the gr of >> your search can compare correctly. >> >> On Thursday, June 20, 2002, at 01:37 PM, Alisha Outridge wrote: >> >>> 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 --------------------------------------------------------------------- Clint Davis Webmaster / Interactive Media Specialist Gray Loon Marketing Group, Inc. http://www.grayloon.com 204 Main Street | Evansville, IN 47708 | Phone:812-422-9999 --------------------------------------------------------------------- ------------------------------------------------------------- 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)
This logic works: A - B + CJust use a combination of searches, deletes, and appends to accomplish the update as you've outlined it below. On 6/20/02 2:35 PM, Ben Swihart wrote:> Unfortunately, this data that I am getting has no date associated with > each record. I'm not sure how, but I think I have to create a new > database that checks the existing database for matching records - and > ignores the new data if there is an existing match. > > - ben > > > > > > > -----Original Message----- > From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf > Of Brian Fries > Sent: Thursday, June 20, 2002 3:07 PM > To: WebCatalog Talk > Subject: Re: Updating product information > > > Or better yet, use the [math]{[date]}[/math] format for your dates. > This makes life so much easier in so many ways when dealing with > dates in dbs. > > - brian > > > At 2:02 PM 6/20/02, Alisha Outridge wrote: >> Also, use the date format [date %Y%m%d] (ie 20020620) so the gr of >> your search can compare correctly. >> >> On Thursday, June 20, 2002, at 01:37 PM, Alisha Outridge wrote: >> >>> 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 --------------------------------------------------------------------- Clint Davis Webmaster / Interactive Media Specialist Gray Loon Marketing Group, Inc. http://www.grayloon.com 204 Main Street | Evansville, IN 47708 | Phone:812-422-9999 --------------------------------------------------------------------- ------------------------------------------------------------- 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/ Clint Davis

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:

bug in [SendMail] (1997) Mac/network guy - newsfeed (2004) Sorting error (1997) garbage on page (2000) SEARCH Peram (2003) Set Header Context (1998) Stupid question (2003) Nesting format tags (1997) I'm new be kind (1997) Pithy questions on webcommerce & siteedit (1997) Sorting Numbers (1997) [Webcat 2]Next (1997) Re:What file? (1997) WebCat2 - [format thousands] (1997) math on date? (1997) WCS Newbie question (1997) DrWatson Error! (1999) Text variables do not show (1999) Separate SSL Server (1997) RAM variables (1997)