Sync Reports

Sync Reports

Once you perform a switch sync, CAIRS creates a report for all data synced between the switch and the CAIRS database. Each report displays three pieces of information:

  • Out of Sync – displays a list of out of sync records, that are either not in the switch database or not in the CAIRS database.
  • Not In Switch – displays a list of the records that are in your CAIRS database that are not in your switch database.
  • Unable to Sync – displays a list of records CAIRS was unable to sync from either database.
  • In Sync – displays a list of the records found in both databases.

You can modified the records within the report and then perform a sync directly from the report.

Viewing a Report

  1. Click the System Admin
  2. In the Navigation pane, click the plus sign (+) next to Data Sync Center to expand the menu items.
  3. Click Switch Sync Project.
  4. The Switch Sync Project list opens to the right. Within the list, double click the project to schedule.
  5. The General-Import screen opens. Within the Report ribbon group, click the Sync Results
  6. The Sync results display. There are four tabs of information:
    • Out of Sync – displays a list of out of sync records, meaning they are either not in the switch database or not in the CAIRS database.
    • Not In Switch – displays a list of the records that are in your CAIRS database that are not in your switch database.
    • Unable to Sync – displays a list of records that CAIRS was unable to sync from either database.
    • In Sync – displays a list of the records appearing the same in both databases.
  1. To view all the records within a pane, click the Show All link in the pane header.
  2. CAIRS allows only 500 records to display in a batch. To view more or less than 500 records, click in the textbox next to Max Records to Send in Batch and type-in a new number.
  3. By clicking the appropriate icon in the toolbar along the top of the window, you can export the information seen on your screen in either an Excel or PDF format.
  4. Once you have the file exported, you can save or print the information.
  5. To exit, click Close.

Out of Sync

You may have records that are out of sync, meaning that they are in your switch database but they are not in CAIRS.  These records are going to always be placed in the Out of Sync tab so you can determine what you want to do with them. Whether you want to sync the records into your CAIRS database or leave them out.  For each record, each field is going to be represented in two columns, the first column displays the information from the switch the second column displays the information from the CAIRS database.  The first three columns of the report are the most important:

  • Processing State – if a record appears in this report the state is always going to say ‘Waiting Evaluation’, this lets you know the ball is in your court
  • Record State – this column is always going to state ‘Not in CAIRS’ these records reside in your switch but not in CAIRS
  • Status – this column is going to give the reason why record did not sync, this could be anything from a duplicate record to telephone number not is switch.

There are a few choices you have when dealing with the records.  At the top of the pane are two buttons:

  • Sync Out of Sync Records – after you have resolved any discrepancies or issues with the records you can try to sync the entire report again.
  • Sync Single Number or Port – this allows you to sync individual records within the report. After you have resolved the discrepancy, click on the row to highlight and then click the button.