L3 Support
  1. L3 Support
  2. LS-573

Redline device dump from NEP for Infovista

        Details

        • Type: CR CR
        • Status: Cancelled Cancelled (View Workflow)
        • Priority: Normal Normal
        • Resolution: Unresolved
        • Component/s: NEP
        • Labels:
          None Labels
        • Customer:
          OMAN-Tel

          Description

          the customer is requesting to have the DB view for redline IDUs as the excel sheet attached below with all details

          1. File
            IDU Report.csv
            1.16 MB
            Salem Dannawi
          2. File
            new siites report.csv
            9.13 MB
            Salem Dannawi
          3. Microsoft Excel
            Redline DV.xlsx
            10 kB
            Salem Dannawi

            Activity

            Ascending order - Click to sort in descending order
            Permalink
            Salem Dannawi logged work - 15/Aug/25 12:00 AM
            • Time Spent:
              1 hour, 30 minutes
               

              match the existing data with the DV requested from customer

            Salem Dannawi made changes -
            Field Original Value New Value
            Gantt Options Milestone (set to milestone: having a due date but zero effort)
            Planned Start 2025-08-22 24:00 (milestone: set planned start date to due date)
            Planned End 2025-08-22 24:00 (milestone: set planned end date to due date)
            Salem Dannawi made changes -
            Remaining Estimate 0 minutes [ 0 ]
            Time Spent 1 hour, 30 minutes [ 5400 ]
            Worklog Id 274647 [ 274647 ]
            Salem Dannawi made changes -
            Baseline Start 2025-08-22 24:00 (set baseline based of initial work logging)
            Baseline End 2025-08-22 24:00 (set baseline based of initial work logging)
            Salem Dannawi made changes -
            Attachment IDU Report.csv [ 116206 ]
            Salem Dannawi made changes -
            Attachment new siites report.csv [ 116207 ]
            Permalink
            Nouha Mhadhbi logged work - 28/Aug/25 12:00 AM
            • Time Spent:
              5 hours
               

              VIEW

            Hassan Abdine made changes -
            Status Opened [ 1 ] Pending Requirements [ 10300 ]
            Hassan Abdine made changes -
            Status Pending Requirements [ 10300 ] Pending Design Session [ 10112 ]
            Hassan Abdine made changes -
            Status Pending Design Session [ 10112 ] Dev Scheduled [ 10014 ]
            Assignee Khaled Khalil [ kkhalil ] Nouha Mhadhbi [ nmhadhbi ]
            Nouha Mhadhbi made changes -
            Assignee Nouha Mhadhbi [ nmhadhbi ] Salem Dannawi [ sdannawi ]
            Hide
            Permalink
            Nouha Mhadhbi added a comment -

            The ticket has been resolved, and a batch will be released for it.
            Please find the script below to apply.

            Best regards,
            Nouha
            INSERT INTO DB_VIEW_CONF (VIEW_NAME, ATTRIBUTE_NAME, VALUE) VALUES ('REDLINE_VIEW','VERSION_NAME','put your version');

            --------------------------------------------------------------------------------------------------------------------------
            CREATE OR REPLACE FORCE EDITIONABLE VIEW REDLINE_VIEW ( "VENDOR", "IDU_NAME", "LABEL", "IDU_ID", "LOCATION", "IDU_TYPE", "NE_ID", "SITE_ID", "SITE_NAME", "LOCATION_REGION","LOCATION_CITY")
            AS WITH SELECTED_VERSION
            AS (SELECT VERSIONID VERSION_ID FROM VERSION
            WHERE NAME = (SELECT VALUE FROM DB_VIEW_CONF WHERE VIEW_NAME = 'REDLINE_VIEW' AND ATTRIBUTE_NAME = 'VERSION_NAME'))
            select m.name vendor,
            i.name IDU_NAME,
            i.name || ' '||i.objectid LABEL,
            i.objectid IDU_ID,
            c.wilayah_name LOCATION,
            type.name IDU_TYPE,
            i.neid NE_ID,
            s.objectid SITE_ID,
            s.name SITE_NAME,

            c.governate_name LOCATION_REGION,
            c.city_name LOCATION_CITY

            FROM IDU i
            left join SELECTED_VERSION v on v.VERSION_ID=i.versionid
            left join site s on s.siteid=i.siteid
            left join FN_CITY_VIEW c on c.city_id=s.zone_id
            left join IduType type on i.IduTypeID=type.IduTypeID
            left join Manufacturer m on m.ManufacturerID=type.ManufacturerID
            where m.name='REDLINE';

            Show
            Nouha Mhadhbi added a comment - The ticket has been resolved, and a batch will be released for it. Please find the script below to apply. Best regards, Nouha INSERT INTO DB_VIEW_CONF (VIEW_NAME, ATTRIBUTE_NAME, VALUE) VALUES ('REDLINE_VIEW','VERSION_NAME','put your version'); -------------------------------------------------------------------------------------------------------------------------- CREATE OR REPLACE FORCE EDITIONABLE VIEW REDLINE_VIEW ( "VENDOR", "IDU_NAME", "LABEL", "IDU_ID", "LOCATION", "IDU_TYPE", "NE_ID", "SITE_ID", "SITE_NAME", "LOCATION_REGION","LOCATION_CITY") AS WITH SELECTED_VERSION AS (SELECT VERSIONID VERSION_ID FROM VERSION WHERE NAME = (SELECT VALUE FROM DB_VIEW_CONF WHERE VIEW_NAME = 'REDLINE_VIEW' AND ATTRIBUTE_NAME = 'VERSION_NAME')) select m.name vendor, i.name IDU_NAME, i.name || ' '||i.objectid LABEL, i.objectid IDU_ID, c.wilayah_name LOCATION, type.name IDU_TYPE, i.neid NE_ID, s.objectid SITE_ID, s.name SITE_NAME, c.governate_name LOCATION_REGION, c.city_name LOCATION_CITY FROM IDU i left join SELECTED_VERSION v on v.VERSION_ID=i.versionid left join site s on s.siteid=i.siteid left join FN_CITY_VIEW c on c.city_id=s.zone_id left join IduType type on i.IduTypeID=type.IduTypeID left join Manufacturer m on m.ManufacturerID=type.ManufacturerID where m.name='REDLINE';
            Permalink
            Salem Dannawi logged work - 29/Aug/25 12:00 AM - edited
            • Time Spent:
              1 hour
               

              check the updated file,
              analyze the headers and compare it with customers requirements

            Nouha Mhadhbi made changes -
            Time Spent 1 hour, 30 minutes [ 5400 ] 6 hours, 30 minutes [ 23400 ]
            Worklog Id 275959 [ 275959 ]
            Salem Dannawi made changes -
            Time Spent 6 hours, 30 minutes [ 23400 ] 7 hours [ 25200 ]
            Worklog Id 275988 [ 275988 ]
            Salem Dannawi made changes -
            Time Spent 7 hours [ 25200 ] 7 hours, 30 minutes [ 27000 ]
            Worklog Id 275988 [ 275988 ]
            Abir Messaikeh made changes -
            Status Dev Scheduled [ 10014 ] Cancelled [ 10013 ]
            Hide
            Permalink
            Abir Messaikeh added a comment -

            DB view delivered

            Show
            Abir Messaikeh added a comment - DB view delivered
            Permalink
            Salem Dannawi logged work - 03/Sep/25 12:00 AM - edited
            • Time Spent:
              2 hours, 30 minutes
               

              update the data sent by customer,
              add the missing catalog models
              validate the new csv to be imported,
              create 2 different csvs,
              analyze the naming changing and update the file,
              delete old data,
              import the new data and validate and its working fine

            Salem Dannawi made changes -
            Time Spent 7 hours, 30 minutes [ 27000 ] 1 day, 1 hour, 30 minutes [ 34200 ]
            Worklog Id 276351 [ 276351 ]
            Salem Dannawi made changes -
            Worklog Id 276351 [ 276351 ]
            Salem Dannawi made changes -
            Time Spent 1 day, 1 hour, 30 minutes [ 34200 ] 1 day, 2 hours [ 36000 ]
            Worklog Id 276351 [ 276351 ]
            Abir Messaikeh made changes -
            Summary Redline device dump from NEP Redline device dump from NEP for Infovista
            Transition Time In Source Status Execution Times Last Executer Last Execution Date
            Opened Opened Pending Requirements Pending Requirements
            		12d 18h 10m 1 Hassan Abdine 28/Aug/25 8:42 AM
            Pending Requirements Pending Requirements Pending Design Session Pending Design Session
            		7s 1 Hassan Abdine 28/Aug/25 8:42 AM
            Pending Design Session Pending Design Session Dev Scheduled Dev Scheduled
            		14s 1 Hassan Abdine 28/Aug/25 8:43 AM
            Dev Scheduled Dev Scheduled Cancelled Cancelled
            		4d 5h 43m 1 Abir Messaikeh 01/Sep/25 2:26 PM
            Subversion JIRA

            Links Hierarchy

            		  Documentation

            Invalid license: EXPIRED

            Cancel

              People

              • Assignee:
                Salem Dannawi
                Reporter:
                Salem Dannawi
              • Votes:
                0 Vote for this issue
                Watchers:
                3 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 day, 2 hours
                  1d 2h

                    Drag and Drop