msteer

I've installed FX.php and got it to connect to a test system (PIII, 400Mhz, 160MB) we've set up to develop the link. I activated the plugin and made the databases available for sharing. The php program can list the databases and the layouts, but reading data is taking ages... This morning the program ran 3,5 hours, and it wasn't even finished. FM Pro keeps on processing. Based on the documentation, I think it has to do with the layout. I don't have access to the layouts, so I cant set up a specific one for the model. Can the layout be the problem here, or is the test system too minimal?

I've installed FX.php and got it to connect to a test system (PIII, 400Mhz, 160MB) we've set up to develop the link. I activated the plugin and made the databases available for sharing. The php program can list the databases and the layouts, but reading data is taking ages... This morning the program ran 3,5 hours, and it wasn't even finished. FM Pro keeps on processing. Based on the documentation, I think it has to do with the layout. I don't have access to the layouts, so I cant set up a specific one for the model. Can the layout be the problem here, or is the test system too minimal?

I've installed FX.php and got it to connect to a test system (PIII, 400Mhz, 160MB) we've set up to develop the link. I activated the plugin and made the databases available for sharing. The php program can list the databases and the layouts, but reading data is taking ages... This morning the program ran 3,5 hours, and it wasn't even finished. FM Pro keeps on processing. Based on the documentation, I think it has to do with the layout. I don't have access to the layouts, so I cant set up a specific one for the model. Can the layout be the problem here, or is the test system too minimal?

Theere is no user interfacing in the forecasting model. We dump data in csv files from the FM database, the PHP model puts that in MySQL and calculates forecasts. At the moment we're making prints and typing the forecasts in the FM user interface... We'd like to feed that information automatically, and have the users overrule the forecasts if needed in the FM application they use for their daily business. So all user interaction is in the FM application, none in the forecast model.

Thanks for the step-by-step instruction! As you may have understood I am quite a newbie on FM, and I am trying to get it clear... so this will also update the database on the server to all other clients, right? Or is there more to do to get that done? If this is all we have to do, I guess we shouldn't go through all the hassle by reprogramming the model into Filemaker, but just use the PHP/MySQL model and link things up via FX.php.

Ok, so I need to enable the web companion on a client. Then, using FX.php my PHP/MySQL can read from and write data to the shared FM databases via the client to server. Correct? What does "unlimited" mean?

We can not access the web companion with the url. We did replace the <myip>, <port> and <mydb> fields. We think the plugin is not activated, so we'll check that first. Is there an easy step-by-step instruction how to activate and configure the plugin? BTW: it's FM 5.5 Server.

A friend of mine has his sales information in FM 5.5. I created a forecasting model with PHP/MySQL, exporting and importing data via CSV files. The model is working great and we'd like to put things in daily operation. We're not sure what to do: re-programming the model in FM, or linking up FM/PHP. What's your take based on your experience? Does FX.php work on FM 5.5?