Home

"user manual"

1. SPECIMEN refno acronym num suffix especimenno username eentry_date fieldno type_status no_specimens taxa_studied configuration fieldrefno colldnrno oldrefno cbfno FIELDNOTES fieldrefno year reference map_ref colldnrno ACQUISITION colldnrno collector collyear donor accnyear STORE refno colldnrno building room cabinet_drawer walletno FORMATION refno basin supergroup groupname subgroup formation member beds lithology remarks PREPARATION refno prepdate prepby coreno weight residue hell hf hcl2 Sg Oxy koh sieve vom slides code description samptype continuous lines show links between tables arrow head indicates a one to many relationship i e one record in one table links to many records in another Australian Geological Survey Organisation 1995 47 PALTABL2 WPD PALEO DATABASE USER S MANUAL
2. 5 Catalogue Reports Menu 22a n ne nnn nnn renee 5 Curatorial Reports Menu 22 2 nnn 6 SQL Plus n nnn nnn nn nnn nnn nnn nennnnenenenee G Forms for individual tables 6 Using the Forms __ n none nnn 8 INITENTRY amp PALENTRY Forms Menu Options 2 3 8 INITENTRY Forms Menu Option 2 12 PALENTRY Forms Menu Option 3 9 22 2 nnnnnnn nee 14 Forms Menu Option 8 Access to individual tables 17 ACQUISITION Tables Menu Option 2 17 AGE Tables Menu Option 3 anne I FORMATION Stratigraphy Tables Menu Option 4 18 IDENTIFICATION Tables Menu Option 5 18 LOCATION Tables Menu Option 6 9 18 MAPS Tables Menu Option 7 7 19 PUBLICATION Tables Menu Option 8 19 PUBLISHEDIN Citation details Tables Menu Option 9 20 SPECIES Tables Menu Option 10 0 20 STORAGE Tables Menu Option 11 21 SPECIMEN Tables Menu Option 12 9 22 FIELDNOTES access
3. 28 39 Editing the Report To fit relevant data on a label which will fit in a standard 5x7 cm tray more extensive formatting is required than for the previous Report but the principle is the same The base font is Helvetica 10pt The flag pairs for font changes to be attended to in this order are rjl rjO right justify the type status of the specimen ff1 ff0 put into fine font size Helvetica 5 8pt under WordPerfect 6 sf1 sf0 put into small font size Helvetica 7 7pt If1 1f0 put into large font size Helvetica 11 8 bf1 bf0 put in bold face Following that put the text in Newspaper Column format 3 columns per page adjusting margins and column separation to give a 60 mm text width and print A single label cut from a resulting A4 sheet will then look like this CPC 1011 Paratype Taeniothaerus teicherti COLEMAN 1957 Brachiopoda COLEMAN P J 31 8 1957 104 PI 17 fig 1 Carnarvon Basin Wandagee Formation Permian Artinskian Commonwealth Palasontological Collection Australian Gaological Survey Organisation CURATORIAL REPORTS MENU OPTIONS 5 amp 6 Palynological register Selected data for specified MFP numbers Designed specifically for palynomorphs these two Report programs do not require further formatting The first will provided a record of location preparation history and storage location for MFP registered samples the second is an abbreviated list of source and remarks on processing design
4. automatically alerts the palaeontological curator of execution of Option 4 see p 24 6 Foraminiferida A Form for constructing faunal lists of forams see pp 24 25 7 Conodonts As Option 6 but designed for conodonts see p 25 8 Access to individual tables This gives access to the Tables Menu see pp 17 22 from which Forms can be run for most of the individual tables 9 Palynological processing A Form used for keeping track of processing and location of palynological samples see p 26 10 Find location of specified holdings This View is designed for searching for the location of samples according to a variety of selection criteria see p 27 CATALOGUE REPORTS MENU The various report programs run under this menu are specifically designed to provide the raw data as appropriately formatted ASCI files for the assembly of taxonomically based CPC catalogues They are menu driven and require no further comment in this manual The Palaeontological Curator holds a short manual on the procedures involved in producing a catalogue 1 Exit to previous menu 2 Selected recorded species a list of all species in the database within a selected higher taxonomic category 3 Selected recorded specimens a list of CPC specimens and the taxonomic names attached to each selected the same way 4 Selected references all the references for the selected taxonomic group Catalogue the report program which assembl
5. for each field on the Form a brief message is displayed in the help line at the bottom of the screen as the cursor alights in that field This may be instructions on what data should go into that field or on what table is linked through that field Should an error occur the normal message line will be replaced by a brief error message Press lt Alt FI gt display error to try and find out what has gone wrong More generally lt Esc h gt will display a help screen where one is available INITENTRY amp PALENTRY FORMS MENU OPTIONS 2 3 Field sample and specimen data The Forms INITENTRY for initial sample data entry and PALENTRY for full specimen data entry are composites of selected fields from several tables all fitted respectively on one or two screens The Form JNITENTRY is designed for the entry and display of sample and laboratory data of relatively limited scope while PALENTRY is designed for the entry of more extensive data especially for published specimens As the procedures for using the two Forms are essentially the same those will be dealt with for both before discussing aspects of the individual Forms In both only a single record can be entered while staying within the Form but access to appropriate individual Forms is easy and enables entry of series of records Similarly only one record can be displayed at a time but multiple records retrieved following a query can be easily and quickly examined by usi
6. it must be instructed to save the result of a retrieval to a named file for subsequent handling Before entering and executing each query gt Enter spool filename quoting the name of the file you wish to hold the result of the query When the query has been run gt Enter spool off the file filename lst will be generated in your home directory Repeat this procedure for each query using a different filename each time If you want to send the report to the Line Printer on the ground floor the alternative last command is spool out Otherwise the file can be transferred to your PC as an ASCII file see p 39 for examination at your convenience If you want to check that the files have been generated or what size they are you can use Unix commands but you must tell SQL Plus that you are referring to your working Se home directory Thus gt Enter host Is to obtain an abbreviated directory listing gt Enter host Is l to obtain an extended listing gt Enter host pg filename to display the file filename a screen at a time scroll through it with lt Page Down gt quit with q Australian Geological Survey Organisation 1995 38 PALEO DATABASE USER S MANUAL TRANSFERRING FILES To transfer any files you have generated in your AVON home directory either by running Report programs or from SQL Plus you must first quit both PALEO and the AViiON then log in again either through the LAN Workplace window or from D
7. The first block is a view of the SPECIMEN table see pp 8 10 15 16 for comments on the individual fields This block gives access to the full Form in the normal way with lt Alt F3 gt The only new field is CBF No which is a cross reference to Clinton Foster s personal numbering system Under prefix acronym the default is MFP and appears automatically except in Query Mode As with all composite Forms this one can only be queried from within this first block The second block is a view of the LOCATION table and gives access to the full Form Special requirements for some fields are discussed in the context of the ZINITENTRY and PALENTRY Forms pp 9 10 13 16 The default entry in the field country ocean is Australia The third block deals with various preparation processes and from it lt Alt F3 gt gives access to a SAMPLE PREPARATION Form This can display up to four sets of data from the PREPARATION table andis designed for entering multiple records see the discussion of INJTENTRY and PALENTRY on p 11 for the way in which this system works The fields are either very straightforward or as listed below very specific samp type records the type of sample being processed OC outcrop DRE dredge COR core SWC side wall core CUT cuttings core No specifies the core number within a well it is a numeric field sample weight is the weight in grams of the sample to be processed residue requires simply Y
8. This is designed to provide all the data that normally appear on a CPC registration sheet in an ASCII file cpcrecs lis written to your AViiON home directory It is intended particularly to provide hard copy for semi archival storage for CPC registrations done directly into the computer without use of registration forms or for records which have been considerably updated If you register CPC specimens directly perhaps using Forms Menu Option 4 itis very important that this Report Program be run and the resulting properly formatted and printed hard copy be handed to the Palaeontological Curator Running the Report program When you access this Option you will be offered three choices select records by user name and entry date select records by a range of CPC numbers exit Australian Geological Survey Organisation 1995 28 PALEO DATABASE USER S MANUAL ee2eeoeee0e80000089800008080 806080808808 880880808 6 If you choose selection by user name entry date you will be asked to enter them both If you do not know them exit and move to the Forms Menu PALENTRY option and retrieve them they are the fields username and entrydate in the box at the top right corner of the Form and are fields in the SPECIMEN table Then start again username is the PALEO login name e g jbloggs entry_date is the date on which the data in the SPECIMEN table were committed and should take the standard form for example 20 MAR 93 If you c
9. a record in a table with a key field such as Specimen you are likely to get a message saying that you must delete the record in other linked tables first In that case note down what you are trying to delete exit the Form with lt Alt F10 gt answer No when asked if you want to commit the changes See the next item then search and delete using an appropriate Forms option e g PALENTRY see pp 8 12 14 16 Truncated displays examining in full and editing Where the contents of a field cannot be fully displayed because of limited space it is possible to display the full field in a separate editing window with the advantage that the cursor up and down arrows work allowing quick movement through lengthy text gt Press lt Esc e gt see Editing window When finished gt Press lt F10 gt Transaction committal 3 Please note that all transactions Le all new entries or changes to existing entries must be actively committed gt press lt F10 gt This can often be done for several successive records at a time In complex Forms however one should commit data for a single record before trying to move on to the next one otherwise it can be difficult to track what caused any error messages If you try to leave a Form without committing any changes you will first be asked whether or not you wish to commit This will happen even if you have changed your mind and have reinstated previous text Of course if you just
10. be entered in this field This Reference Number may be a field or Australian Geological Survey Organisation 1995 9 PALEO DATABASE USER S MANUAL sample number or the number under which a specimen is registered in one of several specific collections In the latter case the collection is referred to by its acronym e g MFP CPC F V Procedure gt If there is an acronym type it in the first field if not press lt Enter gt gt If an acronym has been entered enter the specimen number in the second field which is strictly a numeric field the database name for it is num Simple numeric sample numbers e g eight digit field numbers like 74284301 should be entered here gt If there is a suffix e g a part letter or number enter it in the third field suffix If using a number start it with a dash or slash i e or So that it is recognisably separate from the main number there is room for up to two digits gt If there are entries in the previous fields they will automatically be combined in the fourth field Refno If not a number must be entered here Composite sample numbers such as 20NG7251 which do not readily lend themselves to subdivision into acronym number can be successfully entered only here Field Number If the Reference Number is a field or locality number or alphanumeric code such as 20NG3124 or GEO367 then repeat it in the Field No field so that the record will be retrieved if a qu
11. field lt Esc i gt Move to next field lt Enter gt Move to previous field lt Ctrl h gt Move to next block lt Home gt Move to previous block lt End gt In the Forms INJTENTRY and PALENTRY lt Enter gt is programmed to allow the cursor to move forward through the whole view but the reverse has not been implemented lt Ctrl h gt will only work within the one block Moving between records Either as a result of retrieving several records with a Query or following entry of successive records without closing a Form it is possible to examine individual records Move forward 1 record lt l gt Move back 1 record lt t gt Moving between Forms From appropriate places in several Forms it is possible to move to a linked Form which may be a full version of a table abbreviated in the first Form or a lookup table From a specific field or block in the initial Form lt Alt F3 gt next primary key will place the cursor in a designated field within the linked form With appropriate programming a linked Form will query the database so as to display data from the initial form From this point a whole series of records for that table can be entered using the Duplication facility see p 47 Return to the initial Form with lt Alt F10 gt When you enter a lookup table you are immediately placed in Query Mode see below This fact will be advised in the message line at the bottom of the screen It is then possi
12. from PALENTRY SPECIMEN 22 ECOLOGY access from INITENTRY PALENTRY SPECIMEN 22 CPC ALLOCATION Forms Menu Options 4 5 23 FORAMINIFERIDA Forms Menu Option6 9 24 CONODONTS Forms Menu Option7 25 PALYNOLOGICAL PROCESSING Forms Menu Option 9 26 FIND LOCATION OF SPECIFIED HOLDINGS Forms Menu Option 10 27 Reports m 28 Using SQL Plus _ _ 34 Transferring Files 39 Appendices 1 Passwords 40 2 Oracle Commands Procedures amp Keystrokes 41 3 List of PALEO tables and fields 47 Australian Geological Survey Organisation 1995 i PALEO DATABASE USER S MANUAL INTRODUCTION The PALEO database is a sample oriented palaeontological database which is capable of storing data covering a wide variety of taxonomic biostratigraphic curatorial and technical requirements The database is relational operating on the AGSO s computer network under the ORACLE Database Management System Because of its wide scope it is a powerful tool for both research and curation but pays an inevitable price in associated co
13. gt Carefully enter the following command line where the appropriate words are substituted for your username and new password DO NOT type the semi colon or press lt Enter gt until you are sure you have the command right go to errors with the cursor keys and lt Backspace gt if necessary then overtype the text with the correct words DO NOT USE lt Delete gt orant connect to your username identified by new password see Grant succeeded gt Enter exit see Main menu If having established a password it happens that you forget it ask the system administrator AViiON or Oracle as appropriate for help The administrator will reset your password to the initial password and you start again Zt pays to have a password which while not easy for someone else to guess is nevertheless one you can easily remember Random character groups may be difficult to guess but are just as difficult to remember Australian Geological Survey Organisation 1995 40 PALEO DATABASE USER S MANUAL APPENDIX 2 ORACLE COMMANDS PROCEDURES amp KEYSTROKES In a relational database the data are held in a number of tables each item being stored in a cell or field at the intersection of a row and a column Tables are linked by common or key fields A sample or specimen record comprises the data held in one or several tables There are two ways to work with the data One is by using Oracle s command language called SQL Plus the other is t
14. or press lt Alt F10 gt cancel do not try to enter a new record until that is done or you will receive a message Function not available when you try to commit the record and you will have to start again In multi block Forms there are often restrictions on what information can be retrieved in various parts of the Form This has been discussed in the context of those Forms Wildcards in Queries When a query is executed the system unless told otherwise looks for a precise match for the total contents of each field in which you have typed text Queries are therefore case sensitive remember that fact when you are entering new data and if the field contains additional text it will not be retrieved To avoid this problem to save time typing a long string of text to be found and in many cases to limit the number of records retrieved to a manageable number two specific wildcards can be used either separately or in combination the underline key on the keyboard will retrieve records which have any character or digit in that specific position It can be used in multiple but remember if there is nothing in a particular position other than a space between two words the record will not be retrieved the percent key on the keyboard is more general standing for any combination of letters or digits It tells the database that it wants any record with a specified string of text within the field no matter what el
15. they are detailed are 1 Exit to previous menu 2 Run the acquisition form p 17 A view of all fields in the ACQUISITION table recording when and by whom samples were collected amp or donated 3 Run the age form p 17 All fields in the AGE table Australian Geological Survey Organisation 1995 6 PALEO DATABASE USER S MANUAL eeeeaeevoeoenvevnoseevoevseuevueaendenaeeeneeeneeeaeaeaeoeaeaeee50e se n E E S EE E E E E E D D D E O O O O O O O O O O O eee ee ee 4 Run the formation form p 18 All fields in the FORMATION table i e geological provenance 5 Run the identification form p 18 All fields in the IDENTIFICATION table in which faunal lists can be assembled with the assistance of the SPECIES table 6 Run the location form p 18 All fields in the LOCATION table i e geographic provenance 7 Run the map form p 19 All fields in the MAP table map name code scale etc 8 Run the publication form p 19 All fields in the PUBLICATION table ie bibliographic data for any publication in which a registered sample is cited 9 Run the publishedin form p 20 All fields in the PUBLISHEDIN table i e details of where in a publication a sample or specimen is cited amp or illustrated 10 Run the species form pp 20 21 All fields in the SPECIES table i e the name and authorship of a taxon plus its systematic position and any comments on synonymy etc 1
16. username ogin of the person who logged in to PALEO to enter the record If a number is displayed in collector donor number from which the ACQUISITION Form can be reached so also are the associated data collector donor dates of collection or acquisition FIELDNOTES access from within PALENTRY SPECIMEN FIELD NOTES eat 3 K Reference Reference Field refro t Reference Field vefno lii Reference Field refno lii Reference Field refno fs Reference Field refno oper Collector DBonor Ho Collector Donar No lt Replace gt Asix record display of references to such things as field notebooks air photos unpublished Records etc Anentry in Fieldrefno is mandatory before data can be entered it can be an alphanumeric not just a number The other fields are fairly obvious ECOLOGY access from within INITENTRY PALENTRY SPECIMEN This Form cannot be reached directly from the Tables Menu as the ECOL OGY table was designed as an adjunct to the SPECIMEN table A Form specifically for recording the statistical data associated with environmental assessment of foraminiferal samples some fields have obvious functions those which do not being Australian Geological Survey Organisation 1995 22 Registered number ECOLOGY BLGCL7 B50 foram types Cz in sampled T 3 E B number of forams in the sanple a taxa narine grab sample number of Live forans salinity lt ppm gt PT UP
17. where clause Note the use of single quotation marks to define text to be inserted or matched but not numbers Note that all sets of brackets must close so a complex command may finish with several D Because the command is long it has been divided into sections each on a single line finish each line with lt Enter gt the line numbers are added automatically and do not form part of the command itself If you do not want to replace any existing data then as part of the where clause include a selection criterion that restricts selection to those records where the specified field is empty in the form and fieldname is null Australian Geological Survey Organisation 1995 35 PALEO DATABASE USER S MANUAL If you are uncertain it would be wise to check that the records to be retrieved are just those you want by querying as you intend but substituting select for update If only the desired records are retrieved then proceed with the update otherwise rethink the selection criteria It should be clear from this that SQL Plus cannot be used simply to add text to a field which already contains some That has to be done either under Forms Mode or if the existing text is common to several records by replacing the former text with the full old new text Wildcards As in Forms Mode wildcards can be used in SQL Plus see p 45 However their use does make the wording of that part of the command string slightly differ
18. will now find himself back at his starting point either in the LAN Netware utilities menu or in the Windows Program Manager screen Australian Geological Survey Organisation 1995 3 PALEO DATABASE USER S MANUAL ORACLE MENU SYSTEM MAIN MENU CATALOGUE REPORTS FORMS MENU CURATORIAL REPORTS FORMS FOR INDIVIDUAL TABLES Access to the many PALEO systems reports etc is by way of a series of menus which you will automatically enter once you have logged into the database The Main Menu gives access to nested menus for using Oracle forms two Report menus and the SQL Plus program For all menus you select an option either by using the cursor keys to highlight it or by typing its number In each Menu the invariable first option the default selection on opening the menu is to exit that menu Possible actions are gt Activate the selection with lt Enter gt gt Return to a previous menu or in the Main Menu to the operating system by selecting Option 1 gt Leave PALEO directly with lt Alt F10 gt MAIN MENU The Main Menu is AGSO PALAEONTOLOGICAL COLLECTIONS portrayed at right Note AETH NENG that in this case Option 1 takes you completely out of w AAEE PALEO The other options Curatorial reports Use SQL P lus provide access to three other menus and one x program SQL Plus Enter your choice OOO PALEO database 1 Exit 2 Forms menu for data entry and retrieval the normal select
19. 1 Run the storage form pp 20 21 All fields in the STORE table i e where a sample or specimen is normally kept 12 Run the specimen form p 22 All fields in the SPECIMEN table i e sample specimen specific data e g preservation data reliability and history taxonomic status The key form in registering a sample or specimen this also gives access to several tables FIELDNOTES p 22 ACQUISITION and ECOLOGY pp 22 23 It is also designed to give access to the RADIOMETRY table yet to be set up dealing with radiometric age determinations 13 Run the corlo form This is essentially of curatorial interest holding information requiring cleaning because it was not cleanly transferred from an earlier version of PALEO operating under the Image system on an HP1100 computer Explanation is unnecessary 14 Run the ocnlo form As for Option 13 Australian Geological Survey Organisation 1995 7 PALEO DATABASE USER S MANUAL USING THE FORMS In this section the use of the various Forms available for data entry and retrieval will be described Access to these Forms is from Option 2 of the Main Menu and from Option 8 of the Forms Menu see pp 5 6 Keystrokes and commands other than very special ones will not be explained here but in Appendix 2 Oracle Commands Procedures amp Keystrokes pp 41 46 Help line error messages A general aspect of Forms applicable in nearly all of the PALEO ones is that
20. AUSTRALIAN GEOLOGICAL SURVEY ORGANISATION PALEO DATABASE MANUAL FOR DATA ENTRY MODIFICATION AND DISPLAY Record 1995 16 D L Strusz and S L Lenz AUSTRALIAN GEOLOGICAL SURVEY ORGANISATION HLT DEPARTMENT OF PRIMARY INDUSTRIES AND ENERGY Minister for Resources Hon David Beddall MP Secretary Greg Taylor AUSTRALIAN GEOLOGICAL SURVEY ORGANISATION Executive Director Harvey Jacka Commonwealth of Australia 1994 ISSN 1039 0073 ISBN 0 642 22328 9 This work is copyright Apart from any fair dealings for the purposes of study research criticism or review as permitted under the Copyright Act 1968 no part may be reproduced by any process without written permission Copyright is the responsibility of the Executive Director Australian Geological Survey Organisation Requests and inquiries concerning reproduction and rights should be directed to the Principal Information Officer Australian Geological Survey Organisation GPO Box 378 Canberra City ACT 2601 O O O a O a O O O O O a O e O O e O O O O O e O O e O ee 8 8 CONTENTS Introduction e Login Procedures 2 Logout Procedures 3 Oracle menu system 2 4 Main Menu 2 n nanan nnn nnn nnn nnn nnn nnn nnnen 4 Forms Menu for data entry and retrieval
21. Alt F4 gt lt Alt F6 gt lt Alt F7 gt lt Alt F8 gt lt Alt F9 gt lt Alt F10 gt lt Tab gt lt Enter gt lt Backspace gt lt gt amp lt gt lt l gt amp lt l gt lt Home gt lt Insert gt lt End gt lt Page Up gt lt Page Down gt lt Ctrl A gt lt Ctri B gt lt Ctrl F gt lt Ctrl H gt lt Esc E gt lt Esc G gt lt Esc H gt lt Esc I gt lt Esc T gt Australian Geological Survey Organisation 1995 show keys i e list available key definitions and functions select duplicate field duplicate record insert record enter query execute query list commit transaction also accept display error displays the program command which caused the error with some indication of just what the error was count query hits i e how many records will be retrieved by a query you are about to execute This gives you the chance to decide whether to add to the selection criteria so as to restrict the number retrieved Run before pressing the execute query key next primary key clear record i e remove the displayed data for that record only in the Form in use The display is cleared but the data are not destroyed delete record the record will be destroyed once the transaction is committed clear form and rollback the former option clears all displayed data from a form not just one record the second option if used befor
22. HINZ 1994 The different generic name will make it a new taxon anyway but this sets out the history of authorship clearly and succinctly Of course a note under remarks for both taxa would be even more helpful Abbreviate the authorship only if absolutely necessary Start by judicious deletion of spaces then use very well known standard abbreviations e g Linn as a last resort use et al Unique index The Species Number is applied to a unique combination of data in the fields Genus Subgenus Species Subspecies Species author and Conodont element A single character difference in any one of these fields is enough for a new record This makes careful spelling and the positioning of commas and spaces in the Author field very important STORAGE TABLES MENU OPTION 11 Designed to record where a specimen or sample is stored the Form will display three records at once For consistency fields should be filled in as follows Building Repository and AGSO old records will show BMR are the normal entries Room Vault Room nnn are the non AAAS Cabinet Drawer For ie e Cahinet Draver Hicropal Box the present Repository com ME ee ae pactus enter in the form e g ane ne B1L4 ie run B compactus area i Date neen BN 1 left side 4th drawer down a Micropal Box The number of the box in which micropalaeontological resi dues are stored mostly forams Other area Unusua
23. If you cannot find a duplicate record this way then press lt F7 gt enter query you will be asked if you want to commit the changes you have made gt Press lt n gt for no gt Type the sample or specimen number in the appropriate place and press lt F8 gt gt Check the result of your query You may find the displayed data show some differences although this may only be a matter of wording Make any necessary corrections or additions don t assume the data you originally tried to enter is better and press lt F10 gt If it is a case of identical numbers for different samples or specimens then the answer to your problem lies outside the database DATA ENTRY multiple samples If you have a series of samples to enter which share common data e g they come from closely spaced intervals on a measured section have the same age etc then the first record can act as a template for the others using Record duplication see p 46 However you cannot do this within the confines of the single composite Form but one way or another must go to the linked individual Forms Australian Geological Survey Organisation 1995 11 PALEO DATABASE USER S MANUAL Procedure gt Commit the first record and return the cursor to the first part of the Form gt Press lt Alt F3 gt to go to the SPECIMEN Form See the data already entered for the first record automatically displayed gt Press lt F6 F4 gt create record d
24. No the map identifier e g SF53 14 or 6551 depending on scale Remarks here can be noted the edition date of map or in the case of a map to 1 50 000 or 1 100 000 scale the 1 250 000 map within which it falls PUBLICATION TABLES MENU OPTION 8 Accessed in Query Mode the same comments aL 1956 apply as for ACQUISITION see p 17 this Form can display two records wie S C reer ance ee The individual fields LERET he pe lecypods Undulomya Cosmomya and Palaeocosmonya in the Permian of ix ee e India and Western flustralia ar EZIN MAJournal of the Geological Society of Australia vol 12 pt 2 pp 253 2 and peculi hes of their use toy a wablicoien dates Scroll to t entry Cif found auth So tt LC alioan a e cro o re correc entry L oun a E To carry the required data across exit this form with lt NEXT PRIMARY KEY gt Authors Everything To add a new record use CEXIT gt INSERT RECORD gt and finally lt COMMIT gt Press lt EXIT gt lt EXIT gt to quit this form 1S automatically capitalised multiple authorship should be in standard Reference List format e g DICKINS J M THOMAS G A amp JONES P J Use full first names only where considered essential to avoid ambiguity Date Because only the year may be known this field i is nota date field governed by strict rules but a character field Enter as much as is known but for ease of searching it is best to start with the yea
25. OS Y Y VY Y see Windows Double click the Rapid Filer icon Open a Remote System dialogue box Click on Remote Host Name box type av Click on the User Name box type your AVION username Click on the Password box type your AViiON password press lt Enter gt or click on Open a split window with the initial directory i above your AViiON home directory below Click on the upper window then bring down the File menu Select change directory then follow the menu to set up the directory to which you want to transfer any files execute by selecting Change Highlight the file to be copied Click on the Copy button Repeat if desired If desired while connected you can clean up your AViiON directory select files then select appropriate buttons e g Rename Delete Exit by selecting exit from the File menu MS DOS go to the network prompt e g M gt and enter ftp av When asked for the name of the host enter av Enter your AVON username and password when asked your home directory prompt i e av home3 Enter Is to see a listing of the files therein Enter get filename ext pathname where filename ext is the full name of the file you want to transfer and pathname is the full pathname drive directories and file name for the file when it is transferred The new file name does not have to be the same as the AVON one A statement on how many bytes were trans
26. Pi 1 fig 1 FORAM LABELS CURATORIAL REPORTS MENU OPTION 8 Designed to produce labels for unpublished foraminiferan slides this differs from Option 8 only in the style of the sample or specimen number no acronym is specified This however does impose limits on the way in which numbers are entered because of the way in which the computer orders alpha numeric fields Remember the computer first converts letters into numbers and then orders the numbers so produced The only safe way is to group number sets so that any alphabetic parts do not change within each set The output is a file forams2 lis Australian Geological Survey Organisation 1995 33 PALEO DATABASE USER S MANUAL USING SQL PLUS Complex operations generally cannot be performed with the database in Forms Mode but must rather be done either directly or indirectly using the SQL Plus language This is very useful in gathering together data from a number of tables generating reports and carrying out some forms of updating The full gamut will not be discussed here look to the manuals on SQL Plus or see the somewhat briefer discussion in AGSO Record 1993 81 However some relatively simple procedures which are most likely to be used are explained below Start SQL Plus gt Select Main Menu Option 5 see SQL Prod gt Leave SQL Plus gt Enter exit ESSENTIAL POINTS TO NOTE DO NOT USE lt Delete gt to correct errors use lt Backspace gt or si
27. S F ip etact RA RLA 4 GOL 7 8 foram types lt z in sanple gt T P s f number of forams in the sample all taxa marine grab sanple number of Live forams salinity number of taxa f and dead forans Sieve fraction p number of taxa and dead forans sieve fraction g lt Replace gt PALEO DATABASE USER S MANUAL 9 of textulariine foraminiferans 9 of milioline foraminiferans of rotaline foraminiferans 9 of planktic foraminiferans 9 of benthic foraminiferans number of taxa number of foraminiferan taxa in the sample sieve fraction the sieve size e g 125 which retained the sample we The Form is entered in Query Mode and automatically queries on the Refno entry that was displayed in the main Form from which it was accessed If no data can be retrieved for that entry then it must be separately entered in ECOLOGY before new data can be recorded against it CPC ALLOCATION FORMS MENU OPTIONS 4 amp 5 As an increasing amount of sample data are This form is for registering nev CPC numbers and E duplicating existing data for then entered when first obtained Enter the oia number acronym se art gt Fee ee it will become feasible when 4455 specimens from those samples are published to attach already entered data to new CPC numbers It is feasible to do this for one specimen at ASsaa ares eon A Maerua Mt Rae cra Se Sara ne CO a time using Query Mode and Ni
28. a locality description such as Beside entry gate to Smith s home paddock would be typed as Beside entry gate to Smith s home paddock UPDATING EXISTING RECORDS It is possible to update several records at once but only in one table at a time However the criteria for selecting which records are to be updated can involve other tables When updating you see only a statement after it has been done of how many records were affected If you are uncertain which records will be affected by your command try it first as a select after arranging to have the result written to a file see below If you are performing a long series of updates it is wise to commit what has already been done every now and again to guard against system failures etc enter commit All transactions will be committed automatically when you leave SQL Plus that should suffice for short sessions Two examples of updating commands are given below the second specific to CPC or similarly constructed numbers Update selecting records which match field s in the same table Update paleo tablename 2 set fieldname string fieldname string fieldname numerical field nnn a comma must separate successive clauses 3 where fieldname string nnn or and fieldname string nnn This will put into the specified fields the words or numbers specified for all records with field contents matching precisely those specified by the
29. ables SPECIMEN LOCATION FORMATION and AGE For each the original sample data will be displayed for you to check Any errors or omissions can be corrected and committed with lt F10 gt in that table for the original record Australian Geological Survey Organisation 1995 23 PALEO DATABASE USER S MANUAL gt Once you are satisfied press lt F4 gt duplicate record see each of the CPC numbers with the data attached as a succession of records for that table gt Scroll through the records and make any additions or alterations to the data for individual CPC specimens e g type status in Specimen gt Commit for that table with lt F10 gt gt Press lt Alt F10 gt You will then be taken to the next table where the same procedure can be followed After the fourth table you are returned to the initial screen Follow the instructions to either do another set or finish the program and return to the Forms Menu At this point it is important that you select Forms Menu Option 5 which is all you have to do This is a reporting program it was not possible to tag it on to the end of the program in Option 4 It advises the Database Owner currently the Palaeontological Curator through ccMail which CPC numbers have been allocated by whom and when When data on taxonomy and publication become available they are best added in the individual tables remember these data will be specific to the individual CPC specim
30. ange the oldest goes in the first field the youngest in the second Keep strictly to this it s important for querying Remember that time terms use Early not Lower etc and that using these modifiers at all has implications for data retrieval tactics zone Where possible include the generic name even if in abbreviated form If the possible age covers a series of zones then indicate that Australian Geological Survey Organisation 1995 16 PALEO DATABASE USER S MANUAL Forms Menu Options 4 to 7 Because the INITENTRY and PALENTRY Forms give access to many tables which can also be displayed individually as Forms accessed through Option 8 it is appropriate to discuss the details of that Option before Options 4 to 7 FORMS MENU OPTIONS 4 5 See pp 23 24 FORMS MENU OPTION 6 See pp 24 25 FORMS MENU OPTION 7 See p 25 TABLES MENU FORMS MENU OPTION 8 Access to individual tables As noted earlier Option 8 places you in the Tables Menu From this Menu Forms are available which display full data for individual Tables Because most of these individual Forms can be accessed from the two composite Forms INITENTRY and PALENTRY as well as some others they will be discussed here before the remaining Forms Menu options Note that in many cases the same fields are displayed as in those two forms so for comments on individual fields consult the descriptions under e g PALENTRY ACQUISITION TABLES MENU OPTION 2 This i
31. ble to establish appropriate data such as the Species Number for a taxon If the data are already in the database they will be displayed and Query Mode cancelled If not and you have to establish a new entry first cancel Query Mode with lt Alt F10 gt then enter the data and commit it with lt F10 gt You can then take data such as the computer generated Species Number back to the initial Form with lt Alt F3 gt next primary key Alternatively return without the data with lt Alt F10 gt Extensive help messages are provided where there is room on the screen Australian Geological Survey Organisation 1995 43 PALEO DATABASE USER S MANUAL Text control Changing text within a field can be by insertion replacement or deletion lt Esc t gt clear to end will clear all of a field at and following the cursor position unfortunately it is my experience that this does not work properly every time sometimes just inserting a t where the cursor is so watch what you are doing lt Delete gt will delete the character before the cursor DO NOT USE lt Backspace gt which has a different function go to previous field lt Insert gt works in the usual way as a toggle between insert and replace characters In Oracle the default setting is replace not the normal PC setting insert lt Alt F6 gt delete record will delete a displayed record but not undisplayed tables This means that if you try to delete
32. ccess linked Forms from see pages SPECIMEN all fields on the first three lines except environ t ECOLOGY environ t 22 23 ACQUISITION colldnrno 17 STORAGE access to storage data 21 LOCATION all fields in the 5 line block headed COUNTRY OCEAN 18 MAPS Maprefno 19 FORMATION all fields in the two line block headed BASIN PROV 18 AGE the line headed PERIOD 17 IDENTIFICATION FOSSIL groupis 18 SPECIES species number 20 21 PUBLICATION the section headed PUBLICATIONS 19 20 Procedure gt press lt Alt F3 gt next primary key Unless on screen messages instruct otherwise return to the main Form as easily gt press lt Alt F10 gt cancel exit There is one table and associated Form which has yet to be set up RADIOMETRY It is envisaged that it will relate radiometrically and biostratigraphically determined ages for samples and will also be a link to databases such as OZCHRON Access will be from sampled for radiometry Notes on individual fields Some of the fields in JNITENTRY have specific requirements as to what or how data should be entered The same applies to individual linked Forms as well of course to check those refer first to the discussion of PALENTRY below that Form encompasses many of the individual ones then to the sections on the individual Forms environ t The message line displays a key for entries in this single character field M marine S saline F freshwater L lacustrine E estuari
33. correct command wording in other words following the command c stands for change specify the wrong text and the wording to replace it Note carefully the slashes separating the two sets of text without gaps When all corrections have been made rerun the command gt enter run DATABASE STATISTICS It will sometimes be useful to know how many records there are for a particular field gt Enter select count fieldname from paleo tablename _ selection conditions can be added before the semi colon if desired i e where Australian Geological Survey Organisation 1995 37 PALEO DATABASE USER S MANUAL SELECTING RECORDS Just as command strings are used to update records so also they can be used to query the database The conventions are the same A typical simple command string would take the following form select fieldname fieldname from paleo tablename where add selection criteria just as in updating Queries become complex only where several tables are involved as the way in which data from those tables are joined must be specified Consult the SQL Plus manuals If you just want to look at the result of your query on screen the above will suffice the data will scroll past and the scrolling can be stopped and resumed with lt Scroll Lock gt GENERATING REPORTS If you want a printed record then in the way of all computer systems you must first tell the system what it is to do Specifically
34. d i e to just behind the last character in the field HELP Used once gives a brief help message at the bottom of the screen used a second time displays full details for the field containing the cursor cursor move to beginning of field clear text to end of line 1 e from the cursor to the end of the field 42 PALEO DATABASE USER S MANUAL KEYSTROKES amp PROCEDURES Exit lt Alt F10 gt One of the most important keystrokes the one which gets you out of the database In fact this key combination has the more basic meaning cancel If you think of Oracle Forms as rumning a series of nested programs starting with the menu program then the Forms program followed by the Query program then it makes sense that each lt Alt F10 gt cancels the program running at that time If in query mode you will be left in the form a second cancel will take you back to the menu program the next cancel stops that program and returns you to the system prompt If you get into trouble while in Forms Mode you can cancel lt Alt F10 gt You will usually be asked whether you want to commit any changes you have made the safe answer is No You will exit to the menu and must start again but at least you have not incorrectly modified the database Cursor control The normal keys for cursor movement are Move to right in field lt gt gt Move to left in field lt gt Go to end of field lt Esc g gt Go to start of
35. e grid ref Two fields of which the first is for the 2 letter international zone code if you know it the second is a 6 digit numeric field DO NOT insert a period between the eastings and northings but DO make sure the components of the reference are in that order DO NOT enter references to any other grid system here other grid ref This field is for non metric or non standard grids and the type of grid should be indicated Thus a reference to the Australian 10 000 yard grid could add yds to the number well bore depth Where possible a well or bore name should be the same as in PEDIN The two depth fields are for core etc and refer in that order to the top and bottom of the interval enter the numbers in metres to the appropriate number of decimal places basin province Spell out whether it is a Basin Sub basin or other geological province e g Fold Belt superep gp subg Put the name in the correct field but do not add the rank Thus the Catombal Group would be entered just as Catombal in the gp field NOT in the supergp field formation Spell out whether it is the Woop woop Formation or the Black Stump Sandstone member Treat as for the supergp etc fields bed or beds Under the current Australian Guide informal units are beds but a formal Bed is allowed Add the appropriate one to the name of the unit period epoch series stage substage If only one enter it in the first field if a r
36. e TAR S Longitude t79 6967 keyg 5a ey 1 Pg g s UTA Zn Ref Country Ocean I Map refno id Altitude m S L B48 1 CE eS n 3ka MAGEREN road from Namale East to Mbhangasau cutting on north side of main ro Registered number 4 bU tsi Area state territory etc gt w South Wales im Rititude m SL E2 3 as Latitude 038611 J Longitude 148 82385 eisdey n gt g 1 48 ree Grid prefs UIM a Ref Ot her Weli Bore De DATES EMostern shore of Burrinjuck Reservo paper Portion 65 Parish of Taemas Co Cow th RECT Eus tralia Map refno 443 Field No eES to ay old road at Shears by s Wall PALEO DATABASE USER S MANUAL MAPS TABLES MENU OPTION 7 The MAPS Form is entered in Query Mode see comments on aspects of this in the description of the ACQUISITION Form on p 17 In this Formup to 13 3 2008 S records Can be displayed on Fou plac ting in QUERY mode Press e rss a I to quit this form Query on at least the map name Scroll to the required entry Cif found the screen The fields are To carry the required Map ID acros exit the form with lt NEXT PRIMARY KEY gt To add a new record use lt EXIT gt lt INSERT RECORD gt and finally lt COMMIT gt MapID i e Map Refno Name the map name automatically capitalised Spell such words as Mount in full Scale enter as e g 1 250 000 NOT 1 250000 this avoids errors over how many zeros Map
37. e logging out will reverse an unwanted committal even the deletion of a record print necessary connections etc have to be made first so this is not very useful refresh if for some reason while in PALEO your screen gets covered with garbage this will redisplay a pristine screen or form exit you will be queried if there are any uncommitted transactions cursor to next field cursor to next field cursor to previous field it s less confusing to use lt Ctrl H gt work as always cursor left and right scroll forwards and backwards through multiple records and also through menu options go to next block insert replace toggle i e change modes go to previous block go to the previous record it s less confusing to use the cursor key because lt Page Up gt always takes the cursor to the beginning of the first field in the Form go to the next record again and for the same reason it is simpler to use the cursor key clear block in a composite Form this is quite different from lt Alt F4 gt and lt Alt F7 gt block menu displays a list of the blocks to which you can gain direct access choosing with the cursor keys and then either lt F2 gt or lt Enter gt clear field go to the previous field edit useful when fields to be edited are long amp or truncated because the field is displayed in an editing window within which aff cursor arrow keys work as expected cursor move to end of fiel
38. e sure of your keystrokes especially special keys Errors must be detected to be corrected and the database is only as accurate as the data it holds so check for and correct all errors CONTENTS KEYBOARD MAP pc vtemulation _ 42 KEYSTROKES amp PROCEDURES 43 Exit 2 222 43 Cursor control won n nena ann nnnn nnn nanan ween nena 43 Moving between blocks 43 Moving between records 43 Moving between forms __ 43 Text control insert replace deletion 44 Truncated displays examining in full and editin 8 44 Transactions committal _ 44 Data updating 44 Query mode lt 44 Wildcards in queries 45 Multiple records retrieved by query 46 Record duplication 46 Australian Geological Survey Organisation 1995 4i PALEO DATABASE USER S MANUAL KEYBOARD MAP pc vt emulation Alphabetic keys working as part of commands are case insensitive The following list omits those commands involved only in forms and menu designing lt F1 gt lt F2 gt lt F3 gt lt F4 gt lt F6 gt lt F7 gt lt F8 gt lt F9 gt lt F10 gt lt Alt Fl gt lt Alt F2 gt lt Alt F3 gt lt
39. econd Keep strictly to this it s important for querying Fossil group Type here the informal name of the major group e g brachiopod trilobite foram to which the taxon belongs For samples with many different taxa enter here a list of the groups that does mean that wildcards are essential during querying but the solution to that problem would make the database quite unwieldy identified by on This refers to unpublished taxa and sheets home the responsibility for identifications Unfortunately it cannot cope with different people identifying different components of a sample at different times Such information will have to go in the general remarks field in SPECIMEN PALENTRY FORMS MENU OPTION 3 Below are shown the two screens and beside them the accessible individual Forms details on that access follow below the illustrations Tip You can move quickly between the two display screens by using lt End gt and lt Home gt to move between the top block of Screen I and the bottom block of Screen 2 This is very useful when examining displays of multiple records The username entry date and record number assigned on committal are displayed in a separate box in the top right corner as with INITENTRY these fields are only accessible in Query Mode SPECIMEN ital S FEB 9 1 Hi 96 ity btm LBERIO seg AMP R28 4 a0 et et OLOT Y PE i field refno FIELDNOTES configuration other fossil grou ECOLOGY radiometr
40. ed see the comment above fieldname the formal database name of a single field in a table command an optional command or word to be inserted at that point when required This is used to indicate alternative command phrases comment an explanatory comment not to be incorporated in an actual command nnn a number may or may not be decimal string a series of characters amp or numbers to be inserted in the database or which a query is required to match Australian Geological Survey Organisation 1995 34 PALEO DATABASE USER S MANUAL Commands should be entered with spaces only where shown a space can be more than one character long without affecting a command Avoid long command lines as wrapping themcan be tricky Itis better to break a command up into short segments placed on separate lines see below Make sure each line is correct before moving on to the next with lt Enter gt Each new line will commence with a line number which can be used to modify previous commands consult the SQL Plus manual A semicolon should not be used except at the end of the complete command unless within a character string defined by single quotation marks If acharacter string necessarily includes an apostrophe that MUST be typed as two successive single quotation marks NOT one double quotation mark otherwise it will be taken as the end of the string and you will end up with an error message For example
41. ed for easy loading into an Excel spreadsheet The files generated are respectively palynrep lis and palrep lis and should be transferred amp or renamed in the usual way see pp 27 39 Australian Geological Survey Organisation 1995 31 PALEO DATABASE USER S MANUAL In both cases you will be asked to enter first and last numbers refno which should include the acronym MFP That done the program runs and you are returned to the Curatorial Reports Menu The output from palynrep lis appears thus single record REGISTRATION No MFP10001 entered by CTHUN on 16 JUN 93 field No 56 DR 014 A 4 CBF No 841 remarks LOCATION country ocean Australia area well bore depth to m details Dredge samples Wombat Plateau PREPARATION date 16 JUN 93 by CTHUN core No sample weight 18 841 residue N processes 1st HCl Y HF Y 2nd HCI Y sieve SG OXY KOH VOM No of slides K description BARREN STORAGE building AGSO room 166 wallet No cabinet drawer check 16 JUN 93 other area micropal box collector donor remarks The output from palrep lis is one record per line with commas inserted as spreadsheet cell delimiters a selection of records appears thus MFP10001 56 DR 014 A 4 BARREN MFP10005 Ashmore Reef 1 2833 22 2833 32 20 10 amp 20 3 MFP10018 Ashmore Reef 1 3678 78 3678 94 26 10 3 BARREN MFP10032 DM Brigalow DDH2 552 1 20 3 MFP10044 WMC Oil A 20 Sample w
42. ed in a separate window While in the window the up and down cursor arrows allow one to move quickly from line to line speeding any editing gt Exit the window with lt F10 gt One peculiarity of the way the Forms INITENTRY and PALENTRY are constructed is that the normal method of moving backward with lt Ctrl k gt includes the Help Screen as a field Another lt Ctrl h gt takes you to the last field in the first block SPECIMEN DATA DISPLAY QUERY MODE The whole Form can be queried only from within the first block corresponding to the SPECIMEN table See pp 44 46 for query procedures Once a sample record has been retrieved its data are displayed throughout the Form It is then possible to move the cursor to other parts of the Form see p 43 for cursor control While it is possible to query those parts individually that is a pointless exercise since the result of a query still corresponds to the record which remains displayed in the rest of the form Multiple records retrieved see also p 46 If a query retrieves several records which meet the query conditions remember they can only be set within the initial SPECIMEN block this will be shown by a down arrow v in the status line at the base of the screen With the cursor in the initial block you can scroll through the records with the cursor keys and the status line will display two arrows and v and the number of records scrolled through until you reach
43. eight is in Litres Oil dissolved in Dichloromethane CONODONT FORAM LABELS FOR CPC SPECIMENS CURATORIAL REPORTS MENU OPTIONS 7 9 These two Report programs are designed to produce the formatted text from which slide labels can be made for conodonts and foraminiferans There are differences in what is retrieved but the basic structure of the output is identical Input is the first and last numbers of a block of CPC numbers the acronym is set at CPC already Australian Geological Survey Organisation 1995 32 PALEO DATABASE USER S MANUAL The files produced are conods lis and forams lis and they should be handled as are those from the previous report programs see pp 28 39 Base font is Times Roman 8 pt Formatting flags are lf1 1 0 large font size 9 6pt bf1 bf0 boldface Set up for newspaper style columns about 2 5 mm separation 24 mm text width 5 columns across an A4 page The labels for each slide are arranged as a pair to be placed either side of the specimen well or thin section When copied either copy onto self adhesive sheets or use some other form of adhesive guillotine to size and apply The formatted pairs of labels under the two programs will appear thus Paltodus sp a Operculina Ct 69 complanata CPC10146 DEFRANCE 1822 133 826A 2W CC CPC23256 DRUCE E C 1970D BMR Joumal Pl 7 fig 3 CHAPRONIERE Lachlan Fold Belt i G C H amp BETZLER Devonian C 1993 BMR Joumal
44. elect the AViiON Oracle icon in the LAN WorkPlace window see DG UX Release 5 4 1 av or whatever the current version is login enter jbloggs Password enter dumb If Dr Bloggs AViiON password has expired aged he will be asked to enter old and new passwords at this stage see Copyright messages Statement of your default terminal type gt If this is pc vt press lt Enter gt gt If something else is specified enter pe vt see Advice on network news and mail normally none see av home3 jbloggs i e Dr Bloggs AVHON home directory prompt At this point Dr Bloggs has successfully logged into the AVuON and is about to run PALEO under Oracle 2 Log in to PALEO enter paleo see the Oracle login screen asking for entry of username and password enter jbloggs gt enter dumb see the PALEO Main Menu Dr Bloggs is now ready to use PALEO From this point on he must use Oracle keystrokes see Appendix 2 since Unix commands no longer apply Australian Geological Survey Organisation 1995 2 PALEO DATABASE USER S MANUAL eee eed oeasvuega0ae00e0e0e00e00e000008 eee1eeeeee LOGOUT PROCEDURES 1 Exit PALEO If Dr Bloggs has opened a Form he should gt press lt Alt F10 gt exit if he is within a Menu then he should gt select Option 1 OR press lt Alt F10 gt He repeats this as often as necessary until see av home3 jbloggs 2 Exit AViiON gt Enter exit Dr Bloggs
45. ens not to the original samples For each table you will have to start by entering the CPC number anew An alternative isto use PALENTRY Forms Menu Option 3 display the initial record then access the two individual Forms from appropriate blocks as has already been described on p 11 FORAMINIFERIDA FORMS MENU OPTION 6 This Form is designed for compiling foraminiferal faunal lists and is entered in Query Mode It is assumed that the basic sample data have already been entered e g in JNITENTRY A scroll bar at the bottom of the Form indicates that it is wider than can be displayed on the screen how to cope with this is explained below As usual each field has its own help message Entry of Foraminiferida Enter the reference No and press lt EXECUIE QUERY gt Biei specinen No SUSE MEE entered by td het O DEC F1 qenus species subgenus subspecies forn identified hy i taxon ident date t lt Replace gt The sample number is the basis of the query which must be made before the rest of the Form is accessible Once a record is displayed the first two lines of the Form move the cursor to the first field in the No column this is for entering or displaying species numbers Australian Geological Survey Organisation 1995 24 PALEO DATABASE USER S MANUAL eee oaeoeeoeeeeeeedee eeoa eeegeeecmlcelUCcclUCcCeOecmcCeCeoelecmlUceeCcelele le p If you know the Species Number for a taxon found in t
46. ent If in your selection criteria you wish to introduce wildcards the appropriate wording is one of the following fieldname like string string string string string for fields in which the data contain the specified string s in the positions shown amongst otherwise unspecified text e g genus like Reticul or Refno like CPC 22 fieldname like sfring_string where a single character within a string may vary more than one underline symbol may be used one for each variable character For example Refno like CPC22_ or Refno like CPC_22_1 Remember that the remaining characters in the specified strings will be matched exactly including by case The two wildcards can be mixed in the one string e g Refno like CPC22_ Note the use of the word like to replace when wildcards are used Update selecting by reference number Because of the way in which the Oracle system orders the contents of fields the selection of a series of catalogue numbers CPC F or similar for updating is a bit complex involving selecting the components of the number to avoid changing data where it should not be changed The full command for one or a series of specimen numbers in the CPC F or similar collections thus takes the form Update paleo tablename set fieldname string and the other alternatives as in the previous example 2 where refno in 3 select acronym to_char num suffix from paleo s
47. entered by Strusz on 09 aug 94 Appearance configuration fragmentary more or less fire damaged conchs Known associated taxa General remarks SYSTEMATICS Major taxonomic group ammonoid SPECIES NUMBER 1167 Phylum Mollusca Class Cephalopoda Order Ammonoidea Suborder Lytoceratina Superfamily Turrilitacea Family Baculitidae Subfamily Eubaculitinae Eubaculites vagina FORBES 1846 CURATORIAL REPORTS MENU OPTION 4 Production of specimen labels This Report program is designed to produce tray labels for specimens registered in one of the formal collections CPC F etc Selection is purely on collection acronym and set of numbers and a file labels lis is generated in your home directory As with the previous program editing labels are inserted but there is no explanatory page and the records follow one another without page breaks Running the Report program The screen display is simple Australian Geological Survey Organisation 1995 30 PALEO DATABASE USER S MANUAL SOR Structured Query Report Writer V2 27c Copyright lt C gt 1986 89 SQ Software All Rights Reserved Enter the acronym e g CPC F Enter the lowest fossil number Enter the highest fossil number Enter each item in turn e g CPC 539 545 and when the last is entered the program will run and you will be returned to the Curatorial Reports Menu The same comments on file renaming and transfer apply as applied to the previous Report see pp
48. ery is done on that field this is also important later if there are published specimens registered with their own numbers but from that locality since the connection between the two numbers will not be lost 7 Other data Having entered the number work through the Form adding data remembering that some fields e g general remarks in INITENTRY may be longer than they look Truncated fields In such a truncated field be a bit careful the program is normally set to Replace characters so when you reach the last space in the field each character you type will replace the one you typed previously If you know what you have to type in is going to be longer than the display you can work in the field in a separate window accessed with lt Esc e gt and left with lt F10 gt See p 44 for details Correcting errors To correct errors or modify text which will not fit in a field use the left and right cursor keys to move through the field and toggle between Insert and Replace Text modes with lt Insert gt Accessing other Forms You will also come to fields which require that you access a separate single table Form which is linked to the main one by a common field often some sort of record number An example common to both Forms of how to do this is to enter the Maprefno 1 e map reference number gt From the Maprefno field access MAPS with lt Alt F3 gt next primary key In this case as the help message will show you are a
49. es or N o i e is there a residue or not Ist HCl HF and 2nd HCl record sequential acid treatment again with Y or N sieve specify the sieves used in separation e g as 38 amp 20 amp 10 SG specific gravity of the separating liquid used OXY Oxidation a numeric field records the number of minutes in HNO KOH a numeric field records the number of minutes in KOH VOM initials of volume of organic matter a number derived according to the following formula VOM 10 weight of float original weight K kerogen present or absent requires simply Y es or N o The fourth block is the STORAGE Form see p 21 plus one special field wallet number which refers to an old but still extant storage system for slides using numbered subdivided envelopes wallets in index cabinets Access to the ACQUISITION Form see p 17 is gained from the collector donor field Default entries which can be changed are AGSO for the building field and 166 for room Australian Geological Survey Organisation 1995 26 PALEO DATABASE USER S MANUAL FIND LOCATION OF SPECIFIED HOLDINGS FORMS MENU OPTION 10 This Form although displaying data from several tables works as though it were a single table Form It is designed to display information on the location of specimens selected either on number or a combination of basic taxonomic geological and age data i e informal taxonomic name or a specific species n
50. es in an ASCII file the records for a selected taxonomic group ready for editing into a publishable catalogue 6 Go temporarily into Unix After running a report program one can use this option to execute a variety of Unix commands e g after running a report program to rename the file produced prior to running the same report again for a different batch of data Return to the Catalogue Reports Menu by entering exit rn Australian Geological Survey Organisation 1995 5 PALEO DATABASE USER S MANUAL CURATORIAL REPORTS MENU This menu permits a variety of report programs having to do with specimen handling documentation and control to be run Their use will be explained on pp 28 33 1 Exit to previous menu 2 Ordered list of all recorded specimens Simply a list of CPC specimens which have been entered into PALEO see p 28 3 Full data records for selected registered specimens This is designed to provide hard copy of the data for selected sets of registered CPC F etc specimens see pp 28 30 4 Production of specimen labels A report program designed to produce labels for registered specimens in formal collections CPC F etc see pp 30 31 5 Palynological register for specified MFP numbers This is designed to provide hard copy of the processing form for palynology Forms Menu Option 9 see pp 31 32 6 Selected data for specified MFP numbers This produces a set of locality and processing data format
51. ferred at what speed and how long it took Repeat as necessary When you have finished transferring files you can if you wish clean up your home directory For each file to be deleted gt enter rm filename ext When you have finished leave the AViiON with the usual Unix command exit Australian Geological Survey Organisation 1995 39 PALEO DATABASE USER S MANUAL APPENDIX 1 PASSWORDS When you first log in to most networked systems you will be confronted with the need to change from a specific initial password to one that is unique to you Each system has a distinct way of achieving this and each system administrator has his or her own carefully guarded initial password Some systems also require that passwords be changed periodically but then provide prompts on how to do this so need not concern you unduly In this Appendix will be explained how to change your AViiON and Oracle passwords for the initial password ask the appropriate system administrator AViiON gt Log in using your existing password or the system s initial password see av home3 username i e your home directory prompt gt enter passwd gt when asked enter the password you used to log in gt when asked enter your chosen new password twice You will then be returned to your home directory prompt ORACLE gt Log in to PALEO using your existing initial password see Main menu gt Select Option 5 use SQL Plus
52. first line and then start the second line by pressing lt Enter gt As already noted it is better not to make commands so long but to divide them up into separate logical clauses each on a separate line Error messages and command correction If the system doesn t like something about the way you phrased your command it will tell you and will not execute the command The command will be displayed with an asterisk below the place where the error was found If you divided your command into clauses on separate lines the offending line will be displayed with appropriately placed asterisk as well as the line number and error type If you have made several errors Oracle because it examines a command backwards will only display the one closest to the executive semi colon so it may take several goes to get the command right If your command was on only one line it can be edited and re run very simply gt lt Ctrl A gt will display the command gt move back through it with the lt gt key to the error gt type over what is already there It is better to avoid lt Backspace gt in the middle of a command extra spaces can be left as they are ignored gt Execute the corrected command with lt Enter gt If your command covered several numbered lines note carefully the line number s where the error s occurred Then gt Enter list n where n is the number of the line to be edited gt Enter c wrong part of commandi
53. h sample or specimen since there is a straight forward procedure in Forms Mode fordisplaying a duplicate of the previous record containing that information editing the duplicate for any differences and entering it as the new record In this context it is worth remembering that when a series of records is being entered in a Form the data in those records already entered is accessible by scrolling at any time until a query is made Procedure gt Display the record holding the data to be repeated by querying or scrolling if it is not the record you have just entered gt Check for and correct any errors If any changes are made commit with lt F10 gt gt Press lt F6 F4 gt create record duplicate record gt Edit the displayed record changes or additions to align it with the proposed new one gt Press lt F10 gt commit Australian Geological Survey Organisation 1995 46 PALEO DATABASE USER S MANUAL conodontel remarks PUBLICATION pubno authors year title source APPENDIX 3 List of PALEO tables amp fields IDENTIFICATION refno speciesno identdate identby ECOLOGY refno tpct PUBLISHEDIN refno epubno illustration pageno LOCATION refno country_ocean area altitude depth well_bore dlat ns diong ew utmzone gridref oldgridref details maprefno lowdepth fieldname numeric field e NOT NULL field primary key field
54. he sample enter it here see The species name displayed across the screen together with the form and taxonomic group see the illustrated example This can be repeated by moving the cursor to the next No field and typing the new number gt If you do not know the Species Number move to the next field genus then gt Type the first part of the generic name DO NOT USE wildcards gt Press lt F9 gt list see A window overlaying the upper two thirds of the screen containing a list of all taxa held in the database whose generic names start with the typed in character string gt To select a taxon scroll to it then press either lt F2 gt or lt Enter gt see The window disappear and the taxonomic name displayed in the full Form together with form default entry foram which if necessary you can edit identified by default Chaproniere likewise changeable and ident date default changeable is the login date gt If there are more taxa to be added for the same sample move the cursor to the next genus field and start the listing procedure again e When there are no more taxa to be listed for that sample commit with lt F10 gt e If there is another sample to be dealt with Diese lt Alt F7 gt and start again with a new sample number in Refno o When all samples have been committed exit with lt Alt F10 gt CONODONTS FORMS MENU OPTION 7 This Form is designed to do for conodonts what the previous Fo
55. hoose selection by number you will be asked to enter the lowest and highest CPC number omitting the CPC acronym since the program is designed specifically for CPC specimens In either case once the second item is entered you are returned to the program menu You must enter X as the program only writes the output to the file epcrecs lis when this is done Don t forget to rename that file before you run the program again see above Transferring and editing the Report The Report file may now be transferred from the AViiON see p 39 and formatted for printing within a word processing package To aid in this formatting several character groups have been inserted in the text to act as flags for find procedures These which should enable appropriate macros to work no matter what the word processing program used are explained on the first page of the file as follows For editing purposes the flags listed below have been inserted where appropriate Macros to change the text so flagged must be run in the order of this list 1 italics itall start ital0 end WordPerfect macro italics 2 boldface bfi start bf0 end WordPerfect macro boldface _ 3 large font size lgf1 start lgf0 end WordPerfect macro large As of May 1992 under WordPerfect insert the following printing codes which will fit the text onto an A4 page Format top margin 2 cm left margin 1 8 cm right margin 1 2 cm Base Font Palatino 9 pt Use th
56. hrough a system of data entry and display Forms each of which displays selected parts of the database and through which the user can move using specific keystrokes The former is powerful can refer to any combination of tables and can retrieve multiple records which can be stored in an ASCH file for later manipulation or printing Its disadvantage is that the language is complex precise and must be used with care The latter is simpler to use but less flexible because all the commands for using the actual database must be built in and cannot store retrieved records Forms work by setting up one or more views of the database which may incorporate fields from one or several linked tables each table forms a block A Form can only display one specimen or sample record at a time Nevertheless the Forms system or Forms Mode is the normal means of access to the database for data entry updating and correction and for one off queries Details of all available ORACLE Forms functions can be found in Lenz et al 1993 AGSO Record 1993 81 A reference list of those normally used is given below cross referenced where appropriate to the following discussion of the various procedures and keystrokes set out in the order in which they are likely to be met with A PC keyboard template for the pc vt emulation that favoured under LAN WorkPlace is available from the Database Owner Remember at all times that you are working directly with the database b
57. ian Geological Survey Organisation 1995 17 PALEO DATABASE USER S MANUAL FORMATION Stratigraphy TABLES MENU OPTION 4 STRATIGRAPHY Registered No Basin or Province Member Subgp Member lt Replace gt As with the AGE Form this displays two re cords at a time and all the fields are as on the PALENTRY Form Seep 16 for detailed comments IDENTIFICATION Species Identification TABLES MENU OPTION 5 Again two records are displayed and the same fields are here as on the PALENTRY Form just differently arranged see pp 14 16 You can access the SPECIES Form from the Species field when that field displays a species number the name of the species is dis played on the next two lines SPECIES IDENTIFICATION Registered No Species gije Taxon Abundancy Percent Population Nos Coiling Registered No Species y fulosteges yndonensis Form Taxon Unt opo Abundancy Percent Population Nos Coiling Identified by MEMa De RE Identified by A3 OCT 89 Press lt ERIT gt to quit LOCATION Specimen Locality TABLES MENU OPTION 6 In this Form also two records can be displayed at once and the fields are as displayed in PALENTRY for notes on individual fields see pp 13 16 Access the MAPS Form from the Map refno field Australian Geological Survey Organisation 1995 18 SPECIMEN LOCALITY hg Registered number FILA GETERE tit a a a anua Lovu Latitud
58. ic Sanples Y collector donor No pip aa 2 ACQUISITION identified IDENTIFICATION SPECIES conodont element abundance population No HE coiling VA a PUBLICATION illustrations l No pes Pl 1 figs 4 PUBLICATION CITATION DETAILS COUNT HO e SH eeeetr eee een NECSCMSCMEPR2845 7 A ia Slit estern Australia LSet me S 713 wa ile eae 25 608 LOCATION 41 8 Cr 8i 5 Sie altitude I lmap refno UTM zone rid ref BREE other grid ref MAPS we ll bore depth to ce eeemesection PR284 level J section starts at PR284f f 4 miles 6 4 ka gt due W of Chestnut Bore extends for 3 miles 4 8 km at BAS IN PROUINCE anning Basin lt supergp DA Ema ormation aol bah Formation ttm eo 296 m above basem tidi pt Tis FORMATION remarks AGE era Palasozoic Seieierermian arly Permian to series to Perma Pt inskian to lt AGE substage to zone datum remarks ter the name of country ocean or sea ount 1 lt Replace gt 14 PALEO DATABASE USER S MANUAL Australian Geological Survey Organisation 1995 Access linked Forms from SPECIMEN any field in the block labelled SPECIMEN except field refno environment and collector donor No see p 22 FIELDNOTES field refno see p 22 ECOLOGY environment see pp 22 23 ACQUISITION collector donor No see p 17 IDENTIFICATION any field in the block FOSSIL except species and Conodont element Note that the fields in which a species
59. ion for data manipulation 3 Catalogue reports a series of Report programs which produce files used in the production of CPC catalogues 4 Curatorial reports various Report programs producing files for curatorial purposes e g specimen labels or hard copy of records 5 SQL Plus This option is briefly discussed below The prompt displayed is SQL Prod gt Australian Geological Survey Organisation 1995 4 PALEO DATABASE USER S MANUAL FORMS MENU FOR DATA ENTRY AND RETRIEVAL This menu more succinctly referred to as the Forms Menu gives access to a variety of Forms several of which are composite views of several tables Some are of general use some are specific to certain aspects of Palaeontology within AGSO The overall appearance and methods of selection are the same as for the Main Menu the options being 1 Exit to previous menu 2 Initial data entry and display The single screen Form JNJTENTRY useful for entry and display of field and sample data see pp 8 14 3 Full data entry and display The double screen Form PALENTRY useful for entry and display of data for published specimens see pp 8 12 14 16 4 CPC allocation This is a very specific program rather than simply a Form It is designed to attach previously entered field data to the CPC numbers of published or about to be published specimens see pp 23 24 5 After using item 4 run this report An essential but quick reporting program which
60. is printed report to check for AND CORRECT any errors in data entry When all corrections have been made it is your responsibility promptly to prepare a fresh set of registration sheets and hand them to the palaeontological curator DELETE THESE INSTRUCTIONS AFTER EDITING AND BEFORE PRINTING Experience has shown that for Palatino 9pt it is not necessary to have a left margin narrower than 2 cm However if 10pt must be chosen then the heading will not fit unless the margins are narrow Each record is a separate page Prior to formatting the upper portion of one such record looks like this Australian Geological Survey Organisation 1995 29 PALEO DATABASE USER S MANUAL igflbflREGISTERED SPECIMEN COMMONWEALTH PALAEONTOLOGICAL COLLECTION CPC 2698bf0lgf0 INDEX NUMBER 27249 STATUS Referred specimens 22 specimens entered by Strusz on 09 aug 94 Appearance configuration fragmentary more or less fire damaged conchs Known associated taxa General remarks lgfi bf1SYSTEMATICSbf0lgfO0 Major taxonomic group ammonoid SPECIES NUMBER 1167 Phylum Mollusca Class Cephalopoda Order Ammonoidea Suborder Lytoceratina Superfamily Turrilitacea Family Baculitidae Subfamily Bubaculitinae lgflitallEubaculites vaginaital0O FORBES 18461gf 0 When properly formatted this will be changed to REGISTERED SPECIMEN COMMONWEALTH PALAEONTOLOGICAL COLLECTION CPC 2698 INDEX NUMBER 27249 STATUS Referred specimens 22 specimens
61. ive or absolute abundance of a taxon in a sample Abundance is an estimate of the relative abundance of the taxon in the sample simply using the initials wr very rare r rare c common ye very common and ab abundant is the percentage that taxon is of the total sample population No is the number of species in the sample coiling is the of individuals of a particular taxon which are sinistrally or dextrally coiled express this as e g 10 S or 45 D latitude longitude In this Form while the correct format is decimal degrees there is provision made on the next line for entry as degrees minutes and seconds the last two can be decimal numbers A resident routine will convert them to decimal degrees which is the only way AGSO s Oracle databases store that information Unless you know they are more accurate do not enter more than 4 decimal places NOTE If you have to change the latitude or longitude and only have the correct numbers as degrees minutes and seconds you must first clear the decimal degree figures with lt Ctrl f gt or lt Esc t gt If you do not the change will not be recorded Alternatively first use a calculator and then simply edit the decimal degree numbers altitude Relative to sea level in metres submarine samples should therefore be entered as negative numbers This field does NOT refer to well data except where appropriate to the collar altitude UTM zon
62. l storage situations e g for very large specimens Date seen For control purposes note here the date of the most recent stocktake or the date when a sample had to be searched for because it was not where expected and was successfully found make sure you also record where you found it in Remarks if that was a temporary location Remarks Anything not covered in the other fields which is relevant to the storage and recognition of the sample ess lt EXIT gt to quit Australian Geological Survey Organisation 1995 21 PALEO DATABASE USER S MANUAL SPECIMEN TABLES MENU OPTION 12 This Form displays the key database table in PALEO Most of its features have been described already as it is almost identical to the first blockinthe PALENTRY Form see pp 8 10 15 16 includ ing access to other Forms In the Form s top right corner there is a distinct area whose fields are filled auto matically but under some SPECIMEN CPC11103 numher thE suf fix Field 7161 2 Registered number type status configuration 3 other fossil Maturity rFadionetric samples Y N collector donor number collector etd et o P eB 9 ORI 89383 i0t b eed LBERTO Specimens field refno collected on acquired on circumstances can be useful for querying Here are recorded the date entry_date on which this part of the record was committed not necessarily when the record was completed the record number and the
63. lready in Query Mode Follow instructions to establish the reference number for the map gt If your query retrieves a map reference number return with it to the original Form with lt Alt F3 gt gt If your query retrieves no data it is because the map has not yet been entered in the database gt press lt Alt F10 gt to cancel Query Mode gt enter the map data gt press lt F10 gt commit gt return the new map reference number to the original Form with lt Alt F3 gt Australian Geological Survey Organisation 1995 10 PALEO DATABASE USER S MANUAL ee eoeeoeedeseoe0e93090008006068G 008808080808 08808006 Multiple entries in FOSSIL PUBLICATION As already mentioned it is possible for a sample or specimen to have more than one entry in these blocks Procedure gt Place cursor on the already displayed species number or publication number gt press lt F6 gt insert record the field and associated display only fields will be cleared gt enter the new number type it in if you already know it otherwise go to the appropriate individual Form in the way described under Accessing other Forms above establish the correct number and return with it to the main form gt press lt F10 gt commit Repeat as necessary Committing record For more detail see p 44 b When the record is complete press lt F10 gt commit Error message on committal Oracle unable to insert data If when y
64. men numbers which include a suffix such as CPC 1201a c which the query for CPC12__ would not Multiple records retrieved by Query When a query retrieves more than one record this is indicated by the insertion in the message line at the screen bottom of a down arrow or v Scroll forward through the records with lt gt or lt Page Down gt next record Scroll backward through the records with lt t gt or lt Page Up gt previous record While you are in the midst of the stack of records the message line will display the two symbols A y when you have reached the last record only is displayed If you persist the form is cleared until you scroll back When you scroll back to the beginning the display reverts to v If you try to keep going you will here a beep and a message will remind you that you are at the first record In multi block Forms indication of multiple records is specific to where the cursor rests If it is in that part of the Form which queries for complete records the arrows apply to complete records If it is in a part of the Form which allows for multiple data attached to the one record e g taxonomic lists publications the arrows apply to that block within the displayed single record Anywhere else in the Form no arrows are displayed Record duplication It will often be the case that there will be data common to many records Fortunately these common data usually do not have to be retyped for eac
65. menu system and modes of operation are discussed and the various menu options and how they are used are presented There follows a section on the available Report programs and a very basic guide to the use of SOL Plus Finally an account is given of the current method for transferring files from the AViiON to LAN directories or one s own PC An Appendix gives details of the general methods used in data entry modification updating and retrieval querying CONVENTIONS Several conventions are used throughout this manual in describing keyboard procedures 1 Special keys to be pressed are shown as lt key name gt Two to be pressed simultaneously are shown as lt key name key name gt keys to be pressed in sequence as lt key name key name key name gt 2 Characters or text strings to be entered are shown in boldface 3 Where key combinations performing Oracle functions are specified the Oracle name for the combination or function may also be shown as function if that makes the explanation clearer 4 The term enter followed by a string of text implies typing the text then pressing lt Enter gt It can also mean more generally that some data are to be added to a database 5 The term select means indicating a chosen item on a menu by highlighting using the cursor keys or mouse or by typing the item number and implementing that selection with lt Enter gt or other appropriate means 6 The term see refers to what sh
66. mplexity And like most actively used databases it is always being improved PALEO originated over 20 years ago as an HP Image database and has seen not only migration to a different database system but to different computer systems As a result of this history and of developments in the types of data recorded as well as inconsistencies in data entry over the years many early records are incomplete some have been corrupted and some tables contain significant redundant material As work continues particularly on cataloguing the Commonwealth Palaeontological Collection detected shortcomings are being fixed but it is the responsibility of the individual staff who use the system to bring data within the scope of their professional interests up to date In this way the usefulness and reliability of the database will continue to increase This manual is designed as a day to day guide to all aspects of data handling within PALEO in its current state of development For a more detailed discussion of the database itself a separate AGSO Record is being prepared while a broader discussion of Oracle can be found in AGSO Record 1993 81 Users guide to AGSO s Oracle database system The following instructions are for PCs and assume the user has logged on to the MPSR formerly OS amp PG LAN Where appropriate instructions for the Windows environment are appended to those for DOS After an outline of manual conventions and login procedures the Oracle
67. mply go back to the error with the left cursor key and retype the keyboard is locked in replace mode Use table and field names as shown in Appendix 3 p 47 not those heading the various forms where space sometimes allows the use of less cryptic names sometimes forces abbreviations When referring to a table always combine it with the database name in this manner sees paleo identification When typing a command do not insert the final semi colon until you have checked for errors and have made sure you have so phrased the command that it will work only on the particular records you want affected Be especially careful if using wildcards A command must end with that semi colon and is executed with lt Enter gt Before you insert the final semicolon in a command you can abandon the command with lt Enter Enter gt You cannot easily abort a command once it has started but if you realise that you have run a bad command immediately enter rollback this will undo the command provided you have not left SQL Plus Remember you do not see displayed the results of many commands unless you enter specific preliminary commands which may include writing the result to a file Leave SQL Plus by entering the command exit In the examples that are given in this section the following conventions are used tablename the formal database name of the table to be used in executing the command specifi
68. name is displayed are display only see p 18 SPECIES species which displays the Species Number or indirectly from the IDENTIFICATION Form see pp 20 21 PUBLICATION No in the block labelled PUBLICATION see pp 19 20 CITATION DETAILS anywhere in the block labelled PUBLICATION except No which displays the Publication Number The Form displays the PUBLISHEDIN table see p 20 LOCATION anywhere in the block labelled COUNTRY OCEAN except map refno see p 18 MAPS map refno see p 19 FORMATION anywhere in the block labelled BASIN PROVINCE see p 18 AGE anywhere in the block so labelled see p 17 Procedure gt press lt Alt F3 gt next primary key Unless on screen messages instruct otherwise return to the main Form as easily gt press lt Alt F10 gt cancel exit Notes on individual fields As with INITENTRY some of the fields in PALENTRY have specific requirements as to what or how data should be entered The same applies to individual linked Forms as well of course but most of them are actually incorporated in this present Form For many fields the help line provides all the information you need so do please look at it otherwise see below or in a few cases under the descriptions of the individual Forms old reg d No For recording a previous collection number An example would be a specimen from the F collection which is renumbered in the CPC collection for publication The F numbe
69. ne and in this method it is simpler to check that by simply querying each Form using appropriate wildcards see p 45 INITENTRY FORMS MENU OPTION 2 The screen appearance is shown below and beside it the names of the individual tables for which Forms can be accessed from the main Form SPECIMEN Sample No ae ionder ABE ECOLOGY environ t W csee displayed 4 thinsections from core gt ACQUISITION access to stor ies STORAGE CO eee Coral nL N Cue ens Land Plateau latitud ERZA ge ridref LOCATION i MAPS BAS TN PROD FORMATION sai ertiar AGE FOSSIL group s 2 speci b n BAA PR 3 IDENTIFICATION EGRE SPECIES PUBLICATION There is no direct access to the CITATION DETAILS Form Publishedin Table Australian Geological Survey Organisation 1995 12 PALEO DATABASE USER S MANUAL The first line of the display comprises computer generated data the username of the person who first committed the record the date on which that was done both derived from the login procedure and the number assigned by the computer to that record These fields can only be entered when the Form is being queried The several display only fields cannot be entered or queried These are Collector and date tied to the field colldnrno Genus subgenus species and subspecies tied to the field species number Publication author and date tied to the field pubno displaying the publication number A
70. ne T terrestrial Statistical data for environmental assessment of foraminiferal samples can be entered in the ECOLOGY Form accessible from this field latitude longitude In this Form must be entered as decimal degrees Unless you know they are more accurate do not enter more than 4 decimal places The default settings for hemisphere are E and S alter if necessary metric grid ref Two fields actually the first is for the 2 letter international zone code if you know it the second is a 6 digit numeric field DO NOT insert a period between the eastings and northings but DO make sure the components of the reference are in that order DO NOT enter references to any other grid system e g the old Australian 10 000 yd grid here well depth Where possible a well name should be the same as in PEDIN e g BMR Huckitta 6 The two depth fields are for core etc and refer in that order to the top and bottom of the interval enter the numbers in metres to the appropriate number of decimal places Australian Geological Survey Organisation 1995 13 PALEO DATABASE USER S MANUAL basin province Spell out whether it is a Basin Sub basin or other geological province e g Fold Belt Form n Abbreviated form of Formation Spell out whether it is the Woop woop Formation or the Black Stump Sandstone Period If only one enter it in the first field if a range the oldest goes in the first field the youngest in the s
71. ner of new CE either the PALENTRY Form Pome or the individual Forms Forms Menu Option 8 but that method becomes totally inefficient when a sample or field locality has yielded a number of published specimens Option 4 provides a simple alternative specifically for the marrying of recorded field data with CPC numbers Procedure gt Select Forms Menu Option 4 gt Enter in the first field the original sample or field number from which the specimens came gt Enter in the third field the nuznber part of the first CPC numbers to be allocated the acronym field automatically displays CPC The cursor should move to the fourth field see the complete CPC number except that any suffixes cannot be entered in this form gt After the first CPC number is typed use the down cursor key in this or the next single character field to add consecutive numbers until you have as many as are needed for that sample or locality It is possible to start a different block of numbers for the same locality simply by moving the cursor back to the number part field and entering a new number before resuming scrolling gt Check that you ve got it right you can use the up cursor key if necessary gt Move the cursor to the final single character column if not already there at the last entry gt Press lt F10 gt to commit the program to its next phase copying the data You will now be taken in turn to the Form for each of the four basic t
72. ng the up and down cursor arrows while the cursor is within the first part of the Form There is an initial help screen that for INITENTRY being shown at right which lists the tables from which fields are displayed and also explains the keys used in moving through the form In both there are some display only fields from PALEO Database Initial entry forn linked tables and especially This initial data entry form is a nulti block aie eae torn k INITE RY son fields Information entered goes into the following table Specimen have a truncated display arity F ormat ion which simply means you identification cannot immediately see all the Meee O ll thr h Access the underlying table from any Field by pressing lt NEXT PRIMARY KEY gt text ne Can Scro oug To navigate forwards through the form just press the lt NEXT FIELD gt ke the display with the left and To go right back through the form use lt PREUIOUS FIELD gt or lt PREVIOUS BLOCK gt To exit this help screen press lt ENTER gt J right cursor arrows but one S can also display the whole i rene field separately using the following procedure Australian Geological Survey Organisation 1995 8 PALEO DATABASE USERS MANUAL eee eoeeeeaeeseeoe8eeoesgs cdc d eoedoseeeeeee eee eee eo SE DE EE EE E E D E E O O O D O O o O O O O O O O e880 With the cursor in the truncated field gt Press lt Esc e gt edit see the whole field display
73. ou commit the record you get an error message that the record cannot be committed because of a duplicate value this normally means that the sample or specimen number you entered in the Refno field is already in the database When you are not sure that a sample or specimen number is new it pays to check before starting data entry query under Refno see p 9 Escape from the error is possible but will probably waste the effort you have put into typing all the data unless you are prepared to put a bit more effort into correcting its cause Procedure gt Press lt Alt F1 gt display error to see if the full error message is enlightening it is conceivable there is a different cause which can be easily rectified without loss of data gt If the cause is an existing duplicate record then go to the Refno field with lt End gt gt If you have been entering a set of records scroll back to see if the one you have just tried to commit is already there you may just have forgotten to change the Reference Number gt If you have forgotten to change the number do so and press lt F10 gt b If the second record is strictly a duplicate perhaps you lost track of what you had already done then make sure it is the one displayed press lt Alt F4 gt clear record and lt F10 gt to make sure everything is fixed If that doesn t work try lt Alt F6 gt delete record in place of lt Alt F4 gt and don t forget the lt F10 gt gt
74. ould appear on the screen following a command 7 Commands or specific actions are indicated by the symbol gt 8 The term record is used rather broadly to imply the sum of all available data for a single sample or specimen be that confined to one table or spread over many Australian Geological Survey Organisation 1995 1 PALEO DATABASE USER S MANUAL LOGIN PROCEDURES Logging into PALEO involves saying who you are username and that you are entitled to enter the system password There are separate passwords for the AV1iON and Oracle The AViiON password is case sensitive and cannot be simply alphabetic the Oracle password is not case sensitive and may be purely alphabetic or include other characters the only proviso being that the first character must be alphabetic The AVuON password also has to be changed periodically In the folowing guide to lo gin and logout procedures we will use as an example the identity of Dr Joseph Bloggs a temporary member of staff His username is jbloggs and he has set his passwords to dumb1 for the AViiON dumb for Oracle how to do this is shown in Appendix 1 1 Log in to AViiON DOS from the LAN prompt e g M gt enter menu see Main LAN menu select B Onshore network services see Netware utilities menu press f or g selects Login Avion for Oracle lan workplace according to whether the program is loaded on your C drive or the network server WINDOWS gt s
75. pecimen 4 where num nnn between nnn and nnn and acronym CPC F E and suffix string use the last phrase only where essential Note carefully where the round brackets start and finish the selection sub clause Note also that the first and last specimen numbers in a series are specified It is possible to specify several numbers amp or series of numbers by joining the phrases of the where clause with the word or g Where num 2786 or num 2880 or num between 2901 and 2925 For unregistered specimens and samples where there is no acronym this command does not apply Selecting on a range of numbers will therefore be very difficult as ORACLE and simular database systems order alphanumeric fields by first converting the letters to numbers following Australian Geological Survey Organisation 1995 36 PALEO DATABASE USER S MANUAL database systems order alphanumeric fields by first converting the letters to numbers following an agreed convention The results can be surprising For such specimens choose another selection criterion or update under Forms Mode Long commands If you put together a very long command it may exceed the allowed line length If that happens the command will be split in a relatively illogical way and without special treatment will not work To indicate that a very long command is continued on a second line without break insert a dash at the end of the
76. r becomes the old registered number the CPC number the new one For correctly entered records this is done automatically under Forms Menu Option 4 see pp 23 24 type status For published specimens to specify whether they are merely cited or figured or some sort of Type Follow the format in the help line configuration What the specimen looks like as an aid to finding it in our vast collections maturity Enter here the degree of maturity of the sample in terms as brief as possible without being cryptic Amoco TAI Thermal Alteration Index number or range according to the Amoco scheme CAI Conodont Alteration Index number or range Group Type here the informal name of the major taxonomic group e g brachiopod trilobite foram to which the taxon belongs For samples with many different taxa enter here a list of the groups that does mean wildcards must be used during querying but the solution to that problem would make the database quite unwieldy Australian Geological Survey Organisation 1995 15 PALEO DATABASE USER S MANUAL identified by on This refers to unpublished taxa and sheets home the responsibility for identifications Unfortunately it cannot cope with different people identifying different components of a sample at different times Such information will have to go in the general remarks field in SPECIMEN Abundance The four fields on this line have to do with various ways of expressing relat
77. r in full Examples would be 1879 March 1979 23 Nov Title You will be startled the first time you enter this field A separate enlarged window for data entry or update will appear gt Type the title of the article or book gt To exit the Title window and save new text or any changes to existing text therein press lt F10 gt to commit the data The cursor will then move to the next field Source Type in the Journal name or book publisher s name pagination etc i e the full bibliographic works Then lt F10 gt to commit all the data for the Form Australian Geological Survey Organisation 1995 19 PALEO DATABASE USER S MANUAL PUBLISHEDIN Citation Details TABLES MENU OPTION 9 CITATION DETAILS Publication No 12 ARCHBOLD Studies on Western Australian Perrian brachiopods b b The 98 3 97 119 a Strophalosia King 1844 Heteralosia Kin Proceedings of the Royal Society of Victor Illustrations age No Registered No Publication No N Permian pes E of Western Australia Bure of ners ae ah te sue tnetane Bulletin 48 Illustrations rl 18 fige 15 16 pl 19 fig 1 age No Press lt EXIT gt to quit the form ount 2 lt Replace gt Again two records can be displayed for each the central part comprises trun cated display only fields from the PUBLICATION table displaying the author date title and source of the reference Help messages show how ill
78. rm did forthe Foraminiferida It differs in that the display fits fully on the screen and shows not form but conodont element name or code and population number Default entries editable are conodont in taxon and Nicoll R S in identified by The same procedures and comments apply as for the preceding option in both just follow the help messages on the bottom line Entry of Conodonts Enter the reference No and pres aaa i specimen No P2027 onte OEP LEOCT Sra Gao E OCT 92 enus species ubgenus subspecies elem ident hi TALS ey Icrioduse onodo atericrescens be Australian Geological Survey Organisation 1995 25 PALEO DATABASE USER S MANUAL PALYNOLOGICAL PROCESSING FORMS MENU OPTION 9 A composite Form a bie DATA ENTRY FOR PALYNOLOGY designed to record treatments pre Lerner en AA No suffix Ml Eea hmore Reef a1 CBF No used in processing samples Been for palynomorphs Ke eC Tusa A semustralia area A hard copy of re well nsheore 7 at ae es Miss S66 59 86 e66 72 etails z cords displayed in this Form TIT LOL Peet 88 OCT 93 ECT HUN pe re No 2p x 652 ERYS CY processes ist HCI HF ond whee can be produced using Cura ieve ZER OXY KOH VOM No of slides torial Reports Menu Option jaaten Beera check MTR other ar micropal box t 5 PalynologicalRegister KRASA E see pp 31 32 T Press lt EXIT gt to quit ount lt Replace gt
79. s a straight forward Form which can Nunher IMMIMME Collector Collected zm display four records at a time MUIA Dent Mines Energ Acquired To each new record the AAG collector Collected a3 fcavived Ain computer automatically j emer SAIN Collector c Reeg assigns a unique noe So 255 collector donor number You are starting in QUERY mode placed in the colldnrno field Query on collector donor or date Scroll to the required entry Cif found gt To carry the required info across exit this form with NEAT PRIMARY aie The fields are obvious To add a new record use lt EXIT gt lt INSERT RECORD and finally lt COMRIT gt Press SEXIT gt lt EXIT gt to quit this forn but note that the date 18 best entered with the year in full first As explained in the help panel the Form is programmed to be accessed in Query Mode The message assumes you have entered from another Form so if you have come from the Menu ignore the comments on carrying information across or you will get an error message AGE TABLES MENU OPTION 3 This Form displays age Reg a No TENETE Nalacozoic n OOP data for two records on one eee iy Permian screen The peculiarities of a pines the various fields have already Tertiary letten ocase been described for the Devonian PALENTRY Form see p 16 Remember Reg d No Tertiary letter stage Datem may be a sample number Ta catalogue number including the acronym Austral
80. s follows ICZN Recommendation 22A For junior synonyms enclose both author and date in brackets thus BLOW 1959 This follows ICZN Recommendation 22B cf and aff should NOT be preceded by sp A query is placed after the item it refers to If the whole identification is uncertain this is conventionally printed as A us b us but in the database enter it as A us b us The format for un named species is sp sp indet or sp A do not use sp ind and restrict sp undet to material which you are confident will be identified in the not too distant future or for quoting from publications Australian Geological Survey Organisation 1995 20 PALEO DATABASE USER S MANUAL e ee0e eeeeeeeeeeeeeeeW eaeeee ee eee 8 8 8 8 In the case of gen indet ambiguity or problems if there are several such in the same paper can only be avoided by specifying in the genus field the formal name of the next higher definite taxonomic category be that Family or even Phylum thus Cyrtinidae gen indet Agnostina gen indet etc Authorship of un named species is the authorship and date of the paper in which they first appear This is very important to avoid possible ambiguities Should a published un named species be referred to subsequently but placed in a different genus it helps to append the name of the second authority after a semi colon thus sp JONES 1969
81. se is there This wildcard can be anywhere relative to the specified string including separating strings and more than one can be used within a field It can be used without a string as a way of retrieving all records with data in a particular field except in this case it will also retrieve records with no text where the is placed Thus in a field will retrieve all records with data in that field text string will retrieve only records in which the typed text is at the end of the field Note that putting a wildcard at the start makes retrieval noticeably slower text string will retrieve only records in which the typed text starts the field text string 1 text string 2 will retrieve records starting with text string 1 and subsequently containing text string 2 text string will retrieve all records containing the typed text and so is the more reliable form of query when you aren t sure how data have been entered except that the typed text will still be sought as an exact match case and all Again the initial makes retrieval slower Australian Geological Survey Organisation 1995 45 PALEO DATABASE USER S MANUAL Examples 1 Permian will retrieve Early Permian but not Permian Early Perm will retrieve both 2 CPCi2__ two underlined spaces in the Refno field will retrieve all records of CPC specimens in the twelve hundreds plus all those in the twelve thousands and so on More usefully it will retrieve speci
82. ted for insertion in an Excel spreadsheet see pp 31 32 7 Conodont labels for CPC specimens A file is produced which suitably processed will produce a master for making conodont slide labels specifically for CPC specimens see pp 32 33 8 Foram labels As for Option 7 but designed for unpublished foraminiferan slides see p 33 9 Foram labels for CPC specimens As for Option 8 but specifically for CPC specimens see pp 32 33 10 Go temporarily into Unix The same option as in the Catalogue Reports Menu see above Return to the Curatorial Reports Menu by entering exit SQL Plus Option 5 runs the command driven system for accessing information in databases It can be used for any AGSO public database not just PALEO e g it can be used to obtain latitude and longitude for wells registered in PEDIN For examples on how SQL Plus can be used see chapter 8 in AGSO Record 1993 81 referred to above For further discussion see pp 34 38 FORMS FOR INDIVIDUAL TABLES This menu entered from Option 8 in the Forms Menu is designed to give direct access to tables including lookup tables most of which are otherwise accessed from other Forms such as PALENTRY see the Forms Menu above It actually has 14 options although only 10 can be displayed at once Use the up or down cursor keys to see the rest yes you can go backwards through the menu it acts as a continuous loop The various options and the pages on which
83. the last record when only the one arrow will remain beyond that the form is empty With the cursor in another block you cannot scroll through successive full records but In the IDENTIFICATION and PUBLICATION blocks in both Forms the former is headed FOSSIL it is possible to have several entries for each main record In IDENTIFICATION this may be several taxa from a sample or successive names applied to the same specimen In PUBLICATION there may be several papers citing the sample or specimen two can be displayed at once in both Forms on successive lines To check whether there are undisplayed taxa or publications for a particular record move the cursor to the appropriate block If there are more records waiting to be displayed a down arrow will reappear in the message line Scroll through to examine Access to linked Forms From both Forms it is possible to move to individual Forms which can display additional information To which and from where in the Form is discussed for each in turn The details of how to do it are given under Moving between Forms on p 43 DATA ENTRY Single sample Reference Number When you enter the Form the cursor will appear in the first field acronym This and the next two fields are combined to form the fourth field which the database system knows as Refno short for Reference Number This is a key field which holds together the components of a record Because of this data MUST
84. umber geological basin or province period There are two display only fields Genus and species The Form can also be used to find out what is in a specific storage location Form for query only Specimen No 8x60 RIP E brachiopod Species eicherti Ue Carnarvon Basin o Periods STORAGE DETAILS Building Cahinet dyauer Other Area Date Last Checked Remarks The Form is in Query Mode when accessed for procedures see pp 44 45 and because of its underlying construction cannot be used for data entry or updating Moreover because it acts as though it were displaying only one table movement is only with either lt Enter gt or lt Ctrl h gt It is possible to retrieve on any except the display only fields but retrieval except by specimen number can be rather slow So if at all appropriate put at least part of a specimen or sample number in Refno remember the Wildcard as a query condition Unfortunately a simple by itself will not help Australian Geological Survey Organisation 1995 27 PALEO DATABASE USER S MANUAL REPORTS Two Menus opened from the Main Menu give access to a variety of Report programs Of these the first Menu Option 3 Catalogue Reports has to do with the production of catalogues for selected parts of the Commonwealth Palaeontological Collection A separate short manual is available from the Curator for these programs As they will only be of use to someone producing a catalogue they
85. uplicate record this step is vital do not change the displayed data until you have done it or you will simply change the original record gt Now edit the displayed duplicate including the sample number If only the sample number is to change then be sure to press lt Enter gt to move beyond the Refno field gt Press lt F10 gt commit gt Repeat for all the samples gt Press lt Alt F10 gt cancel exit to return to the original composite Form gt Move to the next section of that Form with lt Home gt The original record remains displayed there gt Repeat the above procedure and continue doing so until all data have been entered Many records involving duplication If you have more records than can comfortably be entered at a single sitting there are two tactics possible both involving the use of Query Mode 1 Use the above method but keep careful track of the stage you have reached at the end of each session At the beginning of the next session start by using Query Mode to once more display the first record then move within the composite Form to the appropriate block and proceed as above 2 Enter the first record in full but then instead of working through INITENTRY or PALENTRY return to the Forms Menu select the Tables Menu option and use the individual Forms Within each enter a Query to display the original record then proceed just as above Again it is important to keep track of what you have do
86. ustration and citation data should be typed please follow them _ SPECIES TABLES MENU OPTION 10 A single record Form entered in Query Mode see previous comments the cursor alighting in the Genus SPECI ES SiN Brachiopoda Scrophonenida p tacea Press Seer gr eae to quit this forn field Most of the fields sungente d should be obvious and have Species author ATERHOUSE 1978 been chosen after consultation J to reflect the most widely used DOSE oll to correct entry Cif fo To carry the required info Cross suprageneric categories form with lt NEXT PRIMARY KEY gt To add a new record use CEKIT ZINSERT RECORDS and finally lt COMMIT gt ount 1 lt Replace gt It is important that the classification be recorded if necessary with comments on whose classification is being followed although normally the Treatise on Invertebrate Paleontology is the standard That way taxonomic research can be assisted by being able to determine what related material for a particular taxon we have in our collections Other category is for entering taxonomic categories not specifically catered for spell out what the category is Species author For reasons given below it is important that a standard format be followed Capitalisation is automatic so need not be of concern it helps for reliable searching The author s name is followed by a comma and a space thus BLOW 1959 Thi
87. want to experiment it can be a good way to do that and yet avoid affecting the database Data updating Updating means both correcting errors made during data entry and adding to the information already entered The unifying assumption is that you want to change an existing record and the basic system is quite straightforward Procedure Display a record to be updated using Query Mode see next item gt go to the field or fields to be changed see Cursor control above gt make the appropriate changes to each field see Text control above gt commit with lt F10 gt Query Mode For retrieval and display of existing records the database must be given some information on which to select the wanted records and must be then told to go and find them To this end Australian Geological Survey Organisation 1995 44 PALEO DATABASE USER S MANUAL the Query program is run The program stops only when it retrieves one or more records or is cancelled Procedure Within the table to be queried gt press lt F7 gt enter query p move the cursor to the field in which you wish to type the data on which the computer will make its selection gt type in the data using wildcards see below if appropriate gt repeat for other fields if appropriate gt press lt F8 gt execute query If no records are retrieved the system stays in Query Mode and you will be asked to Re enter Either try again with a modified query
88. will not be dealt with in this more general manual A list of the Reports to be found under this Menu is given on p 6 The second Reports Menu Main Menu Option 4 is for Curatorial Reports curatorial being taken quite broadly The full list is found on p 6 PLEASE NOTE Ifyou are running a Report program several times in succession for different sets of specimens it is imperative that as each file is generated under the general name of the Report program plus the extension Hs it is renamed Each new file overwrites the previous file of the same name Renaming Report files gt Choose Catalogue Reports Menu Option 6 or Curatorial Reports Menu Option 10 This takes you to your working usually home directory operating under Unix see e not the full AViiON prompt gt To check the contents of your directory you can enter Is gt To rename a file e g the file epcrecs lis generated under Option 3 enter mv cpcrecs lis newfilename where newfilename is the new unique name of your choice gt To return to the Reports Menu enter exit CURATORIAL REPORTS MENU OPTION 2 Ordered list of all recorded specimens This runs completely automatically and produces a complete list of all CPC numbers held in the database The ASCII file palrefno lis is written to your AViiON home directory ready for transfer and printing after appropriate formatting CURATORIAL REPORTS MENU OPTION 3 Full data records for selected specimens

"user manual"

Contents

Download Pdf Manuals

Related Search

Related Contents

&quot;user manual&quot;

Contents

Download Pdf Manuals

Related Search

Related Contents

"user manual"