Scheduler Exporting A Range of Appointments

[Brian Mains]

Hello,

I love the export feature available with telerik, but I'm curious of one thing.  If I schedule a recurring appointment, it comes up as one appointment record.  Say this appointment recurs from November to June.  I only want to export the month of January.  How, with the recurring appointments, can I export just the month of January, since recurrence is represented by a single Appointment class?

Thanks.

[Peter]

Hi Brian,

Yes, this is possible. Using the iCalendar Export example, modify the code like this:

protected void Button2_Click(object sender, ImageClickEventArgs e)
        {
            List<Appointment> AppointmentCollection = new List<Appointment>();

            foreach (Appointment a in RadScheduler1.Appointments.GetAppointmentsInRange(new DateTime(2009, 1, 1), new DateTime(2009, 1, 31)))
            {
                if (a.RecurrenceState == RecurrenceState.Master)
                {
                    RecurrenceRule parsedRule;
                    RecurrenceRule.TryParse(a.RecurrenceRule.ToString(), out parsedRule);
                    parsedRule.SetEffectiveRange(new DateTime(2009, 1, 1), new DateTime(2009, 1, 31));

                    foreach (DateTime occurrence in parsedRule.Occurrences)
                    {
                        Appointment app = new Appointment();
                        app.Subject = a.Subject;
                        app.Start = occurrence;
                        app.End = occurrence.Add(a.Duration);
                        AppointmentCollection.Add(app);
                    }
                }

                else if (a.RecurrenceState != RecurrenceState.Occurence)
                    {
                        AppointmentCollection.Add(a);
                    }
            }
            WriteCalendar(RadScheduler.ExportToICalendar(AppointmentCollection));

        }

Cheers,
Peter
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[Brian Mains]

Thanks!

[Brian Mains]

Hey,

It seems that the appointments scheduled, even the recurring ones in the current view I'm in, have the value: RecurrenceState.Occurence and thus in your code wouldn't be exported.  How does that property get set and why is it the wrong condition for me, according to your code?

Thanks.

[Peter]

Hi Brian,

In my test project this workd as expected. Anyhow, you can use another condition for a recurrent master appointement: if(a.RecurrenceRule != String.Empty)

Greetings,
Peter
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[Brian Mains]

Hey,

This doesn't ever seem to be hit:

if (!string.isNullOrEmpty(a.RecurrenceRule))

Because every object that comes back has the RecurrenceParentID set to a key value, and the RecurrenceRule null, that comes back from RadScheduler.GetAppointmentsInRange(..).  So it seems this method does the work of figuring out which appointments in a recurrence are of which day...

The other issue I'm experiencing is that appointments exported that have the RecurrenceParentID set to a value do not get exported to the ICS file when exporting...

Thanks.

[Brian Mains]

Hello,

I ended up creating separate appointment objects and it worked;  rather than adding what the scheduler gives me, I simply copy the necessary data from one to a new Appointment object without any recurrence information specified, and that appears to work.

Thanks.

[Deepa Balasundaram]

Hi Peter,

When you export recurring events using the method you have given here, the events are properly imported to outlook calendar but not to google calendar. Why is that?

Thanks,
Deepa

[Peter]

Hi Deepa,

Currently, exporting to google calendar is not supported by RadScheduler, but we will consider implementing this feature.

Thanks for your question.


Greetings,
Peter
the Telerik team

Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Follow the status of features or bugs in PITS and vote for them to affect their priority.

[Deepa Balasundaram]

OK. Thank you.

I have another question for you. I have a RadPanelBar with few RadPanelItems. I would like to use one of these panel itmes to export appointments in my RadScheduler.

I am getting errors if I use the following function for the "OnClientItemClicked" event.

function Export(sender, e) {
                $find("<%= RadAjaxManager1.ClientID %>").__doPostBack(sender.name, "");
            }

So, I couldn't export the appointments. Is there any solution for this? I have pasted my code for your reference here:

<telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">

        <script type="text/javascript">
            function Export(sender, e) {
                $find("<%= RadAjaxManager1.ClientID %>").__doPostBack(sender.name, "");
            }
        </script>

</telerik:RadCodeBlock>
<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" DefaultLoadingPanelID="RadAjaxLoadingPanel1">
    <AjaxSettings>
        <telerik:AjaxSetting AjaxControlID="RadScheduler1">
            <UpdatedControls>
                <telerik:AjaxUpdatedControl ControlID="RadScheduler1" LoadingPanelID="RadAjaxLoadingPanel1" />
            </UpdatedControls>
        </telerik:AjaxSetting>
        <telerik:AjaxSetting AjaxControlID="RadCalendar1">
            <UpdatedControls>   
                <telerik:AjaxUpdatedControl ControlID="RadCalendar1" />                               
                <telerik:AjaxUpdatedControl ControlID="RadScheduler1" LoadingPanelID="RadAjaxLoadingPanel1" />
            </UpdatedControls>
        </telerik:AjaxSetting>        
    </AjaxSettings>
</telerik:RadAjaxManager>
<telerik:RadFormDecorator ID="RadFormDecorator1" runat="server" DecoratedControls="Buttons" Skin="Office2007" />

<div>
        <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Skin="Office2007" ></telerik:RadAjaxLoadingPanel>
        <telerik:RadAjaxPanel runat="server" ID="RadAjaxPanel1" HorizontalAlign="NotSet" LoadingPanelID="RadAjaxLoadingPanel1">  </telerik:RadAjaxPanel>
        <div class="example-panel">
            <telerik:RadSplitter runat="server" ID="RadSplitter1" PanesBorderSize="0" Width="734px"
                Height="552px" Skin="Office2007">
                <telerik:RadPane runat="Server" ID="leftPane" Width="240px" MinWidth="240" MaxWidth="300"
                    Scrolling="None" OnClientResizing="hideScrollableArea" OnClientResized="showScrollableArea"
                    OnClientExpanding="hideScrollableArea" OnClientExpanded="showScrollableArea"
                    OnClientCollapsing="hideScrollableArea" OnClientCollapsed="showScrollableArea">
                    <div class="calendar-container">
                        <telerik:RadCalendar runat="server" ID="RadCalendar1" Skin="Office2007" AutoPostBack="true"
                            EnableMultiSelect="false" DayNameFormat="FirstTwoLetters" EnableNavigation="true"
                            EnableMonthYearFastNavigation="false" OnSelectionChanged="RadCalendar1_SelectionChanged">                            
                        </telerik:RadCalendar>
                    </div>
                    <telerik:RadPanelBar ID="RadPanelBar1" runat="server" Skin="Office2007" Width="100%" OnItemClick="RadPanelBar1_ItemClick" >
                        <Items>
                            <telerik:RadPanelItem runat="server" Text="Export" Expanded="true">
                                <Items>
                                    <telerik:RadPanelItem runat="server" Text="Export All"></telerik:RadPanelItem>
                                    <telerik:RadPanelItem runat="server" Text="Export Present to Future"></telerik:RadPanelItem>
                                    <telerik:RadPanelItem runat="server" Text="Export Range"></telerik:RadPanelItem>
                                </Items>
                            </telerik:RadPanelItem>
                            <telerik:RadPanelItem runat="server" Text="Import" Expanded="true">
                                <Items>
                                    <telerik:RadPanelItem runat="server" Text="Export"></telerik:RadPanelItem>
                                    <telerik:RadPanelItem runat="server" Text="Import"></telerik:RadPanelItem>
                                    <telerik:RadPanelItem runat="server" Text="Home"></telerik:RadPanelItem>
                                </Items>
                            </telerik:RadPanelItem>
                        </Items>
                    </telerik:RadPanelBar>
                    <br />
                   
                    <!-- tabs start -->
                    <asp:LinkButton ID="lbLogin" runat="server" Font-Bold="True" Font-Size="Small"> [Home] </asp:LinkButton> <br />      
                    <asp:LinkButton ID="lbTasks" runat="server" Font-Bold="True" Font-Size="Small"> [Export] </asp:LinkButton> <br />
                    <asp:LinkButton ID="lbSearch" runat="server" Font-Bold="True" Font-Size="Small"> [Import] </asp:LinkButton><br />
                    <asp:LinkButton ID="LinkButton1" runat="server" Font-Bold="True" Font-Size="Small" OnClick="LinkButton1_click"> [Export Link] </asp:LinkButton><br />
                    <br /> <br />                    
                   
                <!-- tabs end -->
                
                </telerik:RadPane>
            <telerik:RadSplitBar runat="server" ID="RadSplitBar2" CollapseMode="Forward" />
                <telerik:RadPane runat="Server" ID="rightPane" Scrolling="None" Width="490px">                   
                        <asp:Panel ID="Panel1" runat="server" Style="font: normal 12px Arial, Verdana, Sans-serif;
                        color: #a6a896;">     
                        <telerik:RadScheduler ID="RadScheduler1" runat="server" Skin="Office2007"
                        OnAppointmentCreated="RadScheduler1_AppointmentCreated"   Height="551px"     
                        DataEndField="End" DataKeyField="ApptId" DataSourceID="LinqDataSource1" DataStartField="Start"
                        DataSubjectField="Subject" HoursPanelTimeFormat="htt" ValidationGroup="ctl00_RadScheduler1"
                        DataRecurrenceField="RecurrenceRule" DataRecurrenceParentKeyField="RecurrenceParentId"
                        SelectedView="MonthView" CustomAttributeNames="Location, IsPrivate"
                        EnableCustomAttributeEditing="True"
                        OnClientFormCreated="schedulerFormCreated"
                        OnClientTimeSlotClick="OnClientTimeSlotClick"
                        OnClientAppointmentClick="OnClientAppointmentClick"
                        onformcreated="RadScheduler1_FormCreated"
                        onformcreating="RadScheduler1_FormCreating" >
                        <Localization AdvancedAllDayEvent="All day"></Localization>        
                        <AdvancedForm DateFormat="M/d/yyyy" TimeFormat="h:mm tt" Modal="True"></AdvancedForm>
                        <AppointmentTemplate>
                            <div>
                                <%# Eval("Subject") %>
                            </div>
                        </AppointmentTemplate>
                        <MonthView FirstDayHeaderDateFormat="dd MMMM" HeaderDateFormat="MMMM, yyyy" />
                        <AdvancedEditTemplate>
                            <scheduler:AdvancedForm runat="server" ID="AdvancedEditForm1" Mode="Edit" Subject='<%# Bind("Subject") %>'
                                Location='<%# Bind("Location") %>' Start='<%# Bind("Start") %>' End='<%# Bind("End") %>'
                                IsPrivate='<%# Bind("IsPrivate") %>' RecurrenceRuleText='<%# Bind("RecurrenceRule") %>' />
                        </AdvancedEditTemplate>
                        <AdvancedInsertTemplate>
                            <scheduler:AdvancedForm runat="server" ID="AdvancedInsertForm1" Mode="Insert" Subject='<%# Bind("Subject") %>'
                                Location='<%# Bind("Location") %>' Start='<%# Bind("Start") %>' End='<%# Bind("End") %>'
                                IsPrivate='<%# Bind("IsPrivate") %>' RecurrenceRuleText='<%# Bind("RecurrenceRule") %>' />
                        </AdvancedInsertTemplate>
                        <TimelineView UserSelectable="false" />
                    </telerik:RadScheduler>                     
                    </asp:Panel>                    
            </telerik:RadPane>
            </telerik:RadSplitter>
            </div>
      
 
 
    <asp:LinqDataSource ID="LinqDataSource1" runat="server" ContextTypeName="CREC.DNNModules.MySource_Calendar.MySource_CalendarDataContext"
        EnableDelete="True" EnableInsert="True" EnableUpdate="True" TableName="MySource_Calendar_Appts"
        OnInserting="LinqDataSource1_Inserting" OnSelecting="LinqDataSource1_Selecting"
        OnUpdating="LinqDataSource1_Updating" OnDeleting="LinqDataSource1_Deleting">
    </asp:LinqDataSource>

Thanks,
Deepa

[Peter]

Hello Deepa,

The Export method in the online demo is used to cause a real postback by the AjaxManager. In your case, your RadPanelbar control is not ajaxified so you can avoid this technique and simply handle the ItemClick server event of RadPanelbar.

Greetings,
Peter
the Telerik team

Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Follow the status of features or bugs in PITS and vote for them to affect their priority.

[Deepa Balasundaram]

But if only have onclick event for the RadPanelItems, I am getting the folowing error:

Line: 4723
Error: Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed. Common causes for this error are when the response is modified by calls to Response.Write(), response filters, HttpModules, or server trace is enabled.
Details: Error parsing near 'BEGIN:VCALENDAR
VER'.

Deepa

[Deepa Balasundaram]

Here is my code:

<telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">

        <script type="text/javascript">
            function realPostBack(eventTarget, eventArgument) {
                $find("<%= RadAjaxManager1.ClientID %>").__doPostBack(eventTarget, eventArgument);
            }
                     
        </script>

</telerik:RadCodeBlock>
<div id="divRadMgr">
<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" DefaultLoadingPanelID="RadAjaxLoadingPanel1">
    <AjaxSettings>
        <telerik:AjaxSetting AjaxControlID="RadScheduler1">
            <UpdatedControls>
                <telerik:AjaxUpdatedControl ControlID="RadScheduler1" LoadingPanelID="RadAjaxLoadingPanel1" />
            </UpdatedControls>
        </telerik:AjaxSetting>
        <telerik:AjaxSetting AjaxControlID="RadCalendar1">
            <UpdatedControls>   
                <telerik:AjaxUpdatedControl ControlID="RadCalendar1" />                               
                <telerik:AjaxUpdatedControl ControlID="RadScheduler1" LoadingPanelID="RadAjaxLoadingPanel1" />
            </UpdatedControls>
        </telerik:AjaxSetting>  
        <telerik:AjaxSetting AjaxControlID="RadPanelBar1">
            <UpdatedControls>   
                <telerik:AjaxUpdatedControl ControlID="RadPanelBar1" />                                               
            </UpdatedControls>
        </telerik:AjaxSetting>  
    </AjaxSettings>    
</telerik:RadAjaxManager>
<telerik:RadFormDecorator ID="RadFormDecorator1" runat="server" DecoratedControls="Buttons" Skin="Office2007" />
</div>
<div>
        <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Skin="Office2007" ></telerik:RadAjaxLoadingPanel>
        <telerik:RadAjaxPanel runat="server" ID="RadAjaxPanel1" HorizontalAlign="NotSet" LoadingPanelID="RadAjaxLoadingPanel1">  </telerik:RadAjaxPanel>
        <div class="example-panel">
            <telerik:RadSplitter runat="server" ID="RadSplitter1" PanesBorderSize="0" Width="734px"
                Height="552px" Skin="Office2007">
                <telerik:RadPane runat="Server" ID="leftPane" Width="240px" MinWidth="240" MaxWidth="300"
                    Scrolling="None" OnClientResizing="hideScrollableArea" OnClientResized="showScrollableArea"
                    OnClientExpanding="hideScrollableArea" OnClientExpanded="showScrollableArea"
                    OnClientCollapsing="hideScrollableArea" OnClientCollapsed="showScrollableArea">
                    <div class="calendar-container">
                        <telerik:RadCalendar runat="server" ID="RadCalendar1" Skin="Office2007" AutoPostBack="true"
                            EnableMultiSelect="false" DayNameFormat="FirstTwoLetters" EnableNavigation="true"
                            EnableMonthYearFastNavigation="false" OnSelectionChanged="RadCalendar1_SelectionChanged">                            
                        </telerik:RadCalendar>
                    </div>
                    <telerik:RadPanelBar ID="RadPanelBar1" runat="server" Skin="Office2007" Width="100%" OnItemClick="RadPanelBar1_ItemClick">
                        <Items>                            
                            <telerik:RadPanelItem Text="Test" Expanded="true">
                                <Items>
                                    <telerik:RadPanelItem Text="Export All" Value="Export All"></telerik:RadPanelItem>
                                    <telerik:RadPanelItem Text="Export Present to Future"></telerik:RadPanelItem>
                                    <telerik:RadPanelItem Text="Export Range" ></telerik:RadPanelItem>  
                                    <telerik:RadPanelItem Text="Terminate" Value="Terminate" ></telerik:RadPanelItem>                                    
                                </Items>
                            </telerik:RadPanelItem>  
                            <telerik:RadPanelItem Text="Import" Expanded="true">
                                <Items>
                                    <telerik:RadPanelItem Text="Import"></telerik:RadPanelItem>                                   
                                </Items>
                            </telerik:RadPanelItem>                              
                        </Items>
                    </telerik:RadPanelBar>
                    <br />
                   
                    <!-- tabs start -->

                    <asp:LinkButton ID="LinkButton1" runat="server" Font-Bold="True"
                    Font-Size="Small" OnClick="LinkButton1_Click"> [Export] </asp:LinkButton>
                    <br />
                    <br /> <br />                    
                   
                <!-- tabs end -->
                
                </telerik:RadPane>
            <telerik:RadSplitBar runat="server" ID="RadSplitBar2" CollapseMode="Forward" />
                <telerik:RadPane runat="Server" ID="rightPane" Scrolling="None" Width="490px">                   
                        <asp:Panel ID="Panel1" runat="server" Style="font: normal 12px Arial, Verdana, Sans-serif;
                        color: #a6a896;">     
                        <telerik:RadScheduler ID="RadScheduler1" runat="server" Skin="Office2007"
                        OnAppointmentCreated="RadScheduler1_AppointmentCreated"   Height="551px"     
                        DataEndField="End" DataKeyField="ApptId" DataSourceID="LinqDataSource1" DataStartField="Start"
                        DataSubjectField="Subject"
                        DataRecurrenceField="RecurrenceRule" DataRecurrenceParentKeyField="RecurrenceParentId"
                        SelectedView="MonthView" CustomAttributeNames="Location,IsPrivate"
                        EnableCustomAttributeEditing="True"
                        OnClientFormCreated="schedulerFormCreated"
                        OnClientTimeSlotClick="OnClientTimeSlotClick"
                        OnClientAppointmentClick="OnClientAppointmentClick"
                        onformcreated="RadScheduler1_FormCreated"
                        onformcreating="RadScheduler1_FormCreating" >
                        <AdvancedForm DateFormat="M/d/yyyy" TimeFormat="h:mm tt" Modal="True"></AdvancedForm>
                        <AppointmentTemplate>
                            <div>
                                <%# Eval("Subject") %>
                            </div>
                        </AppointmentTemplate>
                        <MonthView FirstDayHeaderDateFormat="dd MMMM" HeaderDateFormat="MMMM, yyyy" />
                        <AdvancedEditTemplate>
                            <scheduler:AdvancedForm runat="server" ID="AdvancedEditForm1" Mode="Edit" Subject='<%# Bind("Subject") %>'
                                Location='<%# Bind("Location") %>' Start='<%# Bind("Start") %>' End='<%# Bind("End") %>'
                                IsPrivate='<%# Bind("IsPrivate") %>' RecurrenceRuleText='<%# Bind("RecurrenceRule") %>' />
                        </AdvancedEditTemplate>
                        <AdvancedInsertTemplate>
                            <scheduler:AdvancedForm runat="server" ID="AdvancedInsertForm1" Mode="Insert" Subject='<%# Bind("Subject") %>'
                                Location='<%# Bind("Location") %>' Start='<%# Bind("Start") %>' End='<%# Bind("End") %>'
                                IsPrivate='<%# Bind("IsPrivate") %>' RecurrenceRuleText='<%# Bind("RecurrenceRule") %>' />
                        </AdvancedInsertTemplate>
                        <TimelineView UserSelectable="false" />
                    </telerik:RadScheduler>                     
                    </asp:Panel>                    
            </telerik:RadPane>
            </telerik:RadSplitter>
            </div>


CODE BEHIND:
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
            {
                LinkButton1.Attributes.Add("onclick", string.Format("realPostBack(\"{0}\", \"\"); return false;", LinkButton1.UniqueID));
                RadPanelBar1.Attributes.Add("onitemclick", string.Format("realPostBack(\"{0}\", \"\"); return false;", RadPanelBar1.UniqueID));
            }
}
protected void RadPanelBar1_ItemClick(object sender, RadPanelBarEventArgs e)
        {
            RadPanelItem ItemClicked = e.Item;
           
                if (ItemClicked.Text.Contains("Export"))
                {
                    List<Appointment> AppointmentCollection = new List<Appointment>();

                    foreach (Appointment a in RadScheduler1.Appointments)
                    {
                        try
                        {   //Check if the appointment is a recurring event
                            if (a.RecurrenceState == RecurrenceState.Master)
                            {
                                //Parse the recurring events to get the recurring counts/occurences
                                RecurrenceRule parsedRule;
                                RecurrenceRule.TryParse(a.RecurrenceRule.ToString(), out parsedRule);

                                //Save each occurence of the recurring Master event as a seperate event
                                foreach (DateTime occurrence in parsedRule.Occurrences)
                                {
                                    Appointment app = new Appointment();
                                    app.Subject = a.Subject;
                                    app.Start = occurrence;
                                    app.End = occurrence.Add(a.Duration);
                                    AppointmentCollection.Add(app);
                                }
                            }
                            //Check if the appointment is not an occurence if an recurring master event
                            else if (a.RecurrenceState != RecurrenceState.Occurrence)
                            {
                                AppointmentCollection.Add(a);
                            }
                        }
                        catch (Exception ex)
                        {
                            String text = ex.Message;
                        }

                    }
                    TimeSpan currentOffset = TimeZone.CurrentTimeZone.GetUtcOffset(DateTime.Now);
                    try
                    {
                        WriteCalendar(RadScheduler.ExportToICalendar(AppointmentCollection, currentOffset));
                    }
                    catch (Exception excep)
                    {
                        String text = excep.Message;
                    }
                }
            
            
            
        }

For this code, I am getting the following error:

"Line: 4723
Error: Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed. Common causes for this error are when the response is modified by calls to Response.Write(), response filters, HttpModules, or server trace is enabled.
Details: Error parsing near 'BEGIN:VCALENDAR
VER'."

Deepa

[Deepa Balasundaram]

OK. I figured it out. The scenario is similar to the RadUpload scenario.

Deepa

[Shahzada]

i am facing same error
but unable to solve it, kindly help me

[Plamen]

Hello Shahzada,

 
If you are trying to export appointments by using some other way than the ones described in our on-line demo. please have in mind that a real post back is required.

You can refer to this forum post where is explained one way to handle such functionality using theOnRequestStart event of RadAjaxManager.
 
Hope this will be helpful.

Kind regards,
Plamen Zdravkov
the Telerik team

[Shahzada]

done it

thankyou for your reply