yashsingh1/xdaforums huggingface dataset:
[Android Apps and Games] parkxx:
not working .. help

I did all that was in the read me file, this was the outcome:

C:\Users\*****\Downloads\Whatsapp_Xtract_V2.2_2012-11-17 (1)>python wh

atsapp_xtract.py msgstore.db.crypt

Python Version 3.x

Android mode!

trying to repair android database...

trying to decrypt android database...

Traceback (most recent call last):

File "whatsapp_xtract.py", line 1344, in main

c1.execute("SELECT * FROM chat_list")

sqlite3.DatabaseError: file is encrypted or is not a database

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "whatsapp_xtract.py", line 1362, in main

c1.execute("SELECT * FROM chat_list")

sqlite3.OperationalError: no such table: chat_list

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "whatsapp_xtract.py", line 2453, in <module>

main(sys.argv[1:])

File "whatsapp_xtract.py", line 1371, in main

from Crypto.Cipher import AES

ImportError: No module named Crypto.Cipher

C:\Users\*****\Downloads\Whatsapp_Xtract_V2.2_2012-11-17 (1)>pause

Press any key to continue . . .

Please help
[Android Apps and Games] NoobQueen:
not found

hey guys,

i have a problem with the "install pycrypto" he want to installi it and open the black window. but he cant inastall cause he cant found the instruction ""SetEnv" . so i tryed to install it manuell with the instruction "install pypm pycrypto" there he say the same. please help me. can't read all the 70 side's ^^

View attachment 2247783

so sorry for my bad english i will write it in german aigain. maybe it is better for the german guys.

also...soweit ist alles ok bis er es installieren will. hier sagt er mir (wie auf dem bild zusehen ist) das der befehl falsch geschrieben ist oder er ihn nicht finden kann. ich habe aber nichts umgeschrieben.

der thread hier ist ja schon recht voll daher blick ich langsam nicht mehr durch, sonst hätt ich mir das vielleicht selbst erklären können. so komme ich aber nicht weiter. achja und den befehl "install pypm pycryton" der funktioniert auch nicht (hab ihn nicht mehr richtig im kopf aber hatte ihn richtig abgeschrieben)

a short help would be really nice

thank you

edit: found the problem... :D SenEv not in the right fulder :) im ok thank you

edit: -.-* "error - set value : der vorgang wurde erfolgreich beendet" was!?/what!?

C:/users/neuer ordner<2>> SetEnv -a pythonpath "c:/pythonpath32"

error - set value : der vorgang wurde erfolgreich beendet.
[Android Apps and Games] romab:
Problem with file

When I run on the whatsapp_xtract_android_crypted,I get this error:

"Could not find the database file. Guess it is not an Android or iPhone file".

What can I do? and what can be the cause? This files were copied from the SD card and I don't have the phone anymore.

Thanks for the help
[Android Apps and Games] Bonaz93:
Hi guys! thanks for the very useful tool ztedd :good: Here it worked perfectly except for one thing: in my whatsapp database (Android system) i have also other .db.crypt files in addition to the classic msgstore.db.crypt.

Those files have different names like msgstore-2013-09-11.1.db.crypt....since once i have lost all my whatsapp chats im hoping they are somewhere in those files, but with your method i can't decrypt and export to html those databases because the shell tells "msgstore.db.crypt file not found!". So i have tryed to simply rename those files so that phyton would recognize them....but when i try again with the new name it tells "Could not open database file. Guess it's not a valid Android or Iphone database file.". How can i do? Thanks a lot again!:)
[Android Apps and Games] pc9099:
Error no 2 "No such file or directory"

I'm not sure if I misunderstood but it seems that the newest version works for db.crypt files as well? I'm using a mac and when running the command "python whatsapp_xtract.py msgstore.db.crypt" through Terminal I get the error message "can't open file "whatsapp_xtract.py [errno2] No such file or directory"

I've installed Active Python, pyCrypto and the latest version of Whatsapp Xtract. Thanks!
[Android Apps and Games] rabah_vip:
help

hello, I'm new here and i hope that you will help me .

i tried this app ( xtract ) and it work perfectly but i need some help

this app open me the chat that is in the database but it cant show me the deleted messages ( deleted by phone ) it show maybe just 1 or 2 conversation but in reality there is a lot of conversation that is already deleted . so anyone can help me to retrieve this deleted chat , there is anyway to recover this chat and show it . thank you guys and hope anyone can help me because i really need to find the chat because its a big issue thanks
[Android Apps and Games] Adler122:
You also get the file open "MsgStore.bak.2"?
[Android Apps and Games] JuLePe:
If you use an android device:

Every day, at 4:00 am, whatsapp backups the database into the folder "Whatsapp" of the sdcard, try with one of these archives (msgstore-year-month-day.db.crypt). Extract and rename it to msgstore.db.crypt and try. The latest 7 databases are stored.
[Android Apps and Games] maverick0219:
what is ZSTANZAID?

Hello,

I am new here, does anyone know what ZSTANZAID in the ZWAMESSAGE table of the ChatStorage.sqllite does? What does it define?

Thank you,
[Android Apps and Games] Sridhar1984:
I am also having the same error ... how did u overcome it?
[Android Apps and Games] alexus96:
Thans a lot for this tool!

Can I add these chats that i have extracted to another backup?

Or can I join two backups???
[Android Apps and Games] jeroenvtec:
Worked after update

Hi

thanks for the script.

I ran into line 2453 errors

but after the updated script on post 605 it is working fine.

I used linux btw

Regards
[Android Apps and Games] rabah_vip:
help

thank you for your reply but i mean the same database the xtract show something and another program show another so why ? is there any program to show all what is inside this databases even thought the chat is deleted from whatsapp

hope you will understand what i mean . and thank you very much . hope any one could help me
[Android Apps and Games] JuLePe:
Yeah! I understand what you mean.

You're are right, there are a lot information in the database, every row is the info for the corresponding message (message, date, media info, etc.), but Whatsapp Xtract just takes the info that it needs to show the conversations.

If you have deleted a message, that message is NOT in the database; so, it's not possible to see it again unless you've got a stored database prior to deleting the messages.
[Android Apps and Games] amitshardule:
Whtsapp Extractor

Hi All,

I have done all the steps as given in whtsapp extractor guide.

after that i have draged database file into batch file as well.

but whr is my output or HTML file get saved?
[Android Apps and Games] JuLePe:
HTML file is in the same directory (where msgstore.db and whatsapp_xtract.* are)
[Android Apps and Games] JuLePe:
whatsapp_xtract.py for WhatsApp Messenger 2.11.xx

If you have a rooted device and extract wa.db to get a HTML with the name of your contacts instead of the number, you'll have noticed that it doesn't work. That is because the column "id" has been changed to "_id", in wa.db.

I've edited that in the section # ANDROID WA.db file *** wa_contacts TABLE # (curr_chat = Chatsession(chats["_id"]) and now it works.

The attached file has been modified from WhatsApp Xtract v2.2. If you like v2.52, do it yourself, just Edit with PythonWin

Right now, I'm facing other issues:

1. Some emojis, received from apple devices, are not shown in the output (HTML) because there are not PNGs for those codes.

i.e. With Mozilla Firefox, I see 01F305, 01F37B, 01F3C7, 01F3CA, 01F433, 01F436, 01F463, 01F622, 01F6A2

I fixed it easily. Looking for the emoji, that is shown in my device, in the emoji folder and adding some lines to # Smileys conversion function section.

(I don't know how my device shows the emojis because I can't see the corresponding PNGs in whatsapp.apk)

2. Some links for media files are not made by the script. WhatsApp Xtract searches for media files by date and size, but sometimes the size, stored in media_size, doesn't match. So, to get a good HTML I have to edit msgstore.db and change the value in media_size.

I'm not a programmer, that's why I don't know whether this will be possible. I could see that the name of the media file is not in media_name but in thumb_image in a BLOB data, therefore I would like to raise a question, is it possible to get the exact media name from the BLOB in thumb_image column and not using day and size?

PS A file (BLOB.txt) is inside the attached file as example; and sorry for my English language skills.
[Android Apps and Games] Kaushikjyoti:
help!

Its confusing to follow these steps. I really want to read my whatsapp chat on PC. Please post sample video to show these steps practically.

Thank you

---------- Post added at 06:36 AM ---------- Previous post was at 06:02 AM ----------

what is to be done in 2nd point?
[Android Apps and Games] Kaushikjyoti:
thanks a lot!

it really worked well. thank u really much.
[Android Apps and Games] dannymichaeli:
Please help for convert from python lines to c#

Hi,

First of all, i want to say thanks for backup messages extractor.

I trying to write for me little extractor in c#, but i have a problem to de-serialize of thumb_image.

in python the code is:

y.media_thumb = "data:image/jpg;base64,\n" + base64.b64encode(y.media_thumb).decode("utf-8")

so i trying to do same like:

byte[] encodedbytes = System.Text.Encoding.Unicode.GetBytes(thumbImage);

string encoded = System.Convert.ToBase64String(encodedbytes);

byte[] utf8Decoded = System.Text.Encoding.UTF8.GetBytes(encoded);

File.WriteAllBytes(mediaName, utf8Decoded);

But without success:\

Can somebody help with that?

Thanks.
[Android Apps and Games] anjelika:
Hi.

I'm getting :

C:\temp\whatsapp>python whatsapp_xtract.py msgstore.db -w wa.db
Python Version 2.x
Android mode!

Error: file is encrypted or is not a database

Does it has to do with the new Whatsapp database that everyone is talking about or with the _id column from wa.db?

Anyway, if I'm running just python whatsapp_xtract.py msgstore.db I can see the messages but to correlation with the contacts as it doesn't use the wa.db which holds the contacts.

Any solution to this?

Thanks
[Android Apps and Games] 80000037:
Please add the feature to merge backups from different account.
[Android Apps and Games] MrsXidus:
Whatsapp

Can anyone please help me? I'm stuck on this.

gyazo.com/83d908171f64a2fd4d0a30d3845850ce.png

Whenever I run the "whatsapp_xtract_android" file it gives me that error. And I didn't find any "wa.db" file in my whatsapp folder.
[Android Apps and Games] rosskelly:
erros when trying to open database

hi guys,

I'm trying to use whatsappextract and I keep on getting the same error (I'm using the latest version updated on Novermber 2012).

The error is: "Import error: No module named Crypto.Cipher"

I have attached a screenshot.

Any suggestions are welcome!
[Android Apps and Games] peterjwhite:
thanks ztedd! I had a couple of glitches along the way but managed to merge the .db from my old phone (7,515 messages) with the .db from my new phone (133 messages).

first glitch was the path for python not being found (akeedthe had similar) - perhaps because of installing the x86 version on Win64?

second glitch was the chat_list table was required a lot of manual editing - as well as adding the new chats to the merged chat_list table i had to remove duplicates and update the last message _id number for chats that begin in the old .db but had additional new messages in the new .db
[Android Apps and Games] andcha:
Installed it again today, almost after a year. Just followed your instructions to the point and the installation went flawless. Everything is working perfectly.

Only if we could have an option of exporting the data into excel, that would be like an extra chocolate topping on the cake.

---

The reason I say excel, is because my msgstore.db.crypt is about 22 MB and whenever it automatically opens after decryption, firefox crashes.

---

Okay, so what I did now is stopped the output file from opening automatically by commenting the line no. 2014 "webbrowser.open(outfile)" in whatsapp_xtract.py and since the output file is saved in the main folder, I can open it anytime in chrome.

With that, I also found that the decrypted file gets saved in the same folder with "msgstore.plain.db" name and I can open it in SQLite Database Browser and export the tables whenever required. But still, getting all the tables into excel linked to each other with proper formatting can be so much fun.

Thanks man for making such a wonderful utility.
[Android Apps and Games] Eclipserazer:
Can anyone please explain this right here, i merged the messages DB files, and chat lists.. but it comes up with errors for duplicates.. what exactly do i to change the last message id?

for example

In the old DB.. a contacts _id is 30047 and message_table_id is 30045

In the new DB the same contacts _id is 8875 and message_table_id is 8876

do i have to look through the chat for the last message ive recieved/sent to said person and change both _id and message_table_id?

oh and also, none of the chats are showing up for the contacts at the moment either.. (dont know what exactly im doing wrong but i guess its somewhere)
[Android Apps and Games] Beretta1979:
WhatsApp Xtract Error

I'm getting the same error you mentioned here...have you had any luck getting it to work yet?
[Android Apps and Games] dasich6:
Hi there,

Just used the tool,worked as magic, thanks. But i do have a question; i backuped the chats from whatsapp menu and copied the .db file to the folder and extracted it but i only see the messages from last night. not before or after that. i did talk to people after that time and also before that time. but i'm not able to see them all.

By the way i had deleted all the chat sessions from the main screen of Whatsapp. However i guess whatsapp takes a backup every night. So i think i should see the past chat sessions too i guess?:mad:
[Android Apps and Games] injulia:
very useful tool.

thankyou
[Android Apps and Games] Blinkin89:
By deleting chat sessions the chat sessions will be permanently removed. That's why they call it deleting...

I'm afraid they're all gone now.

You could try Recuva though: http://www.piriform.com/recuva

But wouldn't expect much from it since it's hard to recover files from a flash medium.

Edit: the backups should indeed still be there. They are on your internal sd > WhatsApp > Backups.

The backup files are the crypt files (so you'll only see phone numbers instead of names).
[Android Apps and Games] linkinZA:
Hi

Could you possibly update the install batch script to support ActivePython 3.3?

As 3.3 and 2.7 are the only options to download on the ActivePython site.

Thanks
[Android Apps and Games] tacginc:
Can some tell me if in the Whatsapp DBs, does Whatsapp store the origin IP? Kind of like the header on the an email.
[Android Apps and Games] killwaz:
i managed to work around this error got decrypt files now however when i merged the files and put them back i have 3 conversations that wont open they crash when i click them i went back to the sqlite and tried to understand the problem but no luck ,

the 3 conversations 1 of them is old+new the other 2 are new so i cant really track down the problem
[Android Apps and Games] Anaissy:
Crypte

Can anybody help me please. I have done everthing that was suggested however I still can't open the file :(
[Android Apps and Games] messy2k:
guys,

pls help me ...

i've installed all the files but it does not work at all.

so i deleted all of it and started over again.

i've installed the ActivePython version 33, most of the tutorial here is about the ActivePython version 27.

so i deinstalled the 33, reinstalled the 27 but when i click on !install pyCrypto.bat an error message shows up "missing python 33.dll"

so, how cab i fix this to go on?

i think i need to solve this step by step ....

thx for your help.

messy
[Android Apps and Games] yarabadisudhakar:
Great !!!! thanks

Super cool...works perfectly !!!
[Android Apps and Games] AaMP3rio:
FINE, but there is still a problem

Very useful guide, I followed step by step... and finally I merged 4 backups of conversations :D. Whatsapp detects perfectly the new file. :good:

There is a problem: Somewhere in this process, the integrity of thumbnails are broken. Consequently, when you open a conversation, and trying to load older messages, if you load any message with a thumbnail, whatsapp will crash and will close. :crying:

Is there any solution to this issue?

Thanks. :D
[Android Apps and Games] Blinkin89:
Hi AaMP3rio I think this is caused by how those media previews are saved in the db: as blob data. AFAIK no-one in this forum had mentioned finding a way to extract or manage this data. But I think it something to do with it. When I was trying to combine 2 db's I couldn't copy this blob data for unknown reasons...
[Android Apps and Games] d-vaish:
Error found

I tried to open a database file recovered through a data recovery software but it gave me an error attachment is given.

Please help me to open this file I really need it. Many thanks!
[Android Apps and Games] holographer:
Merge the whattsapp files is something I want to do. Every step seems to work, but when I put the new "merged" msgstore.db crypt file back to my phone I will only see all the old messages, In SQlite compare when I relocate the messages from new file to old one with the "R" button, it seems that not the total messages are there. Somebody knows what's going wrong?
[Android Apps and Games] Fahad143:
Blackberry bold 9870 whatsapp backup db file how to open on pc

I have Blackberry bold 9870 i had taken backup on my pc whatsapp data backup. all files are under dp format i tired many software on net to open it but i was unable please help me how to read or convert as i installed Whatsapp pocket but its only work for my Iphone whatsapp back data not for taking my BB Whatsapp data..
[Android Apps and Games] mading1309:
New database of Whatsapp

Hi to all

I used this working tool a few month ago. Since that time the database encryption seems to be changed. I can open encrypted databases of whatsapp until begin of September. When I try open database with the last version of whatsapp then I get this error message

crypt

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.

I use the version of November 17th 2012 and was working before perfect for my use. BTW the wa.db is empty, I made no use of the address book function. So I think the problem is not related to the change of id to _id. I also checked the forum messages since August 2013, but cannot find information about the new encryption and how to overcome.

Can anyone give a help what to do or give hints, advice or link to overcome this new encryption

thanks your reply in advance

Mading
[Android Apps and Games] Pr3muToS:
doesnt matter what i try.

always getting this error, attached here in a screenshot. :(
[Android Apps and Games] catto:
whatsapp crash after replacing the merged "msgstore.db" file

the same happened to me.

I managed to follow all the steps as explained in here http://xdaforums.com/showthread.php?t=1583021&page=24#post28899881

(after many trial and errors i even managed to manually edit the chat_list records in order to refer to the very last message of each contact) then i merged the two chat histories

when I reinstall Whatsapp the Backup is correctly imported and I see my conversation list; but half of them i can't actually read, because when i start scrolling back, after a little while Whatsapp crashes.

this happens with some conversations from contacts that appear in both files, aswell with conversations from contact that only appear in the more recent file... but not with all of them.

this happened every time i installed a merged database.

i can still access the merged chat history by converting in html... but i really wish i could restore everything in my new phone and continue from there.

can someone tell me what am i doing wrong? any help would be very appreciate
[Android Apps and Games] sparshme:
Manul delete chats with Whatsapp Xtract

When we recover chats, it only shows the last back up time chats as visible in the whatsapp

however also require chats which are manually deleted and present in the back up.

recovermessages give you entire chats with the manual deleted entries, however it is difficult to get full info

kindly help us if we can get those chats which are there in .db.cryot file but was not saved

regards

sparsh
[Android Apps and Games] Blinkin89:
Hi Sparshme,

Like said before a few times in this topic: deleting means it won't exist.

When you delete messages they will be removed.

So in other words: you can't restore what's not there.

The only recovering that can be done (and which is very tricky on flash memory) is recovering the old database if you accidentally deleted it.
[Android Apps and Games] ForrestFalcon:
For every person who has the same problem. You're crypto module isn't installed correctly ;)

Try to install the module per hand. I had the same problem and now, everything is fine. Great job here!
[Android Apps and Games] ricebus:
hi, first of awesome tool.. helped me alot.. second, i wanted to know if i can use it to re-crypt the db ?
[Android Apps and Games] RFA93:
Can you explain this? I don't understand this at all..
[Android Apps and Games] sparshme:
freeblock recover

While taking the back up whatsapp also have the freeblocks data

when you extract the data on the site called recovermessages dot com it gives you lot of free blocks and show you the entries against the deleted records also. however the report is low. would like to know if the freeblock data can also be allocated
[Android Apps and Games] Blinkin89:
I don't really understand you, and I don't know if I can trust that site. It seems suspicious.

But gone is gone, messages that are deleted from within the app will be removed from the database, that's all I know.

And you don't need that site to check it, you can use the free sql tools listed on the front page to inspect to field.

And if they really exist, which means I'm wrong, then you'll also be able to read/extract the messages you deleted.

It's not hard at all. :)
[Android Apps and Games] MrH672:
Stuck ..:(

Please help me out..:crying:

When i m going to open !install pyCrypto.bat it could not find the python directory make sure it is installed on Program files.

I checked and there is a Python folder.

But then why..:confused:
[Android Apps and Games] MartK87:
Cant do it guys. Keep getting this error. any idea why?

Using WinXP 32Bit

Had to move the python27 folder from C: to C:\program files manually because it wasn't seeing it and was tryna find it ion C:\Program Files. Now ive done that though im getting this error.

any ideas what to do?

Thanks.
[Android Apps and Games] nickyt89:
iphone problems

im having a few problems with this for example i hve watched youtube videos and when people click "install pycrypto" there command box comes up and downloads and few other things mine says error no such package found for requirements but still at the end says success: specified value was saved

then im using my iphone "chatstorage" extracted though an iphone extractor and drag and dropping but comes up with a few different errors which i assume will be sorted out if i sort my previously mentioned problem about install pycrypto

any help would be much appreciated