![]() ![]() |
Natural Resources Canada | Earth Science Sector | Geological Survey of Canada
![]() ![]() |
GlobalDB System Release 3.7 |
GlobalDB System Site Map | Presentation | Requirements | Software and Scripts | Aliases | Using GShell | Using GQuery | Using Documentor
USING GSHELL
This page:
This page is fairly long and is not meant to be read like a novel. We suggest that you start GShell (or GShellBrowser if GShell does not work with your version of Windows) and open a sample database, in order to explore its several screens and controls as you read this page, switching between your browser and GShell/GShellBrowser itself.
ENTERING GSHELL
GShellADO, shortened here to GShell, and GShellBrowser are standalone applications designed especially for entering and editing (GShell) or simply browsing (GShellBrowser) data conforming to the GlobalDB schema. To use GShell or GShellBrowser, the user must have unpacked the GlobalDBSystem321 and Data321 as described in Software and Scripts, and configured at least one database alias as described in Defining database aliases. As it is explained in the presentation of the database schema (see Database description), the deposit group and deposit entities in particular have many detail tables defined. Because not all of them are used in all databases, the user may wish to customize GShell or GShellBrowser to show only the tables he or she plans to use; these preferences are stored in a file called gshell.iii where iii are the initials of the user. When the program is started, the user is asked to enter his/her initials and click the OK button; the corresponding preferences file can then be opened. Only then will the program's main form appear; a database is selected and operations begin. If the user does not enter initials or clicks the Cancel button, the program displays a message and stops. If a new set of initials is entered (first use of GShell or new user), a preferences file is automatically generated, set for all detail tables to be displayed. The user's initials are also stored in the REVWHO field of new and updated records and the REVDATE field is date-stamped for version tracking.
Once the user initials have been processed, the program asks (via a small dialog form) in which mode to start GShell. In the default Browse mode, GShell operates normally, except that data cannot be entered, deleted or changed; the combo boxes are not loaded from the lookup tables; also, many of the buttons and other data entry and edit controls will be greyed out. The Edit mode allows data entry and editing, all necessary combo boxes will be loaded and the screen controls will be active. GShellBrowser only operates in Browse mode, and will be used by most users of this Open File because it will run under Windows 7 and up (32 bit) as well as under older versions of the Windows operating system.
If the current mode of GShell operation is Browse, or if GShellBrowser is being used, this will be indicated at the bottom of the main form after "GShell - 3.7 ADO (3.21 - 2006-08-02)" as "BROWSE MODE ONLY". The only way to change mode if using GShell is to shut down and restart GShell.
Minor glitch: GShell/GShellBrowser main form size: The window that opens when either version of GShell is started may be too short to display the GShell version text along the bottom. There is no fix. You can be assured that for the current Open File this text reads: "GShell - 3.7 ADO (3.21 - 2006-08-02)" or "GShell - 3.7 ADO (3.21 - 2006-08-02) BROWSE MODE ONLY"
File allows one to Select a database or Exit the program.
Edit or Browse is used to select which type of entity to work with and to customize the tabbed page preferences (described below).
Tools has a menu item that allows a compiler using GShell to rebuild the 3 summary tables mentioned in the description of the database updates after updates. It is greyed out in Browse mode and in GShellBrowser.
Help is not yet fully implemented, but contains an About button.
A top panel with seven buttons replicates the options in the Edit or Browse menu, except for Customize Tab pages. When a database is open, its title, compilers, and other relevant information is displayed below the buttons panel.
CUSTOMIZING THE TABBED PAGES DISPLAY
The preferences file can be modified by clicking Customize Tab Pages in the Edit orBrowse menu, which will bring up the "Customize Tab Pages" form. On that form, the left list box shows all the available tabbed pages; the right list box shows the tabbed pages currently selected for display. The right list box shows the values of the preferences file when the form is called.
The Clear All button can be used to start with a clean slate. The desired pages are selected from the left box (a range is selected using the Shift key, individual selections are toggled with the Ctrl key) and the Add button moves the selected name(s) to the right box. To use a different order (than the default order), select and add each title one at a time. The Add All button selects and moves all titles. The Up and Down arrow buttons above the right box can be used to move a single selected line up or down. The page selection is done for each of Deposits and Deposit Groups, independently from one another. When the selections are made, press the Save button to write the preferences file and return control to the main form. This operation can be performed at any time during program execution by returning to the main form, and repeating the process.
Warning: the preferences file is a plain text file. Do not attempt to modify it with a text editor or word processor as this may prevent GShell from operating properly. This file is used with all GlobalDB databases on your system. It is user specific, not database specific.
Once the main form is showing, the user selects the database he/she wishes to work with. This is done by clicking Select Database in the File menu. A small form will appear, showing the aliases (see Defining database aliases) of the database(s) available to work with. Other aliases may exist for other applications on your system. Only those aliases starting with the string "Global" will show in this selection form.
After connecting with the database, the buttons on the top panel and the entity items under the Edit or Browse menu become active and the user can select an entity, either by clicking on the corresponding button or using the menu bar. The corresponding form module is built in the computer's memory. If in Browse mode, the user is asked if empty tab pages are to be displayed (a tab page would be empty if its underlying table did not have a single data record). If using GQueryBrowser a text box will pop up listing the tab pages which will not be displayed. Then, if in Edit mode, all the relevant combo boxes are populated from their corresponding lookup tables or from actual data; then the form comes up to the screen. On a fast computer, this takes but a few seconds. The main form of GShell is normally centered on the screen. It can be moved but not resized. All other forms come up centered on top of the main form and are modal. This means that only the top form (of GShell or GShellBrowser) is active at any one time; the underlying form can only be used once the top form has been closed. It is not possible to have two or more active module forms simultaneously. The deposit module form (or deposits form) will be used here to illustrate the main features of GShell. In several places in the text, we refer to record selection forms; their use is described in detail in the reference selection page.
For most of the WMGDP mineral deposit databases the Deposit module is the main module for storing information about the deposits themselves, with the exception of the Porphyry database, for which Deposit Group is the main module. When Deposit is selected from the Main form, the Deposit form opens. On the deposits form, several values are displayed against a colored background; these are managed directly by GShell and cannot be modified by the user (with two exceptions, described below). Values for DEPNO, RANK, REVWHO and REVDATE (see Database description) are automatically entered by the program and are not directly accessible; DEPNO and RANK are visible; REVWHO, REVDATE and RELDATE are not shown. The deposits form is divided horizontally in five sections top to bottom: 1) a top panel has a navigation bar, buttons for insertion and deletion of records(do not work in Browse modes), a record selection combo box (a text box with a little downward pointing triangle at the right edge), a Current Links speedbutton and a Close button to get back to the main form, 2) a names panel showing the country name, deposit name(s), group name(s) to which this deposit is linked and buttons to make or break the link between that deposit and a deposit group, 3) a larger panel with fields that make up the master table for the deposit, 4) a series of tabbed pages (the set and order of which is based on the preferences file of the current user), each one corresponding to a detail table for the deposit, and finally 5) a status bar. All this is described below. Please keep in mind that no deposit or deposit groups can be inserted or deleted, linked, or unlinked in Browse mode; only the navigation, deposit selection, the Current Links speed button, and close buttons are active. Limited editing is however possible, although pick lists will notbe loaded.
Starting from the left edge, a navigation bar displays deposit records by going to the first, prior, next and last record respectively; post (check mark) can be clicked to commit changes to the main record; cancel (X) can only be used to cancel some changes and is shown mostly for information.
Next is a cluster of four buttons:
Insert is used to create a new deposit record. GShell will generate a new value for DEPNO, one above the current highest value in the database. If there are no deposit records in the database, the user is prompted for a starting value for DEPNO (the default value is 1). A new record is created and immediately saved in the database; one can then enter data in the various fields and the detail tables (described below).
Delete is used to delete the deposit record currently displayed, together with all records in its detail tables; a confirmation message will be displayed before it actually happens. If that deposit record is connected to another entity such as deposit groups or mines, a warning message to that effect appears and the operation is cancelled. If the user still wishes to delete the deposit record, all the links listed in the warning message have to be removed by going to the relevant modules. Only then can the record be deleted (along with all of its detail tables). The Current Links speedbutton can be clicked to display all records connected to the current deposit master record.
Query is not yet implemented.
Report is not yet implemented.
To the right of the Insert/Delete/Query/Report buttons is a record selection combo box with five options:
All deposits is the default option. All records are visible and the navigation bar is used to move forward and backward in the database.
Go to DEPNO is useful if one knows the value of DEPNO for the desired record; a small box opens up, prompting for the value of DEPNO. GShell will move directly to that value (if it exists in the database) or remain on the same record.
Go to deposit name when clicked, opens a a record selection form, displaying the name(s) of all deposits in the database, in ascending alphabetical order. Since all names are shown, a record can be selected by of its names, if it has more than one. The selection is made by double-clicking on the selected name or by pressing the Select button. A tabbed index facilitates the navigation in the list of names.
Filter by NTS area when clicked, opens a a record selection form, displaying the NTS areas linked to all deposits in the database, in ascending alphabetical order. Usw the scroll bar to navigate to the NTS area. Since all NTS areas are shown, a record can be selected by any one of its NTS areas if it is on the edge or corner of an NTS tile. The selection is made by double-clicking on the selected NTS area or by pressing the Select button. When records are filtered by NTS area, a message to that effect is displayed in the rightmost panel of the form's status bar located at the base of the form.
Filter by province/state allows selection of records by province, territory or state. This option also opens a record selection form displaying the list of provinces/states present in the database for deposit records, together with the number of occurrences of each province/state name. The selection is made by single-clicking a name from the list and then pressing the Select button, or by double-clicking on the selected name. When records are filtered by province/state, a message to that effect is displayed in the rightmost panel of the form's status bar located at the base of the form.
Filter by country allows selection of records by country. This option also opens a record selection form displaying the list of countries present in the database for deposit records, together with the number of occurrences of each country name. The selection is made by single-clicking a country name from the list and then pressing the Select button, or by double-clicking on the selected country name. If several countries are to be used in the filter, select each country name while holding down the [Ctrl] key, then press the Select button. When records are filtered by country, a message to that effect is displayed in the rightmost panel of the form's status bar located at the base of the form.
Filter by continent allows selection of records by continent. This option also opens a record selection form displaying the list of continents present in the database for deposit records, together with the number of occurrences of each continent name. The selection is made by single-clicking a continent name from the list and then pressing the Select button, or by double-clicking on the selected continent name. When records are filtered by continent, a message to that effect is displayed in the rightmost panel of the form's status bar located at the base of the form.
Still going towards the right on the top panel comes the Current Links speedbutton (showing a chain icon). When clicked, it displays the number of master records connected to the current deposit record, along with their primary key values.
Last towards the right on the top panel is the Close button, which closes the deposit form and returns to the main form. All currently open records are saved if they have been modified, and then closed; the deposit form is destroyed and the computer memory it occupied is made available for other uses.
Immediately below the top panel is the names panel, which displays the country name of the current deposit and NTS area if it has one, its name(s) and the name(s) of deposit groups to which it is linked. The background color of these fields indicates that values cannot be entered or edited on that panel. The values are displayed for information only; these fields can be edited in the form's Tab Pages. To the right are two buttons used to make or break links between deposits and deposit groups. To link a deposit to a deposit group, click the Link button to open a record selection form which shows the name(s) of all deposit groups in the database. A deposit group is selected by double-clicking a name or by selecting a name and then clicking the Select button of the selection form. To break the link between a deposit and a deposit group, click the Unlink button to open a record selection form which shows the name(s) of all deposit groups in the database to which the current deposit is connected. A deposit group is selected by double-clicking a name or by selecting a name and clicking the Select button of the selection form. GShell inserts/deletes records in the dpdg junction table of the database. In order to prevent loss of information, junction tables such as dpdg should never be manipulated directly by the user (using MS-Access).
Underneath the top panel and the names panel are two large panels showing respectively the fields of the master deposit table (dpgeol), and a set of tabbed pages, each page corresponding to a detail table. Field DEPNO is shown against a colored background; its value is generated automatically by GShell and cannot be modified by the user. This field is the master key for a given deposit and all data tables related to this deposit are linked through its value, thus its importance. Values for DEPTYPE(S) are displayed for information only; the actual values can be entered/edited in one of the tabbed pages.
On the form are simple edit boxes, combo boxes and check boxes. In edit boxes, data entry and/or editing is done by positioning the cursor in a field and typing. Combo box lists are loaded from lookup tables, or directly with data values before the Deposits form is displayed on the screen (Lookup tables can be loaded and/or edited using the Lookup Tables module from the main form). For fields displayed in combo boxes, a value can be selected by dropping down the list (by clicking on the downward pointing triangle) and clicking on the selected value. Another approach is to start typing the desired value; the next available term in the list that matches what has been type is automatically brought up. If the combo box corresponds to a lookup table and a new value is typed in, GShell issues a message and asks if that new value should be added to the lookup table and combo box list; if the user agrees, the new value is added; otherwise, the cursor points back to the relevant combo box. In combo boxes loaded directly with data values, a new value will simply be added to the combo box list. All combo boxes in GShell (with very few exceptions such as those used by the top level of Host rocks) exhibit this same behavior. In check boxes, simply click the mouse button to change the value between checked and unchecked.
Near the middle of the form are fields for longitude and latitude. By entering the values in the degrees, minutes and seconds fields and tabbing (using the Tab key on the keyboard) from field to field, the value of the decimal degrees of longitude and latitude will automatically be (re)calculated. If the values of longitude and latitude are only available in decimal degrees, they can be entered directly in their respective colored text boxes and tabbing will automatically trigger the calculation of degrees, minutes and seconds. This is the only instance in GShell where data can be entered in colored text boxes in any module. NOTE: if tabbing is not used to move from field to field, the user should click the mouse in any other data field in the longitude or latitude fields BEFORE moving to another deposit record to insure that the calculation is triggered; otherwise, it may be that the degrees, minutes and seconds values for location do not match the decimal degrees values. At the very right of that row of fields, a small combo box shows whether the location was entered to the neareast degree, minute or second. The checkbox indicates whether the location was calculated from the known location of the nearest community. When checked, indicates that the longitude and latitude were calculated from an approximate location and not quoted from a reference or determined using GIS.
Detail table data can be displayed by selecting the tab corresponding to the desired table. The number of tabbed pages and their order can be controlled by the user, as shown earlier on this page (see Customizing the tabbed pages display). If all tabs are not visible on the screen, the left-right buttons at the right of the tabs will scroll the bottom part of the screen left and right and the tab pages will apear. Clicking on one of these buttons and moving your cursor to the left horizontally may do the same thing.
Tabbed pages show one of seven layout styles, represented by the Names, Country Rocks, Geological Age, References, Alteration Signature, Radiometric Age and General Shape pages:
The Names page style (which is also used for Country/Province, Commodities, Mineralogy, Mineralization Style, Tectonic Structure, Deposit Type, Deposit Status and Tectonic Setting pages, as well as the Protolith and Lithology sub-pages of the Country Rocks, the Protolith, External Form, Internal Structure and Lithology sub-pages of the Host Rocks page and the Lithology sub-page of the Related Igneous Rocks page) has a large area in which a group of fields is displayed (in one or several lines) for each detail record that belongs to the current deposit. The first of these fields is RANK (read-only); the other fields are presented in text boxes, combo boxes or check boxes. Placing the cursor in any empty field of an empty record creates a new detail record, automatically inserting the deposit number and rank. However, the preferred method for adding detail records is to use the button cluster on the right side of the page (see The button cluster). If more records exist than can be displayed all at once, the scroll bar to the right of the data fields can be used to bring them into view. On those pages where a single record is displayed at a time, the scroll bar is replaced by two navigation buttons in the button cluster.
The read-only checkbox near the RANK field of the Mineralogy page indicates whether or not a Radiometric Age detail record points to the current detail record (see the Radiometric Age page description below).
The Deposit Type page also has a Link/Unlink reference button and displays (in read-only mode) the reference number, year of publication, title and authors of the linked reference record.
The Country Rocks page style (which is also used for Host Rocks and Related Igneous Rocks pages) shows one record at a time on its upper half and has its own tabbed page(s) for sub-detail table(s). Record insertion, deletion and scrolling is done with the button cluster to the right of the data fields. The bottom half of the page shows additional tabbed pages. Records shown in those tabbed pages are sub-detail records of the Country Rocks (Host Rocks or Related Igneous Rocks) detail record shown in the upper half of the page.
On the Host Rocks page, the content of the HOST ROCK combo box is determined by the value selected in the CATEGORY combo box. A slight delay might be experienced while the HOST ROCK combo box is reloaded, but this makes the list of values much smaller and easier to use. The same behavior is found in the Related Igneous Rocks page, with fields CATEGORY and RIGNEOUS.
The read-only checkbox near the RANK field of the Country Rocks, Host Rocks and Related Igneous Rocks pages indicates whether or not a Radiometric Age detail record points to the current detail record (see the Radiometric Age page description below).
The Geological Age page style displays a single record at a time. Record insertion, deletion and scrolling is done with the button cluster to the right of the data fields. To facilitate entry of the data and minimize the risk of errors, a frame at the lower right hand corner of the page with two combo boxes is used to select a starting and ending age and qualifier. The data fields are filled automatically. No data should be typed directly into the combo boxes.
The References page style displays the year of publication, the author(s) and the title of connected references in its upper half and details about the relationship between the deposit and currently highlighted reference in it lower half. The connected reference extracts are read-only values (against a colored background), displayed from an live SQL query into the database. References to link to the deposit record are selected using the Link (which calls the reference selection form), and Unlink buttons. The lower half of the page is in the Names page style, with a large number of check boxes instead of text boxes. The check boxes allow the compiler to indicate what topics were found in the currently selected reference shown in the upper half of the reference tab page. A record that has just been linked will by default be the current record. Clicking the mouse just outside any field in the upper half of the page will make a frame appear around a reference record, making it the current record. Record insertion, deletion and scrolling is done with the button cluster to the right of the data fields.
The Alteration Signature page style (which is also used for Coincident Features and Metallic Signature pages) looks like the Names page in its upper part. The data grid in the bottom part of the page shows Mineralization Style record(s) connected to the current record. The Link button is used to link those records: a selection form pops up from which the relevant record (if any) can be selected. The Unlink button can be used to unlink a linked record.
The read-only checkbox near the RANK field of the Alteration Signature and Metallic Signature pages indicates whether or not a Radiometric Age detail record points to the current detail record (see the Radiometric Age page description below).
The Radiometric Age page style looks like the Names page, but displays a single record at a time. Record insertion, deletion and scrolling is done with the button cluster. Two Link/Unlink buttons make this page different.
Next to the RANK value is a combo box for OBJDATED, used to indicate what has been dated: alteration, country rocks, host rocks, etc. If the object dated has its own record in the database, a link to it can be made by clicking the Link button (next to OBJRANK on the first row of controls); a selection form pops up from which the relevant record (if any) can be selected. If a link to an object dated is already present, the button can be clicked to unlink the record. When such a link is established, a read-only checkbox will appear checked on the corresponding object page, near the RANK field.
The second button links or unlinks a reference record directly to the record. Each age determination in the database should come from a single published reference. If the REFNO field is empty, the button's caption is Link and when clicked, a reference selection form pops up and a reference can be selected in one of several ways (see the reference selection page for details). If the REFNO field is not empty, the button's caption is Unlink and when clicked, the REFNO field is cleared.
The General Shape page style borrows from the Names page and from the References page. Both the upper and lower halves can display several records. Below the dividing line, records from the Dimensions of the currently selected General Shape record are displayed.
Field RANK (combined with DEPNO, the deposit number) is used to uniquely identify detail records. In some instances, it is also used to indicate record order of significance. On the status bar at the bottom of the form, the second and third panel indicate if the detail (and possibly sub-detail) table records are ordered or not.
The button cluster found on detail and sub-detail pages is made of a navigation bar, a Renumber button, an Up and a Down button. The navigation bar has either 3 or 5 buttons, depending on the context:
The Prior button (left pointing triangle) moves back one record in the detail table on those forms where a single record is shown at a time (such as the Radiometric Age page).
The Next button (right pointing triangle) moves forward one record in the detail table on those forms where a single record is shown at a time (such as the Radiometric Age page).
The Insert Record button (plus sign) inserts a new record in a detail table. Values for the two-element key (DEPNO and RANK) are automatically generated by GShell. If the record has its own sub-detail records (Country Rocks, Host Rocks, Related Igneous Rocks, Reference Details or General Shape), GShell will automatically generate the three-element key (DEPNO, RANK of parent record and RANK of the sub-detail record) for the new sub-detail record.
The Delete Record button (minus sign) deletes the current record from a detail table. GShell asks for confirmation before proceeding. If the record has its own sub-detail records (Country Rocks, Host Rocks, Related Igneous Rocks, Reference Details or General Shape), those sub-detail records are also automatically deleted.
The Post Changes button (check mark) registers the changes to the database. If this is not checked before leaving the form, the record is saved. If the changes are made to an already existing record, pressing the ESCAPE key will cancel those changes. If a new record was just inserted and is not wanted, it is best to click the Post Changes button to complete the operation, then click the Delete Record button to remove it.
The Up button is used to move a detail record up within a group. The currently selected record (by clicking on it) is moved up one position at a time. This does not affect values of RANK, even if there is a gap in the sequence. RANK can be renumbered using the Renumber button.
The Down button is used to move a detail record down within a group. The currently selected record (by clicking on it) is moved down one position at a time. RANK can be renumbered using the Renumber button.
If the RANK value of a detail or sub-detail record changes by using the Up, Down or Renumber buttons, and that record is linked to other records (such as References, Radiometric Age or between Metallic Signature and Mineralization Style, etc), the links will automatically be adjusted by GShell. As stated earlier, it is best to leave the management of junction tables and key values to GShell; adjusting those values directly in MS-Access could cause the loss of those linkages.
We have noticed that if a detail record RANK value is changed, that change is shown on the screen but not for the visible sub-detail records. The screen refresh can be made by clicking to another tabbed page, then coming back to the one of interest. This annoyance may be addressed in a future version of GShell.
The status bar along the bottom of the form is divided in four panels. From left to right:
the first panel provides help about various controls on the form,
the second panel indicates if the RANK value of a detail table shows record ordering,
the third panel indicates if the RANK value of a sub-detail table shows record ordering,
the fourth panel indicates if browsing through records is restricted by a filter.
The deposit groups form looks and behaves very much like the deposits form described above, with two exceptions. The first one is on the names panel. Since a deposit group might have many deposits connected to it, it would not be practical to concatenate all these deposit names and try to fit that long string in a short text box. Instead, clicking on the deposits Display button at the extreme right of the panel shows a list of all names of connected deposits. The other buttons are used to link or unlink deposits from the current deposit group. The other exception is that there is no Mineralization Style tab page; the Alteration Signature, Coincident Features and Metallic Signature pages do not have a Mineralization Style data grid as they do in the Deposits form.
The mines form behaves like the deposits form described above. The current mine can be linked to deposits (but not to deposit groups, see Database description) and all the names of those deposits as displayed on the names panel. The record selection combo box allows selection by mine name or by deposit name. The mines master table has three detail tables, used for storing information on Owner(s) and Operator(s) and for details about the relationship between the reference and the mine information. The Reference tab page, used for linking a single reference, looks like the deposits Reference page. Several reference detail records can point to that single reference.
The production form follows the same general layout as the deposit form. It has six tab pages: Link to Deposit Groups, Link to Deposits, Link to Mines, Production Grades, Production Weights and Reference. The top panel record selection combo box has options to show all records, go directly to a record whose PRODNO value is known, or select records by name of deposit group, deposit or mine to which the current record is linked. The names panel shows three read-only combo boxes; these are not used to make choices but to display all the names of deposit groups (DG), deposits (DP) or mines (MN) linked to the current record. The combo box type of control was chosen in order to save space on the screen.
The first three tab pages are used to link the current production record to deposit groups, deposits or mines respectively. Clicking on the Link button will bring up a record selection form from which the proper deposit group, deposit or mine entity can be selected. Breaking a link is made by clicking the Unlink button, which displays the list of entities to which the current production or resource record is linked. Select the appropriate record to complete the operation. Within each of three Link to... pages, the navigation bar moves the cursor through the linked entities, and the current key value (for the linked entity indicated by the cursor) is displayed in a read-only colored text box beneath the grid. The next two boxes to the right are used to enter a percentage value and the initials of the person who assigned that value. The percentage value indicates how much of the production figure is allocated to each entity (deposit group, deposit or mine). The sub-total text box displays the sum of the percentage values. Those percentage values are displayed with the names in the names panel combo boxes.
Private companies and authors of the assesment reports used in data sources may be the only parties who actually know for sure how their figures should be allocated to individual entries. For our purposes, it is most essential that the percentages allocated for each figure total 100.0%. Improved accuracy may be attained in future revisions of the data.
The Production Grades and Production Weights pages behave like the Names page of the deposits form. The Reference page, used for linking a single reference, is like the deposits Reference page. Each production record is normally built from a single reference, and information about the relationship between the reference and record, such as page number, can be entered in the reference sub-detail table.
It is advisable to link the production record only to the most specific entity to which it applies, ideally a mine. However, production figures are seldom presented mine-by-mine; they are often presented as lump figures for one or more deposits, or even a deposit group plus some unrelated deposits.
The resource form looks and feels very much like the Production form described above. In its main record area, it has two Link/Unlink buttons; in the lower part, the form has seven tab pages: Link to Deposit Groups, Link to Deposits, Link to Mines, Resource Grades, Resource Cutoff Grades, Resource Weights and Reference. These tab pages work like those of the Production form.
A resource record may be entered to describe a concentrated pocket of mineralization within another one. This is defined as a resource within a resource. These resource records can be linked to one another by clicking the CONTAINED Link button, which brings up a form from which a resource record can be selected; the check box (read-only) will be checked accordingly. The link can be removed by clicking the CONTAINED Unlink button.
A new resource record may be entered to describe a mineralized zone adjacent to another one. This is defined as a resource added to a resource. These resource records can be linked to one another by clicking the ADDED TO Link button, which brings up a form from which a resource record can be selected; the check box (read-only) will be checked accordingly. The link can be removed by clicking the ADDED TO Unlink button.
As with production records, it is advisable to link resource records to the most specific targets/entities possible. Other associations used in queries and filters can be obtained from the mine-deposit and deposit-deposit group junction tables.
On its top panel, the references form shows the same "tools" as the other forms described above. The record selection combo box has three options: All references, Go to REFNO to display a reference record whose number is known and Find by title or first author which calls the reference selection form. The next panel contains the main fields of data for a reference: the publication date, title and source type (SRCTP). Field SRCTP (which is read-only but displays the current value from the database) can have one of eight values; it indicates what type of reference is recorded, such as a journal article, a map or a digital file. Each will have a different selection of additional descriptive fields relevant to its citation. The PREVIEW combo box is used to specify what kind of reference is being coded; the bottom panel of the form reflects that choice by showing the relevant fields. In the middle of the screen, on the left is a rarely used group of checkboxes that indicates what broad category of data, at the module level in the database schema, is found in the reference. On the right is the list of authors, with the field RANK indicating author order.
On the lookup tables form, compilers can enter or edit the lists of values that will fill the combo boxes on the forms described above. Some of the lookup tables are read-only but can still be displayed. The upper grid is the list of lookup tables and their current description (see Using Documentor) and is read-only; the bottom grid shows the current content of the lookup table pointed to in the upper grid field by field. The navigation bars are used to navigate in the tables; on the bottom of the form, the navigation bar is also used to insert and delete records in the lookup table, as long as it is not read-only.
GlobalDB System Site Map | Presentation | Requirements | Software and Scripts | Aliases | Using GShell | Using GQuery | Using Documentor
Important notices and disclaimers | 2014-09-26 |