Accessing FP data from external programs (MS Assess)

[Tim Fischer]

Well, apparently this has generated some interest.  I can't go into too 
much detail, simply because I developed it for my employer.  They own 
it, I do not.  I could talk to my boss to see how he feels about sharing 
it if the interest is there.

Basically, the system is this.  We have a script that works as a mySQL 
client.  We simply feed the data through this client and it updates the 
mySQL database.  To sync the other way, we do the same thing in 
reverse.  The submit function calls a report which syncs the two records.

No third party software, outside of MySQL and the OS on both servers, is 
involved.  I don't know if this would integrate with any database system 
other than MySQL, simply because I have never done it.  My instincts 
would tell me that it would, but there would be a good deal of 
programming needed to make the switch.

The system is very dynamic - it is very easy to drop in for other 
tables. Once we had the base system setup, it's a matter of copying code 
and dropping it into place.

We've had this up and running for over a year now with minimal issues.  
I'm sure I've talked about it on the list before - I guess no one read 
my emails before??

Tim Fischer




Walter Vaughan wrote:

> Tim Fischer wrote:
>
>> Actually, I do this now.  I have a filepro database that, whenever 
>> updated, it writes to a mysql database on a different server.  The 
>> great part is, we have created the ability to update this information 
>> from the web, and it also keeps the FP table in sync.
>
>
> How are you writing changes from MySQL to filePro?
> Is your sync one-way or two-way?
> Are you using fpODBC clients or ssh/telnet clients into a Unix server?
>
>> I would be happy to answer any questions you have.
>
>
> Is the solution general in application, or is it quite specific to 
> your instance?
>
> -- 
> Walter
>
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>