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:
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:
ShowNext (1997)
[/application] error? (1997)
Tax Collection for Different Items (2003)
WC1.6 to WC2 date formatting (1997)
WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997)
WebCatalog2 Feature Feedback (1996)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
emailer on Windows Beta 18 (1997)
OT: PDA Browser Emulator (2006)
OT - Mail Solution (2002)
referrer usage (1997)
[WebDNA] Convert to PDF (2009)
snicker, snicker (1997)
wc 2 pro users - sites, quotes wanted (1997)
frames & carts (1997)
[OT] HTML render (2003)
Storebuilder SOLVED!!!!!!! (2003)
IIS4b2 and WebCatalog b19 (1997)
really wierd browser truncating (1997)
WebCat Error Log problem (2.0.1, acgi, Mac) (1997)