jQuery Fullcalendar plugin (forked by rosali)

[voltron81]

Thanks Rosali,
I'll try it now.
Do I need to upgrade the mysql database as well or is enough to move the new calendar folder in the plugin directory?

Thanks
Michele

[rosali]

You have to modify the database aswell. The final release which is scheduled for the weekend will need further database modifications.

[voltron81]

Hi rosali,
thanks for the reply.
I've downloaded your last version.
I've modified the mysql database with the command:

Code Select Expand

mysqldump -u user -p roundcubemail < mysql.sql
and I've modified the file /config/config.inc.php, putting "database" as backend.

On roundcube I can see the new plugin (it's actually really nice).
I can also see the old events (the one that was on the database with the old version of the plugin), but I can not save a new event (I'm having this error message: Server error (Internal Server Error).

I guess is something wrong with mysql.
Am I wrong in something?

Thanks
Michele

[rosali]

Use phpmyadmin and check if your events table has exactly the structure as shown in mysql.sql.

I'm not sure if it is compatible with old events. Best would be to start with a new database table.

Before deleting the old one, export the events. Then check if you can create new events.
If that's ok, then finally re-import old events and check again.

__________
EDIT: What is in the errors log?

[voltron81]

Hi rosali.
At the end I've cancelled the table events and created it again according with the new mysql file and it's look like working now...
How can I try now the features? For example the shared calendar and the email notification...

Anyway I will be more than happy to test your final version this weekend...

thanks
Michele

[rosali]

Check settings (Calendar feeds and Calendar).

To share a calendar the one party has to generate a token URL (read or read/write) and the other party has to add these URL to its layers.
It basically works like google calendar access URLs.

[voltron81]

Mmm I'm not exatly sure to have understood what do you mean...
Anyway I'll have a look how google calendar is working, then maybe it will appear more clear...

Thanks
Michele

[voltron81]

Hi rosali,
I've just installed your last version of the calendar plugin and it's working really good.

Just a couple of questions.
1) If i want to upload an outlook calendar file, do I need to create an event and then upload that file? If in that file there will be 100 events for 100 different days, does the system upload all of them? Because it looks like it doesn't read an outlook calendar file (strange behaviuor)
2)There is a way to connect this calendar to an exchange calendar, so that they will be automatically sync? (of course I'm talking about a local roundcube installation, so the connection between roundcube and exchange is local)
3)still I don't understand how to share a calendar between more users...

Thanks
Michele

[rosali]

#1 - Send me an Outlook upload file for testing.
#2 - Only Thunderbird / Lightning is supported ... I do not have ($$$) Exchange.
#3 - Sharing calendars is easy:

User A wants to share with User B...
User A: Settings -> Calendar Feeds -> enable Token read/write access and/or read only access
User A: Now you should see a Feed URL
User A: Pass this URL to User B (either the read/write URL or the read only URL)
User B: User B has to add this URL to Calendar Feeds (First Fieldset in Settings -> Calendar Feeds)

User B has to do the same steps to share with User A.

OK?

[voltron81]

Hi Rosali,
I'm making the calendar sharing as you said, but it's look like not working...
I'm following exatly your instructions...
:eek:

Thanks
Michele

[rosali]

Give me two test accounts on your machine and PM'me login details.

If it works for it should work for you too.

[Granada]

Sharing calendars among users does not work here, too. Installed the new version of the calendar plugin over the old one and newly generated the mysql-table. Adding a calendar feed via the settings leads to some PHP-warnings in the log, but nothing critical:

[27-May-2010 15:04:28] PHP Warning:  array_combine() [function.array-combine]: Both parameters should have an equal number of elements in /usr/local/htdocs/roundcube0.4beta/plugins/calendar/calendar.php on line 1059
[27-May-2010 15:04:28] PHP Warning:  Invalid argument supplied for foreach() in /usr/local/htdocs/roundcube-0.4beta/plugins/calendar/calendar.php on line 1066

But it's no wonder the sharig does not work: no data is written to the user's config entry in the database and reloading the settings tab shows no entry at all.

Apart from that I'd like to have calendar sharing made in a different way: would it be possible to select users from the address book that I want to allow to view my calendar? That seems much more intuitive to me.

Regards
Ruediger

[rosali]

Could please post your calendar config file?

[Granada]

You mean ~plugins/calendar/config/config.inc.php? Mine looks like this:

<?php
// backend type (dummy, database), see README
// Note: "dummy" is only for demonstrating basic functionality.
$rcmail_config['backend'] = "database";

/* database table name */
$rcmail_config['db_table_events'] = 'events';

// default calendar view (agendaDay, agendaWeek, month)
$rcmail_config['default_view'] = "agendaWeek";

// time format (HH:mm, H:mm, h:mmt)
$rcmail_config['time_format'] = "HH:mm";

// timeslots per hour (1, 2, 3, 4, 6)
$rcmail_config['timeslots'] = 2;

// first day of the week (0-6)
$rcmail_config['first_day'] = 1;

// first hour of the calendar (0-23)
$rcmail_config['first_hour'] = 6;

// event categories (can be modified by user)
$rcmail_config['categories'] = array(
  'Personal' => 'c0c0c0', 
  'Work' => 'ff0000',
  'Family' => '00ff00',
  'Holiday' => 'ff6600',
);

// public calendar categories (can't be modified by user)
$rcmail_config['public_categories'] = array(
  'Public' => 'ff6600',
);
                                      
// work days (0 = Sunday)
$rcmail_config['workdays'] = array(1,2,3,4,5);

// default event duration in hours (e.g. 0.25, 0.5, 1, 2 ...)
$rcmail_config['default_duration'] = 1;
                                      
// event feeds (can be deleted by user)
$rcmail_config['calendarfeeds'] = array(
  //'http://www.google.com/calendar/feeds/[email protected]/public/basic' => 'Google',
);

// public calendar (can't be deleted by user)
$rcmail_config['public_calendarfeeds'] = array(
  'http://www.google.com/calendar/feeds/[email protected]/public/basic' => 'Public', 
);
?>


Regards
Ruediger

Edit: Who set this topic's icon to "thumbs down"? I did not - at least not intentionally! The calendar plugin is worth developing!

[voltron81]

Hi Rosali,
unfortunately I'm trying this calendar plugin on a local machine that is not online (this roundcube installation is just to read local emails from local users).

So let's wait some more feedback from somebody else then...

thanks
Michele