Instructions
Contents
1. CAMBODIAN INFORMATION SYSTEM ON IRRIGATION SCHEMES Add Edit Sub Projects d o Ne T soe EEE SE ocos subprojeto E C a or a A Communes included in this Sub Project 2 Find a Commune The Commune selected in the Commune Finder will be transferred here Use the Commune Finder to add a new Commune KE eT it uA E a EE EKE Ge EE aS Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 CISIS by MOWRAM Edit SubProjects CISIS DATABASE et CAMBODIAN INFORMATION SYSTEM ON IRRIGATION SCHEMES Add Edit Sub Projects g OFJ ogg Ocode Oname Name Bans erer Kork Thnong SubProject No D ex CK OL JL ott C 00 Lbs J Communes included in this Sub Project 1E Find a Commune AUE 7 Siem Reap v District 1701 Angkor Chum v Sotes 70101 Char Chhu v Replace with 170101 Char Chhuk Yes No pid fed o fF gt gt ff pe Villages included in this Sub Proiect gt Kork Thnong v CD ED Er SS D 7T CISIS by MOWRAM Edit SubProjects CISIS DATABASE CAMBODIAN INFORMATION SYSTEM ON IRRIGATION SCHEMES Add Edit Sub Projects OFJ og code O name Name EJ Jere emefex Kork Thnong SubProject No P GGL n lG Communes included in this Sub Project gt 170101 Char Chhuk v Find a Commune Aue 17 Siem Reap v District 1701 Angkor Chum v Sola 170101 Char Chhuk v Replace 170101 Char Chhuk with 170101 Char Chhuk2. pyes No E ED it Et T ncluded in this Sub Proiect Kork Thnong v 17010101 Prasat A 17010102 Yeang E 17010103 anuk J 17010104 Prey Lvey 17010105 Prey Cheng 17010106 Kbal Cham 17010107 Kouk Lvea 17010108 Char Roka 17010109 Thnal 17010110 Chhuk 17010111 Kouk Kbat 17010112 Ta Tov only villages belonging to the selected Commune above will appear here Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 CIsIs by MOWRAM Edit SubProjects CISIS DATABASE CAMBODIAN INFORMATION SYSTEM ON IRRIGATION SCHEMES pi Add Edit Sub Projects code O Name O Sbjct os Pe ee eee Communes included in this Sub Project arse chhuk i Find a Commune ka ins S Siem Reap v District 1701 Angkor Chum w eume l 70101 Char Chhuk ka Replace 170101 Char Chhuk with 170101 Char Chhuk Yes No ED CD BP GS a aa Villages included in this Sub Proiect 17010104 Prey Lvey 5 17010105 Prey Cheng G 17010119 Kouk Thnong 7 17010120 Ka Trakiet 4 4 4 6 Li JOA N 3of4 J d Above you can use this controls to display Provinces Districts Communes and Villages in Khmer or English and by code or by name Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 For example CISIS by MOWRAM Edit SubProjects CISIS DATABASE CAMBODIAN INFORMATION SYSTEM ON IR
3. Define Projects SubProjects CISIS DATABASE CAMBODIAN INFORMATION SYSTEM ON IRRIGATION SCHEMES R Edit Projects SE Project 2 hl 10 Kork Thnong In the new Project 2 created above we can only select SubProject no 10 because the others are already attached to the NWISP Project The following controls act the same as explained for SubProjects e Delete Button Save button d L Find Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 6 4 Survey Years Head Office must assign a survey year to each SubProject Press CIsis by MOWRAM SubProject Survey Years CISIS DATABASE h ai ze ra CAMBODIAN INFORMATION SYSTEM ON IRRIGATION SCHEMES Seam E Sub Projects Survey Years Select a SubProject using either control E Krouch Saeuch A Khmer or English ii to DeActivate a Year Select a Year Above you can see Untick to DeActivate a Year Once a survey year is finished and the SubProject office has confirmed that all data entry is completed Head Office should deactivate the survey year and perform a Data Export to the SubProjects The SubProject will no longer be able to access data for the deactivated survey year in their module This prevents historical data being accidently changed At any given time Head Office should only allow one survey year to be activated This will prevent SubProjects entering survey data in the wrong survey y
4. Name Code Name The official government naming of Provinces Districts Communes and Villages also uses a numbering system When selecting any of these you can switch between i Code view Select a Household by Code C Name Commune 010201 Banteay Neang Village 01020102 Phnum Households Man Poor Poor Woman Poor Poor ii Name view Select a Household by Code Name SubProject Po Pi Deum Commune Banteay Neang 010201 E village Phnum 01020102 Households Man Poor Poor Woman Poor Poor 5 3 Exit To exit forms use the Exit button Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 5 4 Deleting records On many forms you will find this control to delete records Check the Check Box to activate the delete button a Si By default the button is disabled shown in grey as shown above This is a safeguard so that the Delete Button is not accidently pressed To activate it check the check box Once activated the delete button will appear in colour Once the delete button is clicked as a further safeguard against accidental deletion the user will be warned normally twice that the record is about to be deleted DELETING RECORDS IN SUB FORMS The process for deleting a record in a subform is different Look at the form below CISIS by MOWRAM Edit SubProjects yA Add Edit Sub Projects Form CAMBODIAN INFORMATION SYSTEM ON IRRIGATION
5. Rohat Teuk 1 Po Pi Deum Do Pi Deum BMC 1 Mongkol Borey Bat Trang 6 Khtum Reay Keut Anlong Thngan Keut Bang Bat Keut Bat Trang Bat Trang Thom Keut and Bat Trang Toch W 3 fram Mneash Thnout Chum 8 Dangteuk Leach Chambok Thom Tbeng Chrum Tram Beung Veal Kandal Chheuteal and Sen Pen Banteay Neang 4 Phnom Kork Phnov Trang and Pongro a Bnina Svav PUR 1 Bak 2 Rum Lech 6 Roung Takok Kaun Thnoat Phnouv Pra Sat Koh Kchiey and Rum Lech a eal BAEN O Ta Paong 2 Cham Kar O Robos Raing PUR ho Ruessey Kroak 2 Neang Ket and Chamka Tadoak TO Saeuch Bakan 2 Khnar Totoeung 3 Khnar Totoeung Krouch Saeuch and Phtas Sla i Trapaing Chorng 5 Kab Kralanh Bakan Qu Rumchek Svay Toal and Stung Kambot uch Noup Kbal Trach Doung Phsar Samrong Sre Russey and Krolanh 2 Kakaoh 4 Chork Thum Chork Toch Kakaoh and Srae Ou ah go Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 6 3 Attach to a Project Once SubProjects are attached we need to attach them to a Project A Project is really just a group of SubProjects By creating a Project we can report on several SubProjects later you will see how to do this Normally a Project will group SubProjects that the Ministry feels are logically linked For example the first Project is NWISP and its SubProjects are situated in the North West area of Cambodia Once a Project is created and SubProjects linked to it we can run
6. SCHEMES 4 This form contains the following subforms Add Edit Sub e Villages O Communes included in this Sub Project b 010303 Ponley v 010801 Phkoam Villages included in this Sub Project P 01030301 Ta Vong J E 01030302 Ponley Se Dowel at Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 To delete the 010303 Ponley commune first select it CISIS by MOWRAM Edit SubProjects pe Se CISIS DATABASE ee CAMBODIAN INFORMATION SYSTEM ON IRRIGATION SCHEMES SAT Add Edit Sub Projects The black arrowhead indicates which record is selected Name EY pene 8 Puney sd r Oe E ee aT P 010303 Ponley BL 010303 Ponley 010801 Phkoam v Click the black arrowhead It will change in appearance to look like this white arrowhead black background 010303 Ponley then press the Delete key on your keyboard You will get this warning Microsoft Office Access Relationships that specify cascading deletes are about to cause 1 record s in this table and in related tables to be deleted Gre vou sure you want to delete these records If you are sure you want to delete the record click Yes ATTENTION Be careful deleting records Deleting a record may delete other information that depends on it For example SubProjects require Communes If you delete a Commune the SubPr
7. a single report to show all SubProjects for a given project For example d2 C Boe Home Insert Page Layout K34 a fe Formulas Data Review View Acrobat PPMS Summary Template_EN2 Microsoft Excel Project A zy 7 n Key Indicators Sumary rep A EN ear aye INDICATOR Punley Pe PiL Tram Anlong Chork De Mneash Svay Ac SubProjects 2 3 Irrigation system Year 2009 2009 2009 2009 na na ma ni 4 No of farming households in benefit area No m a e Se 5 Average land area per household in benefit area ha og 2 oo45 oser o J P ee 6 Overall Average productivity DS rice t ha Ooo ee ee ee ee fe fe ee 7 Overall Average productivity WS rice t ha Ooo To 7J ee ad 5 eee eee 8 Overall Average productivity DS other main crop t ha ee a 5 Je je 9 Overall Average productivity WS other main crop t ha nn ee eee eee J fe o 10 Total WS irrigable area ha 11 WS rice planted in benefit area ha 49 Mthar VAIO arana in hanafi naran fA o So o w a A n S f o So 2 Y a ee ee 7 h 4 a To create a Project and attach SubProjects Press Attach to a Project on the Main Menu CISIS by MOWRAM Define Projects SubProjects CISIS DATABASE CAMBODIAN INFORMATION SYSTEM ON IRRIGATION SCHEMES R ree Edit Projects nn lt pn _Add New Project A gt SubProject 1 Punley 2 Po PiDeum SubProjects For This Pro
8. all Autonumber Head Office tbhlTranslations strEnglish strkAmer strForm strFieldName bIFinished strBald strFantEN strFantKH strFantsizeEN strFontsizeKH Non Autonumber SubProject tblTranslations ID Translation Ing_ID TranslationsHeadOffice strEnglish strkAmer strForm strFieldName bIFinished strBald strFontEN strFontKH strFontsizeEN strFontSsizeKH The same situation exists for the Banks tbIBanks table Households table tblHouseholds The Head Office households table version of tblHouseholds index field ID_ Household is non Autonumber so it can accept the SubProjects Autonumber index Each SubProject will assign an AutoNumber index to its own Households So SubProjects 1 2 and 3 can all have a Household No 1 Obviously if the Head Office table accepts three different Housholds with the same index number Head Office has no unique index So the Primary Key in both modules is multi field both ID_ Household and IngVillageCode a unique village code Households coming from different SubProjects will not have the same village code as a village can only belong to one SubProject Head Office Non Autonumber a L M LOWS T IngCODEVILLAGE ID_Village strHusband FamilyName_EN strHusband GivenName_EM strvvife_FamilyName_EN strvvite_GivenName_EN strHusband FamilyName_KH strHusband GivenName_KH strvvife_FamilyMame_KH strvvife_GivenName_KH strHHAddress SubProjects Auto
9. data for that SubProject held in tables A1 to B8 This deleted information is completely re imported In this way any corrections by the SubProjects to past data are automatically picked up Accidental changing of past data in finished survey years is protected because Head Office can de activate each Subproject s survey years as they are completed and the SubProject will no longer have editing capability for that survey year see Section 6 4 above So the SubProject s ability to correct edit enter data described in the above paragraph should only be available in the current survey year Data Exchange via MS Outlook The export import processes between Head Office and SubProjects can be done via MS Outlook However this process has not been tested live with the SubProjects because at the time of development neither Head Office nor the SubProjects were using MS Outlook Create New SubProject Module The template database C Program Files MOWRAM_BME Database SupportDocs CISIS_BME_SubProjectTemplate accdb contains a complete model of the SubProject software except that it lacks the following queries e ftblQrySubProjects e tblQrySubProjectCommunes_Custom e tblQrySubProjectVillages Custom The above are customized according to the selected SubProject and inserted when the SubProject is created This process means that although each SubProject module contains a full list of all SubProjects each SubProject can only see its own SubProject in th
10. it was felt that the original database may become stressed once used as multi user database for which it was designed b the BME Module was conceived by NWISP a specific section of MOWRAM At the time of development MOWRAWM s IT infrastructure was fragmented and it was not clear that NWISP and the existing CISIS administrators could share a common server As such BME was designed as a separate module However the BME module feeds off geographical information contained in CISIS such as government defined Provinces Districts Communities and Villages This data is passed from CISIS to BME to ensure that the 2 systems remain aligned and that maintenance of this geographical information is not duplicated The information is passed via a data package so that the two systems don t require direct communication e g residing on a common server The two systems can reside in completely separate locations and the data updates CISIS to BME can be done by email or flash drive Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 It should be noted that while BME was conceived by NWISP the module has been designed so that new Projects SubProjects can be added at any time The BME was originally designed as a spreadsheet calculation It was recognized that this would be difficult to maintain over time a Data entry is decentralized so each MOWRAM Commune Office responsible for a given SubProject requires its own sprea
11. module e g value of production As for Head Office data collation and reporting are automated 4 Installing the software The software must be installed in the location Fie Edit View Favorites Tools Help C Program Files MOWRAM_BME Q pak A i p2 Search F Folders Bre Address C Program Files MOWR AM BME Database Overview of the sub folders an olders e Database holds the Front End fie OURAN PME e BackEnd holds the BackEnd 3 o Database e SupportDocs holds the MS Word and MS aa Excel reporting templates as well as the E Dataarchive empty SubProject software template I DataReceived i P 9 DataSent e The Data sub folders are used for data gt DLLAndLibraries exchange between Head Office and the 9 Instructions O SubProjectModules SubProjects SupportDocs It is imperative to respect the above as the software looks for templates and data in the above specific locations Also the Front End user interface looks for the Back End data tables in the location C Program Files MOWRAM_BME Database BackEnd For an explanation of splitting a database into a Front and Back end see my instructional video prepared for the original CISIS database Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 5 Common Controls Navigation 5 1 Translation SO Kod You can change the screen text between Khmer and English by selecting the above control 5 2 Code
12. the deleted Province is in fact restored fthlvillages ftblCommunes ftbl Districts ftblProvinces EA 98 7 ID_Househ IngNoOfPlotsOwnech PROVINCE F IngCODEVI IngTotalLand ID Year N_KHUM M_ DIST CodeVillage SAPIA T ID_District T ID_Province ID_ Commune Codecommune CodeDistrict Namek Province COMMU ID District ID_Province NameE_Province IngCOMMUNe InaDISTRICT EE f IRC Law a men e e e a Ag Lode ommur IngCodeDistrict UTM_ ge z Namek_Village fi Namek Somn TEE District AREA ain ae wa thl_BO_Householdinfo ey pistrict PERIMETER UTMLY i 1D_B2 POP_98 ID_Household POP Osh IngCODEVILLAGE POP ORF tbl_B1_OtherInc ID_Year HH as a ID_B1 strvVealthGroup F ategory weCategary ur a sf tbl_B2_AgriIncome i Fi ed ID_B2 r It is also important to note that the official government codes while appearing as numbers are actually text For example a District code may be 0101 Because it has a leading zero it must be captured as text However as don t like using text in relationships have converted these codes to integers e g 0101 become 101 This conversion occurs when the geographical tables are imported from CISIS to the Head Office BME module This done by the queries shown below BEE qryConvertCisis fthlCommunes Fd gryConvertCIsIS_ftb Districts BEE qrylConvertClsis_ftblVillages Gregory D Regan Email greg trader yahoo com au Mobil
13. CISIS DATABASE BME MODULE Benefit Monitoring amp Evaluation USER MANUAL for Head Office By Greg Regan Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 afd CISIS DATABASE BME MODULE Head Office DOCUMENTATION 1 Terms e CISIS Cambodian Information System on Irrigation Schemes e BME Benefit Monitoring and Evaluation e PPMS An alternative name to BME Project Performance Monitoring System e SubProject a specific collection of Communes and Villages and the households of those villages e Project a specific group of SubProjects e MOWRAM Ministry of Water Resources and Meteorology e MS Access Microsoft Access database software e NWISP North West Irrigation a specific section of MOWRAM e Baseline Year the first survey year for a given SubProject 2 History The original CISIS database was designed to facilitate data collection and reporting on Cambodia s circa 3 000 irrigation schemes It covers areas such as infrastructure management operation agricultural uses distribution network and yearly budgeting The BME Module was designed as an addition to the existing CISIS database Its purpose is to assess the correlation between a improvements in irrigation schemes and b improvements in the quality of life of the communities served by those irrigation schemes This author decided to develop the BME module as a separate MS Access database because a
14. Data file to the SubProjects you need to use the module and not resend it directly from Outlook Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 6 10 Exporting To SubProjects Head Office Email Addresses Survey Years SubProjects BME BME To export data to the SubProjects use the Export to SubProjects button Check this to activate the Export Import buttons Export Import p Export to SubProjects Import from SubProjects If you are using Outlook the Head Office Export data file will be automatically emailed to the SubProjects based on the email addresses you have entered for them see Section 6 6 above Make sure the internet is activated or the email will not be sent To make sure the email is sent press the Send All button on your Outlook li Outbox Microsoft Outlook File Edit View Go Tools Actions Help A New ki LAS x i Reply Reply to All f Forward Y Lej Mail lL Outbox Favorite Folders Click here to enable Instant Search If you are not using Outlook the Head Office Export data file will be saved to the Desktop You need to email this to the SubProjects fe GA Search address boo L Send Receive Y Send Receive All Fo Export Import 6 11 Importing from SubProjects Export to SubProjects Head Office SubProjects BME BME The Commune offices will submit survey data to Head Office from t
15. Mobile 855 0 25 99 95 After selected a Project SubProject and survey year if one is not already selected click the Create New SubProject Module button and the new empty SubProject module will be saved to the user s desktop as a zip file Send this to the Commune Office responsible for the SubProject The Commune Office must unzip the file to the C drive and software will be located correctly as explained in Section 4 Installing the Software above 6 9 Export Import Overview Data exchange is required between the Head Office module and the SubProject modules This is shown in the Data Flow diagram below Provinces Districts DATA F L O W Communes Villages Head Office SubProjects BME The data flows between Head Office and the SubProjects are highlighted in yellow Both Export and Import of data can be done using MS Outlook assuming the user s MS Outlook is functional To use MS Outlook for export import check the Do you use Outlook box MAIN MENU Do you use Outlook 3 9 LL lt _ If you choose not to use Outlook the software uses the PC desktop as the place where import export data is placed Also note that Data Export files attached to the emails both incoming and outgoing will be removed to prevent your Outlook from becoming bloated The email itself won t be deleted so you can check the history of exports and imports So if you want to resend and Export
16. Mongkol Borey ieee Widen Phnom Pie sshd Pa pu Ruessey Kroak N tand C ka Tadoak 1B Roung I Kaun Font Ph Make sure the SubProject number matches your official SubProject List Click the Save button and close the form You don t need to enter all of the communes and villages for the SubProject Ask the SubProject to do a Data Export to you and then run the Import from SubProjects process The SubProject will now be restored with all of its survey data 6 1 Running Compact and Repair Database You should compact and repair your database regularly This keeps the database running efficiently To do this click here gt o i CERS CIR dee CIsis by MOWRAM Cut oa CISIS DA id CAMBODIAN INFORT Clipboard BME Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 7 TECHNICAL NOTES 7 1 Head Office Module compared to the SubProject module Basically the table relationship structure of both modules is the same except for a few differences Translations table tblTranslations The SubProject version has an extra non AutoNumber index column so it can import the Head Office Autonumber index The form labels refer to the Head Office tbIlTranslations index number If the SubProject tblTranslations index was also AutoNumber it could increment independently from the Head Office table and the SubProject labels would point to the wrong translation or none at
17. RIGATION SCHEMES Add Edit Sub Projects 4 oe O code Name Ga l o l JL LP Communes included in this Sub Project char Chhuk 170101 k Find a Commune Provinces Districts Communes and enn Villages appear by Name first Replace Char Chhuk 170101 with Villages included in s Sub Proiect Prey Lvey 1 010104 EE e Be ee ee ae You can find an existing SubProject by using the SubProject Finder Anlong Svay Canal No 1 Chork Don Aov Alternatively use the navigation buttons H Oio e Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 The above screen shows a completed SubProject To add more use the New button Kork Thnong a Ma aka When all SubProjects have been added exit this screen CISIS by MOWRAM Edit SubProjects CISIS DATABASE CAMBODIAN INFORMATION SYSTEM ON IRRIGATION SCHEMES Sree Add Edit Sub Projects 4 SOF oE Ocode name You should note above that the numbering of the SubProjects should match your official list e g Add Edit Sub Projects ee Oe ee ae On ed ES LO ee doProjectAndvillages xlsx Microsoft Excel Home Insert Page Layout Formulas Data Review Vx Acrobat 119 vO fe A B G H 1 Northwest Irrigation Sector Project 2 11 July 2009 3 aN amp x Phnom Srok 2 Punley 2 Punley and Ta Vong U wip vuy Chot pem S Svay Sor Thmar Kaul and Ou 4
18. ad Office to add new banks Recommended Water Standards Email Addresses can only be updated by Head Office SubProjects survey years once a survey year is finished for a SubProject Head Office can deactivate that year to prevent accidental changes to the survey data SubProjects can only add data to survey years determined by Head Office This is set individually for gt oOaQao each SubProject iii Providing each SubProject with their customized module automated iv Reporting this is completely automated CISIS ee DATA FLOW rovinces Districts Definitions SubProjects Projects Banks National Water Standards Email Addresses Survey Years Head Office SubProjects aii ne Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 The SubProjects are responsible for i Verifying that the SubProject Definitions are correct ii Requesting changes to Banks and email addresses iii Survey coordination iv Survey data entry The BME modules have been designed primarily with promoting ease of data entry by the SubProvinces e Software screens are bilingual Khmer English e Data entry screens match the paper format e Data exchange with Head Office is simple e Required data fields cannot be omitted e Data types are controlled e g text cannot be entered in a number field e Calculations that were previously done by the user on the previous survey form are now handled by the
19. bove CISIS by MOWRAM Edit SubProjects CISIS DATABASE CAMBODIAN INFORMATION SYSTEM ON IRRIGATION SCHEMES i Add Edit Sub Projects PE o eee Communes included in this Sub Project 010303 Ponley v The Phkoam commune is selected b 010801 Phkoam w kea To add a new village just select the next vacant row indicated by Click the drop down arrow to see records available for selection Villages included in this Sub Proiect 01080105 0u E 01080108 Svay Sa E 01080110 Thma Koul SEEE 01080101 Phkoam 01080102 Yeang Vien 01050103 Yeang 01080104 Ampil 01080105 0u Select a new village from the drop down list 5 6 Saving convention Data changes are saved automatically Unlike MS Word or MS Excel there is no Save button to click after making data changes Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 6 SUBPROJECT PROCESSES CISIS by MOWRAM CISIS DATABASE feo Fic a P CAMBODIAN INFORMATION SYSTEM ON IRRIGATION SCHEMES BME Module MAIN MENU Do you use Outlook Import from CISIS Add Edit SubProjects Create New SubProjectModule Attach to a Project Survey Years Banks Email Addresses Water Quality m m Fa EL E F g ee Er i 2 D ft ag ry f Reports View Reports Jase development by www completeexce The Head Office Main Menu pictured above shows Head Office processes
20. bove image shows a report extract for the NWISP Project for the Baseline Year Note the column to the right shows n a in the year row for the Krouch Saeuch SubProject This is because there is no survey data entered The report will show a column for all SubProjects in the Project even if there is no survey data This is so the user can see which SubProjects still require survey data entry Restoring a Deleted SubProject Read Section 6 9 Restoring a Deleted SubProject of the SubProject User Manual If you accidently delete a SubProject it can easily be restored as follows Edit SubProjects Click Add Edit SubProjects On the next screen click the New SubProject button CISS by MOWRAM Edit SubProjects CISIS DATABASE ee oe CAMBODIAN INFORMATION SYSTEM ON IRRIGATION SCHEMES SE Add Edit Sub Projects Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 OE a aaa CISIS by MOWRAM Edit SubProjects CISIS DATABASE fees cf CAMBODIAN INFORMATION SYSTEM ON IRRIGATION SCHEMES Bsc ba Add Edit Sub Projects OF ix PIL i E Name BY ry Pe Se Po Pi Deum Lo ER EE pt jf p Code Name E T a al T Official SubProject List gt tt IF 1 ot n nom 7 Pu j tes erate k t Ithmar Kaui gi 4 Rohat Teuk Po Pi Deum Bat T di Khtum Reay Keut Anlong Thngan Keut Bar Po Pi Deum BMC 1
21. dsheet These need to be collated somehow b Spreadsheets are easy to corrupt rendering collation difficult c The spreadsheet format does not match that of the paper surveys which increases the likelihood of errors e g data being entered in the wrong field d Volume of information the NWISP Project alone includes 11 SubProjects each of which will survey around 100 households per survey year Each survey has around 200 fields A complete evaluation will require two to three survey years Other Projects are foreseen in future Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 3 Overview of the module A complete description of the BME PPMS can be found in the Annexes A SubProject survey consists of 2 parts 1 Part A one survey per SubProject conducted at the Commune level 2 Part B Household Survey A maximum of 100 households will be surveyed per SubProject which is considered to be statistically relevant One aspect of Part A is to roughly determine the percentage of a SubProjects that could be considered Poor Average and Better Off The households selected for surveying in Part B should then match that same demographic composition Head Office is responsible for i Updating regularly from CISIS ii Maintaining SubProject definition only needs to be established once Project definition only needs to be established once Bank lists where SubProject must contact He
22. e 855 0 25 99 95 7 3 The fields containing the original government code is shown with an asterisk in the above relationship diagram The fields bordered in red are my conversions for use in relationships The queries above add the converted field integer version of the government code then the record can be added to the BME tables Overview Exporting from Head Office to SubProject The following tables are exported in this process e Provinces ftblProvinces e Districts ftbIDistricts e Communes ftblCommunes e Villages ftblVillages e Banks tbIBanks e Font tblFont e SubProjects ftblSubProjects e SubProject Communes tblSubProjectCommunes defines which Communes belong to which SubProjects This is the parent table of the tblSubProjectVillages table e SubProject Villages tblSubProjectVillages Defines which villages belong to which SubProject child of the tb SubProjectCommunes table above e Project SubProjects tbIProjectSubProjects defines which SubProjects are grouped together under which Projects e SubProject Years tblSubProjectYears defines each SubProject s survey years e Translations tblTranslations e Email Addresses tblEmailAddresses e Water Quality tblRecommendedWaterQuality In the SubProject module when importing from Head Office the last 3 tables above are completely destroyed and completely re imported each time These tables have no dependents so no data will be destroyed during this pr
23. e drop down boxes Once the above program routine is finished a zip file is created programmatically that contains the support documents such as zip DLL s report templates MS Word and MS Excel and an empty backend This backend is held in the SupportDocs folder not the BackEnd folder When Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 the SubProject installs and runs the software for the first time a check is made to see if a SubProject backend already exists in the BackEnd folder e If Yes it means the computer doing the install already has another SubProject installed so the new empty backend in the SupportDocs folder is not copied to the BackEnd folder This is because it is possible that a commune office administers more than one SubProject There will be a separate accdb file in the Database folder but they will share the same backend database e If No the empty backend in the Support Docs folder is copied to the BackEnd folder for use by the front end accdb in the Database folder The SubProject will have to run a Data Import from Head Office the first time the software is run as it when first installed it does not contain the SubProject definition Communes Villages nor up to data translations used for the bilingual screens Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95
24. ear DeActivating a year will not delete any survey data entered for that year WARNING Deleting a survey year deletes survey data entered for that year Deleting a year is not the same as deactivating it Survey years should only be deleted if it was created by mistake E g you entered 2 survey years instead of just one If you need to a delete a survey year select it and press the Delete key on your keyboard Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 Here is an example of several survey years being created for a SubProject but only one of them is active CISIS by MOWRAM SubPraject Survey Years CISIS DATABASE ieee ake CAMBODIAN INFORMATION SYSTEM ON IRRIGATION SCHEMES Sub Projects Survey Years ae Krouch Saeuch i o o ry Fase pee to DeActivate a Year E F hgt aj Active survey year Above 2009 and 2011 would have been completed Year 2014 is the survey year currently in progress CISIS DATABASE AMIE iodule MAIN MENU 6 5 Banks 1 to edit banks Press b Head Office maintains banks to ensure consistency of data This avoids entering the same bank spelled differently E g SubProject 1 enters ACLEDA while SubProject 2 enters A C L E D A 6 6 Email Addresses Email addresses are also maintained by Head Office SubProjects must request updates by Head Office Press Email Addresses to edit email addre
25. ime to time as required This is done by emailing a zipped data export file to the Head Office These can be processed automatically with or without Outlook Tir at Y PP Y Se es If you are using Outlook the Head Office module will Do you use Outlook Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 automatically open Outlook and search the Inbox for the Data Export files emailed by the SubProjects These will automatically be processed by the module If you are not using Outlook you must save any SubProject Data Export files to the Desktop The module will find them there and process them automatically Once processed they will be removed from the Desktop CS by MOWRAM CISIS DATABASE CAMBODIAN INFORMATION SYSTEM ON IRRIGATION SCHEMES BME Module MAIN MENU Do you use Outlook Import from CISIS 6 12 Reporting Edit SubProjects Add Edit SubProjects HS View Reports n J li N 3 3 3 3 There are two reports available 1 An MS Word report this shows a single SubProject and where appropriate breaks down report statistics by Wealth Group e g Poor Average and Better Off contract Mo NIP LC Appendix A A Baseline Data Survey Questionnaire KEY INDICATORS Summary Report Form for Overall Scheme Name of Subproject Punley Year of Survey 009 Baseline Year 2009 Ref Indicators Measured Baseline Year a Irrigation system o Average
26. in their logical sequence 6 1 Import from CISIS The CISIS administrators must produce a Data Export zip file This should be saved to the desktop of Head Office BME Administrator s PC Import from CISIS Press the module with additions or deletions to Provinces Districts Communes and Villages button to process this file This will update the BME Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 6 2 Add Edit SubProjects This is where SubProjects are defined in terms of the Communes and Villages they cover A given Commune or Village can only belong to one SubProject and this rule is enforced by the BME Module __Add Edit SubProjects Press To add a New Sub Project CISIS by MOWRAM Edit SubProjects Its DATABASE ai Add Edit Sub Projects You will see CISIS by MOWRAM Edit SubProjects CISIS DATABASE CAMBODIAN INFORMATION SYSTEM ON IRRIGATION SCHEMES g Add Edit Sub Projects Once you have entered the required information above you will see the Save button Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 CISIS by MOWRAM Edit SubPrajects CISIS DATABASE CAMBODIAN INFORMATION SYSTEM ON IRRIGATION SCHEMES Add Edit Sub Projects e at Tale KEKE a Once saved you will see the screen below and you can now add the Communes and Villages CISIS by MOWRAM Edit SubProjects OES CISIS DATABASE
27. ject gt ees ik 3 Tram Mneash 4 Anlong Svay 5 Krouch Saeuch 6 Kuch Noup 7 Chork 8 Don Aov 9 Canal No 1 11 Ta Saom O 4 Delete Project i Oi Rh Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 A SubProject can only be added to one Project The user cannot mistakenly add a given SubProject to two Projects as once a SubProject is attached to a Project it becomes unavailable for selection in the SubProject Drop Down box For example Here you can see the NWISP Project has ten SubProjects attached to it CIsIs by MOWRAM Define Projects SubProjects CISIS DATABASE CAMBODIAN INFORMATION SYSTEM ON IRRIGATION SCHEMES 3 Edit Projects SubProjects For This Project SubProject al ubProject No 10 is not Seat Saceat ttached to this Project 6 Kuch Noup ae so it is available for rero selection by other SubProjects 11 Ta Saom SubProject no 10 still has not been selected Let s create a new Project Click the New Project button j CISIS by MOWRAM Define Projects SubProjects CISIS DATABASE CAMBODIAN INFORMATION SYSTEM ON IRRIGATION SCHEMES Edit Projects Enter the Project Name in both English amp Khmer Va and Click Save d save Button i ee eae oO PO el ta LOO Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 CISIS by MOWRAM
28. land area per household in benefit area A3 Overall Average productivity DS rice tha 7 i a i n ai L i par i i m _ E a rere Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 2 An MS Excel report this report shows all the SubProjects for the selected Project Statistics are not broken down by Wealth Group 6 13 Ge i ei o FILT DE PPMS Summary Template_EN1 Microsoft Excel Home Insert Page Layout Formulas Data Review View Acrobat c2 i f m INDICATOR Punley Po Pi Tram Deum Mneash Irrigation system Year zoos 2o08 zool zool niat n m Key Indicators Sumary report form for pann pmp Anlong Krouch Svay Saeuch Average total non agriculture income for HH last 12 months USD of LO of ISF charged compared to agriculture income pp Average HH marketable surplus rice kg o o o o o p o Direct Costs of Production all crops last 12 months USD o aal aso aloo o oaao eee of farmer access to formal credit 100 100 100 aooo ooo Average interest rate charge by formal credit Oo ee ee o oa ee eee HH GDP USD per year o en 245 43 172 Poverty incidence of HH s O S 7aa S a Total labor days input by men for crop production Mo Te 5 33 533 Total labor days input by women for crop production No amel saal 5 33 Number days hired male labor for crop production No ee crop production Mo The a
29. number thlHousehalds T IngCODEVILLAGE strHusband FamilyName_EN strHusband GivenName_EN strvVife_FamilyName_EN strvVife_GivenName_EN strHusband FamilyName_KH strHusband GivenName_KH strvVife_FamilyName_KH strvVife_GivenName_KH strHHAddress Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 7 2 Difference to the original CISIS database Unlike the original CISIS database the BME modules both Head Office and SubProject use the official government geographical codes in relationships with the tables for Provinces Districts Communes and Villages The BME modules rely on importing all data from the above mentioned tables so cannot use their own Autonumber index in relationships as Autonumber indices can increment independently Imagine a Province with an Autonumber index of 1 and an official government Province Code of 01 is accidently deleted in the CISIS database The mistake is found and it is restored Now it may well have an Autonumber index of say 25 If the BME modules referred to this index in its relationships any data depending on the original Autonumber index of 1 would be orphaned When the Province is restored though it will be re entered with the official government Province Code of 01 As long as the BME modules use the government Province Code accidental deletion and restoration of a Province District Commune or Village will not cause a problem assuming of course in the above example that
30. ocess from Access s cascading deletions referential integrity Programmatically in the SubProject module the imports are done by e Append Queries to add any new records found e Delete Queries to delete any records in the SubProject that were deleted in the Head Office module An exception is the Villages table At the time of development it has 13 866 records and the delete query runs very slowly So deletions are down programmatically in the cmdimportFromClSIS routine see programming comment Special routine for villages as the delete query takes too long to run Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 7 4 Overview Exporting from SubProject to Head Office 7 5 7 6 The following tables are exported from the SubProject in this process e SubProjects ftblSubProjects e SubProject Communes tblSubProjectCommunes e SubProject Villages tbISubProjectVillages e SubProject Years tblISubProjectYears defines each SubProject s survey years e Households tblHouseholds e Survey tables A1 to B8 e SubProject Prices tbIPricesBySubProject e Email Addresses only the email address for SubProject concerned is exported Explanation When the Head Office module performs the routine to import the above tables it first destroys the SubProject in the ftblSubProjects table This cascade deletes all dependent data e g SubProject Communes SubProject Villages SubProject Years and all survey
31. oject attached to it will also be deleted The survey data attached to that SubProject will in turn be deleted Safeguards have been built into the software to prevent accidental deletion but ultimately the responsibility belongs to the user Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 5 5 Adding New Records Normally records are added to forms using an Add Record button which may look like one of When adding records to some forms the form background colour will change to light green indicating the form is in New Record mode the following Review Edit Households E Review Edit Households ai Add New Household Select a Household by Code C Name Part 1 Select a Household by Code C Name pains Select a Village et mA 2 9 visage 01090302 Ponte i Village v Households Mars P Pe Vom Select a Survey Year v Select a Survey Year In New Record mode some forms will have an Undo button Use this if you decide to cancel adding the new record When all the necessary data has been completed for the new record you may see the Save button E Click this to save the new record The form will return to Normal mode the green background will disappear Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 ADDING RECORDS TO SUBFORMS Let s return to the example illustrated in 5 4 a
32. sses 6 7 Water Quality Recommended minimum national water standards are entered by Head Office Gregory D Regan Email greg trader yahoo com au Mobile 855 0 25 99 95 6 8 Create New SubProject Module The SubProject module used by the Commune offices is customized so that each Commune office can only see their own SubProject in screen selections CAMBODIAN INFORMATION SYSTEM ON IRRIGATION SCHEMES 9 SSS BME Module SubProject CISIS DATABASE xh afd mG CISIS by MOWRAM Commune Data Entry hi moj SubProject Surv s hiji Part A SubProject v Poribeum TC on o Select a Survey Year 2009 o Start Survey gt In the above example the software customized for the Po Pi Deum SubProject will only show the Po Pi Deum SubProject This prevents data entry to the wrong SubProject particularly important for Part A Customizing a SubProject module is automated Press Create New SubProjectModule Eg CISIS by MOWRAM CISIS DATABASE ers of CAMBODIAN INFORMATION SYSTEM ON IRRIGATION SCHEMES Se a BME Module CREATE NEW SUBPROJECT MODULE on of Select a Project NWISP J Select a SubProject 1 Punley all Years m to DeActivate a Year K K P 2009 v v Ensure a survey year is selected and activated checked Create New SubProject Module Jatabase development by www completeexcellence com Gregory D Regan Email greg trader yahoo com au
Download Pdf Manuals
Related Search