Forum OpenACS Q&A: Re: Calendar: how to add public events?

Collapse
Posted by Claudio Pasolini on
The calendar admin UI is quite obscure, but it works.
Try calendar/admin and visit 'Create a new calendar'. You can then define your new calendar as public or private and then visit 'Manage Calendar Audience' to assign permissions to groups or individuals.
You can create any number of calendars and get a nice shared view of the events you have the permissions to view.
Collapse
Posted by Tom Lazar on
claudio,

thanks for that: I just found the admin page with your help! there is no link to it, but when i manually enter the url

/calendar/admin/

i actually get an admin page, wow 😉

of course, this was *after* i manually converted one of the Personal calendars to public...

anyway, now i got the setup i wanted: everybody has a private calendar and can post to the public one.

one thing, though: when i click onto 'edit your calendar preferences' i get the following error:

Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.")

ERROR:  Attribute 'party_id' not found

SQL:


        select  distinct(o.object_id) as calendar_id,
                calendar__name(o.object_id) as calendar_name,
                calendar__show_p(o.object_id, '292') as show_p
        from    acs_objects o
        where    calendar__readable_p(o.object_id, '292') = 't'
        and      party_id = '292'
        and      acs_object_util__object_type_p(o.object_id, 'calendar') = 't'
        and      calendar__private_p(o.object_id) = 'f'

        union

        select  cal_item__on_which_calendar(o.object_id) as calendar_id,
                calendar__name(cal_item__on_which_calendar(o.object_id)) as calendar_name,
                calendar__show_p(cal_item__on_which_calendar(o.object_id), '292') as show_p
        from    acs_objects o
        where    privilege = 'cal_item_read'
        and      party_id = '292'
        and      acs_object_util__object_type_p(o.object_id, 'cal_item') = 't'
        and      calendar__private_p(cal_item__on_which_calendar(o.object_id)) = 'f'

any ideas?

Collapse
Posted by Dis Continued on
Hi Tom -- did you ever find a solution for this? I have just run in to the same problem. Thanks. Michael
Collapse
Posted by Dis Continued on
The database operation error
Collapse
Posted by Dirk Gomez on
Michael, file a bug in bug-tracker. I'll fix this at some point.