Skip Ribbon Commands
Skip to main content

Specifications for CSV data

E-Receptionist accepts plain-text data in both comma-separated and tab-delimited formats. In both cases, columns are variable width. Comma-separated values must be enclosed in double quotes if they contain internal commas (in which case, 2 consecutive double quotes are used to encode internal quote characters). The order and number of columns must match the following specifications:

Staff directory

​Ordinal position Data type​ ​Can be empty Description​
​0 ​string ​No A value which uniquely identifies the staff member.​​
​1 ​string ​No ​The display name for the staff member.​
​2 ​string ​Yes ​The staff member's position or role within the firm.​
​3 ​string ​No ​The staff member's telephone extension​. Multiple extensions can be separated using internal commas.

Note: Staff photos are not supported for this data source.

Global directory

​Ordinal position Data type​ ​Can be empty Description​
​0 ​string ​No A value which uniquely identifies the individual.​​
​1 ​string ​No ​The display name for the individual.​
​2 ​string ​Yes The name of the firm/company to which the individual belongs.
​3 ​string ​Yes ​The telephone extension to dial​. Multiple extensions can be separated using internal commas.
​4 ​boolean ​Yes Value indicating whether the entry navigates to a deliveries menu instead of dialing a telephone number.​

Appointment list

Ordinal position Data type​ ​Can be empty Description​
​0 ​string ​No ​A value which uniquely identifies the appointment.​
​1 ​​ISO 8601 date (YYYY-MM-DDThh:mm) ​No ​The start date and time of the appointment.​
​2 ​string ​No ​The display name for the attendee. Consider using only first name and last initial​ to preserve privacy.
​3 ​string ​No ​​The appointment organiser's telephone extension​. Multiple extensions can be separated using internal commas.

Holidays 

Ordinal position Data type​ ​Can be empty Description​
​0 ​string No​ The display name for the holiday/observance.​
​1 ​ISO 8601 date (YYYY-MM-DD) No​ The date on which the office will be closed. Time component will be ignored if included.​