List of Inactive Cases?

Users
1

Hi All,

Is there an easy way on HQ to download an excel list of inactive cases?

Thanks,

Michael

··· -- Michael Matheke-Fischer Director of Programs - India Real Medicine Foundation Mobile # (Delhi): (0091) 9971234868 Mobile # (Madhya Pradesh): (0091) 9098116315 Skype id: michael_matheke
2

Hi Michael,

An easy way to do this would be to export all the currently open cases from
the Export Cases, Referral, and Users page. The data exported to excel
will include the date the case was last modified (column "modified_on").
In excel, you can easily sort the data by this date and discard any
inactive cases.

For guidance on how to use excel to sort & filter, see our documentation
here: Sorting & Auto Filters - CommCare Public - CommCare Public

Amelia

··· On Thu, Nov 1, 2012 at 12:32 AM, michael matheke wrote:

Hi All,

Is there an easy way on HQ to download an excel list of inactive cases?

Thanks,

Michael

--
Michael Matheke-Fischer
Director of Programs - India
Real Medicine Foundation
Mobile # (Delhi): (0091) 9971234868
Mobile # (Madhya Pradesh): (0091) 9098116315
Skype id: michael_matheke

http://www.realmedicinefoundation.org/

3

Thanks Amelia, weve been following up based on last.modified. When does hq
classify a case as inactive?

-sent from my android-

··· On 1 Nov 2012 21:03, "Amelia Sagoff" wrote:

Hi Michael,

An easy way to do this would be to export all the currently open cases
from the Export Cases, Referral, and Users page. The data exported to
excel will include the date the case was last modified (column
"modified_on"). In excel, you can easily sort the data by this date and
discard any inactive cases.

For guidance on how to use excel to sort & filter, see our documentation
here: Sorting & Auto Filters - CommCare Public - CommCare Public

Amelia

On Thu, Nov 1, 2012 at 12:32 AM, michael matheke < michael.matheke@gmail.com> wrote:

Hi All,

Is there an easy way on HQ to download an excel list of inactive cases?

Thanks,

Michael

--
Michael Matheke-Fischer
Director of Programs - India
Real Medicine Foundation
Mobile # (Delhi): (0091) 9971234868
Mobile # (Madhya Pradesh): (0091) 9098116315
Skype id: michael_matheke

http://www.realmedicinefoundation.org/

4

HQ classifies as case as "inactive" in the Case Activity Report if the case
has not been modified (no form has been filled out against the case) in the
past 120 days.

To see full definitions of how each column in the case activity report
works, hover your mouse over the (?) symbol in each column header.

Amelia

··· On Thu, Nov 1, 2012 at 11:35 AM, michael matheke wrote:

Thanks Amelia, weve been following up based on last.modified. When does hq
classify a case as inactive?

-sent from my android-
On 1 Nov 2012 21:03, "Amelia Sagoff" asagoff@dimagi.com wrote:

Hi Michael,

An easy way to do this would be to export all the currently open cases
from the Export Cases, Referral, and Users page. The data exported to
excel will include the date the case was last modified (column
"modified_on"). In excel, you can easily sort the data by this date and
discard any inactive cases.

For guidance on how to use excel to sort & filter, see our documentation
here: Sorting & Auto Filters - CommCare Public - CommCare Public

Amelia

On Thu, Nov 1, 2012 at 12:32 AM, michael matheke < michael.matheke@gmail.com> wrote:

Hi All,

Is there an easy way on HQ to download an excel list of inactive cases?

Thanks,

Michael

--
Michael Matheke-Fischer
Director of Programs - India
Real Medicine Foundation
Mobile # (Delhi): (0091) 9971234868
Mobile # (Madhya Pradesh): (0091) 9098116315
Skype id: michael_matheke

http://www.realmedicinefoundation.org/

--
Amelia Sagoff

5

Great thanks. Sorry for all the questions with obvious answers.

-sent from my android-

··· On 1 Nov 2012 21:08, "Amelia Sagoff" wrote:

HQ classifies as case as "inactive" in the Case Activity Report if the
case has not been modified (no form has been filled out against the case)
in the past 120 days.

To see full definitions of how each column in the case activity report
works, hover your mouse over the (?) symbol in each column header.

Amelia

On Thu, Nov 1, 2012 at 11:35 AM, michael matheke < michael.matheke@gmail.com> wrote:

Thanks Amelia, weve been following up based on last.modified. When does
hq classify a case as inactive?

-sent from my android-
On 1 Nov 2012 21:03, "Amelia Sagoff" asagoff@dimagi.com wrote:

Hi Michael,

An easy way to do this would be to export all the currently open cases
from the Export Cases, Referral, and Users page. The data exported to
excel will include the date the case was last modified (column
"modified_on"). In excel, you can easily sort the data by this date and
discard any inactive cases.

For guidance on how to use excel to sort & filter, see our documentation
here:
Sorting & Auto Filters - CommCare Public - CommCare Public

Amelia

On Thu, Nov 1, 2012 at 12:32 AM, michael matheke < michael.matheke@gmail.com> wrote:

Hi All,

Is there an easy way on HQ to download an excel list of inactive cases?

Thanks,

Michael

--
Michael Matheke-Fischer
Director of Programs - India
Real Medicine Foundation
Mobile # (Delhi): (0091) 9971234868
Mobile # (Madhya Pradesh): (0091) 9098116315
Skype id: michael_matheke

http://www.realmedicinefoundation.org/

--
Amelia Sagoff

6

We love all questions! If you are wondering about something, chances are
someone else on the commcare-users list is too.

Thanks!
Amelia

··· On Thu, Nov 1, 2012 at 11:43 AM, michael matheke wrote:

Great thanks. Sorry for all the questions with obvious answers.

-sent from my android-
On 1 Nov 2012 21:08, "Amelia Sagoff" amsagoff@gmail.com wrote:

HQ classifies as case as "inactive" in the Case Activity Report if the
case has not been modified (no form has been filled out against the case)
in the past 120 days.

To see full definitions of how each column in the case activity report
works, hover your mouse over the (?) symbol in each column header.

Amelia

On Thu, Nov 1, 2012 at 11:35 AM, michael matheke < michael.matheke@gmail.com> wrote:

Thanks Amelia, weve been following up based on last.modified. When does
hq classify a case as inactive?

-sent from my android-
On 1 Nov 2012 21:03, "Amelia Sagoff" asagoff@dimagi.com wrote:

Hi Michael,

An easy way to do this would be to export all the currently open cases
from the Export Cases, Referral, and Users page. The data exported to
excel will include the date the case was last modified (column
"modified_on"). In excel, you can easily sort the data by this date and
discard any inactive cases.

For guidance on how to use excel to sort & filter, see our
documentation here:
Sorting & Auto Filters - CommCare Public - CommCare Public

Amelia

On Thu, Nov 1, 2012 at 12:32 AM, michael matheke < michael.matheke@gmail.com> wrote:

Hi All,

Is there an easy way on HQ to download an excel list of inactive cases?

Thanks,

Michael

--
Michael Matheke-Fischer
Director of Programs - India
Real Medicine Foundation
Mobile # (Delhi): (0091) 9971234868
Mobile # (Madhya Pradesh): (0091) 9098116315
Skype id: michael_matheke

http://www.realmedicinefoundation.org/

--
Amelia Sagoff

--
Amelia Sagoff