Results 1 to 13 of 13

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


Thread: Dumping notes and SMS

  1. #1
    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

  3. #3
    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
    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
    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
    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
    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
    Cool great!
    very genius.. thanks mate!

  11. #10
    how do you open the sms.db file?

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

  13. #12
    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
  •