About the Code Value EDS Load

The EDS Load codevalue is available as part of the EagleML modernization effort as a metadata driven interface. 

The load and extract of long descriptions for code-values is supported for up to 255 characters with multilingual options. The implemented solution reused the existing code-value translation database table, PACE_MASTERDBO.EGL_GENERIC_XLATION_ML. 

For a CM example, see Code Value EDS Load RTR Example. 

The Code Value EDS Load and Extract are available with the March 2021 EagleML version or later.

About the Language ID

Before upload, be sure that the desired language ID is set up in the database, PACE_MASTERDBO.EGL _LANGUAGES.

To upload a long Code Value Description, it is not necessary to specify the language id in the incoming data file. By default, the languageId set to 0 is allied to the English language: <languageId>0</languageId>

If the languageId provided in the file does not exist in the database, then an exception error is thrown upon load/update.

If the languageId is not specified in the incoming file for a new code value record, then it will be loaded as previously, with a 50-symbol restriction for the codeValueDescription field/LONG_DESC.

If the language Id is not specified in the incoming file but an incoming code-value record already exists in the database with a defined language id, then it could be possible to upload a long Code Value Description, up to 255 symbols in length.

About the Long Code Value Description

The Long Code Value Description is fully stored in the PACE_MASTERDBO.EGL_GENERIC_XLATION_ML.DESCRIPTION field, and the first 50 symbols from the Long Code Value Description value is stored in the PACE_MASTERDBO.CODE_VALUES.LONG_DESC database field. 

To send the Long Code Value Description use <codeValueLongDescription>Description up to 255 chars</codeValueLongDescription>

Extract of the long Code Value Description, if one exists, is supported by default.

On this page