Jump to content

DB Services

Membres
  • Content Count

    113
  • Joined

  • Last visited

    Never

1 Follower

About DB Services

  • Rank
    100

Profile Information

  • Gender
    Homme
  • Location
    US

Recent Profile Visitors

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

  1. FileMaker Web Apps with Vue.js There inevitably comes a time in a successful FileMaker application’s life where it needs to be extended to the web, usually as a customer portal. WebDirect may suffice as a solution, but if the needs go beyond WebDirect’s capabilities, standard web technologies must be used, such as HTML, CSS, Javascript, and a backend scripting language like PHP. Building an app on the web can be a daunting task for a FileMaker developer, especially a web app that’s as interactive and responsive as a FileMaker app. Luckily, there are Javascript frameworks available to simplify and speed up the process of developing highly dynamic web apps, frameworks such as React, Angular, and Vue.js. For FileMaker developers we recommend Vue.js as it has many parallels to the way FileMaker works that makes it easier to pick up, and because it’s a progressive framework, it can be used as little or as much as you want. And Vue is not only useful for web portals: you can use Vue inside a web viewer to extend what’s possible on a FileMaker layout such as tree views, horizontal portals and cross tab reports. In this article, we’ll go over the different concepts of Vue.js and how these provide some of the interactivity that FileMaker developers expect out-of-the-box with a development platform, and in the video, we’ll show you how to make a simple HTML editor using Vue that runs in a web viewer in FileMaker. Why Vue.js? Vue.js is a progressive web framework which means it can be used as little or as much as you want. Do you want to drop it into an existing page and just use it for one section? No problem. Do you want to build a full SPA (Single Page Application) with components, lifecycle hooks, state management, and application routing? No problem. If you don’t know what all of that is, that’s fine, Vue.js will grow with your needs. Vue.js is also extremely fast with a small package size. It’s very popular with a growing community and has a large number of packages that can be implemented to add things like drag and drop support or form validation. Vue.js has the 3rd most stars in Github’s history and is currently being used by almost 4% of the top 10,000 websites in the world. Vue.js is one of the easiest frameworks to get started with as you don’t need to learn JSX or anything like you would with React. Vue.js also has one of the best dev tools we’ve ever used for debugging a web app. Let’s take a look at some of the features that make Vue.js so great, and what the equivalent would be in FileMaker. 2-Way Data Binding 2-way data binding allows you to bind inputs, text, etc on a website to data stored in Vue so when a change is made to the input/text/etc, that change is automatically reflected in the data, and vice versa. This means everything stays in sync. To a FileMaker dev this might not sound so exciting as almost all of our work involves automatic 2-way data binding, but doing so in a web browser is a bit more challenging. In the example below, we create about as simple of an app you can get. We have a paragraph tag that displays dynamically the content of ‘message’. You can think of ‘message’ as a field in FileMaker. You’ll notice the ‘message’ property is also declared in our Vue instance. Then we have an input. This input can be tied directly to our message field by using the v-model directive. Directives are special attributes that help make our HTML interactive and react to changes in the state of our date. Now whatever we type in the field will show instantly in the paragraph tag above it. Computed Properties Computed properties allow us to create a value that will be automatically calculated based on the data in our app, and will automatically update if any of the data changes. Think of them as if they are stored calculations in FileMaker, because they will only calculate if a reactive property has changed. This means using Date.now() in a property will always return the date from the first time it ran unless another reactive property is changed. Below is a simple computed property that will uppercase our message data property, outputting “HELLO” in our second paragraph tag. All of our computed properties will live inside of the computed object, and each property needs to call a function that returns some data. They don’t have to return simple strings or numbers, they can return complex object and arrays as well. Filters In the previous example, we used a computed property to capitalize our message, but in reality, a better way to do so would be to use a filter. Filters are most commonly used for text, date, and number formatting. They are comparable to the data formatting FileMaker allows in the layout inspector palette. Filters are more flexible in that we can use them over and over, and are not tied to one data property. The example below is accomplishing the same goal as before, just using filters. Notice that we’re still using our message property in the HTML, we just added a pipe symbol to tell Vue that we wish to use a filter to format our text. Filters are declared in much the same way that computed properties are. The only difference is that they take a value as a parameter in the function. Vue.js will automatically use what is on the left side of a pipe symbol as the parameter. Methods Vue.js methods are similar to FileMaker scripts. They can be called by events or lifecycle hooks. Events are like object and field triggers in FileMaker and in Vue.js would be things like button clicks, form submits, mouse over, key enter, etc. Lifecycle hooks occur when the Vue instance is created, before it’s compiled, compiled, ready, before it’s destroyed and destroyed. Think of these as layout and file script triggers. You define all your methods as functions under the methods object. Methods can take parameters, such as the ‘message’ parameter being passed in the ‘say’ function below. To call the method from your HTML we simply use the v-on:click directive, and pass the parameter from there. Conclusion Vue.js can help FileMaker developers build highly dynamic web apps on par to the interactivity and responsiveness of a FileMaker application, and can even be used to extend what’s possible on a FileMaker layout. And because of similar concepts to FileMaker, Vue should be easier to pick up for FileMaker developers compared to other popular Javascript frameworks. In part 2 of this article, we will build a fully responsive customer portal with the use of Vue and the FileMaker Data API. Download FileMaker Web Apps with Vue.js Database Please complete the form below to download your FREE FileMaker database file. Name* First Last Company Phone* Email* FileMaker Experience*New to FileMaker Platform Existing User of FileMaker Existing Developer of FileMaker Terms of Use I agree OPT-IN: I agree that I am downloading a completely free FileMaker application file with no strings attached. This database is unlocked, and I may use it for my business or organization as I see fit. Because I am downloading a free database, I agree that I should receive occasional marketing. I understand that I can OPT-OUT of these emails at anytime. Did you know we are an authorized reseller for FileMaker Licensing? Contact us to discuss upgrading your FileMaker software. Afficher la totalité du billet
  2. FileMaker SurveyMonkey Integration SurveyMonkey is a popular cloud-based survey platform boasting over 20 million questions answered per day. Flexible and user friendly, surveys generated by SurveyMonkey can be used for a variety of purposes, from large company wide reviews to customer satisfaction surveys. Using SurveyMonkey’s API you can automatically collect survey responses and data directly into your FileMaker application, allowing you to link your surveys to your FileMaker data.  Prerequisites In order to integrate FileMaker with SurveyMonkey, you will need a SurveyMonkey account with the Premier service plan. Without this package you will not be able to fully communicate with the SurveyMonkey API. However with the Advantage plan you are granted a 90 day trial period if you would like to test it before pursuing the Premier plan. Getting Started First you need to create a new app on SurveyMonkey’s developer website. From there under the settings you can set the scopes of what this app has access to. For the sole purpose of pulling survey responses you will need the following scopes enabled: View Responses, View Response Details, View Surveys, View Collectors, View Webhooks and Create/Modify Webhooks. In addition, you will need to save the access token provided to you by SurveyMonkey for FileMaker to authenticate across the API. Creating a Webhook Arguably the most useful part of the SurveyMonkey API is that they allow you to tie webhooks to certain actions that can take place on their website. To try out the API you can create a webhook via Postman (SurveyMonkey has a library you can use in their API documentation) or use the demo file attached to this article. You will need to specify the layout and field of your FileMaker application where you want the raw data to be stored. Here is a sample create webhook request: { "event_type" : "response_completed", "name" : "MyWebhook", "object_ids" : [ "176444261" ], "object_type" : "survey", "subscription_url" : "https://your.domain.com/webhook.php" } And the response: { "event_type" : "response_completed", "href" : "https://api.surveymonkey.net/v3/webhooks/3579938", "id" : "3579938", "name" : "MyWebhook", "object_ids" : [ "176444261" ], "object_type" : "survey", "subscription_url" : "https://your.domain.com/webhook.php" } Receiving the Webhook To receive the webhook you will need to create the web script that you specified in the url of the initial webhook creation request. In this article we used PHP. This PHP code is run whenever the webhook is triggered, communicating with FileMaker’s Data API to pass the survey’s information into your FileMaker application. Parsing the Webhook You should parse the returned JSON object in the FileMaker script instead of PHP because FileMaker is the one that needs the data. While being the easiest part of the integration, it must be noted that the parsing code will in most cases have to be written to match how your survey(s) are formatted. Due to the plethora of different question and answer types that SurveyMonkey has to offer, writing a catch-all script could potentially be very time-consuming. Here is a sample webhook response: { "event_datetime" : "2019-05-30T19:35:08.362289+00:00", "event_id" : "10014567306", "event_type" : "response_completed", "filter_id" : "176444261", "filter_type" : "survey", "name" : "MyWebhook", "object_id" : "10766574798", "object_type" : "response", "resources" : { "collector_id" : "0123446546", "recipient_id" : "0", "respondent_id" : "9832489383", "survey_id" : "23784237", "user_id" : "0439219" } } Conclusion The SurveyMonkey API allows you to automatically pull in all your survey’s data directly into your FileMaker application. With your surveys in FileMaker you can link them up to your employee or customer data to track satisfaction over time and to build a process to handle negative feedback on surveys. Contact us if you would like help integrating your SurveyMonkey surveys with your FileMaker application! Did you know we are an authorized reseller for FileMaker Licensing? Contact us to discuss upgrading your FileMaker software. Download the FileMaker SurveyMonkey Integration Sample File Please complete the form below to download your FREE FileMaker database file. Name* First Last Company Phone* Email* FileMaker Experience*New to FileMaker Platform Existing User of FileMaker Existing Developer of FileMaker Terms of Use I agree OPT-IN: I agree that I am downloading a completely free FileMaker application file with no strings attached. This database is unlocked, and I may use it for my business or organization as I see fit. Because I am downloading a free database, I agree that I should receive occasional marketing. I understand that I can OPT-OUT of these emails at anytime. Afficher la totalité du billet
  3. FileMaker 18 Security Enhancements Among the ensemble of new things to play with, FileMaker 18 brings with it a collection of security enhancements. Some of these changes include a redesigned Manage Security dialog aimed towards improved ease of use, an ability to manage FileMaker users without the need to have Full Access privileges, and a security warning for potentially malicious plug-ins.  Manage Security Redesign The Manage Security dialog has been redesigned, combining the Detail View and Basic View into one new display. Clicking an account name will make the detailed settings of the account slide in from the right, where users can still personalize the settings per the individual. The “Advanced Settings…” button in the bottom left pops up the Extended Privileges, Privilege Sets, and File Access settings in the original Manage Security dialog. Managing Users Without Full Access Arguably the biggest enhancement lies within the ability for non-Full Access users to manage the security of a FileMaker file. Now non-power users will have the ability to add and manage non-Full Access accounts in the Manage Security dialog without having to contact a developer or an administrator. However since the default privilege sets cannot be changed, accounts with this power will have to use a custom privilege set. This setting can be enabled under the “Edit Privilege Set” menu of the Manage Security dialog. Unsigned Plug-in Notifications Additionally FileMaker will now display a notification on startup when an installed plug-in is not signed by its developer. This is a measure taken to notify users that one or more of their plug-ins could have been potentially tampered with. This dialog gives the user the ability to choose whether they would like to load the unsigned plug-in. Please note that if you auto install unsigned plug-ins in your solution you will have to make sure Set Error Capture is set to Off to for users to get the warning. The auto installer will otherwise fail if Set Error Capture is set to On. Conclusion Managing security for your FileMaker solutions has become more intuitive and user friendly, while also keeping users more informed of security risks. Contact us if you would like help securing your FileMaker solution. Download the FileMaker Security Enhancements Database Please complete the form below to download your FREE FileMaker database file. Name* First Last Company Phone* Email* FileMaker Experience*New to FileMaker Platform Existing User of FileMaker Existing Developer of FileMaker Terms of Use I agree OPT-IN: I agree that I am downloading a completely free FileMaker application file with no strings attached. This database is unlocked, and I may use it for my business or organization as I see fit. Because I am downloading a free database, I agree that I should receive occasional marketing. I understand that I can OPT-OUT of these emails at anytime. Did you know we are an authorized reseller for FileMaker Licensing? Contact us to discuss upgrading your FileMaker software. Afficher la totalité du billet
  4. FileMaker While Function Sometimes smallest features offer the biggest impact. The new While function, which gives the ability to loop within a calculation, drastically reduces the need for one-off recursive custom functions, speeding up development in any part of FileMaker that requires looping in a calculation. Let’s take at how it works.  How It Works The format of a while function is broken into four parts: initial variables, the condition, logic, and the results. The function repeats the logic section until the condition is false; that is how the function provides the ability to loop. In the example below the While function returns a list of numbers 1 through 5: While ( [ count = 1; numberList = "" ]; count < 6 ; [ numberList = numberList & (count) & "¶"; count = count + 1 ]; numberList ) The function returns: 1 2 3 4 5 Notes Initial variables are available throughout the loop of the function. You can define multiple initial variables by enclosing them in brackets, similar to how let functions work. Variables that need to retain information from each iteration must be defined in the initial variable section otherwise their values are empty in the next iteration. To prevent infinite loops the while function will return “?” after the number of iterations exceeds a limit. The default limit is 50,000 iterations. Use the new function, Set Recursion, to set a new limit to the number of iterations. Conclusion With the advent of the While function, development of FileMaker applications will become a simpler and quicker process, eliminating the need for one-off recursive functions. Download the demo file to try out the new function. Did you know we are an authorized reseller for FileMaker Licensing? Contact us to discuss upgrading your FileMaker software. Download FileMaker While Function Database Please complete the form below to download your FREE FileMaker database file. Name* First Last Company Phone* Email* FileMaker Experience*New to FileMaker Platform Existing User of FileMaker Existing Developer of FileMaker Terms of Use I agree OPT-IN: I agree that I am downloading a completely free FileMaker application file with no strings attached. This database is unlocked, and I may use it for my business or organization as I see fit. Because I am downloading a free database, I agree that I should receive occasional marketing. I understand that I can OPT-OUT of these emails at anytime. Afficher la totalité du billet
  5. FileMaker 18 Database Engine Improvements FileMaker Server 18 brings some exciting database improvements in the form of faster processing of parallel queries and automatically recovering corrupt databases when the server starts up using a transactional log. This auto-correction feature, called Startup Restoration, will save significant time and headaches during disaster recovery of a FileMaker application. Both updates are intertwined within Startup Restoration, which means that added speed and stability are packaged together.  What’s the Fuss About? Performance optimization is one of the most time-consuming (and expensive) types of development and is often overlooked or ignored until applications are nearly unusable. This often happens as businesses expand, adding both more users and data which load the server with an ever increasing number of queries. Without Startup Restoration (what most users are used to), FileMaker Server handles queries in serial. Each query is put in a single line and assigned a processing “lane” once one opens up, much like a bank line with several tellers. The Startup Restoration feature allows the server to handle queries in parallel. That means, your query goes to the shortest “lane” available and has a better chance of being processed more quickly. To get an idea of the impact, the two screenshots below show just how much faster enabling Startup Restoration is. With Startup Restoration turned on, our example unstored find took a little less than 15 seconds for 10 simultaneous users. With Startup Restoration off, the same unstored find for the same 10 users took more than twice as long at just under 33 seconds. The added efficiency on the CPU is a major part of the benefit. For developers frustrated with a server needing more cores while the CPU usage is hanging around 20%, Startup Restoration will help, allowing you to do more with each core. The unstored find for 10 users with Startup Restoration easily took up about 60% of the CPU. The same find for 10 users without Startup Restoration barely topped 30% of the CPU. Auto-Recovery Startup Restoration also allows the server to auto-recover files on startup if corrupt data is detected. Having Startup Restoration enabled means in addition to more efficient queries, the server also keeps a transactional log of all the data changes occurring in FileMaker. If the server detects an error in the consistency of your FileMaker application, it automatically rolls itself back to the last consistent state by using the transactional log. Manual rollbacks to a progressive backup should be even more rare and no one has to worry about them being accidentally turned off. That means added stability and fewer emergencies. How Do I Get It? In FileMaker 18 Server, Startup Restoration is on by default, but turning it off is a simple command with either the Admin API or the command line. Setting “StartupRestorationEnabled=false” will disable logging. Setting it to “true” will enable the feature. If you are toggling Startup Restoration, you must restart FM Server for it to take effect. What if you want to know if Startup Restoration is enabled already? You can use the FMSAdmin “Get” command to ask the server for the current setting setup. When Not To Use It Why would you want to turn it off? Startup Restoration comes at a cost: creating and editing records take longer. In our example, creating records with Startup Restoration enabled meant an extra 1.5 seconds per user for 1,000 records. With Startup Restoration turned on it took just over 2 seconds per user to make 1,000 records. With Startup Restoration turned off, it only took each user an average of .6 seconds to make 1,000 records. For most applications and users, this isn’t likely to be a problem or even noticeable (the additional time per record in our example was .0015 seconds). However, if your application batch creates records, this could mean a pretty significant slowdown. If you have large-scale, predictable batch creations, you may even consider turning transactional logging off while you run those batch creations. Start Optimizing Almost everything is fast when it is first built, but your FileMaker application isn’t a statue – it changes and grows with your business. The optimization in Server 18 is FileMaker’s way of recognizing that as applications grow in size, FileMaker needs to keep up with the requests. In the same vein, Startup Restoration emphasizes better stability and less downtime caused by corrupt files. While no database engine improvement is a silver bullet for performance or stability, these optimizations are an improvement that will help applications grow with the businesses they serve even more effectively than before. Did you know we are an authorized reseller for FileMaker Licensing? Contact us to discuss upgrading your FileMaker software. Download FileMaker 18 Database Engine Improvements Please complete the form below to download your FREE FileMaker database file. Name* First Last Company Phone* Email* FileMaker Experience*New to FileMaker Platform Existing User of FileMaker Existing Developer of FileMaker Terms of Use I agree OPT-IN: I agree that I am downloading a completely free FileMaker application file with no strings attached. This database is unlocked, and I may use it for my business or organization as I see fit. Because I am downloading a free database, I agree that I should receive occasional marketing. I understand that I can OPT-OUT of these emails at anytime. Afficher la totalité du billet
  6. Redesigned FileMaker Import Dialog The new FileMaker 18 Import Dialog has been redesigned to be more user-friendly, flexible and fast. Some of the new features include the ability to select the target fields in a list that can be filtered and the ability to perform auto-enter options individually for each field.  What Is New? User-friendly interface Ability to select the target field from a list that can be filtered A custom row can be used as the “Field Names” row in the source file for certain data types Auto-enter options are independent for each field Ability to import data from files using a custom character to separate values User Friendly Interface The way information is presented makes it easier for the users to understand how the import process works. For example the use of colors to define if the field will be imported or not, or if it will be used to find a match conveys what is going to be done in a very efficient and natural way. In addition FileMaker provides diagrams in a pop-up window of the different operations that could be performed when importing. Search Target Field FileMaker now allows us to choose the target fields from a list that can be filtered, decreasing the time needed to map fields, especially when including a considerable amount of fields. Use Custom Record As Field Names You can now select any row in the import file as the header row (the row containing the field names). All rows in the file before the header row will be omitted. Independent Auto-Enters You can choose which auto-enters to fire when importing by clicking on the red gear button located on the right side of each field with auto-enter options. Custom Character Separators You have now the ability to import files that have separators other than commas and tabs, getting rid of the need to preprocess the file before importing. Conclusion FileMaker greatly improved importing with a more intuitive interface, a more efficient methodology, and more flexible functionality. Contact us if you would like help importing data into your FileMaker application. Did you know we are an authorized reseller for FileMaker Licensing? Contact us to discuss upgrading your FileMaker software. Download Redesigned FileMaker Import Dialog Database Please complete the form below to download your FREE FileMaker database file. Name* First Last Company Phone* Email* FileMaker Experience*New to FileMaker Platform Existing User of FileMaker Existing Developer of FileMaker Terms of Use I agree OPT-IN: I agree that I am downloading a completely free FileMaker application file with no strings attached. This database is unlocked, and I may use it for my business or organization as I see fit. Because I am downloading a free database, I agree that I should receive occasional marketing. I understand that I can OPT-OUT of these emails at anytime. Afficher la totalité du billet
  7. FileMaker Script Error Logging For many years FileMaker Server has automatically logged errors in server side scripts, but now with FileMaker 18 developers have to ability to log script errors client side in FileMaker Pro and Go, saving time troubleshooting issues with scripts. And with the new file manipulation script steps, developers can automatically import script error logs into a centralized table to quickly view errors across all clients.  A simple-to-use script step Error logging can now be accomplished with a simple script step: Set Error Logging [ On/Off ]. And because you can control when error logging occurs you can prevent unnecessary log entries from being created. Additionally you can set up a “custom debug info” calculation, the result of which will be added to each log entry of the script allowing developers to log dynamic information the moment an error occurs. The log file When enabling error logging in a script, FileMaker will create a single file named “ScriptErrors.log”, which will be created in the user’s Documents folder if it doesn’t already exist. Each log entry will include the following pieces of information: the name of the file, account, script, script step, error code, timestamp, session number, and custom debug information. Set Error Logging is currently only supported on FileMaker Pro and Go, not WebDirect, nor FileMaker Server. Collecting log files To really make these log files useful you should consider automatically importing them into a centralized table so the information is in one location and easily searchable by a developer. For example you could import the log every time a user closes the FileMaker application via the OnLastWindowClose trigger. Having an easily accessible error log can go a long way when something has gone wrong and troubleshooting becomes necessary. Conclusion Script error logging is no longer relegated to only FileMaker Server: it is now available in both FileMaker Pro Advanced and FileMaker Go, to help troubleshoot errors in client side scripting. In a future version of the FileMaker platform we would love the ability to enable or disable script error logging on FileMaker Server to prevent unnecessary log entires. In the mean time download the sample file to check out the client side script error log in action! Did you know we are an authorized reseller for FileMaker Licensing? Contact us to discuss upgrading your FileMaker software. Download FileMaker Script Error Logging Database Please complete the form below to download your FREE FileMaker database file. Name* First Last Company Phone* Email* FileMaker Experience*New to FileMaker Platform Existing User of FileMaker Existing Developer of FileMaker Terms of Use I agree OPT-IN: I agree that I am downloading a completely free FileMaker application file with no strings attached. This database is unlocked, and I may use it for my business or organization as I see fit. Because I am downloading a free database, I agree that I should receive occasional marketing. I understand that I can OPT-OUT of these emails at anytime. Afficher la totalité du billet
  8. FileMaker 18 Overview A new and exciting version of the FileMaker platform is here! 2019 marks over 34 years for the FileMaker platform. In this article we review what’s new in the FileMaker platform, specifically for FileMaker Pro Advanced 18, FileMaker Server 18, FileMaker Go 18, and FileMaker Cloud for AWS. We highlight some of our favorite new features with in-depth content with videos and sample files. With this release FileMaker continues to prove to be the Workplace Innovation Platform leader. What’s New? FileMaker Pro Advanced now includes an Import Dialog redesign, introduction of scripted Versioning, native File Manipulation script steps, and the new norm: more security enhancements. FileMaker Go now includes Append to Existing PDF, more barcodes supported, and OAuth 2 login support for iOS SDK with Amazon, Google, or Microsoft Azure. FileMaker Server now includes parity between the FileMaker Data API and the FileMaker PHP API—which is on the deprecation watch list—and the official release of the FileMaker Server Admin API (both RESTful APIs). FileMaker Community launched a new site in April. FileMaker Cloud for AWS 1.18 availability within the week. An all new FileMaker Cloud is coming later this year and will be the first time FileMaker offers a SaaS directly to customers. This will not require a separate AWS account to setup. FileMaker Marketplace is coming sometime later this year, replacing Made for FileMaker and requires developers to resubmit their product. No new price increases, price protection for existing customer ended May 14th. FileMaker Pro Advanced 18 FileMaker Pro Advanced is the flagship desktop application with more enhancements to create custom apps such as an improved file importing workflow, native file manipulation, enhanced security, and many more developer tools that allow you to build and deploy more innovative applications faster than ever before. Redesigned Import Records A welcomed redesign to the process of bringing data into FileMaker via the File Menu->Import Records, the dialog presents users a much easier way to import data and more possibilities with custom file import delimiters. You can choose any row for the field names, trigger auto-enters on a per field basis, and use type ahead field mapping when dealing with large number of columns to wade through. See the wonderful user experience as Carlos Machado shows you the Redesigned FileMaker Import Records Dialog in action. Version Comparison The new Save a Copy as XML script step opens up the potential for automating versioning of solutions and is great for teams or managing multiple build outs of the same application. The XML representation provides more detail than the Database Design Report XML most developers use today. See FileMaker Version Comparison in action as Brandon Terrell shows you in a video and sample file. Sending HTML Emails Sending email is now supported in the Insert from URL script step with SMTP cURL options, which have opened up the ability to send HTML emails directly from FileMaker. Learn about Sending FileMaker HTML Emails as Kevin Boehle walks you through in a video and provides a sample file for download. File Manipulation What used to require third party plugins can now be done natively in FileMaker: you can work with files on disk, including creating, renaming, deleting, reading and writing. See FileMaker File Manipulation in depth as Victor Perez-Mendoza shows you how and provides a free download as well. Security Enhancements Many new security improvements are available in FileMaker 18 including the ability to grant administrators account management without giving the them Full Access in Advanced Settings. A new user experience for the Manage Security Dialog box allows you to work more seamlessly when managing accounts including a new Details pane, type ahead, and multi-select. Also Full Access is required by default to reference a file when creating a new application. Read more in depth about the new FileMaker 18 Security Enhancements as Andrew Bosworth demos the security updates. Script Error Logging Now you can log errors while a script is running in FileMaker Pro, similar to how errors are logged when a script runs on FileMaker Server. With the file manipulation script steps, developers can build automatically importing the script error logs into a central table to view errors from all Pro clients. Check out FileMaker Script Error Logging as Austen Gren shows you in a video and sample file. While and SetRecursion Functions The new While function allows developers to loop in calculations, repeating logic while a condition is true, and then return the result. This gives developers the ability to replace many recursive custom functions. And with the new SetRecursion function, developers can bypass the previous limit of 50,000 iterations. See the new FileMaker While Function in detail as Devin Drake shows you how the function works. Open Application at Launch Using the Assisted Install file, you can now specify the FileMaker application to automatically launch by default when FileMaker Pro is opened. For those who distribute the application for single purposes such as SBA (Solution Bundle Agreement) or want the end user always to go to the same application this provides more control over your FileMaker user experience. FileMaker Pro Advanced Technical Specs FileMaker Pro Advanced 18 is supported on Windows 10 Pro and Enterprise, Windows 8.1 Standard and Pro, Windows 7 SP1 Professional and Ultimate, macOS Mojave 10.14, and macOS High Sierra 10.13. If you want early access to FileMaker versions, purchase a FileMaker Developer Subscription for $99/per year. The subscription gives you access to the pre-release version, the FileMaker Data Migration Tool, the FileMaker iOS SDK, and more. FileMaker Go 18 FileMaker Go for iPad and iPhone has all the features provided in FileMaker Pro Advanced plus specific iOS features. You will need FileMaker Pro Advanced on the desktop to build your custom application. The new version of FileMaker Go 18 is available in the App Store as a free download. Append to Existing PDF Users love to create and send PDFs from FileMaker Go and it just got better with the ability to append a new PDF to an existing one via the Save Records as PDF script step’s append option on Go. Enhanced Barcode Support There are many barcode fonts out there and 4 more are now supported in Go 18. Using the script step Insert from Device you can now read PDF417 (IDs), ITF-14 (packages), Aztec (mobile), and Data Matrix (labels, letters, food) barcode types. OAuth Support for iOS SDK Using the FileMaker iOS SDK you can use MDM (Multi Device Management) to authenticate your application with the same OAuth providers supported in regular FileMaker applications: Amazon, Google, and Microsoft Azure. FileMaker Go 18 Technical Specs FileMaker Go 18 is supported on iPads and iPhones running iOS 12.1. FileMaker Server 18 FileMaker Server is known for its ease-of-use and ability to run without any problems. The newest version focuses on performance improvements, FileMaker Server Admin Console interface enhancements, security updates, FileMaker Data API enhancements, and the Official FileMaker Admin API. Database Engine Enhancements FileMaker has enhanced the performance of FileMaker Server’s database engine, speeding up finds when many users are connected to the server. Understand more and see some tests of the FileMaker 18 Database Engine Enhancements by Nathan Kiefer with a sample file you can use to do some benchmarking yourself. Expect more improvements to the database engine over time. Startup Restoration Unfortunately servers do go down unexpectedly due to hardware failure or power outages, but with the new Startup Restoration feature, FileMaker Server will automatically fix corrupt files after the server is restarted. The process validates database entries when a file is first opened and before client access and if the file appears to not have been closed properly then FileMaker Server uses the restoration log (restore*.log) to restore the file to its last consistent state. Nathan’s article on the FileMaker 18 Database Engine also discusses Startup Restoration. Server Monitoring FileMaker Server has been updated to work better with Zabbix, an open-source server monitoring software. You can monitor users, memory, cpu, disk space, network traffic, and processes, and you can trigger events on stats. FileMaker plans to release a white paper and Zabbix templates for FileMaker Server. Understand how to set up Zabbix FileMaker Server Monitoring in a video by Aaron Kaiser. FileMaker Data API Enhancements The future of FileMaker Custom Web Publishing is the FileMaker Data API and it is now in parity with the functionality provided by the FileMaker PHP API. The Data API now includes XML metadata such as Script Names, Layout Names, and Layout Schema. FileMaker continues to support the FileMaker PHP API for Custom Web Publishing (via Command Line Interface only) and has been clear to developers that web apps should be built using the Data API going forward. Learn more about the Official FileMaker Data API as Mason Stenquist goes in depth about how to use the Official FileMaker Data API in a video. Official FileMaker Server Admin API The FileMaker Server Admin API allows administrators to create their own interfaces to manage servers. The FileMaker Server Admin API, based on the OpenAPI specification (REST API), was previously in beta until September 27th 2019 in FileMaker Server 17, but with 18 is now officially released. Learn about the FileMaker Server Admin API by Mason showing you how the FileMaker Server Admin API works with FileMaker Cloud for AWS in a video. FileMaker Server Admin Console Enhancements The FileMaker Server 18 Admin Console now includes more details on schedules such as which ones are currently running, their last success, or their last failed information. You can also see the last time the FileMaker Server was restarted, more clear status of files hosted on server via iconography, and in the command line interface (CLI) you can change the default backup time. All welcomed additions; another one we would like to see in future FileMaker Servers is the ability to view and filter logs without downloading them first. FileMaker Server 18 Technical Specs FileMaker Server 18 is compatible with Windows Server 2019 Standard Edition, Windows Server 2016 Standard Edition, Windows Server 2012 R2 Standard with Update Microsoft KB2919355, macOS High Sierra 10.13, and macOS Sierra 10.12. If you’re on Windows Server 2008 it’s a good time to think about moving to FileMaker Cloud. Also worth noting the release of a Spanish FileMaker Server support. WebDirect desktop browser support includes Safari 12.x, IE 11.x, Microsoft Edge 44+, Chrome 72+, and mobile browser support includes Safari on iOS 12.x minimum and Chrome 72 on Android 7.x. Note that Firefox is not on the list of supported browsers. FileMaker Cloud for AWS FileMaker Cloud for AWS was initially released in September 2016 and is a great product for most customers especially if you need to replace your current server hardware or are expanding to a more mobile workforce! This new product is available ONLY through Amazon Web Services (AWS) and gives you FileMaker Server in minutes. FileMaker Cloud is fast, lowers long-term maintenance, and is secure. FileMaker Cloud 1.18 will support all of the features of FileMaker Server 18. Contact us if you would like help to setup and Manage FileMaker Cloud. Summary The FileMaker platform continues to be the leader in creating innovative, powerful custom applications for organizations all around the world and works seamlessly across Windows, Mac, iPad, iPhone, and the web. The release of the FileMaker 18 platform further solidifies FileMaker as the Workplace Innovation Platform leader. FileMaker Go gives the platform a competitive edge and this version continues to build off its strong foundation. Organizations can create innovative and rapid custom applications for iOS with great ROI. Creating prototype applications on the iPad and iPhone is a matter of hours not months. FileMaker 18 is a great release and has features everyone can benefit from. We look forward to building innovative custom applications using the new tools for mobile, web and desktop. Did you know we are an authorized reseller for FileMaker Licensing? Contact us to discuss upgrading your FileMaker software. Afficher la totalité du billet
  9. Zabbix FileMaker Server Monitoring Zabbix, one of the largest free and open source server monitor applications with 300,000 installations worldwide, can be used to collect and display metrics from multiple FileMaker servers at once on one interface; therefore, giving you the ability to save time monitoring servers individually. Viewable from a web browser on a central dashboard, these metrics are displayed as charts, graphs, alerts, and reports with information fed in by the machines monitored by Zabbix. Furthermore, when issues are triggered by the monitored machines, notifications can be sent out. Let’s take a look at how to set up Zabbix to monitor your FileMaker servers.  Initial Setup Installation requires setting up a Zabbix server to monitor the various Zabbix agents (or clients). To monitor multiple FileMaker servers, Zabbix agents would be installed on each server machine, which would communicate with the central Zabbix server. In the following walkthrough, we used an AWS Ubuntu web server for Zabbix server and a Windows FileMaker server for the Zabbix agent. Zabbix server can only be installed on Linux distributions. The first step will be to identify the proper package from Zabbix’s website. This guide will be using Zabbix server version 4.2, Ubuntu 18.04, and MySQL due to our familiarity with each. Zabbix server requires a back end to store the data it collects from the Zabbix agents and a web front end to display the information. Setting up Zabbix Server Back End First we need to install the server back end and create the database to store our collected data. Download the Zabbix repository by running the following commands from your Zabbix server’s terminal. ~$ wget https://repo.zabbix.com/zabbix/4.2/ubuntu/pool/main/z/zabbix-release/zabbix-release_4.2-1+bionic_all.deb ~$ sudo dpkg -i zabbix-release_4.2-1+bionic_all.deb ~$ sudo apt update Next, install Zabbix server with MySQL support. ~$ sudo apt install zabbix-server-mysql Next, create a MySQL Zabbix database with a username of ‘zabbix.’ The password is the variable <password> in this example. Start the MySQL shell by running the mysql command. ~$ sudo mysql Once in the MySQL shell, create the database and user with the variable <password> replaced with your chosen password enclosed in single quotes. mysql> create database zabbix character set utf8 collate utf8_bin; mysql> grant all privileges on zabbix.* to zabbix@localhost identified by '<password>'; mysql> quit; Now import the schema for the newly created MySQL database. When prompted for the password, provide the password chosen in the previous step. This may take a while to complete. ~$ zcat /usr/share/doc/zabbix-server-mysql/create.sql.gz | mysql -uzabbix -p zabbix Set up the config file with the database’s username and password by editing the zabbix_server.conf file located in /etc/zabbix/ ~$ sudo vim /etc/zabbix/zabbix_server.conf ### Option: DBName # Database name. # # Mandatory: yes # Default: DBName=zabbix ### Option: DBUser # Database user. # # Mandatory: no # Default: DBUser=zabbix ### Option: DBPassword # Database password. # Comment this line if no password is used. # # Mandatory: no # Default: DBPassword=<password> Setting up Zabbix Server Front End Next up is installing the front end and creating the web pages to view the collected data. ~$ sudo apt install zabbix-frontend-php Edit the apache.conf file located in /etc/zabbix/ to have the appropriate time zone by commenting out the line and entering your PHP timezone. Other PHP settings can also be modified here. ~$ sudo vim /etc/zabbix/apache.conf php_value date.timezone America/Indianapolis Restart Apache to apply changes. ~$ sudo systemctl restart apache2 Finally, start the Zabbix server process and enable it to start at system boot. ~$ sudo service zabbix-server start ~$ sudo update-rc.d zabbix-server enable Zabbix server’s front end is accessed via a web browser. In order to be accessible and communicate with Zabbix agents, ports 80, 443, and 10050 need to be opened on the Zabbix server. Copy all the files in the /usr/share/zabbix/ directory to a new Zabbix subdirectory in /var/www/html/zabbix. First, create a new subdirectory and then copy the files. ~$ sudo mkdir /var/www/html/zabbix ~$ sudo cp -r /usr/share/zabbix/* /var/www/html/zabbix In a browser, navigate to http://<server_ip_or_name>/zabbix. You should see the UI for the Zabbix front end. Check that the prerequisites are all OK, and enter the database information on the following screen. This is the information used when creating the MySQL database on the Zabbix server. On the next screen, enter the Zabbix server details. The name field is what will be displayed on the menu bar and page titles. You will then get a summary of the information entered before finalizing your install. Once the setup is complete, log in using the default username and password ‘Admin’ and ‘zabbix.’ Setting up Zabbix Agent (Windows 10) On Windows, Zabbix agent runs as a service and can either be downloaded as a zip archive or installed via the command prompt. In this example we’ll be using the zip archive. After unzipping the files, choose or create a new directory to store the unzipped folders. For our purposes, we’re using: C:\zabbix Copy bin\zabbix_agentd.exe and conf\zabbix_agentd.win.conf files from the unzipped archive to your chosen directory. Our resulting directory is now C:\zabbix --bin --conf --zabbix_agentd.exe --zabbix_agentd.win.conf Next, we’ll need to edit the c:\zabbix\zabbix_agentd.win.conf file. For the ‘Server’ option, specify your Zabbix server’s fully qualified domain name. If you are enabling active checks, also specify the server name in the ‘SeverActive’ option. The ‘HostName’ option can be left blank. ### Option: Server # List of comma delimited IP addresses, optionally in CIDR notation, or DNS names of Zabbix servers and Zabbix proxies. # Incoming connections will be accepted only from the hosts listed here. # If IPv6 support is enabled then '127.0.0.1', '::127.0.0.1', '::ffff:127.0.0.1' are treated equally and '::/0' will allow any IPv4 or IPv6 address. # '0.0.0.0/0' can be used to allow any IPv4 address. # Example: Server=127.0.0.1,192.168.1.0/24,::1,2001:db8::/32,zabbix.domain # # Mandatory: yes, if StartAgents is not explicitly set to 0 # Default: Server=<Zabbix server’s FQDN> ### Option: ServerActive # List of comma delimited IP:port (or DNS name:port) pairs of Zabbix servers and Zabbix proxies for active checks. # If port is not specified, default port is used. # IPv6 addresses must be enclosed in square brackets if port for that host is specified. # If port is not specified, square brackets for IPv6 addresses are optional. # If this parameter is not specified, active checks are disabled. # Example: ServerActive=127.0.0.1:20051,zabbix.domain,[::1]:30051,::1,[12fc::1] # # Mandatory: no # Default: ServerActive=<Zabbix server’s FQDN> To install the Zabbix agent service, run the following command from the command prompt as an administrator. Again, in our example our files are placed in C:\zabbix. C:\> C:\zabbix\zabbix_agentd.exe -c C:\zabbix\zabbix_agentd.win.conf -i Now you will be able to manage the Zabbix agent service in the Windows services menu. To bring up the Windows services menu, navigate to Control Panel\All Control Panel Items\Administrative Tools and select ‘Services.’ It can also be opened by simply searching for ‘Services’ from the start menu. From here we can start, stop, and restart the Zabbix agent service as necessary. Connecting Zabbix Agent to Zabbix Server To connect Zabbix server to Zabbix agent, you will need to create a host and add a template. On the Zabbix web dashboard, go to Configuration>Hosts>Create host. The Host name field will be the IP address or fully qualified domain name of the Zabbix agent that you want to add. The visible name is what is shown on the Zabbix dashboard. In the Groups field we can add a new group named FileMaker. In the Agent interfaces section, again we will supply the IP address of the Zabbix agent and use port 10050. Once all the fields are populated, click Add at the bottom. Now a template will need to be added to the host. Go to Configuration>Hosts and select the FileMaker Server host that was created. Select the Templates tab from here. A template can be specified in the ‘Link new templates’ section by searching for a template and then clicking ‘Add’. After selecting the template, click update to save your changes. Zabbix provides many templates out of the box and they can all be customized for a user’s needs. To highlight a starting point, we’ll add the “Template OS Windows” template, which includes basic hardware stat monitoring. Once the template is added, we can begin to see some of the data by going to the Monitoring->Graphs tab. From here, we can select the FileMaker Server host and the graph to display. FileMaker Templates In addition to the included templates, FileMaker has provided templates to monitor Windows, macOS, and Linux FileMaker Servers. These templates include items that monitor various FileMaker server ports, system processes, and triggers to send alerts if something goes wrong. To import custom templates, go to Configuration>Templates and click Import in the top right. Conclusion Once you have completed the installation process, Zabbix can be used to monitor multiple machines at once, while providing deeper customization to tailor its use to your needs. Contact us if you have any questions or need assistance setting up Zabbix monitoring. Did you know we are an authorized reseller for FileMaker Licensing? Contact us to discuss upgrading your FileMaker software. Afficher la totalité du billet
  10. FileMaker File Manipulation Included in the release of FileMaker 18 are some new exciting file manipulation scripts steps giving developers the ability to create and edit data files without plugins, saving time and making upgrading FileMaker in the future easier. The following are the new script steps for data files: Close Data Fie Create Data File Delete File Get Data File Position Get File Exists Get File Size Open Data File Read from Data File Rename File Set Data File Position Write to Data File Let’s take a look at how to use these script steps.  Creating and Writing to Files While you can create files of any file extension with the new Create Data File script step, there are a few of things to remember when using the new script steps. A file must always be opened first before writing to it or it will result in an error, even files that you just created. The Open Data File step will return the ID of the file which you will later use in the other script steps. In the example below we create a data file, open it, write to it and close it. When writing to the file we recommend to error trap and to close the data file if an error occurs; otherwise the data file will remain locked. The Close Data File step uses the ID returned by Open Data File to close it. A file path cannot be used to close the file. Reading, Renaming and Deleting Files Just like before, a file must be opened before reading it or renaming it. To delete a file the file must be closed. Conclusion With the new file manipulation script steps FileMaker applications can natively create, edit, delete, and read data files without a plug-in, making upgrading FileMaker easier. Contact us if you need help with reading and writing files in your FileMaker application. Did you know we are an authorized reseller for FileMaker Licensing? Contact us to discuss upgrading your FileMaker software. Download the FileMaker File Manipulation Demo Please complete the form below to download your FREE FileMaker database file. Name* First Last Company Phone* Email* FileMaker Experience*New to FileMaker Platform Existing User of FileMaker Existing Developer of FileMaker Terms of Use I agree OPT-IN: I agree that I am downloading a completely free FileMaker application file with no strings attached. This database is unlocked, and I may use it for my business or organization as I see fit. Because I am downloading a free database, I agree that I should receive occasional marketing. I understand that I can OPT-OUT of these emails at anytime. Afficher la totalité du billet
  11. Sending FileMaker HTML Emails When sending emails to customers, it can often help get their attention by adding a bit of design and creativity to what could otherwise be a boring block of text. With FileMaker you can now send HTML emails without the need for 3rd-party plugins, making upgrading FileMaker easier. Let’s take a look at how to send native HTML emails using FileMaker.  How To Send The Insert From URL script step now supports the SMTP protocol and includes a handful of SMTP cURL options. Using your SMTP server as the URL and the “–mail-from” and “–mail-rcpt” cURL options, you can specify where the email is sent from, who is sending the email, and who is receiving the email. Perhaps most importantly, you can use the “–upload-file” cURL option to upload a text file containing the HTML that you want to send. URL smtp://<SMTP Server>:<SMTP Port> cURL --ssl --mail-from "<From Email>" --mail-rcpt "<To Email>" --upload-file $emailBodyFile --user "<SMTP Username>:<SMTP Password>" And now that FileMaker can natively read and write files, you can use those script steps to create the HTML file for the email or you can use Base64 Encode and Decode to take the HTML and save it to a file in a container. Conclusion FileMaker can now send HTML emails natively! By using a little scripting and some simple cURL options, you can send beautifully designed HTML emails, eliminating the need of 3rd-party products and helping you grab your customers attention. Contact us if you would like help sending native HTML emails out of FileMaker. Did you know we are an authorized reseller for FileMaker Licensing? Contact us to discuss upgrading your FileMaker software. Download the Sending FileMaker HTML Emails Database Please complete the form below to download your FREE FileMaker database file. Name* First Last Company Phone* Email* FileMaker Experience*New to FileMaker Platform Existing User of FileMaker Existing Developer of FileMaker Terms of Use I agree OPT-IN: I agree that I am downloading a completely free FileMaker application file with no strings attached. This database is unlocked, and I may use it for my business or organization as I see fit. Because I am downloading a free database, I agree that I should receive occasional marketing. I understand that I can OPT-OUT of these emails at anytime. Afficher la totalité du billet
  12. FileMaker Version Comparison One of the more important tools in development is being able to save or compare different versions of your application. This allows for quick and easy identification of any changes, lets developers make rapid updates in small and clear steps, plus can provide the ability to share or reuse code, layouts, and other elements with minimal effort. Using the new Save a Copy as XML feature in FileMaker, this critical functionality can be implemented via a single click or through scripting as a replacement of the previous Database Design Report (DDR). Taking this XML and using a diff tool, organizations will be able to track changes between versions of their FileMaker application.  Save a Copy as XML While the original DDR function still exists for now, a new option has been added in the Tools menu to “Save a Copy as XML”. When you select this tool you will be prompted to choose a save location and enter a file name. This will be set to your file name by default, and no other settings or configuration is necessary. Once you choose Save, FileMaker will create a new XML file in your specified location that is an XML serialization of your FileMaker file excluding record details What About the DDR? Initially just being able to save an XML copy of a FileMaker file can sound quite similar to the existing Database Design Report option; however the Save a Copy as XML feature is meant to be an XML serialization while the DDR is not. For example Save a Copy as XML includes encrypted account credentials as they would be required to have a complete serialization of a FileMaker file’s schema and structure while the DDR doesn’t include this information. Benefits of Scripting For even more control, there is a new script step also called “Save a Copy as XML” that allows you to automatically save an XML representation of the solution. With this step a developer can easily create a script and set it up on a server schedule to automatically generate daily version records of an entire application, and these files can then be archived for security and referenced as needed. In addition there is another new script step called “Save a Copy as XML Package” which provides the same functionality but also includes record information. Instead of a single file this step will generate a folder directory containing an XML document for the serialized solution, an XML document for all serialized record data, PNG files for the solution’s preview and icon images, and .strings files containing schema and file info. Conclusion Save a Copy as XML is a fantastic addition to the FileMaker platform, providing a way to run differential comparisons on a solution. Contact us if you need help incorporating this excellent new feature into your FileMaker application! Did you know we are an authorized reseller for FileMaker Licensing? Contact us to discuss upgrading your FileMaker software. Download FileMaker Version Comparison Database Please complete the form below to download your FREE FileMaker database file. Name* First Last Company Phone* Email* FileMaker Experience*New to FileMaker Platform Existing User of FileMaker Existing Developer of FileMaker Terms of Use I agree OPT-IN: I agree that I am downloading a completely free FileMaker application file with no strings attached. This database is unlocked, and I may use it for my business or organization as I see fit. Because I am downloading a free database, I agree that I should receive occasional marketing. I understand that I can OPT-OUT of these emails at anytime. Afficher la totalité du billet
  13. FileMaker Square Integration Square is one of the most popular in-person credit card processing systems available with over 2 million sellers using square today. Using the Point of Sale API, Square allows you to easily integrate with their Point of Sale app to quickly process in-person payments from your FileMaker application on mobile devices.  What You Need You must have a Square account and a Square Reader for all mobile devices you want to accept payment on. You will also need to have your FileMaker application hosted on a FileMaker Server, have the FileMaker Data API enabled on FileMaker Server, and enable the fmurlscript “Allow URLs to perform FileMaker scripts” and fmrest “Access via FileMaker Data API” extended privileges for all users pushing charges to Square. source: https://docs.connect.squareup.com/payments/pos/overview How It Works Your FileMaker application will determine the total charge to the customer and pass the transaction information to the Square POS app. The mobile device automatically opens the POS app and the charge amount is pre-populated in the transaction presented to the customer. Once the transaction is completed, the results are sent via a callback URL, which references PHP code to open your FileMaker application and pass in the results of the transaction from Square. Creating Your Square Application First install the Square Point of Sale app from the App Store (available on iOS and Android). Then create a Square application on your Square developer dashboard. To do this, sign in to your developer portal online and click “New Application”. Next enter your web callback URL by clicking into the application you created, selecting the “Point of Sale API” tab, and entering your Web Callback URL. Square requires that we use an HTTPS URL and not an FMP URL. This URL will be a link to a PHP script that acts as an FMP URL and will reopen your FileMaker application after the Square transaction completes. It needs to include parameters to reference your FileMaker file and call the FileMaker script that will handle the response data from Square. Keep in mind you will have to purchase an SSL certificate for the domain you use to host your PHP code as Square requires HTTPS for Web Callback URLs. Pushing a Transaction to Square Now that you’ve configured your Square application in the developer portal and have hosted your PHP script on a secure web server, you can start pushing transactions to Square from FileMaker. To push the transaction to Square, you will need to call the Square app with the Square URI scheme and pass information to prepopulate the transaction in the form of a JSON object. Here is an example of the JSON object. { "amount_money" : { "amount" : "0", "currency_code" : "USD" }, "callback_url" : "https://fm.dbservices.com/Test/SquareArticle/LaunchFMPURL.php?host=cloud.dbservices.com&database=DB_Services_FileMaker_Square_Integration&script=Square_Process_Payment", "client_id" : "sq0idp-mRVxvaQDqPVVacCJDPn2zg", "notes" : "", "options" : { "supported_tender_types" : [ "CREDIT_CARD", "CASH" ] }, "version" : "1.3" } Make sure to URL encode the JSON object and append it to the end of the URL “square-commerce-v1://payment/create?data=”. Use the Open URL script step to open the Square POS app. One important note to remember is that Square reads the transaction amount in cents, so if you’re passing dollar values, you need to multiply them by 100 before passing them through the API. Passing Back Transaction Results with PHP Included in the demo file is a PHP file used to pass the Square transaction results back to your FileMaker application. This PHP code handles the JSON data passed from Square and essentially builds an FMP URL used to re-open your FileMaker application and call a script. This is how we retrieve our result data in the FileMaker script that is called by Square. An example of the result data is shown below. { "client_transaction_id" : "C33DC0BB-98B4-4E7E-BB0E-9764C46E5A15", "status" : "ok", "transaction_id" : "WO873ceEC5bOO4KtzCFtaNzeV" } The only catch to this, is that on iOS devices, Safari will always be the browser that handles the FMP URL sent by the PHP code. Unfortunately Safari always prompts the user to open FileMaker Go and there is no way to disable this. So users will have to click “Open” or the FileMaker application won’t open. This can cause issues because the transaction could have completed or canceled and your FileMaker application wouldn’t know the difference. Processing Payment in FileMaker This is the easiest part of the integration. Once the PHP code opens your FileMaker application it will run the specified script. You will want to grab the data from Square and tie it to your charge record. In the demo file, we store the entire result in the response field and store the transaction ID in a transaction ID field. Conclusion The Square Point of Sale API allows you to quickly and easily process in-person payments on mobile devices, while linking your Square transactions with your FileMaker records. This eliminates the risk of human error while taking payment with Square. Contact us if you need help integrating your FileMaker application with Square! Did you know we are an authorized reseller for FileMaker Licensing? Contact us to discuss upgrading your FileMaker software. Download FileMaker Square Integration Database Please complete the form below to download your FREE FileMaker database file. Name* First Last Company Phone* Email* FileMaker Experience*New to FileMaker Platform Existing User of FileMaker Existing Developer of FileMaker Terms of Use I agree OPT-IN: I agree that I am downloading a completely free FileMaker application file with no strings attached. This database is unlocked, and I may use it for my business or organization as I see fit. Because I am downloading a free database, I agree that I should receive occasional marketing. I understand that I can OPT-OUT of these emails at anytime. Afficher la totalité du billet
  14. FileMaker: A Workplace Innovation Platform In 2018 a new term emerged to categorize software specifically made for building custom solutions for businesses. This new category labels FileMaker and similar software as “Workplace Innovation Platforms”. Let’s take a look at what a Workplace Innovation Platform is and how can it improve your business! What is a Workplace Innovation Platform? FileMaker, as the creator and leader of the Workplace Innovation Platform category, defines it this way: “A Workplace Innovation Platform like FileMaker allows you to build custom apps to match the unique needs of your business and help to better connect your systems, processes and employees.” G2 Crowd—a business software review site—also launched a Workplace Innovation Platform category in January 2019, and they offer an objective definition and list of requirements for these types of platforms. In order to be considered a Workplace Innovation Platform on G2 Crowd, the software must meet the following requirements: Provide both visual design and full-stack development tools Provide collaborative application management and secure communication capabilities Facilitate cross-platform availability via on-premise, cloud, or hybrid deployment Provide integration tools for connecting to systems, services, and platforms Provide a partner network, learning resources, marketplace, and/or user community Additionally G2 Crowd allows for customers of different Workplace Innovation Platforms to review the software in that category, and then ranks them based on market presence and customer satisfaction. Other platforms contained in this category on G2 Crowd include Airtable, Salesforce Lightning, K2, Quick Base, and others. As seen on the G2 Crowd grid as of Feb 2019, FileMaker, Inc. leads in both categories, and is considered the leader in the category of Workplace Innovation Platforms. What a Workplace Innovation Platform Can Do for You The benefits of a Workplace Innovation Platform for your business are vast. FileMaker lists 5 primary reasons to invest in a custom application in the workplace: Allows you to “escape the work rut” of tedious manual tasks “Bridges the gap” between current software used in the business Meshes your innovative ideas and expertise with your business’ software Provides the opportunity to go fully paperless Moves your business towards mobility Additionally FileMaker conducted a State of the Custom Apps study in 2018 to find out how custom applications have impacted businesses who use them. The customers surveyed belonged to businesses of all sizes and industries, and were located in North America, Europe, and Japan. Out of 370 FileMaker customers surveyed: 93% were able to reduce inefficient tasks 91% increased team productivity 76% reported a return on investment (ROI) 70% saw an increase in customer satisfaction Workplace Innovation at DB In our own words, a Workplace Innovation Platform such as FileMaker is a software platform that allows businesses of any size or industry to create a custom application that solves problems and paves the way for innovation and efficiency. Put simply, DB Services uses FileMaker to transform and innovate the way businesses operate. Whether it’s integrating several scattered business applications into an all-in-one solution for a company, eliminating tedious data entry, or allowing businesses to take their FileMaker solution out in the field via iPads or iPhones–we’ve done it all. Check out our Case Studies to see just a few of the ways that DB Services has used FileMaker to innovate workflows for businesses across the country. Conclusion Workplace Innovation Platforms such as FileMaker can provide fantastic benefits to organizations, regardless of size, industry, or location, allowing them to transform and innovate the way they do business. If you’re ready to see what FileMaker can do for you, contact us today for a free initial consultation! Did you know we are an authorized reseller for FileMaker Licensing? Contact us to discuss upgrading your FileMaker software. Afficher la totalité du billet
  15. FileMaker OneDrive Integration OneDrive and Microsoft Office 365 is one of the most popular business software packages and services on the planet. Its reach has expanded 238% since 2014 and 81% since 2016. And with the Microsoft OneDrive API, integrating has never been easier. OneDrive is excellent for sharing documents with other people without giving them access to your FileMaker system and allows for editing files without the hassle of downloading, editing, then re-uploading. We will walk through how to use the Microsoft OneDrive API to upload documents, list documents in a folder, and download documents, allowing your documents to be stored and shared easily in the cloud to keep your FileMaker database lean and mean.  What You Need You must have a OneDrive account to use this article’s integration which is included in the Office 365 package. Also make sure you have admin access to your Office 365 subscription if you have a business or school user account. Creating a Microsoft Graph Application Make sure you a create Azure AD Tenant first if you are using a personal account and not work school account. Similar to other API integrations, you need to create an app first. Go to the application registration portal and add an app. You will be given an application ID and a new key pair that you can use to make API calls from FileMaker to OneDrive. Managing App Permissions Microsoft OneDrive requires that each user give the app permissions to be able to read/write data from their OneDrive. Before users can give permissions, you need to set up the default permissions on the application registration page. You’ll need one delegated permission for this OneDrive Integration: Files.ReadWrite Authenticating With Microsoft Graph Once you have your API information, you will need to authenticate your solution with the OneDrive API. The sample file at the end of the article has the calls & web viewers that you can reference to authenticate FileMaker with OneDrive. When the user clicks the Connect button, they will be asked to log in to their Microsoft account and approve delegated permissions for the application. After the user logs in, a FileMaker script parses the redirected page’s URL for the client ID and auth codes that will be used for requests to OneDrive. Making Requests And Parsing The Response Microsoft OneDrive API supports multiple types of requests such as HTTP POST, GET and DELETE. You can perform all actions by using the native Insert from URL[] script step and giving it a valid URL and cURL options including required fields within the JSON body specified by the documentation. Here’s a sample request body to download files from a folder. Note how the DateTime element is formatted. For more details, refer to Microsoft OneDrive documentation under the List Children Page. -X GET https://graph.microsoft.com/v1.0/me/drive/items/E9953196A1CE2F19!28596/children?$expand=thumbnails --header "Authorization: Bearer EwBwA8l6BAAURSN/FHlDW5xN74t6GzbtsBBeBUYAAROJk..." The response will have an array of documents from the selected folder and will include URLs to the thumbnails so we can download those in a bit. You’ll also notice that some of the object names are prefixed by “@odata.” which will not work with FileMaker’s built-in JSON functions, because FileMaker does not allow periods in an objects name. If you need to read one of these properties, you can simply substitute the entire object to remove the prefix. Substitute ( $response ; "@odata." ; "" ) Downloading Files Downloading a file is relatively easy once you know a quirk of the FileMaker cURL library. By default when you try to download a file it first authenticates your call, and then redirects you to download the file. FileMaker will not follow the redirect and won’t return anything unless you include the -L or –location flag in your cURL command. Another tip is that you can pass the –output flag with a URL encoded file name when downloading, to ensure the downloaded file has the correct name. -X GET https://onedrive.live.com/?id=E9953196A1CE2F19%2129992 --header "Authorization: Bearer EwBwA8l6BAAURSN/FHlDW5xN74t6GzbtsBBe..." -L --output Screen%20Shot%202019%2D01%2D14%20at%204%2E54%2E41%20PM%2Epng Uploading Documents Uploading files to OneDrive is a bit more difficult. OneDrive provides 2 API methods for uploading docs, one for files under 4MB and another resumable upload method for larger files. We will strictly be using the resumable upload method as it is more flexible. The first thing you need to do is to create an upload session. The documentation is not very clear on how to do this. You’ll need the folder ID you want to upload to and the filename URL encoded. When constructing the URL you’ll need colons after the folder and filename, though the documentation makes no mention of this. -X POST https://graph.microsoft.com/v1.0/me/drive/items/E9953196A1CE2F19!29992:/picture%2Epng:/createUploadSession --header "Authorization: Bearer EwBwA8l6BAAURSN/FHlDW5xN74t6GzbtsBBeBUYAAQScvI1+tUkC1GcS1z+E6..." --header "Content-Type: application/json" -d { "@microsoft.graph.conflictBehavior": "rename", "description": "description", "fileSystemInfo": { "@odata.type": "microsoft.graph.fileSystemInfo" }, "name": "Screen Shot 2019-01-14 at 4.54.41 PM.png" } This will return an uploadUrl that you’ll use to actually upload the data to. { "@odata.context":"https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.uploadSession", "uploadUrl":"https://api.onedrive.com/rup/e9953196a...", "expirationDateTime":"2019-01-31T18:16:08.186Z", "nextExpectedRanges":["0-"] } After you have the uploadUrl you need to calculate the content range of the file so we can tell the API what bytes we are uploading. You can use GetContainerAttribute ( TABLE::container ; “fileSize” ) to get the size of the file in bytes. From there you just can determine the content range. The range starts at zero, while the total starts at one, meaning a 25-byte file will have a content range of 0-24 and a total byte size of 25, thus setting the content range to 0-24/25 is telling the API that we are uploading the entire file. To actually upload the contents of a container you’ll first set a variable with the contents of the container and then you’ll use that variable with the -T or –upload-file flag. -X PUT https://api.onedrive.com/rup/e9953196a... --header "Content-Range: bytes 0-24/25" -T $data Displaying Files and Folders in FileMaker One thing you’ll want to keep in mind when working with the API is that you’ll need to store a representation of all the files and folders as records in your FileMaker solution. In the sample file, I have a file table to store the document names, OneDrive ID, size, etc. You might also want to include a container field to store a thumbnail of your files as well, which are quite small at around 100px by 100px. OneDrive will also generate thumbnails of file types FileMaker doesn’t natively support such as Word and PowerPoint. Conclusion The Microsoft OneDrive API can help keep your database size down, make sharing files easier, and allowing you to edit files without downloading and re-uploading to FileMaker. Contact us if you need help integrating your FileMaker solution with OneDrive! Download FileMaker OneDrive Integration Database Please complete the form below to download your FREE FileMaker database file. Name* First Last Company Phone* Email* FileMaker Experience*New to FileMaker Platform Existing User of FileMaker Existing Developer of FileMaker Terms of Use I agree OPT-IN: I agree that I am downloading a completely free FileMaker application file with no strings attached. This database is unlocked, and I may use it for my business or organization as I see fit. Because I am downloading a free database, I agree that I should receive occasional marketing. I understand that I can OPT-OUT of these emails at anytime. Did you know we are an authorized reseller for FileMaker Licensing? Contact us to discuss upgrading your FileMaker software. Afficher la totalité du billet
×
×
  • Create New...