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

        Hide
        Bassem Sabbagh added a comment -

        Assigned to Juned to define the Wl

        Show
        Bassem Sabbagh added a comment - Assigned to Juned to define the Wl
        Hide
        Indrasan Yadav added a comment -

        Dear @Bassem Sabbagh,

        Please find the updated FRS attached, which includes the rule added to parse the site ID.

        An example is explained in the FRS, and the same FRS has also been attached on JIRA.

        Best regards,
        Indrasan

        Show
        Indrasan Yadav added a comment - Dear @Bassem Sabbagh, Please find the updated FRS attached, which includes the rule added to parse the site ID. An example is explained in the FRS, and the same FRS has also been attached on JIRA. Best regards, Indrasan
        Hide
        Bassem Sabbagh added a comment -

        WL = 1.5 mdays to be started on 7-1 and delivered by 8-1

        Show
        Bassem Sabbagh added a comment - WL = 1.5 mdays to be started on 7-1 and delivered by 8-1
        Hide
        Bassem Sabbagh added a comment -

        it is on hold till Sandya commit the code

        Show
        Bassem Sabbagh added a comment - it is on hold till Sandya commit the code
        Hide
        Bassem Sabbagh added a comment -

        code committed and to be started on 9-1

        Show
        Bassem Sabbagh added a comment - code committed and to be started on 9-1
        Hide
        Juned Ali added a comment - - edited

        will be delivered by tommorrow first half !!

        Show
        Juned Ali added a comment - - edited will be delivered by tommorrow first half !!
        Hide
        Bassem Sabbagh added a comment -

        to be delivered by 10-1

        Show
        Bassem Sabbagh added a comment - to be delivered by 10-1
        Hide
        Juned Ali added a comment -

        rule to be correct for bts node , waiting for indrasan call !!

        Show
        Juned Ali added a comment - rule to be correct for bts node , waiting for indrasan call !!
        Hide
        Indrasan Yadav added a comment -

        Dear @Juned,

        As discussed yesterday over the phone call, please proceed to apply the given rule where it is applicable:

        Applicable Nodes:

        NodeB
        SRAN
        Already Updated:

        For BSC and RNC, the site matching sheet has already been updated.
        Not Applicable Nodes:

        eNodeB
        BTS
        You can ignore applying the rule for eNodeB and BTS for now. Once we receive any feedback from the customer, we will modify and implement the rule accordingly.

        Best regards,
        Indrasan

        Show
        Indrasan Yadav added a comment - Dear @Juned, As discussed yesterday over the phone call, please proceed to apply the given rule where it is applicable: Applicable Nodes: NodeB SRAN Already Updated: For BSC and RNC, the site matching sheet has already been updated. Not Applicable Nodes: eNodeB BTS You can ignore applying the rule for eNodeB and BTS for now. Once we receive any feedback from the customer, we will modify and implement the rule accordingly. Best regards, Indrasan
        Hide
        Juned Ali added a comment -

        xml and csv shared on mail

        Show
        Juned Ali added a comment - xml and csv shared on mail
        Hide
        Indrasan Yadav added a comment -

        Dear @Juned Ali,

        Please find below validation remarks:

        1- 416 NodeB are not parsing in XML/CSV and related physical also, please find below snippet out of them for your reference.

        2- Still site id is not appearing against BSC/RNC as I think you didn’t used updated site matching sheet which I have also attached on mail & same JIRA.

        Best regards,
        Indrasan

        Show
        Indrasan Yadav added a comment - Dear @Juned Ali, Please find below validation remarks: 1- 416 NodeB are not parsing in XML/CSV and related physical also, please find below snippet out of them for your reference. 2- Still site id is not appearing against BSC/RNC as I think you didn’t used updated site matching sheet which I have also attached on mail & same JIRA. Best regards, Indrasan
        Hide
        Juned Ali added a comment -

        xml and csv Shared !!

        Show
        Juned Ali added a comment - xml and csv Shared !!
        Hide
        Indrasan Yadav added a comment -

        Hello @Juned Ali,

        Still below nodes are coming on “Auto Site” while site id is available in “site matching sheet” against these nodes (BSC & RNC), please check & fix the same.

        Here, I am sharing one example for RNC “JZN1RNC1” whis is available in “site matching sheet”

        And please ensure all those nodes which are coming with “Auto Site” should be appear in add info under Actual Site.

        Best regards,
        Indrasan

        Show
        Indrasan Yadav added a comment - Hello @Juned Ali, Still below nodes are coming on “Auto Site” while site id is available in “site matching sheet” against these nodes (BSC & RNC), please check & fix the same. Here, I am sharing one example for RNC “JZN1RNC1” whis is available in “site matching sheet” And please ensure all those nodes which are coming with “Auto Site” should be appear in add info under Actual Site. Best regards, Indrasan
        Hide
        Indrasan Yadav added a comment -

        Hi @Indrasan Yadav,

        1. Site ID COMING As Auto site because it doesn’t meant that if it is present in site matching sheet then it will definitely came although before that we have to check that in info.csv and there it is not present so it coming as Autosite in npsbsc and same has been available in addinfo as actual site. (It was not a issue )

        2. Now All Rnc SiteId are Coming in npsRnc !! (fixed)

        Point 1 was not an issue and 2 point has been resolved !!

        Thank you !!

        Show
        Indrasan Yadav added a comment - Hi @Indrasan Yadav, 1. Site ID COMING As Auto site because it doesn’t meant that if it is present in site matching sheet then it will definitely came although before that we have to check that in info.csv and there it is not present so it coming as Autosite in npsbsc and same has been available in addinfo as actual site. (It was not a issue ) 2. Now All Rnc SiteId are Coming in npsRnc !! (fixed) Point 1 was not an issue and 2 point has been resolved !! Thank you !!
        Hide
        Indrasan Yadav added a comment -

        Hi @Juned,

        Please commit the code for same.

        Show
        Indrasan Yadav added a comment - Hi @Juned, Please commit the code for same.
        Hide
        Navneet Kaur added a comment -

        @Juned: Has the code been committed?

        Show
        Navneet Kaur added a comment - @Juned: Has the code been committed?
        Hide
        Juned Ali added a comment -

        CODE COMMITTED ++

        Show
        Juned Ali added a comment - CODE COMMITTED ++
        Hide
        Indrasan Yadav added a comment -

        We are now closing this child JIRA as it pertains to an individual issue.

        As suggested by @Ahad, all code commit JIRAs will be covered under the parent JIRA.

        Show
        Indrasan Yadav added a comment - We are now closing this child JIRA as it pertains to an individual issue. As suggested by @Ahad, all code commit JIRAs will be covered under the parent JIRA.

          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