GUImaint Help
How-To Use the 2.0 release
Notes on using
Important: Do not edit the dataset at the same time that the "insert_multiple_files" script is running or this error can occur: "An error occurred saving a change to the 'dataset' table" ("Deadlock found when trying to get lock; Try restarting transaction message from server. Lock wait timeout exceeded; try restarting transaction.") Understand how to use the NavToolBar. See the section below entitled To post, save, delete, update, add data, etc.
To begin:
Click on the Log In button and enter your user ID (all in lower case) as it was set for the maint program, e.g. "dstott". This will take you to the Search page. You can also get to the Start or Search pages at any time by clicking on the tabs along the left side.
83.01% is entered in the search box to get you started. The percent sign (%) is a wild card like the asterisk (*) is in other programs. Enter any other search terms. A tool tip will be shown if you hover the mouse over the search box. There are tool tips for a number of input fields on the different pages, and buttons at the bottom.
To enter a new data set:
In the Search page, insert a new row, either by clicking on the "+" in the NavToolBar, or with a right click of the mouse. Enter the dataset id number and the dataset name. DO NOT POST and SAVE. Click on the Dataset tab on the left. You can now continue to edit this data set, using the information given in the DTS notes to make entries. As you go, it is a good idea to frequently Post and Save frequently. After the first Post and Save , you will see that the dataset has been entered in the Search page. You might want to enter all or most of the dataset ID in the box in the upper left of the Search page at this point. This ensures that you return to that data set after each Post and Save .
To edit a data set:
Click the mouse on a row, or use the arrow keys to select a
data set from the list returned from the data set search. The ID and Title
of the highlighted data set are displayed at the top of the window. These
fields will always display information on the data set you are working on,
no matter which tab has been selected.
Click on the Dataset tab to the left to view metadata
for the data set selected. Choose from a row of tabs along the top of the
frame for the different information. When editing in a text field, common
shortcut keys such as.Ctrl-C and Ctrl-V are available, as well as use of the
clipboard. A right mouse click within text fields will popup a menu with editing
shortcuts.
The following list summarizes navigation and editing keystrokes:
- Use Tab, Shift+Tab, Up, Down, Left, and Right to move from one cell to
another in the table.
- Use Ctrl+Tab or Shift+Ctrl+Tab to move out of the table to the next or
previous component.
- Press Home or End to move to the first or last cells of the row and Ctrl+Home
or Ctrl+End to move to the top or bottom of the column.
- Begin typing to append to the value in the current cell, or use Ctrl+Enter
to place a text cursor in the cell. At this point, Left, Right, Home, and
End move within the current cell.
- Press Enter, Tab, or Shift+Tab to end editing in the cell. If the value
is invalid, a message will be displayed on the JdbStatusLabel or in an error
dialog, and the cell will remain in edit mode.
- Press Escape to cancel, leaving the cell's value as it was before you
began editing.
Row operations
To sort a Table by the values in a column, click that column's header.
To toggle between ascending and descending order, click the header again.
You can also right-click anywhere in the data of a Table to open a popup
menu of row operations. In addition to selecting a column to sort by, you
can return to the DataSet's original, unsorted order.
Newly inserted rows are appended at the
end of a DataSet. In "<unsorted>" order, a new row will "fly
away" to the end of the DataSet when you navigate off it or post it.
To insert a new row into a Table, use Ctrl+Ins. Columns that have default
values defined will contain those values and all other columns will be empty.
If you navigate off a row that has only blank or default values, it will be
discarded. To delete a row, use Ctrl+Del. You can also use the popup menu
to insert and delete rows.
The NavToolBar is used with the Table. NavToolBar automatically
detects and binds to the active component's DataSet. It can be used to navigate,
insert and delete rows, and save DataSet changes back to a server, and also
provides visual indications of editing status and row position
Date editing
The first mouse click in the Begin Date box moves the cursor into the box. Position the cursor to the beginning of the line, or the position you want for data entry, and click again. The Enter key will position the cursor to begin entering the data in the next End Date box. While in a date box, using the Esc key will refresh that entry to the original date. You will not be able to move the cursor out of the date box unless numbers are entered in each position, in an acceptable format.
Project view:
When clicking on the left Project tab, the project
that is viewed is the one associated with the selected data set. If more than one project
is associated with a data set, they will be listed on the Project Links page. Changing which of those links
is highlighted will change which project is viewed on the project page. Other projects can be chosen from the drop down
box, and viewed and/or edited, but if you click off the project tab then back onto the project tab, the project associated with the dataset will again be displayed.
To post, save, delete, update, add data, etc:
The navigation toolbar at the lower right of the application
window is the main control for saving, updating, refreshing, and navigating
the information stored in the database tables. It can be detached from the main application window and moved. To make it return to its original position at the lower right, click on the "X" in the upper right corner. The navigation toolbar's unassuming look belies
some very powerful features. It acts upon the table that has its "focus",
which is always displayed to the left in the status field. It is very important
to be aware of which table has the focus, especially before saving changes
to a table. It is possible to be editing on one page, while the toolbar has
the focus of fields which are on another page. To give focus to a the table
on a page you are viewing, click on a field. Tabs are differentiated by color as a visual reminder
that they connect to different tables in the database. Changes made to tables using the GUImaint must be saved to that table, i.e. while on that same tab.
Tabs with more than one table on the page will have different background colors for the fields of the different tables. Note that the Users & PIs tab has two different tables displayed on its page.
Changes made while editing the fields within one colored background must be saved while the fields within that color have the focus.
If at any time before saving changes to a table, you decide to discard your edits and revert
to the data in the database, click the Cancel button, and the
fields in the table with the focus will return to their original values.
Use the "Ditto" button to copy a row in order
to use it as a template for editing.
The new row will be inserted beneath the row you were duplicating. A new unique identifier will automatically be created for the new row.
|
|
|
status field |
|
|
|
|
|
|
|
navigation tool bar |
|
|
| |
|
Navigation toolbar buttons
|
|<
|
|
move to first row |
|
<
|
|
move to prior row |
|
>
|
|
move to next row |
|
>|
|
|
move to last row |
|
+
|
|
insert new row |
|
-
|
|
delete current row |
|
|
|
post changes to current row |
|
X
|
|
cancel changes to current row |
|
"
|
|
copy previous row |
|
|
|
save changes |
|
|
|
refresh data |
|
|
|
|
|
|
Common error message if you try to save more changes to a record without refreshing first. Solution? Refresh, make changes, post, save, refresh.
