SOLVED - ICal export

[obelix1990]

Hello,
I have a problem with Ical export.
I generate a repetitive event (birthday) without hours (tick box), and when I export the birthday category, jevents generate the following file:

BEGIN:VEVENT
UID:494160462fcf3fcd4a2e5e3ac71e4662
CATEGORIES:Anniversaires
SUMMARY:Bon anniversaire Yannick
DESCRIPTION;ENCODING=QUOTED-PRINTABLE:
DTSTAMP;TZID=Europe/Brussels;VALUE=DATE:20111020T100144
DTSTART;TZID=Europe/Brussels;VALUE=DATE:20100106
DTEND;TZID=Europe/Brussels;VALUE=DATE::20100107
SEQUENCE:0
RRULE:FREQ=YEARLY;UNTIL=20200106T235959Z;INTERVAL=1;BYYEARDAY=+006
TRANSP:OPAQUE
END:VEVENT

When I try to import into google, it doesn't work.
The first problem is :: instead of : in DTEND line.
The second, the event is not treated by google except if I remove the ';VALUE=DATE' to have the following:

DTSTAMP;TZID=Europe/Brussels:20111020T100144
DTSTART;TZID=Europe/Brussels:20100106
DTEND;TZID=Europe/Brussels:20100107

Could you help?

Thanks

[Geraint]

I can't see in the code where this second : could be coming from.

Which version of Joomla and JEvents do you have?

[obelix1990]

Hello Geraint,
Thanks for your reply,
I use joomla 1.7 and jevents 2.0.7

[obelix1990]

This is the export result for this event:

Clipboard01.jpg (120.57 KiB) Viewed 489 times

BEGIN:VEVENT
UID:220ea411a77b02b9aad409eefb3b9e1f
CATEGORIES:Anniversaires
SUMMARY:Bon anniversaire Sylvian
DESCRIPTION;ENCODING=QUOTED-PRINTABLE:
DTSTAMP;TZID=Europe/Brussels;VALUE=DATE:20111024T204258
DTSTART;TZID=Europe/Brussels;VALUE=DATE:20101206
DTEND;TZID=Europe/Brussels;VALUE=DATE::20101207
SEQUENCE:0
RRULE:FREQ=YEARLY;COUNT=20;INTERVAL=1;BYYEARDAY=+340
TRANSP:OPAQUE
END:VEVENT

[obelix1990]

For help purpose...
This is an event setting who works correctly (as you can see, the start and end time are in use)

Clipboard01.jpg (120.15 KiB) Viewed 484 times

and this is the calendar.ics result who is correct

BEGIN:VEVENT
UID:220ea411a77b02b9aad409eefb3b9e1f
CATEGORIES:Anniversaires
SUMMARY:Bon anniversaire Sylvian
DESCRIPTION;ENCODING=QUOTED-PRINTABLE:
DTSTAMP;TZID=Europe/Brussels:20111025T090808
DTSTART;TZID=Europe/Brussels:20101206T080000
DTEND;TZID=Europe/Brussels:20101206T170000
SEQUENCE:0
RRULE:FREQ=YEARLY;COUNT=20;INTERVAL=1;BYYEARDAY=+340
TRANSP:OPAQUE
END:VEVENT

This is the same event without start and end time (tick box full day or time not specified). This doesn't work

Clipboard02.jpg (128.38 KiB) Viewed 484 times

and this is the calendar.ics result who is not correct
BEGIN:VEVENT
UID:220ea411a77b02b9aad409eefb3b9e1f
CATEGORIES:Anniversaires
SUMMARY:Bon anniversaire Sylvian
DESCRIPTION;ENCODING=QUOTED-PRINTABLE:
DTSTAMP;TZID=Europe/Brussels;VALUE=DATE:20111025T091430
DTSTART;TZID=Europe/Brussels;VALUE=DATE:20101206
DTEND;TZID=Europe/Brussels;VALUE=DATE::20101207
SEQUENCE:0
RRULE:FREQ=YEARLY;COUNT=20;INTERVAL=1;BYYEARDAY=+340
TRANSP:OPAQUE
END:VEVENT

Thanks for your help....

[Geraint]

Thanks for the detailed explanation - I have found the problem and it will be fixed in version 2.1.0 (out soon). In the meantime you can fix it by changing line 161 of components/com_jevents/views/icals/tmpl/export.php from

Code: Select all

$endformat = ":%Y%m%d";

to

Code: Select all

$endformat = "%Y%m%d";

[obelix1990]

Hello Geraint,
Marvelous, the first problem is solved
For the second one, in line 159 (same file), you wrote:

$alldayprefix = ";VALUE=DATE";

With this line, calendar.ics generate the following:
BEGIN:VEVENT
UID:220ea411a77b02b9aad409eefb3b9e1f
CATEGORIES:Anniversaires
SUMMARY:Bon anniversaire Sylvian
DESCRIPTION;ENCODING=QUOTED-PRINTABLE:
DTSTAMP;TZID=Europe/Brussels;VALUE=DATE:20111025T141225
DTSTART;TZID=Europe/Brussels;VALUE=DATE:20101206
DTEND;TZID=Europe/Brussels;VALUE=DATE:20101207
SEQUENCE:0
RRULE:FREQ=YEARLY;COUNT=20;INTERVAL=1;BYYEARDAY=+340
TRANSP:OPAQUE
END:VEVENT
I you import the event in google, you have the following problem:

Clipboard01.jpg (87.24 KiB) Viewed 479 times

If you place a comment in the line:

// $alldayprefix = ";VALUE=DATE";

calendar. ics become:
BEGIN:VEVENT
UID:220ea411a77b02b9aad409eefb3b9e1f
CATEGORIES:Anniversaires
SUMMARY:Bon anniversaire Sylvian
DESCRIPTION;ENCODING=QUOTED-PRINTABLE:
DTSTAMP;TZID=Europe/Brussels:20111025T142056
DTSTART;TZID=Europe/Brussels:20101206
DTEND;TZID=Europe/Brussels:20101207
SEQUENCE:0
RRULE:FREQ=YEARLY;COUNT=20;INTERVAL=1;BYYEARDAY=+340
TRANSP:OPAQUE
END:VEVENT

Now, as you can see,the google import is working fine:

Clipboard02.jpg (80.35 KiB) Viewed 479 times

Is there a special feature for this line, or it should be removed?

Thanks for your help

[Geraint]

The DTSTAMP field is not a date its a datetime so should not have the VALUE=DATE; piece.

The line

Code: Select all

$html .= "DTSTAMP$tzid$alldayprefix:" . $stamptime . "\r\n";

should not have the $alldayprefix part

Geraint

[obelix1990]

Hello Geraint,
could you confirl that I have to replace the line 184

$html .= "DTSTAMP$tzid$alldayprefix:" . $stamptime . "\n";

by

$html .= "DTSTAMP$tzid:" . $stamptime . "\n";

and uncomment the

$alldayprefix = ";VALUE=DATE";

at line 159

... other thing, I don't have the \r at the end of the line, is it normal?

Thanks

[Geraint]

The \r was added in JEvents 2.0.7 to support Novell calendar software - its is not essential.