iCalcnv

iCalcnv is a PHP utility package containing functions for converting iCal files to xls and csv format and from csv format to iCal.

All functions support local and remote iCal/csv input files.

Default is to redirect output to browser with option to save file to disk.

The csv2iCal function makes it possible to create a time schedule or plan in a spreadsheet, "save-as" a csv file, convert file to iCal format using the csv2iCal function and update a calendar application.

The iCal2csv function converts from iCal to csv file format.

The iCal2xls function converts iCal to spreadsheet xls file format and is using PEAR Spreadsheet_Excel_Writer-0.9.1 and OLE-1.0.0RC1.

iCalcnv may use PEAR Log or eClog packages (included).

iCalcnv also includes two functions, "fileCheckRead" and "fileCheckWrite", checking (local) files read- and writeability.

Definition of csv can be found at wikipedia.org/wiki/Comma-separated_values

To get a proper understanding of iCal, explore the RFC2445, download here.

iCal to xls/csv

Input file format to functions iCal2xls and iCal2csv is an iCal RFC2445 file (*.ics). Output file format are xls/csv formatted and are row oriented. The xls format file is ISO-8859-1 encoded.

Using the "conf" parameter supports
 map of iCal property names to user friendly column names,
 order output columns,
 iCal properties to skip from output.

First comes rows with product, date and file information, then opt. calendar properties like METHOD, CALSCALE and X-PROPerties with name and value.

Next comes opt. timezone/standard/daylight components in row order, with a leading header row, every component in a separate row, every property in a separate column, starting with columns for component type and order.

The event components (vevent/vtodo/vfreebusy/vjournal and corresponding valarms) are also presented in row order, with a leading header row, like the timezone part above, components in rows and their properties in separate columns, also starting with columns for component type and order.

xls/csv to iCal

When converting from xls format to iCal, use spreadsheet application function "save-as" a CSV file and select , if possible, field separator comma  , , field delimiter double quote  "  and, if selectable and also depending on PHP configuration and platform,  UTF-8  as character set.

Input csv file format to function csv2iCal is actually output csv file format above. Output file format is an iCal RFC2445 file (*.ics).

Using the "conf" parameter supports map of user friendly column names to iCal property names.

Free images

Roadmap

New release of eventCreator (2.4), using the new features from iCalcreator 2.6 and will support
- parsing and editing of existing iCal files and included events
- using iCalcnv package to allow import csv and export csv/xls files.
- creation of iCal file and events
- event alarms and recurrent events
- extended Ajax support.

New release of eventManager, a port of eventCreator (2.4) to Joomla.

Minor bug fix/function improvement releases of iCalcreator.

Next major release (3.x) of iCalcreator is a PHP 5.x, more strict object-oriented, refactored version.