So basically I have to wrap the tables relevant to events in the database with an API that support iCal format?
On Mon, Mar 10, 2014 at 10:10 AM, Maxim Solodovnik <[email protected]>wrote: > It is not clear why do you need to change tables. > I believe you can create methods to send/receive current events as iCal > events, and change data structure only if it is necessary > > > On Sun, Mar 9, 2014 at 7:47 PM, Maduranga Siriwardena < > [email protected]> wrote: > > > Hi, > > While going through the caldav specifications I understood that data > > exchange in the protocol in done using iCalender format. So it is really > > necessary to accommodate iCalender format in the project if we are going > to > > support caldav protocol. But working with two data formats for calender > > events would e really painful. So it is really good if we can change the > > current data model to support iCalender data format. > > > > So the first question I had was whether I have to change the data model > of > > the project (regarding the appointments table and other tables relevant > the > > event data in the project) so that it can store the iCalender objects in > > the database. Unless I am not going to change the datamodel, I have to > map > > the current columns in the data tables to the matching fields in the > > iCalender objects (which would not be practical sometimes. But with this > > method, adding the functionality of recurrence events support wont take > > much effort as the the we can easily store recurrence details in the > > current appointments table). > > > > Somehow the first part of the project would be to convert the existing > > calender events format to iCalender format. After doing that I have start > > working with adding the missing iCalender and caldav functionality to the > > project. > > > > Please correct me if I am wrong. > > > > Thank you > > > > > > On Wed, Mar 5, 2014 at 9:38 AM, Vasiliy Degtyarev <[email protected]> > wrote: > > > > > Hello, > > > > > > The main events table is appointments. > > > > > > Vasiliy > > > > > > > > > On 05.03.2014 11:00, Maduranga Siriwardena wrote: > > > > > >> Hi, > > >> So regarding the iCal support, I have to extend the functionality of > the > > >> calender events including ability to create recurrence events, > > exceptions > > >> in the recurrences etc. > > >> And then I can use a library like caldav4j and map the events created > by > > >> the library to the existing events structure of the project. If it is > so > > >> can I know more about the event structure of the project? It will be > > >> really > > >> helpful for me to proceed if I can get a good understanding about the > > >> existing structure of events. > > >> > > >> > > >> Regards. > > >> > > >> > > >> On Wed, Mar 5, 2014 at 9:02 AM, Irina Arkhipets > > >> <[email protected]>wrote: > > >> > > >> Hi Madhuranga, > > >>> > > >>> On Tue, Mar 4, 2014 at 11:55 PM, Maduranga Siriwardena < > > >>> [email protected]> wrote: > > >>> > > >>> As I have understood, what I need to do is provide an API to import > > and > > >>>> export calender events to the openmeetings from outside client. And > > also > > >>>> add some method to work with the caldav calender events in the > > >>>> > > >>> openmeetings > > >>> > > >>>> system (That means functionality like create, view, edit, delete > etc. > > of > > >>>> the calender events). > > >>>> > > >>>> Actually, such a functionality is already implemented in > > OpenMeetings, > > >>> but > > >>> for the single events only. > > >>> ICal specification is wider and allows create recurrence events, > > >>> exceptions > > >>> in the recurrences, different type of guests and reminders, etc. > > >>> > > >>> > > >>> > > >>> While studying about the Caldav protocol I came across a library > > >>>> implementation of the protocol [1]. I'm not sure whether this can be > > >>>> used > > >>>> in the project as I am still studying about the openmeetings code > > base. > > >>>> > > >>> If > > >>> > > >>>> I use this library (or any other suitable library) to get the caldav > > >>>> protocol support, the work needed to do will be really eased. > > >>>> > > >>>> Yes, most of Java caldav servers use caldav4j. > > >>> The problem is to map existing events structure to this. > > >>> > > >>> > > >>> [1] https://code.google.com/p/caldav4j/ > > >>>> > > >>>> Thank you. > > >>>> > > >>>> > > >>>> On Mon, Mar 3, 2014 at 1:35 PM, Irina Arkhipets > > >>>> <[email protected]>wrote: > > >>>> > > >>>> Also a good point to start would be trying existing Caldav server > > >>>>> implementation. For example, take a look here: > > >>>>> http://caldav.calconnect.org/implementations/servers.html > > >>>>> > > >>>>> > > >>>>> Best regards, > > >>>>> Irina > > >>>>> > > >>>>> > > >>>>> On Mon, Mar 3, 2014 at 11:58 AM, Maduranga Siriwardena < > > >>>>> [email protected]> wrote: > > >>>>> > > >>>>> Thank you for the ideas. > > >>>>>> > > >>>>>> I'll go through the details about recurring events and CalDav > > >>>>>> > > >>>>> protocol. I > > >>>> > > >>>>> have some doubts about the CalDav protocol support. I may need some > > >>>>>> > > >>>>> more > > >>>> > > >>>>> details about this idea. > > >>>>>> > > >>>>>> Thank you. > > >>>>>> > > >>>>>> > > >>>>>> On Mon, Mar 3, 2014 at 9:41 AM, Irina Arkhipets > > >>>>>> <[email protected]>wrote: > > >>>>>> > > >>>>>> Hi Maduranga, > > >>>>>>> > > >>>>>>> Here are a few words about the possible works: > > >>>>>>> > > >>>>>>> OpenMeetings now has its own calendar which now supports simple > > >>>>>>> > > >>>>>> single > > >>>> > > >>>>> events only. > > >>>>>>> As a quick start you can register on > > >>>>>>> > > >>>>>> demo.dataved.ru/openmeetingsand > > >>> > > >>>> try > > >>>>>> > > >>>>>>> this: just select Home-> Calendar to enter the calendar and > check. > > >>>>>>> > > >>>>>>> Eexport of the existing events using iCal generally is a simple > > >>>>>>> > > >>>>>> task > > >>> > > >>>> and > > >>>>> > > >>>>>> I > > >>>>>> > > >>>>>>> don't think it requires significant time. > > >>>>>>> > > >>>>>>> More interesting things which can be dona are: > > >>>>>>> - Recurring event support according to iCal spec. > > >>>>>>> - I don't know exactly is currently all OK with the time zone or > > >>>>>>> > > >>>>>> not, > > >>> > > >>>> maybe > > >>>>>> > > >>>>>>> some improvemebts can be done > > >>>>>>> - CalDav protocol support. In my vision, it should be a separate > > >>>>>>> > > >>>>>> caldav > > >>>> > > >>>>> servlet which works on the same tomcat as OpenMeetings itself. If > > >>>>>>> > > >>>>>> we > > >>> > > >>>> implement this, users can sync with the OpenMeeting events via > > >>>>>>> > > >>>>>> standard > > >>>> > > >>>>> calendar clients like MS Outlook or Mozilla Thunderbird and. for > > >>>>>>> > > >>>>>> example, > > >>>>> > > >>>>>> create appointments in the real time. In my point of view it's the > > >>>>>>> > > >>>>>> most > > >>>> > > >>>>> difficult and interesting task, and definitelly it takes a lot of > > >>>>>>> > > >>>>>> efforts. > > >>>>>> > > >>>>>>> Best regards, > > >>>>>>> Irina > > >>>>>>> > > >>>>>>> > > >>>>>>> > > >>>>>>> On Thu, Feb 27, 2014 at 11:12 PM, Maduranga Siriwardena < > > >>>>>>> [email protected]> wrote: > > >>>>>>> > > >>>>>>> Hi all, > > >>>>>>>> > > >>>>>>>> I'm a third year Computer Science and Engineering undergraduate > > >>>>>>>> > > >>>>>>> of > > >>> > > >>>> University of Moratuwa. Currently I'm in my internship at WSO2. > > >>>>>>>> This year I'm planing to participate in Google Summer of Code > and > > >>>>>>>> > > >>>>>>> I'm > > >>>> > > >>>>> very > > >>>>>>> > > >>>>>>>> much interested in the project idea "Need to have possibility to > > >>>>>>>> import/export sync events from OpenMeetings calender using iCal > > >>>>>>>> > > >>>>>>> or > > >>> > > >>>> caldav > > >>>>>> > > >>>>>>> protocol" [1]. As I have worked with the iCal format, I think it > > >>>>>>>> > > >>>>>>> will > > >>>> > > >>>>> be > > >>>>>> > > >>>>>>> a > > >>>>>>> > > >>>>>>>> advantage for me. So to start with the project I need to have > > >>>>>>>> > > >>>>>>> more > > >>> > > >>>> details > > >>>>>>> > > >>>>>>>> about the project. > > >>>>>>>> Can someone please explain the requirements of the project in > > >>>>>>>> > > >>>>>>> detail? > > >>>> > > >>>>> > > >>>>>>>> [1] https://issues.apache.org/jira/browse/OPENMEETINGS-553 > > >>>>>>>> > > >>>>>>>> > > >>>>>>>> Thank you > > >>>>>>>> -- > > >>>>>>>> Maduranga Siriwardena > > >>>>>>>> Undergraduate > > >>>>>>>> University of Moratuwa, Faculty of Engineering > > >>>>>>>> Department of Computer Science and Engineering > > >>>>>>>> > > >>>>>>>> > > >>>>>> > > >>>>>> -- > > >>>>>> Maduranga Siriwardena > > >>>>>> Undergraduate > > >>>>>> University of Moratuwa, Faculty of Engineering > > >>>>>> Department of Computer Science and Engineering > > >>>>>> > > >>>>>> > > >>>> > > >>>> -- > > >>>> Maduranga Siriwardena > > >>>> Undergraduate > > >>>> University of Moratuwa, Faculty of Engineering > > >>>> Department of Computer Science and Engineering > > >>>> > > >>>> > > >> > > >> > > > > > > > > > -- > > Maduranga Siriwardena > > Undergraduate > > University of Moratuwa, Faculty of Engineering > > Department of Computer Science and Engineering > > > > > > -- > WBR > Maxim aka solomax > -- Maduranga Siriwardena Undergraduate University of Moratuwa, Faculty of Engineering Department of Computer Science and Engineering
