Re: Updating product information
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 40746
interpreted = N
texte = 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.- brianAt 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/
Associated Messages, from the most recent to the oldest:
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.- brianAt 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/
Brian Fries
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:
writing orders to a db (1997)
Associative lookup style? + bit more (1997)
Order file numbers diferent than the cart number. why? (2000)
Double Spacing in Mails from Sendmail (2002)
OS X Problem... (2000)
Sku numbers (1997)
embedded showif statements (2000)
A little syntax help (1997)
Heads up: WebCatalog 4 drops MacTCP, 68K (2000)
creating an index based on first letter of word inspecific field in database (2002)
AAgghh!! Help, please. SSL strikes again. (1997)
[WebDNA] Ubuntu 16.04.4 LTS (2018)
WCS Newbie question (1997)
WebCat for Site Search? (1997)
passing large amount of text in post form (2005)
[WebDNA] proxy server domains mysteriously appear in webdna's domain list (2010)
Location of Webcat site in folder hierarchy (1997)
Re:emailer 150 (1997)
Not really WebCat - need HTML Grider (1997)
WebCat2b13MacPlugIn - More limits on [include] (1997)