[maemo-users] Forced Upgrade to N900 from N810

From: Peter Flynn peter.flynn at mars.ucc.ie
Date: Wed Feb 3 01:37:54 EET 2010
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.


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 

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 

How have others migrated their calendar data to elsewhere?

More information about the maemo-users mailing list