JEvents 1.5 (No longer actively supported)

How to export ical

JEvents 2.0 was launched over 2 years ago and the latest stable version is version 2.2 which will run on Joomla 1.5 and Joomla 2.5. JEvents 1.5 is therefore no longer actively supported - you should upgrade to JEvents 2.2+ as soon as possible.
Forum rules
Please include as much detail in any test or bug reports for JEvents 1.5 as possible.

First of all, check if you are running the latest available version of Joomla! and JEvents. Posts for issues, where both systems are not updated, will be ignored.

We need the following at least:

* PHP version (e.g. 5.2.5). Note: Support for PHP4 is discontinued.
* Joomla! version
* JEvents version
* Web Server software (Apache or IIS with version number if possible)
* Server Operating system (e.g. Linux, Windows, Solaris, Darwin ...)
* Database version
* memory_limit from your phpinfo
* Web browser and version

Please enable error reporting and include any error messages in your posting. You do this via the Joomla Configuration - set "error reporting" to "maximum" on the Server tab.

Finally, please describe the steps required to recreate the problem and also please enable error reporting and give us any error messages generated.

Postby PaRunner » Fri Dec 14, 2012 1:16 pm

I am trying to figure out how to export my Jevent calendar with my Google Apps calendar and sync the two. Is this possible?
PaRunner
 
Posts: 96
Joined: Mon Oct 18, 2010 10:35 pm
Location: Pa

Postby Geraint » Fri Dec 14, 2012 2:44 pm

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.
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!
User avatar
Geraint
 
Posts: 42795
Joined: Fri Feb 15, 2008 6:14 pm

Postby PaRunner » Fri Dec 14, 2012 2:50 pm

How to create an ical export menu item?
PaRunner
 
Posts: 96
Joined: Mon Oct 18, 2010 10:35 pm
Location: Pa

Postby Tonyp » Fri Dec 14, 2012 3:05 pm

Create a new menu item.

Regards
Tony
---------------------------------------
Feel free to PM me if you would like Custom Installs or Joomla! related work for a competitive quote.

User avatar
Tonyp
Team Staff
 
Posts: 23650
Joined: Tue Oct 12, 2010 9:12 pm
Location: Isle of Man

Postby jamesbe » Mon Feb 18, 2013 10:54 am

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
jamesbe
 
Posts: 4
Joined: Mon Feb 18, 2013 10:45 am

Postby carcam » Mon Feb 18, 2013 11:42 am

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.
¿Sabías que tenemos soporte en español para los miembros del Club de JEvents? ¡ÚNETE AHORA!
User avatar
carcam
Team Staff
 
Posts: 7074
Joined: Wed Aug 06, 2008 7:50 pm
Location: Almería

Postby jamesbe » Mon Feb 18, 2013 11:47 am

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
jamesbe
 
Posts: 4
Joined: Mon Feb 18, 2013 10:45 am

Postby Geraint » Mon Feb 18, 2013 12:03 pm

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.
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!
User avatar
Geraint
 
Posts: 42795
Joined: Fri Feb 15, 2008 6:14 pm

Postby jamesbe » Mon Feb 25, 2013 2:04 pm

I have a staging evironment for this now. Unfortunately the download doesn't appear to be available via that link.
jamesbe
 
Posts: 4
Joined: Mon Feb 18, 2013 10:45 am

Postby jamesbe » Mon Feb 25, 2013 5:03 pm

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";
}
jamesbe
 
Posts: 4
Joined: Mon Feb 18, 2013 10:45 am

Next

Return to JEvents 1.5 (No longer actively supported)

  • Who is online
  • View new posts
  • View unanswered posts
  • In total there are 2 users online :: 2 registered and 0 hidden (based on users active over the past 5 minutes)
  • Most users ever online was 94 on Tue Sep 01, 2009 12:33 am
  • Users browsing this forum: Bing [Bot], Yahoo [Bot]