yashsingh1/xdaforums huggingface dataset:
[Android Apps and Games] ztedd:
merging/combining of multiple backup files

@lost_ & CJCord:

merging/combining of multiple backup files is still on the feature request list. I'm sorry I can't propose a better tool to do it than SQLite Compare, also I don't have the time to write the code for that feature. Maybe Antonine could do it:

Or you could ask Fabio Sangiacomo (fabio.sangiacomo@digital-forensics.it), the other creator of Whatsapp Xtract. Have a look here:

http://blog.digital-forensics.it/2012/05/whatsapp-forensics.html
[Android Apps and Games] CJCord:
take you time;)

your tool already helped me alot, getting back my old backups. merging them would have been nice, but as long as i can see them (my WA never accepted its OWN database files *facepalm*) im fine :)
[Android Apps and Games] sam shaikh:
Very Useful... Thank You... :good:

Can u make this working in stealth mode and send database to email? :confused:
[Android Apps and Games] ark0n3:
I'm working on a tool to convert the db from iphone to android. still need some polishment but think i'll be able to release it in a few weeks top. drop me a PM if you are interested
[Android Apps and Games] yw1972:
openeing blackberry whatsapp messagestore.db

hi im not sure if there is a solution to opening up a blackberry whatsapp messagestore.db

if there is a solution please please can somone help me
[Android Apps and Games] Vedant92:
your help will be much appreciated :)

Your method seems to be the best way to recover whatsapp data on the internet :)

i wish i could get it right though, I have an iphone 4.

I've installed python, but i can't follow you from step 5. I'm a noob :(

Where are the codes meant to be typed? and each time i double click on any .bat file, a terminal opens up with an error.

eg./Downloads/Whatsapp_Xtract_V2.1_2012-05-10-2/whatsapp_xtract_iphone.bat: line 3: @ECHO: command not found

python: can't open file 'whatsapp_xtract.py': [Errno 2] No such file or directory

I could really use your help on this one, there is a buttload of critical data in my old whatsapp conversations and your tools seems like the most viable option out there.

thank you
[Android Apps and Games] ztedd:
You are using a wrong, old version of Whatsapp Xtract. Please go to the first page of this thread and download the latest version, Whatsapp_Xtract_V2.1_2012-05-16.zip.

Then follow again the steps and finally use whatsapp_xtract_iphone.bat. Normally it should work...
[Android Apps and Games] ztedd:
That's cool! Which programming language are you using? Will you tell us here as soon as you've finished?
[Android Apps and Games] dbarrera:
Guys, I know this is way off-topic but I need to modify countries.tsv file... Anybody knows where can I find documentation about it?
[Android Apps and Games] shinekwt:
Hi,

I had followed all steps but unfortunately i couldn't make this tools to work

My first error showing when i click !install pyCrypto.bat

(attaching error image 1.png)

After that when i drag the DB file in the whatsapp_xtract_drag'n'drop_database(s)_here.bat, i get the below error

(attaching error image 2.png)

Can anyone please help me to solve this issue
[Android Apps and Games] ztedd:
I get the impression you guys are not reading the howto and the output messages of the dos windows. In your attached screenshot 1, it reads "install pycrypto - Access is denied" and above, "If you get errors then try to do this: rightclick on this !install pyCrypto.bat and choose "run as administrator"!".

Is this clear enough?

And just to prepare other problems, please make sure you have installed 32bit (x86) version of ActivePython.
[Android Apps and Games] chavocarlos:
There are any method to modify chat records, in my case, my country added a 9 number before all mobile phone numbers, so 0912345678 has changed to 09912345678 and now all my old chats are unattached to my new/modified contacts.

Or maybe merge databases from chats, old chats with new chats :P
[Android Apps and Games] dbarrera:
Ecuadorian?

Update the remote_key_jid with the new id with any sqlite editor...
[Android Apps and Games] chavocarlos:
Yes proudly, and you too :).

Ok, this is a field inside whatsapp database. I have installed a sqllite editor but only can edit once record each time, there are some method to do this more quickly, I mean run an sql update command using where clause? Or maybe from a desktop?

------------- Spanish -------------

Sí orgullosamente, y tu también :)

Bueno, veo que esto es un campo dentro de la BD del whatsapp, he instalado un sqllite editor pero sólo me deja editar registro por registro, hay manera de hacer esto menos tedioso? es decir lanzar un sql update where tal y tal cosa? O hay cómo hacerlo desde la PC?
[Android Apps and Games] dbarrera:
When I get to my office I'll play a little with commands and will send you a PM...
[Android Apps and Games] chavocarlos:
Done, edited via PC and working. Thanks a lot.
[Android Apps and Games] archieco:
iphone 4s backup doesnt contain emoji icons

Hi,

I used whatsapp chat extractor v2012-0512 to extract chats on my windows machine using whatsapp_xtract_iphone -i ChatStorage.sqlLite

The data\emoji folder has got emoji smileys but none got translated. Can you please tell me how to get them,?

thank
[Android Apps and Games] ztedd:
Execute SQL to change data inside your whatsapp database

I'm glad you found a way! Just to have it written down here: For problems like this you can use the tool SQlite Database Browser ( http://sqlitebrowser.sourceforge.net/ ) and the Execute SQL function. You just need to know some SQL, or to learn it a bit.

Here are the commands that work in your case (assuming the wrong number is 599123456789 and the correct should be 59123456789):

UPDATE messages SET key_remote_jid = "59" || SUBSTR(key_remote_jid, 4) WHERE key_remote_jid LIKE "599%"

UPDATE chat_list SET key_remote_jid = "59" || SUBSTR(key_remote_jid, 4) WHERE key_remote_jid LIKE "599%"
[Android Apps and Games] ztedd:
At first, you don't have the newest version. Please download and install the latest version from the first page.

Maybe it's because there are new smileys that aren't included in Whatsapp Xtract yet. We should have a look on this.
[Android Apps and Games] chavocarlos:
Yeah, thanks anyway, I just copied the database and edit with SQLite commands first, then I used DBVisualizer because is user friendly and didn't knew that can connect to SQLite databases. Regards.
[Android Apps and Games] archieco:
I will download latest version by tomorrow and try the same process again. I will let you know if even the old ones show up. So nice of you
[Android Apps and Games] archieco:
I tried that, but no smileys come.....I only extracted the sqlite file and not the other files

I extracted the whatsapp tool in my folder in desktop

copied sqlite file which I got

ran the batch file with i option

ANybody had problems with emoji icons....even the basic icons didnt show up
[Android Apps and Games] ztedd:
Which version of Whatsapp on Iphone do you use?

Can you send me your ChatStorage.sqlite file? Here you can contact me:

send PM
[Android Apps and Games] ictvs:
Hey guys,

I get this message when I'm running !install pyCrypto.bat

[see attached file]

What did I do wrong and how can I fix it?

Thanks a lot
[Android Apps and Games] ztedd:
pypm install error - operational error: unable to open database file none

some googling with "pypm install" + "operational error unable to open database file none" gave me this link:

http://community.activestate.com/node/6709

Maybe you've got a similar problem.

Try:

- running the !install pyCrypto.bat as Administrator

if it doesn't help,

- uninstall ActivePython, switch user account (Login as a different user, preferred Administrator account),

install ActivePython again, choose Install for All Users if you are asked to, run !install pyCrypto.bat again (run everything as Administrator)

I hope, this helps. If not, you need support from ActivePython on how to install it correctly and run the Python Package Manager pypm. I can't give that support, it's a problem of the software ActivePython!
[Android Apps and Games] gaurav.prabhu01:
getting error while drag n drop

Hi friend,

I have done all the steps in Howto..... but still getting the below error....

1) extactor files are on desktop xyz folder

2)database file are on desktop abc foler

installed activestate in c:

run install !install pyCrypto.bat -----> run perfectly

but when i drag an drop any database files getting the below error....

C:\Users\Vasudev\Desktop\my-crypt>python "C:\Users\Vasudev\Desktop\gaurav\whatsa

pp_xtract.py" C:\Users\Vasudev\Desktop\my-crypt\msgstore-2012-10-05.1.db.crypt

'python' is not recognized as an internal or external command,

operable program or batch file.

Press any key to continue . . .

It would be great if any one can help me....

Thank you in advance.
[Android Apps and Games] gaurav.prabhu01:
great

:good::laugh:

great it worked .... thnankyou very very much
[Android Apps and Games] ztedd:
Drag and drop mostly seems only to work if the database files are in the same folder as the script. However, glad you made it! :)
[Android Apps and Games] paperogiallo78:
Great work, really. :)

I wonder if there's any chance to get a backup useful to perform a restore on a different kind of device. In my case, from iOS to Android, as I switched platform a few days ago... ;)

Thanks for helping!
[Android Apps and Games] boldo:
It´s going to be usefull to me.

Thanks!!!
[Android Apps and Games] gaurav.prabhu01:
One doubt

Hi Friend.....

Im a bit confused. :confused:

1) The automatic backup will happen between 1am to 5am.

if i delete all the chat history before backup i.e( 1am to 5am) then will that capture the deleted chat history ?

2)can we make any automation which takes backup on hourly basis?

Please dont mind for my silly questions and would like to hear you experts .:)
[Android Apps and Games] CJCord:
1.) afaik: deleted means deleted!

2.) BUs are made by whatsapp. either make a feature request, or do it manually
[Android Apps and Games] ztedd:
It seems like ark0n3 is working on a solution for converting the whatsapp database from iOS to Android:

http://xdaforums.com/showthread.php?t=1583021&page=29#post32036484
[Android Apps and Games] ztedd:
I'm not quite sure anymore. I have seen whatsapp database files which contained more text messages (as seen in the HEX Editor) than Sqlite and the Whatsapp Xtract tool were able to show. So maybe sometimes deleted messages are still left in the database file somehow.

But I guess if you delete the whole chat history, then it will be cleared to a new and very small database file and the older messages are gone completely.

Regarding your second question: If your phone is rooted and you've got the app Tasker installed, you may create a script for it. The script should copy the database file from /data/data/com.whatsapp/databases/msgstore.db to a defined location on the sdcard and rename it somehow using the date and time. That should be possible.
[Android Apps and Games] dbarrera:
This is a "security issue" for the messages...

When you delete the chat, is much like a clear or cls command in terminal, it cleans the "chat space" but history still remains, which are the .db and .crypt files...
[Android Apps and Games] ztedd:
New emoji2 smileys emoticons

Does anyone know if there is a website containing the new emoji2 smileys and utf-8 codes, similar to this:

http://www.easyapns.com/iphone-emoji-alerts

?
[Android Apps and Games] gaurav.prabhu01:
hi...

cpould you please hlp on this part....

1) how we can make request for feature or

:)
[Android Apps and Games] CJCord:
dunno, sry. you have to ask Whatsapp support. I think they wont bite you ;)

but you can still make a backup by yourself. search in WA manus. Options button => Options => Backup Chathistorie (or similar)
[Android Apps and Games] gaurav.prabhu01:
Ist getting intresting...

Great frendo......

1) "If your phone is rooted "---> how to root that....

2) I dont have much knowledge on the scripting !!! what is the MOP for this scripting.

3) My last query is is there any way we can see our chat details on spot online remote view by third paty?

Thanx for sharing valuable knowledge .... this is helping me alot to grow my knowledge ...:good::)

God day
[Android Apps and Games] ztedd:
Obviously, you want to spy on someone. I won't help you with that.
[Android Apps and Games] didb:
Doesn't work for me on the Mac

Last login: Tue Oct 16 20:58:31 on ttys000
MacBook-Pro:~ [username]$ /Users/[username]/Downloads/Whatsapp_Xtract_V2.1_2012-05-16/whatsapp_xtract_android_crypted.bat ; exit;
/Users/[username]/Downloads/Whatsapp_Xtract_V2.1_2012-05-16/whatsapp_xtract_android_crypted.bat: line 1: @ECHO: command not found
/Users/[username]/Downloads/Whatsapp_Xtract_V2.1_2012-05-16/whatsapp_xtract_android_crypted.bat: line 2: fg: no job control
/Users/[username]/Downloads/Whatsapp_Xtract_V2.1_2012-05-16/whatsapp_xtract_android_crypted.bat: line 2: fg: no job control
/Users/[username]/Downloads/Whatsapp_Xtract_V2.1_2012-05-16/whatsapp_xtract_android_crypted.bat: line 3: @ECHO: command not found
python: can't open file 'whatsapp_xtract.py': [Errno 2] No such file or directory
/Users/[username]/Downloads/Whatsapp_Xtract_V2.1_2012-05-16/whatsapp_xtract_android_crypted.bat: line 5: pause: command not found
logout

[Process completed]

I've installed ActivePython 3.2.2.3 and opened the whatsapp_xtract_android_crypted.bat file in terminal.app. This is what I've got.
[Android Apps and Games] ark0n3:
that's right, and i got it succesfully tested by another user! i'm working out some perks like media management but the plain messages are already migrated with no problem whatsoever
[Android Apps and Games] aced84:
Thanks, Ztedd, this detailed compilation of information and tools helped me a lot! Appreciate that so much.

I can't seemed to post a link yet so I will try to compose a few more posts before replying to one of your earlier posts asking for the new emojis website...

Aiden
[Android Apps and Games] aced84:
Ztedd, I am also wanting to ask about the conversion of new emojis for my WhatsApp chats in my Samsung Galaxy Tab 7.7, and that's how I found out about this post.

Before that, I just want to thank you because your detailed tutorial enabled me to at least back up and store my important WhatsApp chats on my computer! :)

I found out a site: iemoji.com, they are having the new emojis.

The old emojis matches the code and the emoji icons that you provided for us in your Whatsapp Backup Messages Extractor, inside the [data] folder.

For example: e057 , this emoji shows us the emoticon of a "smiling face with open mouth". On their site, you can get the same information as well: http://www.iemoji.com/view/emoji/3/smileys/smiling-face-with-open-mouth

But I tried to look for a new emoji's code, they don't have the old code for it anymore.. Example: "Face with Look of Triumph" - http://www.iemoji.com/view/emoji/822/smileys/face-with-look-of-triumph

Not sure if this is going to help, but I tried my best to get you the information you need in order to help us all in here :) Thanks again for your help!

May I know if there's any way I can donate some funds for you for your hardwork? I'm using Paypal though...

All the best, Ztedd!

Aiden
[Android Apps and Games] ztedd:
new smileys

Thanks for your hints regarding the new smileys.

Unfortunately, I don't have the time to update it yet.

If you want to donate to me, please buy a ukash or paysafecard code and send it to me via private message.
[Android Apps and Games] tippoint:
hey =)

Hi

ich hoffe du/ihr könnt mir helfen!

ich versuche es schon seit mehr als drei Tagen das es funktioniert, aber es will einfach nicht klappen!

ich habe alles installiert was man dafür braucht:

> ActivePython 2.7 (32Bit)

> Den Zip-Ordner entpackt

> wollte dann die Install pyCrypto Datei instalieren, aber es ging nicht. So habe ich dann über den 'Python Package Manager' mit der Eingabe 'pypm install pycrypto' und er hat auch irgendwas installiert. Doch es geht immer noch nicht.

Das passiert wenn ich die Datei 'install pyCrypto.bat ausführen will.

und das wenn ich es über den 'Python Package Manager' mache

Danke für die Hilfe schonmal =)
[Android Apps and Games] CJCord:
Wie dir vllt aufgefallen ist, ist das hier ein internationales forum: englisch bitte;)

("How might have seen this is an international forum: english please")

Who cant read what he says:

...
[Android Apps and Games] cavelgino:
Please HELP!!! whatsapp backup

Hi All,

I've recently lost my phone... and of course my whatsapp history was gone... i do have a backup.... and tried to encrypt it... i followed at least 15 times all the steps which are described... i installed... uninstalled... installed... uninstalled and so on.... unfortunately i am not sooooo good with computers and programs etc. etc.

If I read the instructions it seems to me done in less than 30 minutes for a "specialist"..... is there anybody out there who could help me please?

i could send you the whatsapp backup by email... you encrypt them and send them back in word, pdf, notepad... anything.... even willing to pay for the invested time... pls. contact me if you can help on cavelgino@yahoo.com

oww its an android phone... samsung galaxy and the files i have as backup... are like msgstore-2012-10-01.1.db etc.

thanks a lot !!
[Android Apps and Games] frenzyboi:
Do you mind zipping the files and PM-ing me the zip file? I could try! Had done it before and encountered no problems(: No gurantee though but I will try my best!

EDIT : Successfully extracted the content of the Whatsapp message!(: Send me the "msgstore.db.crypt" file if possible!
[Android Apps and Games] ztedd:
According to your second screenshot, pypm is already installed. That's to say, Whatsapp Xtract should work. Did you try it?

According to the first screenshot, Python isn't installed in C:\Programme\Python27. Maybe try to uninstall, reinstall in the correct location, then run !install pyCrypto.bat, then run Whatsapp Xtract Script.

Make sure to use the newest version, download on the first page, the one on google code is outdated!
[Android Apps and Games] carysai:
I hope I can transfer android records to IOS:confused:
[Android Apps and Games] jouce:
awesome tool

Thanks for this awesome tool.

I have successfully generate the html file, but I got some error messages during the execution and found some problem in html too.

1.All the images are missing in html file. I still have these images in my iPhone, but how can I link them?

2.Some strange message shows in html. I don't know if it was something to do with the error during generating?

Thanks for your help:good:
[Android Apps and Games] Brostorm:
Could someone extract and do the program for me?

Dear community,

I am struggling for 3 days now trying to get my mgstore.db.crypt to get read by the program. I can´t seem to figure out what is going wrong.

I got the files from micro SD and I don´t have a android phone atm. I hope you guys could help me recover the whatsapp history if I send the needed data to you.

With kind regards,

Bro

(if anyone wonders I get a error when trying to drag my database into the drag databse here called: sqlite3.operationalError unable to open database file)
[Android Apps and Games] frenzyboi:
Send the correct files to my inbox [PM me]. I'll do it for you. Can't guarantee it will work since you got an error but I will try my best since I am able to decrypt mine.
[Android Apps and Games] Rodemire:
"Not authorised" message on multimedia content

Hi guys,

I lost my phone data when my phone (HTC Desire Z) died on me. There'd some Whatsapp data that i had backed up, and i can access it using the Whatsapp Xtract. However, i cant access my pictures that i sent and received. I can see the pictures but when i try to open the full image for me to resave it, i get the error "Not Authorized" in my browser.

Is there a way i can acces the multimedia data?
[Android Apps and Games] Marvi70:
1. copy the whole media folder into the whatsapp-extractor directory

2. sorry.. no idea :eek:
[Android Apps and Games] Untamed86:
Not Authorized

I have the exact same Problem as stated above... It seems to have just stopped working, after some Whatsapp update... They must have changed something with the database files... at least on Android, don't know about iPhone...

I haven't chanced anything on my Pc, and I have the latest version of the Xtractor installed...

If someone could help, that would be great :)
[Android Apps and Games] jouce:
It's not work for me :crying: :crying:

The image url in html are like "0aebb5128d82fb46ed16073729f0de78.jpg"

but the images copied from iPhone are like IMG_0635.JPG

any ideas?
[Android Apps and Games] flakesnow:
Hey, in this Script the new Smiles (after update) don't get replaced.

Can somebody tell me, in what a relation the unitext and the emoticon-filenames stand?

I could finde out a little bit. But not enough to insert all new 330 replace command.

e.g.

em_1f61b.png = unitext replace command \uD83D\uDE1b

i thought the 61b is the key. 6=f -1 = e + 1b = uDE1b

em_1f352.png = unitext replace command \uD83C\uDF52

but this don't work for here. So any Ideea?

I will post the smilie extention if i get it work.

The old emoticons was quite easier.

e013.png is \ue013

e23f.png is \ue23f

i hope you unterstand what i mean. thanks
[Android Apps and Games] Howdyho_84:
Not havin all contacts

When i open my Chatstorage.sqlite with wordpad i have some contacts and normal chats that i dont have when i use the Xtract... and look after it to the html file.

Do you have an idea what that could be!?
[Android Apps and Games] ztedd:
Correct linking of Images

1. Make sure inside the whatsapp xtract folder (where whatsapp_xtract.py is located and where you put the msgstore.db or msgstore.db.crypt file) is a folder "Media" containing a folder "WhatsApp Images" containing all the images.

2. Run the Whatsapp Xtract Script with your database file (msgstore.db or msgstore.db.crypt)

3. Now next to each image thumbnail you have a link "| Image". If you click on it, the corresponding image in the \Media\WhatsApp Images\ directory will open in a browser popup.
[Android Apps and Games] ztedd:
deleted messages still in file but not showing up

I have no idea yet. This weirdness already is on the feature request list:
[Android Apps and Games] ztedd:
Could you please post the new smiley package? Maybe I can include them into Whatsapp Xtract.
[Android Apps and Games] ztedd:
The image links like "0aebb5128d82fb46ed16073729f0de78.jpg" are links on the online images. These are deleted some ~3 weeks after initial upload to Whatsapp.

To get the offline images links, the images have to be inside the \Media\Whatsapp Images\ directory. Like described in the recent posting above.

But you also mentioned some errors showing up during conversion. Maybe this is due to a changed database structure in the Iphone databases again. I only could update Whatsapp Xtract if you would send me a copy of your Iphone Database file Chatstorage.sqlite.

Here you can contact me via private message: ztedd.
[Android Apps and Games] jouce:
Update: unfortunately it looks like only recently images can be found, others are 404 error…

I followed these steps and finally I can only get images by click the red "X" icon, but I still can't "see" images in HTML directly like the fist post of this thread. Is there any way to resolve that?
[Android Apps and Games] banman008:
problem plzzz help

C:\Users\d2ay\Desktop\Whatsapp_Xtract_V2.1_2012-05-16(1)>python whatsapp_xtract.

py ChatStorage.sqlite

Python Version 2.x

Android mode!

trying to repair android database...

trying to decrypt android database...

Error during decrypting: Input strings must be a multiple of 16 in length

Could not decrypt database file. Guess it's not a valid Android/Iphone database

file or Whatsapp changed the encryption.

C:\Users\d2ay\Desktop\Whatsapp_Xtract_V2.1_2012-05-16(1)>pause

Press any key to continue . . ."

plzzz let me know what to do