Re: Updating Prices in Online Database
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23267
interpreted = N
texte = Well, yes, it is completely replacing existing records with new ones. Imisunderstood your question. In your case you would want to use thereplace context instead and just specify the key field (in my example,it is the sku) and the price field. So assuming that both databases havefields called [price] and [sku], it would look more like this:[search db=newrecords.db&neskudatarq=[blank]&max=8000][FoundItems][Replace db=yourdatabase.db&eqskudatarq=[sku]]price=[price][/Replace][/FoundItems]
[numfound] records have been updated per your request.[/search]The other fields in the database should remain as they are; at leastthey do for me, but if you read the docs it says they will be set toblank, so maybe PCS can clarify this for us.Mike Eberly wrote:> > 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-- Gil Poulsen, Webmaster*************************************************************** AltiM@c * Phone: (908) 222-9001 ** 111 Mali Drive * FAX: (908) 222-9002 ** North Plainfield, NJ * e-mail: help@altimac.com ** 07062-2355 * WWW: http://www.altimac.com ***************************************************************
Associated Messages, from the most recent to the oldest:
Well, yes, it is completely replacing existing records with new ones. Imisunderstood your question. In your case you would want to use thereplace context instead and just specify the key field (in my example,it is the sku) and the price field. So assuming that both databases havefields called [price] and [sku], it would look more like this:[search db=newrecords.db&neskudatarq=[blank]&max=8000]
[founditems][Replace db=yourdatabase.db&eqskudatarq=[sku]]price=[price][/Replace][/FoundItems]
[numfound] records have been updated per your request.[/search]The other fields in the database should remain as they are; at leastthey do for me, but if you read the docs it says they will be set toblank, so maybe PCS can clarify this for us.Mike Eberly wrote:> > 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-- Gil Poulsen, Webmaster*************************************************************** AltiM@c * Phone: (908) 222-9001 ** 111 Mali Drive * FAX: (908) 222-9002 ** North Plainfield, NJ * e-mail: help@altimac.com ** 07062-2355 * WWW: http://www.altimac.com ***************************************************************
Gil Poulsen
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:
Database append/replace (2004)
I'm tired of all this! (2000)
RE: Formulas.db + Users.db (1997)
[format xs] freeze (1997)
Using [purchase] (1998)
Virtual hosting and webcatNT (1997)
Mystery authentication (1997)
TaxTotal Problem (1997)
forming a SKU (1999)
Mozilla/4. and Browser Info.txt (1997)
E-mailer error codes (1997)
test (2006)
WebDNA performance comparisons? (2004)
[WebDNA] SOAP support (2014)
Yet another db manager (2004)
carriage returns in data (1997)
multiple search commands (1997)
Looking up two prices in database? (1997)
wild question (1998)
RE: ShowNext Command (1997)