Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Changelog

The latest additions and updates to OneSchema.

Choose an Export Format for FileFeeds

New feature
New feature
New feature
Jun 2024

Users can now specify a desired export format for their FileFeed output via the settings pane. Currently, CSV and JSON are supported.

A blue arrow
Jun 2024

Advanced Excel Preparsing Hook

New feature
New feature
New feature
May 2024

We've launched a new preparsing hook that can be used for advanced Excel parsing. One example use case for this is the ability to ignore Excel's scientific notation formatting.

A blue arrow
May 2024

File Filter for FileFeeds

New feature
New feature
New feature
May 2024

Users can specify a regex for filtering which files are processed from their FileFeed source. This is applied at the FileFeed level and can be changed in FileFeed settings or upon instantiation of a new FileFeed. Files in the source directory that don't match the regex will be ignored.

A blue arrow
May 2024

Multi-Mappable Columns

New feature
New feature
New feature
Apr 2024

Customers can now specify a template column as multi-mappable, which allows your users to map multiple uploaded columns to the same template column. This enables better functionality for use cases such as aggregating multiple columns into a single column, and managing validation of multiple columns of the same type.

A blue arrow
Apr 2024

Custom Downloadable Excel Template

New feature
New feature
New feature
Apr 2024

We're excited to just expand the capabilities of theExcel template file that your users can download during the import process! This new feature enables you to upload a custom file in place of our default generated one. You can find the configuration for this in the Settings tab of each template. Please note that the customization must be enabled for the download button to appear in the importer.

A blue arrow
Apr 2024

Validation Hooks page: a new Columns column

New feature
New feature
New feature
Apr 2024

We've launched a new column to the table of Template Validation Hooks, listing the Template Columns attached to each hook. This is to help template owners manage and verify the hooks in use.

A blue arrow
Apr 2024

Support for 50M row files

Improvement
Improvement
Improvement
Apr 2024

We've increased the efficiency of our Rust data infrastructure, allowing support for uploading even larger files than before (up to 50M rows or 10 GB files). Note: performance will be affected if code hooks are used, depending on the complexity of the code hook.

A blue arrow
Apr 2024

Access Control

New feature
New feature
New feature
Mar 2024

Access Control is a feature that is now available for all Enterprise customers! With Access Control, three user roles are available:

  • Admin: This user can manage your team’s access to OneSchema in addition to the Developer role’s permissions.
  • Developer: This user will have access to the full OneSchema product experience. This includes templates, environments, API keys, webhooks, customizations, and analytics.
  • Analyst: This user is able to view imports in Import Activity
A blue arrow
Mar 2024

Locked Columns

New feature
New feature
New feature
Mar 2024

The new Locked Columns feature allows template owners to lock the value of specific columns, which is useful for fields where you don't want users to be able to edit certain data types. Once locked, the cells in these columns will be read-only, highlighted with a darker gray background, and have a popover indicating their lock status. If there are any errors/warnings for these cells, the error/warning message is displayed as before. Autofixing and accepting suggestions is enabled, however, manual edits are not.

A blue arrow
Mar 2024

New sheet_operation_performed event

New feature
New feature
New feature
Mar 2024

With our new sheet_operation_performed event, you'll now be able to receive event webhooks for all events that happen on Pane 4. This gives you greater insights into the end user behavior which helps both with finding ways to improve your product, as well as building in-depth auditing capabilities.

A blue arrow
Mar 2024

Add a row during upload

New feature
New feature
New feature
Mar 2024

We've launched a new customization that allows your users to add a row to uploaded files in importer! The added row will always appear at the end of the file.

A blue arrow
Mar 2024

Code Hooks API

Improvement
Improvement
Improvement
Feb 2024

We've launched additional endpoints for creating code hooks via the API to allow you to easily manage your code hooks locally.

A blue arrow
Feb 2024

Template Environments Update and Unpushed Changes

New feature
New feature
New feature
Feb 2024

We've launched a new experience on template pages around environments that will enable admins to better manage making and pushing changes to templates. Admins will now see UI on the All Templates page that indicates which environments a template was last pushed to, and UI that indicates the number of changes made to a template that have not been pushed.

A blue arrow
Feb 2024

Frequent Error Types

New feature
New feature
New feature
Feb 2024

Frequent Error Types has now been added to the Importer Analytics! This lets you see which columns your users are experiencing the most validation errors on the Review & Finalize pane.

A blue arrow
Feb 2024

Importer Analytics

New feature
New feature
New feature
Feb 2024

Importer Analytics unlocks powerful information about how your customers are interacting with your importer. From here, you can see data like conversion percentages, time spent per pane, and frequent errors your customers are encountering.

A blue arrow
Feb 2024

Event Webhooks

New feature
New feature
New feature
Feb 2024

For complex use cases where diving even further into analytics is necessary, Event Webhooks allows you to see data around the following events:

  • Embed Initialized
  • Embed Resumed
  • Embed Closed
  • File Uploaded
  • Header Selected
  • Columns Mapped
  • Import Submitted
A blue arrow
Feb 2024

Import activity search filter

New feature
New feature
New feature
Feb 2024

The new search filter on Import Activity provides a more seamless experience by enabling you to filter import activity across template_key, original file name, and user_id.

A blue arrow
Feb 2024

New Warnings Experience

New feature
New feature
New feature
Feb 2024

We've made updates to our pane 4 experience to create a better experience when the uploaded file has warnings. With this new experience, when your user clicks the "Rows with issues" tab, they'll see a dropdown which allows them to filter on only errors OR only warnings. They'll also be able to filter on warnings for a specific column with the new warning pills, and the error sidebar now separates warnings from errors.

A blue arrow
Feb 2024

Additional error resolution actions

New feature
New feature
New feature
Feb 2024

Our newly launched column level error resolution actions in pane 4 allow your users will to access the predefined actions via error popover and via column header dropdowns. This gives them more flexibility and options when it comes to bulk fixing their data, enabling an even easier data cleaning experience!

A blue arrow
Feb 2024

Webhook logs popover update

Improvement
Improvement
Improvement
Feb 2024

The log details popover for Validation Webhooks now contains "rows sent" and "errors returned". This will aid you in more easily debugging validation webhook issues.

A blue arrow
Feb 2024

All templates page redesign

Improvement
Improvement
Improvement
Jan 2024

We've just launched a redesign to the all templates page that allows users to search and sort their templates by various criteria (eg. template key, label, created time) and filter templates by whether they were created from the API. Our goal is to continue making it easier and much faster for you to find a template they are looking for, especially for organizations with a large amount of dynamic templates.

A blue arrow
Jan 2024

Import max row limit

New feature
New feature
New feature
Dec 2023

We've added a customization that allows customers to add a maximum row limit that can be imported, and they can also add an optional custom header and description message for this error. When this customization is active and there are more rows than the specified limit, we will display an error in the importer and block the user from continuing with the import.

A blue arrow
Dec 2023

Education widget

New feature
New feature
New feature
Nov 2023

We've added a customization option that allows you to add education widgets to your importer! This enables you specify different widgets for each of the 4 Importer panes, have it default open or closed, and supports markdown.

A blue arrow
Nov 2023

Environment scopes for API keys

Security and Compliance
Security and Compliance
Security and Compliance
Nov 2023

We're excited to roll out environment scopes for API keys, which enables those keys to only access embeds in the prescribed environment. This helps customers uplevel the security of their organization by ensuring that their developers' local and staging environments should not have access to customer PII.

A blue arrow
Nov 2023

Accept all suggestions

New feature
New feature
New feature
Nov 2023

The cell popover for errors and warnings with suggestions now has a new button, "Accept for X cells". Clicking this button will accept all suggestions for cells in the column that have exactly 1 suggestion, making it even easier for your users to clean their files. The button will appear for users if there are at least 2 cells in the column which have exactly 1 suggestion.

A blue arrow
Nov 2023

Picklist Descriptions

New feature
New feature
New feature
Nov 2023

With Picklist Descriptions, you can now use template overrides to set descriptions for each individual picklist option. These will be displayed in each dropdown of the OneSchema importer:

- Picklist mapping

- Picklist cell editing

- Picklist error popovers to replace all

A blue arrow
Nov 2023

Picklist Truncation and Dropdown Width Adjustments

Improvement
Improvement
Improvement
Nov 2023

These 3 improvements to picklists help customers whose use cases require long picklist values to be inputted:

  1. Picklist pills will now truncate properly with a tooltip on hover to show the full value
  2. The base width of the dropdown has just naturally been increased 20% across the board
  3. The width of the dropdown will now actually increase if the column width increases
A blue arrow
Nov 2023

Template Columns Education

New feature
New feature
New feature
Nov 2023

This new customization option under the "User Education" tab enables an informational sidebar on the mapping pane for your users. This will display a green check next to columns that have been mapped, and update dynamically as users select their mappings.

A blue arrow
Nov 2023

Sample data file generator

New feature
New feature
New feature
Nov 2023

Users now have the ability to generate a sample test file for a template, eliminating the need for a file on hand to experience the importer. The button to generate a sample file lives can be found in the sandbox preview below the importer. The generated data will mostly conform with the template column options, but the data may not be 100% valid according to the template.

A blue arrow
Nov 2023

Accounting format for Number Autofixer

Improvement
Improvement
Improvement
Nov 2023

We've launched an update to our number autofixer, which can now handle negative numbers in account format. You can utilize this to automatically correct entries formatted as (100), and automatically change them to -100.

A blue arrow
Nov 2023

Alternative Picklist Names

New feature
New feature
New feature
Nov 2023

Our new Alternative Picklist Names feature enables you to specify one or more "alternative_names" for each picklist value via template overrides. If any of the alternative names appear in the uploaded file, they will automatically be mapped to the picklist value.

A blue arrow
Nov 2023

EU Number Format

New feature
New feature
New feature
Oct 2023

The number data type now has a new selection for the format, either be "US" (the default), or "EU". The EU number data type uses "," as the decimal separator and "." as the thousand separator.

A blue arrow
Oct 2023

External API keys update

Improvement
Improvement
Improvement
Oct 2023

The external API keys page has been updated so every user can see all external API keys in their organization. With these changes, a user can create multiple keys, set a label, and see when an API key was last used. In addition, deleting a user also now does not delete any API key(s) created by that user.

A blue arrow
Oct 2023

Fullview integration

New feature
New feature
New feature
Oct 2023

OneSchema now supports Fullview as a screen recording provider, allowing customers to analyzing recordings of their customers using OneSchema and optimize the experience.

A blue arrow
Oct 2023

Required Column Groups

New feature
New feature
New feature
Sep 2023

Customers can now use the "Required Column Groups" feature to set that at least one column in a group must be mapped.

A blue arrow
Sep 2023

New Boolean data type

New feature
New feature
New feature
Sep 2023

Our new Boolean data type feature allows users to define true and false values more easily.

A blue arrow
Sep 2023

Customizable Picklist Colors

New feature
New feature
New feature
Sep 2023

You can now set specific colors for each picklist option! A list of 10 default options are provided, but exact HEX values can be used as desired.

A blue arrow
Sep 2023

Environment variables in webhook keys

Improvement
Improvement
Improvement
Sep 2023

Customers can now set environment variables in webhook keys. This helps customers who want to keep their secret keys isolated across different environments.

A blue arrow
Sep 2023

OneSchema Pipelines

New feature
New feature
New feature
Sep 2023

OneSchema Pipelines lets non-technical team members (account managers, operations) setup recurring CSV integrations with your customers’ complex data feeds without engineers getting involved. Map, transform, and ingest CSV files via SFTP, API, or email without needing to write a single line of code.

A blue arrow
Sep 2023

Import template as JSON

New feature
New feature
New feature
Sep 2023

Customers can now select which environments to push when creating dynamic templates.

A blue arrow
Sep 2023

Define validation hooks in template overrides

Improvement
Improvement
Improvement
Aug 2023

Customizations and Templates determine the behavior of OneSchema Importers. Using overrides can allow specific behavior for individual importing sessions. Customers now have the ability to define validation hooks in template overrides.

A blue arrow
Aug 2023

Historical Matching improvements

Improvement
Improvement
Improvement
Aug 2023

We've launched a feature to split Historical Matching into User-specific and Org-level matching. Previously, this only worked on the org-level. This helps customers whose users are differentiated enough that they do not want to have cross-user mappings be saved.

A blue arrow
Aug 2023

Environment Variables in Importer Webhooks

Improvement
Improvement
Improvement
Aug 2023

Customers can now use environment variables in Importer Webhooks

A blue arrow
Aug 2023

Environments General Availability

New feature
New feature
New feature
Jul 2023

Environments allow you to safely push and validate changes to templates in stages to align with the environments in your deploy process.

OneSchema automatically sets up environments for Production, Staging, and Development. See our guide on custom environments to set up custom environments.

A blue arrow
Jul 2023

Per-Customer Overrides

Improvement
Improvement
Improvement
Jul 2023

We’ve made improvements to our Template Overrides functionality by adding the ability to add and remove columns from the overrides.

A blue arrow
Jul 2023

Code Hooks improvements

Improvement
Improvement
Improvement
Jul 2023

We’ve made improvements to our custom code transformations and validations, also known as OneSchema Code Hooks. These Code Hook upgrades aim to greatly enhance both how your team builds custom functions that support your company’s unique business logic, as well as how your end-users experience the OneSchema Importer.

A blue arrow
Jul 2023

Transpose file

New feature
New feature
New feature
Jun 2023

A new post-upload hook now exists for transposing (swapping the rows and columns) of a file.

A blue arrow
Jun 2023

Multi-cell copy and paste

New feature
New feature
New feature
May 2023

To better support end users with bulk error resolution, we’ve improved our copy and paste functionality on the Review & Finalize pane to enable multiple cell copying and pasting.

A blue arrow
May 2023

Review & Finalize pane UI improvements

Improvement
Improvement
Improvement
May 2023

We’ve added UI for end users to immediately filter for all rows, only rows with errors, or only clean rows.

A blue arrow
May 2023

String Replacements customization

New feature
New feature
New feature
May 2023

String Replacements allow you to change the headers and buttons of every step of the importer. This can be helpful if there’s an existing string inside of the importer flow that you feel could be edited to better fit your existing brand (or use case).

A blue arrow
May 2023

Row deletion customization

New feature
New feature
New feature
May 2023

For some customers, an end user deleting a row of data prior to import can break their entire flow. We’ve added a customization option that allows you granular control over how and if the end user should be able to delete rows from the Review & Finalize pane.

A blue arrow
May 2023

Specify expected date formats for template columns

New feature
New feature
New feature
May 2023

Admins can now specify the particular date format that’s expected for template columns instead of relying on OneSchema’s date detection (which defaults to a month, day, year interpretation). This impacts scenarios where a file’s uploaded date column contains a majority of ambiguous dates, and the format is not MM/DD/YY (e.g. 01/02/2022 can be either January 2nd, 2022 or February 1st, 2022).

A blue arrow
May 2023

Custom column support in validation webhooks

Improvement
Improvement
Improvement
May 2023

Custom columns can now be supported inside of validation webhooks. Review our updated docs to understand the different use cases, how to set up custom columns, and example JSON POST/responses.

A blue arrow
May 2023

Pre-built Transforms and Advanced Validations

New feature
New feature
New feature
Apr 2023
Apr 2023

Markdown support in customizations

Improvement
Improvement
Improvement
Apr 2023

To provide further customization of our Upload pane, the optional message box can now be customized using Markdown. Our customers can insert URLs to additional data import resources for the end user.

A blue arrow
Apr 2023

JSON object data type validator

New feature
New feature
New feature
Apr 2023

JSON object is newly available as a data type validation for template columns.

A blue arrow
Apr 2023

Multi-suggestion support for validation web hooks

Improvement
Improvement
Improvement
Apr 2023

Customers can now choose to return a list of suggestions from a validation webhook. End users will be prompted to select one of the suggestions as a part of the error resolution process.

A blue arrow
Apr 2023

Improved date validators

Improvement
Improvement
Improvement
Apr 2023
Apr 2023

Currency symbol validation support

New feature
New feature
New feature
Apr 2023

OneSchema’s money data type validation and autofix feature now supports the Pound (£), the Euro (€), and the Yen (¥) currency symbols.

A blue arrow
Apr 2023

Better error messages for numbers and currency

Improvement
Improvement
Improvement
Apr 2023

The error messaging for the Number data type and Money data type has been improved so end users can better understand why the value is invalid and how to fix it.

A blue arrow
Apr 2023

Import metadata via webhook

New feature
New feature
New feature
Apr 2023

Rather than sending batched rows of data to a customer webhook, sheet metadata can now be sent via webhook. This is significantly faster and also enables you to directly use the metadata to retrieve data via external API (e.g. GET rows for paginated JSON or POST sheets for S3 URL download of CSV/excel/JSON).

A blue arrow
Apr 2023

Headless validation

New feature
New feature
New feature
Mar 2023

Since we’ve started building OneSchema, one of the deepest pain points we’ve seen in our customer base is building and maintaining recurring spreadsheet import workflows. Expensive engineering teams have to write brittle scripts to ingest the data, and spend countless engineering months maintaining validations to make sure all customer data is being imported correctly.

In the case of a failure, it’s extremely painful for the technical team to track down the root cause of the failure, and all the while the customer is frustrated because their data isn’t up-to-date in your product. OneSchema Headless empowers engineering teams to leverage OneSchema’s mapping, validation, and error resolution capabilities to painlessly build custom integrations with a wide variety of data sources, like SFTP/S3 file drops, CSV email attachments, messy API data, and more.

A blue arrow
Mar 2023

Webhook logs

New feature
New feature
New feature
Mar 2023

Users can now see logs of their importer and validation webhooks (up to the past 14 days). This should enable users to better debug their webhooks when they run into errors, and enable your teams to monitor webhook activity.

A blue arrow
Mar 2023

Direct to S3 file transfer

New feature
New feature
New feature
Mar 2023

Customers can now instruct OneSchema to send processed files directly to their own presigned URL.

A blue arrow
Mar 2023

CA data residency

Security and Compliance
Security and Compliance
Security and Compliance
Mar 2023

Customers now have the option of having OneSchema instances hosted in Canada.

A blue arrow
Mar 2023

AU data residency

Security and Compliance
Security and Compliance
Security and Compliance
Mar 2023

Customers now have the option of having OneSchema instances hosted in Australia.

A blue arrow
Mar 2023

In-memory code hooks

New feature
New feature
New feature
Feb 2023

Because our customers span a variety of industries, we often see workflows that come with unique business logic built into their specific datasets.

To make OneSchema even more flexible for these custom use cases, we’ve created OneSchema Code Hooks. Code Hooks empower your engineering team to generate tailored functions to reformat, transform, and/or validate data specific to your business's needs inside of the importer flow.

A blue arrow
Feb 2023

Events/errors webhooks

New feature
New feature
New feature
Feb 2023
Feb 2023

Custom columns renaming

New feature
New feature
New feature
Feb 2023
Feb 2023

Auto include unmapped columns

New feature
New feature
New feature
Feb 2023
Feb 2023

Historical picklist mapping

New feature
New feature
New feature
Jan 2023

Similar to historical column mapping, historical picklist option mapping remembers mappings and pre-fills the values for subsequent uploads. This behavior is active if the “Historical match” customization in the “Map columns” section is set.

A blue arrow
Jan 2023

Resume sessions

New feature
New feature
New feature
Jan 2023

Sessions can now be resumed in case a user's browser crashes or they do not finish an import. To enable this feature, update your SDK to the latest version(0.3.3) and pass in the param saveSession as true. Then sessions using the same userJwt and template key on the same browser will be prompted on resume as seen in the screenshot below.

A blue arrow
Jan 2023

Skip pane 4

New feature
New feature
New feature
Jan 2023
Jan 2023

Template overrides

Improvement
Improvement
Improvement
Jan 2023
Jan 2023

Additional languages for i18n

Improvement
Improvement
Improvement
Jan 2023
Jan 2023

SDK upgraded to 0.3

Improvement
Improvement
Improvement
Jan 2023
Jan 2023

New template configurations

Improvement
Improvement
Improvement
Jan 2023

OneSchema templates just got even more powerful.

  • With the alternative mappings feature, you can tell OneSchema which mappings you’re expecting to see so that your user won’t have to map them manually.
  • Use fill default values to automatically fill in empty cells instead of leaving them blank
  • Check out the flexible options on our data type validations that let you validate everything from digits after the decimal to excluding special characters.

We've also redesigned the template column creation modal to better organize all the different data validations options and to make template creation easier for you.

A blue arrow
Jan 2023

Self hosting (Enterprise Feature)

Security and Compliance
Security and Compliance
Security and Compliance
Dec 2022

You can now host OneSchema inside of your AWS or Azure cloud environment. The self-hosted model provides full isolation of data in your own cloud, and is best for customers who are handling government data (GovCloud), or other extremely sensitive data with unique contractual / compliance requirements. OneSchema will deploy updates and maintenance to the platform through an IAM user.

A blue arrow
Dec 2022

Customizations Dashboard

New feature
New feature
New feature
Dec 2022

A dashboard with granular UI customizations is now available for you to make the OneSchema Importer look and feel like your existing product UI! We’ve also updated our default icon set and illustrations to be more brand-neutral, to help OneSchema’s Importer fit better in any product, even without customizations.

A dashboard with granular UI customizations is now available for you to make the OneSchema Importer look and feel like your existing product UI! We’ve also updated our default icon set and illustrations to be more brand-neutral, to help OneSchema’s Importer fit better in any product, even without customizations.

With our Branding Suite, you can now access 20+ customization options, including:

  • Primary, secondary, and background colors
  • Buttons
  • Success, Warning, and Error states
  • Custom illustrations
  • Font family and font colors

Watch this 3 minute step-by-step demo of the OneSchema Branding Suite that demonstrates how to fully customize your importer's color, font, and more.

A blue arrow
Dec 2022

Downloadable Excel templates

New feature
New feature
New feature
Dec 2022
Dec 2022

Accept clean rows only

New feature
New feature
New feature
Dec 2022

A new modal has been added to the end of the Review & Finalize pane that allows you to accept only rows without errors. For use cases where you’d like to get as much data in as possible but ingesting all of the user’s data isn’t critical, this is a great option to increase your import conversion rates.

The new modal addition:

  1. Allows your user to submit clean rows without having to fix every single error in their data
  2. Gives end users the opportunity to export the remaining errors so they may fix their data in Excel and re-upload it into your system.

Note: This modal will only appear if there are remaining error rows in your end user’s upload when they attempt to import.

OneSchema will still send the final JSON export with clean rows as “records” and error rows as “error_records.” This way, even if your user never returned to clean the rows with the remaining errors, you still have a record of the data not imported.

A blue arrow
Dec 2022

Export to S3

New feature
New feature
New feature
Dec 2022

OneSchema webhooks let you send data to your ingestion endpoint but can be slow for very large files.

Now, OneSchema can put your exported file into an S3 bucket, where you can retrieve it as JSON or CSV. This makes exporting large files far more performant.

To enable this new feature, a new OneSchemaConfig has been added: skipExportData. This changes the behavior of the success event (onSuccess callback in React) when not including a webhookKey. Instead of sending all of the data from the list, we will only send the sheet_id. You can then use API v1 to download a file or use our Paginated JSON Get end point.

We recommend this config option for customers who anticipate their end users will upload large files but don’t want them to wait for the file to finish processing before proceeding back to their workflow.

You can learn more about the config in our docs.

A blue arrow
Dec 2022

Fullscreen mode

New feature
New feature
New feature
Dec 2022
Dec 2022

Select header rows

New feature
New feature
New feature
Nov 2022
Nov 2022

Column splits/merge

New feature
New feature
New feature
Nov 2022
Nov 2022

Row splits/merge

New feature
New feature
New feature
Nov 2022
Nov 2022

Add/delete columns via API

New feature
New feature
New feature
Nov 2022
Nov 2022

Nested data support validation

New feature
New feature
New feature
Nov 2022
Nov 2022

API-as-a-service

New feature
New feature
New feature
Nov 2022
Nov 2022

Customizations v2

Improvement
Improvement
Improvement
Nov 2022
Nov 2022

Import via API

New feature
New feature
New feature
Oct 2022

We understand every company's file ingestion process is unique. That’s why a focus for OneSchema has always been enabling companies to optimize OneSchema’s import workflow for their specific use case. To further expand on the customizability of OneSchema, we’re introducing Import via API.

For workflows that ideally involve a blend of managing some portions of the import process internally while still using OneSchema to handle the rest, initializing the importer via our API provides a great solution.

A blue arrow
Oct 2022

Accept partial imports

New feature
New feature
New feature
Oct 2022

A new modal has been added to the end of the Review & Finalize pane that allows you to accept only rows without errors. For use cases where you’d like to get as much data in as possible but ingesting all of the user’s data isn’t critical, this is a great option to increase your import conversion rates.

The new modal addition:

  1. Allows your user to submit clean rows without having to fix every single error in their data
  2. Gives end users the opportunity to export the remaining errors so they may fix their data in Excel and re-upload it into your system.

Note: This modal will only appear if there are remaining error rows in your end user’s upload when they attempt to import.

OneSchema will still send the final JSON export with clean rows as “records” and error rows as “error_records.” This way, even if your user never returned to clean the rows with the remaining errors, you still have a record of the data not imported.

A blue arrow
Oct 2022

New template configs

Improvement
Improvement
Improvement
Oct 2022
Oct 2022

S3 export integration

New feature
New feature
New feature
Oct 2022
Oct 2022

Skip mapping pane

New feature
New feature
New feature
Oct 2022

The importer will now skip the mapping step if all template columns are matched (exact match) in the list (and header row selection was also skipped).

A blue arrow
Oct 2022

Required vs. optional columns

New feature
New feature
New feature
Oct 2022
Oct 2022

Data Template summary

New feature
New feature
New feature
Oct 2022

You can now customize the first pane of your CSV import experience to include a summary of the data you’d like your customer to import. You can include your required and optional fields and descriptions of the data the customer should upload.

We added the following optional customizations to empower you to create the ideal experience for your end users on the first pane:

  • The header and subheader copy within the Uploader component can now be fully customized
  • Show the required columns and their descriptions in a new InfoSideBar component
  • Show the required and optional columns along with their descriptions in a new InfoSideBar component

You can learn more about how to enable these customizations in our docs.

A blue arrow
Oct 2022

Localization (21 languages)

New feature
New feature
New feature
Sep 2022

OneSchema now supports the ability to fully translate the UI into the language of your choosing. Internationalization is currently an enterprise-tier feature. Please reach out to us to discuss your team's i18n needs and desired language support. Supported languages include: English, Spanish, Portuguese, French, German, Swedish, Chinese (Simplified), Czech, Danish, Dutch, Finnish, Hungarian, Italian, Japanese, Korean, Norwegian, Polish, Portuguese, Romanian, Russian, Arabic,

Learn more about the configuration option in our docs.

A blue arrow
Sep 2022

Guided error-fixing

Improvement
Improvement
Improvement
Sep 2022

We’re very excited to announce our most requested feature: guided error fixing. In our beta tests, offering helpful suggestions for resolving errors has driven substantial uplift in import conversion rates. These upgrades include:

  • Error Fix Suggestions: OneSchema will offer suggestions to your customer to fix errors, contextualized to the type of error your customer is encountering.
  • Navigate to column with errors: When clicked in the issues summary, OneSchema will now pull the column with issues directly into view.

Bulk deleting rows:

  • Delete all rows with errors: OneSchema now contextually surfaces the option to delete all rows with errors, allowing customers to progress in their import workflow. Alternatively they can “Export to Excel” to get a summary of their errors.
  • Delete selected rows: “Delete selected row(s)” button when selecting rows will be shown to users

We are also launching usability improvements based on customer feedback:

  • Issues Sidebar: Issues summary sidebar will no longer obstruct the last few columns in the sheet. Instead, it will appear inside of the spreadsheet view.
  • Filter to find errors: We’ve added a “show error” button in the issues summary that when clicked, brings the error front-and-center. It’s never been easier to find errors in your file.
A blue arrow
Sep 2022

Upload pane customizations (v1)

New feature
New feature
New feature
Sep 2022
Sep 2022

Choose an Export Format for FileFeeds

New feature
New feature
New feature
June 2024

Users can now specify a desired export format for their FileFeed output via the settings pane. Currently, CSV and JSON are supported.

A blue arrow
Jun 2024

Advanced Excel Preparsing Hook

New feature
New feature
New feature
May 2024

We've launched a new preparsing hook that can be used for advanced Excel parsing. One example use case for this is the ability to ignore Excel's scientific notation formatting.

A blue arrow
May 2024

File Filter for FileFeeds

New feature
New feature
New feature
May 2024

Users can specify a regex for filtering which files are processed from their FileFeed source. This is applied at the FileFeed level and can be changed in FileFeed settings or upon instantiation of a new FileFeed. Files in the source directory that don't match the regex will be ignored.

A blue arrow
May 2024

Multi-Mappable Columns

New feature
New feature
New feature
April 2024

Customers can now specify a template column as multi-mappable, which allows your users to map multiple uploaded columns to the same template column. This enables better functionality for use cases such as aggregating multiple columns into a single column, and managing validation of multiple columns of the same type.

A blue arrow
Apr 2024

Custom Downloadable Excel Template

New feature
New feature
New feature
April 2024

We're excited to just expand the capabilities of theExcel template file that your users can download during the import process! This new feature enables you to upload a custom file in place of our default generated one. You can find the configuration for this in the Settings tab of each template. Please note that the customization must be enabled for the download button to appear in the importer.

A blue arrow
Apr 2024

Validation Hooks page: a new Columns column

New feature
New feature
New feature
April 2024

We've launched a new column to the table of Template Validation Hooks, listing the Template Columns attached to each hook. This is to help template owners manage and verify the hooks in use.

A blue arrow
Apr 2024

Access Control

New feature
New feature
New feature
March 2024

Access Control is a feature that is now available for all Enterprise customers! With Access Control, three user roles are available:

  • Admin: This user can manage your team’s access to OneSchema in addition to the Developer role’s permissions.
  • Developer: This user will have access to the full OneSchema product experience. This includes templates, environments, API keys, webhooks, customizations, and analytics.
  • Analyst: This user is able to view imports in Import Activity
A blue arrow
Mar 2024

Locked Columns

New feature
New feature
New feature
March 2024

The new Locked Columns feature allows template owners to lock the value of specific columns, which is useful for fields where you don't want users to be able to edit certain data types. Once locked, the cells in these columns will be read-only, highlighted with a darker gray background, and have a popover indicating their lock status. If there are any errors/warnings for these cells, the error/warning message is displayed as before. Autofixing and accepting suggestions is enabled, however, manual edits are not.

A blue arrow
Mar 2024

New sheet_operation_performed event

New feature
New feature
New feature
March 2024

With our new sheet_operation_performed event, you'll now be able to receive event webhooks for all events that happen on Pane 4. This gives you greater insights into the end user behavior which helps both with finding ways to improve your product, as well as building in-depth auditing capabilities.

A blue arrow
Mar 2024

Add a row during upload

New feature
New feature
New feature
March 2024

We've launched a new customization that allows your users to add a row to uploaded files in importer! The added row will always appear at the end of the file.

A blue arrow
Mar 2024

Template Environments Update and Unpushed Changes

New feature
New feature
New feature
February 2024

We've launched a new experience on template pages around environments that will enable admins to better manage making and pushing changes to templates. Admins will now see UI on the All Templates page that indicates which environments a template was last pushed to, and UI that indicates the number of changes made to a template that have not been pushed.

A blue arrow
Feb 2024

Frequent Error Types

New feature
New feature
New feature
February 2024

Frequent Error Types has now been added to the Importer Analytics! This lets you see which columns your users are experiencing the most validation errors on the Review & Finalize pane.

A blue arrow
Feb 2024

Importer Analytics

New feature
New feature
New feature
February 2024

Importer Analytics unlocks powerful information about how your customers are interacting with your importer. From here, you can see data like conversion percentages, time spent per pane, and frequent errors your customers are encountering.

A blue arrow
Feb 2024

Event Webhooks

New feature
New feature
New feature
February 2024

For complex use cases where diving even further into analytics is necessary, Event Webhooks allows you to see data around the following events:

  • Embed Initialized
  • Embed Resumed
  • Embed Closed
  • File Uploaded
  • Header Selected
  • Columns Mapped
  • Import Submitted
A blue arrow
Feb 2024

Import activity search filter

New feature
New feature
New feature
February 2024

The new search filter on Import Activity provides a more seamless experience by enabling you to filter import activity across template_key, original file name, and user_id.

A blue arrow
Feb 2024

New Warnings Experience

New feature
New feature
New feature
February 2024

We've made updates to our pane 4 experience to create a better experience when the uploaded file has warnings. With this new experience, when your user clicks the "Rows with issues" tab, they'll see a dropdown which allows them to filter on only errors OR only warnings. They'll also be able to filter on warnings for a specific column with the new warning pills, and the error sidebar now separates warnings from errors.

A blue arrow
Feb 2024

Additional error resolution actions

New feature
New feature
New feature
February 2024

Our newly launched column level error resolution actions in pane 4 allow your users will to access the predefined actions via error popover and via column header dropdowns. This gives them more flexibility and options when it comes to bulk fixing their data, enabling an even easier data cleaning experience!

A blue arrow
Feb 2024

Import max row limit

New feature
New feature
New feature
December 2023

We've added a customization that allows customers to add a maximum row limit that can be imported, and they can also add an optional custom header and description message for this error. When this customization is active and there are more rows than the specified limit, we will display an error in the importer and block the user from continuing with the import.

A blue arrow
Dec 2023

Education widget

New feature
New feature
New feature
November 2023

We've added a customization option that allows you to add education widgets to your importer! This enables you specify different widgets for each of the 4 Importer panes, have it default open or closed, and supports markdown.

A blue arrow
Nov 2023

Accept all suggestions

New feature
New feature
New feature
November 2023

The cell popover for errors and warnings with suggestions now has a new button, "Accept for X cells". Clicking this button will accept all suggestions for cells in the column that have exactly 1 suggestion, making it even easier for your users to clean their files. The button will appear for users if there are at least 2 cells in the column which have exactly 1 suggestion.

A blue arrow
Nov 2023

Picklist Descriptions

New feature
New feature
New feature
November 2023

With Picklist Descriptions, you can now use template overrides to set descriptions for each individual picklist option. These will be displayed in each dropdown of the OneSchema importer:

- Picklist mapping

- Picklist cell editing

- Picklist error popovers to replace all

A blue arrow
Nov 2023

Template Columns Education

New feature
New feature
New feature
November 2023

This new customization option under the "User Education" tab enables an informational sidebar on the mapping pane for your users. This will display a green check next to columns that have been mapped, and update dynamically as users select their mappings.

A blue arrow
Nov 2023

Sample data file generator

New feature
New feature
New feature
November 2023

Users now have the ability to generate a sample test file for a template, eliminating the need for a file on hand to experience the importer. The button to generate a sample file lives can be found in the sandbox preview below the importer. The generated data will mostly conform with the template column options, but the data may not be 100% valid according to the template.

A blue arrow
Nov 2023

Alternative Picklist Names

New feature
New feature
New feature
November 2023

Our new Alternative Picklist Names feature enables you to specify one or more "alternative_names" for each picklist value via template overrides. If any of the alternative names appear in the uploaded file, they will automatically be mapped to the picklist value.

A blue arrow
Nov 2023

EU Number Format

New feature
New feature
New feature
October 2023

The number data type now has a new selection for the format, either be "US" (the default), or "EU". The EU number data type uses "," as the decimal separator and "." as the thousand separator.

A blue arrow
Oct 2023

Fullview integration

New feature
New feature
New feature
October 2023

OneSchema now supports Fullview as a screen recording provider, allowing customers to analyzing recordings of their customers using OneSchema and optimize the experience.

A blue arrow
Oct 2023

Required Column Groups

New feature
New feature
New feature
September 2023

Customers can now use the "Required Column Groups" feature to set that at least one column in a group must be mapped.

A blue arrow
Sep 2023

New Boolean data type

New feature
New feature
New feature
September 2023

Our new Boolean data type feature allows users to define true and false values more easily.

A blue arrow
Sep 2023

Customizable Picklist Colors

New feature
New feature
New feature
September 2023

You can now set specific colors for each picklist option! A list of 10 default options are provided, but exact HEX values can be used as desired.

A blue arrow
Sep 2023

OneSchema Pipelines

New feature
New feature
New feature
September 2023

OneSchema Pipelines lets non-technical team members (account managers, operations) setup recurring CSV integrations with your customers’ complex data feeds without engineers getting involved. Map, transform, and ingest CSV files via SFTP, API, or email without needing to write a single line of code.

A blue arrow
Sep 2023

Import template as JSON

New feature
New feature
New feature
September 2023

Customers can now select which environments to push when creating dynamic templates.

A blue arrow
Sep 2023

Environments General Availability

New feature
New feature
New feature
July 2023

Environments allow you to safely push and validate changes to templates in stages to align with the environments in your deploy process.

OneSchema automatically sets up environments for Production, Staging, and Development. See our guide on custom environments to set up custom environments.

A blue arrow
Jul 2023

Transpose file

New feature
New feature
New feature
June 2023

A new post-upload hook now exists for transposing (swapping the rows and columns) of a file.

A blue arrow
Jun 2023

Multi-cell copy and paste

New feature
New feature
New feature
May 2023

To better support end users with bulk error resolution, we’ve improved our copy and paste functionality on the Review & Finalize pane to enable multiple cell copying and pasting.

A blue arrow
May 2023

String Replacements customization

New feature
New feature
New feature
May 2023

String Replacements allow you to change the headers and buttons of every step of the importer. This can be helpful if there’s an existing string inside of the importer flow that you feel could be edited to better fit your existing brand (or use case).

A blue arrow
May 2023

Row deletion customization

New feature
New feature
New feature
May 2023

For some customers, an end user deleting a row of data prior to import can break their entire flow. We’ve added a customization option that allows you granular control over how and if the end user should be able to delete rows from the Review & Finalize pane.

A blue arrow
May 2023

Specify expected date formats for template columns

New feature
New feature
New feature
May 2023

Admins can now specify the particular date format that’s expected for template columns instead of relying on OneSchema’s date detection (which defaults to a month, day, year interpretation). This impacts scenarios where a file’s uploaded date column contains a majority of ambiguous dates, and the format is not MM/DD/YY (e.g. 01/02/2022 can be either January 2nd, 2022 or February 1st, 2022).

A blue arrow
May 2023

Pre-built Transforms and Advanced Validations

New feature
New feature
New feature
April 2023
Apr 2023

JSON object data type validator

New feature
New feature
New feature
April 2023

JSON object is newly available as a data type validation for template columns.

A blue arrow
Apr 2023

Currency symbol validation support

New feature
New feature
New feature
April 2023

OneSchema’s money data type validation and autofix feature now supports the Pound (£), the Euro (€), and the Yen (¥) currency symbols.

A blue arrow
Apr 2023

Import metadata via webhook

New feature
New feature
New feature
April 2023

Rather than sending batched rows of data to a customer webhook, sheet metadata can now be sent via webhook. This is significantly faster and also enables you to directly use the metadata to retrieve data via external API (e.g. GET rows for paginated JSON or POST sheets for S3 URL download of CSV/excel/JSON).

A blue arrow
Apr 2023

Headless validation

New feature
New feature
New feature
March 2023

Since we’ve started building OneSchema, one of the deepest pain points we’ve seen in our customer base is building and maintaining recurring spreadsheet import workflows. Expensive engineering teams have to write brittle scripts to ingest the data, and spend countless engineering months maintaining validations to make sure all customer data is being imported correctly.

In the case of a failure, it’s extremely painful for the technical team to track down the root cause of the failure, and all the while the customer is frustrated because their data isn’t up-to-date in your product. OneSchema Headless empowers engineering teams to leverage OneSchema’s mapping, validation, and error resolution capabilities to painlessly build custom integrations with a wide variety of data sources, like SFTP/S3 file drops, CSV email attachments, messy API data, and more.

A blue arrow
Mar 2023

Webhook logs

New feature
New feature
New feature
March 2023

Users can now see logs of their importer and validation webhooks (up to the past 14 days). This should enable users to better debug their webhooks when they run into errors, and enable your teams to monitor webhook activity.

A blue arrow
Mar 2023

Direct to S3 file transfer

New feature
New feature
New feature
March 2023

Customers can now instruct OneSchema to send processed files directly to their own presigned URL.

A blue arrow
Mar 2023

In-memory code hooks

New feature
New feature
New feature
February 2023

Because our customers span a variety of industries, we often see workflows that come with unique business logic built into their specific datasets.

To make OneSchema even more flexible for these custom use cases, we’ve created OneSchema Code Hooks. Code Hooks empower your engineering team to generate tailored functions to reformat, transform, and/or validate data specific to your business's needs inside of the importer flow.

A blue arrow
Feb 2023

Events/errors webhooks

New feature
New feature
New feature
February 2023
Feb 2023

Custom columns renaming

New feature
New feature
New feature
February 2023
Feb 2023

Auto include unmapped columns

New feature
New feature
New feature
February 2023
Feb 2023

Historical picklist mapping

New feature
New feature
New feature
January 2023

Similar to historical column mapping, historical picklist option mapping remembers mappings and pre-fills the values for subsequent uploads. This behavior is active if the “Historical match” customization in the “Map columns” section is set.

A blue arrow
Jan 2023

Resume sessions

New feature
New feature
New feature
January 2023

Sessions can now be resumed in case a user's browser crashes or they do not finish an import. To enable this feature, update your SDK to the latest version(0.3.3) and pass in the param saveSession as true. Then sessions using the same userJwt and template key on the same browser will be prompted on resume as seen in the screenshot below.

A blue arrow
Jan 2023

Skip pane 4

New feature
New feature
New feature
January 2023
Jan 2023

Customizations Dashboard

New feature
New feature
New feature
December 2022

A dashboard with granular UI customizations is now available for you to make the OneSchema Importer look and feel like your existing product UI! We’ve also updated our default icon set and illustrations to be more brand-neutral, to help OneSchema’s Importer fit better in any product, even without customizations.

A dashboard with granular UI customizations is now available for you to make the OneSchema Importer look and feel like your existing product UI! We’ve also updated our default icon set and illustrations to be more brand-neutral, to help OneSchema’s Importer fit better in any product, even without customizations.

With our Branding Suite, you can now access 20+ customization options, including:

  • Primary, secondary, and background colors
  • Buttons
  • Success, Warning, and Error states
  • Custom illustrations
  • Font family and font colors

Watch this 3 minute step-by-step demo of the OneSchema Branding Suite that demonstrates how to fully customize your importer's color, font, and more.

A blue arrow
Dec 2022

Downloadable Excel templates

New feature
New feature
New feature
December 2022
Dec 2022

Accept clean rows only

New feature
New feature
New feature
December 2022

A new modal has been added to the end of the Review & Finalize pane that allows you to accept only rows without errors. For use cases where you’d like to get as much data in as possible but ingesting all of the user’s data isn’t critical, this is a great option to increase your import conversion rates.

The new modal addition:

  1. Allows your user to submit clean rows without having to fix every single error in their data
  2. Gives end users the opportunity to export the remaining errors so they may fix their data in Excel and re-upload it into your system.

Note: This modal will only appear if there are remaining error rows in your end user’s upload when they attempt to import.

OneSchema will still send the final JSON export with clean rows as “records” and error rows as “error_records.” This way, even if your user never returned to clean the rows with the remaining errors, you still have a record of the data not imported.

A blue arrow
Dec 2022

Export to S3

New feature
New feature
New feature
December 2022

OneSchema webhooks let you send data to your ingestion endpoint but can be slow for very large files.

Now, OneSchema can put your exported file into an S3 bucket, where you can retrieve it as JSON or CSV. This makes exporting large files far more performant.

To enable this new feature, a new OneSchemaConfig has been added: skipExportData. This changes the behavior of the success event (onSuccess callback in React) when not including a webhookKey. Instead of sending all of the data from the list, we will only send the sheet_id. You can then use API v1 to download a file or use our Paginated JSON Get end point.

We recommend this config option for customers who anticipate their end users will upload large files but don’t want them to wait for the file to finish processing before proceeding back to their workflow.

You can learn more about the config in our docs.

A blue arrow
Dec 2022

Fullscreen mode

New feature
New feature
New feature
December 2022
Dec 2022

Select header rows

New feature
New feature
New feature
November 2022
Nov 2022

Column splits/merge

New feature
New feature
New feature
November 2022
Nov 2022

Row splits/merge

New feature
New feature
New feature
November 2022
Nov 2022

Add/delete columns via API

New feature
New feature
New feature
November 2022
Nov 2022

Nested data support validation

New feature
New feature
New feature
November 2022
Nov 2022

API-as-a-service

New feature
New feature
New feature
November 2022
Nov 2022

Import via API

New feature
New feature
New feature
October 2022

We understand every company's file ingestion process is unique. That’s why a focus for OneSchema has always been enabling companies to optimize OneSchema’s import workflow for their specific use case. To further expand on the customizability of OneSchema, we’re introducing Import via API.

For workflows that ideally involve a blend of managing some portions of the import process internally while still using OneSchema to handle the rest, initializing the importer via our API provides a great solution.

A blue arrow
Oct 2022

Accept partial imports

New feature
New feature
New feature
October 2022

A new modal has been added to the end of the Review & Finalize pane that allows you to accept only rows without errors. For use cases where you’d like to get as much data in as possible but ingesting all of the user’s data isn’t critical, this is a great option to increase your import conversion rates.

The new modal addition:

  1. Allows your user to submit clean rows without having to fix every single error in their data
  2. Gives end users the opportunity to export the remaining errors so they may fix their data in Excel and re-upload it into your system.

Note: This modal will only appear if there are remaining error rows in your end user’s upload when they attempt to import.

OneSchema will still send the final JSON export with clean rows as “records” and error rows as “error_records.” This way, even if your user never returned to clean the rows with the remaining errors, you still have a record of the data not imported.

A blue arrow
Oct 2022

S3 export integration

New feature
New feature
New feature
October 2022
Oct 2022

Skip mapping pane

New feature
New feature
New feature
October 2022

The importer will now skip the mapping step if all template columns are matched (exact match) in the list (and header row selection was also skipped).

A blue arrow
Oct 2022

Required vs. optional columns

New feature
New feature
New feature
October 2022
Oct 2022

Data Template summary

New feature
New feature
New feature
October 2022

You can now customize the first pane of your CSV import experience to include a summary of the data you’d like your customer to import. You can include your required and optional fields and descriptions of the data the customer should upload.

We added the following optional customizations to empower you to create the ideal experience for your end users on the first pane:

  • The header and subheader copy within the Uploader component can now be fully customized
  • Show the required columns and their descriptions in a new InfoSideBar component
  • Show the required and optional columns along with their descriptions in a new InfoSideBar component

You can learn more about how to enable these customizations in our docs.

A blue arrow
Oct 2022

Localization (21 languages)

New feature
New feature
New feature
September 2022

OneSchema now supports the ability to fully translate the UI into the language of your choosing. Internationalization is currently an enterprise-tier feature. Please reach out to us to discuss your team's i18n needs and desired language support. Supported languages include: English, Spanish, Portuguese, French, German, Swedish, Chinese (Simplified), Czech, Danish, Dutch, Finnish, Hungarian, Italian, Japanese, Korean, Norwegian, Polish, Portuguese, Romanian, Russian, Arabic,

Learn more about the configuration option in our docs.

A blue arrow
Sep 2022

Upload pane customizations (v1)

New feature
New feature
New feature
September 2022
Sep 2022

Errors vs. warnings

New feature
New feature
New feature
September 2022
Sep 2022

Multi-picklist error resolution

New feature
New feature
New feature
August 2022

We’ve improved our picklist data type error resolution to support multi-value picklists. Your users can now resolve any delimited picklist columns with ease in the same way they would for single value picklist columns.

A blue arrow
Aug 2022

Skip header row selection pane

New feature
New feature
New feature
August 2022

To streamline the import process, users who upload a file with a header row will now skip the Header Row Selection pane and be taken directly to the Map Column pane. Header rows are automatically identified based on a number of criteria. To learn more about how we identify the header row, visit our changelog here.

A blue arrow
Aug 2022

Auto-accept custom suggestions

New feature
New feature
New feature
August 2022
Aug 2022

Template sandbox experience

New feature
New feature
New feature
August 2022

To enhance the template creation process as well as the implementation experience, we’ve released a sandbox of the Importer. This will allow you to see the Importer in action without any additional effort and quickly test new or existing templates with real files.

A blue arrow
Aug 2022

Picklist mapping

New feature
New feature
New feature
August 2022

Your users will now be prompted to map their picklist values to the set of values that you specify within a template. Picklist mapping will help eliminate any unrecognized, undesired, or incorrect values from being in the imported data.

A blue arrow
Aug 2022

Intelligent column mapping

New feature
New feature
New feature
August 2022

We’ve improved our column matching algorithm so your users’ uploaded columns will be automatically mapped to template columns during the Map Column pane more often. In addition to mapping columns that have exact column names, OneSchema will also remember historical mappings that your users may have successfully imported in the past. You can learn more about how our mapping intelligence works in our changelog.

A blue arrow
Aug 2022

Historical column mapping

New feature
New feature
New feature
August 2022
Aug 2022

Angular SDK

New feature
New feature
New feature
July 2022

Angular SDK is now available for users who would prefer to build the OneSchema Importer using Angular.

A blue arrow
Jul 2022

Branding v1

New feature
New feature
New feature
June 2022

You’re now able to customize the appearance of the OneSchema Importer through our developer dashboard! You may customize the primary color of the Importer to better match your brand colors and import a custom font via URL (e.g. Google Fonts or Adobe TypeKit). You will also be able to hide the OneSchema logo as long as you have committed to our annual subscription pricing.

We’re actively working on bringing you more granular customization options to better fit in with your product styles — if you have any particular requests, please let us know.

A blue arrow
Jun 2022

Javascript SDK

New feature
New feature
New feature
June 2022
Jun 2022

React SDK

New feature
New feature
New feature
June 2022
Jun 2022

Custom columns

New feature
New feature
New feature
May 2022

From our new Template Settings, you can now allow your users to upload and import custom columns from the Importer.

Your users can map any of their uploaded columns as a custom column. Custom columns come with default string validations but can be customized with additional validations from the Template Settings page.

A blue arrow
May 2022

Column validation hooks

New feature
New feature
New feature
March 2022

External validation hooks now also support column hooks in Rust. Below are the differences between the existing external row hooks and the new external column hooks:

Configuration differences: If the hook type is `column` the batch size can’t be configured since we always send all rows for column hooks. As you can see in the screenshot we also show a warning banner since a slow column hook could result in a bad user experience. The reason for this lies in the behavioral differences.

Behavioral differences: When a single value is updated by the user we send only send the edited row for row hooks.  For column hooks, we send the whole affected column which can be slower depending on the logic implemented by our admins.

Gating: The gate `ColumnHooks` has to be active in order to create and use column hooks. If the batch size doesn’t show up the `InMemoryListStorage` gate is not active.

A blue arrow
Mar 2022

Row validation hooks

New feature
New feature
New feature
February 2022
Feb 2022

Embedded importer launch

New feature
New feature
New feature
January 2022

The launch of our ready-made CSV importer for developers which automatically corrects customer data. (Also: edge case handling, simple UI, bulk editing).

A blue arrow
Jan 2022

Developer dashboard

New feature
New feature
New feature
January 2022
Jan 2022

Enum validator

New feature
New feature
New feature
December 2021
Dec 2021

Dynamic templates

New feature
New feature
New feature
December 2021

Create custom templates for each of your users. Generate templates via code and create an import experience tailored to your customer’s unique needs.

A blue arrow
Dec 2021

Manage organizations

New feature
New feature
New feature
November 2021
Nov 2021

Find-and-replace

New feature
New feature
New feature
October 2021
Oct 2021

Importer webhook launch

New feature
New feature
New feature
August 2021
Aug 2021

SSO login

New feature
New feature
New feature
August 2021
Aug 2021

No-code validation library

New feature
New feature
New feature
July 2021

At OneSchema, we’ve created the largest proprietary library of data validations available, designed for all industries. With our pre-built validators, even non-technical team members can configure your template(s) without asking an engineer for a single line of code – all while saving your team the enormous cost of building and continuously maintaining validations every time your database schema changes.

With OneSchema, setting up a validation is as easy as giving the column a name, selecting a validation from the dropdown, and optionally ticking a few boxes. We’re continuously testing our validators against messy CSV data of all types across our customer base, updating them to handle the never-ending list of new edge cases, and adding new ones so your team can focus on building your core product.

A blue arrow
Jul 2021

Date autofixers

New feature
New feature
New feature
July 2021
Jul 2021

OneSchema Workspaces v0 release

New feature
New feature
New feature
June 2021
Jun 2021

Template experience launch

New feature
New feature
New feature
June 2021
Jun 2021

Support for 50M row files

Improvement
Improvement
Improvement
April 2024

We've increased the efficiency of our Rust data infrastructure, allowing support for uploading even larger files than before (up to 50M rows or 10 GB files). Note: performance will be affected if code hooks are used, depending on the complexity of the code hook.

A blue arrow
Apr 2024

Code Hooks API

Improvement
Improvement
Improvement
February 2024

We've launched additional endpoints for creating code hooks via the API to allow you to easily manage your code hooks locally.

A blue arrow
Feb 2024

Webhook logs popover update

Improvement
Improvement
Improvement
February 2024

The log details popover for Validation Webhooks now contains "rows sent" and "errors returned". This will aid you in more easily debugging validation webhook issues.

A blue arrow
Feb 2024

All templates page redesign

Improvement
Improvement
Improvement
January 2024

We've just launched a redesign to the all templates page that allows users to search and sort their templates by various criteria (eg. template key, label, created time) and filter templates by whether they were created from the API. Our goal is to continue making it easier and much faster for you to find a template they are looking for, especially for organizations with a large amount of dynamic templates.

A blue arrow
Jan 2024

Picklist Truncation and Dropdown Width Adjustments

Improvement
Improvement
Improvement
November 2023

These 3 improvements to picklists help customers whose use cases require long picklist values to be inputted:

  1. Picklist pills will now truncate properly with a tooltip on hover to show the full value
  2. The base width of the dropdown has just naturally been increased 20% across the board
  3. The width of the dropdown will now actually increase if the column width increases
A blue arrow
Nov 2023

Accounting format for Number Autofixer

Improvement
Improvement
Improvement
November 2023

We've launched an update to our number autofixer, which can now handle negative numbers in account format. You can utilize this to automatically correct entries formatted as (100), and automatically change them to -100.

A blue arrow
Nov 2023

External API keys update

Improvement
Improvement
Improvement
October 2023

The external API keys page has been updated so every user can see all external API keys in their organization. With these changes, a user can create multiple keys, set a label, and see when an API key was last used. In addition, deleting a user also now does not delete any API key(s) created by that user.

A blue arrow
Oct 2023

Environment variables in webhook keys

Improvement
Improvement
Improvement
September 2023

Customers can now set environment variables in webhook keys. This helps customers who want to keep their secret keys isolated across different environments.

A blue arrow
Sep 2023

Define validation hooks in template overrides

Improvement
Improvement
Improvement
August 2023

Customizations and Templates determine the behavior of OneSchema Importers. Using overrides can allow specific behavior for individual importing sessions. Customers now have the ability to define validation hooks in template overrides.

A blue arrow
Aug 2023

Historical Matching improvements

Improvement
Improvement
Improvement
August 2023

We've launched a feature to split Historical Matching into User-specific and Org-level matching. Previously, this only worked on the org-level. This helps customers whose users are differentiated enough that they do not want to have cross-user mappings be saved.

A blue arrow
Aug 2023

Environment Variables in Importer Webhooks

Improvement
Improvement
Improvement
August 2023

Customers can now use environment variables in Importer Webhooks

A blue arrow
Aug 2023

Per-Customer Overrides

Improvement
Improvement
Improvement
July 2023

We’ve made improvements to our Template Overrides functionality by adding the ability to add and remove columns from the overrides.

A blue arrow
Jul 2023

Code Hooks improvements

Improvement
Improvement
Improvement
July 2023

We’ve made improvements to our custom code transformations and validations, also known as OneSchema Code Hooks. These Code Hook upgrades aim to greatly enhance both how your team builds custom functions that support your company’s unique business logic, as well as how your end-users experience the OneSchema Importer.

A blue arrow
Jul 2023

Review & Finalize pane UI improvements

Improvement
Improvement
Improvement
May 2023

We’ve added UI for end users to immediately filter for all rows, only rows with errors, or only clean rows.

A blue arrow
May 2023

Custom column support in validation webhooks

Improvement
Improvement
Improvement
May 2023

Custom columns can now be supported inside of validation webhooks. Review our updated docs to understand the different use cases, how to set up custom columns, and example JSON POST/responses.

A blue arrow
May 2023

Markdown support in customizations

Improvement
Improvement
Improvement
April 2023

To provide further customization of our Upload pane, the optional message box can now be customized using Markdown. Our customers can insert URLs to additional data import resources for the end user.

A blue arrow
Apr 2023

Multi-suggestion support for validation web hooks

Improvement
Improvement
Improvement
April 2023

Customers can now choose to return a list of suggestions from a validation webhook. End users will be prompted to select one of the suggestions as a part of the error resolution process.

A blue arrow
Apr 2023

Improved date validators

Improvement
Improvement
Improvement
April 2023
Apr 2023

Better error messages for numbers and currency

Improvement
Improvement
Improvement
April 2023

The error messaging for the Number data type and Money data type has been improved so end users can better understand why the value is invalid and how to fix it.

A blue arrow
Apr 2023

Template overrides

Improvement
Improvement
Improvement
January 2023
Jan 2023

Additional languages for i18n

Improvement
Improvement
Improvement
January 2023
Jan 2023

SDK upgraded to 0.3

Improvement
Improvement
Improvement
January 2023
Jan 2023

New template configurations

Improvement
Improvement
Improvement
January 2023

OneSchema templates just got even more powerful.

  • With the alternative mappings feature, you can tell OneSchema which mappings you’re expecting to see so that your user won’t have to map them manually.
  • Use fill default values to automatically fill in empty cells instead of leaving them blank
  • Check out the flexible options on our data type validations that let you validate everything from digits after the decimal to excluding special characters.

We've also redesigned the template column creation modal to better organize all the different data validations options and to make template creation easier for you.

A blue arrow
Jan 2023

Customizations v2

Improvement
Improvement
Improvement
November 2022
Nov 2022

New template configs

Improvement
Improvement
Improvement
October 2022
Oct 2022

Guided error-fixing

Improvement
Improvement
Improvement
September 2022

We’re very excited to announce our most requested feature: guided error fixing. In our beta tests, offering helpful suggestions for resolving errors has driven substantial uplift in import conversion rates. These upgrades include:

  • Error Fix Suggestions: OneSchema will offer suggestions to your customer to fix errors, contextualized to the type of error your customer is encountering.
  • Navigate to column with errors: When clicked in the issues summary, OneSchema will now pull the column with issues directly into view.

Bulk deleting rows:

  • Delete all rows with errors: OneSchema now contextually surfaces the option to delete all rows with errors, allowing customers to progress in their import workflow. Alternatively they can “Export to Excel” to get a summary of their errors.
  • Delete selected rows: “Delete selected row(s)” button when selecting rows will be shown to users

We are also launching usability improvements based on customer feedback:

  • Issues Sidebar: Issues summary sidebar will no longer obstruct the last few columns in the sheet. Instead, it will appear inside of the spreadsheet view.
  • Filter to find errors: We’ve added a “show error” button in the issues summary that when clicked, brings the error front-and-center. It’s never been easier to find errors in your file.
A blue arrow
Sep 2022

Import activity

Improvement
Improvement
Improvement
September 2022

An activity feed of all successful, failed, and unsubmitted imports are now available to view via the Developer Dashboard. This will let your team review information about the files that are being imported by each of your users. To help your customer success teams easily provide troubleshooting support on failed imports, we’ve also added the option to download the original files uploaded by your users.

A blue arrow
Sep 2022

SDK updated to 0.2

Improvement
Improvement
Improvement
August 2022

We’ve updated the version of our Javascript and React SDKs to v0.2. Updating the version will require some small changes to initialization and passing in configuration options.

See the new documentation here:

Javascript: https://docs.oneschema.co/docs/javascript

React: https://docs.oneschema.co/docs/react

A blue arrow
Aug 2022

Rust General Availability

Improvement
Improvement
Improvement
July 2022
Jul 2022

Default fill columns

Improvement
Improvement
Improvement
July 2022

You can now enable template columns to automatically fill a value of your choice into the mapped column’s empty cells.

Note: This is only available to customers whose Importers are using our new Rust architecture. Please reach out to your account manager if this feature isn’t available in your Create a Template column modal.

A blue arrow
Jul 2022

Advanced Branding

Improvement
Improvement
Improvement
July 2022

You’re now able to customize the appearance of the OneSchema Importer through our developer dashboard! You may customize the primary color of the Importer to better match your brand colors and import a custom font via URL (e.g. Google Fonts or Adobe TypeKit). You will also be able to hide the OneSchema logo as long as you have committed to our annual subscription pricing.

We’re actively working on bringing you more granular customization options to better fit in with your product styles — if you have any particular requests, please let us know.

A blue arrow
Jul 2022

Support for 10M+ row files

Improvement
Improvement
Improvement
July 2022

Our spreadsheets are running on new infrastructure! Our engineering team has built a new spreadsheet data service in Rust that loads every uploaded file fully in-memory. The spreadsheet files will live on new high-memory servers that make it possible to validate and transform files of up to 4 GB in under 1 second.

Files of up to 1,000,000 rows can be:

  • Uploaded in under a minute.
  • Validated in under a second.
  • Auto-fixed and transformed in under a second.
A blue arrow
Jul 2022

Updated dev docs

Improvement
Improvement
Improvement
June 2022
Jun 2022

Excel worksheet selection

Improvement
Improvement
Improvement
May 2022

Your users will be presented the option to select which worksheet within an Excel workbook they want to upload.

Note: This pane will only appear for users who upload an Excel Workbook with multiple worksheets. CSV uploads and single sheet imports will not trigger this modal.

A blue arrow
May 2022

Mapping UI update

Improvement
Improvement
Improvement
May 2022

The UI for the Map Column pane has been updated. We’ve added more visual separation to delineate your user’s uploaded columns from the template columns. We’ve also improved the delete UX to make it clearer that columns are deleteable and will not be imported as a result.

These changes do not require any additional configuration from you.

A blue arrow
May 2022

Column descriptions

Improvement
Improvement
Improvement
May 2022

Write custom descriptions for any column you feel your users could use additional context or instructions. These descriptions can help guide them through the mapping process and during the final validation step. Descriptions will appear in context to each column, both in the Map Column pane and the Review pane.

A blue arrow
May 2022

Improved error filtering

Improvement
Improvement
Improvement
May 2022
May 2022

Validation hooks batch sizes

Improvement
Improvement
Improvement
April 2022
Apr 2022

Rust architecture work begins

Improvement
Improvement
Improvement
March 2022
Mar 2022

Workspaces v1 release

Improvement
Improvement
Improvement
December 2021
Dec 2021

Manage templates via code

Improvement
Improvement
Improvement
December 2021
Dec 2021

Major UI redesign

Improvement
Improvement
Improvement
November 2021
Nov 2021

Expanded validation library (50+ options)

Improvement
Improvement
Improvement
September 2021
Sep 2021

Environment scopes for API keys

Security and Compliance
Security and Compliance
Security and Compliance
November 2023

We're excited to roll out environment scopes for API keys, which enables those keys to only access embeds in the prescribed environment. This helps customers uplevel the security of their organization by ensuring that their developers' local and staging environments should not have access to customer PII.

A blue arrow
Nov 2023

CA data residency

Security and Compliance
Security and Compliance
Security and Compliance
March 2023

Customers now have the option of having OneSchema instances hosted in Canada.

A blue arrow
Mar 2023

AU data residency

Security and Compliance
Security and Compliance
Security and Compliance
March 2023

Customers now have the option of having OneSchema instances hosted in Australia.

A blue arrow
Mar 2023

Self hosting (Enterprise Feature)

Security and Compliance
Security and Compliance
Security and Compliance
December 2022

You can now host OneSchema inside of your AWS or Azure cloud environment. The self-hosted model provides full isolation of data in your own cloud, and is best for customers who are handling government data (GovCloud), or other extremely sensitive data with unique contractual / compliance requirements. OneSchema will deploy updates and maintenance to the platform through an IAM user.

A blue arrow
Dec 2022

SOC 3 Report

Security and Compliance
Security and Compliance
Security and Compliance
September 2022
Sep 2022

Multi-region hosting

Security and Compliance
Security and Compliance
Security and Compliance
July 2022
Jul 2022

Audit logging dashboard & API

Security and Compliance
Security and Compliance
Security and Compliance
July 2022
Jul 2022

GDPR Compliance

Security and Compliance
Security and Compliance
Security and Compliance
June 2022
Jun 2022

HIPAA Compliance

Security and Compliance
Security and Compliance
Security and Compliance
June 2022
Jun 2022

Access management

Security and Compliance
Security and Compliance
Security and Compliance
May 2022

You can now grant and revoke team member access to OneSchema directly from the developer dashboard.

A blue arrow
May 2022

SOC 2 Type II Compliance

Security and Compliance
Security and Compliance
Security and Compliance
November 2021

While OneSchema makes the overall process of data migration much faster and far less painful, security and compliance are always top of mind as our customers trust us with their customer's sensitive business data and PII.

We are extremely excited to share the news today that OneSchema has now achieved SOC2 Type II compliance.

A blue arrow
Nov 2021
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Choose an Export Format for FileFeeds

New feature
New feature
New feature
June 2024

Users can now specify a desired export format for their FileFeed output via the settings pane. Currently, CSV and JSON are supported.

A blue arrow
Jun 2024

Advanced Excel Preparsing Hook

New feature
New feature
New feature
May 2024

We've launched a new preparsing hook that can be used for advanced Excel parsing. One example use case for this is the ability to ignore Excel's scientific notation formatting.

A blue arrow
May 2024

File Filter for FileFeeds

New feature
New feature
New feature
May 2024

Users can specify a regex for filtering which files are processed from their FileFeed source. This is applied at the FileFeed level and can be changed in FileFeed settings or upon instantiation of a new FileFeed. Files in the source directory that don't match the regex will be ignored.

A blue arrow
May 2024

Multi-Mappable Columns

New feature
New feature
New feature
April 2024

Customers can now specify a template column as multi-mappable, which allows your users to map multiple uploaded columns to the same template column. This enables better functionality for use cases such as aggregating multiple columns into a single column, and managing validation of multiple columns of the same type.

A blue arrow
Apr 2024

Custom Downloadable Excel Template

New feature
New feature
New feature
April 2024

We're excited to just expand the capabilities of theExcel template file that your users can download during the import process! This new feature enables you to upload a custom file in place of our default generated one. You can find the configuration for this in the Settings tab of each template. Please note that the customization must be enabled for the download button to appear in the importer.

A blue arrow
Apr 2024