Tracker Database Tab
The CopyStorm/Restore Tracker database contains information about records that can or will be restored. The following screenshot was taken after a restore operation was partially completed:
Tracker Controls
Object
Filters displayed records by object name. Only objects which are part of the restore set are listed.
Show Fields
Only displays certain fields based on the specified option. Options include:
All — show all fields.
None — show Original Id, Restored Id, and Restore Status.
Choose Fields — select specific fields to show.
Tool
Use Tools to modify records in the Tracker Database. Tool options include:
Filter Type
The type of filter to use. Options include:
Simple
Advanced
Filter visible records using a Record Filter.
Record Type
Filters displayed records by restore status. Options include:
All — show all records.
Inserted — show records that were inserted into Salesforce.
Updated — show records that were updated in Salesforce.
Skipped — show records that were skipped by CopyStorm. Clicking on the status value will display a popup with the skipped reason.
Pending — show records waiting to be inserted or updated in Salesforce.
Simple Filter Parameters
Field
Lists all columns which support filtering by text.
Contains
Lists options for interpreting the text following this pulldown. Options include:
Contains — show any record containing the filter string.
Equals — show any record matching the filter string exactly (case insensitive).
StartsWith — show any records starting with the string.
Apply
Causes the current filter to be applied to the data.
Clear
Causes the current filter to be removed.
Example: Show only Accounts containing the string “Cardinals”
Record Status
The middle part of the dialog shows the status of each record and the corresponding data from the CopyStorm backup.
The first three columns contain tracking data for each record, the remaining columns contain record data from the CopyStorm backup. The “Name” column always appears first, other columns appear in alphabetical order.
Original Id
The unique Salesforce Id for the record in the CopyStorm backup.
Restored Id
The Salesforce Id the record was restored to in Salesforce. If the record was restored via an update, the value will be the same as the Original Id. Otherwise the value will be different.
Status
The restoration status of this record. Values include:
Inserted — this record has been added to Salesforce as a new record.
Updated — this record has been added to Salesforce by updating an existing record.
Skipped — this record was not restored to Salesforce. Click on the status to view the underlying reason.
Pending — this record is waiting to be restored.
Other Resources
The Tracker Database can be queried directly using tools like SQuirreL, or any other H2 database browser.
Database schema documentation can be found here.
Last updated
Was this helpful?