Version 1.2 of /whatsapp_xtract.py

GoogleCodeExporter commented 8 years ago

WhatsApp Extractor for Android v1.2
Updated on April 5, 2012
by Android Fan (Martina)
Tested with Whatsapp (Android) 2.7.5613
Changelog:
V1.2
- media files also linked to offline files
- corrected hyperlinks
V1.1
- updated database structure, old version didn't work
- show contact names
- show smileys
- show images
- link / popup for images, video, audio, gps
- clickable links

HOW TO USE:

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

You can do this by using the App RootExplorer (first copy to SD, then mount 
phone to computer), or using adb method, or something else

3. Download and Install Python http://www.python.org/getit/

4. Extract this archive (whatsapp_xtract.py, whatsapp_xtract.bat, folders emoji 
and sort-table) to the certain folder and run whatsapp_xtract.bat

5. Once finished, your browser will open and show you your chats. 

The resulting file size of the .htm file will be slightly bigger than the size 
of the .db database. 

On windows you can use a whatsapp_xtract.bat to easier start the Extraction. 
Content of whatsapp_xtract.bat:
whatsapp_xtract.py -i msgstore.db -w wa.db

Download the full package (including smiley images and .bat file) at
http://freakshare.com/files/im8s5y35/Whatsapp-Extractor-for-Android-V1.2-2012-04
-05.zip.html

Original issue reported on code.google.com by martina....@freenet.ch on 6 Apr 2012 at 2:16

Attachments:

whatsapp_xtract.py.patch

GoogleCodeExporter commented 8 years ago

Here is the full package:
Whatsapp Extractor for Android V1.2 2012-04-05.zip

Content:

\msgstore.db
\README.txt
\wa.db
\whatsapp_xtract.bat
\whatsapp_xtract.py
\Media
\Media\WhatsApp Audio
\Media\WhatsApp Images
\Media\WhatsApp Video
\sort-table
\sort-table\arrow-down.gif
\sort-table\arrow-none.gif
\sort-table\arrow-up.gif
\emoji
\emoji\e001.png
\emoji\e002.png
\emoji\e003.png
\emoji\e004.png
\emoji\e005.png
\emoji\e006.png
\emoji\e007.png
\emoji\e008.png
\emoji\e009.png
\emoji\e00a.png
\emoji\e00b.png
\emoji\e00c.png
\emoji\e00d.png
\emoji\e00e.png
\emoji\e00f.png
\emoji\e010.png
\emoji\e011.png
\emoji\e012.png
\emoji\e013.png
\emoji\e014.png
\emoji\e015.png
\emoji\e016.png
\emoji\e017.png
\emoji\e018.png
\emoji\e019.png
\emoji\e01a.png
\emoji\e01b.png
\emoji\e01c.png
\emoji\e01d.png
\emoji\e01e.png
\emoji\e01f.png
\emoji\e020.png
\emoji\e021.png
\emoji\e022.png
\emoji\e023.png
\emoji\e024.png
\emoji\e025.png
\emoji\e026.png
\emoji\e027.png
\emoji\e028.png
\emoji\e029.png
\emoji\e02a.png
\emoji\e02b.png
\emoji\e02c.png
\emoji\e02d.png
\emoji\e02e.png
\emoji\e02f.png
\emoji\e030.png
\emoji\e031.png
\emoji\e032.png
\emoji\e033.png
\emoji\e034.png
\emoji\e035.png
\emoji\e036.png
\emoji\e037.png
\emoji\e038.png
\emoji\e039.png
\emoji\e03a.png
\emoji\e03b.png
\emoji\e03c.png
\emoji\e03d.png
\emoji\e03e.png
\emoji\e03f.png
\emoji\e040.png
\emoji\e041.png
\emoji\e042.png
\emoji\e043.png
\emoji\e044.png
\emoji\e045.png
\emoji\e046.png
\emoji\e047.png
\emoji\e048.png
\emoji\e049.png
\emoji\e04a.png
\emoji\e04b.png
\emoji\e04c.png
\emoji\e04d.png
\emoji\e04e.png
\emoji\e04f.png
\emoji\e050.png
\emoji\e051.png
\emoji\e052.png
\emoji\e053.png
\emoji\e054.png
\emoji\e055.png
\emoji\e056.png
\emoji\e057.png
\emoji\e058.png
\emoji\e059.png
\emoji\e05a.png
\emoji\e101.png
\emoji\e102.png
\emoji\e103.png
\emoji\e104.png
\emoji\e105.png
\emoji\e106.png
\emoji\e107.png
\emoji\e108.png
\emoji\e109.png
\emoji\e10a.png
\emoji\e10b.png
\emoji\e10c.png
\emoji\e10d.png
\emoji\e10e.png
\emoji\e10f.png
\emoji\e110.png
\emoji\e111.png
\emoji\e112.png
\emoji\e113.png
\emoji\e114.png
\emoji\e115.png
\emoji\e116.png
\emoji\e117.png
\emoji\e118.png
\emoji\e119.png
\emoji\e11a.png
\emoji\e11b.png
\emoji\e11c.png
\emoji\e11d.png
\emoji\e11e.png
\emoji\e11f.png
\emoji\e120.png
\emoji\e121.png
\emoji\e122.png
\emoji\e123.png
\emoji\e124.png
\emoji\e125.png
\emoji\e126.png
\emoji\e127.png
\emoji\e128.png
\emoji\e129.png
\emoji\e12a.png
\emoji\e12b.png
\emoji\e12c.png
\emoji\e12d.png
\emoji\e12e.png
\emoji\e12f.png
\emoji\e130.png
\emoji\e131.png
\emoji\e132.png
\emoji\e133.png
\emoji\e134.png
\emoji\e135.png
\emoji\e136.png
\emoji\e137.png
\emoji\e138.png
\emoji\e139.png
\emoji\e13a.png
\emoji\e13b.png
\emoji\e13c.png
\emoji\e13d.png
\emoji\e13e.png
\emoji\e13f.png
\emoji\e140.png
\emoji\e141.png
\emoji\e142.png
\emoji\e143.png
\emoji\e144.png
\emoji\e145.png
\emoji\e146.png
\emoji\e147.png
\emoji\e148.png
\emoji\e149.png
\emoji\e14a.png
\emoji\e14b.png
\emoji\e14c.png
\emoji\e14d.png
\emoji\e14e.png
\emoji\e14f.png
\emoji\e150.png
\emoji\e151.png
\emoji\e152.png
\emoji\e153.png
\emoji\e154.png
\emoji\e155.png
\emoji\e156.png
\emoji\e157.png
\emoji\e158.png
\emoji\e159.png
\emoji\e15a.png
\emoji\e201.png
\emoji\e202.png
\emoji\e203.png
\emoji\e204.png
\emoji\e205.png
\emoji\e206.png
\emoji\e207.png
\emoji\e208.png
\emoji\e209.png
\emoji\e20a.png
\emoji\e20b.png
\emoji\e20c.png
\emoji\e20d.png
\emoji\e20e.png
\emoji\e20f.png
\emoji\e210.png
\emoji\e211.png
\emoji\e212.png
\emoji\e213.png
\emoji\e214.png
\emoji\e215.png
\emoji\e216.png
\emoji\e217.png
\emoji\e218.png
\emoji\e219.png
\emoji\e21a.png
\emoji\e21b.png
\emoji\e21c.png
\emoji\e21d.png
\emoji\e21e.png
\emoji\e21f.png
\emoji\e220.png
\emoji\e221.png
\emoji\e222.png
\emoji\e223.png
\emoji\e224.png
\emoji\e225.png
\emoji\e226.png
\emoji\e227.png
\emoji\e228.png
\emoji\e229.png
\emoji\e22a.png
\emoji\e22b.png
\emoji\e22c.png
\emoji\e22d.png
\emoji\e22e.png
\emoji\e22f.png
\emoji\e230.png
\emoji\e231.png
\emoji\e232.png
\emoji\e233.png
\emoji\e234.png
\emoji\e235.png
\emoji\e236.png
\emoji\e237.png
\emoji\e238.png
\emoji\e239.png
\emoji\e23a.png
\emoji\e23b.png
\emoji\e23c.png
\emoji\e23d.png
\emoji\e23e.png
\emoji\e23f.png
\emoji\e240.png
\emoji\e241.png
\emoji\e242.png
\emoji\e243.png
\emoji\e244.png
\emoji\e245.png
\emoji\e246.png
\emoji\e247.png
\emoji\e248.png
\emoji\e249.png
\emoji\e24a.png
\emoji\e24b.png
\emoji\e24c.png
\emoji\e24d.png
\emoji\e24e.png
\emoji\e24f.png
\emoji\e250.png
\emoji\e251.png
\emoji\e252.png
\emoji\e253.png
\emoji\e301.png
\emoji\e302.png
\emoji\e303.png
\emoji\e304.png
\emoji\e305.png
\emoji\e306.png
\emoji\e307.png
\emoji\e308.png
\emoji\e309.png
\emoji\e30a.png
\emoji\e30b.png
\emoji\e30c.png
\emoji\e30d.png
\emoji\e30e.png
\emoji\e30f.png
\emoji\e310.png
\emoji\e311.png
\emoji\e312.png
\emoji\e313.png
\emoji\e314.png
\emoji\e315.png
\emoji\e316.png
\emoji\e317.png
\emoji\e318.png
\emoji\e319.png
\emoji\e31a.png
\emoji\e31b.png
\emoji\e31c.png
\emoji\e31d.png
\emoji\e31e.png
\emoji\e31f.png
\emoji\e320.png
\emoji\e321.png
\emoji\e322.png
\emoji\e323.png
\emoji\e324.png
\emoji\e325.png
\emoji\e326.png
\emoji\e327.png
\emoji\e328.png
\emoji\e329.png
\emoji\e32a.png
\emoji\e32b.png
\emoji\e32c.png
\emoji\e32d.png
\emoji\e32e.png
\emoji\e32f.png
\emoji\e330.png
\emoji\e331.png
\emoji\e332.png
\emoji\e333.png
\emoji\e334.png
\emoji\e335.png
\emoji\e336.png
\emoji\e337.png
\emoji\e338.png
\emoji\e339.png
\emoji\e33a.png
\emoji\e33b.png
\emoji\e33c.png
\emoji\e33d.png
\emoji\e33e.png
\emoji\e33f.png
\emoji\e340.png
\emoji\e341.png
\emoji\e342.png
\emoji\e343.png
\emoji\e344.png
\emoji\e345.png
\emoji\e346.png
\emoji\e347.png
\emoji\e348.png
\emoji\e349.png
\emoji\e34a.png
\emoji\e34b.png
\emoji\e34c.png
\emoji\e34d.png
\emoji\e401.png
\emoji\e402.png
\emoji\e403.png
\emoji\e404.png
\emoji\e405.png
\emoji\e406.png
\emoji\e407.png
\emoji\e408.png
\emoji\e409.png
\emoji\e40a.png
\emoji\e40b.png
\emoji\e40c.png
\emoji\e40d.png
\emoji\e40e.png
\emoji\e40f.png
\emoji\e410.png
\emoji\e411.png
\emoji\e412.png
\emoji\e413.png
\emoji\e414.png
\emoji\e415.png
\emoji\e416.png
\emoji\e417.png
\emoji\e418.png
\emoji\e419.png
\emoji\e41a.png
\emoji\e41b.png
\emoji\e41c.png
\emoji\e41d.png
\emoji\e41e.png
\emoji\e41f.png
\emoji\e420.png
\emoji\e421.png
\emoji\e422.png
\emoji\e423.png
\emoji\e424.png
\emoji\e425.png
\emoji\e426.png
\emoji\e427.png
\emoji\e428.png
\emoji\e429.png
\emoji\e42a.png
\emoji\e42b.png
\emoji\e42c.png
\emoji\e42d.png
\emoji\e42e.png
\emoji\e42f.png
\emoji\e430.png
\emoji\e431.png
\emoji\e432.png
\emoji\e433.png
\emoji\e434.png
\emoji\e435.png
\emoji\e436.png
\emoji\e437.png
\emoji\e438.png
\emoji\e439.png
\emoji\e43a.png
\emoji\e43b.png
\emoji\e43c.png
\emoji\e43d.png
\emoji\e43e.png
\emoji\e43f.png
\emoji\e440.png
\emoji\e441.png
\emoji\e442.png
\emoji\e443.png
\emoji\e444.png
\emoji\e445.png
\emoji\e446.png
\emoji\e447.png
\emoji\e448.png
\emoji\e449.png
\emoji\e44a.png
\emoji\e44b.png
\emoji\e44c.png
\emoji\e501.png
\emoji\e502.png
\emoji\e503.png
\emoji\e504.png
\emoji\e505.png
\emoji\e506.png
\emoji\e507.png
\emoji\e508.png
\emoji\e509.png
\emoji\e50a.png
\emoji\e50b.png
\emoji\e50c.png
\emoji\e50d.png
\emoji\e50e.png
\emoji\e50f.png
\emoji\e510.png
\emoji\e511.png
\emoji\e512.png
\emoji\e513.png
\emoji\e514.png
\emoji\e515.png
\emoji\e516.png
\emoji\e517.png
\emoji\e518.png
\emoji\e519.png
\emoji\e51a.png
\emoji\e51b.png
\emoji\e51c.png
\emoji\e51d.png
\emoji\e51e.png
\emoji\e51f.png
\emoji\e520.png
\emoji\e521.png
\emoji\e522.png
\emoji\e523.png
\emoji\e524.png
\emoji\e525.png
\emoji\e526.png
\emoji\e527.png
\emoji\e528.png
\emoji\e529.png
\emoji\e52a.png
\emoji\e52b.png
\emoji\e52c.png
\emoji\e52d.png
\emoji\e52e.png
\emoji\e52f.png
\emoji\e530.png
\emoji\e531.png
\emoji\e532.png
\emoji\e533.png
\emoji\e534.png
\emoji\e535.png
\emoji\e536.png
\emoji\e537.png

Original comment by martina....@freenet.ch on 6 Apr 2012 at 2:25

Attachments:

[Whatsapp Extractor for Android V1.2 2012-04-05.zip](https://storage.googleapis.com/google-code-attachments/hotoloti/issue-1/comment-1/Whatsapp Extractor for Android V1.2 2012-04-05.zip)

GoogleCodeExporter commented 8 years ago

Original comment by martina....@freenet.ch on 6 Apr 2012 at 2:37

Attachments:

[Whatsapp Extractor for Android V1.2 2012-04-05.zip](https://storage.googleapis.com/google-code-attachments/hotoloti/issue-1/comment-2/Whatsapp Extractor for Android V1.2 2012-04-05.zip)

GoogleCodeExporter commented 8 years ago

Hi, 
What about a file like msgstore.db.crypt ?
It is encrypted and it does not allow you to extract the contents.
What can be done in this case?
Thank you very much.

Original comment by eliad...@gmail.com on 2 May 2012 at 1:06

GoogleCodeExporter commented 8 years ago

The new version of this tool can open both Whatsapp Android and Iphone 
Databases:
- msgstore.db
- msgstore.db.crypt (so the new version of the tool is able to DECRYPT that 
file!)
- ChatStorage.sqlite

Whatsapp Xtract 2.0

https://code.google.com/p/hotoloti/issues/detail?id=3

http://forum.xda-developers.com/showthread.php?p=24603294

Original comment by martina....@freenet.ch on 2 May 2012 at 1:19

GoogleCodeExporter commented 8 years ago

Original comment by francesco.picasso on 3 May 2012 at 9:03

GoogleCodeExporter commented 8 years ago

Hello again,
Sorry for the inconvenience but I installed the ActivePython and the
crypto module and 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.

Can you tell me what is wrong?
Thank you in advance.

Original comment by eliad...@gmail.com on 3 May 2012 at 12:20

GoogleCodeExporter commented 8 years ago

Please, register at xda-developers and ask your question there. 
I would like to have all the support concentrated at one place. 
http://forum.xda-developers.com/showthread.php?p=24603294
http://forum.xda-developers.com/register.php?do=signup

Thanks.

Original comment by martina....@freenet.ch on 3 May 2012 at 12:26

GoogleCodeExporter commented 8 years ago

Hi.. how to open the msgstore.bak.1 ???

Original comment by ideri...@gmail.com on 2 Mar 2013 at 11:36

GoogleCodeExporter commented 8 years ago

Hi,

if I try to:

python whatsapp_xtract.py -w wa.db msgstore.db

I get a:
  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

I fixed it with:
diff whatsapp_xtract.py whatsapp_xtract.py.new 
1486c1486
<                     curr_chat = 
Chatsession(chats["id"],chats["display_name"],chats["jid"],None,chats["unseen_ms
g_count"],chats["status"],lastmessagedate)
---
>                     curr_chat = 
Chatsession(chats["_id"],chats["display_name"],chats["jid"],None,chats["unseen_m
sg_count"],chats["status"],lastmessagedate)

Original comment by markus.d...@gmail.com on 15 Feb 2014 at 11:17

sonegg / hotoloti

Version 1.2 of /whatsapp_xtract.py #1