Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • 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;