Re: Updating Prices in Online Database
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23264
interpreted = N
texte = Thank you for your response. However, wouldn't this simply append new records? I just want to replace the one field (price) but want to leave the other fields untouched (the database from which we export the updated prices does not contain the same fields as the online database). It looks like you are replacing the entire record, not just some of the fields in the record, right?Gil Poulsen wrote:> Try putting the new records in the same directory as the main database, > paste this into a template (modified with your fields, of course) and > just hitting it with your browser: > > [search db=newrecords.db&neskudatarq=[blank]&max=8000] > > [FoundItems] > > [Append db=yourdatabase.db]sku=[sku]&title=[URL][title][/URL]&author=[author]&description=[URL][description][/URL]<ext=[ltext]&lprice=[lprice]&stext=[stext]&price=[price]&locator=[URL][locator][/URL]&mhseq=[mhseq]&mhgroup=[mhgroup]&liseq=[liseq]&ligroup=[ligroup]&faseq=[faseq]&fagroup=[fagroup]&flseq=[flseq]&flgroup=[flgroup]&hiseq=[hiseq]&higroup=[higroup]&bbseq=[bbseq]&bbgroup=[bbgroup]&new=[new]&bigsell=[bigsell]&video=[video]&forthcoming=[forthcoming]&reduced=[reduced][/Append] > > [/FoundItems] > >
[numfound] records have been added per your request. > > [/search] > > It takes about 45 seconds to process this on my 6100/G3; typically I am > updating about 3,000 records to a 10,000 record database. > > Mike Eberly wrote: > > > > I would like to write a merge WebDNA that searches thru a temporary > > (updated) database and does a [replace] on the main database. I had > > posted this in the past and someone from Technical support had suggested > > creating a separate db with just the sku number and price fields. This > > would be an easy solution, however I would like to keep the database > > together for other reasons (instead of pulling info from two different > > db's). Does anyone have a code already developed which is similar to > > what I am looking for? > > > > >Basically, I would like to be able to export everything from our > > >off-line database, create a temporary online database with the > > >exported info, be able to compare the part numbers in the temporary > > >database with the part numbers in the Catalog.db and when it finds > > >matching part numbers, replace the price field in the Catalog.db with > > >the price in the temporary database. > > > > Thanks for your help. > > > > Mike
Associated Messages, from the most recent to the oldest:
Thank you for your response. However, wouldn't this simply append new records? I just want to replace the one field (price) but want to leave the other fields untouched (the database from which we export the updated prices does not contain the same fields as the online database). It looks like you are replacing the entire record, not just some of the fields in the record, right?Gil Poulsen wrote:> Try putting the new records in the same directory as the main database, > paste this into a template (modified with your fields, of course) and > just hitting it with your browser: > > [search db=newrecords.db&neskudatarq=[blank]&max=8000] > >
[founditems] > > [Append db=yourdatabase.db]sku=[sku]&title=
[url][title][/URL]&author=[author]&description=
[url][description][/URL]<ext=[ltext]&lprice=[lprice]&stext=[stext]&price=[price]&locator=
[url][locator][/URL]&mhseq=[mhseq]&mhgroup=[mhgroup]&liseq=[liseq]&ligroup=[ligroup]&faseq=[faseq]&fagroup=[fagroup]&flseq=[flseq]&flgroup=[flgroup]&hiseq=[hiseq]&higroup=[higroup]&bbseq=[bbseq]&bbgroup=[bbgroup]&new=[new]&bigsell=[bigsell]&video=[video]&forthcoming=[forthcoming]&reduced=[reduced][/Append] > > [/FoundItems] > >
[numfound] records have been added per your request. > > [/search] > > It takes about 45 seconds to process this on my 6100/G3; typically I am > updating about 3,000 records to a 10,000 record database. > > Mike Eberly wrote: > > > > I would like to write a merge WebDNA that searches thru a temporary > > (updated) database and does a
[replace] on the main database. I had > > posted this in the past and someone from Technical support had suggested > > creating a separate db with just the sku number and price fields. This > > would be an easy solution, however I would like to keep the database > > together for other reasons (instead of pulling info from two different > > db's). Does anyone have a code already developed which is similar to > > what I am looking for? > > > > >Basically, I would like to be able to export everything from our > > >off-line database, create a temporary online database with the > > >exported info, be able to compare the part numbers in the temporary > > >database with the part numbers in the Catalog.db and when it finds > > >matching part numbers, replace the price field in the Catalog.db with > > >the price in the temporary database. > > > > Thanks for your help. > > > > Mike
Mike Eberly
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:
setting line item numbers (1998)
Problem with [Search] inside of [Loop]? (1997)
rotating thumbnails (1997)
[isfolder] and [filename] (1997)
Form Weirdness (2002)
why why why (2004)
Protecting Realms (was: IIS Brain Dead) (1998)
Trouble with Showif and Search (1998)
Summary search -- speed (1997)
[WebDNA] Using WebDNA with MAMP (2010)
Allow-Deny: Solved with [Getchars] (1998)
wierd [cart] action! (1997)
Need relative path explanation (1997)
No more misunderstanding ... yay! :) (1997)
TCPConnect / Current Temperature (2004)
WebCat for Unix?? (1997)
Not really WebCat (1997)
updating with ProductEditor (1998)
Problems appending to database (1997)
Troubles with Selection Drop Down List Search (1998)