Jump to content
  • Welcome to FMFourms!

  • Our picks

    • Announcing WidgetStudio – FileMaker WebViewer Widgets
      WidgetStudio makes it easy to use, design and share powerful interface widgets, like calendars, gauges, charts, and timers. Pick from the constantly growing set of included widgets or build your own. Freely share them with your customers or friends.
      The post Announcing WidgetStudio – FileMaker WebViewer Widgets appeared first on Geist Interactive.

      View the full article
        • Like
      • 0 replies
    • 24U Software updates all plug-ins for FileMaker Pro
      All 24U plug-ins are now code-signed for better security

      Prague, CZ — January 31, 2019 — 24U Software has released a new updates of all currently available 24U’s plug-ins for the FileMaker platform. The just released new versions of the following plug-ins are now code-signed for macOS, Windows, and iOS:

      - Gonector
      - 24U SimpleDialog Plug-In
      - 24U SimpleFile Plug-In
      - 24U Phone Companion Plug-In
      - 24U Phidgets Plug-In
      - 24U Simple Talk Plug-In
      - 24U Toolbox Plug-In
      - 24U SimpleSound Plug-In
      - 24U SimpleHASP Plug-In
        • Like
      • 0 replies
    • 360Works Releases New Major Version, Zulu 3: Calendar Syncing Application - Integrate FileMaker with Apple, Google, and Exchange Calendar
      New Major Version, 360Works Zulu 3
      FileMaker Calendar Syncing Application

      Integrate FileMaker with Apple, Google, and Exchange Calendars. Now with Recurring Events Support, Improved Speed and Stability, Email Handler for Admin Sync Reports, and Exposed Google API key.

      360Works is pleased to announce the release of Zulu 3. Zulu is a calendar syncing application that lets Apple Calendar, Google Calendar, or Exchange Calendar see your FileMaker table(s) as an Apple, Google, or Exchange Calendar.
      • 0 replies
    • NEW: 360Works Now an AWS Consulting Partner
      360Works is Now an AWS Partner

      360Works, a leading FileMaker product developer and innovator, is now additionally an AWS (Amazon Web Services) Consulting Partner! The AWS Partner Network (APN) is comprised of technology experts that are focused on helping customers take full advantage of all the benefits in the AWS universe of services. As an APN Consulting Partner, 360Works will provide services that help customers design, architect, build, migrate, and manage their workloads and applications on AWS.
      • 0 replies
    • Karbon Webinar – Getting Started
      Free webinar introducing Karbon our free application framework for building ambitious custom business applications. If you are interested in using the FileMaker Workplace Innovation Platform at a high level you'll probably want to see what we have cooked up.
      The post Karbon Webinar – Getting Started appeared first on Geist Interactive.

      View the full article
      • 0 replies
  • Topics

  • Blog Entries

    • By Todd Geist in Geist Interactive
      WidgetStudio makes it easy to use, design and share powerful interface widgets, like calendars, gauges, charts, and timers. Pick from the constantly growing set of included widgets or build your own. Freely share them with your customers or friends.
      The post Announcing WidgetStudio – FileMaker WebViewer Widgets appeared first on Geist Interactive.

      View the full article
    • By John Mark Osborne in The Philosophy of FileMaker
      Ahhh... the ubiquitous notes field. Seems simple, right? In a way it is. Just slap down a field and resize it to show more data. Add a scroll bar and you're done. The problems occur when you are trying to locate an important note, print a report or perform a find. Data can be strewn all about a text field that allows free form entry and supports up to ten million characters. Imagine hundreds of different users trying to follow the exact same format for data entry. Pandemonium! This article will discuss two major techniques for storing notes along with subtle tweaks to help make organization better.

      View the full article
    • By eXcelisys in eXcelisys' Blog
      I Got Quicker at Debugging and So Can You
      Eradicate those Annoying Little Code Demons with these Tools and a Few Lines of Custom Code I Developed

      by Michael Suhrbier, eXcelisys Web App Developer
      You’ve probably heard of these PHP / MySQL debugging techniques:
      Xdebug — Great if you can get it working. BackTrace(), print_r(), var_dump(), etc. — Very useful but usually very ugly and not easy for humans to read and understand. PHP / MySQL logs — Fine for the average user, but let’s explore some methods for putting these guys on steroids. Xdebug is great when you can get it to work. However, I’ve spent days getting it to behave correctly. With multiple clients to tend, setting this up for each one is not the best use of my time. I won’t even go into the details. Instead, I will focus on easy-to-install, use and understand tools.
      Can’t Find the Issue? Try Kint
      My favorite tool of all times is a little-known library called Kint. I could not develop custom websites as efficiently as I do without it.
      This is one of those rare tools that actually makes you go WOW, where have you been all my PHP career? I don’t even start a project until I have it “installed,” by which I mean, use the 1-line include:
      That’s all you need, but what does it do?
      Have you ever wondered what is in a variable, a class, an array, or just about anything? Just throw it in Kint and you will know!
      The output is beautiful, full of details and easy to understand. You are even given copy-and-paste code to get at the value you want!
      Have you ever banged your head trying to figure out what eXactly is in a form post? Just hand it to Kint!
      How about, What the hell is in that class and how do I use it? Again, copy and paste the property or method you are after. Seriously, that’s cool!
      Kint has many modifiers that are great for AJAX and plain text as well.
      I’ve used Kint in many situations, but where I use it most often is for API responses. I don’t have to format the API response at all initially so KINT tells me eXactly what the structure of the response looks like and how I can best get at the parts of the response that I need.
      Hustle that Code with PimpMyLogs
      So what’s wrong with error_reporting(E_ALL) or just scanning the logs manually?
      Again, nothing really, if you like digging for gold in them thar hills. Here’s one approach.
      Using ini_set('display_errors', 1); (show errors on front end) is great in development but not so much for production. So, I just read the logs … again, great, if you can find the logs and you don’t mind eXamining line-by-line for that gold. Take a shot if you grep the snot out a console window and think I’m lazy! Now for the easy way! A super, simple-to-install tool that does just what it says.
      Install via GIT:
      Install via Composer:
      Or the ole fashioned way (via archive):
      Now that you have it installed, just open it in your browser and use the browser-based configuration tools. http://server_ip/PimpMyLog/
      I’ve installed it at least a dozen times already and each time it was able to find the log files automatically, but you may need to find your log paths and enter them manually.
      Now you have some pimped logs!
      PimpMyLogs is browser-based so you are not jumping through hoops every time you need to see what’s going on with your custom web app. Plus, it can automatically refresh.
      PimpMyLogs is great for debugging AJAX calls that might be hidden or otherwise hard to see. Having the desktop notifications turned on also helps because I can simply run my app or site until I see an error pop up in my taskbar without having to switch back and forth.

      MySQL Debugging
      OK, this might be misleading. I’m not talking about debugging SQL syntax, but how many times have you seen this in your logs?
      Not real helpful is it? I once watched a co-worker at a major healthcare provider struggle for weeks tracking down an SQL error that was flooding the logs. I sat at lunch thinking, There has to be a better way than guessing and doing code searches on huge code bases.
      So I came back and wrote this simple — yet powerful — function that leverages the ease of PHP built-in logging and MySQL error reporting. I added this code to our sql.lib.php and had the problem code within seconds.
      Place this where your queries are happening or directly after what you suspect is your problem area. I simply place it in the SQL library/class (/libs/sql.lib.php) for the app like so:
      You only need to adjust 2 things.
      $con_link (which is just your connection string) '/home/sites/site/dev.michael_lojack.log' (where do you want to write your custom log file?) This code is by no means perfect and probably could be optimized, but I only use it when I have a tough-to-track SQL query, so I’m not terribly concerned about the performance.
      You are probably wondering why I didn’t just head for the MySQL error log. I’ve never actually worked on a site that had it enabled, so apparently, this is not a common thing.
      But why a custom log? Well, PHP logs by default truncate error messages. I have tried every command I could possibly find to avoid truncation. This is the best solution I have found so far, plus I can add a bunch more useful information like the backtrace and URL that triggered the error.
      Here’s what the result looks like:
      Now, I have a copy-and-paste SQL string to test. In this case, the problem was obvious. My function call was missing a variable; therefore, it was dropping the word “paid” in where a query limiter should have been. I use this trick all the time because it makes me more efficient when providing web application services for clients.
      Go Forth and Debug with Confidence Using These Cool Debugging Tips
      I hope the title of this post didn’t mislead you into thinking I had discovered some magic silver bullet that would help you find errors and problematic code. Of course, there isn’t a quick magical remedy, but these debugging tips and tools used together will greatly increase your ability to find problems.
      I also suspect that many of you are probably saying, “Just use Xdebug” or one of the other real-time debuggers, but that isn’t always possible. Plus, each of these tools will be useful at some point on its own. Part of what I’m often tasked with here at eXcelisys is to put on my software detective hat and find that pesky bug that only appears occasionally. These tools help take the guesswork out of the process and save my clients time and money.
      So now for a shameless plug. Do you have an app or site that is misbehaving? Talk to one of our Solution Consultants about our website repair services and request that I take a look at your issues. It doesn’t matter if it’s PHP debugging, MySQL debugging, whatever. I’d love to take a swat at it!
      To read more web tips and tricks from our web app developers, check out eX-Cetera, our blog where we offer WordPress Tips and Tricks and other general Web Tips and Tricks.
      **This article is provided for free and as-is; use, enjoy, learn, and experiment at your own risk – but have fun! eXcelisys does not offer free support or free assistance with any of the contents of this blog post. If you would like help or assistance, please consider retaining eXcelisys’ website maintenance and support services.
      About eXcelisys, Inc.: Founded in 2001, eXcelisys (www.excelisys.com) is an FBA Platinum Partner and FileMaker Certified developer organization. eXcelisys specializes in designing, developing, customizing, supporting, consulting, migrating, upgrading, fixing and integrating database solutions for Desktop, Mobile, and Web applications. Our core technology competencies are FileMaker Pro, FileMaker Go, and MySQL for database frameworks, along with FileMaker WebDirect, WordPress, MySQL, PHP, CodeIgniter, PostgreSQL, Joomla, Drupal, Magento, CSS, HTML5, and Javascript for websites and web applications. Aside from providing eXcellent customer service, our goals are to use these technologies to intuitively automate your organization’s data solution needs seamlessly and flawlessly across the web, mobile, and desktop platforms. Contact eXcelisys today for a free estimate and consultation about making your business more efficient through intuitive and effective software automation. 866-592-9235.
      The post I Got Quicker at Debugging and So Can You appeared first on eXcelisys.

      View the full article
    • By FileMaker Magazine in FileMaker Magazine
      When you're the one creating the database, you're the one who says which data makes it in and which data doesn't. This all happens through the various methods of data validation.
      Data is either considered valid or not - and this happens according to your data validation rules. If the data is valid, then everything proceeds as normal. If, however, the data isn't exactly what's required, then you get to choose what happens.
      In most cases, you can let the user keep taking a whack at it until they get the right combination, or you can shuttle the user off to another part of your UI.
      In this tutorial video, we take a look at the three primary tools FileMaker provides for data validation. You can use any single option or combine them to mix and match for the perfect data validation solution. We've even got a nice little text formatting mask feature which provides a great looking phone number field.
      Click the title or link to this article to view the video.

      View the full article
    • By Todd Geist in Geist Interactive
      Join us for a free webinar about Otto, our Automated Deployment and Dev-Ops utility for FileMaker Server. Otto handles the tedious, and error-prone tasks of transferring files to servers and performing data migrations.  If you regularly have to perform data imports and data migrations on your FileMaker systems, you will want to attend this webinar. In this webinar, […]
      The post Otto Webinar appeared first on Geist Interactive.

      View the full article
  • Create New...

Important Information

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