Re: retail integration
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 26563
interpreted = N
texte = > I am looking for recommendations on how best to integrate a WebCat-driven> web database and a local desktop database that is in a retail store.> One reason that I would want to do this is for inventory checking.> Another reason would be for database administration (i.e., using a> Point-of-Sale system or local desktop database app to administer the> database rather than building web-based admin). I am interested in> finding out how others are handling this situation and whether your> implementations are working well. One scenario would be to sync up the> databases once per day or something, but this seems a bit cumbersome. Is> there a better way to integrate the web-based and desktop-based databases> in more real-time fashion?I would recommend that they access the same db source, if you can access thepos system with ODBC, this should work well. I would try to stay away fromsyncing as it could cause data consistency problems if an item is soldonline and in the store, the quantity may go negative.Just an idea,Jason Tylerwww.3ip.net-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to
.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
Associated Messages, from the most recent to the oldest:
> I am looking for recommendations on how best to integrate a WebCat-driven> web database and a local desktop database that is in a retail store.> One reason that I would want to do this is for inventory checking.> Another reason would be for database administration (i.e., using a> Point-of-Sale system or local desktop database app to administer the> database rather than building web-based admin). I am interested in> finding out how others are handling this situation and whether your> implementations are working well. One scenario would be to sync up the> databases once per day or something, but this seems a bit cumbersome. Is> there a better way to integrate the web-based and desktop-based databases> in more real-time fashion?I would recommend that they access the same db source, if you can access thepos system with ODBC, this should work well. I would try to stay away fromsyncing as it could cause data consistency problems if an item is soldonline and in the store, the quantity may go negative.Just an idea,Jason Tylerwww.3ip.net-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .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
Jason Tyler
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:
A multi-processor savvy WebCatalog? (1997)
problems with WebCat-Plugin (1997)
Pgp&emailer (1997)
Multiple Passwords (1997)
Chatroom (2000)
Disappearing data (2002)
Bug Report, maybe (1997)
Press Release hit the NewsWire!!! (1997)
WebCat editing, SiteGuard & SiteEdit (1997)
Multiple Ad databases? (1997)
setcookie getcookie on the same page (2003)
Help with Shipping Costs (1997)
Trouble with formula.db (1997)
Multiple prices (1997)
[MATH] and Dates (1998)
linetiems in thankyou.tpl (1997)
How to Ignore Your Best Customers (2003)
purchase plugin (1996)
Major bug report on rootbeer (1997)
[FoundItems] solved - thanks (1997)