Heya Mark .. I know your looking for general examples, but let me give you some specific ones:
1. vfp to mySql database creation / xfer tool. Written in VFP, basically is a massive tweak on the GenDBC app to map data types from VFP to mySQL, create the output script IN VFP that can Run on a mySql instance (via SQL Pass Through). 2. Catalog Update System Data Glue (internal name). Written in VFP, targets OSCommerce mySql databases. Run as a 'click the button' type of app, but could be adapted to push data in real time as well based on RI for insert. Takes a catalog dbf, creates temp tables that match the structure of the Catalog tables in OSCommerce, populates said tables, and pushes the data via SPT into a mySql instance. 3. OSCommerce <-> Joomla User Bridge, written in php, with mySql tables. Invoked when a user clicks on 'Order Now' button in Joomla, seeks for user in OSCommerce, if found, continue processing with OSCommerce; if not found, create new OSCommerce Buyer Record and continue Processing. As far as a generalized template to handle this - NO, I don't know of ONE, but I haven't looked too hard either. If you wanted a quick way to map and populate a remote hosted db, say mySql for instance, then you would have to extend a coupla tool sets. For an example, Ed Leafe, the creator of Profox, wrote a beastie that will write the scripts to create mySql tables based on VFP tables, see http://leafe.com/dls/vfp and search for Stru2MySQL . You should be able to extend that and push data how ever you want. For another example - when I have to quickly (down and dirty) push data into an existing db on the net from a wintel boxen running VFP, I do this: 1. get the structure of the remote db/tables. 2. establish a sql connection. 3. scan .. endscan loop (if records < 10 000) that maps the data EXACTLY like its supposed to be (cause I hardcoded it that way) , with a record insert to the backend on each loop of the scan. Your final posit, with detail: < But what I want is a generalised updating system that has templates & rules for each end of an updating process and for it to chunk away in the background keeping the data in synch.> Sounds like you want to write up a php script that can be called from either system (ZenCart or phpBB) that IS INVOKED in a coupla places: 1. new record added in either ZenCart or phpBB 2. overnight system updates. 3. Sucessful Order Processing. IIWY, I'd check into the bridging components available in ZenCart to phpBB and see where you'd need to extend it a bit, to abstract an atomic chunk o data (ie - one record) and see where it goes. HTH - regards [Bill] -- William Sanders / efGroup {rmv the DOT BOB to reply} VFP Webhosting? You BET! -> http://efgroup.net/vfpwebhosting Failing dotNet Project? -> http://www.dotnetconversions.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
