Import from Excel into the Almsuppression table

You can export the Almsuppression (almsuppression) table to Excel, edit it, and import the data from the spreadsheet back into the Advanced Database Editor (ADE). It is important to understand how importing and exporting works with the almsuppression table so you do not create unintended records.

The almsuppression table uses a combination of fields to work together as a unique identifier for the row. These fields are: childPt, childDB, parentDB, parentPt, and suppressionType. All of these fields work together to identify whether or not a particular record is unique.

If you want to export your almsuppression records to Excel in order to modify them, it is important to remember that all of these fields are working together. Whenever you modify one of these identifying fields in a row in the exported Excel spreadsheet and import the records back into the ADE, a new record is created in addition to the original. However, if you edit one of the records and it becomes identical to another record in the spreadsheet, ADE considers it a duplicate and ignores this row when importing the data.

Note: You can modify non-key fields in the spreadsheet and import the data back into ADE exactly the same way as you import data into other RealTime database (RTDB) tables.