Scheduler Mappings

[Timothy]

I was not able to find a concise listing of the Appointments table mappings. So, after hours of trial and error and searching through the help and forums I came up with my own documentation. I'm sharing it here in the hopes that others will not have to spend so much time to figure this out. I'm sure Telerik can clarify and fill in the missing information. The formatting of this didn't come out so well so I am also including a screen shot.

Appointment Property	Data Type	Length	Example Data	Notes
Start	datetime		01/1/2013 12:00:00
End	datetime		01/1/2013 13:00:00
Duration	time	7	01:00:00	Can this be set to a datetime in older databases?
Summary	nvarchar	255	Lunch with Steve	Corresponds to Subject
Description	ntext		On the corner of 5th and Main	Corresponds to the large textbox without a label (i.e. details, etc.)
Location	nvarchar	255	Tony Roma's
Visible	bit/boolean		1/True
AllDay	bit/boolean		0/False	I would expect this to be associated with the All Day checkbox but it's always null in the database
AllowDelete	bit/boolean		1/True
AllowEdit	bit/boolean		1/True
UniqueID	int/uniqueidentifier		5  /  6706202d-ca29-40bc-81ab-b2a405c9e929	I'm not sure what this field is for. Maybe if you don't have Auto-Increment or Row GUID set to true it creates a default value for you. I know that if you do have Auto-Increment set you don't want this property pointing to that field.
BackgroundID	int		1	Corresponds to Background color (i.e. category)
StatusID	int		2	Corresponds to the "Show time as" drop down
RecurrenceRule	nvarchar	1024	FREQ=WEEKLY;BYDAY=MO,TU,WE;WKST=SU
MasterEventID	int/uniqueidentifier		5  /  6706202d-ca29-40bc-81ab-b2a405c9e929	This will contain the record id of the parent appointment if an indvidual appointment in a recurrence set has changed.
ResourceID	int/uniqueidentifier		6  /  1367f9f9-e4af-4036-9821-477fd86b81bf	This not on the appointments table but rather on the table that connects appointments to resources.
RecurrenceId	datetime		01/1/2013 12:00:00	Not sure what the point of this field is. It appears to be the Start date/time for an appointment that is an exception of a recurrence.
Resources				This is not a field on the database but rather the name of the relationship between the Appointments table and the AppointmentsResources table.
Exceptions				This is not a field on the database but rather the name of the relationship between child appointment (i.e. exception) and the parent appointment (master event).

[Julian Benkov]

Hello Timothy,

Thank your for the provided detailed information about RadScheduler binding and mapping of Appointments. We will improve and include this information in our online documentation.

I have updated your Telerik points accordingly.

Kind regards,
Julian Benkov
the Telerik team

[Timothy]

Can you tell me if RecurrenceId is still used? Do I need to persist it in my database?

Thanks,
Tim

[Peter]

Hello Timothy,

Thank you for the question.

The DateTime? RecurrenceId property is still in use in the RadScheduler event's object. Also, this property is exported and imported from/to ICAL files.

I hope that you find this information useful.

Regards,
Peter
the Telerik team

[Timothy]

Can you be more specific as to it's purpose and when it's used. Please be as specific and provide as much detail as possible.

I recently spent several days debugging an error that started to occur when saving an appointment. I'm not sure whether it was something I did or whether it started after downloading a new version of your code. The error wasn't trappable and would crash the program. My best guess is that it was occurring when the code was trying to populate the Recurrence Id in the table adapter. It said something about using DBNULL instead of Nothing. I was able to fix the error by overloading the Recurrence Id property. Using the ConvertToDataSource/ConvertToScheduler functions didn't work.

Anyway, I'm not worried about the error so please don't dwell on it. I need more specific information on when the Recurrence Id should be saved to the database so and I can figure out if that's working. So far I've not been able to see the Recurrence Id persisted to the database since I've overloaded it.

[Peter]

Hello Timothy,

Thank you for writing back.

This property is used when adding an exception in the events recurrence sequence (the appointment in the exception collection) and it is also used in the export to ICall format. It is referenced in the following classes: AppointmentMappingInfo, MappingInfoDialog, SchedulerICalendarExporter, SchedulerUIHelper, SchedulerInplaceEditorControl, SchedulerView and EditAppointmentDialog classes.

You can download the source code of our controls in order to debug the exception that you received and to access the code where this property is used. The source code is available only for our customer, not for trial users. You can download it by following these steps:

• Login to your account
• Click on Products and Subscriptions > DevCraft Complete
• Click on Download installer and other resources button on the right
• Click on Browse all product files link in the RadControls for Winforms pane
• Click the Source code link

Also, you can build the assemblies for the source code and you will be able to produce a stack trace when the error occurs.

I hope this helps.

All the best,
Peter
the Telerik team