CODEWITHSUNDEEP
mysqlimportodbcfilemaker
Boris Kamp
Boris Kamp

Reputation: 51

publishing Filemaker (database software) data on Wordpress website

We would like to be able to publish Filemaker data on our Wordpress website. The website is up and running and the filemaker database is set up. We do not need a live connection between both systems so we chose to export the FM data to .csv so we can import it to the mysql database on the server and from there we would like to display in on the website.

Now are my questions, since this kind of development is new to us:

can I setup an automated import to the mysql database from a source like dropbox or something? For example can we make the mysql database import and overwrite the existing database each 24 hours from a .csv file located somewhere? We need this automated overwrite option because the FM data changes often and we need up to date info on the website)

How can we display the data from the mysql database on the WP frontend?

I've been looking into this myself and couldn't find any clear answers or guides. Can you guys point me in the right direction?

(btw, I know there are table plugins I can use for WP but they do not fulfill our needs, and I think it's exciting to do it all by ourself with help from this great community)

Update 01

I've successfully connected FM with my MySQL db using ODBC and can now select tables from the MySQL db in FM's relational graph. I was wondering how I can write the data from my existing FM file to the MySQL db using ODBC, can anybody help me on this? I would like to display the data in some MySQL tables so I can fetch them using php on my website.

Thanks!

Upvotes: 0

Views: 2011

Answers (2)

blag
blag

Reputation: 1

Once you have made the connection to the MySQL database, and you can see the shadow tables, you can write to the fields directly via Filemaker layouts. It's as simple as that. Once the layout contains the fields from the MySQL database you can move through records, find stuff all as if the data were native in your FM database. Of course, for more automated processing, you can create scripts, relationships etc and manipulate/synchronise data. Be warned though, the connection speed can limit complex relationships and large databases. I would advise 'baby steps'.

Upvotes: 0

Jens Teich
Jens Teich

Reputation: 337

It is possible to write directly into (and read from) a remote MySQL database from FileMaker via ODBC.

You need an MySQL account which allows remote access. There are providers where this is not allowed.

On the local box the odbc driver needs to be installed. On Win you can use the open source version (http://dev.mysql.com/downloads/connector/odbc/), on Mac it works better with the Actual Tech (http://www.actualtech.com/de/product_opensourcedatabases.php) drivers.

An odbc system dsn (not user dsn) is set up. Be sure to use the 32-bit odbc manager on Win.

Now you can create the external data source within FileMaker and read and write into MySQL tables.

Upvotes: 0

Related Questions