Seamless Data Onboarding: Simpler than Ever

Ben Hartig
Ben Hartig
Co-Founder & CTO
Published:
September 20, 2024
Updated:
April 23, 2024
Seamless Data Onboarding: Simpler than Ever

Importing complex XML files, mapping dropdown options with AI precision, accessing erroneous data and its error type, and enhancing dropdown option creation – these are just some of the exciting advancements we've introduced to nuvo Data Importer SDK.

In this article, we'll take you through the key features of our latest product update, designed to make your data onboarding processes more efficient and user-friendly.

Import complex XML files with advancedParsing

XML files are typically the Achilles heel of data importers due to their complexity, hierarchical structure, and varying schemas. Custom scripts are often required to accurately parse and process XML files. However, with nuvo Importer’s advancedParsing feature, those days are over. Now, you can effortlessly import both nested JSON and XML files.

When a user uploads complex XML files, the advanced parsing automatically splits the XML file into multiple sheets, each corresponding to a dataset within the XML file. This empowers the user to choose whether to import a specific subset of data or the entire dataset. Activating this option transforms complex XML files into something akin to Excel workbooks with multiple sheets.

As we introduce advancedParsing, we are deprecating the "allowNestedData" setting. We strongly recommend using advancedParsing moving forward, as it not only supports the same functionalities as allowNestedData but also extends its support to complex and nested XMLs. Find out more in our documentation

AI-powered dropdown option mapping 

You are likely very familiar with nuvo importer’s intelligent column matching capabilities. We're excited to announce that we've expanded these mapping capabilities to include advanced mapping for dropdown options. When the processing engine is set to “node”, you and your customers are able to benefit from our trained AI algorithm.

It's important to note that to utilize our AI algorithm for dropdown option mappings, the data in these cells must be processed by nuvo. You have the flexibility to enable this property for individual clients according to your preferences. By default, this property is disabled.

Benefit from our AI algorithm for dropdown option mapping
Benefit from our AI algorithm for dropdown option mapping 

More flexibility in managing data with errors

Our importer now allows you to access rows containing errors, including the specific erroneous cell and its error type, separately. This enhancement significantly expands your options for managing data with errors, offering you and your customers more flexibility to further process the imported data. 

Based on your requirements, you can now start another import process with only the rows containing errors or export them for further analysis. Additionally, you see error messages for each value, explaining what caused the error.

With this enhancement, the identifier parameter inside the onResults function has been deprecated and replaced with the errors parameter. If you had implemented the identifier parameter within the onResults function, please ensure its removal to avoid any disruptions as communicated in the past weeks.

For more information, please refer to our documentation

onResults function with access to erroneous cells
onResults function with access to erroneous cells

Set allowCustomOptions locally

To provide you with a more granular approach to defining rules for dropdown option creation, we've moved the allowCustomOptions property from settings to the columns class.

You can now specify inside the target data model for each column individually whether you allow users to dynamically create dropdown options. For example, you can enable users to add more dropdown options for column A while restricting this capability for column B during the import process. This enhancement ensures that you grant the appropriate degree of flexibility to the users. 

Access to mapping logs

nuvo Importer leverages AI algorithms for seamless column matching between input data and the target system's required schema. We've recently introduced a new parameter called logs within the onResults function, granting you access to the mapping logs.

These logs provide insights into each source column and its corresponding target column, offering a summary of the mapping activities carried out during the import process. For more information, please refer to our documentation, or contact our sales team at sales@getnuvo.com for details on how to incorporate this feature into your plan. 

Goodbye to strange dates

Importing data with various date formats is a common challenge for businesses dealing with data from diverse global sources. We are excited to announce that nuvo importer understands and transforms automatically a total of 35 different date formats. This ensures that you can bid farewell to those perplexing date anomalies in your system.

nuvo understands and transforms automatically 35 date formats

And that concludes our update! We trust that these new features will help you to create the best possible data import experience for your internal teams and your clients. If you require further information on any of these features, please feel free to schedule a call with our team.

book a 30-minute call

Let's talk about your data onboarding needs

white visualwhite visual

Keep exploring

icon