3 Replies Latest reply on Mar 12, 2009 7:37 AM by TSGal

    Which Filemaker Do I Need? Single database holding URL's, links and jpegs to 20,000+ entires

    reearcher_ash

      Title

      Which Filemaker Do I Need? Single database holding URL's, links and jpegs to 20,000+ entires

      Post

      Hi,

       

      Played with Bento and its great but need something heftier. Which Filemaker (if Filemaker at all) could do? Can you help me, I'm a little lost;

       

      I need to create a spreadsheet style database in columns and rows. It includes this:

       

      1. URLs (must hyperlink)
      2. Searchable (keywording)
      3. Clickable iTunes style 1-5 star ratings (that use xls data from an excel spreadsheet that is currently numbered 1-5)
      4. Drop down boxes as data options within a spreadsheet (as per Bento)
      5. Images and videos linked to each entry (viewable in a similar style to Bento's split screen interface)
      6. Image/Video zoom in option (as per Bento)
      7. Optional pretty interfaces with custom layouts (as per Bento)
      8. The ability to hold over 20,000 rows of information, each with linked images (apprx 1Gb of jpeg and/or similar media files)
      9. Sort columns by various data types (alphabetically, numerically etc)

       

      Then I need to future proof this system so it must be able to be (this is at a later date after beta testing of the database on my single Mac);

       

      • Shared over my various computers- ie 1 database that several users can work on / with.
      • Eventually shared with a larger community of users (anything upto 500 users) with the necessary tools for protection, security, administrative etc etc.

       

      Many thanks on your comments and ideas. This is the first time I've done something like this and have already invested time and monies into my excel database, so now need a super database system to deal with it all.

       

      Ash.

       

      • One more question. When attaching a jpeg or similar media file to a piece of data, will Filemaker copy this file or always access it from the original source? I hope it copies it, and thus the database I create acts as a 'whole' and can be saved, moved, archived etc.

       

       

        • 1. Re: Which Filemaker Do I Need? Single database holding URL's, links and jpegs to 20,000+ entires
          davidhead
            

          First of all, you must understand that FileMaker Pro is not Bento. You may find better ways to do what you are doing in Bento. Some Bento features are not as easy to implement in FileMaker Pro. That being said, here are some answers:

           

           

          1. URLs (must hyperlink) - no problems - you can create a button that jumps to a web browser or even use a web viewer in FileMaker Pro to view the web page in situ.
          2. Searchable (keywording) - yes of course
          3. Clickable iTunes style 1-5 star ratings (that use xls data from an excel spreadsheet that is currently numbered 1-5) - a little harder on the interface, not a standard feature but could be simulated
          4. Drop down boxes as data options within a spreadsheet (as per Bento) - definitely
          5. Images and videos linked to each entry (viewable in a similar style to Bento's split screen interface) - could be done
          6. Image/Video zoom in option (as per Bento) - not really but I haven't seen how Bento operates
          7. Optional pretty interfaces with custom layouts (as per Bento) - as pretty as you can create but there are a number of layout templates available
          8. The ability to hold over 20,000 rows of information, each with linked images (apprx 1Gb of jpeg and/or similar media files) - no problem, file size limit is 8TB!!!
          9. Sort columns by various data types (alphabetically, numerically etc) - no problems
           
           
          • Shared over my various computers- ie 1 database that several users can work on / with. - that is where FileMaker Pro shines over Bento - multiple users but also can be mixed Mac and PC.
          • Eventually shared with a larger community of users (anything upto 500 users) with the necessary tools for protection, security, administrative etc etc. - how would you do this? Via a web interface. Doable.
           
          "When attaching a jpeg or similar media file to a piece of data, will Filemaker copy this file or always access it from the original source? I hope it copies it, and thus the database I create acts as a 'whole' and can be saved, moved, archived etc."
           
          You have a choice when inserting an image into a container field - stored or linked (as a reference). The default is what you want - copied in.
           
          Hope that helps 
           
          • 2. Re: Which Filemaker Do I Need? Single database holding URL's, links and jpegs to 20,000+ entires
            reearcher_ash
              

            Very very helpful uLearnIT.

             

            Many thanks - although which version of Filemaker are you generally referencing here? All of them (bar the server - 500 users issue)?

             

            Many thanks - this has saved me hours upon hours of research. 

            • 3. Re: Which Filemaker Do I Need? Single database holding URL's, links and jpegs to 20,000+ entires
              TSGal

              researcher_ash:

               

              Thank you for your post.

               

              All of the options that uLearnIT answered are available in FileMaker Pro 10.  If you are going to share this with 500 users, then you will definitely need FileMaker Server in addition.

               

              TSGal

              FileMaker, Inc.