maemo.org - Talk

maemo.org - Talk (https://talk.maemo.org/index.php)
-   SailfishOS (https://talk.maemo.org/forumdisplay.php?f=52)
-   -   How to access SMS database in Sailfish? (https://talk.maemo.org/showthread.php?t=91909)

juiceme 2013-12-02 08:22

How to access SMS database in Sailfish?
 
I am trying to find a way to import my SMS'es from my N9 to my new Jolla device. By looking around the device I see that it's got a tracker DB just like N9 has, in /home/nemo/.cache/tracker/
Hence, I'd believe SMS'es are stored in tracker the same way that N9 handles them.

Now, on N9 I can get my SMS'es via tracker query: tracker-sparql -q "select nie:plainTextContent(?d) where {?d a nmo:SMSMessage}"

The same thing on Jolla device, however, returns nothing:

[nemo@localhost ~]$ tracker-sparql -q "select nie:plainTextContent(?d) where {?d a nmo:SMSMessage}"
Results:
None

[nemo@localhost ~]$


On N9 when I grep SMS from the used classes I get the hit for it:

~ $
~ $ tracker-sparql -q "SELECT DISTINCT ?o WHERE { ?s rdf:type ?o . }" | grep SMS
http://www.semanticdesktop.org/ontol...nmo#SMSMessage
~ $


And on Jolla it seems to be unused:

[nemo@localhost ~]$
[nemo@localhost ~]$ tracker-sparql -q "SELECT DISTINCT ?o WHERE { ?s rdf:type ?o . }" | grep SMS
[nemo@localhost ~]$


Now, how would I get to my messages on Jolla?

merlin1991 2013-12-02 16:58

Re: How to access SMS database in Sailfish?
 
The access layer for messages isn't tracker but libcommhistory, tracker just happens to be the storage engine on the N9

libcommhistory is part of the nemo middleware layer so it can be used on Sailfish aswell, see https://github.com/nemomobile/libcommhistory/

I've started working on an Harmattan exporter (to CSV) and Sailfish importer, the exporter is finished, but the importer isn't there yet.
The code lives on github: https://github.com/merlin1991/Harmattan-SMS-Boat

EDIT: since not everyone has a working scratchbox installation, here's a built binary:
http://cdnm.at/~christian/Harmattan-SMS-Boat/smsExport (use save link as)

juiceme 2013-12-02 17:27

Re: How to access SMS database in Sailfish?
 
Quote:

Originally Posted by merlin1991 (Post 1391782)
I've started working on an Harmattan exporter (to CSV) and Sailfish importer, the exporter is finished, but the importer isn't there yet.
The code lives on github: https://github.com/merlin1991/Harmattan-SMS-Boat

Okay, so I am missing some dependencies...?

Code:

[sbox-HARMATTAN_ARMEL: ~/Harmattan-SMS-Boat/n9Export] > qmake
/scratchbox/tools/bin/misc_runner: : No such file or directory
/scratchbox/tools/bin/misc_runner: : No such file or directory
/scratchbox/tools/bin/misc_runner: : No such file or directory
[sbox-HARMATTAN_ARMEL: ~/Harmattan-SMS-Boat/n9Export] >
[sbox-HARMATTAN_ARMEL: ~/Harmattan-SMS-Boat/n9Export] > make
g++ -c -pipe -g -D_REENTRANT -Wall -W -DQT_GUI_LIB -DQT_CORE_LIB -DQT_SHARED -I/targets/HARMATTAN_ARMEL/usr/share/qt4/mkspecs/linux-g++-maemo -I. -I/targets/HARMATTAN_ARMEL/usr/include/qt4/QtCore -I/targets/HARMATTAN_ARMEL/usr/include/qt4/QtGui -I/targets/HARMATTAN_ARMEL/usr/include/qt4 -I. -o smsEx.o smsEx.cpp
smsEx.cpp:5: fatal error: CommHistory/SyncSMSModel: No such file or directory
compilation terminated.
make: *** [smsEx.o] Error 1
[sbox-HARMATTAN_ARMEL: ~/Harmattan-SMS-Boat/n9Export] >


merlin1991 2013-12-02 18:39

Re: How to access SMS database in Sailfish?
 
Quote:

Originally Posted by juiceme (Post 1391791)
Okay, so I am missing some dependencies...?

You need libcommhistory-dev which isn't installed by default, I'll add it to the readme :cool:

miqu 2013-12-02 19:11

Re: How to access SMS database in Sailfish?
 
Nice Merlin1991,

Back in the day, I actually transferred all my messages from my N900 to my N9. So now there are well over 20000 messages on my N9. I think this time I will not import them as the database gets a bit large because of that import.

Unless some of you guys tells me to put Jolla to the test. :)

jbrooks 2013-12-02 20:24

Re: How to access SMS database in Sailfish?
 
I maintain the messaging stack for Jolla, so there are some pointers I can give here..

Quote:

Originally Posted by merlin1991 (Post 1391782)
The access layer for messages isn't tracker but libcommhistory, tracker just happens to be the storage engine on the N9

libcommhistory is part of the nemo middleware layer so it can be used on Sailfish aswell, see https://github.com/nemomobile/libcommhistory/

I've started working on an Harmattan exporter (to CSV) and Sailfish importer, the exporter is finished, but the importer isn't there yet.
The code lives on github: https://github.com/merlin1991/Harmattan-SMS-Boat

Correct. Nemo and Sailfish use libcommhistory (as did the N9), but we use a sqlite database instead of tracker. libcommhistory has an import/export tool for backup, but I would strongly recommend not using that between a N9 and Jolla. Things will break. I'd love to get some good text-based import/export tools in there instead. VMessage support would be especially interesting.

Your CSV exporter looks like a great start. For importing, use /org/freedesktop/Telepathy/Account/ring/tel/account0 as the localUid. Use a GroupModel to create one group per unique phone number, and then an EventModel to create events. Make sure to set the right groupId on events.

I wouldn't recommend trying to import IM messages from the N9.

Quote:

Originally Posted by miqu
Back in the day, I actually transferred all my messages from my N900 to my N9. So now there are well over 20000 messages on my N9. I think this time I will not import them as the database gets a bit large because of that import.

Unless some of you guys tells me to put Jolla to the test.

Please don't ;) - Performance will get really bad right now. There are changes going into the next update(s) that make it fast for several hundred thousand messages, but right now it's pretty bad.

merlin1991 2013-12-02 21:38

Re: How to access SMS database in Sailfish?
 
Quote:

Originally Posted by jbrooks (Post 1391887)
I'd love to get some good text-based import/export tools in there instead. VMessage support would be especially interesting.

I'd love to implement a proper transfer format instead of my selfinvented abuse of the term "CSV".

But apart from a wikipedia entry which tells me that vMessage is specified by IrDA and that the format is most likely in their IrMC standards set I've found nothing about the format.
And as usual one gets the standard only for a fee, which is 100$ in this case, so not an option for me.

jbrooks 2013-12-02 21:58

Re: How to access SMS database in Sailfish?
 
Quote:

Originally Posted by merlin1991 (Post 1391923)
I'd love to implement a proper transfer format instead of my selfinvented abuse of the term "CSV".

But apart from a wikipedia entry which tells me that vMessage is specified by IrDA and that the format is most likely in their IrMC standards set I've found nothing about the format.
And as usual one gets the standard only for a fee, which is 100$ in this case, so not an option for me.

http://www.pday.com.cn/technology/ir.../IrMC_v1p1.pdf section 9.9.2 (page 79, or 91 in the pdf) has the definition. Although now that I look around, there's not much support for vmsg anywhere except perhaps in bluetooth.

I'd stick with the CSV for now - no reason to make it complicated. Although if you ever get bored and want to implement vmsg import/export in libcommhistory.. :p

tigre-bleu 2013-12-02 23:43

Re: How to access SMS database in Sailfish?
 
What would be good (but quite more complex than just import/export) is to synchronize SMS with an email account.

There is an app for Android that does that on gmail and even if it is google-only, the principle is good.

SMS could just be exported/imported to an IMAP folder. MMS could also with multimedia content as attachment.

juiceme 2013-12-03 06:27

Re: How to access SMS database in Sailfish?
 
Quote:

Originally Posted by merlin1991 (Post 1391923)
I'd love to implement a proper transfer format instead of my selfinvented abuse of the term "CSV".

CSV is okay I guess but XML would be pretty nice too.
Nowdays I would not worry about the ML overhead, trying to squeeze data into too little containers is pointless on the age of memory abundance we are living :D

wolke 2013-12-03 22:02

Re: How to access SMS database in Sailfish?
 
human-readable import/export of SMS on sailfish is mission critical before i can start using jolla as a primary phone.

likewise with call log and contacts {MMS would be nice too}

i also dont care what format is used, as long as its human-readable, well-structured, and validatable.

however, i personally would prefer a platform-independent solution, preferably one that just reads/writes the sqlite database so that it can be done on a faster box.

as soon as i get a jolla {usa, so sad} this will be the first thing i investigate coding up.
-a sqlite solution will be complicated. it will also be brittle, since the libcomm interfacing impl and the sql table structure could change
-things aside from libcommhistory might be in the sqlite db, so this might involve risk in replacing the db.
-if the jolla code that handles the sqlite db is open and modular, it might be adaptable for this purpose

jbrooks 2013-12-03 22:39

Re: How to access SMS database in Sailfish?
 
Quote:

Originally Posted by wolke (Post 1392315)
human-readable import/export of SMS on sailfish is mission critical before i can start using jolla as a primary phone.

likewise with call log and contacts {MMS would be nice too}

i also dont care what format is used, as long as its human-readable, well-structured, and validatable.

however, i personally would prefer a platform-independent solution, preferably one that just reads/writes the sqlite database so that it can be done on a faster box.

Contacts are stored separately, but vcard export should already be possible (or is easy to write up). Some of our contacts metadata is lost in exporting, of course. We have full backups for contacts, messages, etc as well, but not in a readable format.

Quote:

Originally Posted by wolke (Post 1392315)
as soon as i get a jolla {usa, so sad} this will be the first thing i investigate coding up.
-a sqlite solution will be complicated. it will also be brittle, since the libcomm interfacing impl and the sql table structure could change
-things aside from libcommhistory might be in the sqlite db, so this might involve risk in replacing the db.
-if the jolla code that handles the sqlite db is open and modular, it might be adaptable for this purpose

Avoid using the database without using libcommhistory; the schema is very likely to change. All of this code is entirely opensource at https://github.com/nemomobile/libcommhistory

There is a basic JSON format in commhistory-tool for importing messages right now, primarily meant for predefined content. That may eventually be extended into a full import/export format, to replace the current fragile binary one. See https://github.com/nemomobile/libcom...tool.cpp#L1112

There's nothing to export readable call logs right now, but they are also managed by libcommhistory.

I'm happy to see so much interest. Patches are always welcome.. ;)

wolke 2013-12-03 22:53

Re: How to access SMS database in Sailfish?
 
this is all REALLY good news, thanks.
full json import/export would be perfect {with my n9, i am currently entirely dependent on https://github.com/wwwjfy/MeegoSMSBackupRestore}

out of curiousity, what sort of contacts metadata is non-exportable to vcard? {only things i can imagine are for tie-in with awful apps like skype or wazapp}

merlin1991 2013-12-09 16:08

Re: How to access SMS database in Sailfish?
 
I've hacked up the smsImporter today, I've tested it on nemo since I don't have a device, so no guarantee for it's functionality.

Running the binary with the exported csv as argument imports everything
Binary: http://cdnm.at/~christian/Harmattan-SMS-Boat/smsImport
Source: https://github.com/merlin1991/Harmat...port/smsIm.cpp

edit: Thanks to a tip from jbrooks it works now perfectly, no more segfaults. The new binary is available at the link above.

Nikos Alexandris 2013-12-22 09:57

Re: How to access SMS database in Sailfish?
 
Quote:

Originally Posted by merlin1991 (Post 1394081)
I've hacked up the smsImporter today, I've tested it on nemo since I don't have a device, so no guarantee for it's functionality.

Running the binary with the exported csv as argument imports everything
Binary: http://cdnm.at/~christian/Harmattan-SMS-Boat/smsImport
Source: https://github.com/merlin1991/Harmat...port/smsIm.cpp

edit: Thanks to a tip from jbrooks it works now perfectly, no more segfaults. The new binary is available at the link above.

Hi and thank you for the efforts!

How can I use these tools (smsExport, smsImport) on N9 and Jolla respectively? Simply get the binaries in each device and then execute from a terminal? Any simple examples?

merlin1991 2013-12-23 19:21

Re: How to access SMS database in Sailfish?
 
Quote:

Originally Posted by Nikos Alexandris (Post 1399612)
How can I use these tools (smsExport, smsImport) on N9 and Jolla respectively? Simply get the binaries in each device and then execute from a terminal? Any simple examples?

Yep, simply get them on device and execute.
smsExport just prints everything to stdout so do
Code:

./smsExport > somefile.csv
And smsImport expectes a path to a file, so scp the somefile.csv onto the jolla aswell and do
Code:

./smsImport somefile.csv

xillibit 2013-12-23 20:13

Re: How to access SMS database in Sailfish?
 
Hello,

I'am interested too but to import SMS from symbian device, i have found a way to export the SMS in XML

How can-i see the fields to import into libcommhistory ?

Nikos Alexandris 2013-12-24 13:25

Re: How to access SMS database in Sailfish?
 
Quote:

Originally Posted by merlin1991 (Post 1400083)
Yep, simply get them on device and execute.
smsExport just prints everything to stdout so do
Code:

./smsExport > somefile.csv
And smsImport expectes a path to a file, so scp the somefile.csv onto the jolla aswell and do
Code:

./smsImport somefile.csv

Thanks. Trying... I see that smsExport (in N9) does not have the "x" permission granted. Trying to change that as root, doesn't work. As "user" it won't let me run it.

nieldk 2013-12-24 13:46

Re: How to access SMS database in Sailfish?
 
Quote:

Originally Posted by Nikos Alexandris (Post 1400288)
Thanks. Trying... I see that smsExport (in N9) does not have the "x" permission granted. Trying to change that as root, doesn't work. As "user" it won't let me run it.

whats the errormessage?

/bin/chmod +x path-to/smsExport

/bin is not in PATH as standard, may be your issue

Nikos Alexandris 2013-12-24 14:51

Re: How to access SMS database in Sailfish?
 
Quote:

Originally Posted by nieldk (Post 1400299)
whats the errormessage?

/bin/chmod +x path-to/smsExport

/bin is not in PATH as standard, may be your issue

The only place from where I could execute the binary smsExport was from /home/user. Anywhere else, e.g. under /home/user/MyDocs/N9Export I could neither alter permissions nor let it run (always permission denied).

Now, I've manage to run it (as user, via ssh), as mentioned, from "home", and it does:

Code:

./smsExport

"GDBus.Error:org.freedesktop.DBus.Error.AccessDenied: Rejected send message, 2 matched rules; type="method_call", sender=":1.163" (uid=29999 pid=4928 comm="./smsExport ") interface="org.freedesktop.Tracker1.Steroids" member="Query" error name="(unset)" requested_reply=0 destination="org.freedesktop.Tracker1" (uid=29999 pid=1324 comm="/usr/lib/tracker/tracker-store "))"
# sms:  0
QTrackerDirectSelectResult: QSparqlError(9, "GDBus.Error:org.freedesktop.DBus.Error.AccessDenied: Rejected send message, 2 matched rules; type="method_call", sender=":1.163" (uid=29999 pid=4928 comm="./smsExport ") interface="org.freedesktop.Tracker1.Steroids" member="Query" error name="(unset)" requested_reply=0 destination="org.freedesktop.Tracker1" (uid=29999 pid=1324 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 . } }"

Thanks for caring.

merlin1991 2013-12-24 17:05

Re: How to access SMS database in Sailfish?
 
Quote:

Originally Posted by Nikos Alexandris (Post 1400316)
The only place from where I could execute the binary smsExport was from /home/user. Anywhere else, e.g. under /home/user/MyDocs/N9Export I could neither alter permissions nor let it run (always permission denied).

If you have a look at mount, especially this bit:
Code:

/dev/mmcblk0p1 on /home/user/MyDocs type vfat (rw,nosuid,nodev,noexec,noatime,nodiratime,uid=29999,fmask=0133,dmask=0000,allow_utime=0022,codepage=cp437,iocharset=iso8859-1,shortname=mixed,utf8,rodir,errors=remount-ro)
you'll see, that "noexec" flag ist set for MyDocs which prevents you from running executables from there.


Regarding your problem, never forget our dear friend aegis. You have to run the application as the developer user since he is the only user with enough aegis credentials to access your messages database.

rainisto 2013-12-25 14:45

Re: How to access SMS database in Sailfish?
 
Otherwise works ok, but it scrambles צהו characters on import, maybe it should export/import in utf8 or something?

And on N9 side you needed to run it as developer and not as user.

zlatko 2013-12-25 16:05

Re: How to access SMS database in Sailfish?
 
Worked perfect on my N9 and Jolla :) Thanks everyone involved!

merlin1991 2013-12-26 01:05

Re: How to access SMS database in Sailfish?
 
Another day, another update:

As suggested by rainisto the application now saves to utf-8 files.
It also can ex/import the call history now by using the -c flag.

New binaries:
http://cdnm.at/~christian/Harmattan-...at/jollaImport
http://cdnm.at/~christian/Harmattan-SMS-Boat/n9Export

Source still at github:
https://github.com/merlin1991/Harmattan-SMS-Boat

Nikos Alexandris 2013-12-26 04:18

Re: How to access SMS database in Sailfish?
 
Quote:

Originally Posted by merlin1991 (Post 1400645)
Another day, another update:

As suggested by rainisto the application now saves to utf-8 files.
It also can ex/import the call history now by using the -c flag.

New binaries:
http://cdnm.at/~christian/Harmattan-...at/jollaImport
http://cdnm.at/~christian/Harmattan-SMS-Boat/n9Export

Source still at github:
https://github.com/merlin1991/Harmattan-SMS-Boat

Amazing! I can't get it working though :-(
Code:

/home/user # whoami
root
/home/user # ls -lah n9Export
-rwxr-xr-x    1 user    users    259.1K Dec 26 06:14 n9Export
/home/user # ./n9Export -s sms_n9
"GDBus.Error:org.freedesktop.DBus.Error.AccessDenied: Rejected send message, 2 matched rules; type="method_call", sender=":1.148" (uid=0 pid=6202 comm="./n9Export -s sms_n9 ") interface="org.freedesktop.Tracker1.Steroids" member="Query" error name="(unset)" requested_reply=0 destination="org.freedesktop.Tracker1" (uid=29999 pid=1346 comm="/usr/lib/tracker/tracker-store "))"
# sms:  0
QTrackerDirectSelectResult: QSparqlError(9, "GDBus.Error:org.freedesktop.DBus.Error.AccessDenied: Rejected send message, 2 matched rules; type="method_call", sender=":1.148" (uid=0 pid=6202 comm="./n9Export -s sms_n9 ") interface="org.freedesktop.Tracker1.Steroids" member="Query" error name="(unset)" requested_reply=0 destination="org.freedesktop.Tracker1" (uid=29999 pid=1346 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 . } }"


zlatko 2013-12-26 06:54

Re: How to access SMS database in Sailfish?
 
@Nikos Alexandris
Run
Code:

develsh
prior executing the export.

Nikos Alexandris 2013-12-26 11:18

Re: How to access SMS database in Sailfish?
 
Quote:

Originally Posted by zlatko (Post 1400660)
@Nikos Alexandris
Run
Code:

develsh
prior executing the export.

Thank you! Apologies for my ignorance. It works :-). For the "-c" option, however, I get countless lines of:

Code:

libqtcontacts-tracker: engine.cpp:1591: Not cleaning up obsolete resources for nao:hasTag property since the property's range is too generic (rdfs:Resource).
What does it actually mean?

Nikos Alexandris 2013-12-26 12:59

Re: How to access SMS database in Sailfish?
 
Quote:

Originally Posted by Nikos Alexandris (Post 1400696)
Thank you! Apologies for my ignorance. It works :-). For the "-c" option, however, I get countless lines of:

Code:

libqtcontacts-tracker: engine.cpp:1591: Not cleaning up obsolete resources for nao:hasTag property since the property's range is too generic (rdfs:Resource).
What does it actually mean?

In any case, it worked. Awesome work!!

nicetux 2013-12-26 13:04

Re: How to access SMS database in Sailfish?
 
When i try to export my sms on n9 i get following error message:

Code:

~/MyDocs/SMSBackup $ develsh n9export -s 20132612
n9export: line 1: syntax error: unexpected word (expecting ")")

What I'mdoing wrong?

juiceme 2013-12-26 17:34

Re: How to access SMS database in Sailfish?
 
Quote:

Originally Posted by nicetux (Post 1400733)
When i try to export my sms on n9 i get following error message:

Code:

~/MyDocs/SMSBackup $ develsh n9export -s 20132612
n9export: line 1: syntax error: unexpected word (expecting ")")

What I'mdoing wrong?


you should first launch "develsh", then "./n9export"

nicetux 2013-12-27 15:44

Re: How to access SMS database in Sailfish?
 
When i do it so, i get 'Permission denied'. I tried to change rights for this file with chmod, but i will not change it.

mattaustin 2013-12-28 05:01

Re: How to access SMS database in Sailfish?
 
After today's Sailfish OS update I decided to switch to the Jolla as my primary phone. These utilities worked beautifully - thanks merlin1991!

jamar 2013-12-31 14:33

Re: How to access SMS database in Sailfish?
 
1 Attachment(s)
I've hacked an old smsexporter program to work with newer rtcom-eventlogger DB format (used on recent versions of N900 FW) and output CSV format which can be imported in Jolla.

So, you can export SMS messages from your N900 by using:

Code:

n900export <filename>
e.g.:
Code:

$ ./n900export sms_backup.csv
(it must be run as normal user, not as root)

and then use generated file with Merlin's jollaImport to import SMS messages to your Jolla.

Please note I'm not a C programmer and this is just a quitck&dirty hack. So please check the generated file whether the format looks okay and backup Jolla's history DB before importing.

But it worked fine for me, I've transfered about 2000 of SMS messages without problem.

xkkkx 2013-12-31 16:56

Re: How to access SMS database in Sailfish?
 
when I use the command "n900export" on N900, it says "not found" although I copied the bin to /home/user/ as well as the .cvs files I got from Nokia communication centre, am I doing something wrong?

lokimotive 2013-12-31 19:49

Re: How to access SMS database in Sailfish?
 
Quote:

Originally Posted by xkkkx (Post 1402563)
when I use the command "n900export" on N900, it says "not found" although I copied the bin to /home/user/ as well as the .cvs files I got from Nokia communication centre, am I doing something wrong?

You need to either put the bin into a directory in your $PATH (e.g. /usr/bin/) or you call it with the whole path i.e.
Code:

/home/user/n900export <csv-file>
You can check you $PATH by doing a
Code:

echo $PATH
in the terminal.

xkkkx 2013-12-31 21:23

Re: How to access SMS database in Sailfish?
 
Thanks, however, now I am getting a message "permission denied" even as su on Jolla, why is that?

zlatko 2013-12-31 21:35

Re: How to access SMS database in Sailfish?
 
@xkkkx
Look several posts above - use develsh command!

EDIT: On Jolla? I missed that. Are you sure you have all the right permissions setup for the import script? Do
Code:

chmod 777 <file>
EDIT1: Copy and paste here exactly the commands and the error message.
EDIT2: Change the permission on the script file itself. Looks like it is not executable. Run:
Code:

ls -l /home/nemo/Documents/ |grep jollaImport
and then(if permission not correct)

Code:

chmod 777 jollaImport

xkkkx 2013-12-31 21:39

Re: How to access SMS database in Sailfish?
 
develsh command does not work on Jolla, I am getting the "permission denied" message on my Jolla, even after "devel-su" command... I am already done with the n900 part.
EDIT: I did like you suggested: chmod 777 smsbackup.csv
and then ./jollaImport -s smsbackup.csv
and the same message came:
Code:

bash: /home/nemo/Documents/jollaImport: Permission denied
EDIT1: great, that was the problem, thanks for your help and a HAPPY NEW YEAR!!!

skyjumper 2014-01-01 04:26

Re: How to access SMS database in Sailfish?
 
Firstly, thankyou for the exporter! I was using smsbackup and it suffered from the libcommhistory bug - really annoying.

Secondly, I am wondering is it possible to export the messages to match the timezone set for the phone, not GMT?

I see how to do it now, using Qt::SystemLocaleLongDate but I do not have the scratchbox installed. :-)

EDIT: Scratchox installed and locatime used for exported sms's.

argonius 2014-01-02 19:43

Re: How to access SMS database in Sailfish?
 
Great stuff! Successfully transferred 1500+ SMS form N9 to Jolla :-)


All times are GMT. The time now is 18:23.

vBulletin® Version 3.8.8