@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.
Here is french translation
Thanks you, added it to the 0.2 BETA trunk.
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.
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.
Quote from: Lazlo;25329I'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.
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.
Quote from: xrxca;25336What 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.
Quote from: rosali;25337It 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?
Quote from: Lazlo;25340I'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
That should be no problem.
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
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:
buttonText: {
today: response.settings['today'],
day: rcmail.gettext('day', 'calendar'),
week: rcmail.gettext('week', 'calendar'),
month: rcmail.gettext('month', 'calendar'),
},
replace with:
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 ...
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
I fixed the "," problem for IE7 and some other small fixes.
Also updated in 0.2 BETA package.
@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?
@rosali
I've seen the changes you made in the previous version. I will port them to 0.2 BETA.
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
Ahh ok ...
Then I was right with my assumption:
QuoteA difference between my VPS and my home server is that RC does not run in a root folder there.
to change color of weekend
add to fullcalendar.css
.fc-sat,
.fc-sun {
color: #CC3333;
}
Quote from: lacri;25365i 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.
There is an error when i try to run mysql :
#1005 - Can't create table 'roundcubemail.events' (Errcode: 150)
phpmyadmin say that the problem is on line 24
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
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.
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).*';
no one else have an error when trying to import mysql.sql ?
@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
This is a very good plugin , Thank your sharing ,
Can addon Public function ?
Quote from: bagu;25409no 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
/*!40008
ON DELETE CASCADE
ON UPDATE CASCADE */
Quote from: haocheng;25414This is a very good plugin , Thank your sharing ,
Can addon Public function ?
Thanks,
I don't understand "Can addon Public function ?". Please explain.
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
Please try the latest development version: LazloNL's roundcube-calendar at master - GitHub (http://github.com/LazloNL/roundcube-calendar)
There were some timezone changes.
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'));
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?
Quote from: zlp;25428I 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.
Here's a Bulgarian translation for the plugin ;)
Quote from: batemice;25434Here's a Bulgarian translation for the plugin ;)
Added translation to development version. Thank you.
Quote from: zlp;25428I 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.
(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.
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!
great great ... the categorys are cool :) many thanks
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!
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.
Updated Bulgarian translation for Beta 2:
Thanks, updated in the development version.
I hope it's ok, but I have implemented this calendar in the MobileCube theme! Great job, love the plugin!
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
Here is the french translation for 2 beta 2 :
<?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 :
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`)
)
Thank you, added the translation to the latest development version (LazloNL's roundcube-calendar at master - GitHub (http://github.com/LazloNL/roundcube-calendar/)).
Quote from: rosali;25337It 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",
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
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.
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
-- 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.
Did you configure ./config/config.inc.php ? It looks like you run the "dummy" driver instead of the database driver.
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:
$rcmail_config['use_calendar'] = 'calendar';
$rcmail_config['db_table_events'] = 'webmail_events';
Did I miss something?
:confused:
K.
It does not support customizable table names (yet).
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.
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.
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
Download from here: LazloNL's roundcube-calendar at master - GitHub (http://github.com/LazloNL/roundcube-calendar)
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
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
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
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
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 ?/
Thanks for the tip v2mody. adding that line worked for me on a 0.3.1 install using beta 2 of Calendar.
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
This seems to have fixed the issue!
hungarian translation
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
Quote from: rosali;25008solved
use that:
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
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)
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);
}
}
Hmmm... works for me. Which browser?
Quote from: Blueyed1;27098Hi 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?
Quote from: katie;27206No.
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
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.
Quote from: skaero;27259Assuming 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
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)).
@ all subscribers: Don't miss to subscribe to new threads!
How do I change the hours to AM and PM 12 hour blocks instead of the 24:00 clock
you can do it i calendar settings: change time format....
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
How do I add and create new categories in the calendar
In the same place... on the bottom. Find '+'
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/)
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.
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
Fullcalendar is not supporting caldav. You can try webcalendar from Rosali's trunk (I don't know if it supports caldav...)
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.
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?
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
# 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;
Having a rcube calendar work with Davical would be fantastic: one step closer to a Gmail replacement!
Closing ... Follow up: http://www.roundcubeforum.net/7-third-party-contributions/46-api-based-plugins/6782-jquery-fullcalendar-plugin-forked-rosali.html