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 <geo...@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:bus...@baosystems.com 
> <mailto:bus...@baosystems.com>] 
> Sent: Tuesday, September 12, 2017 10:34 AM
> To: Georgi Chakarov <geo...@logicaloutcomes.net 
> <mailto:geo...@logicaloutcomes.net>>
> Cc: Abyot Asalefew Gizaw <ab...@dhis2.org <mailto:ab...@dhis2.org>>; Stanley 
> Kalyati <skaly...@gmail.com <mailto:skaly...@gmail.com>>; 
> dhis2-us...@lists.launchpad.net <mailto:dhis2-us...@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|
>  bus...@baosystems.com <mailto:bus...@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 <geo...@logicaloutcomes.net 
> <mailto:geo...@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:bus...@baosystems.com 
> <mailto:bus...@baosystems.com>] 
> Sent: Tuesday, September 12, 2017 10:23 AM
> To: Georgi Chakarov <geo...@logicaloutcomes.net 
> <mailto:geo...@logicaloutcomes.net>>
> Cc: Abyot Asalefew Gizaw <ab...@dhis2.org <mailto:ab...@dhis2.org>>; Stanley 
> Kalyati <skaly...@gmail.com <mailto:skaly...@gmail.com>>; 
> dhis2-us...@lists.launchpad.net <mailto:dhis2-us...@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|
>  bus...@baosystems.com <mailto:bus...@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 <geo...@logicaloutcomes.net 
> <mailto:geo...@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:ab...@dhis2.org <mailto:ab...@dhis2.org>] 
> Sent: Tuesday, September 12, 2017 10:13 AM
> To: Stanley Kalyati <skaly...@gmail.com <mailto:skaly...@gmail.com>>
> Cc: Georgi Chakarov <geo...@logicaloutcomes.net 
> <mailto:geo...@logicaloutcomes.net>>; DHIS Users 
> <dhis2-us...@lists.launchpad.net <mailto:dhis2-us...@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 <skaly...@gmail.com 
> <mailto:skaly...@gmail.com>> wrote:
> Has anyone responded to this? Am also very interested.
>  
> Thanks
>  
> On Sep 10, 2017 11:22 AM, "Georgi Chakarov" <geo...@logicaloutcomes.net 
> <mailto:geo...@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 | geo...@logicaloutcomes.net 
> <mailto:geo...@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 
> i...@logicaloutcomes.net <mailto:i...@logicaloutcomes.net>
>  
>  
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users 
> <https://launchpad.net/~dhis2-users>
> Post to     : dhis2-us...@lists.launchpad.net 
> <mailto:dhis2-us...@lists.launchpad.net>
> 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-us...@lists.launchpad.net 
> <mailto:dhis2-us...@lists.launchpad.net>
> 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-us...@lists.launchpad.net 
> <mailto:dhis2-us...@lists.launchpad.net>
> 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-us...@lists.launchpad.net 
> <mailto:dhis2-us...@lists.launchpad.net>
> 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-devs
Post to     : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Reply via email to