Meeting

We had a meeting yesterday. Sir Nes, Sir Tony, Ate Daidee and me were present during the said meeting.

Discussed during the said meeting were the digitizing, workplan, deliverables and others.

Basic PDMS Orientation for the Cambodian Partners

3 Cambodians from Stung Treng arrived in Bohol to join the Local Kick-off Activity which was last July 29 and 30.

Yesterday, July 31, the Bohol Provincial Implementing Team headed by Dr. Pestelos gave them a Special Orientation on PDMS. It is designed to gave them information about How PDMS works, the Survey Process, Questionnaire and others.

Today, we are continuing the Workshop, here in Baclayon - Pestelos' Residence.

Backup Data Checking

Im currently checking the backup data of Pilar, Bohol.

What I'm trying to verify is if there is any barangay that has been encoded in two or more PCs which could raise an issue once all the data will be put in one single DB.

Meeting with the Field-Testing Team

We had a meeting with the Team that conducted the field-testing of the questionnaire in Maribojoc last Friday.

We discussed about the questionnaire, ways to improve it, errors to be corrected and clarified as well as the general experience of the field testing. We also talked about the survey, encoding of the data and ways on how to improve the integrity of the data.

Realising DReAMS Questionnaire Field Testing

We field tested the Realising DReAMS Questionnaire in San Vicente, Maribojoc last July 13, 2010.

We did a spot check in the morning and had a meeting with the Barangay Captain. We started the interviews around 3:00 p.m., and completed before 5:00 p.m.

Trip to Pilar

Been to Pilar with Joyce and Jessica Julia Baier last July 9 to get a backup copy of the PDMS data they have been encoding.

Sample Code for Generating FIs

Here is the sample code to generate the name of FIs and the number of the households they have interviewed.

SELECT DISTINCT s.enumeratorlastname LastName, s.enumeratorfirstname FirstName, COUNT(*) as Surveyed,pl.locationname Municipality
FROM survey s, household h, location l, location ll, location pl, surveydate sd
WHERE s.householdid = h.householdid AND h.locationid = l.locationid
AND ll.locationid = l.parentid AND pl.locationid = ll.parentid AND s.surveydateid = s.surveydateid
AND pl.locationname = "Sagbayan" AND sd.surveyyear = 2004
GROUP BY LastName, FirstName
ORDER BY LastName, FirstName;

Notes on Generating the Names of FIs

One missing feature of the PDMS for now is the capability to generate the names of the Field Interviewers who conducted the survey on a certain year.

To do this, you have to link the survey table with the household table, then the household table with the location table.

Sample Code
SELECT DISTINCT s.enumeratorlastname LastName, s.enumeratorfirstname FirstName, pl.locationname Municipality
FROM survey s, household h, location l, location ll, location pl, surveydate sd
WHERE s.householdid = h.householdid AND h.locationid = l.locationid
AND ll.locationid = l.parentid AND pl.locationid = ll.parentid AND s.surveydateid = s.surveydateid
AND pl.locationname = "Sagbayan" AND sd.surveyyear = 2004
ORDER BY LastName;

Site Updates

Posted some contents of the Realising DReAMS Blogspot yesterday.

One about the fund transfer and the other is about the Provincial Implementing Team.

Meeting with Tony

Tony and I met the other day to discuss about the mapping feature of the PDMS.

He will be teaching me on how to use shapefiles to map the household data sometime next week.

We also had some discussion on the DB structure as I was trying to generate the names of FIs that time.

Blogspot Updates

Updated the Blogspot yesterday. Added contents and updates about meetings and orientations.

For the admin panel of the pdms, still coding some parts of it.

New Features to the DReAMS Blogspot

I have added today new features to the DReAMS Blogspot:

1. Live Traffic Feed - enables us to monitor the site's visitor, their country of origin and the time since their visit

2. Stat Counter / Blog Counter - summarizes the visitors by country

I will just be adding more features to the site once I find something interesting - for the site to be more user friendly, informative and an awesome user experience. (hehe)

June 4 Project Orientation and Consultation

Yesterday, June 4, the provincial implementing team had a meeting with the Municipal Planning and Development Coordinators of the 5 pilot municipalities of the Realising DReAMS Project here in Bohol.

June 2 Technical Briefing

Last June 2, 2010, the Provincial Implementing Team met for the Technical Briefing and discussion on how to start the integration of PDMS and ecoBudget.

It was agreed upon during the said meeting that ecoBudget indicators will be integrated using the PDMS Mapping Tool (only some indicators, others will be at the household level if applicable).

A prototype / demo of the DReAMS Software is due to be presented by the end of June.

CodeIgniter in a SubFolder

I have encountered this problem when I installed CodeIgniter in a subfolder, as part of the PDMS Admin Panel Project.

Problems:
- page not found when accessing controller methods/functions
- forms will not submit
- will only load the default controller

To solve the above problems, I read a lot of forum posts and discussions in the CodeIgniter Forum and found some enlightenment there. Here are the things that I did to solve the problems associated with Installing CodeIgniter in a Subfolder/Subdirectory:

- enable apache modules - you can do this in the httpd.conf file. I cant remember exactly what modules I enabled, but there were several of them
- used the following htaccess file (I put it inside the subfolder where I installed the CodeIgniter)

    RewriteEngine On
    RewriteBase /foldername/

    #Removes access to the system folder by users.
    #Additionally this will allow you to create a System.php controller,
    #previously this would not have been possible.
    #'system' can be replaced if you have renamed your system folder.
    RewriteCond %{REQUEST_URI} ^system.*
    RewriteRule ^(.*)$ /index.php?/$1 [L]
   
    #When your application folder isn't in the system folder
    #This snippet prevents user access to the application folder
    #Submitted by: Fabdrol
    #Rename 'application' to your applications folder name.
    RewriteCond %{REQUEST_URI} ^application.*
    RewriteRule ^(.*)$ /index.php?/$1 [L]

    #Checks to see if the user is attempting to access a valid file,
    #such as an image or css document, if this isn't true it sends the
    #request to index.php
    RewriteCond %{REQUEST_FILENAME} !-f
    RewriteCond %{REQUEST_FILENAME} !-d
    RewriteRule ^(.*)$ index.php?/$1 [L]


    # If we don't have mod_rewrite installed, all 404's
    # can be sent to index.php, and everything works as normal.
    # Submitted by: ElliotHaughin

    ErrorDocument 404 /index.php

 I just found the above htaccess somewhere in the forum. Use it at your own risk.

- in my config file, I set the following
$config['base_url']    = "http://localhost/FOLDERNAME/";

I think that's all. I'll just add here if I can remember something.

Meeting with Tony

Tony and I had a meeting (Afternoon, May 26, 2010). We discussed on the PDMS surveytabs database table and things I could work on. He also let me update the survey definition of Bohol and San Isidro (remove the old one, then replaced it with the one he provided.)

Notes on Survey Tabs:

Survey Type or Type - a. Household, b. Current Member, c. Previous Member
                                - should have a title, 30 chars max

hasContent - 0 = has subtabs
                 - 1 = just content, no subtabs

parentid     - 0 = top level tab
                   # = surveytabid of the parent tab

nocolumns  - just number, put a textfield to do it.

Realising DReAMS Software Admin Panel

Doing the Admin Panel Program of the Realising DReAMS Software -  the PDMS with ecoBudget. I'm currently doing the survey definition part. I have to meet with Tony Irving later to discuss the next steps of the program.