MEIRU Data Processing Description
๐ Paper-based Workflow
1. Form Preparation & Field Collection
- Forms printed and allocated to interviewers
- Blank or pre-filled with participant info
- Administered in field
- Completed forms returned to data office
2. Double Data Entry
- Two separate databases
- Discrepancies resolved
- One authoritative database
- Free text coded using lookup tables
3. Validation & Cleaning
- Standard validation checks
- Errors resolved by officers
- Field revisits for verification
4. Research & Analysis
- Consistency checks
- Multi-study merging
- Analysis-ready datasets
- Researcher feedback
5. Archiving & Sharing
- Standard based metadata created for each study
- Final archiving on local servers
- Anonymized subsets
- Shared with researchers on MEIRU Microdataportal and other platforms
- Harmonized datasets visualized on MEIRU Viewer Dashboard
๐ฑ Electronic Workflow
1. Digital Form Administration
- Interviewers use tablets/phones
- Blank or pre-filled
- End-of-day transfer
- ODK, RedCap, SurveyCTO
๐ ODK Data Transfer
- Tablets โ LAN โ Server
- C# middleware
- ODK Server to Operational Database Data Loading
๐ SurveyCTO Encrypted Transfer
- Public-key encryption on device
- Double encryption (local + SSL)
- Private key decryption
- CSV โ C# โ Operational Database
- Weekly transfers
3. Validation & Cleaning
- Operational Database quality checks
- Cleaning
- Liaison with interviewers
- Field revisits
4. Research & Analysis
- Consistency checks
- Multi-study merging
- Analysis-ready datasets
- Researcher feedback
5. Archiving & Sharing
- Standard based metadata created for each study
- Final archiving on local servers
- Anonymized subsets
- Shared with researchers on MEIRU Microdataportal and other platforms
- Harmonized datasets visualized on MEIRU Viewer Dashboard
MEIRU Viewer Dashboard
Visualizations
from harmonized datasets
