Flatfile’s developer-friendly data importer saves Halligan.io weeks of effort
Halligan.io Powered by Flatfile.io, the new standard for data import.
Halligan.io is a cloud-based inventory and maintenance management platform which helps first-responders, fire departments, and emergency operations keep track of critical equipment.
With Halligan, emergency response departments are able to import CSVs to update data-objects such as trucks, apparatuses, or equipment. Departments upload this data into Halligan to provide first-responders an overview of their emergency inventory.
The team understood that providing departments an intuitive data import experience would be critical to their emergency response customers, who have anything but time to spare. Halligan knew they needed a column-mapping feature in their data importer, along with the ability to translate CSV column header names into predetermined JSON data objects, as their data model frequently changed with new industry standards. Once they assessed these needs, Halligan realized that Flatfile was perfectly suited to address them.
Alex, CEO and Founder of Halligan.io says: “I knew how to build the mapping functionality. I just didn’t want to build it again. We needed to give our users the ability to upload a spreadsheet with any header name in any order while letting them map their imported columns into our specified data objects.”
After assessing their users’ needs, the Halligan team knew they had to create an intuitive data import experience for their customers. Given the complexity of the solution needed, the team did not want to allocate developer resources towards building and maintaining a custom data importer, so they turned to Flatfile.io.
Alex: “It’s a solution we’ve built before when out-of-box solutions hadn’t existed, but we didn’t want to dedicate developer time to build it again.”
After signing up for a developer account, the Halligan team was able to integrate Flatfile into their application within hours. Most of the time was spent ensuring that the CSV data imported correctly into their pre-built JSON objects as the team updated their database columns over time.
Alex: “Implementing Flatfile took a Saturday. Most of it was server-side work. I had to set up the JSON objects to pull data from the CSV.”
Alex: “We customized Flatfile by reusing one snippet for multiple importers — at least eight. Assuming we annotate the JSON properly, we can create a new react.js object with a new URL, place the Flatfile snippet in, and it just works.”
Halligan saved significant amounts of developer time and cost by integrating Flatfile. Not only would a custom data importer take weeks to build, but it would also require updates throughout the year by a developer. This is before any unforeseen bugs or feature requests.
Alex: “If we built the column-mapping ourselves, it would have taken about a month of developer time, then two weeks out of the year to do updates.”
The team is extremely satisfied with Flatfile’s intuitiveness, specifically when working with multiple CSV imports. Flatfile’s import algorithm not only matches up to 95% of columns automatically, but it also remembers column mapping so users don’t have to manually map data on subsequent imports.
Alex: “We’re happy with Flatfile. The uploader workflow is everything that you would expect in easily uploading a CSV file. Flatfile’s caching is well done by saving column-mapping assignments. We really like how users can manually adjust data on import, and configuring incoming CSV columns to JSON objects is simple.”
Success stories like Halligan’s are the reason why we built Flatfile.io. Saving our customers time and effort from building custom solutions is nice, but creating a great experience for a process that used to be frustrating is what keeps us going. The Flatfile team is ambitious in our pursuit of delightful data imports, and we look forward to working with Halligan and all of our customers to solve any problem related to getting data into web-based software applications.
Alex Montgomery, CEO and Founder of Halligan.io
To learn more about Halligan’s Inventory Management Platform for emergency departments, first-responders, and operations, visit halligan.io.
Flatfile is the new standard for data import. By improving the speed, accuracy, and user experience associated with file uploads, Flatfile has earned the trust of dozens of SaaS companies eager to improve their customers’ file import experience. The company, founded in 2018, is comprised of leaders with experience building innovative solutions at Hubspot, AirBnB, Envoy, MailChimp, FullStory, and others. To learn more about Flatfile, contact email@example.com or start a 30-day free trial at flatfile.io.
Topics: Case Study