Changing question ids on ongoing survey

Dear users

We made some changes on question ids while the survey ongoing. I made
change for question id which was question`12 to kebele …

one the data export only the latest question id show up with no
submission.which is all data’s that had been submitted disappeared.

Is there any way to recover the data back.?

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

Hello, Tewelde,

When you change the name of a question ID, CommCare treats these as two
separate questions. The data collected for the deleted question can be
accessed in a data export by clicking on Show Deleted Questions and
Advanced Properties when editing the Export. You can see an example here:

[image: Inline image 1]

I hope this helps,

Jeremy

··· On Mon, Dec 21, 2015 at 12:08 PM, Tewelde Aregawi wrote:

Dear users

We made some changes on question ids while the survey ongoing. I made
change for question id which was question`12 to kebele …

one the data export only the latest question id show up with no
submission.which is all data’s that had been submitted disappeared.

Is there any way to recover the data back.?

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype


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.


Jeremy Wacksman
Dimagi http://www.dimagi.com, Inc.

Hi jeremy

Thank you very much.I am able to see those deleted data’s.But would you
please walk me through some steps how to combined those data to latest one.

Best

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

··· On Mon, Dec 21, 2015 at 10:52 AM, Jeremy W. wrote:

Hello, Tewelde,

When you change the name of a question ID, CommCare treats these as two
separate questions. The data collected for the deleted question can be
accessed in a data export by clicking on Show Deleted Questions and
Advanced Properties when editing the Export. You can see an example here:

[image: Inline image 1]

I hope this helps,

Jeremy

On Mon, Dec 21, 2015 at 12:08 PM, Tewelde Aregawi <teweldino.mvp@gmail.com wrote:

Dear users

We made some changes on question ids while the survey ongoing. I made
change for question id which was question`12 to kebele …

one the data export only the latest question id show up with no
submission.which is all data’s that had been submitted disappeared.

Is there any way to recover the data back.?

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype


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.


Jeremy Wacksman
Dimagi http://www.dimagi.com, Inc.


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.

Hello, Tewelde,

Since these are considered as two separate questions in CommCare, if you
want to merge the data you will need to do that in Excel or whatever data
tool you are using. In Excel this can be done using the “&” as described
here:


You could use this to combine the content of both the old and new columns
into a third which would have a value for all rows.

Jeremy

··· On Mon, Dec 21, 2015 at 2:30 PM, Tewelde Aregawi wrote:

Hi jeremy

Thank you very much.I am able to see those deleted data’s.But would you
please walk me through some steps how to combined those data to latest one.

Best

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

On Mon, Dec 21, 2015 at 10:52 AM, Jeremy W. jwacksman@dimagi.com wrote:

Hello, Tewelde,

When you change the name of a question ID, CommCare treats these as two
separate questions. The data collected for the deleted question can be
accessed in a data export by clicking on Show Deleted Questions and
Advanced Properties when editing the Export. You can see an example here:

[image: Inline image 1]

I hope this helps,

Jeremy

On Mon, Dec 21, 2015 at 12:08 PM, Tewelde Aregawi < teweldino.mvp@gmail.com> wrote:

Dear users

We made some changes on question ids while the survey ongoing. I made
change for question id which was question`12 to kebele …

one the data export only the latest question id show up with no
submission.which is all data’s that had been submitted disappeared.

Is there any way to recover the data back.?

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype


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.


Jeremy Wacksman
Dimagi http://www.dimagi.com, Inc.


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.


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.


Jeremy Wacksman
Dimagi http://www.dimagi.com, Inc.

Hi Jeremy and Tewelde,
I guess what Tewelde wants to do is to get the old responses for the Q. 12
into the database but not to concatenate the old and the new fields.

If this is true and there was no export before the change of name, then I
guess the Q. 12 will be empty for the first submissions before the change
which means that Tewelde need a way to retrieve the data for the Q. 12 for
those submissions and then replace the empty fields.

Jeremy
Is there a way that one can export data for deleted questions? If yes, then
it will be copy-and-paste or simple query can do the trick.

Yaw

··· On 22 December 2015 at 04:28, Jeremy W. wrote:

Hello, Tewelde,

Since these are considered as two separate questions in CommCare, if you
want to merge the data you will need to do that in Excel or whatever data
tool you are using. In Excel this can be done using the “&” as described
here:
https://support.office.com/en-US/article/Combine-text-from-two-or-more-cells-into-one-cell-94700285-8458-469B-AAE9-394451A1045C
You could use this to combine the content of both the old and new columns
into a third which would have a value for all rows.

Jeremy

On Mon, Dec 21, 2015 at 2:30 PM, Tewelde Aregawi teweldino.mvp@gmail.com wrote:

Hi jeremy

Thank you very much.I am able to see those deleted data’s.But would you
please walk me through some steps how to combined those data to latest one.

Best

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

On Mon, Dec 21, 2015 at 10:52 AM, Jeremy W. jwacksman@dimagi.com wrote:

Hello, Tewelde,

When you change the name of a question ID, CommCare treats these as two
separate questions. The data collected for the deleted question can be
accessed in a data export by clicking on Show Deleted Questions and
Advanced Properties when editing the Export. You can see an example here:

[image: Inline image 1]

I hope this helps,

Jeremy

On Mon, Dec 21, 2015 at 12:08 PM, Tewelde Aregawi < teweldino.mvp@gmail.com> wrote:

Dear users

We made some changes on question ids while the survey ongoing. I made
change for question id which was question`12 to kebele …

one the data export only the latest question id show up with no
submission.which is all data’s that had been submitted disappeared.

Is there any way to recover the data back.?

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype


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.


Jeremy Wacksman
Dimagi http://www.dimagi.com, Inc.


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.


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.


Jeremy Wacksman
Dimagi http://www.dimagi.com, Inc.


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.

Hi Jeremy and Yaw

Thanks for your help.I am able to recover the deleted data’s.except one
kebele which showed up as skipped.

Jeremy had it been text data ,it would be good to merge as you suggested
me.But the deleted data’s are integers,like wereda,kebele.

Thanks

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

··· On Mon, Dec 21, 2015 at 8:51 PM, YAW ANTWI-ADJEI wrote:

Hi Jeremy and Tewelde,
I guess what Tewelde wants to do is to get the old responses for the Q. 12
into the database but not to concatenate the old and the new fields.

If this is true and there was no export before the change of name, then I
guess the Q. 12 will be empty for the first submissions before the change
which means that Tewelde need a way to retrieve the data for the Q. 12 for
those submissions and then replace the empty fields.

Jeremy
Is there a way that one can export data for deleted questions? If yes,
then it will be copy-and-paste or simple query can do the trick.

Yaw

On 22 December 2015 at 04:28, Jeremy W. jwacksman@dimagi.com wrote:

Hello, Tewelde,

Since these are considered as two separate questions in CommCare, if you
want to merge the data you will need to do that in Excel or whatever data
tool you are using. In Excel this can be done using the “&” as described
here:
https://support.office.com/en-US/article/Combine-text-from-two-or-more-cells-into-one-cell-94700285-8458-469B-AAE9-394451A1045C
You could use this to combine the content of both the old and new columns
into a third which would have a value for all rows.

Jeremy

On Mon, Dec 21, 2015 at 2:30 PM, Tewelde Aregawi <teweldino.mvp@gmail.com wrote:

Hi jeremy

Thank you very much.I am able to see those deleted data’s.But would you
please walk me through some steps how to combined those data to latest one.

Best

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

On Mon, Dec 21, 2015 at 10:52 AM, Jeremy W. jwacksman@dimagi.com wrote:

Hello, Tewelde,

When you change the name of a question ID, CommCare treats these as two
separate questions. The data collected for the deleted question can be
accessed in a data export by clicking on Show Deleted Questions and
Advanced Properties when editing the Export. You can see an example here:

[image: Inline image 1]

I hope this helps,

Jeremy

On Mon, Dec 21, 2015 at 12:08 PM, Tewelde Aregawi < teweldino.mvp@gmail.com> wrote:

Dear users

We made some changes on question ids while the survey ongoing. I made
change for question id which was question`12 to kebele …

one the data export only the latest question id show up with no
submission.which is all data’s that had been submitted disappeared.

Is there any way to recover the data back.?

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness
and Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype


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.


Jeremy Wacksman
Dimagi http://www.dimagi.com, Inc.


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.


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.


Jeremy Wacksman
Dimagi http://www.dimagi.com, Inc.


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.


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.

​Thanks guys. I have recovered my data’s

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

··· On Mon, Dec 21, 2015 at 9:11 PM, Tewelde Aregawi wrote:

Hi Jeremy and Yaw

Thanks for your help.I am able to recover the deleted data’s.except one
kebele which showed up as skipped.

Jeremy had it been text data ,it would be good to merge as you suggested
me.But the deleted data’s are integers,like wereda,kebele.

Thanks

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

On Mon, Dec 21, 2015 at 8:51 PM, YAW ANTWI-ADJEI yawantwiadjei@gmail.com wrote:

Hi Jeremy and Tewelde,
I guess what Tewelde wants to do is to get the old responses for the Q.
12 into the database but not to concatenate the old and the new fields.

If this is true and there was no export before the change of name, then I
guess the Q. 12 will be empty for the first submissions before the change
which means that Tewelde need a way to retrieve the data for the Q. 12 for
those submissions and then replace the empty fields.

Jeremy
Is there a way that one can export data for deleted questions? If yes,
then it will be copy-and-paste or simple query can do the trick.

Yaw

On 22 December 2015 at 04:28, Jeremy W. jwacksman@dimagi.com wrote:

Hello, Tewelde,

Since these are considered as two separate questions in CommCare, if you
want to merge the data you will need to do that in Excel or whatever data
tool you are using. In Excel this can be done using the “&” as described
here:
https://support.office.com/en-US/article/Combine-text-from-two-or-more-cells-into-one-cell-94700285-8458-469B-AAE9-394451A1045C
You could use this to combine the content of both the old and new
columns into a third which would have a value for all rows.

Jeremy

On Mon, Dec 21, 2015 at 2:30 PM, Tewelde Aregawi < teweldino.mvp@gmail.com> wrote:

Hi jeremy

Thank you very much.I am able to see those deleted data’s.But would you
please walk me through some steps how to combined those data to latest one.

Best

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

On Mon, Dec 21, 2015 at 10:52 AM, Jeremy W. jwacksman@dimagi.com wrote:

Hello, Tewelde,

When you change the name of a question ID, CommCare treats these as
two separate questions. The data collected for the deleted question can be
accessed in a data export by clicking on Show Deleted Questions and
Advanced Properties when editing the Export. You can see an example here:

[image: Inline image 1]

I hope this helps,

Jeremy

On Mon, Dec 21, 2015 at 12:08 PM, Tewelde Aregawi < teweldino.mvp@gmail.com> wrote:

Dear users

We made some changes on question ids while the survey ongoing. I made
change for question id which was question`12 to kebele …

one the data export only the latest question id show up with no
submission.which is all data’s that had been submitted disappeared.

Is there any way to recover the data back.?

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness
and Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype


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.


Jeremy Wacksman
Dimagi http://www.dimagi.com, Inc.


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.


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.


Jeremy Wacksman
Dimagi http://www.dimagi.com, Inc.


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.


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.