avniproject / ashwini Goto Github PK

• Move all the programs from UAT to prod.

https://reporting.avniproject.org/question/542

In Ashwini Prod organisation, around 303 coded form elements have missing type in db while this information is somehow present on App designer. We need to add these missing values as ETL is not working without these values.

Support ticket - https://avni.freshdesk.com/a/tickets/3091

Query used to find these elements -

set role ashwini;
select * from form_element fe
inner join concept c on fe.concept_id = c.id
where c.data_type = 'Coded' and fe.type is null;

Now, since Kannan has provided us with this information, please update the same in DB -

https://docs.google.com/spreadsheets/d/1KlSnyJMYJ2LBs6_MhSKlwYdHbfR7mWb04JfLvfqZbYI/edit#gid=1568604557

• Write a script to add the type to these coded form elements
• Make sure the ETL is working post this update.

https://avni.freshdesk.com/a/tickets/776

org : Ashwini2
Support ticket -
https://avni.freshdesk.com/a/tickets/2216

Vaccination schedule
https://docs.google.com/spreadsheets/d/1NDSWkPWZt22j-4m9kgfEqLaPx_lL1G8W76-vmabytp8/edit#gid=0

https://docs.google.com/spreadsheets/d/10AjhR7NUlOKlQogJk5x0sEG9KRmwmDCMbulbBdaK_QE/edit#gid=0

• Update the checklist with the above mentioned schedule on UAT

Tasks--

Download bundle from ashwini and make following changes--

1. Add org1 concepts( only those which are used in ashwini) to the bundle
   -- Concepts used in ashwini2 and already present in the org1 Done
   --Individual Registration concepts Done
   --Mother concepts Done
   --Child concepts Done
   -- Vaccination conceptsDone

2. Copied subject type "Individual" Done
   Porgram "Mother","Child" Done

Encounter types "Delivery","ANC","PNC",Abortion" Done
"Birth form", "Child PNC", "Anthropommetry assessment" Done
Form mappings-- CHild and mother forms Done

2. Forms from org 1 --
   Mother Enrollment, Done addition and deletions
   ANC, Done addition and deletions
   Delivery, Done addition deletions
   Abortion, Done
   PNC Done
   Exit Done
   Child Enrollment Done
   Birth Form Done
   Anthropometry assessment Done
   Checklist ( Added rule and not the checklist.json, so it wont work on UAT) Done
   to the bundle

3. Create a new org ASHWINI UAT and upload bundle to ashwini UAT Done

4. Add rules from org 1 (View Filter, Decision rules for enrollment and encounters and Visit scheduling for mother and child programs ) and (Checklist Vaccination rule) to new org

-- View filter rules for Mother Done
-- View filter rules for Child Done
-- Decision rules for Mother Done
-- Decision rules for Child Done

-- Program summary rule for Mother
-- Program summary rule for Child

https://avni.freshdesk.com/a/tickets/1470

• Find which new vaccines were added in the Ashwini org

• Check on pre-release if adding vaccines to the child's checklist table {get the exact name of table} will solve the issue
  (issue is - the new vaccine schedule works only when enrolment is added)

• Write appropriate script and test it on pre release

• Co-ordinate with client and run this on prod.