I am a total newbie to the whole world of OS. I have no idea how to write code or do all the advanced things that folks on this site can do. I am, however, a quick learner and I need some help.
I used to use a Palm Pre. I now use the EVO Design. I am trying to get 5000 texts between me and my, now, husband off of the Pre to give to him for Valentine's Day. I have gotten as far as extracting the db3s from the Pre and being able to view the texts in the FolderEntry table in SQLite and exporting that table to CSV to view in MS Excel. However - when I open the CSV File in Excel, it dumps ALL the info in to the 'A' column instead of spreading it across A/B/C, etc. Does anyone know how to get it to spread them?
SQLite will not let me select one column to copy/paste to another program. I am thinking my only option is to modify the entire table in SQL to contain only one column and export that to CSV and then opening it with MS Excel. By repeating the process and saving multiple XLSs that contain one table each, I can merge them into multiple columns in one xls file. This is a royal pain in the rear. As skimedickc said, there only appear to be a few columns in the messaging table that have usable info, i.e. the timestamps and the messages. If you know an easier way to extract pertinent info from the db3, PLEASE tell me!
Some random questions:
Is it accurate that when I opened the FolderEntry table, the only things really in there were timestamps and messages with phone numbers as ids? There are no actual dates, names, etc., in the fields correct? Just want to make sure I got a clean extraction of the whole db3 and didn't lose info somehow. Just seem to be a lot of empty fields in that table and an unnecssary waste of space on it.
Would it be constructive to run a compression on the db3? Backing it up first, of course... Will that get rid of all the indexes that have no info listed?
skimedickc: How did you do a save/restore?
Comment: The EpochConverter that Armada listed has a link on the page where you can enter 500 Unix timestamps at a time for conversion. I plan to copy/pasteintotheink/convert/repaste my timestamps into my excel file table so that I have the exact conversion and don't have to mess with excel formulas or figuring out when leap year happened...
Sorry I am so green. I loved my Pre, but I also love my new EVO Design. I am hoping that getting the texts off of my EVO and onto the computer is an easier process. If you know how to do that also, please let me know!
Thanks in advance for your replies/help!!!