Roundcube Community Forum

Third Party Contributions => API Based Plugins => Topic started by: Lazlo on February 08, 2010, 08:42:23 AM

Title: RoundCube Calendar (jQuery Calendar)
Post by: Lazlo on February 08, 2010, 08:42:23 AM
@Translators, I've attached the localizations file for the next release 0.2 BETA.
You can mail translations to me or attach them to a post. (I already have complete English, Dutch and Russian translations.

@Everyone, 0.2 BETA has a full calendar (day, week and month view) and support for custom backends. Currently there only is a database backend. But someone is working on a davical backend and a Google Calendar API backend can be written very simply now.
Title: RoundCube Calendar (jQuery Calendar)
Post by: bagu on February 08, 2010, 11:59:47 AM
Here is french translation
Title: RoundCube Calendar (jQuery Calendar)
Post by: Lazlo on February 08, 2010, 12:14:06 PM
Thanks you, added it to the 0.2 BETA trunk.
Title: RoundCube Calendar (jQuery Calendar)
Post by: Lazlo on February 08, 2010, 06:45:56 PM
I've just released 0.2 BETA: RoundCube Calendar (http://rc-calendar.lazlo.me/)
Biggest changes are the full calendar (complete JS rewrite) and the support for custom backends.
Only a database backend is provided. The Google backend is not functional yet, it's only a start/example.
ICal export function will be completed next BETA/Release Candidate.
Title: RoundCube Calendar (jQuery Calendar)
Post by: mmaraghy on February 08, 2010, 07:45:53 PM
Beta 0.2 uploaded and working great. Love the implementation of fullcalendar with the ability to switch between day/week/month view. Works smooth and fast. I will be keeping a close eye on this one and eagerly waiting further development and more features.

NOTE: previous calendar plugin folder should be deleted from the server before uploading the new version. not all of the old files are overwritten if you just try to replace the previous version and everything gets all messed up.
Title: RoundCube Calendar (jQuery Calendar)
Post by: xrxca on February 09, 2010, 12:53:16 AM
Quote from: Lazlo;25329
I've just released 0.2 BETA:

What version of roundcube is required for this?
 
ie: do I need the latest from svn. I tried this under 0.3.1-20091031 and with Firefox and Prism I can go to the calendar and everthing seems to work OK, but none of the other toolbar buttons are working (ie: I can't get out of the calendar once I get in)
Correction they are working, but have just been disabled until a Request timed out message comes up.
And under IE (7 I think, I never use it except for page testing) I get an error message Line: 51 Error: Expected identifier, string or number

I disabled all the plugins except calendar as a test and get the same result.

I also got a File does not exist: ...mail/plugins/calendar/program/js/tooltip.js in my server log (commenting out the toolbar.js include_script line cleared that up)

Additionally I'm getting a bunch of "File does not exist: /var/www/webmail/plugins/calendar/skins/default/css/images, referer: https://...." in the error log.
These seem to show up when the event edit box comes up.
Title: RoundCube Calendar (jQuery Calendar)
Post by: rosali on February 09, 2010, 01:34:28 AM
It does not work for me. I have created the database table 'events' by the included script and disabled all other plugins.

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.
Title: RoundCube Calendar (jQuery Calendar)
Post by: Lazlo on February 09, 2010, 03:07:54 AM
Quote from: xrxca;25336
What version of roundcube is required for this?
 
ie: do I need the latest from svn. I tried this under 0.3.1-20091031 and with Firefox and Prism I can go to the calendar and everthing seems to work OK, but none of the other toolbar buttons are working (ie: I can't get out of the calendar once I get in)
Correction they are working, but have just been disabled until a Request timed out message comes up.
And under IE (7 I think, I never use it except for page testing) I get an error message Line: 51 Error: Expected identifier, string or number

I disabled all the plugins except calendar as a test and get the same result.

I also got a File does not exist: ...mail/plugins/calendar/program/js/tooltip.js in my server log (commenting out the toolbar.js include_script line cleared that up)

Additionally I'm getting a bunch of "File does not exist: /var/www/webmail/plugins/calendar/skins/default/css/images, referer: https://...." in the error log.
These seem to show up when the event edit box comes up.


I've only tested with the latest trunk. But 0.3.1 should work too.

Fixed the tooltip.js, old dev stuff.

Working on the missing images, they aren't used but still included by the jQuery UI css.
Title: RoundCube Calendar (jQuery Calendar)
Post by: Lazlo on February 09, 2010, 03:16:51 AM
Quote from: rosali;25337
It does not work for me. I have created the database table 'events' by the included script and disabled all other plugins.

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.


Are you sure you have overwritten all old files? Does it give any JS errors?
Title: RoundCube Calendar (jQuery Calendar)
Post by: SKaero on February 09, 2010, 03:30:10 AM
Quote from: Lazlo;25340
I've only tested with the latest trunk. But 0.3.1 should work too.
The latest trunk is using jQuery 1.4 RoundCobe 0.3.1 use jQuery 1.3
Title: RoundCube Calendar (jQuery Calendar)
Post by: Lazlo on February 09, 2010, 03:33:43 AM
That should be no problem.
Title: RoundCube Calendar (jQuery Calendar)
Post by: lacri on February 09, 2010, 03:37:31 AM
Wowwww respect Lazlo great work this calender is perfekt great design perfect look and feel nice features i love this.

Many thanks this calendar wonderfull
Title: RoundCube Calendar (jQuery Calendar)
Post by: rosali on February 09, 2010, 04:55:09 AM
Lazlo,

yes, I copied it into a new folder but I did not empty the browser cache. I'll see today evening on my home test environment if the problems still persists.

I have it uploaded now on my VPS and it works. A difference between my VPS and my home server is that RC does not run in a root folder there. Everything else is the same. I'll see ...

Two urgent IE7 fixes:

#1-calendar.js:

Code: [Select]

    buttonText: {
      today: response.settings['today'],
      day: rcmail.gettext('day', 'calendar'),
      week: rcmail.gettext('week', 'calendar'),
      month: rcmail.gettext('month', 'calendar'),
    },


replace with:
Code: [Select]

    buttonText: {
      today: response.settings['today'],
      day: rcmail.gettext('day', 'calendar'),
      week: rcmail.gettext('week', 'calendar'),
      month: rcmail.gettext('month', 'calendar')
    },


IE7 does not like the "," before the closing "}". It breaks the whole application.

#2 - IE7 does not render css margin-top correct. A workaround is to add a tag in the skin template ...




 

Title: RoundCube Calendar (jQuery Calendar)
Post by: lacri on February 09, 2010, 05:00:15 AM
with my svn copy i have the same problem ... i have change jquery to 1.3 and the request work the issue is debug with firebug the request via GET plugin.getEvents dont work the response is not a JSON response the response is formated as HTML
Title: RoundCube Calendar (jQuery Calendar)
Post by: Lazlo on February 09, 2010, 05:11:01 AM
I fixed the "," problem for IE7 and some other small fixes.

Also updated in 0.2 BETA package.
Title: RoundCube Calendar (jQuery Calendar)
Post by: rosali on February 09, 2010, 05:11:55 AM
@Lazlo:
There is another problem we have to work out. If the Client and the webserver are not within the same timezone the events on the client are out of sync with the database. I included already a solution in previous weekcalendar: Save events in database always GMT and return to client converted by Roundcube's timezone settings.

@lacri:
Please PM'me (deutsch). I don't understand your last Post. You are saying you have the same problems as I experience on my home environment?
Title: RoundCube Calendar (jQuery Calendar)
Post by: Lazlo on February 09, 2010, 05:17:08 AM
@rosali
I've seen the changes you made in the previous version. I will port them to 0.2 BETA.
Title: RoundCube Calendar (jQuery Calendar)
Post by: lacri on February 09, 2010, 05:47:27 AM
i have found the bug ;)

in calendar.js on line 34

search
events: "/?_action=plugin.getEvents",

replace with
events: "./?_action=plugin.getEvents",

a simple point with large effect
Title: RoundCube Calendar (jQuery Calendar)
Post by: rosali on February 09, 2010, 05:53:49 AM
Ahh ok ...

Then I was right with my assumption:
Quote

A difference between my VPS and my home server is that RC does not run in a root folder there.
Title: RoundCube Calendar (jQuery Calendar)
Post by: lacri on February 09, 2010, 06:32:50 AM
to change color of weekend
add to fullcalendar.css


.fc-sat,
.fc-sun {
    color: #CC3333;
}
Title: RoundCube Calendar (jQuery Calendar)
Post by: Lazlo on February 09, 2010, 01:42:10 PM
Quote from: lacri;25365
i have found the bug ;)

in calendar.js on line 34

search
events: "/?_action=plugin.getEvents",

replace with
events: "./?_action=plugin.getEvents",

a simple point with large effect


Fixed it, thanks.
Title: RoundCube Calendar (jQuery Calendar)
Post by: bagu on February 09, 2010, 10:32:56 PM
There is an error when i try to run mysql :

Code: [Select]
#1005 - Can't create table 'roundcubemail.events' (Errcode: 150)

phpmyadmin say that the problem is on line 24
Title: RoundCube Calendar (jQuery Calendar)
Post by: voltron81 on February 10, 2010, 06:39:47 AM
Hi.
This morning I was trying your calendar plugin for roundcube.
I'm using roundcube 0.3.
Basically I've installed it as you said and I've run the SQL file.
In the webpage there is the Calendar, and if I click on it I can add an event
But, after added it, I can not see it on the calendar...
I had a look to the database and in the table events there are all my
events... so it's look like the plugin is able to write in the
database, but it's not retreiving data from the database.
Am I wrong in something or it's a problem of the plugin?

Thanks
Title: RoundCube Calendar (jQuery Calendar)
Post by: rosali on February 10, 2010, 07:29:31 AM
There is a bug in the code if your RC does not run in a root folder of an URL. See the fix posted by "lacri". Also I recommend to use Roundcube 0.3.1 or current SVN.
Title: set public $task
Post by: lacri on February 10, 2010, 08:50:28 AM
here is a little optimization to set task

addressbook task is missing and some other task in my case

with this change is task set correct to all excluding login and logout.
replace on line 16 in calendar.php
public $task = 'mail|settings';with
// all task excluding 'login' and 'logout'
public $task = '?(?!login|logout).*';
Title: RoundCube Calendar (jQuery Calendar)
Post by: bagu on February 10, 2010, 09:08:17 AM
no one else have an error when trying to import mysql.sql ?
Title: RoundCube Calendar (jQuery Calendar)
Post by: Scarabaeus on February 10, 2010, 10:10:15 AM
@bagu
You are not alone; I have experienced a similar problem with the mysql.sql file. My errcode differs from yours. Mine is 121 I believe.
 
I have yet to find a solution. (MySQL skill level = LOW)
Will post back if I discover a solution outside the forum.
 
But help from forum members will be greatly appreciated.
 
regards
Title: RoundCube Calendar (jQuery Calendar)
Post by: haocheng on February 10, 2010, 10:47:41 AM
This is a very good plugin , Thank your sharing ,

Can addon Public function ?
Title: RoundCube Calendar (jQuery Calendar)
Post by: Lazlo on February 10, 2010, 11:39:47 AM
Quote from: bagu;25409
no one else have an error when trying to import mysql.sql ?


This is a MySQL bug: MySQL Bugs: #46293: Conditional comments not working in FOREIGN KEY definition (http://bugs.mysql.com/bug.php?id=46293)

A temporary fix:

Remove from mysql.sql
Code: [Select]

    /*!40008
      ON DELETE CASCADE
      ON UPDATE CASCADE */
Title: RoundCube Calendar (jQuery Calendar)
Post by: Lazlo on February 10, 2010, 11:40:57 AM
Quote from: haocheng;25414
This is a very good plugin , Thank your sharing ,

Can addon Public function ?


Thanks,

I don't understand "Can addon Public function ?". Please explain.
Title: calendar event timing is wrong
Post by: zlp on February 10, 2010, 12:14:47 PM
Hi. Thanks for a great plugin.

When I add an event to the monthly view, it shows up on the day before. (the database contains this erroneous date too - it's not just a display problem). When I add an event to the weekly or daily view, it appears on the correct day but 2 hours earlier than intended. When I drag it to a new time, it appears 2 hours before the time where I drop it.

Regarding the timezone problem from a previous post: My client and server are in different time zones (server is GMT -8, client is GMT -6) but it is currently 12PM, so I don't understand why the day is wrong too.

my info:
Calendar 0.2 beta
Roundcube 0.3.1

I applied both patches mentioned by Lacri:
http://www.roundcubeforum.net/7-third-party-contributions/46-api-based-plugins/6161-roundcube-calendar-jquery-calendar-7.html#post25365

http://www.roundcubeforum.net/7-third-party-contributions/46-api-based-plugins/6161-roundcube-calendar-jquery-calendar-8.html#post25408
Title: RoundCube Calendar (jQuery Calendar)
Post by: Lazlo on February 10, 2010, 12:39:45 PM
Please try the latest development version: LazloNL's roundcube-calendar at master - GitHub (http://github.com/LazloNL/roundcube-calendar)

There were some timezone changes.
Title: RoundCube Calendar (jQuery Calendar)
Post by: xrxca on February 10, 2010, 05:04:34 PM
The version from GitHub fixed the timeout issues I was having, but the code to get the skin directory is a problem,
    // add styles
    $skin = $rcmail->config->get('skin');
    $this->include_stylesheet($skin . 'calendar.css');


What your doing here is getting the current skin name and using it whether the skin exists for the calendar plugin or not and it is missing a / as well.

Would probably be better with something like this (basically taken from local_skin_path which has never worked for me under anything but the actual mail page)

  function skinPath($skinfile = '') {
    $rcmail = rcmail::get_instance();
    $skin_path = 'skins/'.$rcmail->config->get('skin');
    if (!is_dir(realpath(slashify($this->home) . $skin_path)))
          $skin_path = 'skins/default';
    return($skin_path . '/' . $skinfile);
  }


Then the above becomes:
    // add styles
    $skin =  $this->skinPath();
    $this->include_stylesheet($skin . 'calendar.css');
or more succently:
$this->include_stylesheet($this->skinPath('calendar.css'));
Title: still busted
Post by: zlp on February 10, 2010, 07:13:12 PM
I tried the GitHub version and the calendar formatting went crazy. (calendar icon was now the same as email icon, no table gridlines, just a jumble of numbers in the center of the screen.)

I made the changes suggested by xrxca and the icon came back but the formatting is still wrong. (screenshot attached)

I've never uses GitHub, so maybe I got the wrong files somehow?
Title: RoundCube Calendar (jQuery Calendar)
Post by: xrxca on February 10, 2010, 09:45:23 PM
Quote from: zlp;25428
I made the changes suggested by xrxca and the icon came back but the formatting is still wrong. (screenshot attached)


There is more than one place the change needs to be done:
The above change needs to be done as well as the following (sorry I should have been clearer)
From:
    $skin = $rcmail->config->get('skin');
    $this->include_stylesheet($skin . 'jquery-ui.css');
    $this->include_stylesheet($skin . 'fullcalendar.css');
To:
    $skin =  $this->skinPath();
    $this->include_stylesheet($skin.'jquery-ui.css');
    $this->include_stylesheet($skin.'fullcalendar.css');

And the skinPath function isn't necessarily the best, it should really check the existence of the actual file in the custom skin directory and be used like the second example in my prior post, but as is it works with this second change.
Title: RoundCube Calendar (jQuery Calendar)
Post by: batemice on February 10, 2010, 10:43:19 PM
Here's a Bulgarian translation for the plugin ;)
Title: RoundCube Calendar (jQuery Calendar)
Post by: Lazlo on February 11, 2010, 01:12:10 PM
Quote from: batemice;25434
Here's a Bulgarian translation for the plugin ;)


Added translation to development version. Thank you.
Title: RoundCube Calendar (jQuery Calendar)
Post by: Lazlo on February 11, 2010, 01:34:51 PM
Quote from: zlp;25428
I tried the GitHub version and the calendar formatting went crazy. (calendar icon was now the same as email icon, no table gridlines, just a jumble of numbers in the center of the screen.)

I made the changes suggested by xrxca and the icon came back but the formatting is still wrong. (screenshot attached)

I've never uses GitHub, so maybe I got the wrong files somehow?


Check out latest development version. I think the skin problem is fixed now.
Title: RoundCube Calendar (jQuery Calendar)
Post by: zlp on February 11, 2010, 01:35:26 PM
(edited to reduce confusion)

Thanks xrxca and Lazlo. I can confirm that the time shifting event issues from my previous post + the skin problems are fixed in today's github version. Thanks.
Title: RoundCube Calendar (jQuery Calendar)
Post by: Lazlo on February 11, 2010, 06:15:36 PM
Just released 0.2 BETA 2: RoundCube Calendar (http://rc-calendar.lazlo.me/)

CHANGELOG since 0.2 BETA:
- basic event categories
- export calendar to ICS
- default view option
- several small bug fixes

@Translators,
there are some new strings to translate. New translations are welcome!
Title: RoundCube Calendar (jQuery Calendar)
Post by: lacri on February 12, 2010, 09:01:10 AM
great great ... the categorys are cool :) many thanks
Title: multiple / shared
Post by: sckramer on February 12, 2010, 01:28:26 PM
looks really nice so far!!

With the db design etc, are you guys thinking about how in the future to add features like: multiple cals per account, and sharing cals with other accounts?

Thanks!
Title: RoundCube Calendar (jQuery Calendar)
Post by: Lazlo on February 12, 2010, 06:23:43 PM
Haven't planned to add sharing of cals with other users.

Only planned feature (before stable release) is a print feature (which rosali is working on), like Google Calendar's Agenda view. To easily print your events.
Title: RoundCube Calendar (jQuery Calendar)
Post by: batemice on February 14, 2010, 07:43:52 PM
Updated Bulgarian translation for Beta 2:
Title: RoundCube Calendar (jQuery Calendar)
Post by: Lazlo on February 15, 2010, 05:25:55 AM
Thanks, updated in the development version.
Title: RoundCube Calendar (jQuery Calendar)
Post by: phireware 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!
Title: Group calendar and added in Artica
Post by: touzeau 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 (http://www.artica.fr/index.php/front-ends-a-groupwares/64-roundcube/313-add-a-calendar-in-the-roundcube-webmail-system)

It will be very cool if you plan to provide a group/shared calendar
Title: RoundCube Calendar (jQuery Calendar)
Post by: bagu 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`)

)
Title: RoundCube Calendar (jQuery Calendar)
Post by: Lazlo 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 (http://github.com/LazloNL/roundcube-calendar/)).
Title: Server Error (OK!) still
Post by: sh0x 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",
Title: RoundCube Calendar (jQuery Calendar)
Post by: lacri 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
Title: RoundCube Calendar (jQuery Calendar)
Post by: Sypher 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.
Title: Postgres
Post by: katie 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.
Title: RoundCube Calendar (jQuery Calendar)
Post by: rosali 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.
Title: RoundCube Calendar (jQuery Calendar)
Post by: katie 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.
Title: RoundCube Calendar (jQuery Calendar)
Post by: rosali on February 28, 2010, 12:21:08 AM
It does not support customizable table names (yet).
Title: RoundCube Calendar (jQuery Calendar)
Post by: katie 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.
Title: davical
Post by: roe1234 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.
Title: RoundCube Calendar (jQuery Calendar)
Post by: gznadroj 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
Title: RoundCube Calendar (jQuery Calendar)
Post by: rosali on March 07, 2010, 02:46:27 AM
Download from here: LazloNL's roundcube-calendar at master - GitHub (http://github.com/LazloNL/roundcube-calendar)
Title: caldender plugin roundcubemail-0.2.1
Post by: hantu on March 10, 2010, 03:18:46 AM
Hi

I cannot figure out what went wrong when installing calendar plugin into roundcubemail-0.2.1

My OS
Centos 5.3
package used is iRedMail-0.5.1 released


here are my steps, anything missing?


Step1
I extracted the calender plugin into /var/www/roundcubemail/plugins/calendar

Step2
I updated mysql

mysql> use database roundcubemail;
mysql>  source /var/www/roundcubemail-0.2.1/plugins/calendar/SQL/mysql.sql
mysql> show tables;


Step3
I also added the following line for /var/www/roundcubemail/config/main.inc.php

$rcmail_config['plugins'] = array(
  "calendar"
  );

Step4
I restart Apache services

Note:
I also enable /var/www/roundcubemail/plugins/calendar/config/config.inc.php Should I do that?

In /var/www/roundcubemail/plugins/calendar/config/config.inc.php
// backend type (database)
$rcmail_config['backend'] = "database";

Should I change my database address?

Thanks
Lee
Title: RoundCube Calendar (jQuery Calendar)
Post by: lacri on March 10, 2010, 04:31:58 AM
hi hantu,

you need min roundcube 0.3 stable

roundcube 0.2.1 dont support plugins

the plugin api comes with roundcube 0.3.

i think roundcube 0.3.1 or the current svn version is better for jQuery Calendar.

best lacri
Title: RoundCube Calendar (jQuery Calendar)
Post by: voltron81 on March 19, 2010, 06:10:55 AM
Hi guys,
I'm running roundcube 0.3.1 and I've installed the last version of this great plugin.

-I've put the folder in the /plugins folder
-I've added the SQL file (mysql -u roundcube -p roundcubemail < SQL/mysql.sql)
-I've edited the file /roundcube/plugins/calendar/config.inc.php, adding the name of the roundcube database and username and password
-I've renamed the file /roundcube/plugins/calendar/config/config.inc.php.dist to config.inc.php (I don't think I've to edit that file)

Now I'm entering in the webmail, I can see the Calendar, I can read the example events, but if I try to add a new one, it's just not memorized...
In can see that the events table in the database is empty...

Am I wrong in something?
Thanks

Michele
Title: RoundCube Calendar (jQuery Calendar)
Post by: voltron81 on March 19, 2010, 06:19:08 AM
Sorry, my bad...

I edited the file /roundcube/plugins/calendar/config/config.inc.php, putting database instead of dummy and now it's working fine...

thanks a lot, great job

Michele
Title: RoundCube Calendar (jQuery Calendar)
Post by: v2mody on March 22, 2010, 02:17:25 AM
hi ,
i have used old version of that calendar before ,

however yesterday i tried the latest version , it didn't work untill i add this line from the old config file to the new one
$rcmail_config['use_calendar'] = 'calendar';
it was not exist in the new config file like the old one ??? odd
if i didn't add this line , i can't see the calendar icon on roundcube

just small comments on the new version
before if i select a meeting , there was a start and end date above
now only start date , can i possibly use the old method of showing for example 6-8 meeting instead of only starting date ?/
Title: RoundCube Calendar (jQuery Calendar)
Post by: brashquido on March 29, 2010, 08:01:07 AM
Thanks for the tip v2mody. adding that line worked for me on a 0.3.1 install using beta 2 of Calendar.
Title: Is there an issue with different skins?
Post by: strictlydata on March 31, 2010, 02:38:29 PM
Hi,

I am having an issue that the current skin is not being selected. It is always choosing the default skin.

Is there a bug?

Thanks
Title: The latest github version
Post by: strictlydata on March 31, 2010, 03:06:23 PM
This seems to have fixed the issue!
Title: hungarian translation
Post by: zeta67 on March 31, 2010, 03:24:48 PM
hungarian translation
Title: RoundCube Calendar (jQuery Calendar)
Post by: poyo77 on April 02, 2010, 11:29:30 AM
Hello,
I'm French, so I speak a poor english... Sorry.

I've got a CalDav server (Davical) with many users in it...

How to configure calendar plugin to access all User's calendar?

Note: Calendar plugin works so fine with one user.

thanks for your help.

Poyo77
Title: Daylight Saving bug
Post by: tjm74 on April 06, 2010, 04:49:53 PM
Quote from: rosali;25008
solved

use that:
Code: [Select]

  function get_events()
  {
    $rcmail = rcmail::get_instance();

    $tz = isset($_SESSION['timezone']) ? $_SESSION['timezone'] : date('Z')/3600;


mmm, not quite.  This shifts all events that are not in the current timezone off by one hour -- so if it's july (during daylight saving time) and you're looking back at what happened in january (during which we observed standard time), or vice versa, events look fine in your current month but they are off by an hour during the months where the other tz was observed.

I have a fix, it's not pretty but it works better.  I even try to determine whether DST is not observed where you are (or at least, where the server is, which is usually a good indication).

1. fix toGMT

Code: [Select]

  function toGMT($time) {
    $gmt_offset = date('Z');

    // current gmt offset may not match event's gmt offset
    // adjust accordingly
    if (date('I') && !date('I',$time)) {
      $gmt_offset -= 3600;
    } else if (!date('I') && date('I',$time)) {
      $gmt_offset += 3600;
    }

    return date('Y-m-d H:i:s',$time - $gmt_offset);
  }


2. fix getEvents (in database.php)
Code: [Select]

  public function getEvents($start, $end) {
    if (!empty($this->rcmail->user->ID)) {

      /* This was completely wrong -- the question is whether to adjust
         the EVENT's time for DST.
         Whether we are CURRENTLY observing DST is not really the issue.
         The question is (A) does the user observe DST? and if so,
         (B) does THIS EVENT fall on the calendar during DST or STD time?
      */

      if ($this->rcmail->config->get('timezone') === "auto") {
        $auto = TRUE;
        $tz = isset($_SESSION['timezone']) ? $_SESSION['timezone'] : date('Z')/3600;
      } else {
        $auto = FALSE;
        $tz = $this->rcmail->config->get('timezone');
        if($this->rcmail->config->get('dst_active')) {
          $dst_active = TRUE;
          $tz++;
        }
      }

      if (date('I') || (!$auto && $dst_active)) {
        $tz_std = $tz - 1;
        $tz_dst = $tz;
      } else {
        $tz_std = $tz;
        $tz_dst = $tz + 1;
      }

      // Server does not observe DST?  Then most likely the user doesn't either.
      if (($auto || !$dst_active) && !date('I',mktime(0,0,0,7,1,2010))) {
        // no DST adjustment
        $tz_std = $tz;
        $tz_dst = $tz;
      }

      $result = $this->rcmail->db->query(
        "SELECT * FROM events
         WHERE user_id=?",
         $this->rcmail->user->ID
       );

      $events = array();
      while ($result && ($event = $this->rcmail->db->fetch_assoc($result))) {
        $event['start'] = strtotime($event['start']);
        $event['end'] = strtotime($event['end']);

        // is/was the EVENT during daylight saving time?
        if (date('I',$event['start'] + $tz * 3600)) {
          $event['start'] += $tz_dst * 3600;
          $event['end'] += $tz_dst * 3600;
        } else {
          $event['start'] += $tz_std * 3600;
          $event['end'] += $tz_std * 3600;
        }

        $events[]=array(
          'id'    => $event['event_id'],
          'start' => date('c', $event['start']),
          'end'   => date('c', $event['end']),
          'title' => $event['summary'],
          'description'  => $event['description'],
          'className'  => $event['category'],
          'allDay'=> ($event['all_day'] == 1)?true:false,
        );
      }

      return json_encode($events);
    }
  }

Title: RoundCube Calendar (jQuery Calendar)
Post by: rosali on April 24, 2010, 04:46:21 AM
Hmmm... works for me. Which browser?
Title: RoundCube Calendar (jQuery Calendar)
Post by: katie on May 02, 2010, 04:30:43 PM
Quote from: Blueyed1;27098
Hi Katie

Did you ever get it to work?? RC with calendar on postgresSQL ?

/Blueyed1


No.

Makes no sense to hack around at this state.

Any Ideas?
Title: RoundCube Calendar (jQuery Calendar)
Post by: Blueyed1 on May 05, 2010, 03:30:41 AM
Quote from: katie;27206
No.

Makes no sense to hack around at this state.

Any Ideas?


It's a pitty that it dosn't work with postgreSQL... I managed to get some tables in the postgreSQL db and I can see/edit them with phpPgAdmin. But I don't know if the tables are correct or what else I need to do. Look at screenshots below.









/Blueyed1
Title: RoundCube Calendar (jQuery Calendar)
Post by: SKaero on May 05, 2010, 09:49:48 AM
Assuming the database is setup correctly you would need to edit the sql querys that are going to the database that are in the main plugin file.
Title: RoundCube Calendar (jQuery Calendar)
Post by: Blueyed1 on May 05, 2010, 02:00:16 PM
Quote from: skaero;27259
Assuming the database is setup correctly you would need to edit the sql querys that are going to the database that are in the main plugin file.


Well, my knowledge to postgresSQL DB and configuration in general, is limited to following a step by step guide.

It would be a nice feature if calendar plugin could be made so it'l run on postgresSQL, the same way as mySQL, and with a brief guide to installation.

/Blueyed1
Title: RoundCube Calendar (jQuery Calendar)
Post by: rosali on May 30, 2010, 12:53:00 AM
This thread has been splitted to:

#1-jQuery Weekcalendar plugin (deprecated)
     http://www.roundcubeforum.net/7-third-party-contributions/46-api-based-plugins/6779-jquery-weekcalendar-plugin-deprecated.html

#2-jQuery Fullcalendar plugin (developed by Lazlo and forked by rosali)
     http://www.roundcubeforum.net/7-third-party-contributions/46-api-based-plugins/6782-jquery-fullcalendar-plugin-forked-rosali.html

Posts regarding these two plugin versions has been moved to appriate thread.

Posts remaining here refer to Lazlo's Github version (RoundCube Calendar (http://rc-calendar.lazlo.me)).
Title: RoundCube Calendar (jQuery Calendar)
Post by: rosali on May 30, 2010, 03:28:35 AM
@ all subscribers: Don't miss to subscribe to new threads!
Title: How do I change the hours
Post by: trvsfhln on June 23, 2010, 04:33:45 AM
How do I change the hours to AM and PM 12 hour blocks instead of the 24:00 clock
Title: RoundCube Calendar (jQuery Calendar)
Post by: dziobak on June 23, 2010, 04:49:30 AM
you can do it i calendar settings: change time format....
Title: RoundCube Calendar (jQuery Calendar)
Post by: trvsfhln on June 23, 2010, 07:26:38 PM
I change it to h:mmt and hit save, then it says saved succussfully then when i look at the time format option it has reset itself to HH:mm
Title: Categories
Post by: trvsfhln on June 23, 2010, 07:34:38 PM
How do I add and create new categories in the calendar
Title: RoundCube Calendar (jQuery Calendar)
Post by: dziobak on June 24, 2010, 12:28:54 AM
In the same place... on the bottom. Find '+'
Title: CalDAV support
Post by: ajl on June 30, 2010, 09:58:34 AM
Good day:

I have been trying to get CalDAV support working with the plugin in the latest GIT-checkout. Server is DAViCal  0.9.9-0 on Ubuntu Hardy [1], but the calendar is not populated, probably due to a missing piece in the authentication. Is the login with current rouncube credentials working for CalDAV, or are those config lines a placeholder for future functionality?

Working caldav support would be fantastic for Roundcube, even if on a readonly basis for now.

Thanks, Achim

[1] DAViCal - DAViCal Home (http://davical.org/)
Title: RoundCube Calendar (jQuery Calendar)
Post by: dziobak on June 30, 2010, 10:25:58 AM
you can check Rosali's version. There is possibility to work on the same calendar from RC and TB where RC is 'calendar server'. Rosali's version is supported. The version from Github... I don't know.
Title: No CalDAV
Post by: ajl on July 01, 2010, 08:43:48 AM
I looked at Rosali's version, and unfortunately CalDAV is also not support, as per her own comment: http://www.roundcubeforum.net/7-third-party-contributions/46-api-based-plugins/6782-jquery-fullcalendar-plugin-forked-rosali-11.html#post28428 (http://www.roundcubeforum.net/7-third-party-contributions/46-api-based-plugins/6782-jquery-fullcalendar-plugin-forked-rosali-11.html#post28428).

Is anybody here aware of a simple way to visualise (not even edit!) caldav calendars?

Thanks, Achim
Title: RoundCube Calendar (jQuery Calendar)
Post by: dziobak on July 01, 2010, 09:02:00 AM
Fullcalendar is not supporting caldav. You can try webcalendar from Rosali's trunk (I don't know if it supports caldav...)
Title: RoundCube Calendar (jQuery Calendar)
Post by: rosali on July 01, 2010, 10:34:49 AM
To clarify: CalDAV support is possible if someone would code a suitable backend driver. In the original calendar plugin there was a CalDAV backend under development. I think the contact data of the developer is anywhere in Lazlo's github package.

For someone with CalDAV skills it would be easy to code something to give read access only. This could be done by coding a script which returns events as a json encoded array and to show this as a calendar layer.
Title: unable to write events to caldav rc-calender
Post by: tuxcrafter on October 18, 2010, 06:28:42 AM
Dear Lazlo (and other contributes),

Let me first thank you for creating this roundcube calendar.

I got a debian testing roundcube 0.3.1-5 installation and installed rc-calendar as described bellow.

I also use mozilla sunbird with the same user credentials and with sunbird I am able to write and change caldav events.

However with rc-calendar I can read and see the events but I can't change or create new events!

I checked my apache logs but I cant find any errors, however I don’t see any PUT or PROPFIND events, only REPORT events for roundcube.

How will I be able to read and write to my caldav calender with rc-calendar?

Code: [Select]
wget http://download.github.com/LazloNL-roundcube-calendar-af961ec.tar.gz
tar xvzf LazloNL-roundcube-calendar-af961ec.tar.gz
mv LazloNL-roundcube-calendar-af961ec/calendar calendar
mv calendar /usr/share/roundcube/plugins/
ls -hal /usr/share/roundcube/plugins/
cp /usr/share/roundcube/plugins/calendar/config/config.inc.php.dist /usr/share/roundcube/plugins/calendar/config/config.inc.php
vim /usr/share/roundcube/plugins/calendar/config/config.inc.php


Code: [Select]
# egrep -w rcmail_config  /usr/share/roundcube/plugins/calendar/config/config.inc.php
$rcmail_config['backend'] = "caldav";
$rcmail_config['default_view'] = "month";
$rcmail_config['time_format'] = "HH:mm";
$rcmail_config['timeslots'] = 1;
$rcmail_config['first_day'] = 1;
$rcmail_config['first_hour'] = 9;
$rcmail_config['categories'] = array('Personal' => 'c0c0c0',
$rcmail_config['caldav_server'] = 'https://secure.companyname.nl/davical/caldav.php';
$rcmail_config['caldav_username'] = 'companyname';
$rcmail_config['caldav_password'] = 'secret';
$rcmail_config['caldav_calendar'] = 'agenda';
$rcmail_config['caldav_use_roundcube_login'] = false;
$rcmail_config['caldav_loginwithout_tld'] = false;
Title: RoundCube Calendar (jQuery Calendar)
Post by: ajl on October 18, 2010, 10:02:33 AM
Having a rcube calendar work with Davical would be fantastic: one step closer to a Gmail replacement!
Title: RoundCube Calendar (jQuery Calendar)
Post by: rosali on July 02, 2011, 02:54:30 PM
Closing ... Follow up: http://www.roundcubeforum.net/7-third-party-contributions/46-api-based-plugins/6782-jquery-fullcalendar-plugin-forked-rosali.html