IB LogManager^tm Product Family

What is IBLMExport?

IBLMExport is an IBLM related command line utility for working with logged data. It allows you to export logged data into currently 11 different formats (XLS, DOC, RTF, HTML, XML, DBF, TXT, CSV, DIF, SYLK, SQL, LaTeX).

How to use?

IBLMExport can be simply used as a command line utility and therefore it is possible to schedule the export process using any task scheduling facility like 'AT' under Windows NT/Windows 2000/Windows XP.

Command line usage:

IBLMExport (-i <filename> [-v [<filename>]] [-s]) | (-z)

Options:

	-i <filename>	specifies the export configuration file
	-v [<filename>]	report each action to the screen or writes them to <filename> if specified
	-s	send email after the export process has been finished
	-z	print version information

Some examples:

IBLMExport -i iblmexport.ini
IBLMExport -i iblmexport.ini -v
IBLMExport -i iblmexport.ini -v iblmexport.log
IBLMExport -i iblmexport.ini -v -s
IBLMExport -i iblmexport.ini -v iblmexport.log -s
IBLMExport -z

The user-definable 'iblmexport.ini' file specifies all necessary connection parameters for the source database, the export format, an optional WHERE condition on the operation log data and an ORDER BY clause for both, the operation and column log data.

For example:

Path=localhost:M:\IBLM_D3_EN_TRID.GDB
Charset=ISO8859_1
Username=SYSDBA
Password=masterkey
Dialect=3
IBLM_MetadataTable=IBLM$METADATA

[Export]
ExportType=XLS
OperationLog_Filename=e:\ol.xls
OperationLog_WhereCond=OL.ID=100
OperationLog_OrderBy=OL.DATETIME DESC
ColumnLog_Filename=e:\cl.xls
ColumnLog_OrderBy=CL.ID DESC

[General]
SMTP_Host=smtp.host.com
SMTP_Port=25
EmailFrom_Name=IBLMExport Utility
EmailTo_Address=validaddress@host.com
EmailCc_Address=
EmailBcc_Address=

The section [Source] defines the connection information for the source database. The parameter IBLM_MetadataTable defines the name of metadata table in the IBLM prepared database. This is 'LOG_NOTATION' for IBLM 1.x and 'IBLM$METADATA' for IBLM 2.x (without quotes).

The [Export] section specifies all necessary export parameters.

IMPORTANT: Use the table aliases 'OL' for the operation and 'CL' for the column log table, when specifying a WHERE condition or an ordering for the result sets, otherwise the query might fail or you might get a wrong result set!

Valid ExportType values are:
XLS, DOC, RTF, HTML, XML, DBF, TXT, CSV, DIF, SYLK, SQL, LaTeX

In the [General] section you will find necessary settings for sending emails using the '-s' switch.

How to obtain IBLMExport?

IBLMExport is free for registered IBLM customers only. If you want to deploy IBLMExport to your customers, who haven't an IB LogManager license, then you can purchase IBLM independent IBLMExport licenses here.