Case Import and multiple choice

Users
1

Dear Team,

Kindly seek your guidance on the following.

I have a CommCare app using which we have done a baseline for a project.
The baseline covered 100% beneficiaries for a given area. This was a
single form and there was no cases used.

We have now decided to do the project monitoring also using CommCare for
this area. We have a form for registration of beneficiaries and most of
the information needed in this is already available from the baseline
data. Hence, we would like to avoid re-registration of beneficiaries and
related information, as these are already available in the baseline (using
form export). We now plan to do the following:

  • Create a form for registration and this form would register a new case.
  • Instead of registering all the beneficiaries manually, we plan to
    import that data from the baseline (using form export from baseline). We
    then plan to import this form-export data using case-import (excel
    importer).

I have the following doubts and seek your kind guidance on this:

  1. Some of the questions in the baseline were multiple answer
    questions. How do I structure the columns for this in excel-import
    template as it has multiple answers against one question?
  2. Do I put it (multiple-answers) comma-separated, and can the app map
    it back to appropriate values in an edit-form?
  3. Are there any limit to the case-import size in terms of the number of
    columns (# of questions)?

Thanks & Regards,
Jeffrey

2

Hey Jeffrey,

Dear Team,

Kindly seek your guidance on the following.

I have a CommCare app using which we have done a baseline for a project.
The baseline covered 100% beneficiaries for a given area. This was a
single form and there was no cases used.

We have now decided to do the project monitoring also using CommCare for
this area. We have a form for registration of beneficiaries and most of
the information needed in this is already available from the baseline
data. Hence, we would like to avoid re-registration of beneficiaries and
related information, as these are already available in the baseline (using
form export). We now plan to do the following:

  • Create a form for registration and this form would register a new
    case.
  • Instead of registering all the beneficiaries manually, we plan to
    import that data from the baseline (using form export from baseline). We
    then plan to import this form-export data using case-import (excel
    importer).

I have the following doubts and seek your kind guidance on this:

  1. Some of the questions in the baseline were multiple answer
    questions. How do I structure the columns for this in excel-import
    template as it has multiple answers against one question?

CommCare represents multiple answer questions as space separated lists. So
it would be, e.g. "red yellow blue". However, in general it's not easy to
work with multiple answer questions in apps and data and I'd typically
recommend doing something like is_yellow=yes, is_red=yes, and so on so that
you can easily reference each property.

  1. Do I put it (multiple-answers) comma-separated, and can the app map
    it back to appropriate values in an edit-form?

I believe the selected() function will still work if you use a space
separated format.

  1. Are there any limit to the case-import size in terms of the number
    of columns (# of questions)?

I don't believe there is a limit, but there are practical limitations in
terms of how big the cases can get before things start to get slow.
Typically up to hundreds of case properties are ok though.

Thanks & Regards,

ยทยทยท > Jeffrey > > -- > You received this message because you are subscribed to the Google Groups > "commcare-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to commcare-users+unsubscribe@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. >