TreoCentral.com - View Single Post - Palm Profile Contacts inaccessible solution

ernzo · 10/26/2009, 12:19 PM

Those with MUCH more savvy feel free to hijack this post!

More or less, yes. Remember that your contacts ought to also be backed up to the Palm server anyway.....

If you want to go further, I downloaded a program called sqlitebrowser
SQLite Database Browser | Get SQLite Database Browser at SourceForge.net

This tool allows you to access and export the specific data file (the file palmdatabse.db3 contains a ton of data besides your contacts) as a CSV file for importation to excel or other tools.

Here is another useful link that will tell you how to access the specific file in SQL

PalmDatabase.db3 File - WebOS Internals

In fact, I just noticed that this link (above) pretty much caches out the entire routine! You see, I am NOT a SQL guy, I am not a script guy etc. I was lost reading these things, so I wanted a way to do this that a bonehead like me could do!!

I installed sqlite, asked it to open the palmdatabase.db3 file (you ought to see a big directory) I went to File and Export (table as CSV) pointed to com_palm_pim_Contact and exported it to my desktop.

10/26/2009, 12:19 PM	#8 (permalink)
ernzo Member Join Date: Jul 2009 Location: Colorado Posts: 6 Thanks: 5 Thanked 5 Times in 2 Posts	Those with MUCH more savvy feel free to hijack this post! More or less, yes. Remember that your contacts ought to also be backed up to the Palm server anyway..... If you want to go further, I downloaded a program called sqlitebrowser SQLite Database Browser \| Get SQLite Database Browser at SourceForge.net This tool allows you to access and export the specific data file (the file palmdatabse.db3 contains a ton of data besides your contacts) as a CSV file for importation to excel or other tools. Here is another useful link that will tell you how to access the specific file in SQL PalmDatabase.db3 File - WebOS Internals In fact, I just noticed that this link (above) pretty much caches out the entire routine! You see, I am NOT a SQL guy, I am not a script guy etc. I was lost reading these things, so I wanted a way to do this that a bonehead like me could do!! I installed sqlite, asked it to open the palmdatabase.db3 file (you ought to see a big directory) I went to File and Export (table as CSV) pointed to com_palm_pim_Contact and exported it to my desktop.