阅读Skype消息存档 [英] Read skype message archive

问题描述

我想在 Skype 应用程序之外阅读我的 Skype 消息存档.并且能够以某种方式导出它(除了从我的消息中复制粘贴)，因为我认为 Skype 只提供 30 天或存档.

有人在使用应用程序来存档/导出 Skype 消息吗?

解决方案

你也可以查看skype的资料库(%USERDIR%\Application Data\Skype\%your profile name%\main.db>) 这基本上是 SQLite 数据库，看看你能从中得到什么.如果您使用的是 Windows 8 及更高版本，则路径为 %USERDIR%\AppData\Local\Packages\Microsoft.SkypeApp\Localstate\ %your_skype_profile_name%\main.db>

我会为您介绍一下表格:

• 对话" - 对话
• 通过 convo_id 字段链接到对话"的消息"
• 聊天" - 保存的聊天列表，每个聊天都由对话组成
• ChatMembers" - 聊天成员

表格相当广泛，有些领域的用法不是那么明显，但我想你明白了.

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?

解决方案

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.

这篇关于阅读Skype消息存档的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！