Avoid double registration of Tracked entities

Hello!

Is there a way to avoid a double registration of Tracked entities? E.g. the attributes are Name, Surname, Date of Birth, can I create a program rule that searches if all three values match existing records to prompt a message that a person with such attributes already exists? Another suggestion is also welcome.

Regards,

Georgi

Georgi Chakarov, CIA | georgi@logicaloutcomes.net | +1-647-478-5634 x 104 | LogicalOutcomes c/o Centre for Social Innovation, 720 Bathurst Street, Toronto Canada M5S 2R4 | * You may unsubscribe from receiving commercial electronic messages from LogicalOutcomes by emailing *info@logicaloutcomes.net

Has anyone responded to this? Am also very interested.

Thanks

···

On Sep 10, 2017 11:22 AM, “Georgi Chakarov” georgi@logicaloutcomes.net wrote:

Hello!

Is there a way to avoid a double registration of Tracked entities? E.g. the attributes are Name, Surname, Date of Birth, can I create a program rule that searches if all three values match existing records to prompt a message that a person with such attributes already exists? Another suggestion is also welcome.

Regards,

Georgi

Georgi Chakarov, CIA | georgi@logicaloutcomes.net | +1-647-478-5634 x 104 | LogicalOutcomes c/o Centre for Social Innovation, 720 Bathurst Street, Toronto Canada M5S 2R4 | * You may unsubscribe from receiving commercial electronic messages from LogicalOutcomes by emailing *info@logicaloutcomes.net


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Hi,

The only possibility we have at the moment is if you make those attributes unique.

···

On Tue, Sep 12, 2017 at 7:10 AM, Stanley Kalyati skalyati@gmail.com wrote:

Has anyone responded to this? Am also very interested.

Thanks


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Abyot A. Gizaw.

Senior Engineer, DHIS2

University of Oslo

http://www.dhis2.org

On Sep 10, 2017 11:22 AM, “Georgi Chakarov” georgi@logicaloutcomes.net wrote:

Hello!

Is there a way to avoid a double registration of Tracked entities? E.g. the attributes are Name, Surname, Date of Birth, can I create a program rule that searches if all three values match existing records to prompt a message that a person with such attributes already exists? Another suggestion is also welcome.

Regards,

Georgi

Georgi Chakarov, CIA | georgi@logicaloutcomes.net | +1-647-478-5634 x 104 | LogicalOutcomes c/o Centre for Social Innovation, 720 Bathurst Street, Toronto Canada M5S 2R4 | * You may unsubscribe from receiving commercial electronic messages from LogicalOutcomes by emailing *info@logicaloutcomes.net


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Hi,

This will not work, because each of this attributes can have a duplicate. E.g. you might have two persons by the name of “John”. It is the combination of those attributes that needs to be unique, as it is less likely to have two people with the same First Name and Surname, born on the same date.

There should be another solution. Our clients are very surprised how a system is unable to lookup in the existing records and identify duplicates. Anyone?

Georgi

···

Hi,

The only possibility we have at the moment is if you make those attributes unique.

Abyot A. Gizaw.

Senior Engineer, DHIS2

University of Oslo

http://www.dhis2.org

On Tue, Sep 12, 2017 at 7:10 AM, Stanley Kalyati skalyati@gmail.com wrote:

Has anyone responded to this? Am also very interested.

Thanks

On Sep 10, 2017 11:22 AM, “Georgi Chakarov” georgi@logicaloutcomes.net wrote:

Hello!

Is there a way to avoid a double registration of Tracked entities? E.g. the attributes are Name, Surname, Date of Birth, can I create a program rule that searches if all three values match existing records to prompt a message that a person with such attributes already exists? Another suggestion is also welcome.

Regards,

Georgi

Georgi Chakarov, CIA | georgi@logicaloutcomes.net | +1-647-478-5634 x 104 | LogicalOutcomes c/o Centre for Social Innovation, 720 Bathurst Street, Toronto Canada M5S 2R4 | * You may unsubscribe from receiving commercial electronic messages from LogicalOutcomes by emailing *info@logicaloutcomes.net


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Hi Georgi,

You can always create a query that identifies duplicates based on any number or combination of parameters. The query could then be wrapped in a report that end users can run ad hoc.

Best

- -

Busoye Anifalaje (PhD)
Director of Services (Principal), BAO Systems
UK: +44 7901-740-757 | US: +1 682-307-0986|
busoye@baosystems.com <mailto:busoye@baosystems.com> | http://www.baosystems.com <http://www.baosystems.com/> |
Skype: busoye | 2900 K Street, Suite 406, Washington D.C. 20007

···

On 12 Sep 2017, at 08:18, Georgi Chakarov <georgi@logicaloutcomes.net> wrote:

Hi,

This will not work, because each of this attributes can have a duplicate. E.g. you might have two persons by the name of “John”. It is the combination of those attributes that needs to be unique, as it is less likely to have two people with the same First Name and Surname, born on the same date.

There should be another solution. Our clients are very surprised how a system is unable to lookup in the existing records and identify duplicates. Anyone?

Georgi

From: Abyot Asalefew Gizaw [mailto:abyot@dhis2.org <mailto:abyot@dhis2.org>]
Sent: Tuesday, September 12, 2017 10:13 AM
To: Stanley Kalyati <skalyati@gmail.com <mailto:skalyati@gmail.com>>
Cc: Georgi Chakarov <georgi@logicaloutcomes.net <mailto:georgi@logicaloutcomes.net>>; DHIS Users <dhis2-users@lists.launchpad.net <mailto:dhis2-users@lists.launchpad.net>>; DHIS 2 Developers list <dhis2-devs@lists.launchpad.net <mailto:dhis2-devs@lists.launchpad.net>>
Subject: Re: [Dhis2-users] Avoid double registration of Tracked entities

Hi,

The only possibility we have at the moment is if you make those attributes unique.

--
Abyot A. Gizaw.
Senior Engineer, DHIS2
University of Oslo
http://www.dhis2.org <http://www.dhis2.org/>

On Tue, Sep 12, 2017 at 7:10 AM, Stanley Kalyati <skalyati@gmail.com <mailto:skalyati@gmail.com>> wrote:
Has anyone responded to this? Am also very interested.

Thanks

On Sep 10, 2017 11:22 AM, "Georgi Chakarov" <georgi@logicaloutcomes.net <mailto:georgi@logicaloutcomes.net>> wrote:
Hello!

Is there a way to avoid a double registration of Tracked entities? E.g. the attributes are Name, Surname, Date of Birth, can I create a program rule that searches if all three values match existing records to prompt a message that a person with such attributes already exists? Another suggestion is also welcome.

Regards,

Georgi

Georgi Chakarov, CIA | georgi@logicaloutcomes.net <mailto:georgi@logicaloutcomes.net> | +1-647-478-5634 x 104 <tel:(647)%20478-5634> | LogicalOutcomes c/o Centre for Social Innovation, 720 Bathurst Street, Toronto Canada M5S 2R4 | You may unsubscribe from receiving commercial electronic messages from LogicalOutcomes by emailing info@logicaloutcomes.net <mailto:info@logicaloutcomes.net>

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net <mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net <mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net <mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

Yes, we are aware of the limitation and we are working on to improve that. See here https://jira.dhis2.org/browse/DHIS2-677

At the moment you can only achieve that if you have something like national id or other unique ids.

···

On Tue, Sep 12, 2017 at 9:18 AM, Georgi Chakarov georgi@logicaloutcomes.net wrote:

Hi,

This will not work, because each of this attributes can have a duplicate. E.g. you might have two persons by the name of “John”. It is the combination of those attributes that needs to be unique, as it is less likely to have two people with the same First Name and Surname, born on the same date.

There should be another solution. Our clients are very surprised how a system is unable to lookup in the existing records and identify duplicates. Anyone?

Georgi

From: Abyot Asalefew Gizaw [mailto:abyot@dhis2.org]

Sent: Tuesday, September 12, 2017 10:13 AM

To: Stanley Kalyati skalyati@gmail.com

Cc: Georgi Chakarov georgi@logicaloutcomes.net; DHIS Users dhis2-users@lists.launchpad.net; DHIS 2 Developers list dhis2-devs@lists.launchpad.net

Subject: Re: [Dhis2-users] Avoid double registration of Tracked entities

Hi,

The only possibility we have at the moment is if you make those attributes unique.

Abyot A. Gizaw.

Senior Engineer, DHIS2

University of Oslo

http://www.dhis2.org

On Tue, Sep 12, 2017 at 7:10 AM, Stanley Kalyati skalyati@gmail.com wrote:

Has anyone responded to this? Am also very interested.

Thanks

On Sep 10, 2017 11:22 AM, “Georgi Chakarov” georgi@logicaloutcomes.net wrote:

Hello!

Is there a way to avoid a double registration of Tracked entities? E.g. the attributes are Name, Surname, Date of Birth, can I create a program rule that searches if all three values match existing records to prompt a message that a person with such attributes already exists? Another suggestion is also welcome.

Regards,

Georgi

Georgi Chakarov, CIA | georgi@logicaloutcomes.net | +1-647-478-5634 x 104 | LogicalOutcomes c/o Centre for Social Innovation, 720 Bathurst Street, Toronto Canada M5S 2R4 | * You may unsubscribe from receiving commercial electronic messages from LogicalOutcomes by emailing *info@logicaloutcomes.net


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Abyot A. Gizaw.

Senior Engineer, DHIS2

University of Oslo

http://www.dhis2.org

Hello Adebusoye!

Nice to hear from you again, since our meeting in London at the WW Summit!

Thank you for your thoughts! The thing is, I can’t really tell data entry people, working on the field to run a query. They simply can’t. This needs to be a user interface solution. Do you have other ideas in mind?

Georgi

image

···

From: Adebusoye Anifalaje [mailto:busoye@baosystems.com]

Sent: Tuesday, September 12, 2017 10:23 AM

To: Georgi Chakarov georgi@logicaloutcomes.net

Cc: Abyot Asalefew Gizaw abyot@dhis2.org; Stanley Kalyati skalyati@gmail.com; dhis2-users@lists.launchpad.net; DHIS 2 developers dhis2-devs@lists.launchpad.net

Subject: Re: [Dhis2-users] Avoid double registration of Tracked entities

Hi Georgi,

You can always create a query that identifies duplicates based on any number or combination of parameters. The query could then be wrapped in a report that end users can run ad hoc.

Best

Busoye Anifalaje (PhD)

Director of Services (Principal), BAO Systems

UK: +44 7901-740-757 | US: +1 682-307-0986|

busoye@baosystems.com | http://www.baosystems.com |

Skype: busoye | 2900 K Street, Suite 406, Washington D.C. 20007

On 12 Sep 2017, at 08:18, Georgi Chakarov georgi@logicaloutcomes.net wrote:

Hi,

This will not work, because each of this attributes can have a duplicate. E.g. you might have two persons by the name of “John”. It is the combination of those attributes that needs to be unique, as it is less likely to have two people with the same First Name and Surname, born on the same date.

There should be another solution. Our clients are very surprised how a system is unable to lookup in the existing records and identify duplicates. Anyone?

Georgi

From: Abyot Asalefew Gizaw [mailto:abyot@dhis2.org]

Sent: Tuesday, September 12, 2017 10:13 AM

To: Stanley Kalyati skalyati@gmail.com

Cc: Georgi Chakarov georgi@logicaloutcomes.net; DHIS Users <dhis2-users@lists.launchpad.net >; DHIS 2 Developers list dhis2-devs@lists.launchpad.net

Subject: Re: [Dhis2-users] Avoid double registration of Tracked entities

Hi,

The only possibility we have at the moment is if you make those attributes unique.

Abyot A. Gizaw.

Senior Engineer, DHIS2

University of Oslo

http://www.dhis2.org

On Tue, Sep 12, 2017 at 7:10 AM, Stanley Kalyati skalyati@gmail.com wrote:

Has anyone responded to this? Am also very interested.

Thanks

On Sep 10, 2017 11:22 AM, “Georgi Chakarov” georgi@logicaloutcomes.net wrote:

Hello!

Is there a way to avoid a double registration of Tracked entities? E.g. the attributes are Name, Surname, Date of Birth, can I create a program rule that searches if all three values match existing records to prompt a message that a person with such attributes already exists? Another suggestion is also welcome.

Regards,

Georgi

Georgi Chakarov, CIA | georgi@logicaloutcomes.net | +1-647-478-5634 x 104 | LogicalOutcomes c/o Centre for Social Innovation, 720 Bathurst Street, Toronto Canada M5S 2R4 | * You may unsubscribe from receiving commercial electronic messages from LogicalOutcomes by emailing *info@logicaloutcomes.net


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Hi Georgi,

Great to connect again.

Abyot is right: unless you implement a unique identifier scheme for each record, there is currently no way to achieve what you want. If you can wait, the feature will eventually make it into the core s/w.

Alternatively, if you can’t wait, what I was proposing was not for end users to run a query. Rather, the query would already be created with a standard report template (HTML?) to go with it. The end user would only be required to click on generate report. You can add parameters to the report like org unit (e.g. looking for duplicates within a specific org unit).

Not sure you have many options at this stage.

Cheers.
    
- -

Busoye Anifalaje (PhD)
Director of Services (Principal), BAO Systems
UK: +44 7901-740-757 | US: +1 682-307-0986|
busoye@baosystems.com <mailto:busoye@baosystems.com> | http://www.baosystems.com <http://www.baosystems.com/> |
Skype: busoye | 2900 K Street, Suite 406, Washington D.C. 20007

···

On 12 Sep 2017, at 08:27, Georgi Chakarov <georgi@logicaloutcomes.net> wrote:

Hello Adebusoye!

Nice to hear from you again, since our meeting in London at the WW Summit!

Thank you for your thoughts! The thing is, I can’t really tell data entry people, working on the field to run a query. They simply can’t. This needs to be a user interface solution. Do you have other ideas in mind?

Georgi

From: Adebusoye Anifalaje [mailto:busoye@baosystems.com <mailto:busoye@baosystems.com>]
Sent: Tuesday, September 12, 2017 10:23 AM
To: Georgi Chakarov <georgi@logicaloutcomes.net <mailto:georgi@logicaloutcomes.net>>
Cc: Abyot Asalefew Gizaw <abyot@dhis2.org <mailto:abyot@dhis2.org>>; Stanley Kalyati <skalyati@gmail.com <mailto:skalyati@gmail.com>>; dhis2-users@lists.launchpad.net <mailto:dhis2-users@lists.launchpad.net>; DHIS 2 developers <dhis2-devs@lists.launchpad.net <mailto:dhis2-devs@lists.launchpad.net>>
Subject: Re: [Dhis2-users] Avoid double registration of Tracked entities

Hi Georgi,

You can always create a query that identifies duplicates based on any number or combination of parameters. The query could then be wrapped in a report that end users can run ad hoc.

Best

- -

<image001.png>

Busoye Anifalaje (PhD)
Director of Services (Principal), BAO Systems
UK: +44 7901-740-757 | US: +1 682-307-0986|
busoye@baosystems.com <mailto:busoye@baosystems.com> | http://www.baosystems.com <http://www.baosystems.com/> |
Skype: busoye | 2900 K Street, Suite 406, Washington D.C. 20007

On 12 Sep 2017, at 08:18, Georgi Chakarov <georgi@logicaloutcomes.net <mailto:georgi@logicaloutcomes.net>> wrote:

Hi,

This will not work, because each of this attributes can have a duplicate. E.g. you might have two persons by the name of “John”. It is the combination of those attributes that needs to be unique, as it is less likely to have two people with the same First Name and Surname, born on the same date.

There should be another solution. Our clients are very surprised how a system is unable to lookup in the existing records and identify duplicates. Anyone?

Georgi

From: Abyot Asalefew Gizaw [mailto:abyot@dhis2.org <mailto:abyot@dhis2.org>]
Sent: Tuesday, September 12, 2017 10:13 AM
To: Stanley Kalyati <skalyati@gmail.com <mailto:skalyati@gmail.com>>
Cc: Georgi Chakarov <georgi@logicaloutcomes.net <mailto:georgi@logicaloutcomes.net>>; DHIS Users <dhis2-users@lists.launchpad.net <mailto:dhis2-users@lists.launchpad.net>>; DHIS 2 Developers list <dhis2-devs@lists.launchpad.net <mailto:dhis2-devs@lists.launchpad.net>>
Subject: Re: [Dhis2-users] Avoid double registration of Tracked entities

Hi,

The only possibility we have at the moment is if you make those attributes unique.

--
Abyot A. Gizaw.
Senior Engineer, DHIS2
University of Oslo
http://www.dhis2.org <http://www.dhis2.org/>

On Tue, Sep 12, 2017 at 7:10 AM, Stanley Kalyati <skalyati@gmail.com <mailto:skalyati@gmail.com>> wrote:
Has anyone responded to this? Am also very interested.

Thanks

On Sep 10, 2017 11:22 AM, "Georgi Chakarov" <georgi@logicaloutcomes.net <mailto:georgi@logicaloutcomes.net>> wrote:
Hello!

Is there a way to avoid a double registration of Tracked entities? E.g. the attributes are Name, Surname, Date of Birth, can I create a program rule that searches if all three values match existing records to prompt a message that a person with such attributes already exists? Another suggestion is also welcome.

Regards,

Georgi

Georgi Chakarov, CIA | georgi@logicaloutcomes.net <mailto:georgi@logicaloutcomes.net> | +1-647-478-5634 x 104 <tel:(647)%20478-5634> | LogicalOutcomes c/o Centre for Social Innovation, 720 Bathurst Street, Toronto Canada M5S 2R4 | You may unsubscribe from receiving commercial electronic messages from LogicalOutcomes by emailing info@logicaloutcomes.net <mailto:info@logicaloutcomes.net>

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net <mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net <mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net <mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

Thank you both!

I will implement the unique ID for the time being, although the client does not always have an ID for its clients, especially for babies. The other thing is that they want ID’s to be automatically generated by DHIS2, which excludes the option of anchoring around the ID. Anyhow…

Thanks again!

Georgi

image

···

From: Adebusoye Anifalaje [mailto:busoye@baosystems.com]

Sent: Tuesday, September 12, 2017 10:34 AM

To: Georgi Chakarov georgi@logicaloutcomes.net

Cc: Abyot Asalefew Gizaw abyot@dhis2.org; Stanley Kalyati skalyati@gmail.com; dhis2-users@lists.launchpad.net; DHIS 2 developers dhis2-devs@lists.launchpad.net

Subject: Re: [Dhis2-users] Avoid double registration of Tracked entities

Hi Georgi,

Great to connect again.

Abyot is right: unless you implement a unique identifier scheme for each record, there is currently no way to achieve what you want. If you can wait, the feature will eventually make it into the core s/w.

Alternatively, if you can’t wait, what I was proposing was not for end users to run a query. Rather, the query would already be created with a standard report template (HTML?) to go with it. The end user would only be required to click on generate report. You can add parameters to the report like org unit (e.g. looking for duplicates within a specific org unit).

Not sure you have many options at this stage.

Cheers.

Busoye Anifalaje (PhD)

Director of Services (Principal), BAO Systems

UK: +44 7901-740-757 | US: +1 682-307-0986|

busoye@baosystems.com | http://www.baosystems.com |

Skype: busoye | 2900 K Street, Suite 406, Washington D.C. 20007

On 12 Sep 2017, at 08:27, Georgi Chakarov georgi@logicaloutcomes.net wrote:

Hello Adebusoye!

Nice to hear from you again, since our meeting in London at the WW Summit!

Thank you for your thoughts! The thing is, I can’t really tell data entry people, working on the field to run a query. They simply can’t. This needs to be a user interface solution. Do you have other ideas in mind?

Georgi

From: Adebusoye Anifalaje [mailto:busoye@baosystems.com]

Sent: Tuesday, September 12, 2017 10:23 AM

To: Georgi Chakarov georgi@logicaloutcomes.net

Cc: Abyot Asalefew Gizaw abyot@dhis2.org; Stanley Kalyati skalyati@gmail.com; dhis2-users@lists.launchpad.net ; DHIS 2 developers dhis2-devs@lists.launchpad.net

Subject: Re: [Dhis2-users] Avoid double registration of Tracked entities

Hi Georgi,

You can always create a query that identifies duplicates based on any number or combination of parameters. The query could then be wrapped in a report that end users can run ad hoc.

Best

**

<image001.png>

**

Busoye Anifalaje (PhD)

Director of Services (Principal), BAO Systems

UK: +44 7901-740-757 | US: +1 682-307-0986|

busoye@baosystems.com | http://www.baosystems.com |

Skype: busoye | 2900 K Street, Suite 406, Washington D.C. 20007

On 12 Sep 2017, at 08:18, Georgi Chakarov georgi@logicaloutcomes.net wrote:

Hi,

This will not work, because each of this attributes can have a duplicate. E.g. you might have two persons by the name of “John”. It is the combination of those attributes that needs to be unique, as it is less likely to have two people with the same First Name and Surname, born on the same date.

There should be another solution. Our clients are very surprised how a system is unable to lookup in the existing records and identify duplicates. Anyone?

Georgi

From: Abyot Asalefew Gizaw [mailto:abyot@dhis2.org]

Sent: Tuesday, September 12, 2017 10:13 AM

To: Stanley Kalyati skalyati@gmail.com

Cc: Georgi Chakarov georgi@logicaloutcomes.net; DHIS Users <dhis2-users@lists.launchpad.net >; DHIS 2 Developers list dhis2-devs@lists.launchpad.net

Subject: Re: [Dhis2-users] Avoid double registration of Tracked entities

Hi,

The only possibility we have at the moment is if you make those attributes unique.

Abyot A. Gizaw.

Senior Engineer, DHIS2

University of Oslo

http://www.dhis2.org

On Tue, Sep 12, 2017 at 7:10 AM, Stanley Kalyati skalyati@gmail.com wrote:

Has anyone responded to this? Am also very interested.

Thanks

On Sep 10, 2017 11:22 AM, “Georgi Chakarov” georgi@logicaloutcomes.net wrote:

Hello!

Is there a way to avoid a double registration of Tracked entities? E.g. the attributes are Name, Surname, Date of Birth, can I create a program rule that searches if all three values match existing records to prompt a message that a person with such attributes already exists? Another suggestion is also welcome.

Regards,

Georgi

Georgi Chakarov, CIA | georgi@logicaloutcomes.net | +1-647-478-5634 x 104 | LogicalOutcomes c/o Centre for Social Innovation, 720 Bathurst Street, Toronto Canada M5S 2R4 | * You may unsubscribe from receiving commercial electronic messages from LogicalOutcomes by emailing *info@logicaloutcomes.net


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Hi,
haven’t tested if this is even possible with attributes, but with the program rule ASSIGN functionality, you could potentially have a program rule that concatenates your different attributes into one, and you have a unique constrain on that. For example if you have first name, last name, date of birth as variables, you make a "unique id" attribute which is "John-Doe-20170843".

Just a thought.

Regards
Olav

···

12. sep. 2017 kl. 09.38 skrev Georgi Chakarov <georgi@logicaloutcomes.net>:

Thank you both!

I will implement the unique ID for the time being, although the client does not always have an ID for its clients, especially for babies. The other thing is that they want ID’s to be automatically generated by DHIS2, which excludes the option of anchoring around the ID. Anyhow…

Thanks again!

Georgi

From: Adebusoye Anifalaje [mailto:busoye@baosystems.com <mailto:busoye@baosystems.com>]
Sent: Tuesday, September 12, 2017 10:34 AM
To: Georgi Chakarov <georgi@logicaloutcomes.net <mailto:georgi@logicaloutcomes.net>>
Cc: Abyot Asalefew Gizaw <abyot@dhis2.org <mailto:abyot@dhis2.org>>; Stanley Kalyati <skalyati@gmail.com <mailto:skalyati@gmail.com>>; dhis2-users@lists.launchpad.net <mailto:dhis2-users@lists.launchpad.net>; DHIS 2 developers <dhis2-devs@lists.launchpad.net <mailto:dhis2-devs@lists.launchpad.net>>
Subject: Re: [Dhis2-users] Avoid double registration of Tracked entities

Hi Georgi,

Great to connect again.

Abyot is right: unless you implement a unique identifier scheme for each record, there is currently no way to achieve what you want. If you can wait, the feature will eventually make it into the core s/w.

Alternatively, if you can’t wait, what I was proposing was not for end users to run a query. Rather, the query would already be created with a standard report template (HTML?) to go with it. The end user would only be required to click on generate report. You can add parameters to the report like org unit (e.g. looking for duplicates within a specific org unit).

Not sure you have many options at this stage.

Cheers.
    
- -

<image001.png>

Busoye Anifalaje (PhD)
Director of Services (Principal), BAO Systems
UK: +44 7901-740-757 | US: +1 682-307-0986|
busoye@baosystems.com <mailto:busoye@baosystems.com> | http://www.baosystems.com <http://www.baosystems.com/> |
Skype: busoye | 2900 K Street, Suite 406, Washington D.C. 20007

On 12 Sep 2017, at 08:27, Georgi Chakarov <georgi@logicaloutcomes.net <mailto:georgi@logicaloutcomes.net>> wrote:

Hello Adebusoye!

Nice to hear from you again, since our meeting in London at the WW Summit!

Thank you for your thoughts! The thing is, I can’t really tell data entry people, working on the field to run a query. They simply can’t. This needs to be a user interface solution. Do you have other ideas in mind?

Georgi

From: Adebusoye Anifalaje [mailto:busoye@baosystems.com <mailto:busoye@baosystems.com>]
Sent: Tuesday, September 12, 2017 10:23 AM
To: Georgi Chakarov <georgi@logicaloutcomes.net <mailto:georgi@logicaloutcomes.net>>
Cc: Abyot Asalefew Gizaw <abyot@dhis2.org <mailto:abyot@dhis2.org>>; Stanley Kalyati <skalyati@gmail.com <mailto:skalyati@gmail.com>>; dhis2-users@lists.launchpad.net <mailto:dhis2-users@lists.launchpad.net>; DHIS 2 developers <dhis2-devs@lists.launchpad.net <mailto:dhis2-devs@lists.launchpad.net>>
Subject: Re: [Dhis2-users] Avoid double registration of Tracked entities

Hi Georgi,

You can always create a query that identifies duplicates based on any number or combination of parameters. The query could then be wrapped in a report that end users can run ad hoc.

Best

- -

<image001.png>

Busoye Anifalaje (PhD)
Director of Services (Principal), BAO Systems
UK: +44 7901-740-757 | US: +1 682-307-0986|
busoye@baosystems.com <mailto:busoye@baosystems.com> | http://www.baosystems.com <http://www.baosystems.com/> |
Skype: busoye | 2900 K Street, Suite 406, Washington D.C. 20007

On 12 Sep 2017, at 08:18, Georgi Chakarov <georgi@logicaloutcomes.net <mailto:georgi@logicaloutcomes.net>> wrote:

Hi,

This will not work, because each of this attributes can have a duplicate. E.g. you might have two persons by the name of “John”. It is the combination of those attributes that needs to be unique, as it is less likely to have two people with the same First Name and Surname, born on the same date.

There should be another solution. Our clients are very surprised how a system is unable to lookup in the existing records and identify duplicates. Anyone?

Georgi

From: Abyot Asalefew Gizaw [mailto:abyot@dhis2.org <mailto:abyot@dhis2.org>]
Sent: Tuesday, September 12, 2017 10:13 AM
To: Stanley Kalyati <skalyati@gmail.com <mailto:skalyati@gmail.com>>
Cc: Georgi Chakarov <georgi@logicaloutcomes.net <mailto:georgi@logicaloutcomes.net>>; DHIS Users <dhis2-users@lists.launchpad.net <mailto:dhis2-users@lists.launchpad.net>>; DHIS 2 Developers list <dhis2-devs@lists.launchpad.net <mailto:dhis2-devs@lists.launchpad.net>>
Subject: Re: [Dhis2-users] Avoid double registration of Tracked entities

Hi,

The only possibility we have at the moment is if you make those attributes unique.

--
Abyot A. Gizaw.
Senior Engineer, DHIS2
University of Oslo
http://www.dhis2.org <http://www.dhis2.org/>

On Tue, Sep 12, 2017 at 7:10 AM, Stanley Kalyati <skalyati@gmail.com <mailto:skalyati@gmail.com>> wrote:
Has anyone responded to this? Am also very interested.

Thanks

On Sep 10, 2017 11:22 AM, "Georgi Chakarov" <georgi@logicaloutcomes.net <mailto:georgi@logicaloutcomes.net>> wrote:
Hello!

Is there a way to avoid a double registration of Tracked entities? E.g. the attributes are Name, Surname, Date of Birth, can I create a program rule that searches if all three values match existing records to prompt a message that a person with such attributes already exists? Another suggestion is also welcome.

Regards,

Georgi

Georgi Chakarov, CIA | georgi@logicaloutcomes.net <mailto:georgi@logicaloutcomes.net> | +1-647-478-5634 x 104 <tel:(647)%20478-5634> | LogicalOutcomes c/o Centre for Social Innovation, 720 Bathurst Street, Toronto Canada M5S 2R4 | You may unsubscribe from receiving commercial electronic messages from LogicalOutcomes by emailing info@logicaloutcomes.net <mailto:info@logicaloutcomes.net>

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net <mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net <mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net <mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net <mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

This is a good one! I will test it and let you know.

Thanks,

Georgi

···

From: Olav Poppe [mailto:olav.poppe@me.com]

Sent: Tuesday, September 12, 2017 12:08 PM

To: Georgi Chakarov georgi@logicaloutcomes.net

Cc: Adebusoye Anifalaje busoye@baosystems.com; DHIS Users dhis2-users@lists.launchpad.net; dhis2-devs@lists.launchpad.net

Subject: Re: [Dhis2-users] Avoid double registration of Tracked entities

Hi,

haven’t tested if this is even possible with attributes, but with the program rule ASSIGN functionality, you could potentially have a program rule that concatenates your different attributes into one, and you have a unique constrain on that. For example if you have first name, last name, date of birth as variables, you make a “unique id” attribute which is “John-Doe-20170843”.

Just a thought.

Regards

Olav

  1. sep. 2017 kl. 09.38 skrev Georgi Chakarov georgi@logicaloutcomes.net:

Thank you both!

I will implement the unique ID for the time being, although the client does not always have an ID for its clients, especially for babies. The other thing is that they want ID’s to be automatically generated by DHIS2, which excludes the option of anchoring around the ID. Anyhow…

Thanks again!

Georgi

From: Adebusoye Anifalaje [mailto:busoye@baosystems.com]

Sent: Tuesday, September 12, 2017 10:34 AM

To: Georgi Chakarov georgi@logicaloutcomes.net

Cc: Abyot Asalefew Gizaw abyot@dhis2.org; Stanley Kalyati skalyati@gmail.com; dhis2-users@lists.launchpad.net ; DHIS 2 developers dhis2-devs@lists.launchpad.net

Subject: Re: [Dhis2-users] Avoid double registration of Tracked entities

Hi Georgi,

Great to connect again.

Abyot is right: unless you implement a unique identifier scheme for each record, there is currently no way to achieve what you want. If you can wait, the feature will eventually make it into the core s/w.

Alternatively, if you can’t wait, what I was proposing was not for end users to run a query. Rather, the query would already be created with a standard report template (HTML?) to go with it. The end user would only be required to click on generate report. You can add parameters to the report like org unit (e.g. looking for duplicates within a specific org unit).

Not sure you have many options at this stage.

Cheers.

**

<image001.png>

**

Busoye Anifalaje (PhD)

Director of Services (Principal), BAO Systems

UK: +44 7901-740-757 | US: +1 682-307-0986|

busoye@baosystems.com | http://www.baosystems.com |

Skype: busoye | 2900 K Street, Suite 406, Washington D.C. 20007

On 12 Sep 2017, at 08:27, Georgi Chakarov georgi@logicaloutcomes.net wrote:

Hello Adebusoye!

Nice to hear from you again, since our meeting in London at the WW Summit!

Thank you for your thoughts! The thing is, I can’t really tell data entry people, working on the field to run a query. They simply can’t. This needs to be a user interface solution. Do you have other ideas in mind?

Georgi

From: Adebusoye Anifalaje [mailto:busoye@baosystems.com]

Sent: Tuesday, September 12, 2017 10:23 AM

To: Georgi Chakarov georgi@logicaloutcomes.net

Cc: Abyot Asalefew Gizaw abyot@dhis2.org; Stanley Kalyati skalyati@gmail.com; dhis2-users@lists.launchpad.net ; DHIS 2 developers dhis2-devs@lists.launchpad.net

Subject: Re: [Dhis2-users] Avoid double registration of Tracked entities

Hi Georgi,

You can always create a query that identifies duplicates based on any number or combination of parameters. The query could then be wrapped in a report that end users can run ad hoc.

Best

**

<image001.png>

**

Busoye Anifalaje (PhD)

Director of Services (Principal), BAO Systems

UK: +44 7901-740-757 | US: +1 682-307-0986|

busoye@baosystems.com | http://www.baosystems.com |

Skype: busoye | 2900 K Street, Suite 406, Washington D.C. 20007

On 12 Sep 2017, at 08:18, Georgi Chakarov georgi@logicaloutcomes.net wrote:

Hi,

This will not work, because each of this attributes can have a duplicate. E.g. you might have two persons by the name of “John”. It is the combination of those attributes that needs to be unique, as it is less likely to have two people with the same First Name and Surname, born on the same date.

There should be another solution. Our clients are very surprised how a system is unable to lookup in the existing records and identify duplicates. Anyone?

Georgi

From: Abyot Asalefew Gizaw [mailto:abyot@dhis2.org]

Sent: Tuesday, September 12, 2017 10:13 AM

To: Stanley Kalyati skalyati@gmail.com

Cc: Georgi Chakarov georgi@logicaloutcomes.net; DHIS Users <dhis2-users@lists.launchpad.net >; DHIS 2 Developers list dhis2-devs@lists.launchpad.net

Subject: Re: [Dhis2-users] Avoid double registration of Tracked entities

Hi,

The only possibility we have at the moment is if you make those attributes unique.

Abyot A. Gizaw.

Senior Engineer, DHIS2

University of Oslo

http://www.dhis2.org

On Tue, Sep 12, 2017 at 7:10 AM, Stanley Kalyati skalyati@gmail.com wrote:

Has anyone responded to this? Am also very interested.

Thanks

On Sep 10, 2017 11:22 AM, “Georgi Chakarov” georgi@logicaloutcomes.net wrote:

Hello!

Is there a way to avoid a double registration of Tracked entities? E.g. the attributes are Name, Surname, Date of Birth, can I create a program rule that searches if all three values match existing records to prompt a message that a person with such attributes already exists? Another suggestion is also welcome.

Regards,

Georgi

Georgi Chakarov, CIA | georgi@logicaloutcomes.net | +1-647-478-5634 x 104 | LogicalOutcomes c/o Centre for Social Innovation, 720 Bathurst Street, Toronto Canada M5S 2R4 | * You may unsubscribe from receiving commercial electronic messages from LogicalOutcomes by emailing *info@logicaloutcomes.net


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp