LogoLogo
WebsiteCommunity
  • Overview
    • Introduction
    • How to use it? In 5 steps
  • Importer
    • React Embed
    • Angular Embed
    • Bubble.io Embed
    • HTML & JS Embed
    • Text Customization
    • Directly Enter your Data
    • Select Header Row
  • Data Retrieval
    • Using Webhook
    • Using Frontend Callback
  • Validations
    • Base Validations
    • Advanced Validations
  • Features
    • Data Seeding
    • Import Excel with Image
    • Automated Import
    • Runtime Schema
    • Custom Validation
    • Default Value
    • Column Description
    • Freeze Columns
    • Multiselect Dropdown
    • Output Customization
  • Platform
    • Email Alerts
    • Activity Page
    • Manage Project
    • Make Your Team
    • How subscription works?
  • Additional Resources
    • FAQs
    • Architecture
    • Data Migrations
    • Selfhost Impler
    • Run Impler locally
    • Writing effectively into .xlsm files
  • Changelog
Powered by GitBook
On this page
  • Purpose
  • Example Schema
  • Available properties for schema

Was this helpful?

Edit on GitHub
Export as PDF
  1. Features

Runtime Schema

Do you need to import data in columns that are not fixed firsthand? Impler provides a facility to provide schema at the moment of opening the import widget.

PreviousAutomated ImportNextCustom Validation

Last updated 7 months ago

Was this helpful?

Available after the impler version 0.9.1

Purpose

Consider you have an ERP application that needs to import sales information. Our system provides a way to add extra information to sales information, like challan-no. Other users might have different columns.

In that case, fixing the import data structure is impossible. So we need to pass schema during run time when the user clicks on Import button to import the data.

You can find relevant implementation for react in and for HTML & HS in

Example Schema

[
  {
    name: 'Name',
    key: 'name',
    type: 'String'
  },
  {
    name: 'Phone',
    key: 'phone',
    type: 'Number',
    defaultValue: '#########'
  },
  {
    name: 'Country',
    key: 'country',
    type: 'String'
  }
]

Available properties for schema

Here are the keys

  • name (required): The name of the column, will be displayed in the import widget during mapping.

  • key (required): The key of the column, will be used to create an Excel file and match it with available headings in the file.

  • type (optional): One of the types from String, Number, Date, Email, Regex, Select, and Any to override the existing type for the column.

  • isRequired (optional): A boolean value indicating whether values in the current column are required.

  • isUnique (optional): A boolean value indicating whether values in the current column must be unique.

  • selectValues (optional): Select values indicating what are the possible values when the type is select.

  • regex (optional): A regular expression to override when the type is regex.

  • dateFormats (optional): Date formats indicating a list of formats acceptable for the date field. Required when type is Date. For example, ['dd/mm/yyyy','dd/mm/yy']

Providing Runtime Schema
Providing Runtime Schema

If you have any questions, suggestions, or comments. Feel free to reach out to us over . We’re constantly improving to deliver the best Data Importer for your product, and we value your input.

Discord