Re: Updating product information
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 40749
interpreted = N
texte = 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-- <= Brian C. Fries, BrainScan Software http://www.brainscansoftware.com => <= Macintosh, Internet and Multimedia http://www.artsofauburn.com => <= Development and Consulting =>------------------------------------------------------------- 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/ ------------------------------------------------------------- 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:
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-- <= Brian C. Fries, BrainScan Software http://www.brainscansoftware.com => <= Macintosh, Internet and Multimedia http://www.artsofauburn.com => <= Development and Consulting =>------------------------------------------------------------- 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/ ------------------------------------------------------------- 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/
Ben Swihart
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:
Formating Tables w/[founditems] (1998)
Field name-subcategory (1997)
anyone integrated inventory w/ storebuilder? (2003)
Need relative path explanation (1997)
SKU generator? (1998)
[WebDNA] [BULK] which of these tags exist in 7.0 (2011)
Math Function (1997)
WebSTAR/WebCat is serving .db files! (1999)
WebCatalog 2.0 b 15 mac (1997)
Kanji in http requests (1998)
[text] doesn't change [formvariables] (1999)
CommitDatabase vs. CloseDatabase (2001)
AE aware WebCatalog.acgi? (1997)
Large founditems loops (2000)
NT vs Mac (1997)
Digger URLs ... (2004)
WebDNA performance comparisons? (2004)
emailer error -108 (1997)
Protect vs Authenicate (1997)
syntax question, not in online refernce (1997)