1 of 6

Sharing Data Import ExperiencesMozambique

PEPFAR Data Exchange Implementer Community Call

December 9, 2015

2 of 6

  • Log in (Web based)
  • Partner dashboard
  • Entering data (MS Excel sheet)
  • Logic checks
  • Extracting MER raw data

PEPFAR DevResults System

3 of 6

XML Export tool

4 of 6

  • MS Access database
  • Mapping indicators
  • Importing MER raw data
  • Querying and creating the XML file
  • Narratives (Point of view)
  • Submit XML file to DATIM

XML Export tool

5 of 6

  • DATIM validations - should be able to run validation checks independently (without relying on Tier 3 support).
  • Synchronization between the live environment with the test environment, most of the times these two systems are misaligned. This is very important for testing prior to submission.
  • Ambiguous or “duplicated” mapping of DATIM versus MER indicators
  • Invalid data elements which exist in the DATIM mapping

Challenges

6 of 6

Thank You!�Obrigado!�Kanimambo!�