Documentation/Templates

Templates

Define the structure for your data imports

What are Templates?

Templates define the expected structure of imported data. Each template contains columns that specify the data type, validation rules, and whether the field is required. When users import data, Rowporter maps their file columns to your template columns and validates the data accordingly.

Column Types

Text
string
Any text value. The most flexible column type.
Example:"John Doe", "Product ABC"
Available validations:
minLengthmaxLengthregexunique
Number
number
Numeric values including integers and decimals.
Example:42, 3.14, -100
Available validations:
minmaxunique
Email
email
Valid email addresses. Automatically validated for format.
Example:user@example.com
Available validations:
unique
Date
date
Date values. Supports multiple formats automatically.
Example:2024-01-15, 15/01/2024, Jan 15, 2024
URL
url
Valid web URLs. Automatically validated for format.
Example:https://example.com/page
Available validations:
unique
Phone
phone
Phone numbers. Supports international formats.
Example:+1 (555) 123-4567
Available validations:
regexunique
Boolean
boolean
True/false values. Accepts "yes", "no", "true", "false", 1, 0.
Example:true, false, yes, no, 1, 0

Template Settings

Required Fields

Mark columns as required to ensure users provide data for essential fields. Required columns must be mapped and have non-empty values.

Suggested Names

Add suggested column names to help with automatic mapping. If a user's file contains a column with a similar name, it will be automatically matched.

Extra Columns Handling

Choose how to handle columns in the user's file that don't match your template: ignore them, include them in the output, or warn the user.

Related Topics

Validation Rules

Learn about built-in validation rules like min/max length, regex patterns, and unique values.

Advanced Validation

Custom JavaScript rules and server-side validation for complex use cases.