Author Topic: RoundCube Calendar (jQuery Calendar)  (Read 56889 times)

Offline phireware

  • Full Member
  • ***
  • Posts: 77
RoundCube Calendar (jQuery Calendar)
« Reply #45 on: February 15, 2010, 03:23:11 PM »
I hope it's ok, but I have implemented this calendar in the MobileCube theme! Great job, love the plugin!

Offline touzeau

  • Newbie
  • *
  • Posts: 4
Group calendar and added in Artica
« Reply #46 on: February 17, 2010, 06:54:57 AM »
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

Offline bagu

  • Full Member
  • ***
  • Posts: 109
    • Bagu.biz
RoundCube Calendar (jQuery Calendar)
« Reply #47 on: February 17, 2010, 07:07:03 AM »
Here is the french translation for 2 beta 2 :

Code: [Select]
<?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]
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`)

)
« Last Edit: February 17, 2010, 07:09:46 AM by bagu »

Offline Lazlo

  • Full Member
  • ***
  • Posts: 50
RoundCube Calendar (jQuery Calendar)
« Reply #48 on: February 17, 2010, 10:18:52 AM »
Thank you, added the translation to the latest development version (LazloNL's roundcube-calendar at master - GitHub).

Offline sh0x

  • Newbie
  • *
  • Posts: 2
Server Error (OK!) still
« Reply #49 on: February 18, 2010, 02:06:44 AM »
Quote from: rosali;25337

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",

Offline lacri

  • Full Member
  • ***
  • Posts: 179
    • http://www.php-lexikon.de
RoundCube Calendar (jQuery Calendar)
« Reply #50 on: February 18, 2010, 05:02:45 AM »
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

Offline Sypher

  • Newbie
  • *
  • Posts: 1
RoundCube Calendar (jQuery Calendar)
« Reply #51 on: February 22, 2010, 09:40:07 AM »
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.
« Last Edit: February 22, 2010, 09:52:40 AM by Sypher »

Offline katie

  • Newbie
  • *
  • Posts: 5
Postgres
« Reply #52 on: February 25, 2010, 09:03:24 PM »
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]

-- 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,
    &quot;start&quot; timestamp without time zone DEFAULT now() NOT NULL,
    &quot;end&quot; timestamp without time zone DEFAULT now() NOT NULL,
    &quot;summary&quot; character varying(255) NOT NULL,
    &quot;description&quot; text NOT NULL,
    &quot;location&quot; character varying(255) NOT NULL,
    &quot;categories&quot; character varying(255) NOT NULL,
    &quot;all_day&quot; 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.

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
RoundCube Calendar (jQuery Calendar)
« Reply #53 on: February 26, 2010, 03:38:00 AM »
Did you configure ./config/config.inc.php ? It looks like you run the "dummy" driver instead of the database driver.
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline katie

  • Newbie
  • *
  • Posts: 5
RoundCube Calendar (jQuery Calendar)
« Reply #54 on: February 26, 2010, 04:15:15 PM »
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]
$rcmail_config['use_calendar'] = 'calendar';
$rcmail_config['db_table_events'] = 'webmail_events';

Did I miss something?
:confused:

K.
« Last Edit: February 26, 2010, 04:16:20 PM by katie »

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
RoundCube Calendar (jQuery Calendar)
« Reply #55 on: February 28, 2010, 12:21:08 AM »
It does not support customizable table names (yet).
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline katie

  • Newbie
  • *
  • Posts: 5
RoundCube Calendar (jQuery Calendar)
« Reply #56 on: February 28, 2010, 08:37:13 PM »
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.

Offline roe1234

  • Jr. Member
  • **
  • Posts: 20
davical
« Reply #57 on: March 02, 2010, 06:14:32 PM »
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.

Offline gznadroj

  • Newbie
  • *
  • Posts: 2
RoundCube Calendar (jQuery Calendar)
« Reply #58 on: March 06, 2010, 05:39:19 PM »
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 :p

typos.. gotta love them
« Last Edit: March 06, 2010, 05:47:59 PM by gznadroj »

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
RoundCube Calendar (jQuery Calendar)
« Reply #59 on: March 07, 2010, 02:46:27 AM »
Regards,
Rosali
__________________
MyRoundcube Project (commercial)