GRS is working with Dimagi to design and deploy CommCare workflows across their organization. OpenFn has configured an automated data integration solution between CommCare and Salesforce to sync shared beneficiary information and enable for real-time monitoring of field data collection.
See here for the data element mapping specification.
The solution is a one-way CommCare-to-Salesforce integration that connects the following CommCare forms:
Create intervention
My Team/Group Name
Intervention Notes
Register Participant
Attendance
Coach Support Visit Form
Coach Support Visit Form Zambia
Pre Challenges
Post Challenges
Coach Session Register
Home visit log form
PHQ9
Risk & Vulnerability Assessment | Service Referral - Treatment, Care and Support
HIV Testing Event Snapshot
Malaria Testing Event Snapshot
Service Referral Follow Up
Register Event
Service Referral
HIV Testing Event Statistics
Malaria Testing Event Statistics
Aggregate Service Referral
Register Skillz Plus Club
ART Adherence Self-Reporting Tool
Outcome Monitoring Survey
Trigger Type: Message Filter
A message filter trigger has been configured for each of the forms above. The corresponding job will run when a form with the matching message filter is recieved in the project inbox. These can be adjusted in the OpenFn project.
The CommCare forms map to these Salesforce objects: Event, Person, Attendance, CSV, HomeVisit, PGHQ9StrongMinds, NewReferral, GRS Referral Aggs, ART Adherence Self-Reporting Tool, and Risk Assessment.
These are the external identifiers used in every object to uniquely identify records when syncing between CommCare and Salesforce.
Create intervention - Intervention name
My Team/Group Name - Intervention name
Intervention Notes - Intervention name
Register Participant - Intervention name & case ID
Attendance - Intervention name & case ID
Coach Support Visit Form - Form ID
Coach Support Visit Form Zambia - Form ID
Pre Challenges - Intervention name & case ID
Post Challenges - Intervention name & case ID
Coach Session Register- Case ID
Home visit log form - Form ID
PHQ9 - Form ID
Risk & Vulnerability Assessment | Service Referral - Treatment, Care and Support - Form id & case ID
HIV Testing Event Snapshot - Case ID
Malaria Testing Event Snapshot - Case ID
Service Referral Follow Up - Case ID
Register Event - Event name
Service Referral - Case ID
HIV Testing Event Statistics - Case id
Malaria Testing Event Statistics - Case ID
Aggregate Service Referral - Form ID
Register Skillz Plus Club - Event name
ART Adherence Self-Reporting Tool - Form ID
Outcome Monitoring Survey - Form ID
- If
Venues,Curriculums,Sites,Business UnitsorCoachesare added to CommCare, they will also need to be uploaded to Salesforce. - Users of the mobile app should always make sure they're using the latest version of the CommCare app.
- The
Upsert Pre ChallengesandUpsert Post Challengesjobs have been configured to work with 14 different curricula. These curricula have been documented here.
This integration is hosted on OpenFn.org with CommCare and Salesforce Hosted SaaS. OpenFn will provide ongoing maintenance support to the GRS administrators managing OpenFn, Salesforce, and CommCare.
To add a new Curriculum to the integration, please follow this process:
- Add new mappings to mapping sheet
- Add curriculum to Salesforce
- Add pre/post questions to Salesforce Attendance records
- Submit test submission in CommCare (ideally marked as "test") to be used for job testing
- Create a partial Salesforce Sandbox containing data
- If there are any changes to the curriculum, add them to mapping sheet, submit new CommCare data and notify the OpenFn Support Team.
- The OpenFn team adds the mappings to the jobs and tests using the test submissions and the Sandbox.
Primary GRS support contact: dvumbi@grassrootsoccer.org
Contact support@openfn.org with any OpenFn questions or troubleshooting support.
Video & Slide deck: https://drive.google.com/drive/folders/1KtKTFfqc0jcgrmF7jcW7BmiN5-_6Jpk5