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 >
