Web database management - Filemaker Pro

Discussion in 'macOS' started by Jacko30, Apr 21, 2011.

  1. Jacko30 macrumors newbie

    Joined:
    Dec 15, 2009
    #1
    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.
     
  2. ssmed macrumors 6502

    ssmed

    Joined:
    Sep 28, 2009
    Location:
    UK
    #2
    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.
     
  3. Jacko30 thread starter macrumors newbie

    Joined:
    Dec 15, 2009
    #3
    That could be a possiblity, simple too. Coupled with a CSS I can try and make it work. Thanks. Willing to accept alternatives too
     

Share This Page