RAVACAN, a collaborative platform used by global sourcing teams, needed a CSV Importer solution. After a detailed evaluation process of OneSchema and Flatfile, RAVACAN moved forward with OneSchema due to its intuitive user experience and ease of setup and maintenance.
RAVACAN is a collaborative platform used by global sourcing teams to manage orders, inventory, prices, and lead times with suppliers. For sourcing teams, RAVACAN is a major upgrade from spreadsheets and legacy solutions. But, to get value from RAVACAN, customers first need to load Excel or CSV data into the platform. The data is often messy and poorly formatted, so the team had concerns that data import would drive huge onboarding delays.
With CSV import sitting at such a key moment for their customers, RAVACAN wanted to make sure they had the most seamless possible experience and looked to 3rd party vendors specializing in data import. Anne-Sophie Le Bloas, CEO of RAVACAN, had a few key criteria as they evaluated CSV import options:
Customer Experience: The CSV importer needed to have an extremely simple UI so that customers would not abandon onboarding or contact support. The solution needed to be extremely stable and bug-free to give customers a great first impression of RAVACAN.
Launch & maintenance time: As a fast-moving startup, RAVACAN wanted to launch CSV import in days, not months.
Evaluating CSV Import options
Armed with these requirements, Benjamin Beguin, Technical Co-founder at RAVACAN, kicked off a detailed evaluation process. He built out full proofs-of-concept with both OneSchema and Flatfile. “While Flatfile has a great enterprise offering, we preferred the intuitive user experience offered by OneSchema. After spending time implementing both products, it was also clear to our engineering team that OneSchema would be easier to productionize and maintain”.
When evaluating the customer experience differences between the tools, Benjamin considered carefully which features would make customer onboarding as simple as possible.
They had a couple of advanced CSV import scenarios they wanted to validate would work well. The first was upload times for very large files. “I really liked that OneSchema leverages an in-memory architecture,” said Benjamin. “I don’t have to worry about the product scaling to suit our needs, as it performed well as I stress tested it on much larger files that we’re planning to upload”.
The second was custom columns. “OneSchema’s custom columns feature is far more robust than Flatfile’s. While Flatfile allows customers to create new columns during an import, we couldn’t enforce any data validation on the newly created columns”.
There were a number of other advanced features that swayed Benjamin to prefer OneSchema, the most important being “export errors to Excel”. Benjamin continued, “when our customers are uploading thousands of rows of data, it’s impossible for them to correct errors one row at a time. OneSchema lets the customer export their file to Excel, annotated with error highlighting, making it easy for customers to correct data with issues”. A final differentiator for Benjamin was OneSchema’s robust multiple select dropdown feature, which supports custom delimiters. This feature wasn’t available in any other option he evaluated.
Launch & maintenance time
Like any fast-growing startup, RAVACAN wanted to launch this critical feature as fast as possible. To meet their launch date, they needed to find a solution that could be production ready in under one month (see: why building CSV import in-house can take years).
“I was blown away by how fast it was to set up the OneSchema POC”, said Benjamin. With OneSchema’s out-of-the-box validation library, I didn’t have to spend any time writing data validations. I got a working implementation set up in just a couple of hours”.
Since he had implemented Flatfile first, he was expecting to have to write custom validation logic for every column in their data model. “All of the customizations we needed were as easy as flipping a switch in OneSchema’s dashboard, instead of having to write extensive custom code.”
Maintaining the solution was also top of mind for RAVACAN. “I want our engineers to be focused on other priorities than maintaining CSV import,” said Benjamin. “With all the custom code I had to write in the Flatfile POC, it was just a lot more surface area for our team to maintain”.
After implementing a proof-of-concept for both OneSchema and Flatfile it was clear to the RAVACAN team that OneSchema was the right long-term partner.
“OneSchema really nailed the CSV import customer experience, and that’s ultimately what’s most important to us”.
Benjamin Beguin, Engineering Manager at Ravacan
"The product is incredibly easy for our customers to use. They’ve taken the huge headache of CSV import off of our hands. We’re so glad to be able to focus our engineering resources on the many, many other features on our long product roadmap".
Read more about why startups are choosing OneSchema over Flatfile here.
Engineering and product teams use OneSchema to easily build out best-in-class data import capabilities for their customers. Instead of spending months writing data validations and handing CSV parsing edge cases, focus your development resources on your core product development. With minimal engineering investment, improve your customer activation rates and launch better onboarding than your competitors.