Mediation

Mediation adds a simple user interface to streamline data mediation which can be a critical part of the billing process. It allows you to easily convert your usage data into Gotransverse’s usage data format where the data can be accepted by GTV’s rating engine, then, later be consumed during regular rating (converted into pricing) and billing (added to customers’ accounts and invoices) processes.

You can do this by creating and running mediation jobs; you also have the option to edit or delete jobs. Mediation replaces the need to create and upload a GTV-supported usage spreadsheet for use on the platform.

Mediation Setup Overview

Mediation setup includes:

  1. Initial mediation setup by Gotransverse support.
  2. Adding a raw usage data file to an S3 bucket or sFTP website you supply for import into the GTV platform. Supported file formats include:
    • CSV
    • XML
    • TXT
  3. Creating a mediation job.
  4. Running a mediation job on a schedule or manually.
  5. Viewing details of the job run in real-time and job run results, including success or failure of mediation and rating acceptance.

You can also edit or delete an existing mediation job.

Creating a Mediation Job

After initial mediation setup by GTV and usage data file setup, create a mediation job.

To create a mediation job:

  1. Select Mediation from the Gotransverse action menu .
  2. Click the Setup tab in the left pane. The Setup page displays a list of created mediation jobs.
  3. Click Create System Job from the Setup action menu.
  1. The Create System Job window displays. Complete the relevant fields for the job:
Field Description
Job Name* Enter a name for your mediation job.
Status*

Select one of the following statuses for your job:

  • Active—The job will run according to its scheduled or manual job run.
  • Paused—The job will not run according to its scheduled run. If the job is run manually, it will be rejected.
Description Enter a description for the job.
Emails Enter an email address of the individual you want to notify when a job run completes.
Add Emails Click to add an additional email address for notification of job run completion.
Run Interval (Cron)

Enter information in cron format to run the job at a scheduled time. Alternatively, you can run the job manually through the Run Manager page in Mediation.

The standard cron format consists of five fields separated by white spaces: <Minute> <Hour> <Day_of_the_month> <Month_of_the_year> <Day_of_the_Week>. For example, 0 9 1 * * runs the job on the first day of each month, at 9am.

Type* Select Gotransverse Usage Mediation from the drop-down menu.
Usage Stream* Select a pre-populated product line (stream) from the drop-down menu.
Data Source*

Select either sFTP or S3 to connect GTV to the source where your usage data file is stored. Based on the option you select, the following fields display:

  • sFTP—Data server that will securely store and transfer your files to the GTV platform.
    • sFTP Host*—Enter the host name of your sFTP, for example, gasenergy.exvault.com.
    • sFTP Port*—Enter the port number of your sFTP, for example, 20.
    • sFTP Username—Enter the user name of your sFTP, for example, dasriC0!.
    • Authentication Method*—Select the authentication mode that GTV will use to access your sFTP.
      • Key-Pair—Select to allow for a GTV-generated private key authentication to connect to your sFTP.
      • Password—Select to use your sFTP password for authentication.
        • sFTP Password*—Enter your sFTP password.
  • S3—Data server hosted by Amazon Web Services (AWS) that will securely store and transfer your files to the GTV platform.
    • S3 Bucket Name*—Enter your S3 bucket name, for example, Acme.
    • AWS Access Key ID*—Enter your access key ID provided by AWS.
    • AWS Secret Key Access*—Enter your secret access key provided by AWS.
    • AWS Region Name*—Enter your secret access key provided by AWS.
Source Path Enter the source file path for the file, for example, /product/mks/mediaton/usage-files.
Source file Name* Enter the source file name, for example, MD8_Usage_File.txt.

*Indicates required field.

  1. Click Create.

Your job is added to the mediation job list on the Setup page. If the job is in Active Status and you configured the Run Interval (Cron) field during job creation, your job is set to run at the indicated interval. Otherwise, you can run an Active job manually.

Running a Mediation Job Manually

To run an existing mediation job manually:

  1. Select Mediation from the Gotransverse action menu . The Run Manager page displays. The page includes a list of already run mediation jobs.
  2. Click Create Job Run from the Run Manager action menu.
  1. The Create Job Run window displays. Complete the following fields:
    • Job*—Select an existing mediation job from the drop-down menu.
    • Job Run Name—Enter a name for your mediation job run.
  1. Click Submit.
  1. Upon submission, the job runs in the system. The job displays in the job run list on the Run Manager page.

Once your job runs, you can view the details of the run next for success or failure of mediation and rating acceptance.

Viewing Mediation Job Results

To view the details of a job run for success or failure:

  1. Select Mediation from the Gotransverse action menu . The Run Manager page displays. The page includes a list of already run mediation jobs.
  2. Select a job from the list. The Job Run Detail page displays.

    Run Information and Status Summary sections include general information about the job run such as the ID, Run Date, Job Run Name, and Run Status. Detail tabs display information related to each step of the job run.

  3. The detail tabs display the following:
Field Description
Import The imported data from your raw usage data file.
Normalized The usage data normalized into GTV-supported categories like SRID and Usage Amount so the data can be consumed by the platform.
Mediated Success The normalized usage data that was successfully mediated, or, accepted by the platform.
Mediated Failed The normalized usage data that failed to mediate. The display includes a Message column and a Details column with error message details for troubleshooting assistance.
Rating Success The mediated usage data that was successfully accepted by GTV’s rating engine.
Rating Failed The mediated usage data that failed to be accepted by GTV’s rating engine. The display includes a Message column and a Details column with error message details for troubleshooting assistance.
History Action details surrounding each stage of the job run like Created and Mediation Process: Started.

If the job run produces Mediated Failed or Rating Failed results, review the Message and Details columns under the relevant tab to learn more about errors to assist with troubleshooting and fixing the issue. If you require further assistance after troubleshooting efforts, contact Gotransverse support.

If the job run is successful, the usage data is now set to later be consumed during regular rating (converted into pricing) and billing (added to customers’ accounts and invoices) processes on the platform.

Editing a Mediation Job

To edit an existing mediation job:

  1. Select Mediation from the Gotransverse action menu .
  2. Click the Setup tab in the left pane. The Setup page displays a list of created mediation jobs.
  3. Click the ellipsis button under the Actions column next to the job you want to edit in the list, then select Edit.
  4. In the Edit System Job window, modify the desired fields. Fields that cannot be edited are grayed out like Type.
  5. Click Edit.

Deleting a Mediation Job

  1. Select Mediation from the Gotransverse action menu .
  2. Click the Setup tab in the left pane. The Setup page displays a list of created mediation jobs.
  3. Click the ellipsis button under the Actions column next to the job you want to delete in the list, then select Delete.
  4. In the Confirmation window, click Yes to confirm the deletion.