[Q] Deleting duplicate SMS.

Search This thread

mcjordan92

Senior Member
May 27, 2011
515
48
Hi, I have been using go SMS pro and I made some backups and made it auto backup by schedule..
I've noticed now that something probably went wrong and now I've got most of my SMS twice or trice, or even 4 times duplicate..
And if ill try to fix it handily by my self it'll take me 40 years, cuz I got over a thousand messages.. and each one is 2-4 times..

Is there any app that you know that could scan it and delete it by its own?
Like scanning the whole SMS and delete those who are the same..?

Please help. Its very important for me.

Thanks,
Yarden.
 

Jarmezrocks

Senior Member
Mar 25, 2011
959
495
Gold Coast
tinyurl.com
I'll second this one! Most other SMS apps have a way of sorting duplicates? They see sent or received dates. Would be cool if GOSMS could do this too. I noticed that a 3rd party sms app cannot back up GOSMS's SMS (geeze that's a mouthful to say lol)... the only way you can allow them to function is if you uncheck the box for disable other SMS apps inside GOSMS; but doing that in it's self causes other issues.
 

mcjordan92

Senior Member
May 27, 2011
515
48
Hey
You said "most other app got way of.sorting duplicates.."
Can you name one please?

Although this is very old post and I already fixed the problem of duplicating the messages each backup, I still got a lot of old messages twice / trice...

Can you name a app that can scan and fix it?

Sent from my Desire HD using XDA App
 

walda

Senior Member
Apr 2, 2010
1,387
249
You could use "SMS Backup & Restore".

Make a Backup, Check if it was ok, Delete all SMS, Restore from Backup -> There you can choose if the Restore should check if the Message exists...
 

mcjordan92

Senior Member
May 27, 2011
515
48
How do I choose such a thing?
Can you be more accurate please? I can not see such an option.
Do you talk about go sms?

Thanks.

Sent from my Desire HD using XDA App
 

mcjordan92

Senior Member
May 27, 2011
515
48
Oh that's exactly what I was looking for!!!
It fixed my problem so easily!
God will bless you for inventing this simply genius app!

Thank you!

Sent from my Desire HD using XDA App
 

bobbyball

Senior Member
Nov 11, 2009
152
3
Cambridge
Kamma I downloaded your app to try and remove some duplicate messages I have but I get a force close.

I have an HTC ONE X running ICS
 

fullshred

Member
Aug 26, 2011
17
1
Life saver! I used SMSBackupRestore to restore backups after my phone got factory reset, and it kept hanging about half way through. I ended up with three or four copies of all my messages. Your "delete duplicates" option saved the day! Thanks heaps :)
 

pizzaman79

Senior Member
Jul 4, 2008
345
30
Leiden
Have you yet found a solution to this?

Yes, but it's a bit of work. If I recall correctly, this is what I did.
- use titanium backup to export your sms messages to xml
- rename to .txt
- open in excel, don't import the xml, just the plain text line by line
- take a look at your file: are duplicates exactly the same? How to uniquely identify them?
- on column two, use a formula to extract part of the text that identifies a text message, use excel help or ask me by posting an example
- next column use a formula if(the identifier on column two = identifier of previous line, "", first column)
- copy column three, paste in column four data only
- sort column four to get rid of empty lines
- in titanium, delete all your text messages
- import the cleaned xml file.
- done

I'm a bit of an expert in this, so it took me maybe half an hour. Note that there may be text editing tools that remove duplicate lines, but that only works if the whole xml code of duplicate text messages is identical. Also not that importing xml files in excel is nice, but exporting them is difficult.
 
  • Like
Reactions: jewbydoo

azmo

Member
Oct 30, 2006
14
0
Szczecin
www.szymtech.pl
Yes, but it's a bit of work. If I recall correctly, this is what I did.
- use titanium backup to export your sms messages to xml
- rename to .txt
- open in excel, don't import the xml, just the plain text line by line
- take a look at your file: are duplicates exactly the same? How to uniquely identify them?
- on column two, use a formula to extract part of the text that identifies a text message, use excel help or ask me by posting an example
- next column use a formula if(the identifier on column two = identifier of previous line, "", first column)
- copy column three, paste in column four data only
- sort column four to get rid of empty lines
- in titanium, delete all your text messages
- import the cleaned xml file.
- done

I'm a bit of an expert in this, so it took me maybe half an hour. Note that there may be text editing tools that remove duplicate lines, but that only works if the whole xml code of duplicate text messages is identical. Also not that importing xml files in excel is nice, but exporting them is difficult.

Hi, my backup file have sms and MMS inside, thats why editing it via txt file is pointless
do You have any sollutions how to delete duplicated sms messages from it ?
Because "kAmMa's BackupSMS for Android" didn't work for me - I get an error message...
 

pizzaman79

Senior Member
Jul 4, 2008
345
30
Leiden
Hi, my backup file have sms and MMS inside, thats why editing it via txt file is pointless
do You have any sollutions how to delete duplicated sms messages from it ?
Because "kAmMa's BackupSMS for Android" didn't work for me - I get an error message...

Maybe you can separate the sms and mms and then use my excel procedure to delete duplicate sms messages and delete the mms duplicates by hand?

To behonest, I'm surprised anyone uses mms...
 

Top Liked Posts

  • There are no posts matching your filters.
  • 5
    you can try my app BackupSMS. It has this feature (delete duplicate messages).

    kAmMa's BackupSMS for Android - http://bit.ly/eVTEEn
    1
    Have you yet found a solution to this?

    Yes, but it's a bit of work. If I recall correctly, this is what I did.
    - use titanium backup to export your sms messages to xml
    - rename to .txt
    - open in excel, don't import the xml, just the plain text line by line
    - take a look at your file: are duplicates exactly the same? How to uniquely identify them?
    - on column two, use a formula to extract part of the text that identifies a text message, use excel help or ask me by posting an example
    - next column use a formula if(the identifier on column two = identifier of previous line, "", first column)
    - copy column three, paste in column four data only
    - sort column four to get rid of empty lines
    - in titanium, delete all your text messages
    - import the cleaned xml file.
    - done

    I'm a bit of an expert in this, so it took me maybe half an hour. Note that there may be text editing tools that remove duplicate lines, but that only works if the whole xml code of duplicate text messages is identical. Also not that importing xml files in excel is nice, but exporting them is difficult.