How to delete multiple SMS messages
 

Hello everyone.

How do I select & delete multiple messages in nokia n9. I don't see any option?. I see only Delete (for single message) or Delete all. May be I'm missing something

Re: How to delete multiple SMS messages
 

can someone please help on this??

Re: How to delete multiple SMS messages
 

There is no option to do that, either you delete the sms 1 by one or you delete them all.

Re: How to delete multiple SMS messages
 

This is a basic funcitonality. My nokia n900 has this feature..how come nokia misses stuff like this.. Is any enhancement or tool available to delete multiple messages? It is painful to delete each & every messages

Re: How to delete multiple SMS messages
 

Nope, why not just delete all?

Re: How to delete multiple SMS messages
 

I have to retain some messages for different purposes. I believe almost everyone does If it's not true then 95% of phones doesn't have the option to delete multiple messages at a time.

Re: How to delete multiple SMS messages
 

Tap-and-hold on message, Copy, Paste somewhere. But this is only for message body, not date/time stamp, or people involved in conversation.

Re: How to delete multiple SMS messages
 

You can do that using Nokia Suite if you open messages on the phone rather than the copies synced to the PC... Just multi-select the ones you want to be rid of...

Re: How to delete multiple SMS messages
 

Actually, you can't. Nokia Suite does not support the N9.

PC Suite allows you to view the messages stored on the N9 and can export them to a CSV file, but if you attempt to delete more than one message at a time, it hangs indefinitely and finally bombs out saying "one or more of the messages could not be deleted". Only the first in the list of selected messages is actually deleted.

Re: How to delete multiple SMS messages
 

I know there is no option to do multiselection and delete the messages.
Is it possible to modify the source code and enable the muti selection in Messaging. The Email also having this so why we missed out this feature and why can't the community developer can enable it....
I am not an app developer, can any one explain how much difficulty inside this one. I missed this feature so much. Can anybody make this happen... If is there any separate app or modification also acceptable...

Regards,

Re: How to delete multiple SMS messages
 

May i know the reason why we can't modify or update the code to enable the message app in N9. I think it is simple to the developer to enable that functionality, Mail client is having that great thing.

Please reply me...

Re: How to delete multiple SMS messages
 

It isn't open source hence the issue...

Re: How to delete multiple SMS messages
 

Then there is no possibility ... is it? Is it possible to make a new app with the same feature... Can our community developers build an app ... Even it is a paid version... [ I am just asking]...

Re: How to delete multiple SMS messages
 

Of course it can be done. The question is, what would be the motivation to do it. If somebody sees it as worthwhile development project then it will be done, as fa as I know the interfaces are documented so there is no major roadblocks on the way.

As long as people are content to use the existing messaging application thee is no pressure to develop a new one :)

Re: How to delete multiple SMS messages
 

Thanks for your reply juiceme... I am totally missed up that feature . Still waiting waiting waiting nearly 1 year... But no update fixed it... I have only 2 problems with n9
1. Multi selection (Or Mark ) in message application. (In deleting messages)
2. Text editing application...

Totally disappointed with this. The Meego UI is fantastic. But what is the Use if it missed up the basic required operations and features.....

Re: How to delete multiple SMS messages
 

Ok, your actual problem with the messaging application is the SMS delete having no multiselect feature, you are happy with how it behaves otherways?

Well what comes to my mind as the quickest way to fix this would be a separate application to select and purge messages straight off the SMS database :)

The DB interface is known as the SMS backup/restote tweak uses it, and this way one would not need to worry about interfacing to the system message delivery path.

How does that sound?

Re: How to delete multiple SMS messages
 

juiceme,

I haven't investigated yet but have you tried /home/user/.cache/tracker/meta.db for the messages database location? I think it may just be the elusive database...

Re: How to delete multiple SMS messages
 

Yes You are correct. Messaging as conversation is good. I just want the multiselct and , delete only the unwanted messages...

If it is not possible atleast to remove the confirmation while long press and delete messages one by one...

Any way for your information i am not qt developer, Just trying to become qt developer. I am working in php. I hope with some c++ knowledge i can achieve it.(to become qt developer...) Like This team and support very much. Very happy to being here...

Thank you very much...

Re: How to delete multiple SMS messages
 

You must be correct, when I just cat the strings from that DB I get bits and pieces that look like my SMS's :)

That finally confirms what I have suspected, SMS'es are not really stored anywhere in "real space", just inside trackers DB. So, when as you remember I blew my tracker few weeks back I lost all my SMS'es (and would have lost em for good if I didn't have backup from the day before...)

Re: How to delete multiple SMS messages
 

Well, QT is quite nice environment to code in, there are not many difficult things and there are a lots of example code snippets in the QTCreator that one can look up. For anyone who knows C/C++ (and PHP :)) it should not be difficult to start developing on.

Creating an application that reads SMS list from the tracker DB, lets user select the deletable messages and purges them from the DB could easily be a kind of learning example with QT :D

Re: How to delete multiple SMS messages
 

I've been playing with the tracker database a little now... Copied it off to an external host and looked at it. The format is sqlite3, and it can be dumped with sqlitebrowser or python using apsw (Another Python SQLite Wrapper).

The DB contains loads of stuff in addition to the SMS'es, so it requires some tinkering to access just the messages amongst all the data there.

Re: How to delete multiple SMS messages
 

So complete Smses are indeed in it?

Maybe if you are successful you can describe the additional tinkering required?

Thanks!

Re: How to delete multiple SMS messages
 

Yes, the complete SMS'es are there. Also the text part of MMS'es is stored there but the pictures in the messages are stored separately (and maybe other attachments too, I have not checked with MMS'es containing sound etc..)

To access just the messages would require understanding the DB structure and writing correct queries to retrieve/manipulate/delete the records. It seems to me that the messages are tagged with consistent id's so this should be possible.

I have to confess it's been really long time since I have looked into insides of a sql database... I did some course work on postgresql in the university but that was last millenium :D

Re: How to delete multiple SMS messages
 

Thanks!

So from what I gather it means if we retrieve the meta.db before doing a tracker reset and restoring it back, the messages etc should not be lost right?

I'm not familiar with sql but looks like this is a good excuse to get familiar with it...

Re: How to delete multiple SMS messages
 

I might dare to try that, now as whole device backup works :D


Scenario;
- backup /home
- reset tracker databases
- check that all messagds are gone
- check the content of /home/user/.cache/tracker
- restore the database only
- check that messages are restored
- if all OK, no need to restore from full backp.

Only problem that I see here is that tracker should be killed while replacing the DB, or else it sure will not work. How to do that safely when running in normal mode?
On the other hand if it is required to boot the device to single user mode to restore the DB it is almost same thing to restore the full backup rathdr than just files under .cache directory...

Re: How to delete multiple SMS messages
 

How did you get the meta.db?

I always get
tried via Putty, WinSCP, Filebox and Terminal
as user and root and as user with devel-su

Re: How to delete multiple SMS messages
 

So did you try navigating to this location using Filebox to check if it exists?

Re: How to delete multiple SMS messages
 

Strange...
Absolutely sure, it exists, i can see it in ls and WinSCP and Filebox even opens it, but shows nothing in it...

Today my messages got mixed up again, so i wanted to check whats going on in the db, but no chance. Maybe those two things are related...

I will reboot the phone and check if it changes anything...

Re: How to delete multiple SMS messages
 

leinad,

I think you will have to copy it using winscp to your pc.

i am in open mode maybe thats why it works out for me. this directory should have only user rights but when i did as user i got permission denied so try copying it over first as user if not as root.

edit: maybe you can use an opensh or ariadnesh to copy it to MyDocs before transferring to your pc.

Re: How to delete multiple SMS messages
 

Ok, copying via ariadne worked fine, now i got it on my pc and cannot open it :)

My SQLite-Programm tells me:
"Cannot perform this operation on a closed dataset." when i try to open it.

...and it's quite big, about 40MB for me.

Edit: of course i can open it with an Editor and see fragments of my SMS, but not in a form someone could use...

I still can't imagine, this should be the only place to store them, it's totally mixed up with other stuff and it's in a folder called "cache", so probably it is only a cache... but maybe i'm wrong.

Edit 2: Is there an SQLite-Editor, which can handle that?
I tried 2, noone worked.

Edit 3: thedead, did you ever try to run a grep over the whole phone, for a word, you know it is in your SMS, but not too common to give too many results?

I did that without results, but maybe because i'm not in open mode... was running for about 2 hours :)

Re: How to delete multiple SMS messages
 

Leinad,

I use in firefox an extension named "SQLite Manager" (but then my SQL skills are non-existent so I don't know if this is what you are looking for)...My meta.db is over >110MB as you can see from the ls -l I posted so 40MB is pretty ok :)

Also on your phone you can use sqlite3 to explore...

I'm running the grep now...let's see what happens...

Edit: Grep doesn't do anything for me too...Just keeps running...

Re: How to delete multiple SMS messages
 

You have these file access problems because the /home/user/.cache/tracker attributes do not allow listing of the directory to anyone but users who belong to group "metadata":

Access to the file/directory is of course possible when you are root. (and for the record, of course I also run my device in open mode, else all this stuff wouldn't be possible)

So, I just tarred the whole tracker directory; "tar -cvf trackercache.tar /home/user/.cache/tracker" and then copied it off to my desktop using sftp.

I used sqlitebrowser (version 2.0.0~beta1+ds.1-2 that comes with ubuntu 12.04, but I suppose any version works...) to extract the DB as a CSV file.
Additionally I used python sqlite package "apsw" to test reading the DB file.

Re: How to delete multiple SMS messages
 

May i know who created the native message app in Nokia N9 it self...

Re: How to delete multiple SMS messages
 

This Firefox-Addon works great, better than all the stuff i downloaded before. SQLite is not my native "dialect", but i have to deal with mySQL everyday :)

It ran at least 2 hours on my phone and looked like it was freezing,maybe give it some time more (8h over night?)

Yep. i noticed that too :)

Nope. (for proof, see my putty-log, i was logged in as root)

Nope. possible without open mode, thanks to Ariadne :)


Did a tracker reset and some things more to report, but i will do it tomorrow... got to go to sleep now :)

Re: How to delete multiple SMS messages
 

Ok will leave it to run over-night tonight; will report after 24 hrs as its 1035 here now :D

However, I don't think we'll get anything interesting except for the freezing part which I too experienced yesterday :)

Re: How to delete multiple SMS messages
 

Let me know, here it's 03:38 ;)

Re: How to delete multiple SMS messages
 

any further improvement???

Re: How to delete multiple SMS messages
 

Hi friends , Till now there is no solution for multiselection and delete on the message application.

Can anyone confirm it that it'll be available in sailfish...