PDF manual - Ocean Drilling Program
Contents
1. and arc user_role urp granted_role Note This SQL statement counts the number of applica tions defined by the user s role privileges and then stores this value for later use in the program s choice mechanism 6 The next step requires the following SQL statement to be processed SELECT distinct o app_url 0 app_title FROM odp_apps app_role_connect arc user_role_privs WHERE arc app_name arc user_role urp granted_role 7 The results of the query are used as determined by the value obtained from the previ ous SQL statement the count of applications e If only one application is found the AEP program loads the current browser with the user s application running If more than one application is found a list of the applications is created as shown Ocean Drilling Program Precruise Name User s Manual 11 in Figure 5 the User Application Window Main document The user selects an application and the program loads a new browser window with the user s selected application 8 Anhtml form is created within the login cgi file to act as a wrapper for the information retrieved from the database e This wrapper includes the table Applications with their Descriptions and subtitles Application and Description e reference URL Uniform Resource Locator is hidden beneath the a2. THE USER S MANUAL Table of Contents Document Layout sas sees ees Starting 4455565554535 Accessing login window The Login window oes The User Application Window Precruise Names Application The Precruise Site Name Entry Window The Precruise Site Name Update Window Entering Information s 24 02csn tended Cee dk See ee Other Taforma ti n se seis ou hse are od ard Appendix Operation Overview Bri t Summary onesie Soret tee roast ye ne eee oie gees Operation Overview Dee aces see en eee oe es Table of Figures Figure 1 The Homepage 2 Figure 2 The Database Window of ODP 2 URGFOCAEP he Se here E 3 Figure 4 The Login window of AEP 3 Figure 5 The User Application Window 4 Figure 6 The Precruise Site Name Entry window 5 Figure 7 Precruise Site Name Up
3. Comments This information is usually entered during or after the cruise Ocean Drilling Program Precruise Name User s Manual 7 Entering Information 1 First enter a Precruise Site Name Each name must be unique for the leg specified If you add a duplicate name you will receive the a warning Use the Back key to return to the previous window and correct the error Next select the Priority Status This entry box has a dropdown list with four choices Alternate Added Once on site enter the Site Number This number is assigned by the ship s Operations Manager using the Janus interface to the database Note The program will not accept a number that does not already exist in the Janus Site table No error message occurs if a non existing number is used Instead the pro gram attempts to save the number cannot and the subse quent window does not display the value The next column Science Objective Obtained also has a dropdown list of available choices YES fs he If you entered NO for the Science Objective Obtained column you must also select an entry for the Cause for Failure column Select an option from the following dropdown list Allowed time expired Weather heaverice limits reached Drilling problems Other Substituted by site The final column is for Comments Enter a comment if you selected Other or Sub stituted by site from the Cause for Failur
4. Database Drilling Publications Science 8 Curation Cruise Info Staff Mirrors P ANUS Database SCIENCE OPERATOR Database Overview Predefined Queries Moratorium Access SQL Queries Paleontology Data Policy Data Librarian Logging Database LDEO Ocean Drilling Program JANUS Web Leg Evaluation Precruise Site JANUS Web provides access to ODP s Oracle relational Editor database JANUS The database contains over 300 tables of ODP s marine geoscience data that are collected onboard the Resolution The database includes paleontological lithostratigraphic chemical physical Figure 2 The Database Window of ODP Ocean Drilling Program Precruise Name User s Manual 3 OR 2 Type in janusaxp tamu edu odp login login htm if Netscape does not open to the ODP homepage See Figure 3 Click Enter This opens the Login window 2 sd Back Fonverd Reload Home Search Netscape Print Security Bookmarks Netsite http janusaxp tamu edu odp login login htm Instant Message WebMail Contact People Yellow Pages Figure 3 URL for The Login window Login Welcome to the Ocean Drilling Program s Applications login In order to assure quick access point The login will enable us to identify you and thus provide a list of applications that you problems please contact us using the e mail address found below Thank you Plea
5. as cookies on the client machine e The cookie values are sent via the Post method to the server where the login cgi file parses the stdin stream input and obtains values as strings e The string values are then concatenated into a single connection string that is used to log onto the ODP database Ocean Drilling Program Precruise Name User s Manual 10 3 At the same time applogon log is opened The following values are appended to the log file user name date and time of login host machine name of the user and the IP address of the host machine This information is retained for security reasons It can be used to ascertain illegal attempts to access the database by non privileged users e If this file cannot be opened the program is aborted and the user is advised to con tact the database administrator 4 The program then logs onto the database using the connection string created in the ear lier concatenation process e The login procedure begins by using a database maintenance login name e If this fails the following characters are concatenated to the connect string 1 This represents a user login name The database login is once more attempted 5 If the login is successful the following SQL Structured Query Language statement 15 processed SELECT count distinct e FROM odp_appso app_role_connect arc user_role_privs urp WHERE
6. date Window 6 Precruise Name User s Manual 1 Introduction Application Entry Point AEP is a World Wide Web WWW interface located on the Jan usaxp server This program allows database users to log onto the web and use applications related to their research interests Precruise Names is one of several applications in AEP This application assigns site names to proposed drill sites prior to the cruise leg All informa tion entered is saved to the central database Document Layout This document covers the login procedures and all subsequent user entry windows The appendix at the end gives an operation overview and is designed to aid both programmers and Marine Computer Specialists MCS Ocean Drilling Program Precruise Name User s Manual 2 Starting AEP Accessing the login window To access the Precruise Name application you must first log into the AEP system To do this start Netscape The login window can be accessed in two different ways Either 1 If your system is configured to open to the ODP homepage click on the Database prompt See Figure 1 Ocean Drilling Program Science Operator text version SEARCH Se DATABASE DRILLING PUBLICATIONS SCIENCE amp CURATION CRUISE INFORMATION Figure 1 The ODP Homepage This opens the Database window See Figure 2 Click Leg Evaluation to access the Login window ODP Search
7. e column or if you have any other com ments for the site Use the comments listed on the Precruise Site Name Update page The Comments entry can hold a maximum of 255 characters Ocean Drilling Program Precruise Name User s Manual 8 e Use the arrow keys to view the entire message 7 Finally be sure you click Save to save all information to the database If you make several errors click Reset Input and anything not saved to the database will be cleared Other Information 1 entry prompts are case insensitive 2 All information entered is tied to the Site and Leg tables in Janus If the site and leg information does not already exist in Janus those entered in the Precruise Names application cannot be saved to the database 3 Several of the entry prompts allow a limited number of characters Leg maximum of 5 numbers e Precruise Site Name maximum of 25 characters e Site Number maximum of 6 numbers Comments maximum of 255 characters Ocean Drilling Program User s Manual 9 Appendix Operation Overview Brief Summary Application Entry Point AEP is a World Wide Web WWW interface located on the Jan usaxp server and is used as the entry interface for ODP applications This program allows users to log onto the database through the web It also allows them access to applications related to their research interests The program g
8. eport Report of the cruise evaluation forms Precruise Names An application that ties pre cruise names with the actual drilled sites Please direct any questions comments or suggestions janusweb odp tamu edu Figure 5 The User Application Window 1 Click on Precruise Names to access the application 2 If you have questions about the applications to which you have or should have access to contact the system administrator Ocean Drilling Program Precruise Name User s Manual 5 Precruise Names Application This application is used to enter precruise site names into the Janus database The site names are then tied to their respective site numbers either during or after the cruise The Site Name Entry Window After clicking on Precruise Names the following window opens Precruise Site Name Entry This application is used to enter precruise site names into the after the cruise tie the site names with their respective site n Please Enter the Leg Number Leg Number Enter Number Clear Input Please direct any questions comments or suggestions to JanusWeb odp tamu edu Figure 6 The Precruise Site Name Entry window 1 Enter the Leg Number in the entry blank This leg number must already exist in the Janus Leg table If you try to save a site name into a leg that does not exist in Janus you will receive a warning Use the Back key to return to the
9. ives a degree of database security by requir ing a Username Password and Database Name These are compared to the user s privileges and any matches appear as a list of accessible applications If only one match is found the application is directly loaded into the current browser window If more than one application is found the user selects from the list and the application is loaded into a new browser window The Precruise Name application is located at janusaxp odp precruise login htm Operation Overview 1 The AEP program requires two source files A C source login c and An HTML source login htm These files are located in the usr web cgi srce db_maint login directory The web files are located in the usr web htdocs db_maint_test login directory It includes login cgi login htm and a log file applogin log e There is an index htm file the same directory as the default file for this web site It is a duplicate of the login htm file This adds to site security by forcing the user into the html document and excluding their access to a listing of the other files located at this site 2 Logging onto the site janusaxp tamu edu odp login login htm opens the Login Window in Figure 4 main document e This is the form created by the login htm file and duplicated in the index htm file The user enters the requested values into the three fields USERNAME PASS WORD and HOSTNAME which are saved
10. pplication names Click on the name to load a new browser window with a page from the application URL address site Ocean Drilling Program
11. previous window and correct the error 2 Either click Enter Number to create the next window or Clear Input to enter a dif ferent leg number Ocean Drilling Program Precruise Name User s Manual 6 The Site Name Update Window Enter all information that is to be saved to the database in this window Precruise Site Name Update Number of site names found for leg 171 2 Save Reset Input The comment box should include or a combination of the following comments cannot be more than 255 characters in length Allowed Time Expired WeatherfHeave Ice Limits Reached Drilling Problems Substituted By Site Added Site Other Save your data before exiting this site PLANNING OPERATION Science Objective Comments Obtained DWIGHTTEST Primary x 1044 YES GILTEST Alternate 1053 YES Figure 7 The Precruise Site Name Update Window Precruise Priority Site Site Name Status Number 1 Notice that the number of site names found for the requested leg is displayed in the top left The message There were no records found for leg XXX appears the first time you enter information for a leg 2 Planning has two columns Precruise Site Name Priority Status This infor mation is normally entered prior to the cruise 3 Operation has four columns Site Number Science Objective Obtained Cause for Failure and
12. se login USERNAME 7 PASSWORD sits HOSTNAME 7 Login Clear Input Figure 4 The Login window of 1 Enter your Username Password and Hostname in the appropriate entry boxes Use the mouse or the Tab key to move through the entry boxes 2 The program uses this information for identification and to create a list of applications that you can access Click Login to continue or Clear Input to clear the login information 4 If you have any questions comments or suggestions email the address at the bottom of the screen JanusWeb odp tamu edu If the browser is properly configured click ing on the address automatically opens an email form Ocean Drilling Program Precruise Name User s Manual 4 The Application Window The AEP program creates a list of applications to which you have access based on your User name and Password Figure 5 is an example window You may not have access to all the appli cations that are listed here Note If you have access to only one application it is auto matically opened in the current browser window User Application Selections The following applications are those indicated by your current listed privileges If you require othe Applications with their descriptions Application Description Cruise Evaluation Form to evaluate recent cruise experience Cruse Evaluation Editor Editor for the Cruise Evaluation software Cruse Evaluation R
Download Pdf Manuals
Related Search