+ Reply
Results 1 to 13 of 13

Your favorite Apple, iPhone, iPad, iOS, Jailbreak, and Cydia site.


Thread: Dumping notes and SMS

is a discussion within the

Windows Specific Modding Discussion

forums, a part of the

Computer Modding Software

section;
I have sqlite, but I'm horrible at this kind of stuff. I've been trying for a while and so far all I can get is a blank txt file. Can
...
  1. #1
    Retired Moderator Dash-2's Avatar
    Join Date
    Jul 2007
    Location
    Oregon
    Posts
    2,080
    Thanks
    79
    Thanked 222 Times in 184 Posts

    Default Dumping notes and SMS
    I have sqlite, but I'm horrible at this kind of stuff.
    I've been trying for a while and so far all I can get is a blank txt file.

    Can someone help me dump the notes and SMS databases to a txt file?!

  2. #2
    Retired Moderator Dash-2's Avatar
    Join Date
    Jul 2007
    Location
    Oregon
    Posts
    2,080
    Thanks
    79
    Thanked 222 Times in 184 Posts

    Anyone?

  3. #3
    iPhone? More like MyPhone
    Join Date
    Sep 2007
    Posts
    106
    Thanks
    2
    Thanked 9 Times in 7 Posts

    oh man..
    if u want to extract the info, u need to know the field names, type of value, relationship, and all the info.
    maybe if u looked into the .db file hard enough, u will find the info there.
    im not about to try ... too tedious ... gosh ..

    try using Apple's FileMaker (a DBMS)
    Best Regards

  4. #4
    iPhone? More like MyPhone
    Join Date
    Aug 2007
    Posts
    207
    Thanks
    0
    Thanked 12 Times in 10 Posts

    1. Download this http://www.sqliteexpert.com/download.html
    2.open sms.db
    3. Click on SQL tab
    4. type in select * from message
    5. click in the table control A "select all"
    6. control C "copy
    7. open excel
    8. Contol V paste
    9. Export to whatever you want

  5. The Following 2 Users Say Thank You to freshfitz For This Useful Post:

    Dash-2 (09-16-2007), smiileNnod (07-24-2010)

  6. #5
    Retired Moderator Dash-2's Avatar
    Join Date
    Jul 2007
    Location
    Oregon
    Posts
    2,080
    Thanks
    79
    Thanked 222 Times in 184 Posts

    Thanks a ton freshfitz

  7. #6
    Livin the iPhone Life aziatiklover's Avatar
    Join Date
    Sep 2007
    Location
    Welcome to Jamrock
    Posts
    1,337
    Thanks
    37
    Thanked 62 Times in 61 Posts

    nice
     Think Different

  8. #7
    Green Apple
    Join Date
    Aug 2007
    Posts
    63
    Thanks
    7
    Thanked 5 Times in 5 Posts

    according to the website you need professional to export a file. with the free version you can't.

    http://www.sqliteexpert.com/features.html

  9. #8
    Retired Moderator Dash-2's Avatar
    Join Date
    Jul 2007
    Location
    Oregon
    Posts
    2,080
    Thanks
    79
    Thanked 222 Times in 184 Posts

    After I run the script it out puts it all in the program, I then copy it to an Excel document.



    Flag 2 is my girlfriend, Flag 3 is mine. (Don't know why it's named that way but it works..)

  10. #9
    What's Jailbreak? gviterbo's Avatar
    Join Date
    Oct 2007
    Location
    Philippines
    Posts
    7
    Thanks
    9
    Thanked 1 Time in 1 Post
    Cool great!
    very genius.. thanks mate!

  11. #10
    What's Jailbreak?
    Join Date
    Jun 2008
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    how do you open the sms.db file?

  12. #11
    What's Jailbreak?
    Join Date
    Mar 2008
    Posts
    14
    Thanks
    2
    Thanked 0 Times in 0 Posts

    When I paste into excel nothing happens. Anybody else have this problem?

  13. #12
    What's Jailbreak?
    Join Date
    Mar 2008
    Posts
    14
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Can someone just PM me some help?

  14. #13
    What's Jailbreak?
    Join Date
    Jul 2008
    Location
    Illinois
    Posts
    7
    Thanks
    0
    Thanked 2 Times in 1 Post
    Hello Everyone,
    Well my jailbreaking of 2.01 did not quite go as planned. Don't get me wrong the process was almost a complete success. Everything is there after doing a backup restore, except for a lot of my sms and notes. iTunes on my PC won't let me select on older backup; however, I did find a decent backup on my laptop that itunes will let me use. I was able to use various tools (mobilesync-inspect for Windows by Lukhnos D. Liu mobilesync-inspect - Google Code and SQLite Expert SQLite Expert - SQLite Database Administration Tool) to extract my sms and notes databases out of the backup files and view my data. Now I have old stuff from an older backup, new stuff from my most recent backup and some stuff that shows up in both backups. My question is how do I go about merging the data. I tried using the Data Transfer Wizard from within SQLite Expert, but get errors when I leave the default options checked. Has anyone attempted to merge the data from one database to another and can you describe how you did it?
    Thanks,
    -Cruce

Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts