[maemo-users] Forced Upgrade to N900 from N810

[From: Peter Flynn]

Graham Cobb wrote:
> Peter Flynn <peter.flynn at mars.ucc.ie> wrote:
>> Presumably as it's an SQLite file, there must be a GUI or CL
>> interface to let me open the database and delete from <table>
>> where date<20081231 or something. Do you have pointers to
>> something suitable?
>
> n900's come with the sqlite3 commandline program by default.
> it's an easy program :)
> 
> Unfortunately GPE is still using sqlite0 (also known as sqlite or sqlite2).  
> sqlite3 cannot read the database.

[N800]

I scp'd the calendar file to my Ubuntu desktop machine and installed 
sqlite. Now I can open the database and dump it out.

Exporting the contacts was easy as gpe-contacts on the N800 provides for 
that with an Export function, so my contacts are now available in other 
systems.

I need to get the calendar into iCal format so I can import them into 
other systems too. Unfortunately gpe-calendar appears only to be able to 
export one event at a time to a .ics file (or is there a way to select 
all and export them?).

Does anyone know a good way to convert the calendar file (or an SQL dump 
of its contents) into a .ics file? Perhaps via some other app that reads 
the file and has an Export All function? Or am I going to have to write 
something?

How have others migrated their calendar data to elsewhere?

///Peter