...
- 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 2: Run the update query to fix the data (NOTE: This query should be run once only, running twice or more will corrupt responses column, then you would have to restore the question_group_table and try again)
(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; |