PDA

View Full Version : Importing Data to Gpe Contacts


fredoll
12-19-2005, 11:13 AM
Hi,

I finally imported (some of) my contacts into GPE-Contacts from Palm Desktop :
Here is how :
1/ I exported the selected contacts to vcf format (one big file) from Palm Desktop
2/ I wrote a small tool in java that use a vcard parser and generates sql orders (contacts.sql)
3/ get the contacts database from you 770 (~/.gpe/contacts)
4/ get sqlite 2.8 for your environnement (I used linux)
5/ open the data base (sqlite contacts)
6/ run the script (.read contacts.sql)
7/ copy the database (contacts) back to your 770

Phew ...
I now have my contacts on my 770 ...

O Fred

PS : if anyone wants the java tool ... (no magic here but it kind of works ;) )

PPS : I'm planning to do the same for ics file although it is of less use as it's much more volatile ... the best solution would be to have a calendar application capable of reading and at least displaying ics file from webdav ... or use a web calendar ...

andymulhearn
12-19-2005, 12:22 PM
I did the same with a very manual process, though Apple's Address book exports multiple 2.1 vcfs as multiple files.You then just have to open them manually from within contacts - your SQL method sounds much more attractive :)

I'd appreciate the contacts parser if you wouldn't mind sending it....

And on the subject, whatever you do, don't forget to backup the database before a flash upgrade. The standard backup applet doesn't copy the contents of the .gpe directory, unless there's some magic I didn't see when I backed up :(

Reggie
12-19-2005, 12:34 PM
I hope you can add the parser at the software area so it won't get lost. If you need itT to host the file let me know (PM me).

Thanks.

fredoll
12-20-2005, 11:10 AM
Thanks to Reggie, the file is hosted on InternetTabletTalk
here is the URL : http://www.internettablettalk.com/files/vcf2contactsSql.zip
As usual, it comes with no garanty at all ! it may even make the sky fall ... who knows !
Fred