Importing data in a FileMaker database from a “flat file”
Importing data can be easy when doing it table after table, with well structured data; but what about importing a “flat file”, where data destined to be put in different tables are mixed?
Let’s take a simple FileMaker database, where companies are linked to multiple contacts.
Here is a simple “company” record, linked to a contact in a portalIn order to have this kind of layouts, the relationship between the companies and the contacts i
Lesterius recently published the myFMApiLibrary for PHP. The myFMApiLibrary for PHP is a REST client library for PHP that allows you to easily interact with the FileMaker Data API and integrate it faster. But how do you use it?
In this article I will show you how I use it with Symfony 3.4, a popular Web Application framework based on a set of PHP Components.
Feel free to improve it.
This article assumes that you already have experience with Symfony.
Before using the DataApi fr
With the launch of the FileMaker 17 Platform, the new FileMaker User Licensing program was introduced. Each FileMaker User Licensing contract includes 3 licenses of FileMaker Server. An organisation can, for example, have a production server, backup server, and development server.
FileMaker is a unique product that gives us the possibility of developing in a live environment while users are actively using the FileMaker database. However this does have as implication that the programmer needs to
myFMbutler — myFMApiLibrary for PHP, one library to rule them all
Lesterius Team has developed a PHP library to make the FileMaker Data Api 17 easier to use.
Lesterius co-creates FileMaker Platform based solutions with their customers. Sharing knowledge takes part of our DNA, that’s why we developed this library to make the FileMaker Data API easy-to-use with PHP.
We already used it for our FileMaker 16 internal projects and we improved it enough with FileMaker 17 to share it with the world
March 2018 — The developers of Clip Manager, FM Calendar, PrinterSwitch, DoSQL, AutoSender, announce the immediate availability of myFMbutler Mobile App Builder.
Source: Artem Sapegin on UnsplashAbout Mobile App Builder
When FileMaker, Inc. introduced the FileMaker iOS App SDK, it wanted to simplify the way FileMaker custom apps are distributed in an organization. In the past, the FileMaker Go app along with all the FileMaker files and links were distributed separately. Thanks to the FileMaker
A new year brings new opportunities but also new security challenges. 2018 starts with a bang as two huge hardware bugs, dubbed Meltdown and Spectre, are discovered in the processors of several brands.
What is it about?
Meltdown is a security flaw that could allow hackers to bypass the hardware barrier between applications run by users and the computer’s core memory, which is normally highly protected.
Spectre is slightly different. It potentially allows hackers to trick otherwise error-free
The Nevelland group is made up of two studios and a modern print-shop It is equally committed to a social and an environmental policy. Thanks to the expertise of Lesterius, Nevelland has a simple visual interface for printing.
https://medium.com/media/7e7bf861096cf13d032ca06ecca835eb/hrefJohan Strumane, Nevelland
« The Nevelland Group consists of two sheltered workshops and a sheet-fed offset plant. Here, customers have their products packaged or repackaged, assembled and delivered. We have so
BTM is a commercial laundry servicing hotels, restaurants, industry and the health sector. It takes care of all types of textiles and in doing so helps their clients’ day-to-day stock management. Thanks to the expertise of Lesterius, BTM has peace of mind knowing that it has software which responds to its needs.
https://medium.com/media/0dbd9d5b483106fc23ff8e84fb1f04c5/hrefJean Eudes Renou, BTM
« BTM is an industrial laundry business. We do laundry for professionals in the hospitality sector,
Hogeschool van Amsterdam high school is the largest in the Netherlands. Thanks to the expertise of Lesterius and a simple iPad, its possible for the department of motor skills, sport and diet to measure the motor skills in children aged from 6 to 12 years old.
https://medium.com/media/cc22c7add66c1625265d2e974eb53b23/hrefHuub Toussaint, Hogeschool van Amsterdam
« Our university is the largest institute of higher education in the Netherlands. We are based in the Faculty of Sports and Nutrition.
Established in 1974, Film Fest Gent has become Belgium’s most prominent film festival. Each year 130,000 people come to a wide variety of films and concerts. Thanks to the expertise of Lesterius, Film Fest Gent can organise an international cinema event without compromise.
https://medium.com/media/95b1831b706707b3c90ff92f25c3e56f/hrefWim De Witte, Filmfest Gent
« Film Fest Gent is the most important general film festival in Belgium that doesn’t focus on a particular region or genre. We are the
The objective of FauveParis is to make auction sales accessible to newcomers. This Parisian start-up has 750m2 dedicated to a showroom, exhibition hall, lounge and wine bar. Thanks to the experience of Lesterius, FauveParis can manage its sales and its catalogue online.
https://medium.com/media/875ea62c52f35548fd5cfbeef89f46d5/hrefLucie-Éléonore Riveron, FauveParis
« Fauve Paris is an auction house in Paris, covering 750 square metres including our salesroom, exhibition room and a café and win
Bluestream is involved in numerous offshore operations throughout its 3 departments. It offers a wide range services to surface and submarine installations. Thanks to the expertise of Lesterius, Bluestream is improving its operational safety as well as that of its employees.
https://medium.com/media/6bb72ab74aab822440d1475f562462df/hrefRob de Brouwer, Bluestream
« Bluestream is a service organisation. We provide all kinds of offshore operations. And this is based on three business units. One o
Paris Trip organises minibus excursions,in partnership with tour operators and the principal tourist sites, to visit the capital from a fresh perspective. Thanks to the expertise of Lesterius, Paris Trip are sure to not miss a single reservation and to produce the right invoice at the right tax rate.
https://medium.com/media/11254a9189ce5242dd3ad9411c7104b6/hrefDidier Moreaux, Paris Trip
« PARIS TRIP is a minibus excursion company where we organise trips to Paris, Versailles, the Normandy and