festivals wiki ical

[tob...@tango.info]

Peter Forret

could you give a template of an .ics showing what you would like to have?

I think I can provide
- city coor
- city name
- time start + time end
- a name (would probably be the wiki title)

is this of any use?

tobias

--
Tobias Conradi
Rheinsberger Str. 18
10115 Berlin, Germany

http://info.tango.info http://eng.tango.info
http://festivals.tango.info http://videos.tango.info
http://wiki.tango.info

[Peter Forret]

That would be great actually.

What I get now from my Gmail Calendar is

BEGIN:VEVENT

DTSTART;TZID=Europe/Paris:20071202T170000

DTEND;TZID=Europe/Paris:20071202T220000

DTSTAMP:20071109T100007Z

UID:o9rt0p6pl36dg...@google.com

CLASS:PUBLIC

CREATED:20071109T094930Z

DESCRIPTION:Organisation: Tangoteca - http://users.pandora.be/tangoteca/mil

onga\nContact: tangotec...@telenet.be -\nAdmission: 5 euro

LAST-MODIFIED:20071109T094930Z

LOCATION:De Braempoort\, Vlaanderenstraat\, 30-40\, 9000 Gent

SEQUENCE:0

STATUS:CONFIRMED

SUMMARY:MILONGA: Milonga de la Tangoteca @ Gent

TRANSP:OPAQUE

END:VEVENT

What is necessary:
DTSTART - DTEND
SUMMARY: festival name
LOCATION (city, country would be OK)
DESCRIPTION: link to your site, link to Google Maps, ...

I would then sync it hourly (like I do with GCAL) and visualize it
through agenda.milonga.be !

Peter

--
Peter Forret
http://blog.forret.com
http://www.milonga.be
email: pe...@forret.com
gsm: +32-497-479851

[tob...@tango.info]

thx for the GCAL example.

> What is necessary:
> DTSTART - DTEND
> SUMMARY: festival name
> LOCATION (city, country would be OK)
> DESCRIPTION: link to your site, link to Google Maps, ...

this is not much. great ! :-)

Nevertheless, I am not the fastest ;-)

Tobias

[tob...@tango.info]

basic data comes now (not ical format yet, but this would be easy):
http://x.tango.info/php/wiki_ical.php

currently DTrange is only stored in the name which is not so good for SQL

DTrange is everything (numbers and hyphens) before the first underscore

2007-10-12--14_Festival_Karlsruhe
2007-05-30--06-03_Festival_Sydney
2007-12-07--2008-01-06_Festival_Roma

one probably does not want to retrieve all festivals, what do you think?

currently I could filter with regex on DTSTART (^...) and probably
DTEND (--....)

But I think one cannot say > or < with regex. Right?

i think i have to look how to run a cron job or so. I think it is best
to create a table that has DTSTART and DTEND for each wikiarticle
who's name starts with a DTrange (timerange of event). Then one could
show all festivals in a DTrange (timerange of calendar view).

I could also let sql retrieve all and then filter with php, but this
seems not very clean and consumes more CPU.

tobias

> > What is necessary:
> > DTSTART - DTEND
> > SUMMARY: festival name
> > LOCATION (city, country would be OK)
> > DESCRIPTION: link to your site, link to Google Maps, ...

--

[tob...@tango.info]

I solved the problem, to detect when a new wiki article is created.

I still need to figure out some stuff, but now I am closer to always
have the wiki-event-titles parsed and a meta table by in sync with the
wiki.

The metatable currently stores
geo, dtstart, dtend, the wiki page title

geo can be :
- AR country ISO 3166-1
- ARBUE city UN/LOCODE
- ARBUE-CS venue

dtstart, dtend currently only handles dates, time can be added later.

see examples of page titles
http://wiki.tango.info/events/show3.php

todo:
1) figure out which keywords to use: milonga, show/performance,
workshop/s, festival, marathon,
start, end, outdoor

2) repeated events