Skip to main content

SKP Dictionary Upload

Elizabeth Warden
  • Updated

Overview

In the Syniti Knowledge Platform, users are able to create data quality reports (implementations) by writing SQL queries against MS SQL Server, SAP HANA, Oracle and PostgreSQL databases. To enable report technical column names to be translated into a language-specific, user-friendly column description, users can create dictionaries and assign them to systems and implementations.

This article describes the steps required to import entries into a dictionary.

Dictionary Content

Syniti has created an SAP dictionary that contains English, French and German translations for the most common SAP column names. This dictionary can be downloaded from the following location:

SKP_SAP_Dictionary.csv

Create and Upload a Dictionary

Create Dictionary

To create a dictionary:

  1. Log in to the Syniti Knowledge Platform at https://login.syniti.com/home.
  2. Navigate to Admin > Dictionaries.
  3. Click the Create dictionary button.
  4. Enter a dictionary Name (required).
  5. Enter a dictionary Description (optional).
  6. Click Save.

Upload Dictionary Entries

To upload entries to a dictionary:

  1.  Prepare a CSV file in the following format:

     PhaseIn,PhraseOut,LanguageCode,Active

     PhraseIn One,PhraseOut One,en,true

     PhraseIn One, PhraseOut One,de,true

     PhraseIn One,PhraseOut One,fr,true

The supported LanguageCode values are:

  • en
  • fr
  • de

 The options for the Active field are:

  • true
  • false
  1.  Select the dictionary into which entries are to be uploaded.
  2. Click the Upload file icon

dictionaries1.png

  1. From the pop-up window, click Browse to select the CSV file to upload.

dictionaries2.png

  1. Select the CSV file.
  2. Click Open. 

dictionaries3.png

The file contents are uploaded into the dictionary.

dictionaries4.png

Troubleshooting

If there is inconsistent data within the upload file, there is the possibility that the upload will fail due to a parsing error.

The following are common reasons the upload may fail:

  • LanguageCode column: Check that only translations for allowable languages are being used (en, fr or de) and there are no blank values
  • Active column: Check that only values of true or false are being used and there are no blank values
  • Delimitters: The upload file expects a comma separated file. Therefore, if a PhraseIn or PhraseOut contains a comma, the upload will fail as it will shift columns. It is best to remove commas from PhraseIn or PhraseOut values. If this is not possible, wrap the string with double quotes. For example a PhraseOut – Walk, Run should be presented in the upload file as “Walk, Run”

Related articles