FORUMS
Remove All Ads from XDA
Honor 7x
Win an Honor 7X!

[TOOL] Whatsapp Xtract: Backup Messages Extractor / Database Analyzer / Chat-Backup

205 posts
Thanks Meter: 281
 
By ztedd, Senior Member on 5th April 2012, 08:13 AM
Post Reply Email Thread
3rd May 2012, 02:53 PM |#101  
OP Senior Member
Thanks Meter: 281
 
More
images do not show
Quote:
Originally Posted by Mayn

Send you email

Thanks. The newer mail I want to answer here, since it may be of interest for others as well:
Quote:

I don't know what's wrong with my DB but when the html opens, I still get an error (screenshot 3).


When I click on the left lnik, I get a "can't find webpage" page.
When I click on the right link I get an error (screenshot 1).


But I don't get errors after conversion anymore!

Thanks!

Showing of images is optional. You need to copy the media files in the correct folder.
As explained in the Readme and in the 3rd post on page 1 - Some Additional Information - MEDIA FILES:
Quote:
Originally Posted by ztedd

MEDIA FILES

If you want to watch the videos, audios and images, you can click on the thumbnails and media links. Popups should open displaying the media.
However, online media files are available only for the last ~ 3 weeks.
But you still can open the offline media files, they are linked as well.
For this it is necessary to copy the folder "Media" from /sdcard/Whatsapp (Android) or net.whatsapp.WhatsApp (Iphone) to the certain folder of your computer where this tool is installed.

In your case, the image files need to be in the folder
.../WhatsApp/Media/....@s.whatsapp.net/
so that e.g. the file
.../WhatsApp/Media/....@s.whatsapp.net/6236....f.jpg
can be displayed correctly.

Use Itunes Backup and an Iphone Backup Tool like I-Twin or Iphone Backup Extractor to get the files.
Attached Thumbnails
Click image for larger version

Name:	Clipboard02.jpg
Views:	8914
Size:	24.7 KB
ID:	1038347   Click image for larger version

Name:	Clipboard03.jpg
Views:	8879
Size:	26.1 KB
ID:	1038348  
 
 
3rd May 2012, 02:56 PM |#102  
OP Senior Member
Thanks Meter: 281
 
More
Question empty msgstore.plain.db file with 0 kb
Quote:
Originally Posted by Ruddy13

Hi,Sorry for the inconvenience but I installed the ActivePython and the
crypto module, everything worked fine but all I get is the message:

"decrypted database written to msgstore.plain.db
Error: no such table: chat_list"

The result is a msgstore.plain.db file with 0 kb.
No browser opens.

I have no idea what went wrong on decrypting your
msgstore.db.crypt file. Maybe you could send me that file and I have a
look into it.

Which version of
- Windows
- ActivePython
- Whatsapp Xtract
- and Whatsapp on Android
do you use?

Which input file did you use? Did you use msgstore.db.crypt from the android SD card?

What does your input file look like? How big is it? What is
the content of the beginning of the file, if opened with an editor or
hex-editor?
3rd May 2012, 03:21 PM |#103  
PulseDroid's Avatar
Senior Member
Thanks Meter: 2,440
 
More
Works gr8 thanks


PS:That guy you text has a gr8 name (same as mine) LOL!
3rd May 2012, 03:40 PM |#104  
Junior Member
Thanks Meter: 0
 
More
Deleted records
Hi ztedd

Thanks for the last update, works perfectly now on Iphone....

Am I mistaken or does the deleted records not display? I'm sure it showed deleted records from my Android, unless it was because it was records from when I had another sim in - Guess I will need to verify, unless someone knows the answer already?

Cheers
3rd May 2012, 04:10 PM |#105  
OP Senior Member
Thanks Meter: 281
 
More
Question
Quote:
Originally Posted by dradeloos

Hi ztedd

Thanks for the last update, works perfectly now on Iphone....

Am I mistaken or does the deleted records not display? I'm sure it showed deleted records from my Android, unless it was because it was records from when I had another sim in - Guess I will need to verify, unless someone knows the answer already?

Cheers

Please, do the following:

- Download, extract and Run SQLite Database Browser
http://sqlitebrowser.sourceforge.net/
- open ChatStorage.sqlite with SQLite Database Browser
- go to "Execute SQL" tab
- paste this SQL String and then click "Execute query":
SELECT * FROM ZWAMESSAGE WHERE ZCHATSESSION Not In (Select Z_PK From ZWACHATSESSION)
- make a screenshot of the result and post it here (you may blacken parts with private data)

This will help me to get more information on the question whether there are messages that the script doesn't show.
3rd May 2012, 04:16 PM |#106  
Member
Flag Hechtel-Eksel
Thanks Meter: 4
 
More
Quote:
Originally Posted by ztedd

Showing of images is optional. You need to copy the media files in the correct folder.
As explained in the Readme and in the 3rd post on page 1 - Some Additional Information - MEDIA FILES:

Yes, you're right, I should have read that!
Anyway, it's working like a charm now!
Many thanks!!
3rd May 2012, 04:41 PM |#107  
OP Senior Member
Thanks Meter: 281
 
More
great!
3rd May 2012, 04:54 PM |#108  
Junior Member
Thanks Meter: 0
 
More
No records
Hi ztedd

I ran the script and no records were generated. So I presume that deleted records are REALLY deleted

Cheers


Quote:
Originally Posted by ztedd

Please, do the following:

- Download, extract and Run SQLite Database Browser
- open ChatStorage.sqlite with SQLite Database Browser
- go to "Execute SQL" tab
- paste this SQL String and then click "Execute query":
SELECT * FROM ZWAMESSAGE WHERE ZCHATSESSION Not In (Select Z_PK From ZWACHATSESSION)
- make a screenshot of the result and post it here (you may blacken parts with private data)

This will help me to get more information on the question whether there are messages that the script doesn't show.

3rd May 2012, 05:48 PM |#109  
OP Senior Member
Thanks Meter: 281
 
More
Yes, that seems to be the case unfortunately...

Whatsapp Xtract only can extract those messages that are inside the database. If they are deleted already, it can't help. (Maybe an older backup would contain them)
4th May 2012, 09:00 AM |#110  
OP Senior Member
Thanks Meter: 281
 
More
Lightbulb
received this question by PM:
Quote:

I really really need help with this Whatsapp xtractor;

I have tried so hard to understand and follow this;
1. Root your android phone or use any other method to get access to the folder
/data/data/com.whatsapp/databases

2. copy the files "msgstore.db" and "wa.db" to a certain folder of your computer

...

BUT I don't know what the hell I am doing. I am not a technophobe, nor am I a developer, or similar. I just really need to get the chats downloaded off a Samsung Galaxy Ace (GT-S5830) as they contain critical info I need to download to my PC. Can you tell me what I have to do in practical terms please?

The HowTo that you have quoted refers to an older version. The new version is able to decrypt the msgstore.db.crypt file that you can find on the SD card of your Samsung Galaxy Ace. I guess you know how to connect your Samsung to your Computer and copy files from the SD card?

Do this:
- in Whatsapp, go to settings - more - Backup Chats and hit Backup
- then connect the mobile to your computer, copy the whole folder /WhatsApp to your computer to e.g. C:\WhatsApp
- on your computer in folder C:\WhatsApp, copy the file C:\WhatsApp\Databases\msgstore.db.crypt to C:\WhatsApp
- download and extract the newest version of Whatsapp Xtract (download link in first post) and extract the .zip file also to e.g. C:\WhatsApp
- Now msgstore.db.crypt and the new files, e.g. !README.txt should be in the same folder, e.g. C:\WhatsApp
- Now download and install Activepython (see Howto in first post)
- Now run "install pyCrypto.bat"
- Now everything should be prepared. Now you can run "whatsapp_xtract_android_crypted.bat"
4th May 2012, 10:50 AM |#111  
Junior Member
Thanks Meter: 0
 
More
Smile
Hi ztedd,
works great on Android.
But in the title of HTML-File is a little bug. It shows the phone-number of some contact and not of the owner.
Post Reply Subscribe to Thread

Guest Quick Reply (no urls or BBcode)
Message:
Previous Thread Next Thread
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes