Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


Smef last won the day on May 24 2017

Smef had the most liked content!

Community Reputation

15 Good

About Smef

  • Rank

Profile Information

  • Gender

Contact Methods

  • Website URL
  • Skype

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. David Nahodyl from Blue Feather will be presenting on the new features in FileMaker 17. Come learn about the new scripting, behaviors, functions, and completely overhauled FileMaker Server interface which come as part of the latest version of FileMaker. The post FileMaker 17 New Features – Atlanta FileMaker Developers Group 7/11/18 appeared first on Blue Feather - FileMaker Developer, Android, Web. View the full article
  2. Joe Martin from 360Works demos their new product, 360Deploy 2. He shows how you can use 360Deploy 2 to automate deployment of your development files to your production servers with the click of a button. His demo also includes how to set up the 360Deploy 2. 360Deploy 2 can be purchased from 360Works. The post Atlanta FileMaker Developers Group 6/6/18 – 360Deploy 2 appeared first on Blue Feather - FileMaker Developer, Android, Web. View the full article
  3. John Greene of United Acceptance Inc. presents on considerations regarding web scraping from FileMaker Web Viewer. Specifically, he addresses what happens when you loop through many hundreds or thousands of records and how to mitigate the risk of overwhelming the executing systems resources. The post Atlanta FileMaker Developers Group 5/2/18 – Web Scraping and Web Viewer Performance Issues appeared first on Blue Feather - FileMaker Developer, Android, Web. View the full article
  4. We've filled this position, but you can still PM me your resume for future reference when we look to hire our next person.
  5. Relationship Rescue What does it mean in the Set Field script step when it says “This calculation will be evaluated based on context determined at runtime.”? What is “context”, anyway? It turns out that there are different types of “context” that are relevant to FileMaker development. What do layouts have to do with the relationship graph? What do indexes have to do with relationships? How do the various types of relationships work?What’s the difference between defining a sort in the relationship graph and defining it in a portal? In this presentation Doug Gardner will discuss the answers to all these questions and talk about how to create a relational structure that scales to any size without becoming more difficult to read or use. Enjoy successful relationships without counseling. The post Atlanta FileMaker Developers Group 4/4/18 – Relationship Rescue appeared first on Blue Feather - FileMaker Developer, Android, Web. View the full article
  6. Michael Layne from Gearbox Solutions presents on FileMaker’s new JSON functions. He does a deep dive into FileMaker’s new JSON functions and demos several examples of how they are using JSON for passing parameters, populating form data, validation and rollback, managing session info such as value lists as global. Michael also demos REST client and REST server with new data API. The post FileMaker JSON, REST, and the Data API appeared first on Blue Feather - FileMaker Developer, Android, Web. View the full article
  7. Todd Daniel present to the Atlanta FileMaker Developers Group this month. You can download a PDF of Todd’s presentation here. Learn “best practices” for planning and modeling your next FileMaker solution. In the second part of the presentation Toss talk about his favorite resources on the web. The idea is to not reinvent the wheel, but rather tap into existing assets to get your project off the ground faster. It is hoped that this presentation will lead into a lively discussion. The post FileMaker Project Planning & Online Support Resources – Atlanta FileMaker Developers Group appeared first on Blue Feather - FileMaker Developer, Android, Web. View the full article
  8. This month Earl Cook from Laser Solutions presented about his integration with FileMaker and Amazon S3 and CloudFront for managing access to video content in a FileMaker solution distributed worldwide. The post Amazon S3 and CloudFront integration – Atlanta FileMaker Developers Group 11/1/17 appeared first on Blue Feather - FileMaker Developer, Android, Web. View the full article
  9. Andrew Duncan from Databuzz will be presenting on integrating FileMaker with Xero, Shopify, and WooCommerce using their products fmAccounting Link and fmEcommerce Link. The post Atl Dev Group – FileMaker and Xero, Shopify, and WooCommerce integration appeared first on Blue Feather - FileMaker Developer, Android, Web. View the full article
  10. This month at the Atlanta FileMaker Developers Group meeting we covered some topics we learned about at DevCon this year. View the full article
  11. This month we covered some of the new features in FileMaker 16. Check out the recording of our monthly meeting below. The sample files used in this demo are available for download from https://community.filemaker.com/docs/DOC-8138. This link is supposed to be available to download, but there’s been an error popping up on that page about restricted access which you may experience. View the full article
  12. I've added a new set of instructions for Let's Encrypt SSL Certificates with FileMaker Server for Mac.
  13. Looking for instructions for Windows? Click here! 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 Bash script and a LaunchDaemon 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! Requirements: FileMaker Server deployed on a Mac server – Tested with OSX 10.11 but may work with other versions. The “FileMaker Database Server Website” page must be reachable through the public internet using a web browser at the address you wish to get an SSL certificate for, such as http://myserver.mycompany.com. This means opening or forwarding port 80 in your router, firewall, or security groups. We use the Let’s Encrypt HTTP verification challenge, so we must make sure that Let’s Encrypt is able to reach our FileMaker server through HTTP. Warning: FileMaker does not list Let’s Encrypt as a supported SSL vendor and usually alerts the community that non-supported SSL vendors’ certificates won’t be able to be validated by FileMaker Pro and Go. I believe we’ve solved this issue with this solution. We’ve had no problems with validating these SSL certificates with FileMaker Pro 13-16 but of course can’t make any guarantees. FileMaker Go 15/16 also seem to validate everything correctly, though FileMaker Go 14 can’t connect. Please post in the comments section below if you have any issues using these SSL certificates. This is an experimental script and procedure. Please proceed with the use of this Bash script and Let’s Encrypt SSL certificates at your own risk. Here’s a summary of what we’re going to need to do: Install Homebrew Install Certbot Edit the GetSSL.sh file Run the Bash script Change the FileMaker Server SSL Connections settings Set up a schedule to renew the SSL certificate 1. Download the GetSSL.sh Bash script First, you’ll need a copy of the GetSSL Bash script. Download the file using the link below and save it on your server where you’ll want to get the SSL certificate. Warning: This is an experimental script and procedure, and SSL certificates from Let’s Encrypt are not officially supported by FileMaker, Inc. Please download and use this script with the understanding that it comes with no guarantees or warranties, and that you are doing so at your own risk. Blue Feather, Let’s Encrypt, nor anyone else are responsible for what happens to your server or systems when using this script. Download the GetSSL Bash script 2. Install Homebrew Homebrew is a package manager for Mac. It’s used to install tools and applications for your system. You can read more about Homebrew at the Homebrew website. We’re going to follow the instrucitions on there to install Homebrew on our Mac server. Run the following command in Terminal: /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)" 3. Edit the GetSSL.sh file The script file needs to be edited so that it know the address you wish to get an SSL certificate for. Open the script in a text editor like TextEdit, TextWrangler, Sublime Text, or through Terminal using an editor like Vim. Change the address, email address, and (if necessary) the FileMaker Server install path variables to reflect your server’s information and your contact information. Let’s Encrypt will use this contact information to reach out to you if there is a problem with the SSL certificate that they have issued to you. 4. Run the Bash Script WARNING: Running this Bash script will safely restart your FileMaker Server service, abruptly disconnecting any active users. Make sure that nobody is connected to your server before you run this script. With Certbot installed, we’re now ready to run the Bash script. Make sure nobody is connected or using your FileMaker server and then run the GetSSL.sh Bash script by navigating to the directory you have it copied to in your Terminal window and entering: sudo ./GetSSL.sh A bunch of text will scroll by in the Terminal window as the script requests, fetches, and installs your SSL certificate. Your FileMaker Server service will then be stopped and started again automatically. Your SSL certificate should now be installed! Go to your FileMaker Server admin console to make sure you’re seeing the new SSL certificate. You may need to close and re-open your browser if you had the page open already. 5. Change the FileMaker Server SSL Connections settings The SSL certificate is installed, but we want to force FileMaker Pro and Go clients to connect securely to our server. Log in to your newly secured FileMaker Server admin console. Select the Database Server options from the list on the left and then the Security tab at the top of the page. Check the “Use SSL for database connections” option (as well as “Use SSL for progressive downloading” if you would like) to force FileMaker Pro and Go clients to use a secure connection when connecting to this server. Save your changes and then restart your whole FileMaker Server machine or just the FileMaker Server background service. Your FileMaker Pro clients should now show the green lock icon when logging in to this server, indicating that the connection is secure. 8. Set up a schedule to renew the SSL certificate SSL Certificates from Let’s Encrypt are only valid for 90 days and must be renewed before that time. Let’s Encrypt does this purposefully to encourage automation and increase security. In that spirit, we should set up an automatic renewal for our SSL certificates so that we don’t need to manually re-run this every couple of months. This process is similar to setting up a scheduled script in FileMaker Server. Move the GetSSL.sh file to a relatively permanent location on your server. An example place for this might be /usr/local/bin/. You’ll need to create a LaunchDaemon schedule to run the script at the dates and times you want to do it. A LaunchDaemon will run your scheduled program or task at the dates and times, or at the interval, that you specify. These certificates are good for 90 days at a time, and the Certbot tool we’re using will only renew them once they’re at least 30 days out from renewal. You will want to create a .plist file to schedule this in a way which makes the most sense for you. You can have it run once per week, for example, and it will renew your certificate when it becomes eligible for renewal (It will still restart your FM Server at your scheduled time, even if there isn’t a new certificate – I’d like to update this in the future to only restart if there’s a new certificate.). You can use the example .plist file available at the download link below. You can download and edit this example file to run your GetSSL.sh script at the location you stored it at and on the days you want. This example one is scheduled to run once per week, on Saturdays at 6:21 pm. You can read more about writing your own LaunchDaemons from the Apple Developer site. Download example .plist As an alternative, there’s a great app called Lingon X which give you a really nice GUI for creating, editing, and installing LaunchDaemons. A demo is available, and a single-user license is $9.99, which may be worthwhile as it makes creating and scheduling LaunchDaemons very easy. Once you’ve finished setting your schedule, place your .plist file in /Library/LaunchDaemons/. With your LaunchDaemon installed you can tell your server to start the schedule by ( substituting your .plist file name and then ) running : sudo launchctl load /Library/LaunchDaeomns/my-script.plist Done! That’s all that you need to do! Your script should run automatically at your scheduled time to renew your SSL certificate with Let’s Encrypt. Do a test to make sure that it’s all working properly, that it gets a new certificate for you, and that your FileMaker Server service restarts after it has retrieved the certificate. If there is an issue, you may want to run the script manually in PowerShell or debug with the PowerShell ISE to locate any issues. Keep in mind that your FileMaker Server service will be restarted after getting the new SSL certificate, so be sure to schedule it for a time when people will not be active in your system. This is an early version of this script and there is quite surely room for improvement. Please let me know if you have any suggestions or run into any issues using this scripting. Let’s make the FileMaker community a secure one! View the full article
  14. 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. You can purchase FM Books Connector from http://www.fmbooksconnector.com/. View the full article
  15. 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. View the full article

Important Information

By using this site, you agree to our Terms of Use.