ICQHistoryConverter


[About] [Supported Logfiles] [Usage] [Examples] [Requirements] [Download] [Roadmap] [Past Versions] [Developers] [Authors]

About

ICQHistoryConverter is (or better will become) a tool to convert, merge and modify your instant messenger (IM) logs. Despite the name it won´t be limited to ICQ messenger logs, it knows more IMs (AIM, Yahoo!, Jabber, MSN).
Being  a command-line tool you can use it easily in scripts, batchs, or  in some other kind of automation. Usage is sorrowly rather complicated due to a lot of possible parameters . :(


Supported Logfiles

Log format Description Read Write
Messages URLs Contacts Comments Messages URLs Contacts Comments
ICQ Original ICQ clients up to version 2003a x x x - - - Read-only
ICQ2003b Original ICQ client version 2003b x o x - - - Read-only
Psi Jabber Client x o x x - x
SQLite Own database format, useful for merging, moving, etc x x x x x x
PostgreSQL Own database format, useful for merging, moving, etc x x x x x x
HTML Exports a HTML representation - - - Write-only x - x Fixed format currently
Text Exports to plain-text - - - Write-only x - x Fixed format currently
Key:
x supported
o not possible
- not supported

Usage

Start the program first without a parameter or with --h or --help to see the possible input and output "plugins". You have always to choose an input module and a output module and provide to each module the required parameters. The parameters in brackets [] are optional parameters, the other for the selected "plugins" are required and will abort the program if you do not provide them. Read their description carefully.

Examples

1) You want to Dump your ICQ2003b database to HTML

The ICQ database is in C:\ICQ2003b\78819723\, your ICQ uin is 78819723 and you want to write the HTML files to C:\htmldump\ (the directory must exist!), then the you would call the program this way (in one line please)
C:\icqhistoryconverter> icqhistconvert.exe --input=inicq2003b --output=outhtml --inicq2003b-path=C:\ICQ2003b\78819723\ --inicq2003b-uin=78819723 --outhtml-path=C:\htmldump\

2) You want to store your ICQ2001b database in the tool´s native SQLite DataBase

The ICQ database is in C:\ICQ2001\78819723\, your ICQ uin is 78819723 and you want to the new DB file to be stored as C:\myhistory.hdb. The corresponding  command is :
C:\icqhistoryconverter> icqhistconvert.exe --input=inicq --output=outdb --inicq-datfile=C:\ICQ2001\78819723\78819723.dat --inicq-idxfile=C:\ICQ2001\78819723\78819723.idx --inicq-icqno=78819723 --outdb-path=C:\myhistory.hdb

3) You want to add your Psi log files to an existing native SQLite Database

Your must give the path to your profiles, not the the path to the logs directory. You use only ICQ and Jabber. Your Jabber profile lies in C:\Jabber\Your profile\ , your UIN is 78819723 and you want to add the messages to your database in c:\myhistory.hdb (perhaps the DB from example 2) :
C:\icqhistoryconverter> icqhistconvert.exe --input=inpsi -output=outdb "--inpsi-path=C:\Jabber\Your profile\default" --inpsi-icquin=78819723 --outdb-path=C:\myhistory.hdb
You merged now the logs into one big database.

Requirements

The Windows binaries contain all necessary libraries, so this is only important if you want to compile the programm yourself
Requirement For what License Homepage
libiconv Unicode and general charset conversion LGPL http://www.gnu.org/software/libiconv/
mxml XML Parsing (used by InPsi) LGPL http://www.easysw.com/~mike/mxml/
PostgreSQL Client Library (libpq) PostgreSQL database backend BSD http://www.postgresql.org
SQLite Own Database format Public Domain http://www.sqlite.org
These requirements may have other dependencies by themselves.

Download

Windows (Compiled): IcqHistConv.zip (~ 1.5 MB)
Source icqhistconv.tar.bz2 (~ 36 KB)

Roadmap


Version Description
v ?.?
  • Add easy to use GUI
  • full autotools project with configurable plugins
  • more IM support
v 0.4
  • add support for processing modules
  • add UIN rewrite processing module
  • add message sort order processing module
v 0.3
  • more general documentation
  • more per-module documentation
v 0.2
  • miranda read & write support (if possible)
  • implement finish() in every module and move code from to the destructor to this function

History

Version Description
v 0.1
  • initial release
  • read support for Psi, ICQ, ICQ2003b, DB (SQLite) & PostgreSQL
  • write support for Psi,DB, PostgreSQL, HTML, plain text

Developers' Information

Contact me if you want to help.

Authors

Who What Contact
Evil Azrael Currently everything
Jabber eazrael@swissjabber.de
ICQ 78819723
Yahoo! eazrael
MSN msn(at)evilazrael.de
E-Mail evilazrael@_DELETETHIS_evilazrael.de

Document made with Nvu