[OT-148] Remove Unused Static Files From Code In All Connector Created: 16/Feb/26  Updated: 30/Mar/26  Due: 27/Feb/26

Status: In Progress
Project: Ooredoo Tunisia
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Task Priority: Normal
Reporter: Indrasan Yadav Assignee: Dharmendra Patel
Resolution: Unresolved Votes: 0
Labels: AI_All_incidents, Huawei_RAN_OO, Nokia_RAN_OO
Remaining Estimate: 1 hour
Time Spent: 3 days, 7 hours, 30 minutes
Original Estimate: Not Specified

Attachments: Microsoft Excel Static Sheet Name List (1) (version 1).xlsx     Microsoft Excel Static Sheet Name List.xlsx     PNG File Telco Comment_25-03-2026.png    
Customer:
Ooreedo Tunisia
Planned Start:
Planned End:
Actual Start:
Date of Baselining:

 Description   

Dear @Bassem Sabbagh,

Earlier below are the list of static files which were available under static folder.

static_102.tgz (Link where all files were available)

Sr. No. Static File Name Comment
1 devices_belonging_toAKO2.xls Not using
2 Ericsson_MDRS_slots.xlsx Not using
3 FIxed_Media_Dest.csv Not using
4 found sites.xlsx Not using
5 Frequency bands.xlsx Updated & copied on server
6 FrequencyBandFdd.xlsx Not using
7 FrequencyBandTdd.xlsx Not using
8 GSM_Frequency_Band.xlsx Updated & copied on server
9 Huawei_Nodes_Excluded.xls Not using
10 Huawei_Routers_MB_Matching.xlsx Not using
11 Huawei_Routers_Port_Type_Matching.xlsx Not using
12 HuaweiM2V2_Sites_Matching.xls Not using
13 HuaweiTrlinkMatching.xlsx Not using
14 HW_MatchingFile.xlsx Updated & copied on server
15 HW_MatchingFile.xlsx_bkp_12Feb2024 Not using
16 HW_MatchingFile.xlsx_bkp_30May2024 Not using
17 IMS_Nodes.xlsx Not using
18 KTS.log.rar Not using
19 Logical_Physical_Matching 2018-02-02.rar Not using
20 Logical_Physical_Matching 2018-03-28.rar Not using
21 Logical_Physical_Matching 2019-02-07.rar Not using
22 Logical_Physical_Matching.xlsx Not using
23 Model_IDU_Hughes.xlsx Not using
24 Mux_Demux_matching.xlsx Not using
25 NETypeMatching file.xlsx Not using
26 Nodes_matching 2017-12-26.rar Not using
27 Nodes_matching.xls Updated & copied on server
28 Nodes_matching.xls.backup Not using
29 Nodes_matching.xls.backup2 Not using
30 Nodes_matching.xls_bkp_8apr2024 Not using
31 Nodes_matching_bck.xls Not using
32 Nodes_Names_Matching.xls Not using
33 Omantel_VSAT_RAN.csv Not using
34 ONT_Sites.xlsx Not using
35 OT-Sites Matching 2019-02-03.rar Not using
36 OT-Sites Matching.bkp.2018.03.04.xlsx.bkp Not using
37 OT-Sites Matching.xlsx Updated & copied on server
38 parentMscSgsnMatching.xlsx Not using
39 PE_Router_Loopback_IP.xlsx Not using
40 PORT_MATCHING_FILE_FIXEDACCESS.xlsx Not using
41 PortTypeMatching.xlsx Not using
42 PropertyManagement.xlsx Not using
43 PropertyManagement.xlsx.bk.2019-08-10 Not using
44 regex.txt Not using
45 Routing_Protocols_Types_Matching.xlsx Not using
46 RoutingProtocolMatching.xlsx Not using
47 ShelfMatching file.xlsx Not using
48 Site Database - MW.xlsx Not using
49 Sites_Matching_of_Optical_Splitter_Elements.xlsx Not using
50 Sites_Matchingoldversion.xlsx Not using
51 uarfcn.csv Not using
52 UTMS_Frequency_Band.xlsx Updated & copied on server
53 XDSL_Box_Sites.xlsx Not using
54 .svn Not using
55 Ericsson Not using
56 AKO2 E2E PSTN DATA 10052017.xlsx Not using
57 AKO2_PSTNE2E_PVMB.xls Not using
58 AP_DP_size.xlsx Not using
59 application_port.xlsx Not using
60 CE_ROUTER_LOOPBACK_IP.xlsx Not using
61 Channel-FrequencyMapping.xlsx Not using
62 Cisco_IP_Board_Port_Matching.xlsx Not using
63 CPOS-Channels_Cisco.xlsx Not using

And, out of above list below are the static sheet which to be use in RAN and available on server under given path and except these sheets all has been deleted from server.

1- Nodes_Matching (Static folder)
2- HW_MatchingFile (Static folder)
3- GSM_Frequency_Band (Static folder)
4- UMTS_Frequency_Band (Static folder)
5- Frequency_Band (Static folder)
6- OT Site Matching (Static folder)
7- Site data information (Site folder)

As you suggested I have created a JIRA and assigned to @Dharmendra Patel. @Dharmendra Patel you must check that is there the any code in all connectors where the any static sheet is using except the above 7 static files.

Reference JIRA ID: OT-148.

Best regards,
Indrasan



 Comments   
Comment by Bassem Sabbagh [ 17/Feb/26 ]

WL to be defined by Indrasan ... to be started on 17-2 the second half

Comment by Dharmendra Patel [ 18/Feb/26 ]

DEV WL - 2 - 2.5 days

Comment by Bassem Sabbagh [ 18/Feb/26 ]

WIP and to be completed by 19-2 EOD

Comment by Bassem Sabbagh [ 19/Feb/26 ]

WIP and to be delivered by 19-2 ... after completion, XML to be generated for RAN Nokia and Huawei with new static folder....the both XML to be shared with Indrasan for validation

Comment by Bassem Sabbagh [ 20/Feb/26 ]

Still work in progress and to delivered by 23-2

Comment by Dharmendra Patel [ 20/Feb/26 ]

Dear AI Telco Team,

I have reviewed the Ooredoo project and identified the static sheets that are currently being used. I have attached the same in this email for your reference.

Kindly review the attached static sheets and let us know whether these are required for the Ooredoo connector or if any changes are needed.

Looking forward to your confirmation.

Thanks & regards,
Dharmendra Patel

Comment by Bassem Sabbagh [ 24/Feb/26 ]

Waiting Indrasan and Divya Feedback to proceed

Comment by Indrasan Yadav [ 25/Mar/26 ]

RAN feedback attached here with file name "Telco Comment_25-03-2026".

Generated at Wed Apr 15 14:44:07 EEST 2026 using JIRA 6.1.4#6159-sha1:44eaedef2e4a625c6c7183698b2468d4719c20dc.