What is What is NDBLMExport?

NDBLMExport is a NDB LogManager related command line utility for working with logged data. It allows you to export logged data into formats (XLS, DOC, RTF, HTML, XML, DBF, TXT, CSV, DIF, SYLK, SQL, LaTeX, PDF).

How to use?

NDBLMExport 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:

NDBLMExport (-i <filename> [-ps <pwd>] [-v [<filename>]] [-s]) | (-z)

Options:

-i <filename> specifies the export configuration file
-ps <pwd> Encrypts password <pwd> and writes it into the [Source] section of the given 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:

NDBLMExport -i ndblmexport.ini
NDBLMExport -i ndblmexport.ini -v
NDBLMExport -i ndblmexport.ini -v ndblmexport.log
NDBLMExport -i ndblmexport.ini -v -s
NDBLMExport -i ndblmexport.ini -v ndblmexport.log -s
NDBLMExport -i ndblmexport.ini -ps mypassword
NDBLMExport -z

The user-definable 'ndblmexport.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 example:

[Source]
// 0 = Winsock, 1 = NamedPipe Transport
Type=1
ServerName=NexusDB@TOMSTONE
AliasName=Northwind
UserName=thomas
Password=0t3xyr3v
NDBLM_MetadataTable=NDBLM$METADATA
UseEncryptedPassword=1

[Export]
ExportType=XLS
OperationLog_Filename=c:\olog_neu.xls
OperationLog_WhereCond=OL.ID < 10000
OperationLog_OrderBy=OL.ID
ColumnLog_Filename=c:\clog_neu.csv
ColumnLog_OrderBy=CL.ID

[General]
SMTP_Host=smtp.host.com
SMTP_Port=25
EmailFrom_Name=NDBLMExport Utility
EmailTo_Address=t.steinmaurer@upscene.com
EmailCc_Address=
EmailBcc_Address=

The section [Source] defines the connection information for the source database. The NDBLM_MetadataTable parameter specifies the name of the logging metadata table, in an NDBLM prepared database.

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, PDF

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

How to obtain NDBLMExport?

NDBLMExport is free for registerd NDBLM customers, that means a purchase of NDB LogManager includes a developer license for NDBLMExport for free. If you want to deploy NDBLMExport to your customers, who haven't an NDB LogManager license, then you can purchase NDBLM independent NDBLMExport licenses here.