Import

The import process allows users to import an excel file with entity records.

The first step is to download the template by clicking on Download the template.

It's important that you change the data types of the columns to text to avoid problems converting date and time.

Especial Fields Formats

Date

Date must be in the format YYYY-MM-DD. Example: 2020-12-30.

Datetime

Datetime must be in the format YYYY-MM-DD HH:mm. Example: 2020-12-30 18:59.

Files and Images

Files and images must be the URL of the files, separated by a space. Example: https://scaffoldhub.io/image1.png https://scaffoldhub.io/image2.png

Relation to One or Relation to User (one)

Relations to one must be the ID of the related entity. Example: 5f05d54388768c00437dfd11.

Relation to Many or Relation to Users (many)

Relations to many must be the IDs of the related entities separated by a space. Example: 5f05d54388768c00437dfd11 5f0616d3da85f00043c79103