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:
BUG in [showif] using ^ (contains) (1997)
Emtpy Files (2006)
WebCat2: Found Items syntax, etc. (1997)
Macauth: Dates and No Scripting... (1997)
Now you see it now you donīt (1997)
Users and groups for local directories (1999)
Reversed words (1997)
Can't load tmpl files (1997)
Locking up with WebCatalog... (1997)
webCatalog and Stocks (1998)
WebDNA Solutions ... sorry! (1997)
Frames and WebCat (1997)
[SHOWIF AND/OR] (1997)
math and european notation (1998)
Criticism of WebCatalog: Keep It Coming! (1998)
WebDNA deletes major DB data big time (2004)
Only charge card when product shipped ? (1997)
Will webdna execute before a [redirect]? (1999)
[WebDNA] File not found when trying to install WebDNA on Debian (2016)
One more try (1997)