How can I read Skype log files (chatsync)?
Any SQLite interface can open the XXX.db
file. I use SQLiteStudio.
The following query can be used to get all the chat messages you had with a given username. Replace andy
in this example with the username you want.
select
chatname,
strftime('%Y-%m-%d', datetime(timestamp, 'unixepoch')) AS date,
from_dispname,
body_xml
from
Messages
where
chatname like "%andy%"
order by
timestamp
SkypeLogView should do what you want.
SkypeLogView reads the log files created by Skype application, and displays the details of incoming/outgoing calls, chat messages, and file transfers made by the specified Skype account. You can select one or more items from the logs list, and then copy them to the clipboard, or export them into text/html/csv/xml file.
You can manually browse them using sqlite, the database used for storing the chats ( e.g.: sqlite foo.db ). Sqlitebrowser will make this process less tedious. You will need a complex sql command to sort and list them in chromological order. You can dump your queries from within sqlite directly to files, so I would use sqlite.