Copy records from FM to MySQL

[Marcwa19197]

Hi,

i have a Filemaker Database with a TableA-fm. This Filemaker Database is hosted on an FMS14-Server, which is configured to use the MySQL-Odbc Driver to connect to an MySQL Server. The Mysql have the same Database and Table structure as the FM have. (TableA-mysql)

now i want to do the following:
Create a layout in FM on TableA-fm which let me enter Data (via Fields) to TableA-fm and simultaneously the same data to TableA-mysql on the MySQL Server. So i would like to have the same records of data in the FM-Table and the MySQL-Table.

Any ideas how to do that automatically, or sync TableA-fm to TableA-mysql? 

[Kris M]

With ESS you can drop a mysql table occurence on the relationship graph and work with it as if it was a Fm table occurence.

http://help.filemaker.com/app/answers/detail/a_id/13613/~/accessing-external-sql-data-sources-%28ess%29-overview-and-troubleshooting

No "sync" required as the MySQL data is live

Edited February 24, 2016 by Kris M

[Marcwa19197]

Okay, i read about it.

but is it possible to write in two tables with one field object?
For example: Field "Name" writes Data in TableA-fm and TableA-mysql.

[Kris M]

you treat the ess table occurrence/fields and any layouts that leverage them as if they were FileMaker native objects. So ask yourself could i do this with native FM objects? if the answer is yes then your answer is probably yes.

To your point.. "For example: Field "Name" writes Data in TableA-fm and TableA-mysql"....why would you want to duplicate data.. just write to TableA-mysql

Edited February 24, 2016 by Kris M

[Marcwa19197]

i dont know if a field object can write into two different tables..

maybe i create an field for the mysql-table (TableA-mysql) and use a lookup-field in the Filemaker Table TableA-fm?

[webko]

Why?

If you use the ESS functions in FileMaker, you are effectively writing to TableA-mysql and working on it through the FileMaker interface (same as any field on a layout) - so the data is written to one place, but looks like it is FileMaker data...

[Marcwa19197]

yes I understand how to use ess and how to work with a table in fm.

but image I have one column in both table (TableA-fm and TableA-mysql) called 'forename'. I place a Field object on a Layout, how can I say that the input of this forename-field should be written in both tables? 

if this is not possible I have to add two field objects.. one for every table. forename-mysql and forename-fm, so the data must be entered twice..

[webko]

The data wouldn't be written in two tables - you would place the TableA-mysql::forename on the layout and just data enter into that.

Looks and acts like FileMaker, but is actually the mysql field. 

So, back to my question - why would you have a duplicate field in FileMaker ?

[ggt667]

This is how I export data from FileMaker to SQL: http://wethecomputerabusersamongst.blogspot.com/2016/03/export-1-filemaker-record-as-xml-for.html

This page: https://github.com/TyrfingMjolnir/FMPXMLRESULT2MYSQL has 2 stylesheets, 1 for table definition, 1 for export of data

Edited March 14, 2016 by ggt667