iCal
iCalcreator manual
rsscalCreator manual
Deploying examples
iCal file web calendar
iCal file event web editor
iCal utilities
iCal database interface
iCal converting package
creating iCal test files
Communities
sLog
event tracking database
Communities
Resources
Credits
PHPMailer 5.1
(LGPL)
prototype 1.7 (CC BY-SA)
reCAPTCHA
Support
Our services are available for support, design and developing customizations,
adaptations of PHP/MySQL solutions with a special focus on software long term utility and reliability,
supported through our iterative acquire/design/transition process model.
Donate
You can show your appreciation for our free software,
and can support future development by making a donation to the kigkonsult projects.
Make a donation of any size by clicking here. Thanks in advance!
Copyright ©2008-2012 kigkonsult
dbiCal
dbiCal is a PHP database backend solution storing (multiple) iCal calendar files
in a database, using pear MDB2 as database API and iCalcreator as the
API for calendar information.
dbiCal may very well fit as a caldav calendar database back end.
The package supports
- inserting calendar files into database
- fetching information about stored calendar files in the database
- selecting a calendar filefrom database
- deleting a calendar in database
All calendar information, timezone, event, todo, journal and freebusy
components with all properties, including x-properties are supported.
Empty properties are not supported. Also multiple instances of a
calendar (sharing the same 'calendar name' but with separate insert
dates) are supported.
Using the PHP PEAR MDB2 package, dbiCal supports the following RDBMS:
MySQL/MySQLi, PostgreSQL, Oracle, Frontbase (unmaintained), Querysim,
Interbase/Firebird, MSSQL, SQLite. Depending on the underlying RDBMS
(and MDB2), transactions are supported.
Download dbiCal here.
Special Offer, Boost performance!!
News
31/1 2012 New dev. release, iCalcreator-2.11.15dev on github!
30/12 2011 New release of iCalcnv 3.0
| Release summary: |   |
- iCalcnv is reworked into a single class, using a simple configuration set method.
- the former main functions; iCal2csv, iCal2xls and cvs2iCal are now public methods in the class.
- an iCalcreator vcalendar instance can be used as input (iCal2csv, iCal2xls) or returned as output (cvs2iCal) to ease up integration with iCalcreator
- PEAR Log (or eClog) is supported
4/12 2011 New minor subrelease of dbiCal 3.0.5
| Release summary: |   |
-
new functionality
Concatenating all class files into one file
-
update of functions
Changed 2nd argument to dbiCal select method: using iCalcreator vcalendar array config format
admin interface (, when using compare) removing unnecessary parse, sort and save
testing byte encoded class file(-s)
-
fixed bugs in
admin interface (config tab) when log file is defined but not created
23/11 2011 New subrelease of iCalcreator 2.10.23
| Release summary: |   |
- fixed bugs
function selectComponents; RECURRENCE-ID management
- updated user guide
UTC timezone usage
relationship between getProperty/selectComponents functions
other minor clarifications
15/11 2011 tinycal v3.0
| Release summary: |   |
tinycal v3.0, ported to jQuery JavaScript Library v1.4.4 for display and Axaj logics.
14/11 2011 New subrelease of iCalcreator 2.10.20
| Release summary: |   |
- update of functions
xcal (xml) format update
function setConfig (component level), setting 'nl' always before 'format'
- fixed bugs
selectComponents with last arguments (false, true, false)
iCalUtilityFunctions::_recur2date, FREQ=YEARLY + BYDAY - combination
returnCalendar; removing Content-Length header
- updated user guide etc.
21/10 2011 New subrelease of iCalcreator 2.10.15
| Release summary: |   |
- new functionality
Evaluate, test and use of ionCube php byte file encoder
- update of functions
selectComponents, changed order of generating components
setSequence, value 0 (zero) first value
setConfig, force setting of Directory before Filename
_size75, updated management of line folding (again.. .)
- fixed bugs
_size75, typo error
_makeDtstamp, typo error
selectComponents, setting start/end-dates (x-prop) for events longer than 24h
- updated using manual
missing links, STATUS etc
8/10 2011 Beta test tinycal v3.0
| Release summary: |   |
tinycal v3.0, ported to jQuery JavaScript Library v1.4.4 for display and Axaj logics.
Please feel free to take a look and test it here
and use the contact page and communicate your opinion!
Preliminary release date is late October.
7/10 2011 New release of tiCalFile 2.4
| Release summary: |   |
A file locking mechanism is implemented to avoid parallel excutions.
7/10 2011 New release of eClog 2.0
| Release summary: |   |
Extended version supporting singleton pattern, simplified log calls etc.
5/8 2011 New subrelease of iCalcreator 2.10.5
| Release summary: |   |
- new functionality
transform a datetime from a timezone to another using PHP DateTime and DateTimeZone class (PHP >= PHP 5.2.0)
- update of functions
parse, ensure (vtimezone) standard/daylight component order
iCalUtilityFunctions::createTimezone, creating RRULEs
iCalUtilityFunctions::_setDate
- fixed bugs
adaptation for PHP STRICT error_reporting
- updated using manual
15/7 2011 New release of iCalcreator 2.10
| Release summary: |   |
- new functionality
getProperty, sort, getComponent and selectComponents with new arguments: Attendee, Categories, DTSTAMP, Location, Organizer, Priority, Resources, Status, Summary properties
simple create of timezone (including standard/daylight) component
auto completion of (default) timezone when setting DTEND, DTSTART, DUE, RECURRENCE-ID
new arguments for utf8 encoding and gzencode in function returnCalendar
- update of
get- and setfunctions for properties with numeric (integer) content
parse, management of line folding when parsing
getProperty and deleteProperty, management of properties with multiple ocurrence
parse on calendar level, set config when creating new component etc
setfunctions for DTEND, DTSTART, DUE, RECURRENCE-ID
update of getConfig and all config setting on calendar and component level
calendar property VERSION always first in calendar
- fixed bugs in
iCalUtilityFunctions::_duration2date
selectComponents
setFreebusy
createAttendee
TRIGGER with no duration
iCalUtilityFunctions::_recur2date(, _setRexrule), BYSETPOS
- updated using manual
As usual, exhaustive regression tests has been executed to verify the release as well as external beta testing.
18/6 2011 iCalcreator 2.10 Beta test, Closed
| Summary: |   |
The iCalcreator 2.10 beta test period has started, if you are interested to have a look and squeeze on iCalcreator v2.10rc2
package, please use the contact page.
Planned official release date is mid July.
-
updated management of line folding
-
updated functions getProperty, sort, SelectComponents, works with Attendee, Categories, (dtstamp, ) Location, Organizer, Priority, Resources, Status and Summary properties
-
simple create of timezone (including standard/daylight) component(-s)
-
auto completion of (default) timezone when setting DTEND, DTSTART, DUE, RECURRENCE-ID
-
management of properties with numeric (integer) content; PERCENT-COMPLETE, PRIORITY, REPEAT, SEQUENCE, X-PROP
bug in function iCalUtilityFunctions::_duration2date
bug in function selectComponents
bug in function createAttendee
bug when using TRIGGER with no duration
bug in function SelectComponents regarding X-CURRENT-*-values
bug in function setFreebusy, empty property
bug in function setFreebusy if property is empty.. .
6/3 2011 New release of tiCalFile 2.2
| Release summary: |   |
- Offer extended property parameter setting.
1/3 2011 New release of dbiCal 3.0
| Release summary: |   |
After a successfull beta release test period, the official release.
-
supporting ALL calendar information; timezone, event, todo,
journal and freebusy components with all properties, including
x-properties.
-
using pear MDB2 as database API and iCalcreator (2.8) as the
calendar information API, opt pear Log
-
simple interface functions; insert, select, delete and calendar
information
-
includes a web admin page, offering ability to upload, insert,
examine (file), inspect (db), removal and compare of calendar
files.
-
changed licence to LGPL.
28/1 2011 dbiCal 3.0rc2 Beta test
| Summary: |   |
dbiCal has during the beta tests been extended to
- support storage of metadata, ex. calendar/user references (or preferences)
- include web administrator interface
Please contact if you would like to participarte!
24/1 2011 eventCreator 2.4rc is available for Beta testing.
| Summary: |   |
- Test online
- Please contact if you would like to download and test!
16/1 2011 New release of tinycal 2.4.1
| Release summary: |   |
- adapt for prototype 1.7 javascript framework
- time (date) display in component view
- includes alarms in non-total downloads
9/1 2011 dbiCal 3.0rc Beta test
| Summary: |   |
dbiCal is a PHP database backend solution storing (multiple) iCal calendar files in a database
using pear MDB2 as database API and iCalcreator 2.8 as the API for calendar information.
Please contact if you would like to participarte!
8/1 2011 New release of tinycal 2.4
| Release summary: |   |
- The 2.4 version is updated to use iCalcreator 2.8 and javascript adaptations.
- Supports en, fr, it and se languages.
6/1 2011 New release of iCalcreator 2.8
| Release summary: |   |
- new factory-method for creating components
- simplified configuration
- utility (static) functions collected in support class
- refactored sort and selectComponents functions
- multibyte character support (opt. mb_string)
- value (protocol) prefix (Attendee, Organizer etc.)
- a major number of minor bugs fixed e.g. date (UTC), text properties, duration
- updated using manual
As usual, exhaustive regression tests has been executed to verify the release.