New: XDA launches forum for app developers. Discuss coding, tools, marketing, and more.
XDA Developers Android and Mobile Development Forum
Forgot your password?
 
Post Reply+
Tip us?
 
ztedd
Old
#101  
Senior Member - OP
Thanks Meter 145
Posts: 204
Join Date: Feb 2011
Default images do not show

Quote:
Originally Posted by Mayn View Post
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 View Post
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:	3622
Size:	24.7 KB
ID:	1038347   Click image for larger version

Name:	Clipboard03.jpg
Views:	3619
Size:	26.1 KB
ID:	1038348  
 
ztedd
Old
(Last edited by ztedd; 3rd May 2012 at 02:06 PM.)
#102  
Senior Member - OP
Thanks Meter 145
Posts: 204
Join Date: Feb 2011
Question empty msgstore.plain.db file with 0 kb

Quote:
Originally Posted by Ruddy13 View Post
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?
 
PulseDroid
Old
#103  
PulseDroid's Avatar
Recognized Contributor / Themer
Thanks Meter 1636
Posts: 2,019
Join Date: Jan 2012

 
DONATE TO ME
Works gr8 thanks


PS:That guy you text has a gr8 name (same as mine) LOL!
 
dradeloos
Old
#104  
Junior Member
Thanks Meter 0
Posts: 4
Join Date: May 2012
Default 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
 
ztedd
Old
#105  
Senior Member - OP
Thanks Meter 145
Posts: 204
Join Date: Feb 2011
Quote:
Originally Posted by dradeloos View Post
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.
 
Mayn
Old
#106  
Junior Member
Thanks Meter 0
Posts: 15
Join Date: Apr 2012
Quote:
Originally Posted by ztedd View Post
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!!
 
ztedd
Old
#107  
Senior Member - OP
Thanks Meter 145
Posts: 204
Join Date: Feb 2011
great!
 
dradeloos
Old
#108  
Junior Member
Thanks Meter 0
Posts: 4
Join Date: May 2012
Default 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 View Post
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.
 
ztedd
Old
#109  
Senior Member - OP
Thanks Meter 145
Posts: 204
Join Date: Feb 2011
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)
 
ztedd
Old
(Last edited by ztedd; 4th May 2012 at 08:13 AM.)
#110  
Senior Member - OP
Thanks Meter 145
Posts: 204
Join Date: Feb 2011
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"