Read skype message archive

message archive skype
Mike picture Mike · Dec 7, 2009 · Viewed 64.2k times · Source

I would like to read my skype message archive outside of the Skype app. And be able to export it in some sort (other than copy-paste it from my messages) as far i can figure skype only provides 30 days or archives.

Any one out there using an app for archiving / exporting Skype messages?

Answer

AlexS picture AlexS · Dec 21, 2009

You can also look at skype's profile database (%USERDIR%\Application Data\Skype\%your profile name%\main.db) which is basically SQLite database and see what you can get from it. If you are using Windows 8 and above the path is %USERDIR%\AppData\Local\Packages\Microsoft.SkypeApp\Localstate\ %your_skype_profile_name%\main.db

I'll give you a hit about tables:

  • "Conversations" - a conversation
  • "Messages" linked to "Conversations" via convo_id field
  • "Chats" - a list of saved chats, each chat is composed of conversations
  • "ChatMembers" - members of chat(s)

The tables are quite wide and usage of some fields is not that obvious, but I think you get the idea.

Related questions

How to send email to multiple recipients using python smtplib?

After much searching I couldn't find out how to use smtplib.sendmail to send to multiple recipients. The problem was every time the mail would be sent the mail headers would appear to contain multiple addresses, but in fact only …

Read More
How to show the "Are you sure you want to navigate away from this page?" when changes committed?

Here in stackoverflow, if you started to make changes then you attempt to navigate away from the page, a javascript confirm button shows up and asks: "Are you sure you want to navigate away from this page?" blee blah bloo... …

Read More
jQuery show for 5 seconds then hide

I'm using .show to display a hidden message after a successful form submit. How to display the message for 5 seconds then hide?

Read More