Category: Filemaker Development

If I were to tell you that recent movies like "Skyfall," "Gravity" and "The Dark Knight" were successful because of the special effects that were used on them, you would not be surprised. However, if I told you that FileMaker played a major role in this, that might.

According to a recent article from CBR, London-based Framestore was the company behind the visual effects of these movies and many more. They employ over 600 artists, computer scientists and developers. However, keeping everyone on the same page when you are dealing with single frames of a multi-million dollar movie can be extremely difficult.

This is where FileMaker came into play. According to Alex Jackson, a software developer at the company, on every movie shoot there are piles of data produced including camera shots, lens height and color space. With FileMaker, the company is able to use the rapid development platform to allow staff to initiate and make changes to projects quicker, saving the company thousands of dollars in the process.

"The fact that many film and TV production companies use FileMaker means data shared with and from clients is often in this format, making projects seamless," Jackson said. "The flexibility provided by FileMaker is also vital for us to effectively manage constantly evolving projects and allows hundreds of people from inside and outside our business access to the data."

This means the visual effects artist can access things that are shot that day on a smart device or desktop, make suggestions if a reshooting is needed to improve an effect and those can be put to film almost immediately.

This is just one real world example of how a FileMaker developer can help a company save money and improve operations.

Every business considering a partnership with a FileMaker developer is going to have questions. In this series we will address the frequently asked questions that our customers have about our services.

Answer: One of the most important things for every software solution is keeping it upgraded. While it may seem easy to stay with a solution that has been effective in the past, newer versions of software are often evolved, bring new features and are more secure.

The downfall of not upgrading has been a major topic in the tech world and has been front and center in 2014 because of the Microsoft operating system Windows XP. For 13 years it has been an effective piece of software running computer systems, point of sale terminals and even ATMs. However, this year the company announced that it will no longer be issuing security and support upgrades for XP.

This is because Microsoft has already released several new versions of its core operating system and continuing to support an outdated version, even is some users prefer it, is no longer cost effective. The April deadline has come and gone, leaving some users struggling to catch up.

FileMaker is no different. New versions of the software are being designed to take advantage of the latest technologies like mobile devices, the cloud and web-access. Many of these features have been updated in last years FileMaker 13 upgrade.

If your company is looking to upgrade, Kyo Logic can help. We are experienced in this process, completing more than 100 upgrades for our customers. Not only can we help with the easy move from FileMaker 11 to 13 but also the more complicated two stage process of moving from FileMaker 6 to 13. We also can provide a short white paper outlining the steps that will need to be taken.

Every business considering a partnership with a FileMaker developer is going to have questions. In this series we will address the frequently asked questions that our customers have about our services. 

Answer: When creating a new database on the FileMaker platform or any other, one of the keys to success is maintaining the servers that information is processed on. This is needed to not only ensure that data stored on them remains secure at all times, but also to head any potential problems off at the pass.

When your company partners with Kyo Logic to help create a new database, we take full responsibility when it comes to the FileMaker server machine. This takes the pressure off of your company to handle several solutions and instead focus on the data that is being created to improve how your company operates.

Kyo Logic will stay on top of installing all patches and updates to the operating system, FileMaker Servers and add any plug-ins that are released.

We run consistent reviews that can be used to adjust user permissions and examine the server logs for any sign of trouble. This keeps the systems ahead of any potential issues that could cause downtime for your business.

Kyo Logic also verifies to ensure that the backups are running correctly at all times and that there is enough disk space available to house all of the data that is being collected.

All of this information about the server's performance will be provided in a verbal report and checklist to the client to make sure that everyone is on the same page.

If you were to create a tool kit for any entrepreneur of the must-have gadgets to start their business with, the iPad would certainly be included. The device has made it possible for companies to effectively integrate a mobile element to their business.

Now, with the right applications, the mobile device can become nearly any tool that an organization could need. Plug in a Square credit card reader and it's a POS system. Sales people in the field can enter customer information or access critical data to help meet customer demand. It is also possible to run HR, manufacturing projects and countless other business tasks from the palm of your hand.

However, it can be difficult for small and midsized businesses to decide which apps they truly need if they are getting into the mobile landscape for the first time. Last month, NetworkWorld created a list of seven free iPad applications that businesses should download. Topping it was FileMaker Go.

"If you're a FileMaker Pro user on your PC or laptop, FileMaker Go lets you access these database apps from your iPad (note: the PC version is still needed to create, modify and sync your databases)," the post reads. "Version 12 in 2013 was a big change: lots of new features and controls, improved multimedia capabilities, multitasking support, greatly improved speed, and available free for the first time."

Businesses that are new to these systems can partner with a FileMaker solution provider to develop a plan, learn the software and start reaping their benefits.

Many organizations need to create a comprehensive database and certain tools are more popular than others.

A recent article from CITEworld profiled Berklee College of Music in Boston and features an interview with Damien Bracken, the dean of admissions. He mentioned that every year there are roughly 7,200 applicants and to figure out who is the most qualified talent, team admission staff must travel the globe to 120 sites to interview talent and evaluate not only talent but also potential.

To keep all this information updated, secure and streamlined, Berklee employees were required to carry laptops to enter all of this data when it was fresh. The organization was finally able to ditch the heavy computers on 2012 in favor of iPads because FileMaker – the database software the school has been using for over 20 years – released a mobile platform.

This allowed the officials to stay within a single application ecosystem. Now, all 30 members of the school's recruiting team carry the tablet and use the cloud-based software to take notes and upload them to the department from the road.

"Prior to FileMaker Go, which was designed for the iPad, we used some other products but they weren't up to par," Bracken said. "We needed something at a very professional level. As soon as this application came out it was like the sea parting for me, seriously. Having that available on a mobile device is huge for us."

He added that by using this kind of approach, it gives students the feeling that the school has all its ducks in a row when it comes to data.

This is one example for how a FileMaker solution can revolutionize how a business operates.

In a guest column from CitizenTekk, Brad Wilson, the Rentals Manager at Keslow Camera, spoke about how his company has been able to improve business processes through the use of FileMaker. As one of the largest camera rental companies in the Hollywood area, the organization provides equipment that is used in some of the biggest television shows and movies.

However, this also means there can be piles of paperwork to make sure all cameras are accounted for. This is where FileMaker can come into play. Wilson described several ways that operations have improved include:

• Going paperless – It is now much easier to look up order forms or check inventory. This lets employees answer client questions quickly, closing deals more effectively.
• Incorporate additional hardware – Because FileMaker can be used with multiple systems easily including Macs, iPads, iPod Touches and iPhones, employees now have a much easier way to access information and can help address customer needs from anywhere. This also helps manage business in off hours or during emergency calls.
• Improve speed – In a competitive marketplace, speed is everything. With this database, the company can submit bids quickly after checking to make sure they know all the information needed for an accurate assessment.

"The database is hosted on a Mac Pro for easy access across Keslow Camera's offices in Los Angeles, Chicago, Miami, Santa Fe, and New Orleans," Wilson said. "Managers and staff can tap into the information they need anytime, from anywhere, including via iPads and iPhones. The FileMaker Go app brings the full, rich application to Keslow's iPad and iPhone users – it's not just a slimmed-down version of the database."

With the help of a FileMaker service provider, any organization will be able to follow this path and create a better form of database.

Apple's Worldwide Developer Conference (WWDC) is one of the top software conventions in the industry. Last year, the company gave developers the first view of iOS 7 and OS X 10.9 Mavericks. These were then put into Beta and those with access started troubleshooting.

According to Tech Day, this year's annual event will be held June 2 through 6 at San Francisco's Moscone West. The five-day convention will again present the future of both the mobile and computer operating systems and if history holds true, this years event will have announcements that point to the next big moves for the company and consumers.

While tech enthusiasts will focus on this event because it is a major unveiling for the company, it also means that partner companies will need to adjust to change. Aside from software, the company has also unveiled hardware upgrades like the radically redesigned black cylinder Mac Pro that was unveiled last year.

For companies like FileMaker, this is the unveiling of the platform and hardware that their solution will be paired with.

As we reported last month, FileMaker recently announced its Developer Conference for July 28-31. It is highly likely that what is announced at the WWDC will impact this event, as it could have a direct impact of what the company has planned.

Regardless of what is announced by Apple, it will play a role in the future of solutions that are created by custom database software developers that use FileMaker as their primary tool.

Every software solution goes through a number of updates in order to remain effective. These can be patches to rectify new security threats, updates to existing software glitches or improvements to an existing solution. A majority of the time, these updates are needed to keep the systems firing on all cylinders.

This week, FileMaker released new versions of many of its solutions. This includes FileMaker Pro 13.0v2, FileMaker 13.0v2 Advanced, FileMaker Server 12.0v5 and the Mac version from OS X 10.9 Mavericks only and FileMaker Go 13.0.3 for the iPad and iPhone.

The Pro update addresses the limitations related to the FileMaker Pro URL protocol. It also includes general bug fixes pertaining to calculations and scripting, layout rendering and text editing.

FileMaker Go 13.0.3 expands file transfer capabilities to include moving files between iOS apps on the same device and transferring files between apps on other devices using AirDrop. It also addresses bug fixes and various compatibility issues. 

Making the decision to upgrade a software solution is not easy, especially if it is being used with critical business operations. The IT department needs to make sure that any and all updates are compatible with the other systems. For example, if you are running an older version of the Mac OS, the new FileMaker Server update will not run on this.

If you are a small business, keeping track of all this can be complicated. With the help of a Connecticut FileMaker developer, any organization will be able to assess their current solutions and learn about the new ones.

There are many systems in the corporate landscape that require business professionals to learn a new set of skills to be successful. However, learning these systems is not as easy as it seems, and because of how advanced the solution is, learning the skills could be complicated.

According to a press release from the company, FileMaker has released a new version of its training services series that is designed to help businesses learn the essentials of FileMaker 13. The system is available through Book and DVD, PDF and iBooks.

"Learn how to build a custom solution utilizing the full capabilities of the FileMaker Platform that meets the ever-changing needs of your business. 'The FileMaker Training Series: Advanced' covers a comprehensive set of topics to help you master the essentials of FileMaker 13 solution development," the article reads. "'FileMaker Training Series: Advanced' comes with a detailed, step-by-step manual and includes demo files, exercises and videos to help guide you through the materials."

There are several modules that make up the series that users will be able to master if they complete these projects. They include:

Introduction – This is the basics of the FileMaker platform and is the start of the journey. This is where organizations will be able to gain a fundamental knowledge to start using the database.

Data – FileMaker is a database, so understanding the basics of data relations, integrity and implementing multiple-table solutions are critical. This includes learning about certain types of data, auto-entry, validation, field storage and indexing. It also incorporates images.

Interface – This is the ability to work efficiently with several layouts, which is an essential skill for any developer. Whether accessing data from a mobile, desktop or the Web, the layout needs to be tailored to the specific environment in order for it to be successful.

Solution Logic: Calculations – This is a specific function that works in the calculation engine and can be applied in several contexts. These custom functions are built and use them in database solutions. There is also a set of specific functions for the mobile platform.

Solutions Logic: Scripting – Scripting allow users to create routines that can be triggered in a variety of ways. These make it easier to write and troubleshoot scripts for several platforms.

Reporting – Create reports in FileMaker with a number of techniques. Explore basic and advanced systems that can be used to learn cross-tab reports. This also touches on ExecuteSQL functions.

Security – This is a crucial component of every technology solution on the market. There are several built-in security features that need to be handled for companies to be successful.

Deployment – Work on deploying a FileMaker solution with the new FileMaker WebDirect technology and the improved FileMaker Go mobile application.

Integration – There are several different systems that can be integrated with FileMaker. These include SQL, ODBC connections and External SQL Data Source capabilities.

While this idea of self-learning can be help companies and individuals who have the time to learn it, it will not work for all businesses. This is where a FileMaker support service can come into play and help train an organization on all the best practices of FileMaker 13.

When most people think about gathering and sorting data, they think about using Excel. While it is a powerful spreadsheet tool that has its place in the corporate world, it may not be the best place to house your data if you are working with anything other than numbers.

When you consider that the world is becoming increasingly mobile, drastically improving the kind of information companies gather and the way they sort it, Excel becomes less effective. This is where a more powerful database is needed, and FileMaker has two decades of experience in this field and has embraced the mobile platform to go places never thought possible.

An article from CITEworld features an in-depth interview with Michael Jennings, a Chicago University Ph.D student and archeologist. Along with the fedora and whip, as part of his tool kit on a dig in Palestine of the 11th century Islamic castle at Khirbet al-Mafjar, near Jericho, Jennings is relying on FileMaker Go and an iPad.

While on-site, archeologists are constantly taking pictures, drawing sketches and writing notes. Traditionally this requires parties to carry large binders filled with paper records. The problem is that these can be lost or damaged. One archeologist who was working on the northern area of the site suddenly found all of his records missing, causing the team to redo all of this work.

Not only were teams required to carry these bulky binders around the site, but transport them back to the university departments in carry-on luggage when every page was scanned and information was entered manually into a computer system.

Jennings and field director Jehad Yasin realized they had an opportunity to improve operations here, especially considering that the database program used at the university was FileMaker. There is where the Go version of the software came into play and an iPad version of the existing database was quickly created.

Now, while examining the palace, the archeologists are able to snap pictures using the iPad's camera and sketch on the screen. They have also be able to create several drop-down menus so they can more easily enter accurate information. This is faster than writing everything down and makes it easier to analyze after the fact.

As they started to explore the possibilities of using the iPad, certain tweaks needed to be made to optimize operations. This included adding more controls, which is easy to do with FileMaker Pro on a computer. There are several layouts, controls and themes designed specifically to be compatible with the iOS platform, making it easy to update as needed.

With the Web-publishing capabilities, it was also easy for multiple team members to be work and update the same database at the same time.

"Depending on what you need, you can keep things simple or set up a more powerful way of distributing your database automatically," the article reads. "That's exactly what FileMaker offers: you can make a very simple system for viewing your database and updating it, or you can add in more features to get something more powerful without having to become a database expert."

While not every business needs to gather data while searching the catacombs of an ancient palace, this does highlight the real world possibilities of FileMaker. With the help of a Connecticut FileMaker developer, any organization can improve the way that it handles databases.