13 Replies Latest reply on Dec 31, 2016 1:57 PM by philmodjunk

    A brief rundown of Pro, Server, Go...I have questions. NOOB.

    dallaskruse

      I'm a complete NOOB.

       

      Forgive my ignorance.

       

      I'm still in Trial mode.

       

       

      I was looking for a good database management system for my band. One that I could build custom and keep track of who's booked, where, how much they're getting paid, etc etc. And I also have another person in another city entering the data. We both manage the very active band.

       

      My question ... I understand that building the app to manage the database would be somewhat simple. Well, maybe not "simple" ... but it wouldn't be crazy.

       

      But as I'm reading more about FMP, I'm learning that I'd need Servers and hosting and much more than simply just buying the app and running it from my computer.

       

      I'm not 100% sure how this all works.

       

      It would basically be 2 people, MAYBE a 3rd in the future, entering in data from 2 different locations (2 different cities).

       

      If I create the program that will keep all my info/database ... how would I make that accessible to my partner who also enters in data?

       

      Does it run from a  web browser?

       

      Will she need a copy of FileMaker installed on her computer?

       

      What about entering in info via iPad/iPhone?

       

      Can I just host the FMP on my Web Site Server I'm hosting my website on?

       

      I see many different Filemaker versions (Go, Server, Cloud, etc). Do I have to get all of these?

       

      If anyone could help a complete moron understand what it would take to get this up and running, it would be greatly appreciated.

        • 1. Re: A brief rundown of Pro, Server, Go...I have questions. NOOB.
          Malcolm

          In it's most basic state, Filemaker is a desktop program. You create an app using FileMaker and you run it on your machine. That's it.

           

          If you send a copy of it to your friend, they have a copy and you have a copy. That's two copies and they are completely separate. None of the data is in synch. They need a copy of FileMaker to be able to run it on their machine.

           

          You could download a copy of FileMaker Go onto your iPad or your iPhone. Then you can load your app to your iPhone/iPad. That's pretty cool. It's handy having your app with you on your phone. However, it's not accessible to the world. It's just on your phone.

           

          To get FileMaker networked you use the server program. Once you start running server, you can load your app to the server and then you can begin sharing your app. Sharing gives you the funky web-oriented stuff, like sharing with WebDirect or sharing to FileMaker Go. With WebDirect your friends could simply use their web browsers to access your app. Alternatively, they could download FileMaker Go to their phone/ipad and share your app.

           

          Your ordinary web host will have a database server but it will be a mySQL server, not a FileMaker Server. There are specialist Filemaker Web Hosting services. You pay a monthly fee, just like a web host.

          1 of 1 people found this helpful
          • 2. Re: A brief rundown of Pro, Server, Go...I have questions. NOOB.
            dallaskruse

            Thanks so much.

             

            When I buy FMP, do I also have to to buy FileMaker Server and/or FileMaker Go?

            • 3. Re: A brief rundown of Pro, Server, Go...I have questions. NOOB.
              RickWhitelaw

              You don't have to buyFM Server unless you need it.. FM Go is free.

              • 4. Re: A brief rundown of Pro, Server, Go...I have questions. NOOB.
                Malcolm

                FM Go is free to download and install on your iOS device. However, you purchase licenses for each FM Go connection and install them on your server.

                 

                A web host will have Go licenses, and the cost of Go connections will be in the price or not.

                 

                Malcolm

                1 of 1 people found this helpful
                • 5. Re: A brief rundown of Pro, Server, Go...I have questions. NOOB.
                  dallaskruse

                  As I'm reading on the site, when I open a file on my iOS device, it stays on the device.

                   

                  So, theoretically, if I want my partner and I want to keep synced data, we'd have to host our Database on a server?

                   

                  I'm guessing thats what we'll need to do ... search out a FMP server to host?

                  • 6. Re: A brief rundown of Pro, Server, Go...I have questions. NOOB.
                    Markus Schneider

                    There is no need for FM Server - as long as one runs a database app standalone, on one machine, without having several people working on the same data together. Every one with a FileMaker Pro can use a copy of that database app, without sharing data

                     

                    - FileMaker Pro can serve as a 'host' as well, up to 5 users can work on the very same database application served by one FileMaker Pro (or Pro Advanced), even for iOS devices (but no web connection)

                    - just turn 'sharing' on...

                     

                    - FM Server can make backups during work without interrupting users, even incremental backups, automatically

                    - FM Server only: scripts can be running on the server, speed-boost on several scenarios

                    - FM Server runs as a service, no need to have a user logged in an running the db from that session to serve as a host

                    - etc.

                     

                    There is one massive drawback when running FMServer: The cost for smaller installations when it comes to iOS...

                    - if a company has an existing licence for FMS and clients and needs a few personal iPads to work with the server data, FileMaker charges each connections with more than 1100€... Sorry, that's a no-go

                    - connections are available in packs of 5 only, 5700€...

                     

                    One pack (5 connections) was offered for 5700€, the company in that example has currently one existing FMS with 25 clients, but they wanted to add 3 iPad Pro devices, used as a personal device for three employees (already having licencies for their desktop machines). They asked for additional licencies for these FMGo clients.

                     

                    An iPad Pro costs about 1150€ (256GB, wifi&celluar), then additional cost of more than 1000€ for using the device with FileMaker - from the same company )-:

                     

                    (Yes - ther are other licencing models, but so far we have got no answer on how to change an existing licence..)

                    1 of 1 people found this helpful
                    • 7. Re: A brief rundown of Pro, Server, Go...I have questions. NOOB.
                      philmodjunk

                      And for just two to three users, a low cost, limited feature option might be to keep a "master copy" of your database on a computer in FileMaker Pro and use a synch tool to "synch" the data on your iPhones/iPads back to the copy on this computer. I believe seedCode's goZync tool can do this. There are some other third party tools for syncing, but some require FileMaker Server so that's not what you need if you go this "no frills" route.

                      For those primed to jump on me and tell me "You shouldn't host the database from FileMaker Pro", please first note that I have NOT recommended that. This option simply uses a regular copy of the database open in Pro as the repository and distributor of new/changed data to keep the mobile copies up to date.

                       

                      The main draw back to this method is that without a hosted copy, you have to move copies of the files onto the host machine to synch them. You can host a DB from FileMaker for the limited purpose of establishing a temporary, local WiFi link so that iPhones on the same WiFi network can synch back to the master copy, though I would use this only for purposes of periodic "synchs". This still requires physcial proximity of iPhone and computer to make it work. If you are far apart, (Someone's on the road), you'd have to email a copy of the file or an exported csv file of the new data back to the master machine for synch purposes.

                      • 8. Re: A brief rundown of Pro, Server, Go...I have questions. NOOB.
                        dallaskruse

                        All these answers are helpful.

                         

                        My partner will work in L.A. from her MacBook and/or iPad (if needed). I will work from Orange County on my MacBook.

                         

                        So, from what I'm reading, unless we're sharing the same computer (which we won't be), a Server is needed.  If we'd be working on the same machine, we could just use the same FMP file.

                         

                        We get potential client leads and she will fill out the data in FMP on her machine.

                         

                        I would access the DB on my machine and make any changes or update our employee info. She deals with the clients, I hire the employees for the events.  So, we'd need to be in sync.

                         

                        I'd obviously like to keep costs down as we're not a huge company.  FMP seems like a great solution but once "all in" it might be a bit expensive?

                         

                        And just to be clear ... Its impossible to host the FMP database on my existing GoDaddy server where our website is located?

                         

                        FWIW, I do have a few computers at my studio always on and connected to the internet.

                        • 9. Re: A brief rundown of Pro, Server, Go...I have questions. NOOB.
                          wimdecorte

                          dallaskruse wrote:

                           

                          I'd obviously like to keep costs down as we're not a huge company. FMP seems like a great solution but once "all in" it might be a bit expensive?

                           

                           

                          Compared to...?

                           

                          In essence it's a fairly simple value equation.  Is there anything that exists that you can license?  At what cost?

                          What is the cost to the company if you didn't have the thing in FM?  That would determine its value and how much you can spend on a solution.

                          • 10. Re: A brief rundown of Pro, Server, Go...I have questions. NOOB.
                            dallaskruse

                            Compared to using something simple and free like Google Solutions or others.

                             

                             

                            And considering @MarkusSchneider's post, it looks as though we'll be in to the thousands just to deploy.

                             

                            Again, we're a small entertainment band and don't have a huge budget. We can afford somethings but thousands to just deploy may be out of reach ... or at least not on the front burner.

                            • 11. Re: A brief rundown of Pro, Server, Go...I have questions. NOOB.
                              wimdecorte

                              dallaskruse wrote:

                               

                              It looks as though we'll be in to the thousands just to deploy.

                               

                              Hardly.  FileMaker Cloud for instance with a 5-user license for any type of client connectivity would cost you $888 per year and probably around $20-40 per month for the AWS virtual machine part.

                              So call it just over $1,000, not thousands.

                               

                              But compared to free solutions: yep, that's more money

                              It really comes down to what value you think you can get out of it.  Now and in the short term (scalability, usage on various devices,...)

                              • 12. Re: A brief rundown of Pro, Server, Go...I have questions. NOOB.
                                philmodjunk

                                So, from what I'm reading, unless we're sharing the same computer (which we won't be), a Server is needed.  If we'd be working on the same machine, we could just use the same FMP file.

                                Desirable yes. Necessary no. FileMaker Pro CAN host such a database and be accessible remotely via a number of options. But you have to know what you are doing and have to be able to work within the limitations. And note that a "synch" solution may or may not work for you as another option for not needing server.

                                 

                                The link to such a database is not secure, no SSL type encryption protocol is supported. That's the main vulnerability. But if you don't put data in your database that can be used to steal a person's identity, that might be an acceptable risk as that's the type of data most likely to cause harm if you get hacked.

                                 

                                You have to work out your own back up strategies and have to be sure that only safe methods of access are used--no opening files directly via shared directories allowed, and a client side crash does carry a greater risk of damage to the hosted file than if you hosted from server, but you are also spending far fewer $$ so have to balance risks against rewards.

                                • 13. Re: A brief rundown of Pro, Server, Go...I have questions. NOOB.
                                  bigtom

                                  Using FM Pro as a host is a viable solution in your case, but ultimately the best use of that includes a copy of FM Pro hosting from a Server machine.

                                   

                                  FileMaker Cloud with AWS is a better option for the money.