Get Advance Information About Your WhatsApp Conversations
We all love messaging and using IMs on our smartphones to stay in touch with our friends and family. We use various mobile apps like WhatsApp to IM without having to pay for SMS and this lead to the popularity of this famous app. WhatsApp is a cross-platform mobile messaging app which can auto sync to the phone address book, allow unlimited message length and also allows you to share multimedia like videos, location, images, etc…
While chatting with your friends have you ever wished to get a detailed analysis of your chats. Hear we have these awesome tools to make this job easy.
Our First tool is an very nice application developed by Tasty Katana.
Analyzer for WhatsApp
Probably not, but now it's very easy, so why not give it a shot?
See statistics on who is the most active person in a group chat, which words were used most often, at which times there have been the most messages in a chat and much more...
- graphical representaion of data
- interactive graphs (zoom and pan)
- see the most active chat participants
- most commonly used words / emoji
- most actice weekday / time of day
- search for a word and find out how ofen it was used
WhatsApp Xtract
Our second tool is more like to backup your chats and view them on your windows pc.
Obviously we have whatsapp web and you can backup your chats to google drive but this tool do this offline. This tool is little bit complicated and only recommended for advance users.
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 ztedd.
Before we start, we need the following set of tools to perform the tutorial:
An android mobile device with WhatsApp installed.
USB data cable
Mobile phone drivers (You may find one in the CD which came with the handset or you could also find it online)
WhatsApp_Xtract_v2.0
Any file browser (manager) for android (Such as Astro or Rhythm file manager)
Python for windows, which you can download from: www.activestate.com/activepython/downloads
Where to look for the data?
WhatsApp stores all data in a SQLite database. Since it is a cross-platform app for mobile devices, the location of the database varies from OS to OS.
However, on Android, you will generally find the database stored on the SD card in an encrypted format.
WhatsApp database encryption is a project of D. Cortjens, A.Spruyt, and W.F.C Wieringa. There is a vulnerability in the android implementation of AES cipher. The 192-bit key can be detected or cracked using both static and active analysis. If you are interested about the encryption project refer to the following PDF file: tinyurl.com/c4a8dcw
Ok so now let’s hunt for the encrypted database file. Launch your favorite file manager and navigate to “/mnt/sdcard/Whatsapp/”. Now, you will see two files named as msgstore followed by a date (for example, msgstore-2011-02-11.db.crypt and msgstore.db.crypt).
Now it is advisable to copy the two files somewhere else, for example: /ext/temporary/.
How to use?
You need to copy the whatsapp database.
On Android, either get this file:
/sdcard/WhatsApp/Databases/msgstore.db.cryp
(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!):
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!): www.voidspace.org.uk/python/m...shtml#pycrypto
Now run whatsapp_xtract_android.bat or whatsapp_xtract_android_crypted.bat orwhatsapp_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:
Once finished your browser will open and show the chats.
the resulting file size of the html file will be slightly bigger then the size of the database.
While chatting with your friends have you ever wished to get a detailed analysis of your chats. Hear we have these awesome tools to make this job easy.
Our First tool is an very nice application developed by Tasty Katana.
(Best, Easy, Recommended)
Ever wanted to know which words you use the most in your WhatsApp chats or at which times you send the most messages?Probably not, but now it's very easy, so why not give it a shot?
See statistics on who is the most active person in a group chat, which words were used most often, at which times there have been the most messages in a chat and much more...
Features:
- analyze a whole chat or just a single participant- graphical representaion of data
- interactive graphs (zoom and pan)
- see the most active chat participants
- most commonly used words / emoji
- most actice weekday / time of day
- search for a word and find out how ofen it was used
WhatsApp Xtract
Our second tool is more like to backup your chats and view them on your windows pc.
Obviously we have whatsapp web and you can backup your chats to google drive but this tool do this offline. This tool is little bit complicated and only recommended for advance users.
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 ztedd.
Before we start, we need the following set of tools to perform the tutorial:
An android mobile device with WhatsApp installed.
USB data cable
Mobile phone drivers (You may find one in the CD which came with the handset or you could also find it online)
WhatsApp_Xtract_v2.0
Any file browser (manager) for android (Such as Astro or Rhythm file manager)
Python for windows, which you can download from: www.activestate.com/activepython/downloads
Where to look for the data?
WhatsApp stores all data in a SQLite database. Since it is a cross-platform app for mobile devices, the location of the database varies from OS to OS.
However, on Android, you will generally find the database stored on the SD card in an encrypted format.
WhatsApp database encryption is a project of D. Cortjens, A.Spruyt, and W.F.C Wieringa. There is a vulnerability in the android implementation of AES cipher. The 192-bit key can be detected or cracked using both static and active analysis. If you are interested about the encryption project refer to the following PDF file: tinyurl.com/c4a8dcw
Ok so now let’s hunt for the encrypted database file. Launch your favorite file manager and navigate to “/mnt/sdcard/Whatsapp/”. Now, you will see two files named as msgstore followed by a date (for example, msgstore-2011-02-11.db.crypt and msgstore.db.crypt).
Now it is advisable to copy the two files somewhere else, for example: /ext/temporary/.
How to use?
You need to copy the whatsapp database.
On Android, either get this file:
/sdcard/WhatsApp/Databases/msgstore.db.cryp
(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!):
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!): www.voidspace.org.uk/python/m...shtml#pycrypto
Now run whatsapp_xtract_android.bat or whatsapp_xtract_android_crypted.bat orwhatsapp_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
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
the resulting file size of the html file will be slightly bigger then the size of the database.
IF SOMETHING DOESN'T WORK:
1. First check if you already have the newest download (check full name of the .zip file: is it the same as in mentioned in this thread?). Maybe your error already has been fixed.
2. Read the post Some additional information and read the last pages of this thread to see if your problem is already being discussed.
Use the Search this thread function! (e.g. the "requires Business Edition subscription" error was already answered a "100" times!)
3. If not or if it doesn't help, post your error with a detailed description (and error message) in the thread.
1. First check if you already have the newest download (check full name of the .zip file: is it the same as in mentioned in this thread?). Maybe your error already has been fixed.
2. Read the post Some additional information and read the last pages of this thread to see if your problem is already being discussed.
Use the Search this thread function! (e.g. the "requires Business Edition subscription" error was already answered a "100" times!)
3. If not or if it doesn't help, post your error with a detailed description (and error message) in the thread.
Share story
0 comments: