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

[Kieran Lal]

if you are doing customer relationship data I would recommend  
CiviCRM.  They have CSV imports and exports.  They have also been  
developing plug-ins for synchronizing with clients like outlook.

Node import allows for importing of content in CSVs.  Some times  
simple just works.

Kieran
On Dec 15, 2005, at 9:31 AM, 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
>