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 <[email protected]>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 < > [email protected]> 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 < > > [email protected]> 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 < > > > [email protected]> 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 < > > >> [email protected]> 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 < > > >> > [email protected]> 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
