Export of the Journal Data by ODBC

The journal data base can be exported into an Excel- or Access-file by means of the tool "IBQuery" or directly by ODBC.

 

DSN

A System-DSN for the local access is st up during the installation of the ixi-UMS Business Setup, via that the data base access is executed.

 

If a backup of the data base shall be accessed, the respective data base file must be chosen.

 

You can create an own query for the data export or use the queries delivered by ixi-UMS.

 

Basically, you should proceed as in the following:

Open MS Excel on the ixi-UMS Business Server.

Depending on the Excel Version choose the item:

- Excel 2003 "Import External Data" in the menu "Data".

- Excel 2007 "Data - From Other Sources - From Microsft Query"

You now can make use of the queries delivered by ixi-UMS Business via "Import Data" or create your own query via "Create New Query".

 

Tabellenauswahl_de

 

At ...\ixi-UMS Kernel\Tools\Journal-Query, you can find the following queries:

 

File Names

Columns that are imported

Journal-Basic.xls

Journal-Basic.dqy

Journal-Basic_x64.dqy

BONUDTYPE

SERVICE

SENDERADRESS

MAILFROM

RECIPIENTADDRESS

SUBJECT

FAXNUMOFPAGES

TRANSTIME

TRANSDURATION

RESULTMESSAGE

 

Journal-Advanced.xls

Journal-Advanced.dqy

Journal-Advanced_x64.dqy

like above and additionally

FAXREMOTESTATION_ID

CONNECTOR

PRIORITY

MESSAGE_ID

RETRYCOUNT

 

 

The explanations to the single columns can be found at "Data Base Fields".

 

In order to make use of an available query, just open the respective *.dqy-file by double-click and import the data.

The columns are displayed in the original column description.

 

Version SR1