Data Hooks™ are the most powerful new addition to Flatfile: they allow nearly infinite extensibility and customization of import flows. Today’s focus is on how you can use Data Hooks to normalize the data your customers are dropping into the Portal. Two common cases we see are names and dates.
Normalizing human names
A common data problem we see emerge when importing is when original sources have a full name and your system requires a first and last name (or the opposite). Using data hooks, you can easily employ awesome libraries like split-human-name to normalize values and save users hours of work.
ISO formatted dates
We've all seen the thousands of ways that users provide date values. Thankfully there's awesome libraries like moment.js or date-fns to help normalize human written dates into ISO formats. With data hooks you can not only normalize the values but also run complex analysis - like preventing dates in the future.
...and so many other use-cases.
A. Convert countries to their ISO codes. B. Normalize zip and postal codes. C. Convert monetary values into their currency syntax. D. Automatically format product codes. E. Convert values to database reference IDs. F. Tokenize PII for compliance with products like VGS. G. Append additional data automatically from an external file. H. Send us your ideas!
PS. Flatfile is built on your feedback. We appreciate you for helping us build a better experience every day. If you ever have ideas or suggestions, share them with us, or you can even schedule a call with Randy (our product lead) to discuss them.
Flatfile for your CS team?
Does your success or services team spend time on-boarding customer data?
We've got something special in the works, and would love to get your early feedback! Sign-up here to chat with our product team.