Re: Updating product information
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 40744
interpreted = N
texte = 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 >> >> >> ------------------------------------------------------------- >> 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 > digest@talk.smithmicro.com> >> 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 digest@talk.smithmicro.com> > 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:
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 >> >> >> ------------------------------------------------------------- >> 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 > digest@talk.smithmicro.com> >> 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 digest@talk.smithmicro.com> > 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/
Alisha Outridge
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:
[UPPERCASE] (1997)
macosx 1 process, linux N processes, macosx chokes under load (2001)
What file? (1997)
Online reference (1997)
CloseDataBase vs CommitDataBase (2007)
database with 10,000+ web pages stored in it? (2000)
Sandboxes & Kitty Litter trays (2003)
[REPLACE] inside [FOUNDITEMS] (1998)
Search for 20 finds 2000, 200 Why? (1997)
webcat (2000)
HELP WITH DATES (1997)
Creating main- and sub-category search (1997)
more info on [setlineitems] (1997)
problems with 2 tags (1997)
IE problems persist (2004)
change the number format (1997)
OT: JavaScript question (2001)
View order not right (1997)
Quitting WebMerchant ? (1997)
Authenticate (1997)