RoundCube Calendar (jQuery Calendar)

[phireware]

I hope it's ok, but I have implemented this calendar in the MobileCube theme! Great job, love the plugin!

[touzeau]

I have added your project in my open source project
Add a calendar in the RoundCube Webmail System | Artica Official web site | web based administration interface

It will be very cool if you plan to provide a group/shared calendar

[bagu]

Here is the french translation for 2 beta 2 :

Code Select Expand

<?php
/**
 * RoundCube Calendar
 *
 * Plugin to add a calendar to RoundCube.
 *
 * @version 0.2 BETA 2
 * @author Lazlo Westerhof
 * @url http://rc-calendar.lazlo.me
 * @licence GNU GPL
 * @copyright (c) 2010 Lazlo Westerhof - Netherlands
 *
 **/

$labels = array();

// config
$labels['default_view'] = 'Vue par défaut';
$labels['time_format'] = 'Format de l\'heure';
$labels['timeslots'] = 'Intervalle de temps par heure';
$labels['first_day'] = 'Premier jour de la semaine';

// calendar
$labels['calendar'] = 'Calendrier';
$labels['day'] = 'Jour';
$labels['week'] = 'Semaine';
$labels['month'] = 'Mois';
$labels['new_event'] = 'Nouvel évènement';
$labels['edit_event'] = 'Editer l\'évènement';
$labels['save'] = 'Enregistrer';
$labels['remove'] = 'Supprimer';
$labels['cancel'] = 'Annuler';
$labels['summary'] = 'Sommaire';
$labels['description'] = 'Description';
$labels['all-day'] = 'Toute la journée';
$labels['export'] = 'Exporter en format ICS';
$labels['category'] = 'Categorie';

?>
With mysql 5.1.34, i must use this mysql.sql file :

Code Select Expand

CREATE TABLE `events` (
  `event_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `start` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `end` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `summary` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `category` varchar(255) NOT NULL DEFAULT '',
  `all_day` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY(`event_id`),
  CONSTRAINT `user_id_fk_events` FOREIGN KEY (`user_id`)
    REFERENCES `users`(`user_id`)

)

[Lazlo]

Thank you, added the translation to the latest development version (LazloNL's roundcube-calendar at master - GitHub).

[sh0x]

It never loads events. It does not even see calendar.php::getEvents. I get Error message "Server Error! (OK)". Nothing in the logs. It is not a browser issue (both IE/FF).

Events are created successfully in the database. It looks like the problem is anywhere in the javascript stuff.

I'm having this problem using roundcube 0.3.1 and latest calendar from git (.2 beta 2, but changelog shows beta 3). I dropped the events table and recreated it. I also see events being created in the database but when viewing the calendar in IE/FF I get "Server Error (OK!)". The earlier fix appears to be in calendar.js:

events: "./?_task=dummy&_action=plugin.getEvents",

[lacri]

Feature Request: vcalendar (vcal) support
add vcal events from email with vcal attachment or event to calendar

and add Birthdays from Adressbook with additional Fields and Birtday field to calendar.

i think vcal support is a cool feature or birtday fields in Addressbook and support from calendar for this

[Sypher]

Really nice addon!
This was most definitely a feature Roundcube was really missing.

I would like to request a feature to be able to plug-in the calendar in my Thunderbird (with Lightning) so I my calendar items are synced.

Also, it would be nice if you could make changes in the "desktop" calendar and seeing them changed in the webmail as well, so basicly synchronization. If this is not possible or falls outside your scope, downloading an ICS file from my server is possible so if the RC_Calendar supports it...
I've seen you've got Caldav on the todo list, but thats quite an overkill. DAViCal for instance requires postgresql.

After that, I calendar sharing would be pretty sweet too if this is possible. It'll make RC and the Calendar plugin more enterprise-ready.

[katie]

Hi Lazlo,

my RC runs on PostgreSQL, I was able to set up the Tables, but table-operations dont work.
Its running and I can see the demo-entries, but delete them or put new ones into the cal doesnt work, but shows no error either.

Is there a chance to get it working on PGSQL?

Here the init I used

Code Select Expand


-- PSQL Init for RC calender

CREATE SEQUENCE webmail_event_ids
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;

CREATE TABLE webmail_events (
    event_id integer DEFAULT nextval('webmail_event_ids'::regclass) NOT NULL,
    user_id integer NOT NULL,
    "start" timestamp without time zone DEFAULT now() NOT NULL,
    "end" timestamp without time zone DEFAULT now() NOT NULL,
    "summary" character varying(255) NOT NULL,
    "description" text NOT NULL,
    "location" character varying(255) NOT NULL,
    "categories" character varying(255) NOT NULL,
    "all_day" smallint NOT NULL DEFAULT 0
);

CREATE INDEX webmail_events_event_id_idx ON webmail_events USING btree (event_id);


--
-- Constraints Table `events`
--

ALTER TABLE ONLY webmail_events
    ADD CONSTRAINT webmail_events_user_id_fkey FOREIGN KEY (user_id) REFERENCES webmail_users(user_id) ON UPDATE CASCADE ON DELETE CASCADE;



--
K.

[rosali]

Did you configure ./config/config.inc.php ? It looks like you run the "dummy" driver instead of the database driver.

[katie]

An extra DB driver for calendar?

RC runs fine on my postgres, its using the same DB like my mailserver does (thats why I have the webmail_ -prefix) even the mailadresses according to an account are correct fetched at 1st login.

In calendear I set unlike default:

Code Select Expand

$rcmail_config['use_calendar'] = 'calendar';
$rcmail_config['db_table_events'] = 'webmail_events';

Did I miss something?
:confused:

K.

[rosali]

It does not support customizable table names (yet).

[katie]

Thanks.

I fixes that (renamed the table and the entry) - the other thing was that I didnt checked the new Calendar-Settings after loading the last version, mine were from initial setup.
0:)

After fixing both the dummy-entries are gone, but I cant save entries, it says in the RC-Errortab: Service unavailable

Mail still works.

[roe1234]

I see in trunk there is 'alpha' support for davical.  Let me know if you'd like some help banging on it with davical.  We have a small non-critical install of davical .9.8.3 that we can help test with.

[gznadroj]

I've downloaded this and moved it to the plugins folder, added it to the plugins in main.inc.php, ran the SQL.. but I'm not seeing the Calender anywhere?

Found it

typos.. gotta love them

[rosali]

Download from here: LazloNL's roundcube-calendar at master - GitHub