Can I call a php page through FileMaker

[Jalz]

Hi

Is it possible to call a php page from ScriptMaker? I'm transferring some data out of FileMaker via ODBC into a MySQL table. Once the data is inside te MySQL table (which I've already got it to do through the Execite SQL command ), I would like "activate" a php page which runs a script to manipulate that data so it is usable. Is this possible natively or do I have to go through the plugin route?

[Genx]

... What are you doing with the data with PHP that you can't do before hand in FileMaker?

[Jalz]

Hi Alex,

Im trying to get data out of FileMaker into Moodle an opensource VLE program. I'm using Execute SQL to populate the moodle table (MySQL) which works fine. Moodle has a Import option through the use of a php page, which allows you to import a csv file into a temp table and then manupulate the data from that CSV file into the necessary tables. I thought I could fire off that page once I have my data uploaded in the temp table.

Im actually getting through this slowly, by populating each table I need as Moodle is seriously normalized…just thought if I could fire off the update.php file it would be far more easier to code perhaps and a little bit more interesting :….

[Genx]

Well you could fire it by referencing the php file in a web viewer ... but it would be hard to prevent the script firing multiple times should the window refresh.