Import File Value Information

Overview

Import file values can be quite strict when it comes to format and/or raw value. This table should be used as a guide when organising import file data.

Reference
Data Type Description Valid Value(s) Notes
Dates Represents a specific calendar date. Dates should be set to a Date format (Format marked without an asterisk so it's stored independent of location) within the excel spreadsheet. This will allow DOTS Link to determine the appropriate date format and avoid date ambiguity. If the cell format is Text, the date format should follow the standard Percepium LMS format: yyyy/mm/dd. 8th of April 2018: 2018/05/08 These format rules are enforced as ambiguous day/month values will result in an error.
Time Zone Represents a time zone.
  • +10:00
  • -5:30
  • +08:00
 A positive or negative time must be specified.
Yes / No Also known as true/false or a boolean.

No values:

  • false
  • no
  • f
  • n
  • 0

Yes values:

  • true
  • yes
  • t
  • y
  • 1
 A positive or negative time must be specified.
Custom Fields Custom fields are a flexible way to add any additional fields you may want to store from the user that Percepium doesn't provide out of the box. Text box, Numeric and Date Fields are the only supported custom field types. DateField's must follow the Date format listed above in the Dates data type. TextBox's do not require a date format if the TextBox is used to display dates.
  • Wiping custom field data requires all user data (including all custom fields that are not to be wiped) in the import file and enabling "Wipe excluded values" option.
  • Updating custom fields is to be done as per-normal when updating other columns using their external IDs (but with CUSTOMFIELD_).
Email Addresses Complies with the official specifications from here.

The local-part of the e-mail address may use any of these ASCII characters:

  • Uppercase and lowercase English letters (a-z, A-Z)
  • Digits 0 to 9
  • Characters ! @ $ % && ' * + - / = ? ^ _ ' { } ~
  • Chracter . (dot, period, full stop) provided that it is not the first or last character and provided also that it does not appear two or more times consecutively.
Additionally, quoted-strings (ie: "John Doe"@example.com) are permitted, thus allowing characters that would otherwise be prohibited, however they do not appear in common practice. RFC 5321 also warns that "a host that expects to receive mail SHOULD avoid defining mailboxes where the Local-part requires (or uses) the Quoted-string form". 		The LMS/Web Services currently doesn't allow apostrophes by default.