nrc

mySQL

Discussion created by nrc on Sep 20, 2018
Latest reply on Sep 26, 2018 by nrc

Hello, just looking for some general thoughts / being pointed in the right direction.

 

We are a music school and manage our student database via FileMaker. We have a local server and a number of  clients for admin staff. Enrolments are done via a website form which populates a remote mySQL database.

 

I'd like to see Filemaker talk directly to the mySQL database to retrieve the enrolments. The FM interface would:

- only retrieve data since last import

- allow for viewing and editing of data before importing into local DB

- process the data to look for duplicate customers and enrolments, so that the correct decisions can be made around "creating new" or "adding to existing"

 

I realise this is complicated, but some 'ballpark' suggestions would be welcome. Thanks.

Outcomes