Sync a Wordpress with Filemaker

Hello,
how can I sync a Wordpress site to a Filemaker database on a daily basis.?
Can someone point me in the right Direction in a Technical Way.

Briefing:

The Wordpress site needs to mirror/sync a database that is been created through Filemaker.
jhonc66Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jason C. LevineDon't talk to me.Commented:
Easiest way is to use an ODBC connection and then have FileMaker directly access the MySQL server.

http://www.filemaker.com/11help/html/odbc_ess.20.8.html
0
jhonc66Author Commented:
Sorry i am still lost, from Wordpress How would exactly do that so that Wordpress can mirror/sync the data automatically...?
Have you got a sample I can see or Use
0
jhonc66Author Commented:
The link you have given me is fine, but how exactly Wordpress would do it Automatically without having someone to do it.?

How would I access the Database on a daily basis I believe AUTOMATICALLY.?  Just Mirroring whatever changes you have done in Filemaker.?
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

jhonc66Author Commented:
Just to be clear,

I wont have any access to the filemaker pro system, just the SQL it outputs & the URL's of the images it uploads.
0
Jason C. LevineDon't talk to me.Commented:
What, exactly, do you want to synchronize?
0
jhonc66Author Commented:
The database, I want To mirror/Sync it, I repeat "I wont have any access to the filemaker pro system, just the SQL it outputs & the URL's of the images it uploads"
0
Jason C. LevineDon't talk to me.Commented:
Yes, I read it the first time.  Still makes no sense.  WordPress typically uses a MySQL database.  Setting up FileMaker to access MySQL via ODBC will let you link to the live tables through FileMaker and then you can change data as you wish.

If you simply want to download the MySQL database, a simple script would allow that to happen from FileMaker or even more simply using the mysqldump command from the MySQL database.

If you just want to backup the WordPress installations, there are plugins available that will do this and be a lot easier to manage than a cobbled-together solution.
0
jhonc66Author Commented:
It starts in FileMaker but then exports already to MySQL. That's already happening. I can't change that not offer anything that doesn't leverage the existing MySQL db.
So the problem to solve is not FileMaker to Wordpress. Te problem to solve is custom MySQL db to Wordpress.
0
slinkygnPresidentCommented:
The solution for importing custom MySQL into WordPress is to write a SQL import script that matches your custom MySQL into your WordPress WPML schema.  No further detail is possible, because the solution will be different for every custom MySQL database (there is no "standard" FileMaker MySQL export, it's dependent on your particular FileMaker file -- which you don't have access to).

If you can schedule a CSV or XML export out of your MySQL server, you can use WP All Import - http://wordpress.org/plugins/wp-all-import/ to map and execute your import.  It works with CRON so you can set it to do this automatically as a recurring process, like you're looking for.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
WordPress

From novice to tech pro — start learning today.