Data view window menu

<< Click to Display Table of Contents >>

Navigation:  Reference Manual > Windows and dialog boxes > Data view >

Data view window menu

This is the menu for the Data view window.

File, Open

Close the file currently being viewed and view another data file.  The file is checked and any errors reported.

You can change the checks and re-check the file with the [Checks] menu.

File, Save and exit

This saves the changed file and puts a copy of the original contents in the Archive sub-folder.

The window then closes.

File, Save

This saves the changed file and puts a copy of the original contents in the Archive sub-folder.

The file is then reloaded and checked from the new data file.

File, Save as

Save the current data file to a new data file.  The whole file is saved including any changes.

You can choose the type of data file to save.

File, Save viewed rows as > Viewed rows

Save the current data file to a new data file.  Only viewed rows are saved.

You can choose the type of data file to save.

File, Save viewed rows as > Other (not viewed) rows

Save the current data file to a new data file.  Only rows not being viewed are saved.

You can choose the type of data file to save.

File, Save selected rows as > Viewed rows

Save the current data file to a new data file.  Only selected rows are saved.

You can choose the type of data file to save.

File, Save selected rows as > Other (not selected) rows

Save the current data file to a new data file.  Only rows not selected are saved.

You can choose the type of data file to save.

File, Exit

Close the window.

Checks ...

Use this menu to control which checks are done when the data file is opened or checked.  See the User Guide, Handling data, Checking data for details.  The following checks can be turned on or off:

Hold filters

Empty

Not empty

Value out of range

Out of range response

Invalid response

Filtered response

Single only response

Refused response

Unallocated response

The checking does not alter faulty answers unless you also set:

Clean faulty data when checking

Checks, Whole file check

Re-checks the complete data file using the checks set above.

Edit, Updating allowed

To prevent accidental changes to a data file, this menu item must be checked before existing data records can be changed or records can be added or deleted.

Edit, Delete selected rows

All selected rows are deleted from the file.  Rows are selected using the row headers.

Edit, Add new record

A new record is added with the serial number you supply using Input start.

View ...

Use this menu to control which lines and columns are displayed.  See the User Guide, Handling data, Viewing data for details.

You can choose the columns to show:

All columns

All entries (except program) are shown as columns.

Selected entries only

Only entries selected on the Main window are shown.

Without closing the data view, you can select different entries and then Refresh.

Error columns only

Only show columns for entries that have an error in one or more records.

The following columns can be turned on or off:

Filters show

You can choose to show filter entries as columns.

Variables show

You can choose to show variable entries as columns.

ZZZ entries show

You can choose to show ZZZ questions as columns.

The following selections can be used to set the column widths for all the columns:

Narrow

Makes all the columns very small so that more are shown at the same time.

Contents visible

Makes all the columns wide enough to show all the contents of the cells.

Headers and contents visible

Makes all the columns wide enough to show all the contents of the cells and the full entry names in the column headers.

You can choose the rows to show:

All rows

All questionnaires are shown as rows.

Error rows only

Only rows that contain errors from the last checks are listed as rows.

Filter rows

Filter definition appears so that you can choose the records to view.

You can choose to set the row headers to:

Serial number

The serial numbers are used as the row header texts.

Select entry

You can choose any entry to be used for the row headers with Entry choose.

You can refresh the display:

Refresh

Updates the view with any changes.

You can output the data as currently being viewed to a report file:

Export view

You can output the data as viewed (sorted, with selected rows and columns) to:

Spreadsheet format - this produces a spreadsheet file (.xlsx) and the program set in Options settings will be invoked to view the file, any errors in the view are also highlighted in the spreadsheet file

CSV format display

Report, Summary

View summary of data for each entry in the data file with any changes made, see Data summary.

Report, List present serial numbers

Open a text file with a list of serial numbers found in the file.

Report, List missing serial numbers

Open a text file with a list of missing serial numbers in the file.