Jump to content

From FileMaker to the Web


This topic is 6975 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi,

Hi there,

Total newbie here. Will probably be asking more than answering on this Forum section smile.gif

A general question as a start.

How exactly FileMaker can interact with PHP based Intranet and Internet Sites ?

- uploading documents (mainly pdfs from printed FM reports) to the Intranet.

- synchronization of a PHP db

Can these tasks be automated from FileMaker 7 ? Is FileMaker able to generate PHP requests ? At least is it possible to fill a "form" directly from FileMaker ?

Thanks

Link to comment
Share on other sites

Hi,

You may want to check out FX.php. There are two great places to learn more about FX.php www.iviking.org Chris Hansen's site. He create a PHP class that works with FileMaker Pro 5-7, or www.fxforge.net FX.php software that writes PHP code for you.

FX.php is PHP class that interprets the XML output from FileMaker and allows access through a set of pre-defined functions. Once the PHP is processed it generates HTML to the users browser.

Yes, you can upload images, PDF's basically just about any type of file with PHP. There is also a PHP class that works specifically with PDF's.

In Kindness

Link to comment
Share on other sites

Ok thanks,

Let me tell you more then about my specific needs, as I feel the above, if useful, doesn't really meet what I had in mind.

The solution I'm currently developing is a fully customized Project Management solution, involving numerous projects, partners, participants, documents and events, for a European Sponsored Program.

It is a complete rewrite of an old FileMaker 4 solution they've been using for the daily follow up of each project, but that obviously now appears to be limited.

For now 2 years, they've been deploying an Intranet solution so that participants could exchange documents, reports and data within each project, as well as a Web site for the communication side of the Program.

This site is hosted elsewhere and uses MySqL/PHP. Users of the Intranet are given privileges so that one document should be visible from one and not another according to the Project and the person's function.

Though we'd be using FileMaker 7, management has decided that the FileMaker solution wouldn't be, in any way, visible from the outside, so the Internet and Intranet will remain separated from the served FileMaker.

As the new version will act as a document archiver as well as a Project Manager tool, and as each document uploaded to either the WebSite or Intranet should be controlled by the Program Office, I've been asked to find out solutions that would allow to B)

1) have that Form they use for the upload on the Intranet already filled( with document Name, document Path on "our" server, date, privilege set for the document), or if possible and preferably a complete solution interacting with the MySQL querries so that the upload is automated.

2) synchronize and update user accounts on the Intranet

3) change the privilege set for a document directly from within FileMaker

4) synchronize a given number of data from FileMaker Tables to MySql Tables

Is that clear enough. I'm sorry I'm a so poor webmaster at the moment. crazy.gif

I'll be visiting these adresses you gave me anyway as I have so much to catch on this side of the world. smirk.gif

Any other links on the topic or generally related is very welcome.

Link to comment
Share on other sites

I'm not sure if you are going in this direction, but you might want to build your Project Management Application as a web based application. I say that because it's probably more work than necessary to build it using FMP by itself (considering all you want to do).

This way you can use PHP to communicate with BOTH FMP7 and MySQL. If your client is moving form FMP4 to 7, then they are already in for an nice size learning curve.

If it's built right, it will be easier to manage in the long run.

Just a suggestion.

Link to comment
Share on other sites

-In most cases, to send a SQL query to the mySQL server I use the External functions of PDM plugin(more info in its guide).

http://www.planetsg.com/PLANet/PLANet_HowTo/HowTo.htm

http://www.planetsg.com/PLANet/PLANet_HowTo/PDMmysql.htm

http://filemakeradvisor.com/doc/09111

-To create a PDF I use shubec plugin

=details&products[v][id]=883818]http://www.schubec.com/index.php?products[a]=details&products[v][id]=883818

-And to send files via FTP - plugin at:

http://cnsplug-ins.com/index.htm

I do write PHP and to be honest I dont like solutions as FX.php because of previous experiences with the softvers which write code instead of me. But, my attitude shouldnt be a reason to possible check out and what FX.php can do for you.

Link to comment
Share on other sites

This topic is 6975 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.