dhis2-users team mailing list archive

[Olav Poppe <olav.poppe@xxxxxx>]

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