View source for FPP data problems

=2007-03-23 21:34:25=
===Data problems===
====CSV inventory====
{| class="wikitable"

|Assessment Month
|Number of CSVs extant
|
|
|
|
|
|
|
|-
|Mbatwe-2005-10
|186
|
|
|
|
|
|
|
|-
|Mbatwe-2006-06
|235
|
|
|
|
|
|
|
|-
|Mbatwe-2006-11
|
|
|
|
|
|
|
|


|}

====Mbatwe 2005-10-00====
* sicknessDurationMonths seems to have some really bad data (very large numbers)
* family:waterDistanceMeters has some really large numbers incl. 50,000
* Answer code 2 needs an answer in sicknessType, or maybe 2 is a bad entry.
* family:interviewer needs to have spellings standardized so each interviewer appears only once
* family:interviewed should have been entered with a member number, it seems
* Mbatwe-F-4-2005-10 family has room type '2'
* Family D15 was exported from the wrong page of the spreadsheet. May need to enter again.

====Mbatwe 2006-06-00====
* Answer meanings have changed= Must reconcile.=
* A-1 Duplicate not back to back. Kato can fix and rerun.
* A-12 Sickness symptom problem. Tom has to comment.
* A-17 It appears that a "\\" in the data confused either the buildinserts program or mysql. Tom needs to be aware of this. Kato can fix and rerun.
* A-2 Sickness symptom problem. Tom has to comment.
* A-28 Sickness symptom problem. Tom has to comment.
* D-28 Sickness symptom problem. Tom has to comment.
* E-1 Duplicate family. Tom has to comment.
* J-1 Duplicate family. Tom has to comment.
* J-2 Duplicate family. Tom has to comment.

* All data that should have gone into person:isEmployed went into person:whereEmployed
* person:occupation is showing all numbers. Need to add answer codes to database.
* There is a family:latrineType, family:bathHouseType, family:doortype 17. We must not have building type answer codes 17-19+. Also need better translations on the building materials. Here's the change:

**2005-10-00
**8,"Barrel foil","Chapas de tambor",
**9,"Cement","Cimento",
**10,"Fabricated wood","Contaplacado",
**11,"Corrugated asbestos-cement sheeting","Lusalite",
**12,"Wood","Madeira",
**13,"Mud","Matope",
**14,"Cardboard","Papelão",
**15,"Plastic lined","Plástico",
**16,"Sack","Saco",
**17,"Corrugated galvanized steel","Zinco",
**18,"","Pedras",

**2006-06-00
**8,"Cement","Cimento",
**9,"Fabricated wood","Contaplacado",
**10,"Corrugated asbestos-cement sheeting","Lusalite",
**11,"Wood","Madeira",
**12,"Mud","Matope",
**13,"Cardboard","Papelão",
**14,"Plastic lined","Plástico",
**15,"Sack","Saco",
**16,"Corrugated galvanized steel","Zinco",

* Mbatwe-J-19 family has `homeOccupancy` = '6'
* Three different families have lightingType '9'
* Mbatwe-I-1 has hasPestProblems = '13'
* Portuguese doesn't show up as a language, and there is a rare 19 and 21. These are totally changed. Need to talk to Moises.

**2005-10-00
**4,"Portuguese","Português"
**5,"Sena","Sena"
**6,"Ndau","Ndau"
**7,"Changana","Changana"
**8,"Matswa","Matswa"
**9,"Shona","Shona"
**10,"Macua","Macua"
**11,"Chitswa","Chitswa"
**12,"Chuabo","Chuabo"
**13,"English","Inglês"
**14,"Chichewa","Chichewa"
**15,"Lomwé","Lomwé"
**16,"Maconde","Maconde"
**17,"Chobe","Chobe"
**18,"Bitonga","Bitonga"
**19,"Núngue","Núngue"

**2006-06-00
**4,"Bitonga","Bitonga"
**5,"Changana","Changana"
**6,"Chichewa","Chichewa"
**7,"Chitswa","Chitswa"
**8,"Chobe","Chobe"
**9,"Chuabo","Chuabo"
**10,"Inglês","Inglês"
**11,"Lomwé","Lomwé"
**12,"Maconde","Maconde"
**13,"Macua","Macua"
**14,"Matswa","Matswa"
**15,"Ndau","Ndau"
**16,"Portuguese","Portuguese"
**17,"Sena","Sena"
**18,"Shona","Shona"

* Add a zero to the 1 digit familyId's so they will sort right.

I reviewed pretty carefully down to family:lightingType

I started at family:lightingType and went thru the rest of the indicators

The graph doesn't load for 2006, but does for 2005
* family:hasLatrineSink doesn't show up on 2006
* family:hasStanding water doesn't show up on 2006
* family:isAnyMemberEmployed
* family:hasAnyMemberProfessionalSkill
* family:hasTruantChild
* family:hasAnyMemberProfessionalCourse
* person:isEmployed
* person:hasProfessionalSkills
* family:isWaterTreated
* family:babyFood
* family:farmFieldDistanceMeters
* family:hasFamilyConflict
* family:hasAnyMemberMentalProblems
* person:hasMentalProblems
* family:isAnyMemberSick
* family:hasAnyMemberSicknessTreatment
* family:mostCommonDisease
* family:lastSicknessDate
* family:hasMemberWithCOnstantDiahrrea
* family:hasMemberWithConstantHeadache, skinsores, coughing, coughing blood
* family:hasEnoughMosquitoNets
* person:isHealthy
* person:sicknessType
* person:sicknessDurationMonths
* person:sicknessTreatmentType
* person:sicknessTreatmentDurationMonths
* family:isAnyMemberCommunityLeader
* person:isCommunityLeader
* person:hasIdCard
* person:isTruantChild
* person:hasProfessionalCourse
* person:professionalCourse


* family:businessPastWhyStopped has a 9 and a 10 column
* person:occupation the numbers didn't connect with the occupation names
* I think the whereEmployed graph and the isEmployed graph got switched up.
* person:professionalSkill has a 2 column
* family:dailyMeals the e in tres is wierd. Should be três
* diet:food the English translation of mariscos (I think) is seafood. Does that cover eggs and meat as well?
* I think all the tres have a weird e. family:babyDailyMeals
* farmFieldProduct has a 9 column
* farmFieldProductUse should the Portuguese read "Qual é o destino dessa produção?" ??? I think it's missing the é
* family:farmCommuteMeans it should be A pé instead of R pé
* homeGardenProduct has a 16 and a 17
* animalRaised has a 15, also should the Portuguese read "Qual é o destino dessa criação" ???
* family:hasSmoker should the question say fuma instead of fume??? I'll check on this
* person:isVaccinationCurrent has a 4
* language has 19 and 21








===Web site problems===
* Need to use actual question text in drop-down menu.
* Need to use question text from appropriate year's assessment.
* When there is no such question for the given year, need to show some kind of an "empty" graph message.