Details

    • Customer:
      Zain KSA 3.X

      Description

      Dear @Bassem Sabbagh,

      Please assign an AI DEV resource to implement the following rule for parsing the site ID for Nokia RAN, as outlined below:

      Priority - 1:
      1. Extract the first string before any special characters (such as ‘-’, ‘_’, or ‘/’) from the node name.
      2. Search for this extracted value in column ‘C’ of the relevant tab in the “On Air Sheets V13” file, based on the node type. Retrieve the corresponding value from column “B,” which will be the site ID for the node.
      The steps for each node type are as follows:

      A. For Node Type BTS:
      • (I) Search first in the "2G_NSN" tab.
      • (II) If not found, search in the "On Air Summary" tab.
      • (III) If still not found, search in the "Dismantled Sites" tab.
      B. For Node Type NodeB:
      • (I) Search first in the "3G_NSN" tab.
      • (II) If not found, search in the "On Air Summary" tab.
      • (III) If still not found, search in the "Dismantled Sites" tab.
      C. For Node Type eNodeB:
      • (I) Search first in the "LTE_NSN" tab.
      • (II) If not found, search in the "On Air Summary" tab.
      • (III) If still not found, search in the "Dismantled Sites" tab.
      D. For Node Type SRAN:
      • (I) Search first in the "2G_NSN / 3G_NSN / LTE_NSN / 5G_NSN" tabs.
      • (II) If not found, search in the "On Air Summary" tab.
      • (III) If still not found, search in the "Dismantled Sites" tab.

      E. For Node Type BSC: Follow the "site matching sheet."
      F. For Node Type RNC: Follow the "site matching sheet."

      Priority - 2:
      We will prioritize using the “Site matching sheet” for the site ID.

      Priority - 3:
      The existing rule should be followed for the site ID.

      Best regards,
      Indrasan

      1. FRS_Physical_NSN_ZAIN-KSA.docx
        1.18 MB
        Indrasan Yadav
      2. INFO 3.csv
        1.01 MB
        Indrasan Yadav
      3. On Air Sheets V13.rar
        7.47 MB
        Indrasan Yadav
      4. Sites_Matching 3.xlsx
        546 kB
        Indrasan Yadav

      Issue Links

        Activity

        Subversion JIRA

        Links Hierarchy

         Documentation

        Invalid license: EXPIRED

          People

          • Assignee:
            Indrasan Yadav
            Reporter:
            Indrasan Yadav
          • Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Due:
              Created:
              Updated:
              Planned Start:
              Planned End:
              Actual Start:
              Date of Baselining:

              Time Tracking

              Estimated:
              Original Estimate - Not Specified
              Not Specified
              Remaining:
              Remaining Estimate - 0 minutes
              0m
              Logged:
              Time Spent - 1 week, 7 hours
              1w 7h

                Drag and Drop