Data Preview Page

The Data Preview page allows you to search, view, and restore backed up data. To open this page and view the backed up data for an object, on the Backup Details Page click the View link for the corresponding object.

In its upper part this page displays date and time when the backup operation started and when it was finished, the number of backed up objects and the total number of backed up records.

Below the Data pane displays the backed up data. The Data pane has two tabs: All and Changed to the left of the Data header. The All tab displays the actual data in object at the time of the backup operation. The Changed tab displays the records changed since the previous (or even earlier) backup operation.

note Note

If there were no successful backups prior to the current one for this backup package, only the All tab is displayed and the tab captions are not displayed, because there is no prior backup to compare the current one to.

The tab captions are also not displayed after you select check boxes for some objects or records. You will be able to switch between tabs again only after you clear check boxes or leave the Backup Details page and open it again.

 

view-data

Viewing Data

By default, Skyvia displays 10 records per grid page. You can switch between grid data pages by clicking the corresponding buttons below the grid. The number of rows per page can be changed in the Items list.

Skyvia allows sorting and filtering the data being viewed. To sort data by values of a column, click the corresponding column header. To filter data enter some characters to the box above the grid and click the search-button Search in current backup button or press Enter. Only the records, containing the entered string in any of their fields, will be displayed.

When viewing data, you can select and restore records from the backup. See more about data restore below.

You can also click the Details link for the record to view the record field values as a list instead of a table row, view all the related records and browse by relations on the Record Details Page.

You can navigate back to the list of the backed up objects using the browser Back button, Backspace key, or breadcrumbs:

breadcrumbs-account

Just click the backup date in the breadcrumbs to return to the list of the objects. With the breadcrumbs you can also easily return to the Backup Package Details Page or to the Backup Packages Page.

Analyzing Data Changes in Time

The Changed tab of the Data Preview page allows you to compare data in different backups and see data changes between them. By default it displays data changes, made since the previous backup. Under the breadcrumbs row you can see date and time of the current backup.

Below the Data header after Changed since you can see date and time of the backup you compare the current backup with. If you want to compare the current backup with an older one, click the down arrow after this timestamp, and select the necessary backup from the list. If this backup pair was never compared, the corresponding message is displayed. Click the Compare Now button to compare backups. Note that it can take some time if there is much of data backed up. In such way you can compare any backups made by the same backup package and see how data changed in time.

Note that this menu displays only backups for the same period as specified on the Backup Package Details Page page. If you want to compare with even older backup, return to this page and set longer period for displaying timeline.

backup-details-changed

When you view the records that were changed since the second compared backup, the State column displays the status of the record - whether it was added, deleted, or updated between backups. It can have the following states:

record-state-delete - the record is present in the older backup and not present in the newer one.

record-state-insert - the record is not present in the older backup and is present in the newer one.

record-state-update - the record is present in both backups, however some of its fields were changed.

For updated records (record-state-update) you can see the changed fields on the Record Preview Page. For this click the Select fields link in the second column.

When comparing backups you can select and undo changes made between backups. See more about this below.

Restoring Data

Skyvia offers two ways to restore data: using the All tab and using the Changed tab.

When you use the All tab, you need to select check boxes for the records to restore, click the Restore button, and then select the operation to perform: Insert records, Update records, or Delete records.

When you use the Changed tab, the restore operation undoes the selected changes. So you can compare two backups, then select and undo changes between them. The operation to apply is selected automatically.

note Note

For added rows (marked with record-state-insert in the State column) restore (undoing adding this row) means that the row will be deleted from the data source.

For deleted rows (marked with record-state-delete in the State column) restore (undoing deletion of this row) means that the row will be inserted to the data source.

For updated rows (marked with record-state-update in the State column) restore means undoing the row update. Values from older backup will be applied.

Thus, for example, to undo the recent changes you can perform a fresh backup, compare it with one of the previous backups, select the changes you want to undo, and click Restore.

For updated records (record-state-update) you can select and undo the separate field changes on the Record Preview Page. For this click the Select fields link in the second column and select the fields to restore.

Searching Data

Skyvia offers powerful data search functionality for your backups. You can search your backed up data by a fragment of one of its fields. For example, if you want to find a specific account in your backups, you can find it by a part of its name, address, phone, etc. Data search can be the fastest way for you if you want to find and restore a specific record.

Skyvia can search data in all backups of the current backup package. If it does not find the necessary records in the current backup, you can continue search in previous backups, and get results for the most recent backup that contains such records. If these are not the results you want, you can continue search in even older backup or navigate back to results in a newer backup.

backup-search

When you perform search on the All tab of the Data pane, all the records are searched, and when you perform search on the Changed tab, Skyvia searches only changed records.

To start searching data, open the data of the object to search in on the Backup Details page and enter the search string to the Search record box above the grid. Then click the search-button Search in current backup button or press Enter. Skyvia will display the records, containing the searched string or the message that there are no records to display. You can continue search in the older backups by clicking the search-older-button Search in older backup button. You can navigate back to newer backups by clicking the search-newer-button Search in newer backup button.

note Note

Data search can also be started on the Backup Package Details Page. In such cases it searches in all records. You can switch to the changed records after search results are displayed on the Backup Details page.