What is What is ADSLMExport?
ADSLMExport v1.0 is the first ADSLM 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 v1.0 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 emails 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.
|