Importing Codes using MS Excel Files

You can import codes into Code Value Grid using .xlsx files. The .xlsx file template must be compatible with the Code Value Grid. Hence, you should download the template file, enter the codes into it and then upload it into the Code Value Grid.

To import codes into Code Value Grid using MS Excel Files, follow these steps:

  1. Go to Application Menu > Data Catalog > Codeset Manager.
  2. Under the Codesets Workspace pane, click the required codeset.

    3. The Code Value Grid appears.

  3. Click to download the template file.

    4. The template in .xlsx format is downloaded.

  4. Enter the data in the template.

    5. Note: Set the ACTIVE_FLAG column values to Y, and set the DELETE_FLAG column values to N.

    You can use your own UI labels for user defined fields. For more information on using UI labels for user defined fields, refer to the Configuring Language Settings topic.

  5. Click .
  6. Click .

    7. The Import Excel page appears.

  7. Browse the updated .xlsx file using Choose File.
  8. Click .

    9. The codes are uploaded into the Code Value Grid.

Once you upload the codes in the Code Value Grid, you can manage codesets and managing codesets involves the following:

  • Editing Codesets
  • Copying Codesets
  • Editing Code Value Grid
  • Retiring Codesets