Hello There, Guest!  
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5

Whatsapp Xtract: Backup Messages Extractor / Database Analyzer / Chat-Backup

#1
Have you ever wanted to
- have a useful backup of your whatsapp chats?
- be able to read your whatsapp chats again using a backup file?
- delete the grown-too-big message history of whatsapp without losing the possibility to read the old conversations?
- read older messages without the need of endlessly pressing the annoying "load older messages" button?
- be able to search old messages?
- ...?

Here is a little Tool to display whatsapp chats on your computer, using the database files from your android installation of whatsapp.

It's called WhatsApp Xtract and was created by Fabio Sangiacomo and me.

https://code.google.com/p/hotoloti/downloads/list
(careful, the downloads on google code are outdated! Please use the download links provided here)

So here is WhatsApp Xtract v2.2
Released on November 17th, 2012
Last Update on November 17th, 2012 (v2.2)

Tested with Whatsapp (Android) 2.8.5732
Tested with Whatsapp (iPhone) 2.5.1

CHANGELOG:

v2.2 (updated by Martina Weidner - Nov 17, 2012)
- now supports new emoji smileys
- (Android Version) hotfix for TypeError in b64encode
- (Android Version) decoded file won't be deleted even if it can't be opened

v2.1 (updated by Fabio Sangiacomo and Martina Weidner - May 7th, 2012)
- improved install pyCrypto.bat
- added easy drag and drop possibility with whatsapp_xtract_drag'n'drop_database(s)_here.bat
- (Android Version) added support to fix corrupted android whatsapp database (needs sqlite3, for windows sqlite3.exe is contained in the archive)
- (Android Version) removed wrong extraction of owner in android version
- (Iphone Version) information from Z_METADATA table will be printed to shell
- (Iphone Version) fixed bug in support of older Iphone whatsapp databases

V2.0 (updated by Fabio Sangiacomo and Martina Weidner - Apr 28, 2012)
- supports WhatsApp DBs coming from both Android and iPhone platforms
- (Android Version) wa.db is optional
- (Android Version) now also crypted msgstore.db.crypt from the SD card can be imported
- chat list is sorted by the last sent message
- fixed some bugs (e.g. that the script didn't work with python 3)



How to use

You need to copy the whatsapp database.

On Android, either get this file:

/sdcard/WhatsApp/Databases/msgstore.db.crypt
(crypted database on SD card, can be created by starting backup from whatsapp advanced settings: settings - more - Backup Chats)

or these files:
/data/data/com.whatsapp/databases/msgstore.db and wa.db
(for this you need root access. detailed instructions in the bottom of this file. the advantage is that the corresponding contact names of phone numbers will be displayed.)

On IPhone, get this file:

net.whatsapp.WhatsApp/Documents/ChatStorage.sqlite
(You can use an Iphone Backup Tool to get the file, e.g. I-Twin or Iphone Backup Extractor. Make sure to create an unencrypted backup with Itunes, as these tools can't handle encrypted backups. Another possibility are forensic tools like UFED Physical Analyzer.)

Extract this archive (Whatsapp_Xtract....zip) to a certain folder on your computer, e.g. C:\WhatsApp.

Copy the database(s) to e.g. C:\WhatsApp (on Android, you simply copy the whole folder WhatsApp on SD card to your computer e.g. to C:\WhatsApp and then copy the database file from C:\WhatsApp\Databases to C:\WhatsApp)

You need Python and (for Android msgstore.db.crypt decryption) the PyCrypto library

The easiest way is to install ActivePython
!! on Windows choose 32bit/x86 version even if you have 64bit windows (if not you will get an "requires Business Edition subscription" error!):
http://www.activestate.com/activepython/downloads
It's available for Windows, Linux and Mac. However in my HowTo, I focus on Windows.

and then run !install pyCrypto.bat (contained in this archive. The best is to rightclick on it and choose "run as administrator".)

If you have troubles installing pyCrypto this way, then please try to install it using an installation package from this site (Thanks, andcha!): http://www.voidspace.org.uk/python/m...shtml#pycrypto

Now run whatsapp_xtract_android.bat or whatsapp_xtract_android_crypted.bat or whatsapp_xtract_iphone.bat

OR simply drag and drop the database file(s) to whatsapp_xtract_drag'n'drop_database(s)_here.bat

OR whatsapp_xtract_console.bat and then manually specify the input file with one of these commands:

COMMAND LINE OPTIONS:

Quote:
For Android DB:
python whatsapp_xtract.py msgstore.db -w wa.db
OR (if wa.db is unavailable)
python whatsapp_xtract.py msgstore.db
OR (for crypted db)
python whatsapp_xtract.py msgstore.db.crypt

For iPhone DB: (-w option is ignored)
python whatsapp_xtract.py ChatStorage.sqlite
Once finished, your browser will open and show the chats.
The resulting file size of the .html file will be slightly bigger than the size of the .db database.

Attachments

available here:

http://freakshare.com/files/iykgyxrn/Wha...7.zip.html
[GH निर्वाचन अधिकारी] join me at fb http://facebook.com/napstergh[Image: etoile.gif]
 Reply
#2
When you "delete" some kinds of items from the iPhone, they don't actually get deleted. Instead, they're marked for deletion by the operating system and hidden so that they appear deleted. But they're still on the phone.
Only when you sync your iPhone with iTunes are they truly deleted.
If you want to truly and permanently delete SMS messages from your iPhone. One way is to use iPhone Data Recovery. Also you can follow way below.
This worked for me so I really hope this works for you to recover deleted text messages from iphone! Just follow the steps below:
1. Go to <settings><general><spotlight search><uncheck messages>
2. Then turn your phone off and wait a minute! Turn your phone back on and off again 2 or 3 more times while waiting a minute in between turning it off!
3. After you are done doing that go back to step 1 and <check messages>!
4. Now go to your spotlight search and those messages should be deleted! If they are deleted I would recommend going back to step 1 and <uncheck messages> so you do not have the same problem with messages showing up again in the spotlight search!

Another method is with iPhone Backup Extractor, which extracts SMS out of iPhone.
 Reply
#3
The program doesn't support Android 6.0 device, right? You can restore iPhone whatsapp chat history with other app.
 Reply
#4
(12-06-2014, 07:43 AM)EricaSullia Wrote: When you "delete" some kinds of items from the iPhone, they don't actually get deleted. Instead, they're marked for deletion by the operating system and hidden so that they appear deleted. But they're still on the phone.
Only when you sync your iPhone with iTunes are they truly deleted.
If you want to truly and permanently delete SMS messages from your iPhone. One way is to use iPhone Data Recovery. Also you can follow way below.
This worked for me so I really hope this works for you to recover text messages from iphone! Just follow the steps below:
1. Go to <settings><general><spotlight search><uncheck messages>
2. Then turn your phone off and wait a minute! Turn your phone back on and off again 2 or 3 more times while waiting a minute in between turning it off!
3. After you are done doing that go back to step 1 and <check messages>!
4. Now go to your spotlight search and those messages should be deleted! If they are deleted I would recommend going back to step 1 and <uncheck messages> so you do not have the same problem with messages showing up again in the spotlight search!

Another method is with iPhone Backup Extractor, which extracts SMS out of iPhone.


I used Mobiledic iphone backup extractor to extract data from iTunes backup, it works fine and help me recover deleted messages, contacts, photos from old iTunes backup.
 Reply
#5
How to extract data from iPhone iTunes backup can be easy for us , iPhone data can be retrieved back from backup files if you use iPhone Data Recovery .
It provides you with 2 different modes, 
1.Directly Scan Your iPhone for recover deleted data  , 
2.Recover from iTunes/ iCloud Backup,
 Reply
 
 
Forum Jump:

Users browsing this thread: 1 Guest(s)