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 < maduranga.siriward...@gmail.com> 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 <va...@unipro.ru> 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 > >> <irina.arkhip...@gmail.com>wrote: > >> > >> Hi Madhuranga, > >>> > >>> On Tue, Mar 4, 2014 at 11:55 PM, Maduranga Siriwardena < > >>> maduranga.siriward...@gmail.com> 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 > >>>> <irina.arkhip...@gmail.com>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 < > >>>>> maduranga.siriward...@gmail.com> 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 > >>>>>> <irina.arkhip...@gmail.com>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 < > >>>>>>> maduranga.siriward...@gmail.com> 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