Active Topics

 


Reply
Thread Tools
Posts: 9 | Thanked: 12 times | Joined on May 2016
#181
Originally Posted by juiceme View Post
It is not difficult, no. In the contrary it is amazingly simple, easier than on any other platforms I have ever done it. (well, except on SFOS which is pretty much the same thing as on Harmattan...)

Proof-of-my-point:
  • I tried to back up SMS'es from my wife's Lumia device, and it is absolutely impossible!
    There is no application to do it, and no access to any kind of command line either! Absolutely impossible!
    The only way to do it is to copy and paste each bloody SMS message manually to evernote client... You bet this takes time if there are lots of messages...
  • I also needed to do this to a friend's Samsung Android device, and yes, of course it was unrooted!
    I had to wrestle with the damn device a fair while to find a way to get at the SMS storage without accidentally wiping it while in the process...
  • Apple IOS devices... I have no idea! (never had to try that on IOS, lucky me...)

On harmattan you don't even need any application to do that. Of course you can use SMSBoat which is pretty neat way to do it but you can also do without any external tools; The SMS database is plain sqlite which you can dump in text mode by a simple query script
Ok, I stand corrected, Meego is the easier option overall. I'm glad I'm not dealing with any of those other OS's. Though dealing with my own N9 is a challenge for me as I'm no programmer.

Not sure what I'm going to do. If I could get pc suite of nokia suite going again that would be another option.

Cheers for all the advice.
 

The Following User Says Thank You to N9er For This Useful Post:
Community Council | Posts: 4,920 | Thanked: 12,867 times | Joined on May 2012 @ Southerrn Finland
#182
Originally Posted by N9er View Post
Ok, I stand corrected, Meego is the easier option overall. I'm glad I'm not dealing with any of those other OS's. Though dealing with my own N9 is a challenge for me as I'm no programmer.

Not sure what I'm going to do. If I could get pc suite of nokia suite going again that would be another option.

Cheers for all the advice.
I can post a script to dump the message database when I get home, am on the road now.

--- edit ---

Now I have to confess I just cannot find the script I used to pull the complete SMS dump from the database. I sure had a few lines of bash that I used to get a CSV dump...

You can get just the SMS text (without dates or phone numbers) by
Code:
tracker-sparql -q "select nie:plainTextContent(?d) where {?d a nmo:SMSMessage}"

Last edited by juiceme; 2016-05-17 at 17:26. Reason: added info
 

The Following 2 Users Say Thank You to juiceme For This Useful Post:
Posts: 9 | Thanked: 12 times | Joined on May 2016
#183
Originally Posted by juiceme View Post
"Now I have to confess I just cannot find the script I used to pull the complete SMS dump from the database. I sure had a few lines of bash that I used to get a CSV dump.."[/CODE]
Thanks for looking. Shame it's vanished as that would've been worth trying. If it turns up or you remember where it is, please post here or IM me as I want all data (phone numbers, dates etc). Cheers
 

The Following 2 Users Say Thank You to N9er For This Useful Post:
Posts: 986 | Thanked: 1,526 times | Joined on Jul 2010
#184
ive got two wrapper perl scripts that i run, one for sms/call backuprestore, and one for n9Export

here are the files out of my n9 repo (they should be run on the n9):
https://github.com/teleshoes/n9-conf...ackup-comm-n9e
https://github.com/teleshoes/n9-conf...ckup-comm-scbr

(at the time of writing, master is 46406cc)

also, i will gladly distribute the binary and face the legal wrath of merlin1991, who posted the sourcecode with no license or copyright.

of course, dont run this binary if you dont trust me, and you do so at your own risk.

https://github.com/teleshoes/n9-conf...S/bin/n9Export
__________________
~ teleshoes ~
 

The Following 3 Users Say Thank You to wolke For This Useful Post:
Posts: 9 | Thanked: 12 times | Joined on May 2016
#185
Originally Posted by N9er View Post
Thanks for looking. Shame it's vanished as that would've been worth trying. If it turns up or you remember where it is, please post here or IM me as I want all data (phone numbers, dates etc). Cheers
Anyone else got this CSV dump code? Chime in if you have. Cheers
 

The Following 2 Users Say Thank You to N9er For This Useful Post:
Posts: 9 | Thanked: 12 times | Joined on May 2016
#186
Originally Posted by wolke View Post
ive got two wrapper perl scripts that i run, one for sms/call backuprestore, and one for n9Export

here are the files out of my n9 repo (they should be run on the n9):
https://github.com/teleshoes/n9-conf...ackup-comm-n9e
https://github.com/teleshoes/n9-conf...ckup-comm-scbr

(at the time of writing, master is 46406cc)

also, i will gladly distribute the binary and face the legal wrath of merlin1991, who posted the sourcecode with no license or copyright.

of course, dont run this binary if you dont trust me, and you do so at your own risk.

https://github.com/teleshoes/n9-conf...S/bin/n9Export
Thanks Wolke, I'll look at this. Cheers
 

The Following 2 Users Say Thank You to N9er For This Useful Post:
Posts: 228 | Thanked: 100 times | Joined on May 2010 @ Australia
#187
Originally Posted by wolke View Post
ive got two wrapper perl scripts that i run, one for sms/call backuprestore, and one for n9Export

here are the files out of my n9 repo (they should be run on the n9):
https://github.com/teleshoes/n9-conf...ackup-comm-n9e
Thanks for this Wolke - I tried running and of course needed the Date:Format and Date:Parse perl modules. I tried from CPAN and that didn't work. Anywhere I can grab them myself?
Compiling them on device leads to a rabbit warren of build dependencies....

managed to just install MAKE and all is working so far...

Last edited by skyjumper; 2016-05-19 at 02:13. Reason: found a soln
 

The Following 2 Users Say Thank You to skyjumper For This Useful Post:
Posts: 986 | Thanked: 1,526 times | Joined on Jul 2010
#188
Originally Posted by skyjumper View Post
Thanks for this Wolke - I tried running and of course needed the Date:Format and Date:Parse perl modules. I tried from CPAN and that didn't work. Anywhere I can grab them myself?
Compiling them on device leads to a rabbit warren of build dependencies....
lol yea sry, these are my own personal scripts and 'rabbit warren' perfectly describes the situation there...

anyway, all the perl modules that i depend on for anything are here in my openrepos:
https://openrepos.net/users/teleshoes

you can either download the debs and install directly, or add `deb http://harmattan.openrepos.net/teleshoes personal main` to your apt sources, or use 'warehouse' or whatever it is the cool kids are doing.

the package in question is something like libdate-time-perl, IIRC
__________________
~ teleshoes ~
 

The Following 2 Users Say Thank You to wolke For This Useful Post:
Posts: 1,038 | Thanked: 3,980 times | Joined on Nov 2010 @ USA
#189
Originally Posted by juiceme View Post
You can get just the SMS text (without dates or phone numbers) by
Code:
tracker-sparql -q "select nie:plainTextContent(?d) where {?d a nmo:SMSMessage}"
FYI, if one's texts are MMSs instead -- like sometimes group texts show up as even though they don't contain multimedia -- you can replace the "SMSMessage" fieldname with "MMSMessage" to get the text content of those.
 

The Following User Says Thank You to robthebold For This Useful Post:
Community Council | Posts: 4,920 | Thanked: 12,867 times | Joined on May 2012 @ Southerrn Finland
#190
Originally Posted by robthebold View Post
FYI, if one's texts are MMSs instead -- like sometimes group texts show up as even though they don't contain multimedia -- you can replace the "SMSMessage" fieldname with "MMSMessage" to get the text content of those.
Yes. And if I recall correctly the actual media content of the MMS'es (whether it be pictures/video/sound) is not stored in tracker but to a separate directory in the filesystem...
 

The Following User Says Thank You to juiceme For This Useful Post:
Reply


 
Forum Jump


All times are GMT. The time now is 11:43.