← Back to team overview

dhis2-users team mailing list archive

Re: Avoid double registration of Tracked entities

 

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

Thanks,

Georgi

From: Olav Poppe [mailto:olav.poppe@xxxxxx]
Sent: Tuesday, September 12, 2017 12:08 PM
To: Georgi Chakarov <georgi@xxxxxxxxxxxxxxxxxxx>
Cc: Adebusoye Anifalaje <busoye@xxxxxxxxxxxxxx>; DHIS Users <dhis2-users@xxxxxxxxxxxxxxxxxxx>; dhis2-devs@xxxxxxxxxxxxxxxxxxx
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


12. sep. 2017 kl. 09.38 skrev Georgi Chakarov <georgi@xxxxxxxxxxxxxxxxxxx<mailto:georgi@xxxxxxxxxxxxxxxxxxx>>:

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<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,

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@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

_______________________________________________
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


References