My favorites | Sign in
Project Home Issues
New issue   Search
for
  Advanced search   Search tips   Subscriptions
Issue 914: Download and synchronize
1 person starred this issue and may be notified of changes. Back to list
Status:  Done
Owner:  ----
Closed:  Apr 2011


Sign in to add a comment
 
Reported by nchekwub...@gmail.com, Apr 16, 2011
I would like to download my fullcalendar in excel/word/pdf format... Also I would like to be able to export/synchronize it with gcal. Is this possible? If yes, how? 

Additional info:
developing with asp.net mvc 2
Apr 18, 2011
#1 p.stud...@gmail.com
It is possible.
For google:
I have done this using iCals.

Imports DDay  
Imports DDay.iCal <-- Google this and you will get the DLL you need to use it in VS

Function makeICalendar(ByVal _dataTable As DataTable) As iCalendar
        Dim _myCal As New iCalendar
        _myCal.ProductID = "-//YOUCAL NAME//VERSOPM 1.0//EN"
        _myCal.Scale = iCal.CalendarScales.Gregorian
        _myCal.Method = "PUBLISH"
        '_myCal.Properties

        For Each Item As DataRow In _dataTable.Rows
            Dim _event As DDay.iCal.Event = _myCal.Create(Of DDay.iCal.Event)()

            With _event
                .Summary = Item("title").ToString
                .Start = New DDay.iCal.iCalDateTime(DirectCast(Item("start"), Date))
                .End = New DDay.iCal.iCalDateTime(DirectCast(Item("start"), Date))
                .Status = iCal.EventStatus.Confirmed
                .Class = "PUBLIC"
                .Sequence = 1
            End With
        Next


        Return _myCal
    End Function

This is the most simple that takes a DataTable and turn it into a DDAY.ICAL object. With this object you can save as iCal file or seriliase this file into a JSON string or CSV i would have though.. just use the correct serializer.

But you can easily do it using XML streams too.
ANd you do not need to change much- jsut make sure the column names are those required for Google and do table.getXML()


To export to excel/word/pdf it will be similar structure but you have to find out what DLL or built in functions can give you the data you need.

To get the calendars current data/ month-day view.

.fullCalendar( 'clientEvents' [, idOrFilter ] ) -> Array

Send the returned array using AJAX to your ASP service to process the data and make the format you need.

You dont have to re-write allot of code- just search for plugins. The most difficult part is preparing the data ready for serialization to the document you need.

Apr 19, 2011
#2 eab...@gmail.com
is there a way to do it with PHP?
Apr 19, 2011
#3 nchekwub...@gmail.com
Well I'm guessing you could do the same thing. Check Ical library for php and then look for libraries to manipulate JSON, CSV, XML...etc... 
Apr 28, 2011
Project Member #4 althaus.it
This is not in the scope of FullCalendar as it's "only" the calendar frontend.
Status: Done
Sign in to add a comment

Powered by Google Project Hosting