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 theupdate 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 DavisWebmaster / Interactive Media SpecialistGray Loon Marketing Group, Inc. http://www.grayloon.com204 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 theupdate 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 DavisWebmaster / Interactive Media SpecialistGray Loon Marketing Group, Inc. http://www.grayloon.com204 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:
Fufillment e-mail? (1998)
Emailer on NT not working. (1999)
$Replace with [founditems] (1997)
Date outside Orderfile (2006)
WebCommerce: Folder organization ? (1997)
[showif] / [hideif] (1997)
Setting up shop (1997)
Strange intermittent WebDNA problems (2008)
WebCat2b15MacPlugIn - [authenticate] not [protect] (1997)
ElseIf Statements? (2005)
Next X hits (1996)
Moment of Thanks (1997)
How to download a database???/ (2000)
[WebDNA] Sorry, WebCatalog server not running. (2008)
WebCat with WebTen (1998)
passing cart value (2003)
WebCat2: Formulas.db question (1997)
Setting up WebCatalog with Retail Pro data (1996)
[WebDNA] [OT] WebDNA Wiki - need grammar check / suggestions (2009)
[SHOWIF]s and empty arguments (1997)