For importing appointments into CMS please arrange the data as follows:

•  Comma Separated File (csv).
•  Text fields should be quoted to preserve commas.
•  The first line will be ignored (field names).
•  Fields that are not applicable must be left empty.

Fields:

No	Name	Description
	ClientBranchProductID	Unique identifier in CMS for the client, branch and product combination. Can be found on the Client Product Details screen for the client.
	AttendanceTypeID	Appointment type identifier.
	AttendanceSubTypeID	Appointment sub type. Leave this blank if none defined.
	ConsultantID	User identifier for the attending consultant.
	AppointmentStage	Indicates if the appointment is open or closed. Valid values are "Appointment" for an open appointment and "Authorised" for a closed appointment.
	AttendanceDate	Date on which this appointment occurs. May not be prior to the start of the current month.
	AttendanceTime	Time of day for the appointment.
	Duration	Length of the appointment in minutes - 90 would mean one and a half hours.
	EmployeeParticulars	Text description. May not contain new line (enter) characters. Please type in "\n" for new line characters.
	ClientSatisfactionRating	1 = Client is satisfied with our service, 2 = There is a concern with this client.
	ClientSatisfactionComment	Text description for the client satisfaction.
	ClientHasComplained	0 = No complaint, 1 = Client has complained.
	IsCancelImminent	0 = Cancellation is not imminent, 1 = Cancellation is imminent.