Documentation - PABRA Database
Contents
1. x TABULATE Temperature Moderate 15 to 24 Degrees Celicius Plant Type Typellb Bush indeterminate erect branches Size Large Colour Cream Biege Shape Kidney Coat Pattern Speckled F Local Name PAN148 Year Of Release 1950 Local Name PAN 127 Year Of Release 1990 Local Name EMELENI Year Of Release 1990 Figure 4 Summary of breeding search functionality Breeding search section a user can more than 1 parameter eg Year of release from to Year of release to On clicking search the result will be Part of the varie after searching for specific parameter as explained Param 1 Official Name z Param 3 5 way tabulation TABULATE parameter options Official Name PAN148 Country ZIMBABWE Official Name PAN 127 Country ZIMBABWE Official Name PAN 181 Country SOUTH AFRICA Official Name PAN 182 Country SOUTH AFRICA Official Name PAN 148 Country SOUTH AFRICA Official Name PAN 128 Country SOUTH AFRICA Figure 5 Breeding tabulation example Param 2 Shape elect Parameter gt Select Parameter a mili 100 Seed Category Altitude Coat Pattern Color Constraints1 Constraints2 Constraints3 Local Nac onstraints4 Year Of Constraints5 Country Local Haay To Maturity Gene Pool Year Of ocal Name Official Name Local NaPlant Type Year of Purpose Of Release Rainfall Shape Size m Local Na Local Name N A Year Of2. Kewenca P O Box 6247 Kempele rmo org Pan African Sean Research Alliance PASRA Internasonsl Center for Tropical Acric sture CIAT c o Natonal Agricstural Research Laboratories Kewanca P O Box 6247 Kemeeis Ugence wn Sot Sr er on veren DEE BMIe org Fer Site design and development Contact Akinnola N Akintunde Assoc Prof of informatics Faculty of ComputerTechnology and Engineering international Block Sea University No 2 13Km O Aghmashenebel Alley Toilisi Georgio Emmail aotintunde iesu edu ge ond Innocent Obilil Detebese Manager Pan African Bean Research Allience PABRA International Center for Tropical Agriculture CAT C O Nations Agricultural Research Laboratories Kawanda P O Box 6247 Kampals Uganda Ernail iobiScgior org Figure 13 the contact us page 3 4 About Us The about us page provides a highlight of what the PABRA network is all about it also gives an overview of the rationale behind the database Persons institutions that have been instrumental in providing information for the database are acknowledged in this section A supporting African Map showing all these Countries are displayed Pease note that Maps relating to the individuals Countries are displayed when the Country tabs are clicked along with the primary tabs information like Breeding Seed Systems ICM etc 3 5 Help Clicking help provides an online link to this document This allows you to make an online reference t
3. Release 1994 Local Name MONATI Year Of Release 1995 aa arra Parameter Values used in tabulation 2 2 Seed Systems The Seed systems interface provides database on seed production and supply It provides comprehensive information about the Variety official name seed class partners involved in the distribution partner type quantity supplied and produced year of supply and production the beneficiaries bag sizes and other relevant information The seed systems interface resembles the breeding one in that the Search Tabulation and parameter selection operate the same way References and examples to this section will be drawn from illustrations provided in the breeding section above only instances of seed system unique operations will be fully explained illustrated in this section Using the url http database pabra africa org one can be able to access the database if an internet connection is available Click the seed system tab on the top menu to access the seed system information page the seed system page with a generic layout as explained in figure 3 will be displayed with summary information The figure 6 below shows a summary of the seed system page To search for specific information select the desred parameters and click on the search button the results of your search will be populated and displayed in the result section see figure 4 for example To search based on a specific country select the desired countr
4. authorized individuals with the proper administrative access to the online database where information are sored 1 1 Structure of this manual This manual has been structured according to the key thematic areas of Breeding Seed Systems Integrated Crop Management ICM Capacity Building Nutrition and marketing other important tabs include Reports and Others admin and contact In each of these sections the manual will highlight how the user can be able to access views query and populate information resdent in the database Some sections will have links to external stes that provide additional information to what we have in the database 1 2 General Layout of database The database has been structures into 2 distinct layouts the back end that is restricted to authorized users and the front end that this manual explains and illustrates The table below gives a summary of the major layout features of the database Front end Please make reference to Figure 1 Section Description Summary functions 1 Left Navigation Panel This section contains country specific navigation options It also PABRA regional groupings ECABREN SABREN and WECA BREN This allows a user to be able to navigate for information based on a country of interest as opposed to the general General data information is got by clicking the home tab 2 Top Menu Is arranged according to the thematic areas it also includes the ot
5. ARCH database Param 1 Select Parameter Param 2 Select Parameter 5 way tabulation user Param 3 Select Parameter Param 4 Select Parameter can select parameters Param 5 Select Parameter Min 3 and on clicking tabulate the TABULATE option to excel or PDF Product Name Bean Based Bites Product Type Snack Detailed results after Year of clicking the button Product Detalls search are shown as Product es Variety Official Name Variety Local Name 1Z0201245 INAMUNIHIRE Product RUHORORO Country Name nen with more details Year of Dissemination Method Number of Beneficiaries Training and Demostrations N A Figure 3 Summary layout of pages 1 4 Summary of General and page layout s The interfaces shows a lig of African countries in the network to the extreme left and some search parameter boxes next to the African continent s map The search parameters allows users to filter their search based on criteria s chosen specified in the search boxes And should you choose to select a Country in the left pane the displayed information is limited to that Country alone Equally so the total count will change to another value specific to the country of choice 2 Navigating through the database This section provides a detailed explanation how a user can access each of the pages and be able to navigate the database for data as well as exporting data for further manipulation 2 1 Breeding Under the breeding the user can see severa
6. PABRA DATABASE http database _pabra afnca ora 7iocation help For futhur help visit http database_pabra afnca org 7location contact 1 Introduction This manual provides a step by step approach to the features and use of the web ste for relevant information retrieval We assume that the user has the Link http database pabra africa org so when the user opens the webste the following window appears with sub menu buttons which give access to all routines in the ste and these are divided into several sections which include Home Breeding Seed Systems Integrated Crop Management ICM Capacity Building Nutrition Reports Marketing Others admin and contact about us and Help Below is the digolayed image of the home page ve EES nn qn Alrica Bean jn c NARBL 53 3 as NABE 21 GM 7 v Characteristics EG a U Marketctass quality e Kanyebwa type Highly Palatable Medium seeded 36 g 100 seeds Oval seed shape Good seed colour Dirty yellow with red tan mottled Maturity 58 70 days Yield 1500 2000 kg ha m4 Bush type determinate ALL COUNTRIES Ba a bush ANGOLA b at s al en Tolerant to anthracnose BURKINA FASO BURUNDI CAMEROON CONGO BRAZZAVILLE D R CONGO EASTERN CONGO Allis well Figure 1 Home page of the PABRA database Displayed image of the home page The displayed perpetual flicking image on the home page center can be replaced with other images by
7. and export it to either excel or PDF Note To be able to use this a user must be able to provide a minimum of 3 parameters selections The Figure 5 illustrated some of the functionality explained below e Select at least 3 parameters from the list provided e click the button tabulate this will run your search query and e provide an option to either export to excel or POF e Options of either open or save will be given on the pop up the option open will open the file using the either excel or PDF choice you made and save will prompt the user to select a location they want the files to be saved to ome in send Sytems ro capac Building nuttin Repo Marking Others About Hal Detailed information from the search result Clicking on the highlighted yellow section will give this Seed Details Altitude High gt 1500 m a s Rainfall 500 to 800 mm Days to Maturity 110 100 Seed Category More than 40grams 100 Seed Weight N A Source Name Private Search Total count 31 Official Name Local Name Variety Source PAN Year of Release from Year of Release to Akitude Select yes Sety Temperature Rainfall Growth Habit Day To Maturity from Day To Maturity to 100 Seed Category Seed Color Coat Pattern Seed Shape Seed Size Constraint Stress Label Gene Pool Purpose Of Release SEARCH Param 1 Official Name Param 2 Dep Param 3 ae Param 4 Select Parameter Param 5 Select Parameter
8. grouped together these 2 aspects have linkage to the breeding information Products developed are linked to a bean variety that has been developed and promoted in the PABRA network Hovering your mouse cursor over the nutrition tab will show a dropdown menu for products giving the user an option to select either of the 2 depending on the area of interest Note Section 2 1 to 2 4 present a detailed account on how to access and navigate along pages of interest those steps to apply to Nutrition and products pages SSS PRN vens varta oes tse Figure 9 tab option to access either Nutrition or Products page SE reports arten others aboutus ve Search Total count 32 Variety Official Name Biofortified Protein Tron Raw Product Name Product Type Prod Dissem Method Product Partner Number of Beneficiairies i SEARCH Seed Details Brief Size Large Shape N A Quality Details Biofortified N A Pedigree N A Cooking Speed N A Fiber Content mg N A Protein N A x Colour Pink Coat Pattern N A Cooking Time Dry N A Phytate ug g N A Bean Taste N A Cooked Soak N A Figure 10 Nutrition page Bean Taste Zinc Raw Prod Year Promoted Select year Product Location h 2 Select Parameter n 4 Select Parameter meter E f 1 Name N A Search Total count 109 Product Name Year Of Developed From Year Of Developed To Select year Select year Product Ty
9. her help and reports tabs Clicking on each of the menu links will give you a specific page that displays information related to that See section Breeding Capacity Building ICM Seed Systems Nutrition Products and Markets Inner page general layout for more details 3 Maps For each of the pages accessed using the links on the left navigation a map is digolayed to show the geographical location 4 Footer Contains copyright ownership and vistor counter to help know the number of users that have accessed the database as of data Table 1 Summary of user end layout and functionality 1 3 Breeding Capacity Building ICM Seed Systems Nutrition Products and Markets Inner page general layout The pages listed above have the same layout though with subject specific data information using the tabs in the menu one can be able to access respective pages The illustrations below identify and explain some of the salient features of the general layout The figure 2 below is that of the products page that will be used to explain the layout asit appliesto all pages Total count 34 Summary count of Product Name Year Of Developed From Year Of Developed To all the theme Select year Select year specific records in the database Product Type Variety Official Name Select option List of t Partner Name Product Location PEOL PAUTAS z that can be used to refine search the SE
10. l fields which include total count official name local name Source name year of release from year of release to Altitude Temperature rainfall plant type days to maturity 100 seed category color coat pattern shape size Constraint Stress label Gene pool and purpose of release among others These values are shown the search section as shown in the example figure 3 above and therefore can be used to search The Breeding interface provides a database of nationally registered or released breeding materials and their properties The total count will vary from time to time as population of the database is a continuous process The following are the major user functionalities when accessing the breeding page a Using the url http database pabra africa org one can be able to access the database if an internet connection is available b Click the breeding tab on the top menu to access the breeding information page the breeding page with a generic layout as explained in figure 3 will be digolayed with summary information c To search for specific information select the desired parameters and click on the search button the results of your search will be populated and displayed in the result section see figure 4 for example To search based on a specific country select the desired country on the left panel and results will be specific to that country d Tabulation this allows a user to be able to search for specific information
11. meetings workshops training shot and long termi e one or two weeks to the duration for an Msc Ph d trainings These activities are classified by type description Location Participant and Participant Role Start date and End date and participants nationality These classification constitutes the parameters that can be used to filter and search for specific information and they can also be selected pairwise to get tabulations on any desired pair a b Using the url http database pabra africa org one can be able to access the database if an internet connection is available Click the Capacity Building tad on the top menu to access Capacity Building information page the capacity building page with a generic layout as explained in figure 3 will be displayed with summary information The figure 8 below shows a summary of the capacity building page To search for specific information select the desred parameters and click on the search button the results of your search will be populated and displayed in the result section see figure 4 for example To search based on a specific country select the desired country on the left panel and results will be specific to that country Tabulation this allows a user to be able to search for specific information and export it to either excel or PDF Note To be able to use this a user must be able to provide a minimum zis parameters selections The Figure 5 illustrated some of the functionality e
12. o a set of hints The help panel provides the opportunity for the users to access download documentation It requires one to click at the download documentation to access the PA BRA database user manual which acts as guide and be able to follow the steps while using the database This User manual is downloadable and can be saved in other places for easy accessibility if the user does not have internet
13. pe Variety Official Name Variety Local Name Partner Name Product Location SEARCH _ Product Details x Select Parameter gt Select Parameter gt Variety Official Name Variety Local Name SUG 131 MALEPA x Location Name Rauce Country Name Mozambique MOZAMBIQUE Dissemination Method Number of Beneficiaries Fairs 156 Number of Beneficiaries Number of Beneficiaries Dish Male N A Female N A Product Name Bean yam roasted groundnut Product Type Dish paste Year of Development 2014 Product Partner IAM Product Name Bean Bagia Product Type Snack Year of Deyelanment 2012 Product Partner IAM Figure 11 Product page showing detailed information of selected product 3 Other pages The pages explained in section 2 are the core pages related to the thematic areas of PABRA the pages explained in this section are supplementary pages to the database and they include reports Others Admin and Contact about us and Help 3 1 Reports The reports page shows summary reports in form of tables and graphs this information could be a result of information found in the database and from other sources compiled by the M amp E unit The information on this page will be changing depending on the relevance of the information needed by the end user or deemed important by the M amp E unit To access this page click the reports tab at the menu bar the page is displayed with the current most up to date information Ss EEEN S
14. s a user must be able to provide a minimum of 3 parameters selections The Figure 5 illustrated some of the functionality explained below e Select at least 3 parameters from the list provided e click the button tabulate this will run your search query and e provide an option to either export to excel or POF e Options of either open or save will be given on the pop up the option open will open the file using the either excel or PDF choice you made and save will prompt the user to select a location they want the files to be saved to p gt JER rect oing wuton soco Economies marteting onere About us Current ICM record count ICM Menu Search Total count 4582 Technology Technology Type Purpose r ICM search Dissemination Year from Dissemination Year to Dissemination Method parameter options Select year Select year p Partner Name Partner Type Dissemination Locatiarr SEARCH Tabulation Param 1 Partner gt Purpose parameter options Param 3 Technology Param4 Year Param 5 Select Parameter a Select Parameter Search results ICM Details Fertility z niee Technology Dissemination Trials Partner frechnology Type Location Country GITEGA Year a cumreredgy Type ISFM Intregrated Soil Fertility kg ha Management Purpose Optimisation of P level in Kaolisol Year 1972 Figure 7 ICM page layout 2 4 Capacity Building Capacity Building database presents data on
15. ummary Report s Detailed Information can be got from Annual report 2013 The information displayed here is extracts from the latest annual report from which you can get detailed information Capacity Building Gender training for cartegories Students Training 2009 2014 Male amp Female farmers and scientists partners Group Total Male Female 1 Scientists amp Partners 6565 59 35 4025 2 Farmers amp extension Workers 91188 481 5137 3 Students 150 668 32 Source PABRA database and Reports M Niche market bean varieties over the years Figure 12 Sample reports page 3 2 Admin The admin tab which is under the other tab provides a link to the admin page that is used by only authorized users to access the back end of the system Authorized users will be required to provide a valid user and password to gain access to that section of the system Pan Alrica Bean Research Alliance Figure 12 Admin access page after clicking the admin tab under others tab 3 3 Contact The contact page is accessed under the others tab it gives information on whom the user can contact in case they need more information related to the database It also has a feedback form that the user can use to contact person responsible for information on the database First Name Emam Message SENU Pan African Bean Research Alliance PASRA International Center for Tropical Agrictture CIAT C o Natonal Agricstural Research Laboratories
16. upply 2009 Figure 6 Seed system page results specific to country Burundi 2 3 Integrated Crop Management ICM The Integrated Crop management ICM interface provides a database of pest disease and soil fertility crop management technologies that are promoted alongside bean seed in order to improve the operformance of the bean crop These technologies are collectively referred to as ICM The specific fields includes Name of the technology Technology type purpose of the technology Years of dissemination From what year to what Year the partners involved and dissemination locations among others a b Using the url http database pabra africa org one can be able to access the database if an internet connection is available Click the ICM tab on the top menu to access the ICM information page the ICM page with a generic layout as explained in figure 3 will be displayed with summary information The figure 7 below shows a summary of the ICM page To search for specific information select the desired parameters and click on the search button the results of your search will be populated and displayed in the result section see figure 4 for example To search based on a specific country select the desired country on the left panel and results will be specific to that country Tabulation this allows a user to be able to search for specific information and export it to either excel or PDF Note To be able to use thi
17. xplained elow e Select at least 3 parameters from the list provided e click the button tabulate this will run your search query and e provide an option to either export to excel or POF e Options of either open or save will be given on the pop up the option open will open the file using the either excel or PDF choice you made and save will prompt the user to select a location they want the files to be saved to conc og Se Capacity Building Details Search Total count 1503 Activity Participant Participant Role Start Date 03 02 2014 End Date 07 02 2014 Description Meeting Activity Title Annual Steering Committee Review and Planning Meeting ECABREN Duration 4 days Contact Details e mail Address CIAT Uganda e katungi cgiar org First Name Enid Gender Female Ammann en Senn nn Location KAMPALA Activity Theme PABRA Review and planning Participant Role Participant Kawanda Research Institute 13Km Bombo Road P O Box 6247 kampala Last Name Katungi Nationality N A Mk Bleek on P Figure 8 Capacity building page Activity Type Location Start Date End Date E E x SEARCH eter Param 2 Select Parameter m TABULATE Select Parameter Detailed participant and activity information End Date N A Location KAMPALA End Date 07 02 2014 e Review and Location KAMPALA 2 5 Nutrition Products The nutrition and products tabs are
18. y on the left panel and results will be specific to that country Tabulation this allows a user to be able to search for specific information and export it to either excel or PDF Note To be able to use this a user must be able to provide a minimum of 3 parameters selections The Figure 5 illustrated some of the functionality explained below e Select at least 3 parameters from the list provided e click the button tabulate this will run your search query and e provide an option to either export to excel or POF e Options of either open or save will be given on the pop up the option open will open the file using the either excel or PDF choice you made and save will prompt the user to select a location they want the files to be saved to Research Alliance Search Total count 351 Variety Official Name Variety Local Name Source Name Year Of Supply From Year Of Supply To Quantity Produced kg Select year Select year 7 Partner Name Partner Type Seed Class SEARCH Param 1 Select Parameter gt Param 2 Select Parameter 7 Param 3 Select Parameter gt Param4 Select Parameter G Param 5 Select Parameter p ALL COUNTRIES TABULATE rv BURKINA FASO BURUNDI Patt CONGO BRAZZAVILLE Country BURUNDI Year Of Supply 2011 D R CONGO EASTERN CONGO Official Name AND10 Seed Class Pre basic ECABREN Country BURUNDI Year Of Supply 2009 ETHIOPIA GHANA Official Name AND10 Seed Class Pre basic GUINEA BISSAU Country BURUNDI Year Of S
Download Pdf Manuals
Related Search