 |
 |
Way to copy text message SMS conversations from iPhone to Mac text file?
|
|
|
|
|
Dedicated MacNNer
Join Date: May 2003
Location: Chicago
Status:
Offline
|
|
Is there a low-level utility out there to be able to go into my text messages with a significant other
and save or copy as a text, PDF, rtf file etc?
I see missing sync possibly but all I need is that one function and was hoping for a free utility app that can pull that off.
thanks!
|
|
|
| |
|
|
|
|
|
|
|
Posting Junkie
Join Date: Jun 2001
Location: Chicago, Bang! Bang!
Status:
Offline
|
|
IIUC, your SMS log is a MySQL database, so you need something which can read that. If not, it may be easier to just pay for an app.
|
|
|
| |
|
|
|
|
|
|
|
Clinically Insane
Join Date: Mar 2001
Location: yes
Status:
Online
|
|
MySQL, are you sure about that? I'd bet on SQLite...
If you want to access the database directly you'd have to Jailbreak the phone and install OpenSSH, right?
|
|
|
| |
|
|
|
|
|
|
|
Administrator  Join Date: Apr 2001
Location: San Antonio TX USA
Status:
Offline
|
|
What about accessing this stuff from an iPhone's backup files on the Mac? Or are SMS messages part of the backup?
|
|
Glenn -----
OTR/L, MOT, Tx
|
| |
|
|
|
|
|
|
|
Posting Junkie
Join Date: Jun 2001
Location: Chicago, Bang! Bang!
Status:
Offline
|
|
AFAICT, they're in the backup, so I don't think you need to jailbreak it.
|
|
|
| |
|
|
|
|
|
|
|
Posting Junkie
Join Date: Jun 2001
Location: Chicago, Bang! Bang!
Status:
Offline
|
|
Originally Posted by besson3c 
MySQL, are you sure about that? I'd bet on SQLite...
Yup. It's SQLite. My bad.
|
|
|
| |
|
|
|
|
|
|
|
Administrator Join Date: Apr 2001
Location: San Antonio TX USA
Status:
Offline
|
|
So just find the backup file and use SQLite to query for the other person's name/number/address? I ask because this is something I've been looking at doing (for reasons similar to the OP's) and while there seem to be apps aplenty for Windows, it's kind of quiet in the Mac app world when it comes to this subject.
|
|
Glenn -----
OTR/L, MOT, Tx
|
| |
|
|
|
|
|
|
|
Clinically Insane
Join Date: Mar 2001
Location: yes
Status:
Online
|
|
Originally Posted by ghporter
So just find the backup file and use SQLite to query for the other person's name/number/address? I ask because this is something I've been looking at doing (for reasons similar to the OP's) and while there seem to be apps aplenty for Windows, it's kind of quiet in the Mac app world when it comes to this subject.
Yes, it will take some work, but this is pretty much what you have to do once you've found the flat file DB.
|
|
|
| |
|
|
|
|
|
|
|
Posting Junkie
Join Date: Jun 2001
Location: Chicago, Bang! Bang!
Status:
Offline
|
|
In: ~/Library/Application Support/MobileSync/Backup you'll have one folder for each backed-up iDevice, with a giant hex number as a name.
Once you figure out which one is your phone, the file you want inside that folder is: 3d0d7e5fb2ce288813306e4d4636395e047a3d28
|
|
|
| |
|
|
|
|
|
|
|
Administrator Join Date: Apr 2001
Location: San Antonio TX USA
Status:
Offline
|
|
That file starts with the signature "SQLite format 3@ F="
(rubs hands, gets ready to dig in...)
|
|
Glenn -----
OTR/L, MOT, Tx
|
| |
|
|
|
|
|
|
|
Administrator Join Date: Apr 2001
Location: San Antonio TX USA
Status:
Offline
|
|
And as it turns out, there's an add-in for Firefox that reads SQLite databases...
This was smoother and quicker than I expected.
|
|
Glenn -----
OTR/L, MOT, Tx
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
 
|
|
|
Forum Rules
|
|
|
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
|
HTML code is Off
|
|
|
|
|
|
|
|
|
|
|
|
|
Top
