Simon Hughes - Software Architect, Tutor, Developer

I had a problem recently trying to search the Skype instant messeage history. Searching for a historical chat can be done in Skype by pressing CTRL-F, but only if you know the person(s) that were involved on that chat. You cannot search the chat history globally. The solution is to dump out the skype database into a TXT file for easy searching with notepad. Download SQLite command shell at http://www.sqlite.org/download.html. (I downloaded http://www.sqlite.org/sqlite-shell-win32-x86-3070400.zip ) Extract sqllite3.exe to a place on your path, or somewhere you can run it easily from. Open a DOS command prompt. Change the folder to C:\Users\[pc user name]\AppData\Roaming\Skype\[skype user name] There you should find main.db database. Type the following (in bold): sqlite3 main.db sqlite> .output c:\skype_chat.txt sqlite> .dump sqlite> .quit You can now start Notepad and open file c:\skype_chat.txt to search through.

Download Gource from https://code.google.com/p/gource/ extract to C:\gource-0.28.win32 Download FFMPEG from http://www.videohelp.com/tools/ffmpeg extract to c:\ffmpeg If using SVN also download the following: svn-gource.py from https://code.google.com/p/gource/wiki/SVN extract to c:\python31 Python from  http://www.python.org/download/ I used v3.1.3. extract to c:\python31 In a DOS command prompt type: c: cd C:\Data Files\Projects (Use your own SVN repository location) svn log -r {2011-01-01}:{2010-01-01} --verbose --xml > c:\code-trunk.log cd C:\gource-0.28.win32 The follow is only required if using SVN: c:\python31\python svn-gource.py --filter-dirs c:\code-trunk.log > c:\code-trunk-gource.log gource --log-format custom c:\code-trunk-gource.log -1600x1040 --date-format "%d %B %y" --seconds-per-day 0.5 -a 0.1 --highlight-all-users --stop-at-end --disable-progress --output-ppm-stream c:\code-trunk.ppm --camera-mode overview --bloom-intensity 0.1 --ou...