Author Topic: calendar with invitation option (Read 22012 times)

madal · « **on:** January 11, 2011, 11:45:51 AM »

just finished with calendar with roundcube. it looks nice and thanks for your all input. Anyway, is there a pluginn or feature , when i create the event send invitation to users ?

Also, is is possible to share your calendar with others ?

Thanks in advance!!

MAdal

rosali · « **Reply #1 on:** January 11, 2011, 01:47:22 PM »

#1- Click on event -> Tab Export -> Send Invitation

#2- Settings -> Calendar Feeds ... Enable tokens and pass the URL to share it.

madal · « **Reply #2 on:** January 11, 2011, 02:05:31 PM »

Thanks, i should have looked better on those options. it works indeed. By the way, I have made changes to $rcmail_config['backend'] = "database"; in config.inc.php with in calendar pluginn however whenever i click onto calendar on roundcube mail it shows in address bar as this :

http://localhost/?_task=dummy&_action=plugin.calendar

it should be username&_action=plugin.calendar. I tried with changing in calendar.php dummy with database it is not helping. Sorry my php skillset is very starter.

M

rosali · « **Reply #3 on:** January 11, 2011, 10:33:24 PM »

No, do not change anything there. 'dummy' in the URL is a Roundcube plugin task besides the main tasks login|logout|mail|addressbook|settings.

madal · « **Reply #4 on:** January 12, 2011, 03:30:49 AM »

Thanks - got your point. One final question. when logging with new user it comes with some google stuff in calendar feeds area. And, when I remove that and save it then I am no longer able to add any event i.e if i double click on the anywhere in clendar the popups do not come.

But if i add some calendar feed with my office ical link , then it allows to add/edit etc.

I guess there has to be one calendar feed ? am i right ? or how does it work or what is work around of this?

Thanks

M

rosali · « **Reply #5 on:** January 12, 2011, 11:25:08 AM »

This is a bug. It will be fixed in next release which is scheduled for this weekend.

rosali · « **Reply #6 on:** January 13, 2011, 11:55:11 PM »

Bugfix release is online.

madal · « **Reply #7 on:** January 14, 2011, 03:23:48 AM »

Thanks rosali, I just updated the calendar + jquery pluginn in my setup. So far so good. but i cannot delete /edit already in there i.e birthday etc etc

M

rosali · « **Reply #8 on:** January 14, 2011, 03:28:20 AM »

Did you update the database?

Anything in the logs?

Please keep in mind: It does not work, I can't do etc. is too less to track down issues.

madal · « **Reply #9 on:** January 14, 2011, 03:43:58 AM »

yes I did update the database with mysqldump -uroundcube -p roundcubemail
Does mysql update has to be done before i start logigin to roundcube ? well, that probably not. it should be okay to update after login etc.

Any hint ?

M

rosali · « **Reply #10 on:** January 14, 2011, 03:52:45 AM »

I assume your mysql update failed. It is not an update script. It builds the table from scratch.

Use phpmyadmin and just add column 'client' type text default null to events table.

madal · « **Reply #11 on:** January 14, 2011, 04:43:59 AM »

Okay I will do that but looking into new update calendar, mysql.sql file i do not see the client option there or this has not been updated

CREATE TABLE `events` (
`event_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`uid` text,
`recurrence_id` text,
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`start` int(10) unsigned NOT NULL DEFAULT '0',
`end` int(10) unsigned NOT NULL DEFAULT '0',
`expires` int(10) unsigned NOT NULL DEFAULT '0',
`rr` varchar(1) default NULL,
`recurring` text NOT NULL,
`occurrences` int(11) DEFAULT '0',
`byday` text,
`bymonth` text,
`bymonthday` text,
`summary` varchar(255) NOT NULL,
`description` text NOT NULL,
`location` varchar(255) NOT NULL DEFAULT '',
`categories` varchar(255) NOT NULL DEFAULT '',
`all_day` tinyint(1) NOT NULL DEFAULT '0',
`group` text,
`timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`del` int(1) NOT NULL DEFAULT '0',
`notified` int(1) NOT NULL default '0',
PRIMARY KEY (`event_id`),
CONSTRAINT `user_id_fk_events` FOREIGN KEY (`user_id`)
REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=INNODB CHARACTER SET utf8 COLLATE utf8_general_ci

M

rosali · « **Reply #12 on:** January 14, 2011, 04:57:59 AM »

As said ... add the column manually or create events table from scratch. Nothing more to say at this point ...

madal · « **Reply #13 on:** January 14, 2011, 05:17:19 AM »

okay i created the colum as you mentioned and cannot save any event it does not write into database.

Here is what I idid.

1. downloaded the new trunk from trunk-r-4408.zip - myroundcube - MyRoundCube Plugins Collection (RC SVN r4408) 2011-01-14 05:50 a.m. - Project Hosting on Google Code
2. extracted -- renamed my old calendar and jqueryui or calendar_old and jqueryui_old
3. copied new calendar and jquery from newly extracted directory to /roundcube/plugin
4. cp config.inc.php.dist config.inc.php for both calendar and jqueryui
5. created client coulm manually as you mentioned.
6. restarted apache.

Isssues:
1. Can feed the other ical but cannot save any new event, i.e not writing into database.
2. when i remove the default calendar feed it saves but those event still exists.
3. calendar logs says nothing.

Now, am i missing something else or doing wrong? next step for me would be re-create event tables again, am not sure that will help.

M

rosali · « **Reply #14 on:** January 14, 2011, 05:24:44 AM »

What is in errors log?

Could you give me remote access (IMAP test account, FTP to Roundcube root, PHPMyAdmin)?