Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

Jacko30

macrumors newbie
Original poster
Dec 15, 2009
9
0
Ok, so here is the situation....
We use filemaker pro to run a set of databases to manage the timing for a mountain bike race. One database contains a list of rider and another contains a record for each lap that is completed. These laps are then sorted in various ways to compile results in a pdf form. These pdfs are then hosted on a local intranet at the race so people can use their wifi devices to look up the results. The problem is that these pdfs then have to be updated manually and transferred to a separate computer to host the intranet website which only gets done about every hour or so. People want live results (or semi-live) and I can't think of a way to do this. Users can't access the databases directly as this would cripple the network (there are like 10,000 records). I am thinking exporting new results at regular intervals to an SQL database and then hosting that on the intranet via a php website of some sort. However my knowledge of SQL and PHP are very limited... any suggestions would be kindly appreciated.
 
Simple idea

If the data doesn't need to be dynamically updated why not just export the data as HTML (write scripts to create these files when needed) and cut out any other database. You could break it into chunks to ease navigation and have a preprepared index page that links to the exported files which you could upload to your website. I don't think it would look that pretty, but would be quick and functional.
 
If the data doesn't need to be dynamically updated why not just export the data as HTML (write scripts to create these files when needed) and cut out any other database. You could break it into chunks to ease navigation and have a preprepared index page that links to the exported files which you could upload to your website. I don't think it would look that pretty, but would be quick and functional.

That could be a possiblity, simple too. Coupled with a CSS I can try and make it work. Thanks. Willing to accept alternatives too
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.