DAViCal Web Client
From DAViCal Wiki
Contents |
Web client for DAViCal
In light of users' requests for a web based interface to DAViCal (and to satisfy my own needs) I designed a web- based client for DAViCal last summer.
In its present state it is only able to display events; creating, updating, and deleting is not yet implemented. This should not be a very difficult task, however, due to the widespread use of design patterns and OO-style in general. Use the wise advice from Kernighan and Plaugher: "Program to an interface, not an implementation".
Using my web calendar with Google now works. The settings for using Google Calendar's caldav extension can be found here. The configuration for Mozilla Sunbird also applies for my web calendar.
Here are some screen dumps:
News
Version 0.7.2 has been released. This release fixes some grave bugs as well as add support for using PostgreSQL as backend.
New features:
1) Added support for PostgreSQL
2) Added feature which enables resetting the password for users
Enhancements:
1) Since posix_getpid is not supported on the MS Windows platform implement random filename using a hash
2) Replaced split function with explode since split is deprecated as of PHP 5.3
Bug fixes:
1) Don't add an extra hour if event ends on an hour border
2) Compensate for calendar's use of 00 for 24 (midnight)
3) Proberly test if time is inside configered calendar time
Version 0.7.1 has been released. This is a maintenance release fixing some critical bugs and adds support for SQLite3 >= 3.19. Existing users should not have to upgrade the database but to insure future compatibility with SQLite3 >= 3.19 you are advised to do so. In the install folder is a shell script to help you migrate your database to the new design.
To upgrade to the new database design:
1) Copy the script install/upgrade.sh from the new release to your existing webcal install folder
2) cd to existing webcal install folder
3) Do: ./upgrade export (when requesting the name of the database remember the file is located in the folder above)
4) Copy the resulting files: user.sql and calender.sql to a save place
5) Make a new installation from the new release
6) Copy the files user.sql and calendar.sql to the new installation's install folder
7) cd to new webcal install folder
8) Do ./upgrade import (when requesting the name of the database remember the file is located in the folder above)
9) You should now have a database with the new design populated with the old data
Installation
If you want to try it yourself, go to these installation instructions.
Q & A
Q: Can I create calendars for the admin account?
A: No, the admin account is strictly for administration. The access to create calendars will be removed for user admin in the next release.
Q: The database is not created under install, I receive error messages like "Uncommitted sessions exists", or calendars seems not to be created. What can I do?
A: You are most likely running SQLite3 >= 3.19. SQLite 3.19 is a huge change compared to SQLite3 < 3.19 - eg. SQLite3 now supports AND enforces foreign keys which is incompatible with the database design in the current release. Either downgrade your version of SQLite3 or fetch source directly from my subversion repository. A new release will follow shortly.
Constributing
Information about contributing to this project are here. --Mir 21:54, 25 June 2009 (UTC)

