...
- The additional fields that did not migrate should be listed under "View Additional Fields" in Admin
- The additional fields that did not migrate and all data saved with them should still be in the DB
- In the workflows where these additional fields existed, these additional fields shouldn't be displayed as Additional Fields - the MFI must re-create them manually under Question Groups
- There should be no validation for mandatory additional fields - the validation should only be for QG's
Known Issues
MIFOS-4892 4892 : Survey Migration not mapping single select or choice responses correctly
...
STEP 1: make backup of question_group_response table. e.g.mysqldump
Code Block |
---|
mysqldump -u mifos -pmifos mifos question_group_response > qgr.sql |
STEP 2: Run the update query to fix the data
(This query only affects question_group_response table, so if something goes wrong you can restore the question_group_response table)
...
STEP 3: check for mysql warnings/errors (there should NOT be any warning or error after running the query).
Code Block |
---|
mysql> SHOW WARNINGS; |