yashsingh1/xdaforums huggingface dataset:
[Android Apps and Games] Potato'sRevenge:
Hi guys,

I just installed both the ActivePython and pyCrypto.bat. However when i run the whatsapp_console_crypto.bat file i get this output:

C:\WINDOWS\system32>cmd.exe /t:A0 /k python whatsapp_xtract.py -h python: can't open file 'whatsapp_xtract.py': [Errno 2] No such file or directory

So i guess some path is set wrong, however i have no idea how to fix this. In case there is already a solution to this somewhere on here, please forgive me for not going through all 134 pages... I hope someone can help me.
[Android Apps and Games] bharathrajpappu:
dear sir...... can you help me...... how can i open db.crypt8 whatsapp backup...... almost all the method i tried... but it didnt open.......please help me
[Android Apps and Games] gds06:
i want to transfer my chat history from windows phone 10 to android ....and merge old chat history of android that i had saved on my pc....plz help
[Android Apps and Games] priyamukher:
Recovery of Whatsapp Database

I had seen your full thread, tried to do something to recover, but not being a developer or techie...it was not possible for me..

my mailid for recovery whatsapp database files backup from my android is

priyamukher@gmail.com

please help and see if anything can be done with it.. Thanks..
[Android Apps and Games] rayman3:
Hi Martina. First i have to thank you very very much for this great tool. I use it for forensic examinations since over 4 years!

But in the last months WA do a lot of changes, so the results of the tool become worse. I try to improve the script, but i failed.

It is to complicated for me.

So is it maybe possible for you to update the script? The problem is, that the pathes of the audio/voice-notes have been changed. WA store it in an other folder (voice-notes - sorted by weeks, not in the folder audio).

The solution would be to let the script search all audiofiles in the folder Audio and Voice-notes including subdirectories. In the moment, i have to copy all audio-files from the folder voice-notes to the folder audio and furthermore WA changed the codec from aac to ogg. So i have to search all aac and ogg files in the (sub-)directories and copy it. That´s a lot of work.

In the near future WA go to start .gif in the chats (the folder is still been created, when installing). Maybe you can take that into consideration :D

I would be glad if this would be possible for you.

Many many thanks to you!

Greets
[Android Apps and Games] Shazaaam1109:
Any working decryption without key?

Hello everybody,

I know the Whatsapp Xtractor is quite a bit older... But is there any working decryption of crypt12 database without having the key? I also can´t get the key, cause it was an older prepaid SIM card...

Can anybody please help?

Thnx in advanced...

Shaz
[Android Apps and Games] Shazaaam1109:
Too bad...

Thnx man!!! Have a nice weekend...

Shaz
[Android Apps and Games] ravitiwari29:
Whatsapp database files

I have some database files of whatsapp but do not have key as device is no longer is available with me but I have SIM card and another rooted device so can I know the how can I read those Database files as it is very important for me.
[Android Apps and Games] mrshanmuga:
iphone database detected as android mode

Hi,

I tried with iphone6, but detects for android mode even if i pass as chatstorage.sqlite. Below is the error:

---------------

C:\Users\Shan\Downloads\Whatsapp_Xtract_V2.2_2012-11-17>python whatsapp_xtract.py ChatStorage.sqlite

Python Version 2.x

Android mode!

trying to repair android database...

trying to decrypt android database...

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\Shan\Downloads\Whatsapp_Xtract_V2.2_2012-11-17>pause

Press any key to continue . . .

-----------------

Could someone please help.
[Android Apps and Games] andy2323:
Hey guys...

I have some Crypt 12 Databases. But i can't open it with Xtract... Can someone help me? Or can i send my Databases to someone, who can send me screenshots.. Its very important for me. So maybe my wife is cheating :-/

Thanks!
[Android Apps and Games] shubhamc521:
Do you found the way to convert Msg.bak.1 into readeble format.

Do you found the way to convert Msg.bak.1 into readeble format.??? Please help me to do this.
[Android Apps and Games] tboy2000:
I wish they made it easier to transfer whatsapp messages from Windows phone to android phone. My mother wants to change he handset but doesn't want to lose all her Windows phones messages. I assume this is not possible to do?
[Android Apps and Games] weopm87:
i have the same problem. any solution?`
[Android Apps and Games] draconda12:
help me

i facing problem

i have copy from old whatsapp db cryptd 12 in my computer

i want to read it and i dont have key cryptd

when i try to use whatsaap xtract this msg appear to me :

==============================================

C:\Windows\system32>"C:\Program Files (x86)\Python27\Scripts\pypm" install pycrypto

'"C:\Program Files (x86)\Python27\Scripts\pypm"' is not recognized as an internal or external command,

operable program or batch file.

C:\Windows\system32>"C:\Program Files (x86)\Python27\Scripts\pypm" show pycrypto

'"C:\Program Files (x86)\Python27\Scripts\pypm"' is not recognized as an internal or external command,

operable program or batch file.

C:\Windows\system32>setx pythonpath "C:\Program Files (x86)\Python27"

plzzzz help me ,,, tell me how to show it
[Android Apps and Games] rdude202:
im getting an error that input strings must be a multiple of 16 or length.kindly help plz
[Android Apps and Games] amit_sawant007:
I finally succeeded in deleting custom chats from Whatsapp's msgstore.db

I was getting an 'unknown subject' chat in my chat screen after deleting a group which was having around 50k messages.I tried a lot but couldn't delete it.

As my phone is rooted, I first copied msgstore.db file from /data/com.whatsapp/msgstore.db into PC.

Then using DB Browser for SQLite I opened that .db file and looked out for group info in chat_list table.

Basically all entries based on groups are stored in database as Group Admin's Mobile number.

So I searched for that group admin's number in all tables and deleted all entries.

Then in DB Browser clicked Write Changes option to save that changes in db file and restored that msgstore.db in whatsapp.

Finally managed to delete that chats of around 50k.
[Android Apps and Games] dadnammit:
So where is the key file stored nowadays on Android Marshmallow? I'm thinking I should make a backup of mine just in case.
[Android Apps and Games] beingzettt:
I accidentally saw password of my brothers phone, then I head on to unlock his phone and check his WhatsApp and what I found was a chat with his girlfrnd, I definitely couldn't read the whole chat as it was way too long to read in under 10 mins, so My question is is there any way I forward the whole conversation from his whatsapp to my whatsapp and later delete my chat from his whatsapp? Or is there any other way? Please explain in detail. I can access his mobile for only about 15 minutes as he never keeps his mobile away from him.

P.S. : I am definitely interfering in his personal stuffs but in a good way as he stays depressed all day I can find out what the problem and help him.
[Android Apps and Games] ria kedia:
using whatsapp xtract tool

i am getting this error :

on giving this command: python whatsapp_xtract.py msgstore.db.crypt12

Python Version 2.x

Android mode!

trying to repair android database...

trying to decrypt android database...

Traceback (most recent call last):

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

main(sys.argv[1:])

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

decoded = cipher.decrypt(open(options.infile,"rb").read())

File "/home/ria/.local/lib/python2.7/site-packages/Crypto/Cipher/blockalgo.py", line 295, in decrypt

return self._cipher.decrypt(ciphertext)

ValueError: Input strings must be a multiple of 16 in length

i am not able to resolve it at all! please help
[Android Apps and Games] saarakura:
Can i use this to view my Whatsapp windows phone bkp ? Thanks
[Android Apps and Games] m.a.r.k.i.94:
error in restoring database

i am able to view msgs in whatsapp viewer but unable to restore it

1. whatsapp db got corrupted couldnt restore backups

2. repaired database after getting key using pycrypto

3.still unable to restore db when installing whatsapp.restore gets stuck at 32%

---------- Post added at 03:21 AM ---------- Previous post was at 03:12 AM ----------

i get the following:

H:\Whatsapp_Xtract_V2.2_2012-11-17>python "H:\Whatsapp_Xtract_V2.2_2012-11-17\whatsapp_xtract.py" H:\Whatsapp_Xtract_V2.2_2012-11-17\msgstore.db

Python Version 2.x

Android mode!

printing output to H:\Whatsapp_Xtract_V2.2_2012-11-17\msgstore.db.html ...

Traceback (most recent call last):

File "H:\Whatsapp_Xtract_V2.2_2012-11-17\whatsapp_xtract.py", line 2453, in <module>

main(sys.argv[1:])

File "H:\Whatsapp_Xtract_V2.2_2012-11-17\whatsapp_xtract.py", line 1921, in main

linkimage = findfile ("IMG", y.media_size, y.local_url, date, 2)

File "H:\Whatsapp_Xtract_V2.2_2012-11-17\whatsapp_xtract.py", line 1266, in findfile

timestamptoday = int(str(time.mktime(datetime.datetime.strptime(date, "%Y%m%d").timetuple()))[:-2])

File "C:\Python27\lib\_strptime.py", line 332, in _strptime

(data_string, format))

ValueError: time data 'N/A' does not match format '%Y%m%d'

Press any key to continue . . .
[Android Apps and Games] Shadow128:
Is this tool still working with actual versions of WhatsApp-databases?

I tried today, but I'm getting following error after using it on my msgstore.db/wa.db ->

Python Version 2.x
Android mode!

Traceback (most recent call last):
File "whatsapp_xtract.py", line 2453, in <module>
main(sys.argv[1:])
File "whatsapp_xtract.py", line 1486, in main
curr_chat = Chatsession(chats["id"],chats["display_name"],chats["jid"],None,
chats["unseen_msg_count"],chats["status"],lastmessagedate)
IndexError: No item with that key

Or is there another tool, which can extract the chat history to a .html file?
[Android Apps and Games] Arimania:
What a great Tool, but no luck i cannot use it because i think it is too old. i already use my own db but not works. Can you please update.

Can you please seperate the tools from extract and opening, i already try using to Whatsapp Viewer (it works), but I saw that your database browser looks better. It can show the name of the sender/contact

Would you please create the database opener separately from extractor?

Thanks before.
[Android Apps and Games] ztedd:
Thanks for your comments. I updated Whatsapp Xtract to work with decrypted databases from Whatsapp Viewer.

Please follow the updated Readme on how to do it. For rooted phones, you find the key at /data/data/com.whatsapp/files/key

For non-rooted phones, you need WhatsApp Key/DB Extractor.

https://xdaforums.com/showthread.php?t=2770982

For decrypting the .crypt12 files using the key you can use WhatsApp Viewer:

http://andreas-mausch.de/whatsapp-viewer/

https://xdaforums.com/showthread.php?t=2719741

New Version of Whatsapp Xtract 2.3 (25.04.2018):

https://xdaforums.com/attachment.php?attachmentid=4485963&d=1524676932

https://www.xup.in/dl,10198311/Whatsapp_Xtract_2.3_2018-04-25.zip/

Then you can continue with this tool, if you even need it (WhatsApp Viewer also is able to show you the chats, but Whatsapp Xtract maybe offers you some additional features and you can quite easily edit the code and enhance it).

Note that for showing contact names you need a wa.db file. Either you retrieve it on a rooted phone from /data/data/com.whatsapp/databases or you create it by yourself using an sqlite3 editor (table wa_contacts with columns _id, jid (=491... [MENTION=1019801]s.w[/MENTION]hatsapp.net), display_name (put the names here), is_whatsapp_user (should all be 1), unseen_msg_count, status).

If someone updates Whatsapp Xtract please post it. For example maybe someone would like to integrate the function to save to several html files (one for each chat), like in this different old version.

Or maybe someone wants to integrate the crypt12 decryption from https://github.com/EliteAndroidApps/WhatsApp-Crypt12-Decrypter
[Android Apps and Games] Phantom Thief:
Thanks so much for this! Does it export in the same way whatsapp sends the chat log through email? Found a tutorial on reddit how to make a graph out of it but my chat history is too big for whatsapp to send since the beginning
[Android Apps and Games] gavinch:
Hi,

I tried the steps for rooted phone and I'm getting these errors:

Python Version 3.x

Android mode!

Traceback (most recent call last):

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

for msgs in c1:

sqlite3.OperationalError: Could not decode to UTF-8 column 'data' with text '\ufffd\ufffd\ufffd\ufffd\ufffd\ufffd\ufffd'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

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

main(sys.argv[1:])

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

print('Error sqlite3.Error while reading chat #{}: {}'.format(chats.pk_cs, msg))

File "C:\Python34\lib\encodings\cp437.py", line 19, in encode

return codecs.charmap_encode(input,self.errors,encoding_map)[0]

UnicodeEncodeError: 'charmap' codec can't encode characters in position 95-101: character maps to <undefined>

C:\Whatsapp>pause

Press any key to continue . . .

:(

I think it's to do with some encoding issues because some of the messages aren't in English.

Anybody have any idea how to resolve this?

Thanks
[Android Apps and Games] ikramsopee:
I updated my lineage os and perform a factory reset. After i finish all the processes, i installed whatsapp. Whatsapp did found my google drive backup. But, after it download the chat history file, the moment whatsapp want to recover my restored whatsapp chat, its stuck at 24% and says "Sorry we were unable to restore your chat, you want to backup older chat" and the backup older chat takes forever to finish. Please help me. Its so frustrating. My crypt file is crypt12.
[Android Apps and Games] Kiyoshiii:
Hey!

I'm trying to follow these steps

But after that my Whatsapp doesnt "see" the msgstore.db it seems and proceed to setup the app without any chats being restored.

Does it need to be encrypted to crypt12 again or am I missing some step you need to do nowadays?

I tried several ways and I'm really clueless by now
[Android Apps and Games] dmitry.petruhin:
How I can decrypt image from URL /mmg-fna.whatsapp.net/d/f/An2IzW.enc
[Android Apps and Games] murilogoes:
Error: no such table: wa_contacts

I've copied a "msgstore.db" from a rooted android smartphone, and when I drag and drop the file in the "whatsapp_xtract_android", I've received the message "Error: no such table: wa_contacts". Anyone knows what is going on? Thanks!
[Android Apps and Games] sban7:
Not working for iphone backup

I've used the tool earlier, and it used to work. But off-late, it doesn't.

I'm using it for iphone whatsapp database. I click on "whatsapp_xtract_iphone.bat" but it detects it as Android database and gives the following error error.

--------------------------------------------------------------

python whatsapp_xtract.py ChatStorage.sqlite Python Version 2.x

Detected an SQLite database

Android mode!

Checking Android database integrity...

Android database has integrity issues. Attempting to fix it...

Error: sqlite3 file not found!

Get it from sqlite-org-download-html

Correct download for Windows users begins with "sqlite-shell-win32", put file in same directory as this script

D:\WhatsappXtract>pause

Press any key to continue...

--------------------------------------------------------------

Hope someone can help me out.

Thanks
[Android Apps and Games] Poesknol:
It is doing nothing

Hey guys,

I have a question, i tried the tool on an old (image is from 2016) database, but it is doing nothing.

when i put my msgstore file in, it it only says: "Android mode!" and then it jumps back to the input.

if i try to open it in Whatsapp viewer is says: "cant open database, maybe an old one" (something like that).

what can i try to do?

When i open the file in notepad i can read some messages, so there is something.

Thanks in advance!!
[Android Apps and Games] nflug:
Error from Iphone Mode 2.x

Hey I get this error when I run the xtract_iphone.bat:

What can I do?

Error while reading chat #161: timestamp out of range for platform localtime()/gmtime() function
Traceback (most recent call last):
File "whatsapp_xtract.py", line 2479, in <module>
main(sys.argv[1:])
File "whatsapp_xtract.py", line 1692, in main
curr_message = Message(msgs["Z_PK"],msgs["ZISFROMME"],None,msgs["ZMESSAGEDATE"],msgs["ZTEXT"],contactfrom,msgs["ZMESSAGESTATUS"],media["ZMEDIALOCALPATH"],media["ZMEDIAURL"],media["ZTHUMBNAILDATA"],ZXMPPTHUMBPATH,mediawatype,media["ZFILESIZE"],media["ZLATITUDE"],media["ZLONGITUDE"],media["ZVCARDNAME"],media["ZVCARDSTRING"])
IndexError: No item with that key
[Android Apps and Games] depii:
I changed some code for me of the base version 2.3. It worked with my android whatsapp 2.18.327 and python 3.7.1. Maybe it can be useful for someone else.

v2.3.1 (updated by depii - Jan 1, 2019)

- fixed message count

- output in one HTML-file per chat

- removed online media links

- fix linking to offline media, ppt media too

- new findfile functions, search now in subfolders

- added media duration

- added info for groups (creator and creation time)
[Android Apps and Games] nflug:
Hey,

now I get this error:

Error while reading chat #267: timestamp out of range for platform localtime()/gmtime() function
Error while reading message #1 in chat #324: __init__() takes exactly 19 arguments (18 given)
Error TypeError while reading chat #324: __init__() takes exactly 19 arguments (18 given)
[Android Apps and Games] depii:
I broke some iphone stuff. Redownload the file, i fixed this. But i don't fix your "IndexError: No item with that key" problem.
[Android Apps and Games] nflug:
But do you know why I get this error? (IndexError: No item with that key)
[Android Apps and Games] Nite.Achilles:
Hi everyone

How do I encrypt the db back? My old db is corrupted, therefore I had to repair it. Now I want to restore it.
[Android Apps and Games] Ashish8017:
Hi

Is there any way to use this method for transferring whatsapp messages from Android to iPhone?
[Android Apps and Games] gh-thomas:
Thank you for this guide @ztedd!

However I couldn’t compare my databases using SQLite Compare because of an error when opening the database. Could it be because of a new format?

Is it possible to use a tool like the Navicat for SQLite (which has a 14-day trial) to successful merge two databases?

And if yes, could someone make a tutorial how it works? I have no clue about SQL :confused:

I also tried merjapp by namnoops and sch3m4's wforensic, but both of them are unfortunately outdated and merge with missing information.
[Android Apps and Games] nioBee:
SQlite Compare problem in merging database

I have a problem at this point, SQlite Compare doesn't work, I get this error:

File opened that is not a database file

file is encrypted or is not a database :confused:

The files are not encrypted, I can open them with WhatsApp Viewer and also with SQLite Database Browser (I did all the steps till nr 5 without problems)

Any hints on how to solve?
[Android Apps and Games] Black Swift:
Hello!

my problem is basically my old phone battery died out, so i got a cheap phone to replace it while i got it fixed, at first the backup worked and i have acces to all the mesages, but the media files are all completely gone, so i started using this new phone for a couple of monts until i got my old phone repaired, when i got back to my old phone i noticed that all the messages and media files from the old phone where there, but mesagges and media files from the new one where missing.

so, the old phone as all old media and old mesagges.

the new phone has all the old and new mesages but only has the new media files.

what whould be the best and simpliest method to merge the backups from both phones into my old phone (wich is way better than the new cheap one, has more space and its rooted)

Cheers!

---------- Post added at 12:54 AM ---------- Previous post was at 12:54 AM ----------

Hello!

my problem is basically my old phone battery died out, so i got a cheap phone to replace it while i got it fixed, at first the backup worked and i have acces to all the mesages, but the media files are all completely gone, so i started using this new phone for a couple of monts until i got my old phone repaired, when i got back to my old phone i noticed that all the messages and media files from the old phone where there, but mesagges and media files from the new one where missing.

so, the old phone as all old media and old mesagges.

the new phone has all the old and new mesages but only has the new media files.

what whould be the best and simpliest method to merge the backups from both phones into my old phone (wich is way better than the new cheap one, has more space and its rooted)

Cheers!
[Android Apps and Games] alecxs:
use WhatsApp from that phone which has old + new chat history. the media files doesn't require this tool, you can just merge the folders via MTP. check your Internal Storage, there is a WhatsApp\Media folder on both phones
[Android Apps and Games] Black Swift:
i tried this but some media files where missing, by example, the voice notes are present in the internal storage, but when i try to listen to them in whatsapp they apear as missing :(
[Android Apps and Games] Black Swift:
anyone? help?:crying:
[Android Apps and Games] Black Swift:
UPDATE:

now i know all the media files are in the whatsapp folder, but when i use the new backup, whatsapp loses track of where all te files are, so even if i have all the mesages, i cant hear an olv voice message by example, if i use the old backup, i can acces all the old files via whatsapp, but i lose all the mesages on the new backup, what can i do to solve this problem?
[Android Apps and Games] Solution6996:
is there a way to 'flip' or reverse the order in which the messages appear on the html file?

I have about 5 years of messages to go through and I'd like to start with the most recent ones, because it takes ages to go through them all and not crash any browsers while loading the file :P
[Android Apps and Games] matchung:
nice app ;) it works thx~

but cannot link to local media file directly, only media folder :(
[Android Apps and Games] ztedd:
That means, the media file is missing. You need to copy the whole android folder /WhatsApp/Media to the Media folder inside the folder where Whatsapp Xtract is installed. Then run the script. But if a certain Media file is missing, it can't be linked.
[Android Apps and Games] matchung:
my bad, it works after re-gen the html. thx!
[Android Apps and Games] thesseus01:
Hi.

I want to use your tool for a db copied from symbian. Have you ever tried it on symbian?

I think my db files are encrypted because I cannot open them with any sql tools.

On the phone i have two files: profile.db and chats.db

Both files start with header (in HEX):

50 00 00 10 BE 0E 00 10 00 00 00 00 1F 23 63 E5

Do you think I will have any luck with these files? :)

Thanks
[Android Apps and Games] Xeon:
having problems here, invalid argument -i

C:\Whatsapp>python whatsapp_xtract.py -i Databases/ChatStorage.sqlite

Python Version 2.x

usage: whatsapp_xtract.py [-h] [-w WAFILE] [-o OUTFILE] infile

whatsapp_xtract.py: error: unrecognized arguments: -i

Any help ?
[Android Apps and Games] ztedd:
I'm sorry, the .bat files in the v2.1 release were buggy. Fixed it now, see the new download in the first post.

Generally, this errors means that the command line parameters were slightly changed. Now the input file is given without the -i parameter, but just:

whatsapp_xtract.py ChatStorage.sqlite

This made it possible to use the easy drag and drop with the new whatsapp_xtract_drag'n'drop_database(s)_here.bat

Now you even can drop several database files and let them convert at once.