Hi, So the main GUI change is that user must have a option to mark the event as the recurring event and add the recurring frequency and recurring exceptions when he is creating a event (with regard to recurring events). So regarding showing the events in the calender there should be no change as the user must see a recurring event also as a normal event that is happening according to the recurring frequency.
Thanks, Maduranga On Tue, Mar 18, 2014 at 9:15 AM, Irina Arkhipets <irina.arkhip...@gmail.com>wrote: > Hi again, > > Maybe there is some misunderstanding because of the terminology, please > sorry. I meant that GUI *AND* related internal application logic should be > changed. > > User should be able to create any recurring event he wants. And all these > events should be correctly shown in the calendar. > Database structure and application logic should be optimized for this. > There should be a way to quickly find a correct list of the user's events > for every particular day. > > Regards, > Irina > > > > On Tue, Mar 18, 2014 at 10:33 AM, Maduranga Siriwardena < > maduranga.siriward...@gmail.com> wrote: > > > Hi Irina, > > > > Okay got the point. First I thought of handling this use case with the > > application logic. But as it seems when the user gets lots of events, I > > will have to deal with the performance benchmarks. So what you are > > suggesting is to give the user a option to decide which events should be > > shown in the calender. Something like showing the list of recurring > events > > and then select and show that event in the calender. I hope what I > > understood is correct. So I'll make some wire-frames and attach them to > the > > proposal. > > > > Thanks > > Maduranga. > > > > > > On Tue, Mar 18, 2014 at 8:27 AM, Irina Arkhipets > > <irina.arkhip...@gmail.com>wrote: > > > > > Hi Maduranga, > > > > > > Say, staying in the today's slot (March, 18) OM user created two > > recurring > > > events started now: one endless monthly (occurs each month on the 18th > > day) > > > and one daily with the December,31 until date and with several > exceptions > > > (occurs every day but the March, 28 and May, 15). Then user goes to > > another > > > week in your calendar, say, May,18. And after this he moves to the > > > April,28. Then to the January,1, the next year. > > > > > > How are you going to detect on which days user's meetings slots should > be > > > shown and on which should not? > > > If (for example) you store recurrence rules in the appointments table, > > > which SQL clause are you going to use for this? > > > > > > Regards, > > > Irina > > > > > > > > > On Mon, Mar 17, 2014 at 11:31 PM, Maduranga Siriwardena < > > > maduranga.siriward...@gmail.com> wrote: > > > > > > > Its bit unclear about the things you have mentioned about the UI > > changes. > > > > As I can understand the UI changes needed are minimal. As an example > > when > > > > creating and new event, user must get an option to declare it as a > > > > recurring event and the recurring frequency. I can't think of big > > changes > > > > needed to the UI. As I can feel, the events shown in the calendar > need > > > not > > > > to be changed. Please correct me if I'm wrong. > > > > > > > > Thank you. > > > > > > > > > > > > On Mon, Mar 17, 2014 at 9:30 PM, Maduranga Siriwardena < > > > > maduranga.siriward...@gmail.com> wrote: > > > > > > > > > Thank you for the reply. I'll do the necessary changes to the > > proposal > > > > and > > > > > inform you when I'm finished. > > > > > > > > > > Regarding libraries I have included, I have worked with library > > > biweekly > > > > > used for iCal object parsing. And it seems to be the library I have > > > > > mentioned for CalDav must be changed as it gives full version only > in > > > the > > > > > paid version. > > > > > > > > > > Thank you > > > > > > > > > > > > > > > On Mon, Mar 17, 2014 at 5:46 PM, Irina Arkhipets < > > > > > irina.arkhip...@gmail.com> wrote: > > > > > > > > > >> Hi Maduranga, > > > > >> > > > > >> Sure, you need to add several columns to the appointments table > and > > > > create > > > > >> some additional tables to cover the ical spec.I believe it's > > > impossible > > > > to > > > > >> make all working using existing database structure. > > > > >> > > > > >> One more thing which I suppose you have missed are GUI changes. > How > > > are > > > > >> you > > > > >> going to detect which events should be shown on the particular > > > > >> day/week/month? I.e. if user goes to some day in the calendar - > > which > > > > >> events should be shown there? > > > > >> > > > > >> Regarding the used librarues - I used ical4j and caldav4j in one > of > > my > > > > >> projects, and have not got experience with the ones from your > > > proposal. > > > > >> > > > > >> Best regards, > > > > >> Irina > > > > >> > > > > >> > > > > >> > > > > >> On Mon, Mar 17, 2014 at 6:40 PM, Maduranga Siriwardena < > > > > >> maduranga.siriward...@gmail.com> wrote: > > > > >> > > > > >> > Hi all, > > > > >> > Though I created a draft project proposal, I have little bit of > a > > > > >> concern > > > > >> > regarding the storage of iCal objects. Current appointments > table > > > have > > > > >> the > > > > >> > columns to store the general properties of the iCal objects. But > > the > > > > >> iCal > > > > >> > spec describes lot more properties for the iCal objects. So the > > > > current > > > > >> > appointments table may not be enough to hold all the data. In > that > > > > case > > > > >> > what should I do? Is it okay to add more columns to appointments > > > table > > > > >> or > > > > >> > create more tables as necessary? > > > > >> > Some possible mappings between the iCal object properties and > > > > >> appointments > > > > >> > column tables are mentioned in my project proposal sent in the > > > > previous > > > > >> > mail. But there also I have faced so problems regarding mapping > > the > > > > two > > > > >> > parties. > > > > >> > Please help me > > > > >> > > > > > >> > Thank you. > > > > >> > > > > > >> > > > > > >> > On Sun, Mar 16, 2014 at 8:30 PM, Maduranga Siriwardena < > > > > >> > maduranga.siriward...@gmail.com> wrote: > > > > >> > > > > > >> > > Hi all, > > > > >> > > I have written a draft proposal for the project. Please go > > through > > > > it > > > > >> and > > > > >> > > suggest any possible improvements. Bellow here is the google > > doc I > > > > >> have > > > > >> > > created. > > > > >> > > > > > > >> > > > > > > >> > > > > > > >> > > > > > >> > > > > > > > > > > https://docs.google.com/document/d/1zvz768aEwc-5K7YMXJF7AIeVYF_DqDHzDvU2l0e4EJ0/edit?usp=sharing > > > > >> > > > > > > >> > > 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 > > > > > > > > > > > > > > > -- > > 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