Skip to end of banner
Go to start of banner

How to import Rank Codes

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Version History

« Previous Version 12 Current »

This article explains how to import Rank Codes into APM

Workflow

  1. Download the attached Excel template for the Rank Codes import (at the bottom).

  2. Fill in the data in the columns:
    Code - max 10 symbols, capital letters only, spaces and some of the special signs are not allowed (e.g. !,?,*,%); However, there are still signs that are allowed (/,&). So you'd better test it by adding dummy Rank Code under General Codes from the user interface;
    Name - varchar (max 40 symbols);
    Sort - integer values in range 0-999;

  3. Copy the SQL select for those lines into the SQL Studio;

  4. Use CTRL+F in SQL Studio to search for all lines with ".
    Substitute all the signs " with the empty values.

  5. Run the insert statement.


  6. Refresh APM and open General Codes. You will see that the new Ranks were added into the system.

  7. We recommend you to run the insert in the Test system first to see that it works fine and only after apply the same changes in Prod.

Template

  • No labels