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-users@lists.launchpad.net <mailto:dhis2-users@lists.launchpad.net>; > DHIS 2 developers <dhis2-d...@lists.launchpad.net > <mailto:dhis2-d...@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-users@lists.launchpad.net <mailto:dhis2-users@lists.launchpad.net>; > DHIS 2 developers <dhis2-d...@lists.launchpad.net > <mailto:dhis2-d...@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-users@lists.launchpad.net <mailto:dhis2-users@lists.launchpad.net>>; > DHIS 2 Developers list <dhis2-d...@lists.launchpad.net > <mailto:dhis2-d...@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-users@lists.launchpad.net > <mailto:dhis2-users@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-users@lists.launchpad.net > <mailto:dhis2-users@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-users@lists.launchpad.net > <mailto:dhis2-users@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-users@lists.launchpad.net > <mailto:dhis2-users@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 Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp