Re: Updating Prices in Online Database
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23265
interpreted = N
texte = In this connection, I am wondering if it is not easier to do that in your offline db. Let's say you use File Maker Pro. Have the two db's compared with each other and then merge, then export and upload to your Server.I am just looking into this, since I will have to update my *.db on a 3 day basis.Maybe anybody has any code or expiriences to share? Please. Sincerely, Nitai*** MacTrade - http://www.mactrade.ch More Mac for your money EMail: Info@mactrade.ch Fax: 052 / 654 15 59 ***> 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]&descri ption=[UR > L][description][/URL]<ext=[ltext]&lprice=[lprice]&stext=[stext]&price=[pri ce]&locat > or=[URL][locator][/URL]&mhseq=[mhseq]&mhgroup=[mhgroup]&liseq=[liseq]&ligrou p=[ligrou > p]&faseq=[faseq]&fagroup=[fagroup]&flseq=[flseq]&flgroup=[flgroup]&hiseq=[hi seq]&higr > oup=[higroup]&bbseq=[bbseq]&bbgroup=[bbgroup]&new=[new]&bigsell=[bigsell]&vi deo=[vide > o]&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:
In this connection, I am wondering if it is not easier to do that in your offline db. Let's say you use File Maker Pro. Have the two db's compared with each other and then merge, then export and upload to your Server.I am just looking into this, since I will have to update my *.db on a 3 day basis.Maybe anybody has any code or expiriences to share? Please. Sincerely, Nitai*** MacTrade - http://www.mactrade.ch More Mac for your money EMail: Info@mactrade.ch Fax: 052 / 654 15 59 ***> 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]&descri ption=[UR > L][description][/URL]<ext=[ltext]&lprice=[lprice]&stext=[stext]&price=[pri ce]&locat > or=
[url][locator][/URL]&mhseq=[mhseq]&mhgroup=[mhgroup]&liseq=[liseq]&ligrou p=[ligrou > p]&faseq=[faseq]&fagroup=[fagroup]&flseq=[flseq]&flgroup=[flgroup]&hiseq=[hi seq]&higr > oup=[higroup]&bbseq=[bbseq]&bbgroup=[bbgroup]&new=[new]&bigsell=[bigsell]&vi deo=[vide > o]&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 >
Nitai
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:
WebCat2b12 - nesting [tags] (1997)
Showing specific [cart] contents (1998)
Concatenating Form Variables (1998)
WebMerchant 3.0? (1998)
Credit card types (1997)
Cookie set browser session. (1998)
WebDNA tags in WebMerchant email templates ... (1997)
WebCat2final1 crashes (1997)
Shopping cart not being assigned (1999)
shipping costs (2000)
[searchString] (1997)
Card clearance, problems - solutions? (1997)
WebCatalog 2.0 b 15 mac (1997)
searching multiple databases in single search (1997)
Applescript error (1998)
emailer setup (1997)
WebCat2b12 CGI Mac -- Problems propagating the cart through (1997)
WebCatalog Use Question (1997)
generate sequential numbers (2000)
transferring values (1998)