Changing question types without messing up data

The organization I am with has been collecting Village Name and Clinic Name
as a text question for several years. This has resulted in several outputs
for the same village and clinic due to differences in input by user. (E.g.
Village name “Lovers’ Twist” comes up at L Twist, Love Twist, Lover’s
Twist, etc.)

I want to correct this issue by changing question type to single answer and
using lookup tables, but I am concerned about the existing data. What is
the best way for me to correct the existing data and have the new and old
data appear in the same column when I export?

Thank you for any guidance!

Katie

Hey Katie,

If you keep the question ID the same, this should keep the data in the same
column when you do a form export. Unfortunately, you won’t be able to edit
the existing forms to fix up the old incorrect names (i.e. L Twist or Love
Twist) but all the data should appear in the same column.

Depending on what you’re doing with the data, it might be easier to have a
different question ID for the single answer question so you can distinguish
which forms have “standardized” names vs. user entered names.

Thanks,
Sheel

··· On Thu, Oct 8, 2015 at 5:50 AM, Kathryn Cicerchi wrote:

The organization I am with has been collecting Village Name and Clinic
Name as a text question for several years. This has resulted in several
outputs for the same village and clinic due to differences in input by
user. (E.g. Village name “Lovers’ Twist” comes up at L Twist, Love Twist,
Lover’s Twist, etc.)

I want to correct this issue by changing question type to single answer
and using lookup tables, but I am concerned about the existing data. What
is the best way for me to correct the existing data and have the new and
old data appear in the same column when I export?

Thank you for any guidance!

Katie


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.


Sheel Shah
Project Manager | Dimagi
m: +1.781.428.5419 | skype: sheel_shah

Thank you for the information, Sheel. If I wanted to update the existing
cases to correct the village and clinic names, would the best option be to
update the cases in Excel as explained on the wiki at
https://confluence.dimagi.com/display/commcarepublic/Updating+Cases+-+Setup+Excel+File?
I understand that past form data will not be updated, but I would like the
case properties to be corrected.

Katie

··· On Thursday, October 8, 2015 at 5:15:49 PM UTC+2, Sheel Shah wrote: > > Hey Katie, > > If you keep the question ID the same, this should keep the data in the > same column when you do a form export. Unfortunately, you won't be able to > edit the existing forms to fix up the old incorrect names (i.e. L Twist or > Love Twist) but all the data should appear in the same column. > > Depending on what you're doing with the data, it might be easier to have a > different question ID for the single answer question so you can distinguish > which forms have "standardized" names vs. user entered names. > > Thanks, > Sheel > > On Thu, Oct 8, 2015 at 5:50 AM, Kathryn Cicerchi <kcic...@gmail.com > wrote: > >> The organization I am with has been collecting Village Name and Clinic >> Name as a text question for several years. This has resulted in several >> outputs for the same village and clinic due to differences in input by >> user. (E.g. Village name "Lovers' Twist" comes up at L Twist, Love Twist, >> Lover's Twist, etc.) >> >> I want to correct this issue by changing question type to single answer >> and using lookup tables, but I am concerned about the existing data. What >> is the best way for me to correct the existing data and have the new and >> old data appear in the same column when I export? >> >> Thank you for any guidance! >> >> Katie >> >> >> -- >> 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-user...@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Sheel Shah > Project Manager | Dimagi > m: +1.781.428.5419 | skype: sheel_shah > > >

Hey Katie,

Yup, you can just the bulk case importer to fix up any existing cases.
https://confluence.dimagi.com/display/commcarepublic/Importing+Cases+Using+Excel

Thanks,
Sheel

··· On Mon, Oct 12, 2015 at 5:49 AM, Kathryn Cicerchi wrote:

Thank you for the information, Sheel. If I wanted to update the existing
cases to correct the village and clinic names, would the best option be to
update the cases in Excel as explained on the wiki at
https://confluence.dimagi.com/display/commcarepublic/Updating+Cases+-+Setup+Excel+File?
I understand that past form data will not be updated, but I would like the
case properties to be corrected.

Katie

On Thursday, October 8, 2015 at 5:15:49 PM UTC+2, Sheel Shah wrote:

Hey Katie,

If you keep the question ID the same, this should keep the data in the
same column when you do a form export. Unfortunately, you won’t be able to
edit the existing forms to fix up the old incorrect names (i.e. L Twist or
Love Twist) but all the data should appear in the same column.

Depending on what you’re doing with the data, it might be easier to have
a different question ID for the single answer question so you can
distinguish which forms have “standardized” names vs. user entered names.

Thanks,
Sheel

On Thu, Oct 8, 2015 at 5:50 AM, Kathryn Cicerchi kcic...@gmail.com wrote:

The organization I am with has been collecting Village Name and Clinic
Name as a text question for several years. This has resulted in several
outputs for the same village and clinic due to differences in input by
user. (E.g. Village name “Lovers’ Twist” comes up at L Twist, Love Twist,
Lover’s Twist, etc.)

I want to correct this issue by changing question type to single answer
and using lookup tables, but I am concerned about the existing data. What
is the best way for me to correct the existing data and have the new and
old data appear in the same column when I export?

Thank you for any guidance!

Katie


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-user...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Sheel Shah
Project Manager | Dimagi
m: +1.781.428.5419 | skype: sheel_shah


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.


Sheel Shah
Project Manager | Dimagi
m: +1.781.428.5419 | skype: sheel_shah