Jump to content

DB Services

Membres
  • Content Count

    118
  • 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. DB Services Named FileMaker Growth Partner of the Year 2019 On August 8th, 2019, DB Services was named the FileMaker Growth Partner of the Year for the Americas for 2019. This is DB Services’ third consecutive year bringing home this prestigious award from FileMaker, Inc–now rebranded to Claris International, Inc. This award is given annually to each region’s FileMaker partner that achieves the highest revenue and brand growth for Claris. FileMaker is currently ranked the #1 Workplace Innovation Platform in the world. DB Services’ mission is to make organizations more efficient and effective through the use of custom applications. With over 15 years of experience in FileMaker development, DB Services is dedicated to advocating for and continuing to grow the FileMaker community. “We are proud to be a part of such a great community and humbled to win the FileMaker Excellence Award for Partner of the Year. To win the award three years in a row means that we have great people and great customers. It’s exciting to watch our customers grow and our people grow each year,” said Kevin Hammond, CEO, DB Services. Since 2003, DB Services has provided custom applications and workflow solutions to Fortune 500 companies, small businesses, K-12, universities, and non-profit organizations. DB Services is also FileMaker Business Alliance Platinum Member, and offers FileMaker Development, FileMaker Support, FileMaker Training, FileMaker Cloud Hosting, and FileMaker Licensing. Between the 20+ full time Certified FileMaker Developers and FileMaker Growth Partner of the Year for the Americas awards for 2017, 2018, and 2019, DB Services is considered one of the top FileMaker partners in the country. For a complimentary consultation contact DB Services at 888-488-0191, or fill out a Contact Form on DB Services’ website. 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. DB Services Named to Inc. 5000 List For the first time, DB Services has been ranked #3494 on the annual Inc. 5000 list, which ranks the country’s “fastest-growing innovators” based on overall revenue growth over a three-year period. The Inc. 5000 list has brought attention to America’s growing private businesses since 1982. DB Services now joins the ranks of other Inc. 5000 list alumni such as Facebook, Zappos, Pandora, and others. DB Services is top ranked FileMaker Platinum Business Alliance Partner on the 2019 Inc. 5000 list. DB Services joins 63 other Indiana-based companies, and ranks #42 in the state. DB Services’ mission is to make organizations more efficient and effective through the use of custom FileMaker solutions. Since 2003, they have provided custom applications and workflow solutions to Fortune 500 companies, small businesses, K-12, universities, and non-profit organizations. DB Services is a FileMaker Business Alliance Platinum Member that offers FileMaker Development, FileMaker Support, FileMaker Training, FileMaker Cloud Hosting, and FileMaker Licensing. For a complimentary consultation with one of our Certified FileMaker Developers, call the main line at 888-488-0191, or fill out a Contact Form. Afficher la totalité du billet
  3. FileMaker, Inc. is Now Claris International, Inc. Earlier this year, FileMaker was announced as the top Workplace Innovation Platform in the world, and on August 6th, FileMaker, Inc. announced their rebrand to Claris International, Inc. as well as the acquisition of Stamplay. FileMaker Reborn as Claris The name change is a return to the original name of the company, which was called Claris from 1986-1998. FileMaker, Inc. has been the name of the organization since 1998, a change that was made to reflect their focus on the FileMaker product. Now as the company looks to expand past just the FileMaker product, it has been rebranded back to their original name Claris. The rebranding to Claris International, Inc. is also a commitment to meet the company’s mission: bringing “power to the problem solvers”. Claris International, Inc. CEO Brad Freitag says: “Claris stems from the Latin root ‘clarus,’ which means ‘clear, bright and shining’. Nothing better encapsulates the company’s mission: to empower the problem-solver with smart solutions that work for their business. By extending the reach of our platform as a modern, multi-faceted, and powerful merger of on-premises custom apps and third-party services, our customers can streamline their business processes across the cloud services that they use every day.” Claris Connect The company also acquired the Italian startup and product Stamplay, and rebranded it Claris Connect. The product will allow users to integrate easily with 3rd party cloud software, connect cloud and on-prem software and quickly integrate common business applications such as MailChimp, Slack, and more. The Future of Claris Looking ahead, Vice President of Products & Design, Srini Gurrapu forecasts that Claris Next Generation will “leverage the full power of modern workflow apps”, and use AI to create apps “delivered as a service.” Kevin Hammond, DB Services CEO, is looking forward to the future of Claris. “Claris International is now the parent company of the platform and FileMaker becomes one of many different offerings to customers. We are very excited about Claris Connect, Claris Next Gen, and Claris FileMaker as they will provide more innovation and value to customers.” DB Services is a Claris FileMaker Platinum Business Alliance Partner that offers FileMaker Development, FileMaker Support, FileMaker Training, FileMaker Cloud Hosting, and FileMaker Licensing. For a complimentary consultation with one of our Certified FileMaker Developers, contact DB Services at 888-488-0191, or fill out a Contact Form here to get in touch. 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 Salesforce Marketing Cloud Integration As one of the top email marketing platform, Salesforce Marketing Cloud provides the ability to create marketing email campaigns that scale from a handful of customers to millions. And with Salesforce Marketing Cloud’s SOAP API and automation tools, you can automatically import email engagement statistics into your FileMaker application and link them to customers and prospects.  Setup The first step is to create a new app package from the Salesforce Marketing Cloud setup page. Once created, the client ID, client secret, and base URIs can be used to begin the process of authenticating your FileMaker application with the Salesforce Marketing Cloud SOAP API. Authenticating With Marketing Cloud Using OAuth 2, example calls to authenticate with the Salesforce Marketing Cloud API and receive an access token are included in the sample file at the end of this article. The body of the token request includes your client Id, client secret, account ID, and grant type. Your account ID can be found on the Salesforce Marketing Cloud dashboard by clicking on your business unit’s name. Once an access token has been retrieved, you can use FileMaker’s Insert From URL[] script step and supply your SOAP base URI and cURL options to pull statistics from Salesforce Marketing Cloud. You can specify which objects and object properties you would like to retrieve in your request body. Parsing the Response The API’s response will be returned as an XML object and will require parsing. Using the BaseElements plugin by Goya, we are able to parse out the data we need with the XPath function. In the example file, we download an array of send objects with stats such as, total clicks, opens, bounces, and unsubscribes. A send object contains a collection of information for a batch of emails sent. Retrieving Detailed Stats To retrieve detailed information on individual users who interacted with a particular email, an automation can be set up on Salesforce Marketing Cloud to export a .csv file of interactions in a specified interval to a business unit’s FTP. On FileMaker’s end, a script can be used to parse this .csv file from the FTP to create records for individual interactions. Marketing Cloud FTP First you will need to set up an FTP for your Salesforce Marketing Cloud account. You can do so from the Salesforce Marketing Cloud dashboard by going to your user setup page and selecting FTP Accounts from the Data Management section. Marketing Cloud Automation To set up a new Salesforce Marketing Cloud automation, select the Automation Studio option from the Journey Builder dropdown menu on the dashboard page. From here, click the New Automation button. This screen features a drag and drop interface to set up different automations. First, create an automation that has a Schedule starting source and drag a data extract as the first step. The data extract step can be configured to export various fields for each interaction and the file format of the extract. At the minimum, we recommend selecting the following items on the extract: Extract Bounces Extract Clicks Extract Opens Extract Send Jobs Extract Sent Extract Spam Complaints Extract Survey Responses Extract Unsubs Include Test Sends Include Unique Clicks Include Unique Opens Second, drag a file transfer to the canvas. In this step, the export name and destination can be set. The destination will be selected as the FTP you set up earlier. Since SFTP is used for Salesforce Marketing Cloud and FileMaker’s Insert from URL[] script step doesn’t support SFTP, data can be imported into FileMaker using the BaseElements plugin. The HTTP_GET, HTTP_GET_File, and Unzip functions can be used to download and unzip the file exported by Salesforce Marketing Cloud. Included with the sample file is an example .csv file of clicks that was generated by a Salesforce Marketing Cloud data extract. Conclusion If you’re looking to automatically import email engagement statistics into your FileMaker application, the Salesforce Marketing Cloud API and automation tools makes downloading data seamless. Contact us if you need help integrating your FileMaker application with Salesforce Marketing Cloud! Download the FileMaker Salesforce Marking Cloud 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. Did you know we are an authorized reseller for FileMaker Licensing? Contact us to discuss upgrading your FileMaker software. Afficher la totalité du billet
  5. FM Data Migration Companion In our previous article, we discussed the FileMaker Data Migration Tool and all of its great benefits: instead of spending hours building custom migration scripts, you just write a command that automatically transfers data from one file to another. This saves time, money, and headache for everyone involved. And to make the process even easier, we built the FM Data Migration Companion, a FileMaker file that automatically creates the data migration CLI commands for you for both single-file and multi-file FileMaker applications. Let’s take a look at how companion works.  Adding Latest Data Migration Tool to the Companion The first step to using the companion is to place a copy of the latest FileMaker Data Migration Tool into the companion’s preferences section. This allows you to keep all of the migration tool’s files in once place and download them wherever you need to. Before running any migrations, you’ll need to insert the file path of the data migration tool in the “Migration Tool File Path” field. Note that a FileMaker Developer Subscription is required to download the data migration tool. Mac users will need the single executable file, while PC users will need a series of files including an .exe file. Preparing Your Files Once the tool is downloaded, you’ll need to prepare your FileMaker application’s .fmp12 file(s) for the migration. One set of files will contain the data (the source files, aka the previous version of the application), while the other set of files will contain the structure and schema (the clone files, aka the new version of the application). Normally, you would grab the paths for every file and use them to create commands. With the FM Data Migration Companion, none of that is necessary. You can use the “Create Folder” button in the “Migration Paths” section to create a timestamped folder on your machine. This folder contains 3 sub-folders: “Source”, “Clone”, and “Output”. Just place the source file(s) in the “Source” folder and the clone file(s) in the “Clone” folder. Creating Migration File Sets Once your files have been added to the correct folders, click the “Check Migration Folder For Files” button. If you are migrating multiple files, the FM Data Migration Companion will attempt to match the source and clone files together and create individual “migration file sets.” You can also manually create each file set using the “New Fileset” button if you would like. Think of a “migration file set” as an individual migration command: it has source, clone, and output file paths; connection and encryption information; and other various migration instructions. If you have multiple file sets, chances are your access credentials will be the same for each file; this is where “Default Login Information” and “Default Migration Settings come in. Instead of creating the migration settings for each individual file set, you only need to fill them out once and click “Use Default Migration Settings For All Files” and “Use Default Login For All Files.” This applies your credentials and settings to all file sets. Running a Migration Now that your settings are all correct, it’s time to run the migration(s). You can do this in two ways: run all migrations at once (if you have multiple file sets) or individually. Regardless of which option you choose, a Terminal or CMD window will pop up and run the migration for you. If you choose to run multiple migrations, each will automatically be run one-by-one in a big chain. A header is printed above each migration in the command line window indicating which file set is currently being migrated (e.g. 2 of 10). The output files will be placed in the “Output” folder by default, but you can change this location on your individual file sets. Conclusion The FM Data Migration Companion makes using the FileMaker Data Migration Tool a breeze whether you’re migrating 1 file or 40 files. With this tool, you’ll never have to type another migration command ever again. Contact us if you need help migrating data! Download the FM Data Migration Companion 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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
×
×
  • Create New...