Getting Started

This application provides to function to convert fare data between UIC 108.1 and UIC IRS 90918-10 formats.

To convert fare data a new conversion data set has to be created in the application and the needed data of the fares and the reference data need to be imported. In a second step the data can be enriched via the provided editing features, converted and exported.

The application is made of two main windows, one showing the complete data set as a tree (resource view) and one showing the content of leaves of the tree (property view). Additional views are included to display errors. Editing support is available in the property view for the content and in the context menu of the tree view for editing the tree structure.

Functions for import, conversion and export are available in the tool bar.

Intermediary results can be stored at any time.

Data structure

The data set - where the conversion works on - includes code lists of reference data, 108.1 data, 90918-10 data and conversion parameter

  • code lists
  • conversion
    • 108.1 fare data
      • TCVS
      • TCVS
      • TCVL
      • distance fares
      • route based fares
    • conversion parameter
  • 90918-1 fare data - organized according to the 90918-1 fare delivery data structure

Conversion from 108.1 to 90918-10

Step 1: Import Reference Data

The 90918-10 fare data are based on reference data for company codes, service brands, stations and geographical entities (NUTS codes). These code tables need to be imported first.

The data will be shown in the code list section of the data set.

Import Carriers Import of the Carriers as CSV copy of the Carrier list available on the UIC web site.
Import Service Brands Import of the Service Brands as CSV copy of the Service Brand list available on the UIC web site.
Import Stations Import of the Station data of MERITS in EDIFACT format.
Import border point codes Import of Border Point codes from a CSV file.

Step 2: Import 108.1 Fare Data

Before the import conversion parameters must be set for:

  • character code table - needed to read the local character sets in 108.1 files
  • country - needed to link the local station codes in 108.1 to the country of MERITS stations

import <b>108.1</b> data Import 108.1 Data.

To import 108.1 data the TCV file including the fare data file names must be selected. The import will then import the distance fares and route based fares, the stations TCVS, the series TCVS and TCVL. These files must all be located in the same directory.

The data will be shown in the legacy section of the data set.

Step 3: Add Conversion Parameters

The data of 108.1 are not sufficient to provide a complete set of 90918-10 fare data. The missing data need to be added in the parameter section of the data set.

The missing data are added in the conversion parameter section as fare templates which serve as a copy template to create 90918-10 fares from the imported data. Missing data can be added to the template using the editing features. The template provides a factor to derive the fare price from the standard adult price provided in the 108.1 data.

Form the fare of one series in 108.1 two fares per template are created for the two travel directions. For different travel classes separate templates need to be defined and the service class needs to be set in the fare template.

Series listed in TCVL can be attributed a separated combination constraint in the fare template.

The station codes in 108.1 have been misused to other concepts like non-MERITS-stations, border points, fare reference stations and service brands. These codes need to be mapped to the appropriate entities. For this mappings can be defined in the conversion parameter area to map these codes o the proper entities.

Border points cannot be converted directly, so the needed border points will be converted into connection points and border point mappings but the station sets of the connection points might be incomplete and must be completed manually and the conversion needs to be started again.

Step 4: Convert Data

convert 108.1 data Converts the 108.1 data into the 90918-10 data

Conversion errors will be listed in the console window.

Step 5: Export 90918-10 Data

The data delivery information needs to be provided in the delivery part of the fare data before the export.

export 90918-10 data Export the fare data in the JSON format.

Conversion from 90918-10 to 108.1

Step 1: Import Reference Data

90918-10 fare data are based on reference data for company codes, service brands and stations. These code tables need to be imported first.

The data will be shown in the code list section of the data set.

Import Carriers Import of the Carriers as CSV copy of the Carrier list available on the UIC web site.
Import Service Brands Import of the Service Brands as CSV copy of the Service Brand list available on the UIC web site.
Import Stations Import of the Station data of MERITS in EDIFACT format.
Import border point codes Import of Border Point codes from a CSV file.

Step 2: Import 90918-10 Fare Data

import <b>90918-10</b>data Import the fare data in the JSON format.

Step 3: Convert Data

90918-10 data will lose some content when converted to 108.1 data. Therefore not all data can and will be converted. From regional constraints only one direction will be converted.

The following fares will not be converted:

  • only fares with service classes B and D are converted
  • fares which are not foreseen for conversion
  • fare which are not for adults
  • fares with reduction constraints
  • fares with complex route descriptions (not only routes, too long descriptions or with too many stations)
  • fares with complex sales availability (special days)
  • fares with stations not in the defined country

Step 4: Export 108.1 Data

export <b>108.1</b> data Export the fare data in the 108.1 format.

Export files are:

  • TCV file
  • TCVS file
  • TCVG file
  • One route based fare file