I searched this forum regarding this issue and found postings with same/similar issue starting from 2004, but with no satisfactory solution/workaround. That’s why, I thought of posting this issue one more time to get Notes gurus attention and possible help.
I have a calendar view that is supposed to show reservations made by users for specific equipment. Reservations could span into multiple days continuously (not repeats). I have created all required datetime fields to capture the start datetime and end datetime of the reservation. If the reservation is for few hours in a day, the calendar entry shows without any problem. But, if the reservation spans into multiple days, it shows duplicate/wrong entries. It shows the entries on the dates within the date range but also shows duplicate entries and entries within and beyond the date range too.
Ex:
Start Date: 05/27/2008
End Date: 05/28/2008
Calendar view shows one entry on 05/27/2008 and corresponding entry on 05/28/2008 (which is correct), but one more on 05/28/2008 and corresponding entry on 05/29/2008 too, which is not even within the date range!
I am using the mail template’s calendar view with required customization. All view/column settings and values are setup properly. One thing I noticed was, if we have the duration (second hidden) column that calculates the duration in minutes, it is showing these wrong/duplicate entries and if I remove this column, it doesn’t. But I need the duration column to show the span of reservation on the calendar day. I checked that TimeZone is also not the issue here.
I tried various combinations and options, but could not get it to work properly!
Any help in this regard is highly appreciated.
Thanks,
Subject: Calendar View showing duplicate/wrong entries for multiday reservations (R6.5.4)
I had done some reading (hadn’t sat down and done any partical work, so I didn’t reply to your earlier e-mail due to lack of experience) on calendar entries from my understanding if you wanted to have a booking over multiple days (repeat bookings) you were to have 1 parent docuemnt (with start and end date) and then multiple children documents one for each day.
It sounds like, you’ve setup one document which MAY (again I haven’t actually done this to be sure) be the cause of the problem. Check out:
Here are a couple links I have on this:
http://www-12.lotus.com/ldd/doc/uafiles.nsf/docs/WPNotesCSSchema/$File/csschema.pdf
http://www-12.lotus.com/ldd/doc/tools/c/6.5/api65ug.nsf/85255d56004d2bfd85255b1800631684/8a3a2d71b95e09bd85256559005ce7b3?OpenDocument
Subject: RE: Calendar View showing duplicate/wrong entries for multiday reservations (R6.5.4)
Stephen, Thank you for the response.
I am actually looking to schedule a reservation (or an appointment from calendar perspective) that can span into multiple days. Ex: The reservation can start from 05/28/2008 13:00 PM and end at 05/29/2008 17:00 PM. Thus, its a continuous 28 hrs reservation but not a repeat reservation.
To show this in the calendar, I used the explode function to find the individual dates between the start and end dates and showing those dates through hidden column showing multiple values as seperate entries. This setup is same as in the mail template’s Calendar view. All this works fine and the entries are spanning into multiple days but if I add the Duration hidden column (similar to mail template’s calendar view), it is showing duplicate entries and entries appearing on wrong dates.
Hope I explained it properly.
Thanks,