maemo.org - Talk - A command-line tool for SMS backup and restore

maemo.org - Talk (https://talk.maemo.org/index.php)

- Nokia N9 / N950 (https://talk.maemo.org/forumdisplay.php?f=51)

- - A command-line tool for SMS backup and restore (https://talk.maemo.org/showthread.php?t=83166)

Re: A command-line tool for SMS backup and restore

Quote:

Originally Posted by wolke (Post 1518867)

you just have to run it with the full path to it:
/home/user/n9Export a.sms
~/n9Export a.sms
etc

Thanks. Now I get "permission denied". As user or as root. Well this is progress anyway.

Re: A command-line tool for SMS backup and restore

hahahah
chmod +x /home/user/n9Export

watch, theres gonna be like 2 more things im just taking for granted that i shouldnt be

Re: A command-line tool for SMS backup and restore

Quote:

Originally Posted by wolke (Post 1518883)

hahahah
chmod +x /home/user/n9Export

watch, theres gonna be like 2 more things im just taking for granted that i shouldnt be

Thanks. I thought that there could be something like this.

I was more comfortable in doing things like making something executable during the N900 times. With N9 (Aegis and all) I have visited command line not-so-frequently which has led me to forget most of the basics...

But now it worked! I have a HUGE .csv with my 21742 SMSs. Might be a record :D

Re: A command-line tool for SMS backup and restore

yay!
btw you get silver

Code:

wolke:~/Code/s5/backup/backup-sms/bak$ wc -l all.sms

45664 all.sms

Re: A command-line tool for SMS backup and restore

Does anyone know where the internal backup program of the N9 store the backed up SMS? Seems like the backup folder that is created to Mydocs contains only the MMS. Which is strange, why are SMS stored someplace else?

Re: A command-line tool for SMS backup and restore

Quote:

Originally Posted by OVK (Post 1519196)

Does anyone know where the internal backup program off the N9 store the backed up SMS? Seems like the backup folder that is created to Mydocs contains only the MMS. Which is strange, why are SMS stored someplace else?

IIRC the SMS'es are stored in the commhistory DB, so it makes sense that is where the backup is also. :D
MMS'es are handled differently because the media attachments are stored in the filesystem.

Re: A command-line tool for SMS backup and restore

Now this is strange. Backing up messages was working just fine for a while but now I am only getting the following error:

Quote:

$ /home/user/n9Export sms2.csv
"GDBus.Error:org.freedesktop.DBus.Error.AccessDeni ed: Rejected send message, 2 matched rules; type="method_call", sender=":1.106" (uid=29999 pid=3379 comm="/home/user/n9Export sms2.csv ") interface="org.freedesktop.Tracker1.Steroids" member="Query" errorname="(unset)" requested_reply=0 destination="org.freedesktop.Tracker1" (uid=29999 pid=1254 comm="/usr/lib/tracker/tracker-store "))"
# sms: 0
QTrackerDirectSelectResult: QSparqlError(9, "GDBus.Error:org.freedesktop.DBus.Error.AccessDeni ed: Rejected send message, 2 matched rules; type="method_call", sender=":1.106" (uid=29999 pid=3379 comm="/home/user/n9Export sms2.csv ") interface="org.freedesktop.Tracker1.Steroids" member="Query" error name="(unset)" requested_reply=0 destination="org.freedesktop.Tracker1" (uid=29999 pid=1254 comm="/usr/lib/tracker/tracker-store "))", 4) "SELECT ?message nie:plainTextContent(?message) rdf:type(?message) nmo:communicationChannel(?message) nmo:sentDate(?message) nmo:messageId(?message) nmo:receivedDate(?message) nie:contentLastModified(?message) nmo:isSent(?message) nmo:isDraft(?message) nmo:isRead(?message) nmo:encoding(?message) nie:characterSet(?message) nie:language(?message) (SELECT GROUP_CONCAT(tracker:coalesce(nco:imID(?medium), nco:phoneNumber(?medium), ?medium), "\u001e") WHERE { ?from nco:hasContactMedium ?medium . })(SELECT GROUP_CONCAT(tracker:coalesce(nco:imID(?medium), nco:phoneNumber(?medium), ?medium), "\u001e") WHERE { ?to nco:hasContactMedium ?medium . }) nmo:phoneMessageId(?message) WHERE { SELECT ?message ?from ?to IF (nmo:isSent(?message) = true, ?to, ?from) AS ?target ?message WHERE {?message nmo:from ?from ; nmo:to ?to . ?message rdf:type nmo:SMSMessage . } }"
~ $]