ADS LogManager ADSLMExport

What is What is ADSLMExport?

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

How to use?

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

ADSLMExport (-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:

ADSLMExport -i adslmexport.ini
ADSLMExport -i adslmexport.ini -v
ADSLMExport -i adslmexport.ini -v adslmexport.log
ADSLMExport -i adslmexport.ini -v -s
ADSLMExport -i adslmexport.ini -v adslmexport.log -s
ADSLMExport -z

The user-definable 'adslmexport.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]
UseAlias=0
AliasOrPath=G:\APPLICAT\ADSLogManager\Database\adslogmanager.add
ConnectionTypeLocal=1
ConnectionTypeRemote=0
ConnectionTypeInternet=0
Username=ADSSYS
Password=adssys
ADSLM_MetadataTable=ADSLM$METADATA

[Export]
ExportType=XLS
OperationLog_Filename=e:\olog_neu.xls
OperationLog_WhereCond=ID>13500
OperationLog_OrderBy=ID

[General]
SMTP_Host=smtp.host.com
SMTP_Port=25
EmailFrom_Name=ADSLMExport Utility
EmailTo_Address=ts@adslogmanager.com
EmailCc_Address=
EmailBcc_Address=

The section [Source] defines the connection information for the source database. The parameter ADSLM_MetadataTable defines the name of metadata table in the ADSLM prepared database. This is 'ADSLM$METADATA' for ADS LogManager 1.x (without quotes).

The [Export] section specifies all necessary export parameters.

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 ADSLMExport?

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