Logging In
Contents
1. just submitted by clicking on the appropriate links at the right hand side of the table 102. link and confirm that you really want to delete the displayed record and it would be deleted forever Once deleted records cannot be recovered anymore Instead of deleting the record you may want to update the information contained in it Such can be easily accomplished by using the Edit link discussed earlier 2011 Issue Confirmation Database County Level Delete Delete this record Community and Economic Development IssueTitle Public School Education NoParicipants O O OOOO o O Database Menu Several items made up the database menu Exit Issue ID Report Generator Reset Print ExportToExcel and Add New Record This menu is depicted in the screen capture above 2 row from top of the table Details about each menu item follows 1 Exit Click this link when you want to log off the database 2 Report Generator Data including records in databases are only useful when the metrics in them get analyzed for trends and or use for comparisons This is where Report Generator RG comes in RG is nothing but a simple web form that harvests specific user requests using various form elements such as text boxes option buttons pull down menus and checkboxes The requests are then forwarded to a program that retrieves all records satisfying the specified criteria The same or another program crunches the numbers associated with each record which then generates statistics useful in translating the crunched numbers to unde
3. ISSUE IDENTIFICATION and EPC DATABASE USER S MANUAL By J Rey Santos Updated 01 19 2012 Software Development Group Texas Agrilife Information Technology System Requirements The ISSUE ID and EPC Database web sites use cookies JavaScript ASP and SAS technologies to process the information submitted to the system It uses session variables also known as cookies to keep track of submitted information as they move from page to page JavaScript checks that the information provided is in the format that 1s expected It also ensures and gives reminders as appropriate that required check boxes and or option buttons are not skipped before the data get submitted and processed ASP grabs the information from the submitted form and posts them in the database ASP is the engine that executes actions invoked by the clickable menu links inside the ISSUE ID EPC Database Systems SAS in turn pulls out the numbers and string data from the database and processed them according to the option s you have selected from the Report Generator menu It is important that the following system requirements are satisfied to ensure enhanced browsing experience 1 You must use Internet Explorer IE 8 0 or better as your browser Although the applications may run using other browsers these applications have been tested and proved to work with IE without any problem 2 Cookies must be enabled in your browser Check here if the cookie option is enabled in this
4. RTANT NOTE TO USERS This system uses session variables also known as cookies to keep track of the information you entered as you move from page to page Please make sure to turn on the cookie option of your browser to take advantage of Issue ID Database System s full capabilities We highly recommend the use of Internet Explorer 8 0 or better to minimize timeout graphics and cookie related problems Check here if the cookie option is enabled in this browser Please click here for instruction on enabling cookies Please contact Rey Santos for technical problems questions all content related questions to Dr Jeff Ripley The log in panel has several options Remember me If you checked the box associated with this option the system would remember your User ID and password the next time you log in It would pre fill the two log in boxes for you thus saving you time and possible headache Change Password At any time that you feel a need to change your existing password click on this link You are expected to know your current password in order to use this feature Lost Password In the event that you forgot your password you can click this link which would prompt you for your registered email address in the system After verification that the email address you provided matches one in the system it would send you your password that you can use for logging in Admin If available this link is for authori
5. al Resources 6 Staocking Rates education Newissue 10 4 26 2011 4 26 2011 P m valde Ag and Natural Resources 7 Predator control Education Currently 10 4 26 2011 4 26 2011 addressing Uvalde Ag and Natural Resources Evaluating new Agriculture Chemicals Newissue 0 4 26 2011 Ag and Natural Resources Lack of Crop variety like to see more 4 26 2011 test plots alde Community and Economic 2 Transportation 4 4 26 2011 Development Uvalde Youth Development 6 dob Skills Newissue 4262011 Ji alde Community and Economic 4 unemployment 4 4 26 2011 Development Ag and Natural Resources Water Conservation includ absentee Currently landowners addressing Clicking the OK Print Page s button will route the output to your printer for a hard copy printout 6 ExportToExcel Displays and allows saving of table as an MS Excel file When prompted where to save the file to point to a directory or a disk drive and then choose a name for the file using xls as the extension Click on Save Windows Internet Explorer What do you want to do with GenericListCSV xls Type Microsoft Excel 2003 From eit data tamu edu gt Open The file wont be saved automatically gt Save gt Save as 8 dB Help This invokes a page containing Issue ID EPC Database User s Help Page see screen capture below The Help page essentially provides the user some information on how to navigate the database sy
6. bility or assignment You would not be able to access the database if you skip this step Exit the user registration database after entering the information which would bring you to the log in panel of the Issue ID Database From the log in panel you would have the option link to go the EPC Database and to other features such as retrieving lost passwords or changing passwords NOTE If you want your User ID and password to be remembered by the system just check the Remember me check box before logging in The system would pre fill your User ID and password the next time you log in On successful log in and depending upon your access mode role a list of records will be displayed with view edit and delete links at the right hand side of each record Visibility of each link depends upon your role or access mode Use the view link to display a selected record the edit link to display and edit all or some of the fields within a record and the delete link to erase the record It is by design that both Issue ID and EPC web sites share the same user and admin databases for ease of use and administration The Database The database contains rows that represent all the records entered in the database It also has columns each of which stands for every distinct metric variable related to each record Usually there are several variables columns associated with each record row On successful log in the system would display a compl
7. browser Please click here for instruction on enabling cookies 3 Scripting JavaScript must be enabled in your browser Please consult http support microsoft com gp howtoscript on how to enable scripting in your browser Logging In As in other web sites that contain proprietary information the ISSUE ID and EPC Database systems require each user to log in using a User ID email address and a password before he she can enter any data or view the database As an added precaution the system uses an SSL protected web site so user entered information gets encrypted as it passes from the workstation to the server Initially all users would be issued a one time use password by the Project Coordinator so they can log in to the system after which they would be required to change them to another one that conforms to a high level of security As you enter a new password using the Change Password option the system would let you know if your proposed password had passed its security screening or not It would only let you submit passwords that conform to its pre programmed security policy minimum of 8 characters one uppercase letter and 1 number Below is a screen capture of the log in panel ISSUE IDENTIFICATION DATABASE LOGIN User ID Email isantos tamuedu i Password coceeecocccce Remember me AMS 2 rS Coq Lost Password Change Password Be ee eee E EPC Database Update Login IMPO
8. ete listing of all the records submitted to the system from each geographical location below shows county level records 2011 Issue Confirmation Database Coun 7 7 B 2011 Issue Confirmation Database Coun ylevel i esss lt swsSS oe i i Uvalde Community and Economic Developme 3 Public School Education Newissue 4 ew Edit Delete Uvalde AgandNaturalResources 5 Funding to Maintain E T network sss Newissue 10 4 26 2011 4 26 20 ew Edit Delete Uvalde Youth Developme 1 Teen Drinking New issue Uvalde Youth Developme 3 Drug use New issue 4 26 2011 View dit Delete Uvalde Youth Developme 5 Obesity Problems Newissue 00 iew Edit Delete Sorting By default the database is sorted alphabetically A to Z by a column named County You can also sort the database using other column and you do it by clicking on the header of the column that you want to sort by Conversely clicking the same column header the second time reverses the sorting order of the records Z to A Basic Database Operations There are three basic operations that you can use to manipulate records within the database View Edit and Delete A user accesses any of these operations by clicking on the appropriate link located at the right hand side of each record in the displayed table The following describes each of the operation l View Record This link allows the user to retrieve and view individual records from the database To edit any info
9. lect the appropriate response by clicking on the option button for the desired operation The user should also select an item from the pull down menu located immediately below within the same column the option button that was selected earlier Should the user wants to retrieve reports based on specific keywords RG also provides a text box to capture those keywords which are then passed to the program that use them to screen and further whittle down the number of records that gets retrieved An option to generate reports in RTF format is provided for convenience in exporting the report output to any word processing application 3 Reset Restores table view configuration existing prior to a search or order by operations 4 Refresh Triggers an internal procedure which implements another view request The new view includes the newly entered edited data and or the remaining records after one or several records had been deleted from the database 5 Print This option opens up a window that allows for the selection of the number of records to print It also provides a way to include exclude variables columns from the table before printing Check the box of the variable that you want to include and uncheck the box for the variable that you want to exclude see sample Print menu below If you plan to print a table with many columns it may be necessary to adjust paper orientation using your browser s Print menu to landscape mode Selecting a ra
10. nge of records to print Physically count the starting row and ending row of the range that you want to print and enter those row numbers in the record range selection boxes of the print menu Use Ctrl P to print the selected range You also have the option to print a table using your browser s Print feature setting the paper orientation mode and margins as appropriate 2011 Issue Confirmation Database County Level Print 2011 Issue Confirmation Database County Level All Records Records 1 to 22 Issue Title m Status m No Participants Date Posted Date Updated NOTE Check only the fields that you want printed When printing you may need to adjust to landscape mode if table width spans wider than that of portrait mode After the Print settings have been configured clicking the Next button will bring up a ready to print page similar to the following ql 2011 Issue Confirmation Database County Level Uvalde Community and Economic 3 Public School Education Development 4 4 26 2011 ee Uvalde Ag and Natural Resources 2 Wildlife damage Newissue 100 4 26 2011 4 26 2011 Uvalde Ag and Natural Resources __3 Input cost Fuel labor feed stc Newissue 104 2612011 4 26 2011 Uvalde Ag and Natural Resources 4 Drought Tolerant Crops Newissue 10426 2011 42612011 Uvalde Ag and Natural Resources __5 Funding to Maintain E T network Newissue 10 4 26 2011 alde Ag and Natur
11. rmation within the displayed record click on the Edit link located at the top menu 2011 Issue Confirmation Database County Level View 3 ai 2Z 2 D Public School Education ew Issue Edit Record Clicking this link would pull out all the existing record s of your OWN county district or region Once the record s is are displayed and listed you have the option to view edit or delete any of the records If the table is too wide you may need to scroll to the right hand side of the table to see the editing options view edit and delete available to you Each of these options is an active link that you can click to perform the operation that you want Below is the record listing under Edit mode The Edit Record panel for the EPC database will be slightly different but similar to the one shown below 2011 Issue Confirmation Database County Level Edit Back To List Update Community and Economic Development Pu blic School Education No Pariopens Date Posted 4 26 2011 Date Updated O OO Update Once you are satisfied with the changes you had made click on the Update button to save the edited record 3 Delete Data When record gets outdated and information in it turns stale it is time for it to be deleted or updated A Delete link is provided dedicated to eliminating unwanted record s Just click on the
12. rstandable layman s language Below is a screen capture of Issue ID s Report Generator 2011 Issue Confirmation Report Generator Using the option button dick your preferred geographical location and then select a specific item from the drop down menu Submit to generate report specific to your OWN county district or region PO ianrecenscorts County District Region State Program Area Issue Status a a Ag and Natural Resources Completed Anderson Central 8 East Agriculture and Natural Resources Currently addressing Andrews Coastal Bend 11 North v Community and Economic Development New issue Angelina East 5 South Families and Health Not yet started Aransas v Far West 6 West Youth Development Keyword search within Program Areas optional enter word or phrase _ The search module above does exact matches only For example to search for water conservation just enter water conservation or water conserv No records will be returned if water conservation were entered instead Search is not case sensitive Another quality work by the Software Development Group Agrilife Information Technology RG allows the user to select the geographical entity county district region or state for which reports will be generated for Alternatively reports can also be produced based on Program Area or Issue Status Regardless of what type of reports gets requested a user should se
13. stem pages using the various links and options available on each page gt https eit data tamu edu IssueID gendb GenericHelp html Internet Explorer prov X Issue ID and EPC Database User s Help Page To view edit and delete records These modes can be accessed by scrolling to the right hand column s of the table Click on the appropriate link to execute the procedure MENU OPTIONS Advanced Search When enabled this option displays a form containing some or all variables in the database table Each variable has an associated pull down menu The user clicks to select an option under a variable which may be combined with option s from other variables When the search button is clicked all options selected from some or all variables will constitute a single query like string that would select and display all records that satisfy the criteria contained therein You can only search for text string and memo entries 4 tt 7 Add New Record Displays the ISSUEID s Add New Record Form screen capture below that you can submit after providing some information The Add New Record Form for the EPC database will be slightly different but similar to the one shown below 2011 Issue Confirmation Database County Level Edit After submitting the Add New Record form all the records in the database will be displayed including the one that was just added You ll have the option to review and edit the record you
14. zed web site and system administrator s use only This is the place where administrators can add modify and or delete users of the system New User Registration All CEA level users MUST register using the New User Registration form District regional and statewide level administrators have an initial password of xxxxxxxxxx to be assigned by the Project Coordinator On login the system would tell them that the password has expired so they would be forced to change password Strong password policy similar to that of TExAS will be enforced with the following requirements a All User ID email must contain tamu edu domain extension turned off b Minimum 8 characters combined letters number and special characters c No of numeric digits 1 d At least 1 capital letter e At least 1 special character amp _ turned off f No maximum length required g Required 6 months password renewal email notification will be sent several days before expiration EPC Issue ID New User Registration User ID Email Password Min 1 Number min 1 Alpha Upper char min 8 chars Password Policy Confirm Password Verifies the re entered password as identical with first Reset On successful registration a confirmation page would be displayed Click on the button labeled Provide county credentials Exit Close Browser to provide your role position and county district or regional responsi
Download Pdf Manuals
Related Search