Skip to main content

Templates

A template define the configuration of the spreadsheet file that you want to accept from the users.

For example, if you are expecting users to import a list of vehicles, you can create a template with "Vehicle" name.

Visit app.rowslint.io and click on the Add template button.

General​

Name​

required

An useful and unique name to identify the template.

Columns​

Each template column will match the spreadsheet column in the uploaded file according to the specified configuration.

Click on the Add column button to add a new column.

Name​

required

A unique column name that matches the column with the same name in the spreadsheet.

this is also the name that will be returned in the result after the import is completed.

Matched names​

optional

You can also add a list of additional names to match them with the spreadsheet columns.

For example, for the "name" column, you can accept to also match spreadsheet columns with "First name" and "First-name" names.

Displayed label​

optional

A custom column name, which will be displayed at the validation step as the column name.

Validation​

optional

A validation is a rule that the data must respect. If the data does not respect the pre-defined validation, the user will see an error message to identify what the problem is and how to fix it.

By default, accepts any value.

You can choose one of these builth-in validations:

  • Plein text
  • Number
  • Date
  • Email
  • Phone number
  • Choice list
  • API/Webhook dynamic list
  • Regular expression (regex)

Default value​

optional

The column default value in case it is not defined or empty in the spreadsheet file.

Required​

optional

Display an error if the column value is missed or empty. Deactivated by default.

Destination​

API/Webhook URL​

optional

The endpoint URL of your platform or where you want to send the imported data. You can add headers by clicking on Add new HTTP header, headers are displayed as key-value pairs

Options​

Allow invalid data​

optional

Allow user to import incorrect data if enabled. Deactivated by default.

Default language​

optional

Choose a default language for the importer dialog. English by default.

Available languages:

  • English
  • French

optional

You can allow your users to import their CSVs directly from a URL. This will create a complete page with the import modal if enabled.

Deactivated by default.

Settings​

Template key​

The template key is a unique identifier used to identify the template in the code.