7 Replies Latest reply on Feb 25, 2014 10:44 AM by oraco

    Newbee - New Development Project


      Hi All


      Really looking to be pointed in the right direction as I have read a lot of posts already in the particular areas for concern for my team.


      We are about to take on a client using FM, who is wanting their local sql tables to talk with the server sql. We are PHP developers and have already read some issues faced by other users using the PHP code, in particular new versions of PHP


      My question is this - setting up FM sql to talk with an Apache server, easily done? BTW I am not the programmer, I am just doing all the leg work, so excuse me if some of my terms are a little mixed up.


      The website once made will be hosted on a VPS for better use of resources. The client needs to be able to communicate his local sql with the online version. We have already decided not to do this with a live sql, to avoid any conflicts occurring. Is there anything else that my team will need to know.


      In a nut shell I wanting to know if this project is going to cause us a lot of headachs if we take it on. My team believes we can make it work, never have worked with Filemaker before, so the challenge is there. Not that we need to know FM like our client does, we just need to create the data relationships between his local sql and the server.


      Any suggestions or help is already appreciated.

        • 1. Re: Newbee - New Development Project

          Hello, oraco.


          There's good news and bad news.   


          The good news is yes, FileMaker is well suited to work cooperatively with many versions of SQL databases, across all different kinds of platforms. It can connect via ODBC using either direct queries or via import / export, and it can use a direct connection technology referred to as ESS (External SQL Sources). So what you're describing is perfectly achievable.


          The bad news is, if you're not familiar with FileMaker and how it works, doing an external connection is a mid- to advanced-level skill. This is because FileMaker is ... different. You have to engage in a bit of a paradigm shift to work with FileMaker, because it doesn't work like your traditional SQL database. So your team will likely have a learning curve and will have to do a brain shift to move back and forth between the technologies.


          The other good news is that FileMaker is actually easy once you make that paradigm shift. Depending on how much your client is willing to do (and how much he knows about FileMaker), setting up the connections between the two databases is very doable.


          On the other hand, it might be worthwhile to look into hiring an actual FileMaker consultant to lend a little advice on the specific project. Not necessarily to do the work, but to give some specific guidance after looking at the specifics of the two systems. You can use FileMaker's "Find a Developer" tool on their web site, or look on places like eLance or Linked In.





          • 2. Re: Newbee - New Development Project

            oraco wrote:


            wanting their local sql tables to talk with the server sql.


            Describe this better.


            What is "local"?  A server running at the client's premise?  What database and what version?

            What is "server sql" then?  What database and what version?  A little later you mention "online version"  What's that?  A cloud-hosted database?  Again: what database and what version.


            Since you are PHP developers: what's the PHP role in this project?

            • 4. Re: Newbee - New Development Project

              Good advice here.


              What SQL Database are you working on?  What does "not doing it with live sql" mean?


              If your new to Filemaker expect some frustrations learning how it works, but generally speaking most problems can be solved.



              Lee Snover

              • 5. Re: Newbee - New Development Project

                Thanks Mike


                You were able to read between my lack of understanding of FM and give me a good clear answer of some of the challenges we may face.  I am not the programmer, so I will be speaking with my team today about what we need to be aware of and may even consider taking your advice of find a FM a develper to assist in the project.



                • 6. Re: Newbee - New Development Project

                  The local is the Clients ESS communicating with the server sql by way of import/export. Based on what I have read through this forum, doing this "live" (in real time) may cause some issues.  I will be having this discussion with my team today.  As mentioned I am not the programmer, I am purely doing the leg work, my team will fill the gaps in for me. (Small team)

                  • 7. Re: Newbee - New Development Project

                    Thanks Lee


                    Yes it is going to be a learning curve, the client has found that most developers here in NZ don't deal with FM.  This includes ourselves; however I never turn an opportunity down to learn and the customer is aware of this.  Looks like I will be calling on the advice of the community here, or posting in the "Looking for a FM developer for assistance"


                    Thanks everybody for your contributions.