Details

    • Customer:
      Ooreedo Tunisia
    1. Missing Lat Long For Site Id.xlsx
      10 kB
      Indrasan Yadav
    2. Missing Site Id_Huawei_129 Nodes.xlsx
      2.68 MB
      Indrasan Yadav
    3. OT_Huawei_RAN All Nodes_Physical.docx
      1.67 MB
      Indrasan Yadav
    4. Require Site ID & Lat-Long_Huawei_19-08-2025.xlsx
      21 kB
      Indrasan Yadav

      Activity

      Indrasan Yadav logged work - 18/Jun/25 12:00 AM
      • Time Spent:
        2 hours
         

        Checked sample dump regarding site id & lat/long availability.

      Indrasan Yadav made changes -
      Field Original Value New Value
      Gantt Options Milestone (set to milestone: having a due date but zero effort)
      Planned Start 2025-12-30 24:00 (milestone: set planned start date to due date)
      Planned End 2025-12-30 24:00 (milestone: set planned end date to due date)
      Hide
      Indrasan Yadav added a comment -

      Checked sample dump eNodeB for site id parsing rule and it is founded in dump but will conclude once other sample damp received from customer and also waiting for any clarification regarding site data information from customer end as discussed in last meeting on 12-06-2025.

      Show
      Indrasan Yadav added a comment - Checked sample dump eNodeB for site id parsing rule and it is founded in dump but will conclude once other sample damp received from customer and also waiting for any clarification regarding site data information from customer end as discussed in last meeting on 12-06-2025.
      Indrasan Yadav made changes -
      Remaining Estimate 0 minutes [ 0 ]
      Time Spent 1 hour [ 3600 ]
      Worklog Id 269902 [ 269902 ]
      Indrasan Yadav made changes -
      Baseline Start 2025-12-30 24:00 (set baseline based of initial work logging)
      Baseline End 2025-12-30 24:00 (set baseline based of initial work logging)
      Indrasan Yadav made changes -
      Remaining Estimate 0 minutes [ 0 ] 1 hour [ 3600 ]
      Time Spent 1 hour [ 3600 ] 0 minutes [ 0 ]
      Worklog Id 269902 [ 269902 ]
      Worklog Time Spent 1 hour [ 3600 ]
      Indrasan Yadav made changes -
      Remaining Estimate 1 hour [ 3600 ] 0 minutes [ 0 ]
      Time Spent 0 minutes [ 0 ] 2 hours [ 7200 ]
      Worklog Id 269903 [ 269903 ]
      Indrasan Yadav made changes -
      Status Opened [ 1 ] In Progress [ 3 ]
      Indrasan Yadav made changes -
      Status In Progress [ 3 ] Opened [ 1 ]
      Indrasan Yadav logged work - 03/Jul/25 12:00 AM - edited
      • Time Spent:
        1 hour, 30 minutes
         

        Requested to @Jharna to generate XML for site Id for sample nodes based on updated static file SM and validate the same.

      Indrasan Yadav logged work - 04/Jul/25 12:00 AM
      • Time Spent:
        30 minutes
         

        validated the same site id issue in NEP. now it is ok.

      Indrasan Yadav made changes -
      Status Opened [ 1 ] In Progress [ 3 ]
      Hide
      Indrasan Yadav added a comment -

      As discussed with Bassem Sabbagh we need to parse site id based on sample and parse the same in NEP.

      Once customer will share full dump & any information regarding site data then we will amendment the same accordingly.

      Show
      Indrasan Yadav added a comment - As discussed with Bassem Sabbagh we need to parse site id based on sample and parse the same in NEP. Once customer will share full dump & any information regarding site data then we will amendment the same accordingly.
      Hide
      Indrasan Yadav added a comment -

      Now, site id is parsing correctly in XML based on given data in static sheet SM, and imported the same XML in NEP and also site id is coming correctly there.

      Show
      Indrasan Yadav added a comment - Now, site id is parsing correctly in XML based on given data in static sheet SM, and imported the same XML in NEP and also site id is coming correctly there.
      Indrasan Yadav made changes -
      Time Spent 2 hours [ 7200 ] 3 hours [ 10800 ]
      Worklog Id 271125 [ 271125 ]
      Indrasan Yadav made changes -
      Time Spent 3 hours [ 10800 ] 3 hours, 30 minutes [ 12600 ]
      Worklog Id 271125 [ 271125 ]
      Indrasan Yadav made changes -
      Worklog Id 271125 [ 271125 ]
      Indrasan Yadav made changes -
      Time Spent 3 hours, 30 minutes [ 12600 ] 4 hours [ 14400 ]
      Worklog Id 271212 [ 271212 ]
      Indrasan Yadav logged work - 17/Jul/25 12:00 AM
      • Time Spent:
        1 hour
         

        Checked the site naming convention rule which is shared by customer on 16-07-2025 over the sharepoint.

      Hide
      Indrasan Yadav added a comment -

      Checked the site naming convention rule which is shared by customer on 16-07-2025 over the sharepoint.

      Show
      Indrasan Yadav added a comment - Checked the site naming convention rule which is shared by customer on 16-07-2025 over the sharepoint.
      Indrasan Yadav made changes -
      Time Spent 4 hours [ 14400 ] 5 hours [ 18000 ]
      Worklog Id 272012 [ 272012 ]
      Indrasan Yadav made changes -
      Status In Progress [ 3 ] Opened [ 1 ]
      Indrasan Yadav logged work - 06/Aug/25 12:00 AM
      • Time Spent:
        6 hours
         

        Prepare the site id & site data base information based on file (CM_July) received from Ooredoo.

      Indrasan Yadav made changes -
      Attachment Missing Lat Long For Site Id.xlsx [ 114811 ]
      Hide
      Indrasan Yadav added a comment -

      Which need to be raised to Ooredoo for Huawei_RAN.

      1- There are 22 site Ids which are available in file "CM_RAN_july" but has incorrect/missing Lat/Long.
      2- There are 129 nodes whose site id are not available in file "CM_RAN_july"

      Show
      Indrasan Yadav added a comment - Which need to be raised to Ooredoo for Huawei_RAN. 1- There are 22 site Ids which are available in file "CM_RAN_july" but has incorrect/missing Lat/Long. 2- There are 129 nodes whose site id are not available in file "CM_RAN_july"
      Indrasan Yadav made changes -
      Indrasan Yadav made changes -
      Time Spent 5 hours [ 18000 ] 1 day, 3 hours [ 39600 ]
      Worklog Id 273735 [ 273735 ]
      Indrasan Yadav logged work - 19/Aug/25 12:00 AM
      • Time Spent:
        5 hours
         

        Prepare the list of missing site id & lat long and attached list on same JIRA, and make a naming convention rule to parse site id.

      Indrasan Yadav made changes -
      Attachment Require Site ID & Lat-Long_Huawei_19-08-2025.xlsx [ 115702 ]
      Hide
      Indrasan Yadav added a comment - - edited

      Final sheet is attached which need to be raised to Ooredoo for missing site id & Lat-Long.

      File name: Require Site ID & Lat-Long_Huawei_19-08-2025

      Show
      Indrasan Yadav added a comment - - edited Final sheet is attached which need to be raised to Ooredoo for missing site id & Lat-Long. File name: Require Site ID & Lat-Long_Huawei_19-08-2025
      Indrasan Yadav made changes -
      Time Spent 1 day, 3 hours [ 39600 ] 2 days [ 57600 ]
      Worklog Id 274813 [ 274813 ]
      Indrasan Yadav logged work - 20/Aug/25 12:00 AM
      • Time Spent:
        3 hours
         

        Worked on naming convention rule for Huawei RAN and updated the site matching. require rule updated in FRS & shared to @Jharna for implement the same. and the list of sites shared to @Bassem where needed sites/lat/long from customer.

      Hide
      Indrasan Yadav added a comment -

      Hi Jharna Thakur,

      Please find the attached FRS: (OT_Huawei_RAN All Nodes_Physical_20-08-2025), which details the rules to parse the Site ID for all node types for Huawei RAN.

      I’ve also shared the same via email for your reference.

      Please implement the parsing logic as specified in the FRS.

      Share back the XML along with the CSV output generated from the parsed Site IDs.

      If you have any queries or need clarifications, let me know.

      Show
      Indrasan Yadav added a comment - Hi Jharna Thakur , Please find the attached FRS: (OT_Huawei_RAN All Nodes_Physical_20-08-2025), which details the rules to parse the Site ID for all node types for Huawei RAN. I’ve also shared the same via email for your reference. Please implement the parsing logic as specified in the FRS. Share back the XML along with the CSV output generated from the parsed Site IDs. If you have any queries or need clarifications, let me know.
      Indrasan Yadav made changes -
      Attachment OT_Huawei_RAN All Nodes_Physical_20-08-2025.docx [ 115807 ]
      Indrasan Yadav made changes -
      Assignee Indrasan Yadav [ iyadav ] Jharna Thakur [ jthakur ]
      Indrasan Yadav made changes -
      Attachment Require Site ID & Lat-Long_Huawei_19-08-2025.xlsx [ 115702 ]
      Indrasan Yadav made changes -
      Indrasan Yadav made changes -
      Time Spent 2 days [ 57600 ] 2 days, 3 hours [ 68400 ]
      Worklog Id 275002 [ 275002 ]
      Hide
      Bassem Sabbagh added a comment - - edited

      WIP with OT-17 and both might be delivered by 22-8

      Show
      Bassem Sabbagh added a comment - - edited WIP with OT-17 and both might be delivered by 22-8
      Bassem Sabbagh made changes -
      Status Opened [ 1 ] In Progress [ 3 ]
      Assignee Jharna Thakur [ jthakur ] Bassem Sabbagh [ bsabbagh ]
      Bassem Sabbagh made changes -
      Assignee Bassem Sabbagh [ bsabbagh ] Jharna Thakur [ jthakur ]
      Jharna Thakur logged work - 22/Aug/25 12:00 AM - edited
      • Time Spent:
        1 day
         

        code modifications based on feedbacks

      Hide
      Bassem Sabbagh added a comment -

      delayed and to be delivered on 25-8 the first half

      Show
      Bassem Sabbagh added a comment - delayed and to be delivered on 25-8 the first half
      Jharna Thakur logged work - 25/Aug/25 12:00 AM - edited
      • Time Spent:
        1 day
         

        working on feedbacks and testing

      Hide
      Bassem Sabbagh added a comment -

      XML to be shared shortly on 25-8

      Show
      Bassem Sabbagh added a comment - XML to be shared shortly on 25-8
      Hide
      Jharna Thakur added a comment -

      xml shared

      Show
      Jharna Thakur added a comment - xml shared
      Jharna Thakur made changes -
      Assignee Jharna Thakur [ jthakur ] Indrasan Yadav [ iyadav ]
      Jharna Thakur made changes -
      Time Spent 2 days, 3 hours [ 68400 ] 3 days, 3 hours [ 97200 ]
      Worklog Id 275745 [ 275745 ]
      Jharna Thakur made changes -
      Worklog Id 275745 [ 275745 ]
      Jharna Thakur made changes -
      Time Spent 3 days, 3 hours [ 97200 ] 4 days, 3 hours [ 126000 ]
      Worklog Id 275746 [ 275746 ]
      Jharna Thakur made changes -
      Worklog Id 275746 [ 275746 ]
      Indrasan Yadav logged work - 29/Aug/25 12:00 AM
      • Time Spent:
        1 hour
         

        XML validation of Huawei RAN regarding site id.

      Hide
      Indrasan Yadav added a comment - - edited

      Site Ids are parsing based on naming convention rule in given xml. (2025-08-25-02.33.48_Ooredoo)

      Show
      Indrasan Yadav added a comment - - edited Site Ids are parsing based on naming convention rule in given xml. (2025-08-25-02.33.48_Ooredoo)
      Indrasan Yadav made changes -
      Time Spent 4 days, 3 hours [ 126000 ] 4 days, 4 hours [ 129600 ]
      Worklog Id 276117 [ 276117 ]
      Indrasan Yadav logged work - 03/Sep/25 12:00 AM
      • Time Spent:
        30 minutes
         

        Updated the static sheet "Site Data Information" for Huawei RAN BSC/RNC and shared to @Jharna when she will generate XML.

      Hide
      Indrasan Yadav added a comment -

      Dear Jharna Thakur,

      As discussed please parse the site id for BSC/RNC as same node name of them. and share the revised XML with using of updated sheet "Site Data Information".

      Show
      Indrasan Yadav added a comment - Dear Jharna Thakur , As discussed please parse the site id for BSC/RNC as same node name of them. and share the revised XML with using of updated sheet "Site Data Information".
      Indrasan Yadav made changes -
      Assignee Indrasan Yadav [ iyadav ] Jharna Thakur [ jthakur ]
      Hide
      Bassem Sabbagh added a comment -

      WIP and to be delivered by today EOD

      Show
      Bassem Sabbagh added a comment - WIP and to be delivered by today EOD
      Indrasan Yadav made changes -
      Time Spent 4 days, 4 hours [ 129600 ] 4 days, 4 hours, 30 minutes [ 131400 ]
      Worklog Id 276617 [ 276617 ]
      Hide
      Bassem Sabbagh added a comment -

      will be delivered by today EOD

      Show
      Bassem Sabbagh added a comment - will be delivered by today EOD
      Hide
      Jharna Thakur added a comment -

      xml shared

      Show
      Jharna Thakur added a comment - xml shared
      Jharna Thakur made changes -
      Assignee Jharna Thakur [ jthakur ] Indrasan Yadav [ iyadav ]
      Indrasan Yadav logged work - 10/Sep/25 12:00 AM
      • Time Spent:
        1 hour
         

        Validated the xml for sites parsing correctly or not? and now sites are parsing as per given rule for BSC/RNC.

      Hide
      Indrasan Yadav added a comment -

      Now, sites are parsing for BSC/RNC as per given rule.

      Show
      Indrasan Yadav added a comment - Now, sites are parsing for BSC/RNC as per given rule.
      Indrasan Yadav made changes -
      Time Spent 4 days, 4 hours, 30 minutes [ 131400 ] 4 days, 5 hours, 30 minutes [ 135000 ]
      Worklog Id 276976 [ 276976 ]
      Indrasan Yadav logged work - 16/Oct/25 12:00 AM
      • Time Spent:
        1 hour
         

        Updated the site data information sheet based on sites-DB shared by Ooredoo for RAN & MW.

      Indrasan Yadav made changes -
      Time Spent 4 days, 5 hours, 30 minutes [ 135000 ] 4 days, 6 hours, 30 minutes [ 138600 ]
      Worklog Id 280674 [ 280674 ]
      Indrasan Yadav logged work - 29/Oct/25 12:00 AM - edited
      • Time Spent:
        1 hour
         

        As discussed Bassem he need to update & modify the documents regarding site matching (RAN & MW) Worked on same to update the data as discussed with Bassem to take count & prepare summary with details data regarding demo with management.

      Indrasan Yadav made changes -
      Time Spent 4 days, 6 hours, 30 minutes [ 138600 ] 4 days, 7 hours, 30 minutes [ 142200 ]
      Worklog Id 282014 [ 282014 ]
      Indrasan Yadav made changes -
      Worklog Id 282014 [ 282014 ]
      Indrasan Yadav logged work - 14/Nov/25 12:00 AM
      • Time Spent:
        30 minutes
         

        Update the sheet related to site matching & shared to Bassem as he suggested to share the same to Ooredoo.

      Indrasan Yadav made changes -
      Time Spent 4 days, 7 hours, 30 minutes [ 142200 ] 1 week [ 144000 ]
      Worklog Id 283345 [ 283345 ]
      Indrasan Yadav logged work - 10/Dec/25 12:00 AM
      • Time Spent:
        1 hour, 30 minutes
         

        Worked on site matching issue based on new sheet shared by Ooredoo on secure share (Micro sites) and shared my feedback.

      Indrasan Yadav logged work - 19/Dec/25 12:00 AM
      • Time Spent:
        1 hour
         

        Worked on sites issue as discussed with Ooredoo to implement the rule for micro sites.

      Indrasan Yadav made changes -
      Time Spent 1 week [ 144000 ] 1 week, 1 hour [ 147600 ]
      Worklog Id 286517 [ 286517 ]
      Indrasan Yadav made changes -
      Time Spent 1 week, 1 hour [ 147600 ] 1 week, 2 hours, 30 minutes [ 153000 ]
      Worklog Id 286520 [ 286520 ]
      Indrasan Yadav made changes -
      Remaining Estimate 0 minutes [ 0 ] 1 hour, 30 minutes [ 5400 ]
      Time Spent 1 week, 2 hours, 30 minutes [ 153000 ] 1 week, 1 hour [ 147600 ]
      Worklog Id 286520 [ 286520 ]
      Worklog Time Spent 1 hour, 30 minutes [ 5400 ]
      Indrasan Yadav made changes -
      Remaining Estimate 1 hour, 30 minutes [ 5400 ] 0 minutes [ 0 ]
      Time Spent 1 week, 1 hour [ 147600 ] 1 week, 2 hours, 30 minutes [ 153000 ]
      Worklog Id 286523 [ 286523 ]
      Indrasan Yadav logged work - 23/Dec/25 12:00 AM
      • Time Spent:
        1 hour
         

        Worked on this to identified the possible cases so that I can discuss with Ooredoo in next meeting.

      Indrasan Yadav made changes -
      Time Spent 1 week, 2 hours, 30 minutes [ 153000 ] 1 week, 3 hours, 30 minutes [ 156600 ]
      Worklog Id 286765 [ 286765 ]
      Indrasan Yadav logged work - 24/Dec/25 12:00 AM - edited
      • Time Spent:
        1 hour, 30 minutes
         

        To make a rule to parse site id for micro sites as per Ooredoo new update & updated the FRS. and send an email for same.

        And, also send an email to Ooredoo to confirm for all possible condition to parse site id.

      Hide
      Indrasan Yadav added a comment -

      Hello @Jharna Thakur,

      Please review and implement the following updated rule to parse the Site ID, as per the customer requirement for micro site.

      Rule:
      If the value extracted from the node name (before or after the special characters _ or -) has 2 as the 4th character, and the next three digits after 2 are greater than 600, then subtract 600 from those last three digits.

      This rule is applicable to all node types; however, it is currently observed in SRAN nodes only.

      Example: Attached

      • Node Name: SFX2612
      • Rule Applied: After the 4th character 2, the next three digits are 611 (>600), so subtract 600 → 012
      • Derived Site ID: SFX2012

      Please let me know once this is implemented or if any clarification is required.

      Show
      Indrasan Yadav added a comment - Hello @Jharna Thakur, Please review and implement the following updated rule to parse the Site ID, as per the customer requirement for micro site. Rule: If the value extracted from the node name (before or after the special characters _ or -) has 2 as the 4th character, and the next three digits after 2 are greater than 600, then subtract 600 from those last three digits. This rule is applicable to all node types; however, it is currently observed in SRAN nodes only. Example: Attached • Node Name: SFX2612 • Rule Applied: After the 4th character 2, the next three digits are 611 (>600), so subtract 600 → 012 • Derived Site ID: SFX2012 Please let me know once this is implemented or if any clarification is required.
      Indrasan Yadav made changes -
      Attachment OT_Huawei_RAN All Nodes_Physical.docx [ 124807 ]
      Indrasan Yadav made changes -
      Attachment OT_Huawei_RAN All Nodes_Physical_20-08-2025.docx [ 115807 ]
      Indrasan Yadav made changes -
      Assignee Indrasan Yadav [ iyadav ] Jharna Thakur [ jthakur ]
      Indrasan Yadav made changes -
      Time Spent 1 week, 3 hours, 30 minutes [ 156600 ] 1 week, 5 hours [ 162000 ]
      Worklog Id 286885 [ 286885 ]
      Indrasan Yadav made changes -
      Worklog Id 286885 [ 286885 ]
      Jharna Thakur logged work - 26/Dec/25 12:00 AM
      • Time Spent:
        5 hours
         

        checking the rule and implementing it. also resolving issue regarding node interface, subinterface and radio antenna

      Hide
      Bassem Sabbagh added a comment -

      WIP and XML to be shared on 26-12

      Show
      Bassem Sabbagh added a comment - WIP and XML to be shared on 26-12
      Hide
      Jharna Thakur added a comment -

      xml shared

      Show
      Jharna Thakur added a comment - xml shared
      Jharna Thakur made changes -
      Assignee Jharna Thakur [ jthakur ] Indrasan Yadav [ iyadav ]
      Indrasan Yadav logged work - 29/Dec/25 12:00 AM - edited
      • Time Spent:
        2 hours, 30 minutes
         

        Check locally XML for micro site issue which was shared by @Jharna.

      Basant Kumar logged work - 29/Dec/25 12:00 AM
      • Time Spent:
        1 hour
         

        xml copied on .102 platform

      Basant Kumar logged work - 30/Dec/25 12:00 AM
      • Time Spent:
        1 hour
         

        I have uploaded the csv-output in SD then shared importerid on mail .

      Jharna Thakur made changes -
      Time Spent 1 week, 5 hours [ 162000 ] 1 week, 1 day, 2 hours [ 180000 ]
      Worklog Id 287508 [ 287508 ]
      Hide
      Indrasan Yadav added a comment -

      XML validated locally but CSV output was not uploaded due to latest AI patch deployment pending, now it is deployed and CSV output is shared by Jharna to Basant for upload it on staging-DB. Once upload done I will check & validate it on staging-DB.

      Show
      Indrasan Yadav added a comment - XML validated locally but CSV output was not uploaded due to latest AI patch deployment pending, now it is deployed and CSV output is shared by Jharna to Basant for upload it on staging-DB. Once upload done I will check & validate it on staging-DB.
      Indrasan Yadav made changes -
      Time Spent 1 week, 1 day, 2 hours [ 180000 ] 1 week, 1 day, 3 hours [ 183600 ]
      Worklog Id 287519 [ 287519 ]
      Indrasan Yadav made changes -
      Time Spent 1 week, 1 day, 3 hours [ 183600 ] 1 week, 1 day, 4 hours [ 187200 ]
      Worklog Id 287519 [ 287519 ]
      Indrasan Yadav made changes -
      Time Spent 1 week, 1 day, 4 hours [ 187200 ] 1 week, 1 day, 4 hours, 30 minutes [ 189000 ]
      Worklog Id 287519 [ 287519 ]
      Hide
      Indrasan Yadav added a comment -

      Jharna Thakur please commit the code for same.

      Show
      Indrasan Yadav added a comment - Jharna Thakur please commit the code for same.
      Indrasan Yadav made changes -
      Assignee Indrasan Yadav [ iyadav ] Jharna Thakur [ jthakur ]
      Hide
      Jharna Thakur added a comment -

      code committed

      Show
      Jharna Thakur added a comment - code committed
      Jharna Thakur made changes -
      Assignee Jharna Thakur [ jthakur ] Indrasan Yadav [ iyadav ]
      Indrasan Yadav logged work - 31/Dec/25 12:00 AM
      • Time Spent:
        2 hours
         

        Check & update the tracker which to be share to Ooredoo as suggested by @Bassem and shared over an email.

      Basant Kumar logged work - 31/Dec/25 12:00 AM
      • Time Spent:
        2 hours
         

        The latest nep_ai_batch_56 has been deployed successfully. After generating the Huawei RAN XML and CSV

      Basant Kumar made changes -
      Time Spent 1 week, 1 day, 4 hours, 30 minutes [ 189000 ] 1 week, 1 day, 5 hours, 30 minutes [ 192600 ]
      Worklog Id 287716 [ 287716 ]
      Basant Kumar made changes -
      Time Spent 1 week, 1 day, 5 hours, 30 minutes [ 192600 ] 1 week, 1 day, 6 hours, 30 minutes [ 196200 ]
      Worklog Id 287751 [ 287751 ]
      Indrasan Yadav made changes -
      Time Spent 1 week, 1 day, 6 hours, 30 minutes [ 196200 ] 1 week, 2 days, 30 minutes [ 203400 ]
      Worklog Id 287835 [ 287835 ]
      Indrasan Yadav logged work - 02/Jan/26 12:00 AM
      • Time Spent:
        1 hour
         

        As per @Bassem suggestion prepared the one consolidate sheet regarding all sites issue which to be raise to Ooredoo including for RAN & MW.

      Hide
      Indrasan Yadav added a comment -

      Dear @Jharna Thakur,

      Please find the validation feedback below based on staging-DB and csv output generated on server & uploaded by Basant:

      Importer ID: "20251231015405_2025-12-31-01.54.05"

      The site ID is now parsing correctly based on the defined micro site rule. Kindly review and confirm the following priority order:

      1. First priority: Site matching
      2. Second priority: Naming convention rule

      Please confirm if this priority logic is correctly implemented.

      As I can see, for the below nodes that fall under “site matching”, the parsing is still being done based on the naming convention rule, which should not be the case:

      (I) BSC HW TB
      (II) BSCSOS51 TEST BED
      (III) RNCTBMGH

      Kindly review and correct this so that these nodes follow the site matching logic as intended.

      Show
      Indrasan Yadav added a comment - Dear @Jharna Thakur, Please find the validation feedback below based on staging-DB and csv output generated on server & uploaded by Basant: Importer ID: "20251231015405_2025-12-31-01.54.05" The site ID is now parsing correctly based on the defined micro site rule. Kindly review and confirm the following priority order: 1. First priority: Site matching 2. Second priority: Naming convention rule Please confirm if this priority logic is correctly implemented. As I can see, for the below nodes that fall under “site matching”, the parsing is still being done based on the naming convention rule, which should not be the case: (I) BSC HW TB (II) BSCSOS51 TEST BED (III) RNCTBMGH Kindly review and correct this so that these nodes follow the site matching logic as intended.
      Indrasan Yadav made changes -
      Assignee Indrasan Yadav [ iyadav ] Jharna Thakur [ jthakur ]
      Indrasan Yadav made changes -
      Time Spent 1 week, 2 days, 30 minutes [ 203400 ] 1 week, 2 days, 1 hour, 30 minutes [ 207000 ]
      Worklog Id 287920 [ 287920 ]
      Basant Kumar made changes -
      Time Spent 1 week, 2 days, 1 hour, 30 minutes [ 207000 ] 1 week, 2 days, 3 hours, 30 minutes [ 214200 ]
      Worklog Id 288088 [ 288088 ]
      Jharna Thakur logged work - 07/Jan/26 12:00 AM
      • Time Spent:
        4 hours
         

        checking the issue and resolving it and testing

      Hide
      Bassem Sabbagh added a comment -

      WIP and WL to be be defined by Jharna

      Show
      Bassem Sabbagh added a comment - WIP and WL to be be defined by Jharna
      Hide
      Indrasan Yadav added a comment - - edited

      Hi Jharna Thakur,

      I have corrected the Site ID parsing rules as per the customer requirement and have attached the updated FRS for your reference.

      Updated Site ID Parsing Rules

      1- If the value extracted from the node name (before or after the special characters _ or -) has the 4th character as 2, and the next three digits are greater than or equal to 600, then subtract 600 from the last three digits.
      (This logic is already implemented for values greater than 600; please extend it to cover the equal to 600 condition as well) (Applicable to all node types, though currently observed only in SRAN)

      2- If the value extracted from the node name (before or after the special characters _ or -) has the 4th character as 2, and the next three digits are greater than or equal to 500, then subtract 50 from the last three digits.
      (Applicable only to NodeB)

      3- In all cases, if the value extracted after the special character has the 4th digit as 2 and the next three digits are less than 600, the extracted value itself should be considered as the Site ID (This is finding in SRAN: Example-MBTS-Ste_SOPAT_MAH2010)

      Show
      Indrasan Yadav added a comment - - edited Hi Jharna Thakur , I have corrected the Site ID parsing rules as per the customer requirement and have attached the updated FRS for your reference. Updated Site ID Parsing Rules 1- If the value extracted from the node name (before or after the special characters _ or -) has the 4th character as 2, and the next three digits are greater than or equal to 600, then subtract 600 from the last three digits. (This logic is already implemented for values greater than 600; please extend it to cover the equal to 600 condition as well) (Applicable to all node types, though currently observed only in SRAN) 2- If the value extracted from the node name (before or after the special characters _ or -) has the 4th character as 2, and the next three digits are greater than or equal to 500, then subtract 50 from the last three digits. (Applicable only to NodeB) 3- In all cases, if the value extracted after the special character has the 4th digit as 2 and the next three digits are less than 600, the extracted value itself should be considered as the Site ID (This is finding in SRAN: Example-MBTS-Ste_SOPAT_MAH2010)
      Indrasan Yadav made changes -
      Attachment OT_Huawei_RAN All Nodes_Physical.docx [ 125605 ]
      Indrasan Yadav made changes -
      Attachment OT_Huawei_RAN All Nodes_Physical.docx [ 124807 ]
      Indrasan Yadav made changes -
      Attachment OT_Huawei_RAN All Nodes_Physical.docx [ 125605 ]
      Indrasan Yadav made changes -
      Indrasan Yadav logged work - 08/Jan/26 12:00 AM - edited
      • Time Spent:
        1 hour, 30 minutes
         

        As per customer given updated rule, prepare the FRS for same and given rule to AI DEV to implement the same.

      Jharna Thakur logged work - 08/Jan/26 12:00 AM
      • Time Spent:
        5 hours
         

        working on new requirement that is added later

      Basant Kumar logged work - 08/Jan/26 12:00 AM
      • Time Spent:
        1 hour, 30 minutes
         

        I have uploaded the CSV output into SD and verified the data counts across all tables.
        The counts are matching in all tables .after that i create in all process in excel sheet then shared on mail .

      Jharna Thakur made changes -
      Time Spent 1 week, 2 days, 3 hours, 30 minutes [ 214200 ] 1 week, 2 days, 7 hours, 30 minutes [ 228600 ]
      Worklog Id 288405 [ 288405 ]
      Hide
      added a comment - - edited

      csv output shared to upload it in db. Indrasan Yadav sir can check in db after upload

      Show
      added a comment - - edited csv output shared to upload it in db. Indrasan Yadav sir can check in db after upload
      Indrasan Yadav logged work - 09/Jan/26 12:00 AM
      • Time Spent:
        2 hours, 30 minutes
         

        Validation for site matching of all nodes with all given rules and requested to commit the code for same.

      Indrasan Yadav made changes -
      Time Spent 1 week, 2 days, 7 hours, 30 minutes [ 228600 ] 1 week, 3 days, 30 minutes [ 232200 ]
      Worklog Id 288503 [ 288503 ]
      Indrasan Yadav made changes -
      Time Spent 1 week, 3 days, 30 minutes [ 232200 ] 1 week, 3 days, 1 hour [ 234000 ]
      Worklog Id 288503 [ 288503 ]
      Bassem Sabbagh made changes -
      Assignee Jharna Thakur [ jthakur ] Indrasan Yadav [ iyadav ]
      Hide
      Indrasan Yadav added a comment -

      Hi Jharna,

      Now the sites are parsing correctly as per the given rule.
      Please go ahead and commit the code for the same.

      Show
      Indrasan Yadav added a comment - Hi Jharna, Now the sites are parsing correctly as per the given rule. Please go ahead and commit the code for the same.
      Indrasan Yadav made changes -
      Assignee Indrasan Yadav [ iyadav ] Jharna Thakur [ jthakur ]
      Jharna Thakur made changes -
      Time Spent 1 week, 3 days, 1 hour [ 234000 ] 1 week, 3 days, 6 hours [ 252000 ]
      Worklog Id 288527 [ 288527 ]
      Hide
      Jharna Thakur added a comment -

      code committed

      Show
      Jharna Thakur added a comment - code committed
      Jharna Thakur made changes -
      Assignee Jharna Thakur [ jthakur ] Indrasan Yadav [ iyadav ]
      Indrasan Yadav made changes -
      Time Spent 1 week, 3 days, 6 hours [ 252000 ] 1 week, 4 days, 30 minutes [ 261000 ]
      Worklog Id 288548 [ 288548 ]
      Indrasan Yadav logged work - 12/Jan/26 12:00 AM
      • Time Spent:
        2 hours, 30 minutes
         

        Checked feedback which is received from Ooredoo in attached sheet on secure share and send an email to AI DEV to implement the same with updated static sheet.

      Basant Kumar made changes -
      Time Spent 1 week, 4 days, 30 minutes [ 261000 ] 1 week, 4 days, 2 hours [ 266400 ]
      Worklog Id 288623 [ 288623 ]
      Indrasan Yadav logged work - 13/Jan/26 12:00 AM
      • Time Spent:
        2 hours, 30 minutes
         

        Validated the same data on staging-DB deployed the latest AI patch and CSV output uploaded by integration with updated static sheet.

      Hide
      Indrasan Yadav added a comment -

      Latest patch deployed on server, to be check data on staging-DB.

      Show
      Indrasan Yadav added a comment - Latest patch deployed on server, to be check data on staging-DB.
      Hide
      Indrasan Yadav added a comment -

      Now, all site ids are correctly parsing as per given rule & confirmed by Ooredoo.

      Show
      Indrasan Yadav added a comment - Now, all site ids are correctly parsing as per given rule & confirmed by Ooredoo.
      Indrasan Yadav made changes -
      Status In Progress [ 3 ] Opened [ 1 ]
      Indrasan Yadav made changes -
      Status Opened [ 1 ] Resolved [ 5 ]
      Resolution Fixed [ 1 ]
      Indrasan Yadav made changes -
      Status Resolved [ 5 ] Closed [ 6 ]
      Indrasan Yadav made changes -
      Resolution Fixed [ 1 ]
      Status Closed [ 6 ] Reopened [ 4 ]
      Indrasan Yadav made changes -
      Time Spent 1 week, 4 days, 2 hours [ 266400 ] 1 week, 4 days, 4 hours, 30 minutes [ 275400 ]
      Worklog Id 288719 [ 288719 ]
      Indrasan Yadav made changes -
      Time Spent 1 week, 4 days, 4 hours, 30 minutes [ 275400 ] 1 week, 4 days, 7 hours [ 284400 ]
      Worklog Id 288720 [ 288720 ]
      Indrasan Yadav made changes -
      Status Reopened [ 4 ] Resolved [ 5 ]
      Resolution Fixed [ 1 ]
      Indrasan Yadav made changes -
      Status Resolved [ 5 ] Closed [ 6 ]
      Indrasan Yadav logged work - 17/Feb/26 12:00 AM
      • Time Spent:
        1 hour, 30 minutes
         

        As suggested by Bassem, consolidate the sites issue for Huawei RAN which to be share to Ooredoo.

      Indrasan Yadav logged work - 18/Feb/26 12:00 AM - edited
      • Time Spent:
        1 hour, 30 minutes
         

        Make a list of extra sites which is available in NEP and not available in site data base & after checked with internal team deleted those as confirmed by Bassem over an email.

      Indrasan Yadav made changes -
      Resolution Fixed [ 1 ]
      Status Closed [ 6 ] Reopened [ 4 ]
      Indrasan Yadav made changes -
      Time Spent 1 week, 4 days, 7 hours [ 284400 ] 2 weeks, 30 minutes [ 289800 ]
      Worklog Id 291723 [ 291723 ]
      Indrasan Yadav made changes -
      Time Spent 2 weeks, 30 minutes [ 289800 ] 2 weeks, 1 hour, 30 minutes [ 293400 ]
      Worklog Id 291725 [ 291725 ]
      Indrasan Yadav made changes -
      Time Spent 2 weeks, 1 hour, 30 minutes [ 293400 ] 2 weeks, 2 hours [ 295200 ]
      Worklog Id 291725 [ 291725 ]
      Indrasan Yadav made changes -
      Status Reopened [ 4 ] Resolved [ 5 ]
      Resolution Fixed [ 1 ]
      Indrasan Yadav made changes -
      Status Resolved [ 5 ] Closed [ 6 ]
      Indrasan Yadav logged work - 26/Mar/26 12:00 AM
      • Time Spent:
        1 day
         

        Worked on common site issues for all domain & checked in NEP and share feedback to Bassem.

      Indrasan Yadav made changes -
      Resolution Fixed [ 1 ]
      Status Closed [ 6 ] Reopened [ 4 ]
      Indrasan Yadav made changes -
      Time Spent 2 weeks, 2 hours [ 295200 ] 2 weeks, 1 day, 2 hours [ 324000 ]
      Worklog Id 295620 [ 295620 ]
      Indrasan Yadav made changes -
      Status Reopened [ 4 ] Resolved [ 5 ]
      Resolution Fixed [ 1 ]
      Indrasan Yadav made changes -
      Status Resolved [ 5 ] Closed [ 6 ]
      Indrasan Yadav logged work - 02/Apr/26 12:00 AM
      • Time Spent:
        2 hours
         

        Worked on common issue regarding sites & deleted extra sites from NEP. and shared feedback over an email.

      Indrasan Yadav made changes -
      Resolution Fixed [ 1 ]
      Status Closed [ 6 ] Reopened [ 4 ]
      Indrasan Yadav made changes -
      Time Spent 2 weeks, 1 day, 2 hours [ 324000 ] 2 weeks, 1 day, 4 hours [ 331200 ]
      Worklog Id 296015 [ 296015 ]
      Indrasan Yadav made changes -
      Status Reopened [ 4 ] Resolved [ 5 ]
      Resolution Fixed [ 1 ]
      Indrasan Yadav made changes -
      Status Resolved [ 5 ] Closed [ 6 ]
      Transition Time In Source Status Execution Times Last Executer Last Execution Date
      Opened Opened In Progress In Progress
      27d 17h 2m 3 Bassem Sabbagh 21/Aug/25 5:18 AM
      In Progress In Progress Opened Opened
      181d 12h 28m 3 Indrasan Yadav 13/Jan/26 11:09 AM
      Opened Opened Resolved Resolved
      18s 1 Indrasan Yadav 13/Jan/26 11:09 AM
      Closed Closed Reopened Reopened
      79d 17h 20m 4 Indrasan Yadav 03/Apr/26 6:03 AM
      Reopened Reopened Resolved Resolved
      1h 6m 4 Indrasan Yadav 03/Apr/26 6:37 AM
      Resolved Resolved Closed Closed
      1m 3s 5 Indrasan Yadav 03/Apr/26 6:37 AM
      Subversion JIRA

      Links Hierarchy

       Documentation

      Invalid license: EXPIRED

        People

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

          Dates

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

            Time Tracking

            Estimated:
            Original Estimate - Not Specified
            Not Specified
            Remaining:
            Remaining Estimate - 0 minutes
            0m
            Logged:
            Time Spent - 2 weeks, 1 day, 4 hours
            2w 1d 4h