Flatfile’s developer-friendly data importer saves Halligan.io weeks of effort

The challenge

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.

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.com.

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.

Flatfile’s data onboarding platform simple JSON configurator allows CSV fields to be mapped to specific data models seamlessly. Subsequent CSV data imports from users will adhere to this data model. The Halligan team was able to fully integrate Flatfile into their React.js application through an API connection. In addition, Halligan saved significant amounts of time by repurposing the Flatfile Javascript snippet. Due to Flatfile’s simple JSON configuration, the team was able to create eight separate Flatfile importers, all providing specific CSV import use-cases for each customer department. For example, one Flatfile snippet could be used for equipment imports, one for apparatus imports, and one for inventory imports. The only upkeep needed after re-using the snippet was ensuring that the CSV objects were mapped correctly to Halligan’s database through the JSON configuration.

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.

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.

Flatfile in action. The data importer can be integrated into any application using a JavaScript snippet. Take Flatfile for a spin at https://flatfile.com/developers

Success stories like Halligan’s are the reason why we built Flatfile.com. 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.

About Halligan

To learn more about Halligan’s Inventory Management Platform for emergency departments, first-responders, and operations, visit halligan.io.

About Flatfile

Flatfile's mission is to remove barriers between humans and data. With AI-assisted data onboarding, they eliminate repetitive work and make B2B data transactions fast, intuitive, and error-free. Flatfile automatically learns how imported data should be structured and cleaned, enabling customers and teams to spend more time using their data instead of fixing it. Flatfile has transformed over 300 million rows of data for companies like ClickUp, Blackbaud, Benevity, and Toast. To learn more about Flatfile’s data onboarding platform email hello@flatfile.io or get started for free at flatfile.com.