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.

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".

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

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.