Script to migrate your Palm Pre's contacts from your Palm Profile to Google gMail contacts. FOR FREE!
MvPre2Gmail
The script does everything mentioned at
PalmDatabase.db3 File - WebOS Internals and is performed on a backup copy of the Palm Database, PalmDatabase.db3.
What this script does not do:
It will
not remove the contacts from your Palm Pre Profile.
It will
not remove the Gmail account from your Pre's Contacts App.
It will
not migrate more than 3 emails or 3 phone numbers per contact.
It will
not separate facebook, gmail, or palm pre contacts. It migrates ALL contacts.
UPDATE: Run delete_contacts.sql on your live PalmDatabase.db3 to delete all your contacts from your Palm Pre Profile prior to adding and syncing your Gmail account with your Palm Pre.
There are some error handling and checking to see if certain things are installed or not [root access, filesystem rw, sqlite3, and perl].
Some assumptions are made... You've rooted your Pre, Installed Optware-bootstrap and Quilt per webos-internals.org 'Next Steps'....[needed for ipkg-opt]
Would love for ppl to try it out and give me feed back. I have some ideas on how to improve the script further. I'll wait to hear what ppl think so far tho.
Installation/Usage:
1. download zip file and extract.
2. copy the file to root on the Palm Pre [WebOS QI or sFTP or via USB drive]
3. Log into Pre as root and make file executable chmod 755 MvPre2Gmail
4. Run MvPre2Gmail
I've also attached my googlecsv. This shell script automagically generates a copy of this Perl script. Had to give it a TXT extension to upload it. Remove that if you chose to modify and use it.
My contacts are all in the Google Cloud now!!
Credit for this script goes to Hopspitfire, DCPedit, and wsobel over at webos-internals....
PalmDatabase.db3 File - WebOS Internals
UPDATE: Added the line [code]print SQLDEL ".load /usr/lib/sqlite3_palm_extension.so\n";[/code] to the MvPre2Gmail script in the section where the googlecsv script is created. Both files have been updated to reflect this change.
If you run, delete_contacts.sql [automagically generated] on your live PalmDatabase.db3 file, it will
successfully remove all your contacts from your Palm Pre Profile!! You will
NOT have to manually delete
ALL of the Pre contacts one by one. PLEASE BE CAREFUL WITH THIS. Make sure your contacts are accurate and have been successfully uploaded to Gmail and run delete_contacts.sql prior to adding your Gmail account to your Pre's contact app.