Close

Help

Return to the main help page.

Database Import

The Database-Import facility lets you import database information from a CSV file.

The CSV file must be in the required format shown on the import page, matching the column formats and order. You will be given the chance to correct any entries which do not fit.

Considerations for specific column types
Date and Time

Time is optional on date-only columns, date is optional on time-only columns and omitting AM/PM will assume a 24hr clock format.

The permitted date/time formats are:

  • mmm-dd-yyyy hh:mm a/p  eg. Jan-21-2018 02:46
  • "mmmm d, yyyy hh:mm a/p"  eg. "January 21, 2018 02:46"
  • mm/dd/yyyy hh:mm a/p  eg. 01/21/2018 02:46
  • d-mmm-yyyy hh:mm a/p  eg. 21-Jan-2018 02:46
  • d/m/yy hh:mm a/p  eg. 21/1/18 02:46
  • dd-mmm-yy hh:mm a/p  eg. 21-Jan-2018 02:46
URL

The correct format for a URL column is:

visible text<URL>

For example:

Wikipedia Website<http://www.wikipedia.com>

Auto columns

You must specify a value for each auto column in the database, but the value will be ignored during the import.

Locked columns

You must specify a value for each locked column in the database. The value will be ignored if you do not have permission to update the locked column.

If the CSV file can be read and parsed correctly, then the contents can be previewed before importing them into the database.

General help for Databases.

Return to the main help page.

Does this answer your questions? If not, or if you would like more information, please contact support.