(Requested to Basant to generate the Huawei RAN XML on server & upload the CSV output on staging-DB).
Then started the data validated on staging DB for the same.

Validate the data on staging -DB for Huawei RAN & shared feedback to @Jharna.

checking the Csvs count in my local and in local db as well. there were alot of data thus uploading it in db was taking time

As per received email from Basant that updated csv output is uploaded on staging-DB but there are 2 Importer ID on date of 21-10 so I checked with Integration and they confirmed me I need to consider latest one, but again he suggested me to wait for upload the latest one of today date so discussed with integration that still updated csv output is generated & uploaded or not? and taken the followed up.

I have regenerated the Huawei RAN XML and uploaded the corresponding CSV into the database. Upon checking, I noticed that data in some tables is not reflecting correctly. Please find below the table names along with the row counts from CSV and SD for your reference.

Take the count on staging-DB for Huawei RAN as latest CSV Output uploaded by @Basant.
_________________________________________
Dear @Jharna Thakur,

As discussed during the call with @Bassem Sabbagh, please review the count details in the attached sheet. It clearly shows that the data appearing in the CSV output matches the data uploaded to the staging database.

However, the issue is that the complete data is not being parsed into the CSV output generated by @Basant Kumar on the server. There is a count mismatch between the CSV file generated on the server and the one shared by you. (Further details are available in the first email of this thread.)

Thank you
Indrasan

shared huweai ran, site,static dumps from Ooredeoo requested by jharna .

generating csv output in local and checking if the count is correct in each csv

Shared Ooredoo-propertiesFile.properties from the server with the AI team for validation.

Update Ooredoo properties file, generate CSV, and save data in SD

discussed with sanju sir via team call for Huawei RAN_Data Validation_Staging DB after that we generated huweai ran xml and check csv count on server and DB .

checking the dumps shared as well as property file also generating the csv output and checking the count for each csv

Take the only count of table data on staging-DB after CSV uploaded by integration and shared feedback to Jharna. including checked that previous raised has been fixed or not?
___________________________________________

Prepare the querry on staging DB to show the count

Update the quarry & add the quarry to show the count. and update the sheet of attribute count and share to @Bassem.

generating the csv output and loading it in local database and checking the count of each csv in db

i have uploaded Huawei RAN_Data Validation_Staging DB.

I have uploaded the Huawei RAN CSVs in SD. I verified that the data count before and after the upload matches for all tables

working on csv comparison

checking the feedback and working on it

Huawei RAN tables data validation on staging-DB.

working on feedback

Attended a teams call with Jharna to discuss and explain the highlighted issue.

I have uploaded the CSV file provided by jharna and verified the record counts before and after uploading it in SD. The counts are matching correctly in all tables.

working on feedback

Validated the data in Staging-DB for Huawei RAN and shared feedback to Jharna.

working on feedback and separating the connector

All the tables below have been dropped from SD

DROP TABLE BATCH_ELEMENT_CORE_ELEMENT;
DROP TABLE BATCH_ELEMENT_HSS;
DROP TABLE BATCH_ELEMENT_MGW;
DROP TABLE BATCH_ELEMENT_MSC;
DROP TABLE BATCH_ELEMENT_MSS;

i have applied AI 4.0.0.41 patch on Ooredeoo 102 .

separating the connector

Discussed with Jharna for related issue & regarding pending patch which to be deployed by Integration after released by Dr. Khaled & followed for the same.

I have generated the Huawei RAN XML on .102 and upload the CSV output after that I have verified the counts in all tables are correctly .

checking the Static Files used in each connector that I've worked on and why were these file were used

checking all the rules and static sheet uses and how it was use , and give the explanation to telco

checking the use of static sheet and call with telco

Check & validate the data in staging-DB for same connector.

Validate data on s-DB.

Taken the followed up with Dr. Khaled to release latest AI patch after compile code committed by @Jharna and requested to deploy the latest AI patch on server and generate the XML and upload csv output on staging-DB.

I have generated the CSV output for Huawei RAN Ooredoo using the huaweiM2000V2Connector . and csv-output has been uploaded in SD

checking the issue in local for further confirmation

All highlighted issues have now been fixed as I validated the data on staging-DB, except point no. 10, which will be addressed under OT-45 as confirmed by Jharna.

I have generated the CSV output for Huawei RAN Ooredoo using the huaweiM2000V2Connector . and csv-output has been uploaded in SD.

checking in staging db and CSV output

Validation for missing "elementnodeid" header missing in "radioantenna" in table & xml now issue is fixed, brief validation for all at node level & connector name. requested to commit the code for same.

Validated the all Huawei RAN data on server after deployed latest AI patch & using updated static sheet.