Marc Larochelle from Productive Computing presents about QuickBooks and FileMaker integration at our monthly meeting for May 2017. You’ll learn more about the world of QuickBooks Accounting, the various flavors available today and why customers are interested in connecting QuickBooks with FileMaker. We’ll explore the tools and skills needed to accomplish this as well as common integration strategies in use today. Then, we’ll take a deeper dive under the hood to see what a typical integration script looks like and how it all works from A to Z with FM Books Connector. After watching this webinar, you’ll know a lot more about how to get started with these integrations on your own and the right questions to ask a customer interested in making a connection between FileMaker and QuickBooks.
Nicholas Orr from Goya presented at our developer meeting this month. Watch the recording of the live-stream to see him demonstrate BaseElements and give a run down on the benefits of developer analysis tools in general, and BaseElements in particular. He’ll show you how to get the best solution possible from FileMaker using these tools, as well a quick demo of their update builder product : RefreshFM, Web Services server : RESTfm and the free BaseElements plugin.
Let’s Encrypt is a non-profit certificate authority with the mission of spreading the SSL love across the internet. Though they’re not officially supported, we can use Let’s Encrypt to get free SSL certificates to use with FileMaker Server. We will use a PowerShell script and the Windows Task Scheduler on Windows Server 2012 R2 to retrieve and automatically renew SSL certificates through Let’s Encrypt to make sure our connections to FileMaker Server are secure. With this, there’s no reason anyone should have an invalid SSL certificate on their FileMaker Server deployment!
FileMaker does not list Let’s Encrypt as a supported SSL vendor, but does say that “Any SSL certificate can be used with FileMaker Server as long as the corresponding intermediate certificates are imported as well.” (FM Support)
We had a special presentation at the Atlanta FileMaker Developers group meeting last night. Andy LeCates and Darrin Quick from FileMaker, Inc. came by to present some of the new features in FileMaker 14 and answer questions from the attendees. We live-streamed the event on YouTube and Hangouts On Air, where we also had some remote participants watching and asking questions.
The recording of the live-stream is available on YouTube below.
FileMaker is capable of importing data from many different sources. One of the most useful is importing from XML data sources, which can be a great way to get data from non-FileMaker resources into your database. XML is used by all sorts of programs and applications, and so you may encounter it when working with many non-filemaker services or data sources.
FileMaker has extremely functional charts, but one tricky part I’ve found is making the x-axis display in an appealing format. The values along the x-axis can overlapIf you have a lot of records. Summaries can help with this, but what if you don’t know how many points you’re going to have to plot, or the range which would need to be summarized?
If you’re working in an office with Active Directory and you have more than a couple of computers to install FileMaker Pro on it can be very convenient to use a Group Policy Object to deploy FileMaker to different computers on your domain. This prevents you from having to go to each machine and run the setup program. A GPO can also be used to install updates or uninstall FileMake Pro to different machines on your network. This guide will show you how to set up a GPO to deploy FileMaker Pro to your domain.
The purpose of this lesson is to create a simple PHP page that will make a connection to a FileMaker database hosted on FileMaker Server and pull information that will be displayed as HTML on a webpage. This will help you get started with the basics of using FileMaker Custom Web Publishing