How to export ical

[PaRunner]

I am trying to figure out how to export my Jevent calendar with my Google Apps calendar and sync the two. Is this possible?

[Geraint]

Create an iCal export menu item and then select all the years and categories. Then you will get a link which you can clickk and copy the URL which you can then use to import into Google calendar.

[PaRunner]

How to create an ical export menu item?

[Tonyp]

Create a new menu item.

Regards
Tony

[jamesbe]

I have a site (joomla 1.5.2) with the JEvents plugin 1.5alpha July 2007 and need to export all events to iCal or CSV.

I keep reading in all the search results on this topic that you need to "create an export menu item" but I am unable to find this option in the menu manager.

Any help would be appreciated.

Thanks,
James

[carcam]

Hi James,
ical export was not introduced into JEvents till version 1.5.3, so you need to upgrade your JEvents installation at least to that version.

The older version we have available is 1.5.5:

http://www.jevents.net/downloads/catego ... events-155

so you may try it, but please be sure to take a backup of your site first as you are in a really old and unsecure version of Joomla! and a very old version of JEvents and unexpected errors might appear.

Actually it would be safer to restore the site in a testing environment and try the update there.

[jamesbe]

OK thanks,
It might be best to export the events directly to CSV from the database. What tables would I be looking for in the Joomla database?

Thanks,
James

[Geraint]

Hi James

There are several interconnected database tables and it is is NOT easy to inject data directly. That is why we provide the mechanism to import events from a CSV file.

The db tables all have vevent or jev in the table names.

[jamesbe]

I have a staging evironment for this now. Unfortunately the download doesn't appear to be available via that link.

[jamesbe]

I ended up writing a little perl script to export events from the jos_events database table.

If anyone ends up here looking for a way to export CSV from an old JEvents version you can use the following perl script. In my case I am outputting a format that can be used to migrate events to Google apps calendar.

It can be used like so: (where 57 is the category ID to be exported)

Code: Select all

./export_events.pl 57 > events.csv


Code: Select all

#!/usr/bin/perl
use strict;
use warnings;

use DBI;
use DateTime;

my $dbh = DBI->connect('DBI:mysql:joomla;host=localhost', 'USERNAME', 'PASSWORD',{ RaiseError => 1 }) or die "Can't connect to DB: $DBI::errstr\n";

my $results = $dbh->selectall_hashref("SELECT id, title, publish_up, publish_down, content from jos_events where catid=$ARGV[0] order by id asc",'id');

print "Subject,Start Date,Start Time,End Date,End Time,All Day Event,Description,Private\n";

foreach my $id (keys %$results) {
        my ($yy, $mm, $dd, $h, $m, $s) = $results->{$id}->{publish_up} =~ /(\d{4})-(\d{2})-(\d{2}) (\d{2}):(\d{2}):(\d{2})/;
        my $start = DateTime->new(
                year => $yy,
                month => $mm,
                day => $dd,
                hour => $h,
                minute => $m,
                second => $s);

        my $all_day="False";

        my ($yy2, $mm2, $dd2, $h2, $m2, $s2) = $results->{$id}->{publish_down} =~ /(\d{4})-(\d{2})-(\d{2}) (\d{2}):(\d{2}):(\d{2})/;
        my $parsed_end = DateTime->new(
                        year => $yy2,
                        month => $mm2,
                        day => $dd2,
                        hour => $h2,
                        minute => $m2,
                        second => $s2);
        my $end;

        if( $start->compare_ignore_floating( $parsed_end ) == 0 ) {
                $all_day="True";
                $end = $start;
                $end->add( DateTime::Duration->new( hours => 12 ) );
        }
        else {
                $end = $parsed_end;
                my $diff = $start->delta_days($end);
                if($diff->days() > 0) {
                        $all_day="True";
                }
        }

        print "$results->{$id}->{title},";
        print $start->strftime("%D");
        print ",";
        print $start->strftime("%I:%M:%S %p");
        print ",";
        print $end->strftime("%D");
        print ",";
        print $end->strftime("%I:%M:%S %p");
        print ",$all_day,$results->{$id}->{content},False\n";
}