Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Read skype message archive

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?

like image 895
Mike Avatar asked Dec 07 '09 10:12

Mike


People also ask

How can I see old Skype messages from years ago?

Look to the right side of the Skype screen. Above any current messages displayed from this contact, you see a list of options that says "Show messages from:" followed by a list of time periods.

Does Skype archive messages?

This build brings the ability to archive conversations in Skype. Even though you can archive conversations, you won't be able to see all your archived conversations at once. Microsoft is still working on providing such option and looking for feedback from users.


1 Answers

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.

like image 140
AlexS Avatar answered Sep 28 '22 18:09

AlexS