Skip to main content

Basic Concepts

Welcome to Dromo!

Dromo is an easy and intuitive spreadsheet importer that integrates seamlessly with your product.

Dromo helps your users match columns, correct errors, perform complex validations, tranform values, and upload perfectly formatted data.

Check out a live demo to try it yourself with realistic data!

Quickstart​

If you want to jump straight into getting Dromo into your app, you can head to one of these quickstart guides.

To embed a dynamic Dromo importer, choose the SDK that works best for you:

Or if you want to create a no-code schema in the Dromo Dashboard, head over to the Schema Studio guide.

Dromo Pro in one minute video​

Basic Set Up​

There are two ways to set up a Dromo importer: using the Schema Builder or using one of Dromo's SDKs to define your importer in code.

The Schema Studio is a no-code option that allows you to quickly configure an importer and add it to your application. Try out the Schema Builder now and see how quickly you can define a custom importer.

Defining the importer in code allows for full control of all settings, enabling you to leverage all of Dromo's powerful features. This interactive sandbox is a great example of a fully customized Dromo instance.

Now you know what Dromo is, let's cover some basics. If you have any questions, you can chat with us any time by clicking on the chat bubble, or email us at contact@dromo.io.

Prerequisites​

Whether you define the importer in code or use the Schema Studio, you'll be embedding Dromo in your application with a JavaScript snippet. Before you can do this, you'll need a few things:

  • You will need a free license key. You can get a license key by registering for an account. No payment information is necessary to get started.
  • You will need a place in your JavaScript application or HTML page where you want the importer to be accessed.

Supported file types​

You can use Dromo to import CSV, TSV, XLS, XLSX, XML, or JSON files directly into your application or database.

The basics of Dromo​

There are 4 parts of a Dromo implementation:

  • Defining a schema, either in code or using the Schema Studio
  • Adding validations and transformations
  • Handling the result
  • Customizing the experience
tip

For examples of things you can do in each step, see the Guides in the sidebar.

Defining a schema​

To implement Dromo in your application, you must first define a schema. A schema is a list of fields that you want to import. These fields will be matched to columns during the import process, and define the properties of the JSON payload passed back in the results.

Adding validations and transformations​

With your schema defined, you can add validation rules and data transformation hooks to exactly match the import process to match your data requirements and provide interactive feedback to users during the import process.

tip

Hooks are powerful features that are only available to users on Dromo Pro plans

Handling the result​

After an import is submitted, you will have access to a JSON payload of clean results. You can handle this data directly in the frontend, or fetch it from storage via our REST API.

Customizing the experience​

Dromo is white-label by default, so you can tailor the styling to match your brand. You can craft unique help text, configure the column matching process, regulate user behavior, and vary other settings to suit your requirements.