[consulting] Synchronizing data between a desktop database application and Drupal/mysql

[Gordon Heydon]

Hi,

Yes, If php gtk2 had been released then I would have considered doing
the offline application myself, then it would have been a complete cross
platform offline application for this project.

Gordon.

On Thu, 2005-12-15 at 22:49 -0500, Steve Dondley wrote:
> Gordon,
> 
> I understand what you are doing but don't have the expertise to carry
> it out myself.  Can the vb application be used as a go between for
> foxpro and mysql is what I'm wondering.
> 
> Thanks,
> Steve
> 
> On 12/15/05, Gordon Heydon <gordon at heydon.com.au> wrote:
> > Hi,
> >
> > I am not so much doing the sync at the database level but more the
> > application level. Basically all I am going to do is provide a XML-RPC
> > interface to allow the offline program to query the database in a more
> > machine readable way.
> >
> > Also this should provide things like drupal permissions and only allow
> > access to nodes and other data that they have access to.
> >
> > So the remote application can send commands to get the data that it
> > requires and then put it into the offline database. This will include
> > things like a query option, read and write. It also means that I can do
> > things like track changes and who did what.
> >
> > This also means that I can leave the actual data comparison to the VB
> > application, and it can send me only the updates.
> >
> > You could implement something similar, and have a service on the windows
> > machine either check periodically for new trainees, or a type of ping
> > option which the web site will ping the service to do the update when a
> > new trainee comes along.
> >
> > I am still in early stages, but this should work. You could implement
> > something similar.
> >
> > Gordon.
> >
> > On Thu, 2005-12-15 at 21:59 -0500, Steve Dondley wrote:
> > > Interesting.  Do you think your work would be useful to syncing FoxPro
> > > with a mysql database?
> > >
> > > On 12/15/05, Gordon Heydon <gordon at heydon.com.au> wrote:
> > > > Hi,
> > > >
> > > > I have got a job coming up that is going to be doing some synchronising
> > > > of data between the web site and a VB application that can be used to
> > > > view and update data offline.
> > > >
> > > > Basically my idea is that the transport will be xml-rpc so that
> > > > application can talk directly to the web site, and the copying of data
> > > > can be interactive so that if an update has been made on the site and on
> > > > the offline application the conflict can be resolved.
> > > >
> > > > This also means that there doesn't need to be any messing about with csv
> > > > files and the like. Also I think that this can be dove tailed with
> > > > active sync so that the sync is a little more intelligent.
> > > >
> > > > Gordon.
> > > >
> > > > On Thu, 2005-12-15 at 12:31 -0500, Steve Dondley wrote:
> > > > > I've got a client who uses a custom software solution based on FoxPro
> > > > > for tracking job trainees.  In the future, he wants to integrate and
> > > > > share this data with his web site.  For example, a trainee might visit
> > > > > the site and register for a class there.  He'd like to have his local
> > > > > database reflect this new applicant.  Or, he might want to create a
> > > > > new class in his database locally and have it listed on the site.
> > > > >
> > > > > A sister organization to my client's was able to achieve this for
> > > > > about $7K using ASP.NET.  I'd like to be able to offer an open source
> > > > > solution and have it integrated with the Drupal site I'm moving them
> > > > > to.
> > > > >
> > > > > I've done only minimal work synchronizing a proprietary front end
> > > > > database program (Microsoft Access) with a mysql database.  This is
> > > > > not an area I'm familiar with.  So first I'm wondering if someone
> > > > > could comment of the feasability of using FoxPro as a front end to a remote
> > > > > mysql database.  Second, I'd be interested to know if anyone
> > > > > is interested in being a subcontractor or if anyone knows someone I should
> > > > > get in touch with.  Note that this could lead to more work for other sister
> > > > > organizations of my client.
> > > > >
> > > > > --
> > > > > Dondley Communications
> > > > > http://www.dondleycommunications.com
> > > > >
> > > > > Communicate or Die: American Labor Unions and the Internet
> > > > > http://www.communicateordie.com
> > > > > _______________________________________________
> > > > > consulting mailing list
> > > > > consulting at drupal.org
> > > > > http://lists.drupal.org/mailman/listinfo/consulting
> > > > >
> > > > >
> > > > >
> > > >
> > > > _______________________________________________
> > > > consulting mailing list
> > > > consulting at drupal.org
> > > > http://lists.drupal.org/mailman/listinfo/consulting
> > > >
> > >
> > >
> > > --
> > > Dondley Communications
> > > http://www.dondleycommunications.com
> > >
> > > Communicate or Die: American Labor Unions and the Internet
> > > http://www.communicateordie.com
> > > _______________________________________________
> > > consulting mailing list
> > > consulting at drupal.org
> > > http://lists.drupal.org/mailman/listinfo/consulting
> > >
> > > 
> > >
> >
> > _______________________________________________
> > consulting mailing list
> > consulting at drupal.org
> > http://lists.drupal.org/mailman/listinfo/consulting
> >
> 
> 
> --
> Dondley Communications
> http://www.dondleycommunications.com
> 
> Communicate or Die: American Labor Unions and the Internet
> http://www.communicateordie.com
> _______________________________________________
> consulting mailing list
> consulting at drupal.org
> http://lists.drupal.org/mailman/listinfo/consulting
> 
> !DSPAM:1000,43a23bd173382006516185!
>