dhis2-users team mailing list archive

Thread
Date

Re: Avoid double registration of Tracked entities

To: Adebusoye Anifalaje <busoye@xxxxxxxxxxxxxx>
From: Georgi Chakarov <georgi@xxxxxxxxxxxxxxxxxxx>
Date: Tue, 12 Sep 2017 07:38:21 +0000
Accept-language: en-US
Authentication-results: spf=none (sender IP is ) smtp.mailfrom=georgi@xxxxxxxxxxxxxxxxxxx;
Cc: "dhis2-users@xxxxxxxxxxxxxxxxxxx" <dhis2-users@xxxxxxxxxxxxxxxxxxx>, DHIS 2 developers <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
In-reply-to: <1CFC5897-4496-4852-ABDB-7795CF671E3F@baosystems.com>
Spamdiagnosticmetadata: NSPM
Spamdiagnosticoutput: 1:99
Thread-index: AdMqFeu84JpdDwQuQP20bDJuT3Sd9wBb4N0AAARFJgAAAAwhsAAAUScAAAAQcTAAAFGcAAAADbFg
Thread-topic: [Dhis2-users] Avoid double registration of Tracked entities

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@xxxxxxxxxxxxxx]
Sent: Tuesday, September 12, 2017 10:34 AM
To: Georgi Chakarov <georgi@xxxxxxxxxxxxxxxxxxx>
Cc: Abyot Asalefew Gizaw <abyot@xxxxxxxxx>; Stanley Kalyati <skalyati@xxxxxxxxx>; dhis2-users@xxxxxxxxxxxxxxxxxxx; DHIS 2 developers <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
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.

- -


[cid:image001.png@01D32BB3.3EF26650]

Busoye Anifalaje (PhD)
Director of Services (Principal), BAO Systems
UK: +44 7901-740-757 | US: +1 682-307-0986|
 busoye@xxxxxxxxxxxxxx<mailto:busoye@xxxxxxxxxxxxxx> | 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@xxxxxxxxxxxxxxxxxxx<mailto:georgi@xxxxxxxxxxxxxxxxxxx>> 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@xxxxxxxxxxxxxx]
Sent: Tuesday, September 12, 2017 10:23 AM
To: Georgi Chakarov <georgi@xxxxxxxxxxxxxxxxxxx<mailto:georgi@xxxxxxxxxxxxxxxxxxx>>
Cc: Abyot Asalefew Gizaw <abyot@xxxxxxxxx<mailto:abyot@xxxxxxxxx>>; Stanley Kalyati <skalyati@xxxxxxxxx<mailto:skalyati@xxxxxxxxx>>; dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>; DHIS 2 developers <dhis2-devs@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx>>
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@xxxxxxxxxxxxxx<mailto:busoye@xxxxxxxxxxxxxx> | 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@xxxxxxxxxxxxxxxxxxx<mailto:georgi@xxxxxxxxxxxxxxxxxxx>> 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@xxxxxxxxx]
Sent: Tuesday, September 12, 2017 10:13 AM
To: Stanley Kalyati <skalyati@xxxxxxxxx<mailto:skalyati@xxxxxxxxx>>
Cc: Georgi Chakarov <georgi@xxxxxxxxxxxxxxxxxxx<mailto:georgi@xxxxxxxxxxxxxxxxxxx>>; DHIS Users <dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>>; DHIS 2 Developers list <dhis2-devs@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx>>
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@xxxxxxxxx<mailto:skalyati@xxxxxxxxx>> wrote:
Has anyone responded to this? Am also very interested.

Thanks

On Sep 10, 2017 11:22 AM, "Georgi Chakarov" <georgi@xxxxxxxxxxxxxxxxxxx<mailto:georgi@xxxxxxxxxxxxxxxxxxx>> 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@xxxxxxxxxxxxxxxxxxx<mailto:georgi@xxxxxxxxxxxxxxxxxxx> | +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@xxxxxxxxxxxxxxxxxxx<mailto:info@xxxxxxxxxxxxxxxxxxx>


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

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

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

Follow ups

Re: Avoid double registration of Tracked entities
From: Olav Poppe, 2017-09-12

References

Avoid double registration of Tracked entities
From: Georgi Chakarov, 2017-09-10
Re: Avoid double registration of Tracked entities
From: Stanley Kalyati, 2017-09-12
Re: Avoid double registration of Tracked entities
From: Abyot Asalefew Gizaw, 2017-09-12
Re: Avoid double registration of Tracked entities
From: Georgi Chakarov, 2017-09-12
Re: Avoid double registration of Tracked entities
From: Adebusoye Anifalaje, 2017-09-12
Re: Avoid double registration of Tracked entities
From: Georgi Chakarov, 2017-09-12
Re: Avoid double registration of Tracked entities
From: Adebusoye Anifalaje, 2017-09-12