# User Manual V-9.3.0

[](pdfgenerator=eyJ0aXRsZSI6IFsidHJ1ZS1BZHZpY2UiXSwgInN1YnRpdGxlIjogWyJVc2VyIE1hbnVhbCBWLTkuMy4wIl0sICJ2ZXJzaW9uIjogIjkuMy4wIn0=)
# Overview

true-Advice enables UBS customers to automatically convert data from and to SWIFT messages. It relies on true-Broker to establish secure communication with UBS.

![Ein Bild, das Text, Diagramm, Screenshot, Design enthält. KI-generierte Inhalte können fehlerhaft sein.](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-001.png)

true-Advice Web is a web application running on an Apache Tomcat server.

true-Advice Web is multi-client capable. true-Advice Web Administration is used to manage the client instances of true-Advice Web. For each client a specific true-Advice Web application instance is deployed on Apache Tomcat which separates it from the other clients.

The configuration of each true-Advice Web client instance is held in an internal database.

A separate license is needed for each client. The different true-Advice Web modules are deployed based on the purchased license.

## System Requirements

Operating systems

-   Microsoft Windows Server 2016 x64
-   Microsoft Windows Server 2022 x64
-   Microsoft Windows 10 x64
-   Microsoft Windows 11 x64

Software

-   true-Advice Web
-   true-Broker Web

Hardware

-   20 GB free hard disk
-   4 GB RAM

Other

-   Administrator rights
-   Unbound local port 8650
-   Firewall allowing connections to http://localhost:8650

# Installing true-Advice Web

The true-Advice Web installation is based on Windows Installer Packages. Please navigate to the ***TrueAdviceReporting.msi***.

![Ein Bild, das Text, Screenshot, Reihe, Schrift enthält. KI-generierte Inhalte können fehlerhaft sein.](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-002.png)

Double-click the ***TrueAdviceReporting.msi*** to start the installation process.

![Ein Bild, das Text, Screenshot, Software, Display enthält. KI-generierte Inhalte können fehlerhaft sein.](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-003.png)

![Ein Bild, das Text, Screenshot, Kreis, Software enthält. KI-generierte Inhalte können fehlerhaft sein.](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-004.png)

Press ***Next*** to continue or ***Cancel*** to abort the installation process.

![Graphical user interface, text, application, email Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-005.png)

Please accept the End-User License Agreement. Press ***Next*** to continue.

![Graphical user interface, text, application, email Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-006.png)

Please select the folder where to install true-Advice Web. Press ***Next*** to continue.

![Graphical user interface, text, application, email Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-007.png)

Click ***Install*** to start the installation.

![Graphical user interface, text, application Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-008.png)

The installation process copies the necessary files to the previously defined installation directory, installs Apache Tomcat as a Windows Service and starts it.

![Ein Bild, das Text, Screenshot, Kreis, Software enthält. KI-generierte Inhalte können fehlerhaft sein.](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-009.png)

Press ***Finish*** to end the installation process. True-Advice Web is now installed and ready to be used.

## Updating true-Advice Web

### Using Check for Updates

Use the ***trueAdviceUpdate*** menu item in the ***keyon*** → ***true-Advice Web*** menu to start the update process.

![Ein Bild, das Text, Screenshot, Software, Multimedia-Software enthält. KI-generierte Inhalte können fehlerhaft sein.](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-010.png)

The update process checks online whether updates are available. The update process uses the Internet Explorer connection settings to establish a connection to the update page using http. The update page is located on [http://www.keyon.ch](http://www.keyon.ch).

If your true-Advice Web Installation is up to date the following message window is displayed.

![Ein Bild, das Text, Screenshot, Schrift, Reihe enthält. KI-generierte Inhalte können fehlerhaft sein.](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-011.png)

If an update is available, the following window is displayed.

![Ein Bild, das Text, Screenshot, Software, Display enthält. KI-generierte Inhalte können fehlerhaft sein.](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-012.png)

Press ***Next*** to start the update process.

![Ein Bild, das Text, Screenshot, Software, Display enthält. KI-generierte Inhalte können fehlerhaft sein.](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-013.png)

The update process downloads the patch.

![Ein Bild, das Text, Screenshot, Kreis, Software enthält. KI-generierte Inhalte können fehlerhaft sein.](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-014.png)

Press ***Next*** to start the patch installation process.

![Graphical user interface, text, application, email Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-015.png)

Please accept the End-User License Agreement. Press ***Next*** to continue.

![Graphical user interface, text, application, email Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-016.png)

Please select the folder where to install true-Advice Web. Press ***Next*** to continue.

![Graphical user interface, text, application, email Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-017.png)

Press ***Install*** to begin the installation.

| The database holding the true-Advice Web configuration will not be changed during the patch installation process. |
| --- |

![Graphical user interface, text, application Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-018.png)

During the patch installation process the Apache Tomcat Windows service is stopped and the new files are copied to the installation directory.

![Ein Bild, das Text, Screenshot, Kreis, Software enthält. KI-generierte Inhalte können fehlerhaft sein.](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-019.png)

Press ***Finish*** to terminate the patch installation process. At the end of the patch installation process the Apache Tomcat Windows service is restarted.

# true-Advice Web Windows service

The installation process tries to install true-Advice Web as a Windows service. The Windows service is named TrueAdvice. If true-Advice Web has been installed as a Windows service, you can use the Microsoft Services Console to administrate the service.

![Ein Bild, das Text, Software, Screenshot, Zahl enthält. KI-generierte Inhalte können fehlerhaft sein.](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-020.png)

To install true-Advice Web as a Windows service Administrator rights are needed.

## Configure true-Advice Web Windows service

Before changing the true-Advice Web Windows service configuration stop the service using the ***Microsoft Services Console***.

To change the true-Advice Web Windows service configuration open the file:

***C:\\Program Files\\keyon\\true-Advice\\trueAdvice.ini***

On an operating system with UAC enabled run the editor as administrator.

![](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-021.png)

```

\[Class Path\]

Class Path=C:\\Program Files\\keyon\\true-Advice\\server\\\*.jar;C:\\Program Files\\keyon\\true-Advice\\server\\bin\\\*.jar;C:\\Program Files\\keyon\\true-Advice\\server\\lib\\\*.jar;

\[Product Information\]

Upgrade Code={85B1295E-C0E8-403D-BDB4-008407F42D43}

Product Code={1DCD482F-F8A0-4D00-839B-23E91CA5B2DA}

Product Name=true-Advice

\[Application\]

Application Type=service

\[Java Runtime Environment\]

JRE Path=C:\\Program Files\\keyon\\true-Advice\\jre64\\

JVM Source=favor\_JDK

JVM Type=favor\_server

Library Path=C:\\Program Files\\keyon\\true-Advice\\server\\bin\\;

Main Class=ch.keyon.advancedinstaller.service.tomcat.AdvancedInstallerWin32ServiceTomcat

Maximum Version=1.7

Minimum Version=1.7

Virtual Machine Parameters=-Xms128M -Xmx3062M -Dtrueadvice.api.key="ThisIsMyAPIKey" -Dderby.system.home="C:\\ProgramData\\keyon\\true-Advice\\db" -DtrueadviceReporting.data.home="C:\\ProgramData\\keyon\\true-Advice" -Dlogback.configurationFile="C:\\ProgramData\\keyon\\true-Advice\\cfg\\logback.xml" -Dcatalina.base="C:\\Program Files\\keyon\\true-Advice\\\\server" -Dcatalina.home="C:\\Program Files\\keyon\\true-Advice\\\\server" -Djava.endorsed.dirs="C:\\Program Files\\keyon\\true-Advice\\\\server\\endorsed"

```

Use the ***Microsoft Services Console*** to start the true-Advice Web Windows service.

### true-Advie API Key
The API-Key used by true-Avice to grant access to the SSI-API can be configured with the -Dtrueadvice.api.key paraemtere as whosn above in the last line starting with **Virtual Machine Parameters**

| Do not change these settings unless you are advised by SITS support to do so. |
| --- |

## Starting true-Advice Web Windows service

***Start*** the true-Advice Web Windows service using the ***Microsoft Services Console***.

![Ein Bild, das Text, Screenshot, Display, Zahl enthält. KI-generierte Inhalte können fehlerhaft sein.](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-022.png)

## Stopping true-Advice Web Windows service

***Stop*** the true-Advice Web Windows service using the ***Microsoft Services Console***.

![Ein Bild, das Text, Elektronik, Screenshot, Display enthält. KI-generierte Inhalte können fehlerhaft sein.](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-023.png)

## Daily restart of Apache Tomcat Windows service

The Apache Tomcat Windows service is scheduled to restart daily. The Windows service will be stopped at 00:00 and started at 00:15 AM.

![Ein Bild, das Text, Screenshot, Reihe, Schrift enthält. KI-generierte Inhalte können fehlerhaft sein.](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-024.png)

You can change the restart settings in the ***Scheduled Task*** option of the ***Windows Control Panel***.

# true-Advice Web Windows console

## Starting true-Advice Web as console

If you want to run true-Advice Web as a console application, run the following executable file:

***C:\\Program Files\\keyon\\true-Advice\\trueAdvice Console.exe***

Make sure that the Windows Service is not running when starting true-Advice Web as a console.  
On an operating system with UAC enabled run the executable as Administrator.

![](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-025.png)

True-Advice Web is starting as console application.

![Ein Bild, das Text, Screenshot, Schrift enthält. KI-generierte Inhalte können fehlerhaft sein.](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-026.png)

## Stopping true-Advice Web console

If true-Advice Web is running as a console application, press ***Control-C*** in the console window to stop the application.

# true-Advice Web Administration

true-Advice Web Administration is a web application running on an Apache Tomcat server. true-Advice Web is multi-client capable. Use the true-Advice Web Administration application to load or delete true-Advice Web licenses. If you add a new true-Advice Web license a new web application is deployed to the Apache Tomcat server.

The URL to access true-Advice Web Administration is:

[http://localhost:8650/TrueAdviceWebAdmin/main.do](http://localhost:8650/TrueAdviceWebAdmin/main.do)

Use the link above or select the ***true-Advice Web*** menu item in the ***keyon*** → ***true-Advice Web*** menu to open the URL above in your default browser.

![Ein Bild, das Text, Screenshot, Software, Multimedia-Software enthält. KI-generierte Inhalte können fehlerhaft sein.](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-027.png)

## Login page

To get access to the true-Advice Web Administration web application you have to login with a username and password.

![Graphical user interface, text, application, website Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-028.png)

The default username is ***admin***. The default password is ***12345678***.

![Graphical user interface, application Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-029.png)

Press the ***Login*** button to log on to the application.

You can change the administrator password using the ***User management*** link.

## Main page / Load License

The main page is used to load the true-Advice Web licenses. true-Advice Web is multi-client capable. For each license a new true-Advice Web application is deployed on the Apache Tomcat server.

![Graphical user interface, text, application Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-030.png)

To add a new license, press the ***Browse for file*** button or drag it into the area to load the license file you received from SITS.

![Graphical user interface, text, application Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-031.png)

The tool starts to deploy the new license immediately. This might take a few minutes. Click on ***Refresh*** to update the status.

![Graphical user interface, text, application Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-032.png)

Once it’s done, the status shows Deployed and the license and its modules can be accessed by clicking on the link of the Customers name. (e.g. ***Keyon*** in this example)

To delete a license, select the license name and press the ***Delete selected*** button.

![Graphical user interface, application Description automatically generated with medium confidence](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-033.png)

![Graphical user interface, text, application Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-034.png)

Press ***Delete customers*** to confirm the action.

| Be aware that the configuration of the client web application will be deleted. Messages stored in the internal database are also deleted. Messages downloaded to the configured inbox are not deleted. |
| --- |

## User Management Page

Use the ***User management*** link to add or remove a user. This is only available for users with administrative rights.

![Ein Bild, das Text, Screenshot, Schrift, Zahl enthält. KI-generierte Inhalte können fehlerhaft sein.](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-035.png)

Click on ***Add / remove User*** to show the list of existing users.

![Ein Bild, das Text, Screenshot, Software, Zahl enthält. KI-generierte Inhalte können fehlerhaft sein.](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-036.png)

### Add a user

To add a new user, enter a name and chose the required role, then click on ***Add user***.

![Ein Bild, das Text, Screenshot, Schrift, Zahl enthält. KI-generierte Inhalte können fehlerhaft sein.](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-037.png)

True-Advice will add the user and generate a random password which is shown in the green message bar. This needs to be provided to the user. The user can then use these credentials to login and change the password to a new one as described in the chapter 5.4.

### Remove a user

To remove a user, select the username in the list and click on ***Delete selected***.

![Ein Bild, das Text, Screenshot, Schrift, Zahl enthält. KI-generierte Inhalte können fehlerhaft sein.](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-038.png)

Removing a user does not have any other impact on the system. It will only prevent anybody from logging in with this username.

### Reset a password

There is no option to reset a password of a user. If a user forgot the password, the user needs to be deleted and recreated as described above.

### Available roles

See below list of available roles and their rights.

-   Administrator
    -   Can add and remove users
    -   Can execute any action available within the tool
-   Operator
    -   Can execute any action available within the tool
-   Readonly
    -   Can view all pages, but cannot execute any action within the tool

It is not possible to add additional roles.

## Change password page

Use the ***User management*** link to change your password.

![Text Description automatically generated with low confidence](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-039.png)

Enter the current and the new password and confirm it.

Press the ***Save new password*** button to change the password.

## Logout

To log off from the true-Advice Web Administration application press the ***Logout*** button in the upper right corner.

![Shape, rectangle Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-040.png)

Pressing the ***Logout*** button redirects you to the Login page.

![Graphical user interface, application, website Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-041.png)

# True-Advice Web Instance

For each loaded license a separate true-Advice Web Instance application is deployed. It can be accessed by clicking on the customer’s name of the license in the true-Advice Web Administration app.

![Graphical user interface, text, application Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-042.png)

## Login page

To get access to the true-Advice Web Instance Web application you have to login with a username and password.

![Graphical user interface, text, application, website Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-043.png)

The default username is ***admin***. The default password is ***12345678***.

## Main Page / Module status

The main page shows you the status of all licensed modules and their last startup time.

![Graphical user interface, application Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-044.png)

The menu on the left can vary, based on the licensed modules. This will be discussed later in this document. Always available are the following items:

-   ***Module status***
    -   Shows this main page
-   ***User management***
    -   Allows you to change the password (See chapter 0 for details)
-   ***User Guide***
    -   Shows this user guide of true-Advice Web
-   ***true-Advice Web Admin***
    -   Link to the administration app of true-Advice Web

# CSV Converter

The CSV Converter module is based on the reporting module and is used to convert SWIFT messages into CSV files.

## Main page

The main page is used to trigger a conversion of messages.

![Graphical user interface, application, website Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-045.png)

Use the ***Start*** button within the **Reporting** Module box to start converting messages. Before you can start converting messages you have to configure true-Advice Web using the configuration links under ***Reporting***.

![Graphical user interface, application, website Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-046.png)

Once the application is running you can use the ***Refresh*** button to update the state.

![Graphical user interface, application, website Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-047.png)

Once all messages are converted, it will return to the stopped state.

## Adapter configuration page

Use the ***Reporting Adapter*** page to configure where to store your messages.

![Graphical user interface, text, application, email Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-048.png)

The ***Input directory*** defines the directory where SWIFT messages are read from. Ideally the same folder as the true-Broker inbox directory is configured. The ***Output directory*** defines where the converted messages are stored.

Use the following syntax if you want to store the messages in a local directory:

***/directory/\[subdirectory/\]***

In case of a network directory use the following syntax:

***smb://share/directory/\[subdirectory/\]***

You can optionally copy the URL of your network directory from your explorer:

***\\\\share\\directory\\\[subdirectory\\\]***

Do not use mapped network drives. The Tomcat Apache server is using the System account to run and does not have access to mapped network drives.

Please define the ***domain***, ***username*** and ***password*** to access the network directory.

![Graphical user interface, text, application, email Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-049.png)

Press the ***Save*** button to save your changes.

## Time scheduler configuration page

Use the Time scheduler configuration page to configure the scheduled run of the message conversion.

![Graphical user interface, text, application Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-050.png)

Enter the desired time to run the conversion and select the days on which the conversion should run. The select menu ***Period*** gives the Time scheduler the possibility to execute a task based on the selected time interval specified in minutes or hours described in chapter 9.3.

The default configuration is Mo – Fri. at 08:00 am.

Press the ***Save*** button to save to configuration.

## CSV - Reporting configuration page

Use the ***Reporting*** configuration page to change the reporting settings.

![Graphical user interface, text, application Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-051.png)

With only the CSV Converter license loaded, the options are minimal.

### PsN Light password

To convert an encrypted PsN Light ZIP file, the password of the ZIP file needs to be configured.

![Graphical user interface, text, application Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-052.png)

Enter the password and press the ***Save*** button.

To remove the password, press the ***Clear PW*** button.

### Clean database

To remove all message related data – including any created CIF Groups – from the database, press the ***Clean DB*** button.

This will not remove any configuration settings from the DB.

# Reporting

The Reporting module is used to convert SWIFT messages into either CSV files or an Excel report.

## Main page

The main page is used to trigger a conversion of messages.

![Graphical user interface, application, website Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-053.png)

Use the ***Start*** button to start converting messages. Before you can start converting messages you have to configure true-Advice Web using the configuration links under Reporting.

![Graphical user interface, application, website Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-054.png)

Once the application is running you can use the ***Refresh*** button to update the state.

![Graphical user interface, application, website Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-055.png)

Once all messages are converted, it will return to the stopped state.

## Adapter configuration page

Use the adapter configuration page to configure where to store your messages.

![Graphical user interface, text, application, email Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-056.png)

The ***Input directory*** defines the directory where the to be converted messages are read from. Ideally the same folder as the true-Broker ***Inbox directory*** is configured in case SWIFT messages are used.

The ***Output directory*** defines the directory where the resulting reports are stored.

The ***Archive directory*** defines the directory where the original messages are stored after the conversion. The original SWIFT messages are stored in a sub folder called SWIFT, the converted CSV message are stored directly in the archive folder in a daily ZIP file.

Use the following syntax if you want to store the messages into a local directory:

***/directory/\[subdirectory/\]***

In case of a network directory use the following syntax:

***smb://share/directory/\[subdirectory/\]***

You can optionally copy the URL of your network directory from your explorer:

***\\\\share\\directory\\\[subdirectory\\\]***

Do not use mapped network drives. The Tomcat Apache server is using the System account to run and does not have access to mapped network drives.

Please define the ***domain***, ***username*** and ***password*** to access the network directory.

![Graphical user interface, text, application, email Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-057.png)

Press the ***Save*** button to save your changes.

## Time scheduler configuration page

Use the Time scheduler configuration page to configure the scheduled run of the message conversion.

![Graphical user interface, text, application, chat or text message Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-058.png)

Either enter the desired time to run the conversion on or select a periodicity on which the report should be executed. Furthermore, select the days on which the conversion should be run.

The picture above shows the scheduler configured to be executed every 30 minutes. Disabling the periodically execution can be done by setting the Period menu item to ***<<Please Select>>***, in this case the scheduler will be executed at the specified start time.

The default configuration is Mo – Fri. at 08:00 am.

Press the ***Save*** button to save to configuration.

## Reporting Settings page

Use the reporting configuration page to change the ***Reporting settings***.

![Graphical user interface, text, application Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-059.png)

![Ein Bild, das Text, Screenshot, Zahl, Schrift enthält. KI-generierte Inhalte können fehlerhaft sein.](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-060.png)

### Content Settings

| Setting | Description | Default |
| --- | --- | --- |
| Excel output format | SWIFT messages are converted into an Excel report | Excel |
| CSV output format | SWIFT messages are converted into CSV files | Excel |
| Show hyper-links | Hyper-links are created in the Excel report between sheets which can be related | True |
| Show empty entries | The table of content of the Excel report will include links to empty sheets | True |
| Create empty tabs | The report will include empty sheets | True |
| Use the smallest amount of memory possible | The Excel report will not be held in memory, but directly written to the hard-drive and therefore reduce the memory usage.   However this causes that e.g. hyper-links between the sheets can no longer be created. | False |
| Use existing Excel report files | If an Excel report with the same name already exists in the output directory, it will be enhanced with the newly converted messages.   To have a report per day, which is updated on an hourly basis. The date format in the file name needs to be set to not include the time. See “Report Settings” below | False |
| Show template sheets in front | All sheets which exist in the template will be moved to the front / left in the Excel report. | False |
| Hide PSN Light sheets | Only sheets which exist in the template will be shown. All other sheets will be hidden | False |
| Use legacy masterdata | Report will be created based on legacy masterdata.   Only use this if adviced by UBS or SITS. | False |
| Enable triggered report creation | The module will check if all masterdata are available, if not it will wait for the configured sleep time and check again.   The report is only created once all messages have been received. | False |
| Sleep time for triggered report | Sleep time for above mentioned option | 600’000 ms / 10 min. |

### Report Settings

| Setting | Description | Default |
| --- | --- | --- |
| Filename | Filename of the created Excel report | PsN_Light_Report |
| Use date in filename | Filename will be appended by current date | True |
| Date format | Format of the date which is appended.   **Example:**Year yy = 19; yyyy = 2019 Month MM = 01; MMM = Jan; MMMM = January Day d = 4; dd = 04 Hour HH = 14; h = 2; h a = 2 PM Minute mm = 30 Default yyyyMMdd\_HHmm = 20190104\_1430 | yyyyMMdd_HHmm |
| Report title | Title shown on the content overview page of the Excel report | PsN Light Report |
| Report currency | Currency used on the “Summary” and “Customer Report” sheets of the Excel report | CHF |
| Font | Font used in the Excel report | Calibri |
| Logo | Logo which is shown on the content overview page of the Excel report | None |

### PsN Light password

To convert an encrypted PsN Light ZIP file, the password of the ZIP file needs to be configured.

![Graphical user interface, text, application Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-061.png)

Enter the password and press the ***Save*** button.

To remove the password, delete the content and press the ***Save*** button.

### Clean database

To remove all message related data – including any created CIF Groups – from the data-base, press the ***Delete data*** button.

This will not remove any configuration settings from the DB.

## CIF Groups

Use the ***CIF Groups*** setting page to create CIF Groups for which a report should be created.

![Graphical user interface, application Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-062.png)

For each configured CIF group, a separate Excel report will be created, which only contains data related to the configured customer CIFs.

### Add a CIF Group

Enter a name for the group and press the ***Add Group*** button.

The name of the group will be appended to the filename of the report.

![Graphical user interface, application Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-063.png)

Choose the ***Report type*** and select the CIFs you’d like to add to this CIF group and move them to the “***Selected CIF number***” part by clicking on the arrow or dragging them across. For more details, please see chapter 8.5.2.

### Configure a CIF group

Press the ***Edit*** button for the CIF group to configure

![Graphical user interface, application Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-064.png)

The Excel report must be created at least once, before a CIF group can be created.

Once the report has been run, the available CIFs are shown in the above screen. Select the needed CIFs and press on the arrow right button or drag the CIF across.

To remove CIFs from the group, select the CIFs in the “***Chosen CIFs***” list and press on the arrow left button or drag the CIF across.

| Setting | Description | Default |
| --- | --- | --- |
| Run mode | DAILY – Report for this group is created as configured in the Time scheduler. See 8.3   MANUAL – Report is only created if the module is run manually. See 0 | DAILY |
| Report Type | Default – Standard Excel report   SBIP – Only create sheets related CH data   PandL – Add columns showing PandL | Default |
| Report Currency | Currency used on the “Summary” and “Customer Report” sheets of the Excel report | CHF |

## Usage

### Report format

The format of the Excel report is based on the PsN Light format of UBS. A detailed description can be found here:

[https://www.keyon.ch/transfer/trueAdviceReporting/CSPsNLightFormatDescription.zip](https://www.keyon.ch/transfer/trueAdviceReporting/CSPsNLightFormatDescription.zip)

### Data archive

true-Advice does not delete any files. The processed files are stored in the archive folder as configured. (See Chapter 8.2) The original SWIFT files are stored in a subfolder called SWIFT. The converter PsN Light (CSV) files are stored in a daily ZIP file directly in the archive folder.

### Rerun a report

The report can be manually started as described in Chapter 8. To reuse the data of previously created report, simply copy or move the according ZIP file from the archive folder back into the input folder prior to executing the report. The ZIP files do not need to be extracted.

## Templates

Templates can be used to customize the created Excel report. true-Advice can use an existing Excel file as template, and it will add all sheets or enhance existing sheets. This way Excel formulas can be used to extract or calculate values from the created PsN Light sheets into new customized sheets.

### Template file

The template file is located here:

-   C:\\ProgramData\\keyon\\true-Advice\\cfg\\default\\TrueAdviceReporting\_Template.xlsx

It can be changed or replaced by another template. true-Advice will automatically pick up the file from this location.

An example template file is located here:

-   C:\\ProgramData\\keyon\\true-Advice\\cfg\\default\\TrueAdviceReporting\_Template-Example.xlsx

### Create a template

-   Create a new Excel file
-   Add the sheet you would like to see in your report (e.g. MySafekeepings)
-   Add Excel formulas to collect / calculate the values you’d like to see in that sheet. For example:
    -   To see the safekeeping account in column A use the below formula:  
        \='Safekeeping Accounts'!R5  
        An empty sheet “Safekeeping Accounts” needs to exist in the template.
    -   To see the respective ISIN in column B use the below formula:  
        \='Safekeeping Accounts'!AB5  
        An empty sheet “Safekeeping Accounts” needs to exist in the template.
    -   To see the description of the ISIN in column C use the below formula:  
        \=VLOOKUP(B2;'Financial Instrument Info'!B5:AB494;27;FALSE)  
        An empty sheet “Financial Instrument Info” needs to exist in the template.
    -   Expand the formula until all accounts are shown.
    -   Safe the file as TrueAdviceReporting\_Template.xlsx and replace the original template with the path mentioned above.

All available Excel formulas can be used in the template, true-Advice will fill all the empty sheets with the latest data and afterwards execute / calculate the formulas.

It is not possible to have multiple templates, if the template contains macros it needs to be named TrueAdviceReporting\_Template.xlsm and the original template file needs to be removed.

It is the responsibility of the customer to create and maintain such customized templates.

# M/L Report

The M/L Report module is based on the Reporting module and creates a specific Margin Lending report, based on the raw data from UBS. This option is currently only available for customers in APAC.

## Configuration

For a detailed description of the Reporting module, please refer to chapter 8. This chapter only explains the M/L Report specific configuration settings.

| Setting | Description | Default |
| --- | --- | --- |
| Create report for all CIFs | Creates a report for all customer, even if there are no lending / collateral available | False |
| Include collateral disclaimer | Option to exclude the disclaimer from the created report | False |

## Report

The report consists of a summary page which shows – amongst other values – the overall Market Value, Collateral Value and Liabilities Value of the client.

![Ein Bild, das Text, Screenshot, Software, Zahl enthält. KI-generierte Inhalte können fehlerhaft sein.](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-065.png)

Furthermore, it contains a separate sheet per currency, which contains a detailed list of all assets and liabilities held in the respective currency.

![Ein Bild, das Text, Screenshot, Software, Zahl enthält. KI-generierte Inhalte können fehlerhaft sein.](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-066.png)

# MiFIR Report

The MiFIR Report module is based on the Reporting module and creates an Excel report in the format specified by UnaVista, which contains all required attributes for the MiFIR report.

## Configuration

For a detailed description of the Reporting module, please refer to chapter 8. There are no options specific to the MiFIR Report.

## Template

To create the MiFIR Report, a specific template needs to be configured. For details regarding templates please refer to chapter 8.6.

The MiFIR template – which is provided by SITS – contains a sheet which includes all the static data needed to enhance the data received from UBS to create all columns required by MiFIR. This sheet needs to be maintained by the customer.

### Static Data

| Column | Description |
| --- | --- |
| Account | Account Number |
| Buyer ID Type | \*L (LEI)   \*N (National ID)   \*M (MIC)   \*I (Internal) |
| Buyer ID Sub Type | If Buy ID type = N; NIDN   Else, LEAVE\_BLANK |
| Buyer ID | Code used to identify the acquirer of the financial instrument.   Where the acquirer is a legal entity, the LEI code of the acquirer shall be used.   Where the acquirer is a non-legal entity, the identifier specified in Article 6 shall be used. |
| Buyer Country of Branch | ISO-2 Code of Country |
| Buyer First Name | Full first name(s) of the Buyer. In the case of more than one first name, all names shall be included in this field separated by a semicolon.   For repeating values use a " ; " to separate each value eg a;b;c |
| Buyer Surname | Full surname(s) of the Buyer.   In case of more than one surname, all surnames shall be included in this field separated by a semicolon.   For repeating values use a " ; " to separate each value eg a;b;c |
| Buyer DOB | Date of birth of the Buyer.   In the case of more than one Date of birth all dates of birth shall be included in this field separated by a semicolon.   For repeating values use a " ; " to separate each value eg a;b;c |
| Buyer Decision Maker ID Type | \*L (LEI)   \*N (National ID)   \*M (MIC)   \*I (Internal) |
| Buyer Decision Maker ID Sub Type | If Buy ID type = N; NIDN   Else, LEAVE\_BLANK |
| Buyer Decision Maker ID | Code used to identify the person who makes the decision to acquire the financial instrument. Where the decision is made by an investment firm, this field shall be populated with the identity of the investment firm rather than the individual making the investment decision. Where the decision maker is a legal entity, the LEI code of the decision maker shall be used. Where the decision maker is a non-legal entity, the identifier specified in Article 6 shall be used |
| Buyer Decision Maker First Name | Full first name(s) of the decision maker for the Buyer. In case of more than one first name, all names shall be included in this separated by a semicolon |
| Buyer Decision Maker Surname | Full surname(s) of the decision maker for the Buyer. In case of more than one surname, all surnames shall be included in this separated by a semicolon |
| Buyer Decision Maker DOB | Date of birth of the decision maker for the Buyer |
| Seller ID Type | \*L (LEI)   \*N (National ID)   \*M (MIC)   \*I (Internal) |
| Seller ID Sub Type | If Buy ID type = N; NIDN   Else, LEAVE\_BLANK |
| Seller ID | Code used to identify the seller of the financial instrument.   Where the seller is a legal entity, the LEI code of the seller shall be used.   Where the seller is a non-legal entity, the identifier specified in Article 6 shall be used. |
| Seller Country of Branch | Where the seller is a client, this field shall identify the country of the branch that received the order from the client or made an investment decision for a client in accordance with a discretionary mandate given to it by the client as required by Article 14(3).18 |
| Seller First Name | Full first name(s) of the Seller. In the case of more than one first name, all names shall be included in this separated by a semicolon |
| Seller Surname | Full surname(s) of the Seller. In the case of more than one surname, all surnames shall be included in this separated by a semicolon |
| Seller DOB | Date of birth of the Seller |
| Seller Decision Maker ID Type | \*L (LEI)   \*N (National ID)   \*M (MIC)   \*I (Internal) |
| Seller Decision Maker ID Sub Type | If Buy ID type = N; NIDN   Else, LEAVE\_BLANK |
| Seller Decision Maker ID | Code used to identify the person who makes the decision to acquire the financial instrument. Where the decision is made by an investment firm, this field shall be populated with the identity of the investment firm rather than the individual making the investment decision. Where the decision maker is a legal entity, the LEI code of the decision maker shall be used. Where the decision maker is a non-legal entity, the identifier specified in Article 6 shall be used      For repeating values use a " ; " to separate each value eg a;b;c |
| Seller Decision Maker First Name | Full first name(s) of the decision maker for the Seller. In the case of more than one first name, all names shall be included in this separated by a semicolon   For repeating values use a " ; " to separate each value eg a;b;c |
| Seller Decision Maker Surname | Full surname(s) of the decision maker for the Seller. In case of more than one surname, all surnames shall be included in this separated by a semicolon   For repeating values use a " ; " to separate each value eg a;b;c |
| Seller Decision Maker DOB | Date of birth of the decision maker for the Seller   For repeating values use a " ; " to separate each value eg a;b;c |
| Investment Decision ID Type | \*L (LEI)   \*N (National ID)   \*M (MIC)   \*I (Internal) |
| Investment Decision ID Sub Type | If Buy ID type = N; NIDN   Else, LEAVE\_BLANK |
| Investment Decision ID | Code used to identify the person or algorithm within the investment firm who is responsible for the investment decision. For natural persons, the identifier specified in Article 6 shall be used If the investment decision was made by an algorithm, the field shall be populated as set out in Article 8. Field only applies for investment decision within the firm. Where the transaction is for a transmitted order that has met the conditions for transmission set out in Article 4, this field shall be populated by the receiving firm within the receiving firm’s report using the information received from the transmitting firm. |
| Investment Decision Country of Branch | Code used to identify the country of the branch of the investment firm for the person responsible for the investment decision as set out in Article 14.3(b). |
| Firm Execution ID Type | \*N (National ID)   \*A (Algorithms)   \*C (Client) |
| Firm Execution ID Sub Type | If Buy ID type = N; NIDN   Else, LEAVE\_BLANK |
| Firm Execution ID | Code used to identify the person or algorithm within the investment firm who is responsible for the execution. For natural persons, the identifier specified in Article 7 shall be used if the execution was made by an algorithm, the field shall be populated as set out in Article 9. |
| Firm Execution Country of Branch | Code used to identify the country of the branch of the investment firm for the person responsible for the execution of the transaction as set out in Article 14.3(c). |

## Macros

The report is based on the Time Scheduler configuration (see chapter 8.3) once the standard report is created it can be converted into the MiFIR Report by executing two Excel macros.

-   Open the report
-   Click on the View menu
-   Click on Macros 🡪 View Macros

![Ein Bild, das Text, Screenshot, Reihe, Software enthält. KI-generierte Inhalte können fehlerhaft sein.](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-067.png)

![Ein Bild, das Text, Elektronik, Screenshot, Display enthält. KI-generierte Inhalte können fehlerhaft sein.](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-068.png)

-   Execute the first macro***: a\_createMIFIR***
-   Double check the content of the report
-   Execute the second macro: ***b\_cleanupMIFIR***

Once both macros have been run, the report consists only of one sheet called MIFIR which contains all transactions since the last report was created, and the enhanced columns sourced by the static data. This report can now be uploaded into the UnaVista web application.

# Reporting with Bloomberg®

The Reporting with Bloomberg® module is based on the Reporting module and is used to convert SWIFT messages into an Excel report which is then uploaded to Bloomberg® using an SFTP connection.

It consists of two parts, one for the creation of the report (Reporting) and the second one for the upload to Bloomberg®.

## Reporting

For a detailed description of the Reporting module, please refer to chapter 8. This chapter only explains the Bloomberg® specific configuration settings.

| Setting | Description | Default |
| --- | --- | --- |
| Include FX Forwards in the BBGUpload Sheet | If set, FX forwards are also included in the report which is forwarded to Bloomberg®. | True |

## SFTP Main page

The main page is used to trigger an upload to Bloomberg®.

![Graphical user interface, application, website Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-069.png)

Use the ***Start*** button to start uploading the files. Before you can start uploading files you have to configure true-Advice Web using the configuration links under ***Bloomberg Reporting***.

Once the application is running you can use the ***Refresh*** button to update the state. However, since the upload of the files only takes a few seconds, the status will normally jump back to stopped straight away. Based on the ***Last start up*** timestamp you can verify if it already ran.

![Graphical user interface, website Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-070.png)

Once all files are uploaded, it will return into the stopped state.

## Uploader Configuration

Use the uploader configuration page to configure where to upload your files.

![Graphical user interface, text, application, email Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-071.png)

The ***Remote-Host*** and ***Remote-Directory*** are per default set for the SFTP server of Bloomberg®. The ***SFTP username*** and ***password*** are provided to you during the setup process by Bloomberg.

The ***Output directory*** defines the directory where the files which need to be uploaded are stored. It needs to be the same directory as configured as ***Output directory*** in the ***Reporting*** module (See Chapter 8.2).

The ***archive directory*** defines where the files which were already uploaded are stored.

Use the following syntax, if you want to store the messages in a local directory:

/directory/\[subdirectory/\]

In case of a network directory use the following syntax:

smb://share/directory/\[subdirectory/\]

You can optionally copy the URL of your network directory from your explorer:

\\\\share\\directory\\\[subdirectory\\\]

Do not use mapped network drives. The Tomcat Apache server is using the System account to run and does not have access to mapped network drives.

Please define the ***domain***, ***username*** and ***password*** to access the network directory.

![Graphical user interface, text, application, email Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-072.png)

Press the Save button to save your changes

### Advanced options

In the ***advanced options*** the SSH public and private key which is used to secure the SFTP connection can be configured.

![Graphical user interface, text, application Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-073.png)

| Do not change these settings, unless you are advised by SITS support to do so. |
| --- |

## Anonymizing Portfolio for Bloomberg

In case the actual portfolio information inside the report for the Bloomberg PORT upload does not need to be sent to Bloomberg, an option to anonymize the portfolio accounts is available. Inside the file C:\\ProgramData\\keyon\\trueAdvice\\cfg\\BBUPortfolio\\BBUPortfolio.xml the information can be configured.

By setting the parameter *mapAllAccounts* to *true* and not expanding the accounts list with the accountNr and alias information, the tool generates automatically an alias to substitute the portfolio number.

![Ein Bild, das Text, Screenshot, Schrift enthält. KI-generierte Inhalte können fehlerhaft sein.](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-074.png)

## NT and UPL reporting to Bloomberg

In case the source data of the Bloomberg report is not PSN but Northern Trust of UPL of UBS there are a couple of more options for the configuration.
Which will be outlined in the following chapters.
The configuration consists of the following files.
- C:\\ProgramData\\keyon\\true-Advice\\cfg\\BbgCsvConfig\\BbgCsvConfig.xml
  - The main configuration. It holds the references to the other files and also the convertsion configuration of the Excel input
- C:\\ProgramData\\keyon\\true-Advice\\cfg\\BbgCsvConfig\\input\\NTPositions.xml
  - The parsing configuration for the CSV Inputfile from NT positions
- C:\\ProgramData\\keyon\\true-Advice\\cfg\\BbgCsvConfig\\input\\UplPositions.xml
  - The parsing configuration for the CSV Inputfile from UPL Positions
- C:\\ProgramData\\keyon\\true-Advice\\cfg\\BbgCsvConfig\\input\\UplTransactions.xml
  - The parsing configuration for the CSV Inputfile from UPL Transactions
- C:\\ProgramData\\keyon\\true-Advice\\cfg\\BbgCsvConfig\\output\\BbgNTPositionsCSV.xml
  - The mapping configuration for the CSV Output file from NT Positions
- C:\\ProgramData\\keyon\\true-Advice\\cfg\\BbgCsvConfig\\output\\BbgNTTransactionsCSV.xml
  - The mapping configuration for the CSV Output file from NT Transactions
- C:\\ProgramData\\keyon\\true-Advice\\cfg\\BbgCsvConfig\\output\\BbgPositionsCSV.xml
  - The mapping configuration for the CSV Output file from UPL Positions
- C:\\ProgramData\\keyon\\true-Advice\\cfg\\BbgCsvConfig\\output\\BbgTransactionsCSV.xml
  - The mapping configuration for the CSV Output file from UPL Transactions
- C:\\ProgramData\\keyon\\true-Advice\\cfg\\BbgCsvConfig\\BBUTransaction.xml
  - The mapping configuration for the Transactiontypes of NT/UPL to BBG
- C:\\ProgramData\\keyon\\true-Advice\\cfg\\BBUPortfolio\\BBUPortfolio.xml
    - The mapping configuration for the NT/UPL Accounts to the BBG Accounts and the corresponding Strategy Tag

### Input parsing configuration

#### BbgCsvConfig.xml
The Excel parsing can be configured as per below example:

![BbgCsvConfig.xml example](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-093.png)

Overall settings:

| Setting | Description | Default | Can be changed |
| --- | --- | --- | --- |
| dbTableName | Name of DB-Table used to store these values | dbTableName | No |
| fileNamePattern | Pattern of filenames which will be imported for this type of conversion | NAV.*xlsx | Yes |
| insertMethod | Name of the insert method used for this conversion | add | No |
| headerRowNumber | Number of row which contains the headers | 6 | Yes |

Settings for each field containt in the ColumnsList beans:

| Setting | Description | Comment |
| --- | --- | --- | 
| haeder | Value of the header in this column |  Needs to match exactly what is contained in the header row configured above |
| setMethodName | Name of the setter method used for this field value | N/A |
| index | Number of the column which contains this value | N/A |

#### NTPositions.xml, UplPositions.xml, UplTransactions.xml
These three files are composed indetically and only differ in the content.
Each one represents the parsing of the input files received by either NT or UPL and defines how the values are mapped into the database of true-Advice.

![UplPositions.xml example](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-094.png)

Overall settings:

| Setting | Description | Default | Can be changed |
| --- | --- | --- | --- |
| dbTableName | Name of DB-Table used to store these values | dbTableName | No |
| fileNamePattern | Pattern of filenames which will be imported for this type of conversion | CPV_TRA_.*csv ; CPV_POS_.*csv; inputNTPositions_.*csv | Yes |
| insertMethod | Name of the insert method used for this conversion | add | No |

Settings for each field containt in the ColumnsList beans:

| Setting | Description | Comment |
| --- | --- | --- | 
| haeder | Value of the header in this column |  Needs to match exactly what is contained in the first row of the csv |
| setMethodName | Name of the setter method used for this field value | N/A |
| index | Number of the column which contains this value | N/A |

### Output parsing configuration

#### BbgNTPositionsCSV.xml, BbgNTTransactionsCSV.xml, BbgPositionsCSV.xml, BbgTransactionsCSV.xml
These four files are composed indetically and only differ in the content.
Each one represents the mapping of the values in the true-Advice DB to the corresponding output CSV-file.

![BbgNTPositionsCSV.xml example](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-095.png)

Overall settings:

| Setting | Description | Default | Can be changed |
| --- | --- | --- | --- |
| fileNamePattern | Pattern of the file which is created from 3 strings, Customername, FileName, Date| %s_%s_%s.csv | Yes |
| filename | FileName to be used as second sring in the fileNamePattern above| Positions ; Transactions  | Yes |
| dbTableName | Name of DB-Table used to store these values | NtPositions ; NtTransactions ; UplPositions ; UplTransactions | No |
| selectMethod | Name of the select method used for this file creation | selectAll | No |
| writeFooter | Option to write a footer in the file with sums of each collumn | false | No |
| writeHeader | Option to write a header in the file| false | No |

Settings for each field containt in the ColumnsList beans:

| Setting | Description | Comment |
| --- | --- | --- | 
| haeder | Value of the header in this column |  Needs to match exactly what is required by Bloomberg |
| getMethodName | Name of the getter method used for this field value | N/A |
| createSum | Option to calculate a sum of this column for the footer of the file | Not used by Bloomberg |

### Value Mapping from Input to output files

Below table shows the mapping of the input columns for both NT and UPL input to the colmun in the bloomberg report for positions

| Input UPL | Input NT | Output BBG |
| --- | --- | --- | 
| External Client ID | GP3 fund code | Portfolio Name | 
| ISIN | ISIN | Security Identifier | 
| ValorNumber | SEDOL | SEDOL  | 
| CUSIP | Telekurs | CUSIP  | 
| BloombergTicker | Bloomberg Ticker | TICKER  | 
| Nominal Quantity | Nominal | Quantity  | 
| As Of | NAV Date | Date  | 
| Mapped based on config | Mapped based on config | Strategy Tag  | 

Below table shows the mapping of the input columns for both NT and UPL input to the colmun in the bloomberg report for transactions

| Input UPL | Input NT | Output BBG |
| --- | --- | --- | 
| External Client ID | GP3 fund code | Portfolio | 
| ISIN | Asset Code | Security_Identifier | 
| Internal Reference | Transaction Ref  | Transactions_ID | 
| Mapped based on config | Mapped based on config  | Type | 
| Quantity | Quantity Nominal  | Quantity | 
| Trade Price | Trade Price  | Price | 
| Trade Date | Trade Date  | Record_Date | 
| Mapped based on config | Mapped based on config | Strategy Tag  | 


# CSV/SWIFT Order Routing

The ***CSV/SWIFT Order Routing*** is used to exchange trading messages with UBS using the SOAP interface of true-Broker.

## CSV/SWIFT Order Routing Adapter

Use the ***CSV/SWIFT Order Routing Adapter*** to configure your connection.

![Graphical user interface, application Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-075.png)

| Setting | Description | Default |
| --- | --- | --- |
| Input directory | Defines the directory where the received files are stored | - |
| Create daily sub directories | If set, Order Routing creates a daily sub directory in the input directory | False |
| SWIFT input format | If set, the received messages are stored in SWIFT format as txt files in the input directory | SWIFT |
| CSV input format | If set, the received messages are converted into CSV and then stored as files in the input directory | SWIFT |
| Input update interval | Period in which Order Routing checks for new messages in Seconds | 15 |
| Output directory | Defines the directory where the files, which are to be sent, are stored | - |
| Output update interval | Period in which Order Routing checks for new files in Seconds | 15 |
| WSDL URL from true-Broker | URL of the true-Broker over which the messages are sent to and received from UBS | - |
| Timeout | Timeout after which the receive method is stopped | 60 |
| Sender BIC | Sender BIC which is used in SWIFT messages | - |
| Receiver BIC | Receiver BIC which is used in SWIFT messages | CRESCHZZ80A |
| Delivery Agent BIC | Delivery Agent BIC which is used in SWIFT messages for FX Settlement instructions | - |

Use the following syntax for all configured directories.

If you want to store the messages into a local directory:

/directory/\[subdirectory/\]

In case of a network directory use the following syntax:

smb://share/directory/\[subdirectory/\]

You can optionally copy the URL of your network directory from your explorer:

\\\\share\\directory\\\[subdirectory\\\]

Do not use mapped network drives. The Tomcat Apache server is using the System account to run and does not have access to mapped network drives.

Please define the ***domain***, ***username*** and ***password*** to access the network directory.

![Graphical user interface, text, application, email Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-076.png)

Press the ***Save*** button to save your changes.

## Send messages

To send SWIFT messages, simply put them as text files into the configured output directory.

To send orders using a CSV file, put the CSV with below described format into the output directory.

### Order CSV format

The CSV file must contain the header below:

MT502

V\_SR15\_1.0.0

ID;SenderBIC;ISIN;BuySell;Quantity;QuantityTypeCode;InstrumentType;OrderType;Limit;Trigger;Validity;ValidUntil;Exchange;Currency;PartyType;Party;PhoneOrder;eTicketNr;Narrative;CashAccount;SafekeepingAccount

The columns need to be divided by a semicolon.

The screenshot below does not contain the complete header, due to the limited space.

![](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-077.png)

| Column | Description | Mandatory |
| --- | --- | --- |
| ID | Numeric ID of the order, needs to be unique per day. With a maximal length of 3 | Yes |
| SenderBIC | BIC of the sender as BIC11 e.g. CRESCHZZ80A | Yes |
| ISIN | ISIN of the instrument | Yes |
| BuySell | BUYI   SELL   SUBS   REDM | Yes |
| Quantity | Quantity of order (Numeric value) | Yes |
| QuantityTypeCode | Amount   FaceAmount   UNIT | Yes |
| InstrumentType | EQU   BON | Yes |
| OrderType | Limit   Market   Stop   Stop\_Limit | Yes |
| Limit | Limit in case of a Limit order (Numeric value) | No |
| Trigger | Trigger in case of Stop order (Numeric value) | No |
| Validity | Day\_Order   Good\_Till\_Date (For CH booked accounts)   Good\_Till\_Canceled   Expire\_On (For UK Booked accounts) | Yes |
| ValidUntil | Valid until date in case of a valid until order (dd.mm.yyyy) | No |
| Exchange | Exchange to execute the order | No |
| Currency | ISO-Currency | Yes |
| PartyType | BRCR (Broker of Credit)   Party that receives the trade credit   BUYR (Buyer)   Party that receives the financial instrument.   CLBR (Clearing Broker)   Party that settles the trade on behalf of the executing broker.   INBR (Introducing Broker)   Party that has the closest association with the investor.   INVE (Investor)   Default, use sender BIC Instructing party, either an individual or organization, whose assets are being invested.   RQBR (Requested Broker)   In a directed order (:22F::TTCO//DIOR), broker with which the Receiver of the message is requested to execute the order.   SELL(Seller)   Party that delivers the financial instrument.   STBR (Step-In Broker)   Party to whom the investor directs the credit for executing the trade. | Yes |
| Party | BIC of the party as BIC11 e.g. CRESCHZZ80A | Yes |
| PhoneOrder | TRUE   FALSE | Yes   Default false |
| eTicketNr | eTicket Number in case of a phone order | No |
| Narrative | Narrative of max. 35 characters. No special characters allowed | No |
| CashAccount | Cash Account   (Format:   1234-1234567-12-123) | No |
| SafekeepingAccount | Safekeeping account   (Format:   1234-1234567-12-123) | Yes |

## Message History – Message Status

The ***Message History*** page is used to monitor all sent and received messages.

It is in the responsibility of the customer to check – at least in this page – that the message was transferred successfully and has been accepted by UBS with a respective response.

![Graphical user interface, text, application, email Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-078.png)

The history is automatically updated every 30 seconds. The ***TrueBoker Connection*** shows *connected,* if CSV/SWIFT Order Routing is running and able to reach a working true-Broker. The messages can be filtered by:

-   SEME
-   ISIN
-   State
-   Direction
-   Deposit Name
-   Value Date
-   Date From
-   Date To

### Message States

The messages can be in the following states:

| State | Description |
| --- | --- |
| Sent | Message was successfully sent to UBS.   This state only means that the technical transfer was successful. It does not necessarily mean that UBS has accepted the message. |
| Error | Message could not be sent |
| Accepted | Message was accepted by UBS, based on the received response |
| Rejected | Message was rejected by UBS, based on the received response |
| Cancellation sent | A cancellation was sent for this message to UBS |
| Cancelled | Cancellation of this message was accepted by UBS, based on the received response |
| Received | Message was received from UBS |
| Cancellation pending | Cancellation of this settlement message is pending by UBS |
| Matched | Settlement message has been matched |
| Unmatched | Settlement message is unmatched on the market |
| Pending | Settlement message is in a pending state, still possible to settle at instructed date |
| Failed | Settlement message has failed, not possible to settle at instructed date |
| Denied | Instruction was denied by UBS |
| Not accepted | Instruction was not accepted by UBS |
| Repair | Settlement message is accepted, but in repair |
| Overdue | Settlement message is overdue |
| Other | All Other states, based on the response by UBS |

### Message Details

By clicking on the link of the row of the message, the details of the message can be shown

![Graphical user interface, application, email Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-079.png)

![Graphical user interface, text, application Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-080.png)

#### Download message

Press on the ***Download SWIFT Message*** button to download the current message.

#### Cancel message

Press on the ***Cancel SWIFT Message*** button to send a cancellation for the current message to UBS.

# SSI Creator

The ***SSI Creator*** module is based on the CSV/SWIFT Order Routing and is used to create and send settlement instructions to UBS.

## Configuration

For a detailed description of the CSV/SWIFT Order Routing module, please refer to chapter 12. There are no options specific to the SSI Creator.

## Deposits

To use the SSI Creator, the used deposits need to be configured.

![Graphical user interface, application Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-081.png)

The deposits can be managed by Edit or by Add new deposit.

![Graphical user interface, application Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-082.png)

To add a new deposit, enter the ***Deposit name*** (mandatory) and the ***Broker Account*** Number (mandatory) and press the ***Save*** deposit button. If a Custodian Account or Receiver BIC is added next to a deposit, the application will use the Custodian Account or respectively the Receiver BIC inside the message.

To edit an existing deposit, press on the ***Edit*** link, enter the changes and press on the ***Save*** deposit button.

![Graphical user interface, application Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-083.png)

To delete a deposit, select the entry and press on ***Delete selected***.

## Instructions

The SSI Creator uses predefined Instructions based on the chosen broker and market.

![Graphical user interface, application, email, website Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-084.png)

The settlement instructions can be managed on the Instructions page.

![Graphical user interface, text, application, email Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-085.png)

To add a new market, click on the ***Edit Market list*** button, enter the name of the market and press the ***Add market*** button.

To delete a market, click the ***Edit Market list*** button, select the name of the market and press the ***Delete selected*** button.

![Graphical user interface, text, application Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-086.png)

To add a new broker, click on the ***Edit Broker list*** button, enter the name of the broker and press the ***Add broker*** button.

To delete a broker, click on the ***Edit Broker list*** button, select the name of the broker and press the ***Delete selected*** button.

![Graphical user interface, application Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-087.png)

To add a new Instruction, click on the ***Add new instruction*** button, enter the required values and press the ***Create instruction*** button.

![Graphical user interface, application, email, website Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-088.png)

To delete an instruction, select the required instruction and press the ***Delete selected*** button.

To export the complete list of instructions, click on the ***Export*** button.

To filter the list, click on the header column and enter the searched string

Inside the Load Settlement Instructions box the instructions can be loaded through a signed xml file provided by SITS with the settlement instructions compiled by the customer.

## SSI Creation

To send an SSI message to UBS open die SSI Create Message page. It will lead you through multiple steps in which you can enter the trade details. In the last step you can review the values and enter the required values and press on Submit to send the instructions to UBS. See below table for a detailed description.

It is in the responsibility of the customer to check – at least in the history page (chapter 12.3) – that the messages were transferred successfully and have been accepted by UBS with a respective response.

| Field | Description |
| --- | --- |
| Deposit Name | Filled automatically, based on the chosen account |
| Broker Account | The safekeeping account, list based on the configured accounts. See chapter 13.2 |
| Type of trade | Receive Against Payment (MT541)   Deliver Against Payment (MT543) |
| Trade Date | Date of trade |
| Settlement Date | Date of settlement |
| Instrument ISIN | ISIN of the instrument |
| Equity (UNIT) | Units in case of equity |
| Bonds (FAMT) | Face amount (FAMT) in case of bonds |
| Transaction currency | Currency of the transaction |
| Broker | Chose broker based on the configured ones. See chapter 13.3 |
| Market | Chose market based on the configured ones. See chapter 13.3 |
| Price | Price of the trade |
| Amount | Filled automatically, based on the other values |
| Commission 1 | Local commission (LOCO), calculated automatically if set in the instructions |
| Fees | Local fees (CHAR) |
| Stamp Duty | Stamp duty (STAM), calculated automatically if set in the instructions |
| Stoch Exchange Tax | Stock exchange tax (STEX) |
| Executing Broker’s Amount | Executing broker’s amount (EXEC) |
| Accrued Interest | Accrued interest (ACRU) for bonds only |
| Other commissions | Other commissions can be added by using the dropdown menu and the Add button.   Available options are:   Country, National, Federal Tax (COUN)   Local Tax Country Specific (LADT)   Payment Levy Tax (LEVY)   Local Tax (LOCL)   Other Amount (OTHR)   Regulatory among (REGF)   Research Fee (RSCH)   Shipping Among (SHIP)   Transfer Tax (TRAN)   Transaction Tax (TRAX)   Value-Added Tax (VATA)   Withholding Tax (WITH) |
| Net Amount | Filled automatically based on the other values |
| Settlement Indicator | For a detailed description, kindly refer to the SWIFT standard or respective market guide.   Possible options are:TRAD RODE OWNE SBRE OWNI SECB BYIY SECL CLAI SWIF NETT SWIT PLAC COV PORT EFTF REAL ISSU IBRC/OAUX |
| Stamp Duty Indicator | For a detailed description, kindly refer to the SWIFT standard or respective market guide.   Possible options are:   BENE/NBEN   BENE/YBEN   REGT/YREG   REGT/NREG   STAM/CRST/IE1X   STAM/CRST/IE8X   STAM/CRST/GBPX   STAM/CRST/GBTX   STAM/CCAS/FUSD   STAM/CCAS/HASD   STAM/STRA/USTN   SETR/SMPG/TRFD |
| Counterparty Settlement Agent | Filled automatically based on the other values |
| Counterparty | Filled automatically based on the other values |
| Place of Settlements | Filled automatically based on the other values |
| Counterparty Account | Filled automatically based on the other values |
| Place of Trade Code | For a detailed description, kindly refer to the SWIFT standard or respective market guide.   Possible options are:   EXCH   OTCO |
| Place of Trade | Place of trade |
| SI Processing Narrative | Narrative |

## Load Confirmation

The trade details can be uploaded through the SSI Load Confirmation page inside the tool. Only CSV file formats and MT515 SWIFT messages are supported. Once the trades have been uploaded, simply click on ***Instruct*** to load the Create Message page with the trade details.

![Graphical user interface, text, application, email Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-089.png)

To directly instruct one or multiple trades, select the required trades and click on ***Instruct selected***. For that to work, all details need to match, i.e., a matching market and broker needs to be configured, the loaded CSV needs to contain all details of the trade.

![Graphical user interface, application, email Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-090.png)

If some required values are missing, the trade will not be instructed. In that case the ***Instruct*** button can be used to amend the details and submit the instruction manually.

The SSI Confirmation routing module allows the table to be filtered using the searched text, inserted in the table header input fields. The Table will then filter the data based on a AND Algorithm, shown in the screenshot below.

![Graphical user interface, application Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-091.png)

### CSV-File specification

Below a description of each column in the CSV can be found. Each column must be present, non-mandatory ones can be left empty (no whitespaces).

| Field | Description | Mandatory |
| --- | --- | --- |
| Trade ID | Unique ID of the trade   Alphanumeric max 40 characters | Yes |
| Trade Status | NEW – for a new trade   CANCEL – for a cancellation      In case of cancel, the “Trade ID” must be the unique ID of the original trade which is cancelled | Yes |
| Safekeeping Account | Account-Nr of Credit-Suisse;   Or Broker-Account as configured in Deposits (See Chapter: 13.2) | Yes |
| Type of Trade | B or BL - For a Buy   S or SL - For a Sell | Yes |
| Trade Date | In the format: DD.MM.YYYY | Yes |
| Settlement Date | In the format: DD.MM.YYYY | Yes |
| ISIN | ISIN of the instrument | Yes |
| Quantity | Number of shares or face amount | Yes |
| Bond | UNIT – for equities   FAMT – for bonds | Yes |
| Currency | ISO-4217 code of the currency | Yes |
| Broker | Name of the broker   Needs to map a broker configured in the instructions (See chapter: 13.3) | Yes |
| Market | Name of the market   Needs to map a market configured in the instructions (See chapter: 13.3) | Yes |
| Price | Deal-Price | Yes |
| Amount | Deal-Amount (Price * Quantity) | Yes |
| Commission | Local Broker’s Commission | No |
| Stamp Duty | Stamp Duty | No |
| LEVY | Payment Levy Tax | No |
| LOCL | Local Tax | No |
| TRAX | Transaction Tax | No |
| ACRU | Accrued Interest Amount | No |
| Place of Trade Code | EXCH – Stock exchange   OTCO – Over the Counter | No |
| Place of Trade | MIC code of exchange (e.g. XSWX) | No |
| Stamp Duty Indicator | Stamp Duty Indicator | No |
| Narrative | Narrative for CS Trading desk. Will force manual processing of the message. Therefore, best to leave empty. | No |

## Message History – Message Status

Sent settlement instructions and received responses can be monitored in the History page of the ***CSV/SWIFT Order Routing*** module. For a detailed description please refer to chapter 12.3.

![Graphical user interface, text, application, email Description automatically generated](/uploads/images/gallery/2026-09/0de4ab658cec8dd30e52277edb2105dc19a8d988-image-092.png)