Select/Deselect Records Through Excel Upload

This facility is given for the user to select records or remove selected records from the pre-sales grid by using a list in excel.

Example: If a user needs to filter a set of properties that do not match any of the filtering criteria given in standard filters, then those. Similarly, users can deselect a certain set of records of a selected grid by uploading data through excel.

Excel filter button

Upload excel file

Filter data - upload excel

Set parameters

Filter data through excel - Set parameters

  1. Uploaded excel file can be viewed by clicking here
  2. Select the relevant excel column that needs to compare
  3. Select the relevant table column;
    1. Fiber number
    2. SSN
    3. point ID
  4. Option to select records from the grid. By using this option, the user can filter and load relevant records to the grid.
  5. Option to deselect the records from the grid. By using this option, the user can filter and remove relevant records from the grid.

Once the parameters are set, click the OK button to select/deselect records.