Exporting DB Files
Editing & Exporting Events Stored in *.DB Files
On this page:
Starting the Event Editor
The Event Editor is a tool to edit events which were previously recorded in a QINSy online session.
- This executable is started from the Raw Data Manager (Replay).
- Select one or multiple databases and select Export from the Action menu.
- Select Event Data - Event Editor as export.
- Press OK to start the Event Editor.
The default view is the data view:
Fields with a white background can be edited.
Duration values are only available for start events which have a linked end event.
See for more information about the Event Editor its inline help.
|File||Print and Save options for the report. Options are only active when the report is displayed, see View Menu-Show Report at the bottom of this page.|
|Edit||Cut, Copy and Paste options for editable (white) data fields of the events. Options are only active when an event is highlighted.|
By using the Show Report you can switch to the so-called Report View.
|Events||Add or delete events and renumber or recalculate events.|
|Tools||Export the events or set the general options and special option for reports.|
|Help||View the Help file for the Event Editor or check which version of the Event Editor you are using.|
Editor - View Menu
Enable/Disable the display of one or more of the available toolbars. (See paragraph below.)
Switches the status bar at the bottom of the display ON or OFF.
|Show Data||Show the events as they are stored in the database file.|
|Show Report||Show the events as they will be shown in the report. Note: When you adjust the settings under Tools, they will not be shown in the view on-screen but they will be printed.|
|Set how to show the columns of information in the report. (See paragraph below.)|
The Standard Buttons for editing, printing and exporting the data can be found here.
|The Event Edit Buttons are used to edit the events in the 'Show Data' view.|
An Adjustment to the data can be done by selecting a different positioning system from the drop down list on the left.
Select which columns to show by ticking them in the left pane.
When ticked in the left pane the column names will move to the right pane where they can be re-ordered using the <Move Up/Move Down> buttons.
|Number||Number of the event as assigned online as events are fired.|
|Description||The description of the event as entered in the I/O Driver - Event Output setup dialogs.|
|Line Name||Name of the line which was used as the mainline during recording of the event.|
|Time / End Time||Start and end time of the event.|
|The abbreviation of the event as entered in the I/O Driver - Event Output setup dialogs.|
|Code||The code of the event as entered in the I/O Driver Editor - Event Output setup dialogs.|
|Comment||If a 'Comment' property has been assigned to an event when defining it in the I/O Driver Editor (Event Properties - Type tab), any text added when the event is fired online is shown in this column of the Event Editor.|
|Length / Width / Height||Dimensions of the event.|
|Location||Location of the event.|
|DOL||Distance Off Line of the selected node.|
|Easting / Northing||Coordinates of the selected node.|
|Longitude / Latitude||Coordinates of the selected node.|
|Duration||Length of time the event took place.|
|<Show All>||Show all columns in the Data View and in the Report View.|
|<Hide All>||Show no columns at all in the Data View and in the Report View.|
Or use this button to clear the right pane and to start selecting columns in the left pane again.
|<Move Up/Move Down>||Use these buttons to move columns in the left pane.|
Moving the highlighted column up in the list, means it will appear more to the left in the Data View and in the Report View.
|<OK>||Close this dialog, saving the changed settings.|
|<Cancel>||Close this dialog without applying the changed settings.|
Editor - Events Menu
Add a new event.
First highlight an event, then add one, using the Select Event Type dialog:
Use the drop down button to select an event type as available in the *.xml file used online for generating the events.
|Delete a highlighted event from the list.|
Change Event type
Change the type of event.
A pop-up message warns of the consequences of editing:
|After adding or deleting events it might be useful to renumber the events starting from 1 again.|
|Line offsets and positions of events are recalculated based on the selected Adjustment and Node in the toolbar of the editor. |
Note that changes are not stored in the database.
Editor - Tools Menu
Start by using the <Edit> button to select which items to export.
In the Select Columns window check the columns for export in the left pane. Checked columns are listed in the right pane.
Change the order of columns using the Move Up/Down buttons:
Selections are listed back in the Export Events window:
|Item||Items from the Select Columns window as found under the View menu.|
|Field||Position of the item in the exported file.|
|<Export>||Export events to a text file|
|<Cancel>||Leave this menu without exporting anything.|
|<Edit>||Set the items and the order of the items to be exported. |
Option leads to the Select Columns window as found under the View menu.
|Filename||Enter the file name for the export file. The file will be stored in the Export folder of the current QINSy Project.|
|Use delimiter||Enter the delimiter which will be used between the fields in the export file.|
|Save selection||The settings entered in this dialog will be stored for future export actions.|
Create a backup
|A copy is made of the original database. '_Backup' is added to the original file name.|
Any data edits are stored in the original database.
|When this option is ticked it is not possible to edit line offsets and coordinate fields.|
|Extrapolate positions in case the last event occurred after the last position update.|
Hide end events
|End events connected to a start event will not be shown when this option is ticked.|
Date and Time
|Select how the times in the editor should be displayed, either in UTC time or in local time.|
|<OK>||Close this dialog, saving the changed settings.|
|<Cancel>||Close this dialog, not saving the changed settings.|
Select the part of the data used to generate the report.
|All charts data selection|
|All data||All available data is used in the report.|
|Plot data only between events||A selection of events will be used in the report. Choose a Start and End event in the lines below.|
|Start at event||Select an event from the drop down menu which lists all the events in the *.xml file.|
|End at event||Select an event from the drop down menu which lists all the events in the *.xml file.|
|Plot only when||If necessary, set limits to what will be used for the Track chart in the report. Select an observation from the drop down menu.|
|Larger than||Enter a limit for plotting the observation.|
|Minimum Zoom Boundary||Enter which area will be shown in the track chart.|
|Plot main line database||Select to plot the database which contains the mainline used during recording.|
|Extra Line database||If necessary, set which database contains the extra lines used during this survey.|
|Observation vs Time Chart||Select the observations to be drawn in a time-plot graph in the report.|
|Observation 1, 2, 3||Select an observation from the drop down menu.|
|Tide System||If a tide system was used during recording, it can be selected from the drop down menu.|
|<OK>||Close this dialog, confirming all settings.|
|<Cancel>||Close this dialog, leaving all settings as they were.|
View Menu - Show Report
By using the menu View\Show Report you can switch to the so-called Report View.
Select the correct report option to display graphics etc.
This report can be printed or saved to html. If saved to html then it can be viewed and printed with the Internet Explorer.
Return to: How-to Eventing