2 Replies Latest reply on May 11, 2009 9:42 AM by deltatango

    Members Database for Social Club

    Seamus

      Title

      Members Database for Social Club

      Post

      Hello Forum, :)

       

      I'm in a motorcycling social club and we have a web page listing our current active members here: http://www.southerncrosscruiserclub.com/member_list/members.htm

       

      The above page is basically just a CSS table that I have to update manually, which is a cumbersome process.

       

      Our club "database" is just an Excel spreadsheet.

       

      The first thing I want to do is get all the relevant membership data into a real database system like FileMaker Pro. This will require manual data entry or an import of the Excel spreadsheet.

       

      Next, I need these changes reflected on the club members page: http://www.southerncrosscruiserclub.com/member_list/members.htm

       

      It would also be nice to have an online sort option. Maybe one solution is to simply export two tables - one sorted numerically by membership number, the other sorted alphabetically.

       

      So, can FileMaker Pro help me?

       

      I've been looking for online examples of the sort of thing I'm looking for but so far have not found much.

       

      Any tips and links would be greatly appreciated. :)

       

      Thank you,

       

      Seamus. 

       

        • 1. Re: Members Database for Social Club
          philmodjunk
            

          I suggest downloading the trial version of FMP and playing with it and the free tutorials to see if you can make it work for you. A lot depends on your own expertise and how much time you want to spend learing how to do this.

           

          Two key points drawn from your post:

           

          You can easily import excel spreadsheet data into filemaker. If the first row consists of unique column headings, filemaker can even make these the field names of a new table in the database. (Try it with the trial install).

           

          You can use a feature called Instant Web Publishing (IWP) to publish a simple database to the web. There are also hosting companies that will host a database for you.

          • 2. Re: Members Database for Social Club
            deltatango
              

            http://www.triple8.net/hosting_filemaker.htm

             

            Will host your files for you.

             

            You will still need to know how to set up and create your database and get it on the web.