Hi Terence, great to see it worked out. Just plugging the collaborative nature of the documentation effort as well ;-) https://docs.dhis2.org/master/en/implementer/html/doc_guide_chapter.html#
On Thu, Nov 1, 2018 at 9:24 AM Terence Scott < terence.sc...@rabiesalliance.org> wrote: > Dear Shurajit > > Thanks for the advice. This worked fantastically - however, the > documentation is a little confusing with regards to the required format. Is > there somewhere where I can possibly make suggestions for clarification? > > The string that eventually worked under the Auto-generate section is as > follows: > CURRENT_DATE(yyyy-MM)-"-"-ORG_UNIT_CODE(...........)-"-"-SEQUENTIAL(####) > > The '+' did not work for me and gave a parse error - this is what is > specified in some parts of the documentation, whereas using the '-' worked > (as is shown in one example under "SEQUENTIAL(format)". > > It seems that currently only CURRENT_DATE is supported and not enrollment > date? Is there some way to include Enrollment date instead? I tried to > simply include ENROLLMENT_DATE(yyyy-MM) and this did not work. > > Thank you once again for the help! Really appreciate it as I have been > struggling with this for a while. > > Kind regards, > Terence > > Terence Scott > > Global Alliance for Rabies Control (GARC) > Pan-African Rabies Control Network (PARACON) Steering Committee > terence.sc...@rabiesalliance.org > https://paracon.rabiesalliance.org > Skype: tpscott1987 > > > > On Thu, Nov 1, 2018 at 3:46 AM Shurajit Dutta <shurajitdu...@gmail.com> > wrote: > >> Hi Terence >> >> This textpattern applies to generating unique tracked entity attributes. >> So if you make the attribute unique and then system generated you can enter >> the pattern accordingly: >> >> [image: image.png] >> >> On Wed, Oct 31, 2018 at 5:58 PM Terence Scott < >> terence.sc...@rabiesalliance.org> wrote: >> >>> Hi MSP >>> >>> Thank you for the suggestion. I have also attempted this and was unable >>> to have any success. I tried to create a new rule with simply having >>> "Sequential(###)" alone, and did not have any success either. Therefore, I >>> assumed that there would be some sort of additional text that is required >>> to make it work. >>> >>> Kind regards, >>> Terence >>> >>> Terence Scott >>> >>> Global Alliance for Rabies Control (GARC) >>> Pan-African Rabies Control Network (PARACON) Steering Committee >>> terence.sc...@rabiesalliance.org >>> https://paracon.rabiesalliance.org >>> Skype: tpscott1987 >>> >>> >>> >>> On Tue, Oct 30, 2018 at 5:49 PM M.Selvaraaj Prabu <msp....@gmail.com> >>> wrote: >>> >>>> Hi Terrance, >>>> >>>> Sometime back I read about this. I think you need to use the expression >>>> like >>>> >>>> - >>>> >>>> ORG_UNIT_CODE(…) + "-" + CURRENT_DATE(yyyyww) + "-" + SEQUENTIAL(#####) >>>> >>>> >>>> Instead of using the function concatenate. Please refer the below link >>>> for more details: >>>> >>>> - >>>> https://docs.dhis2.org/master/en/user/html/working-with-textpattern.html >>>> >>>> Hope this helps. >>>> >>>> Thanks and regards >>>> >>>> MSP >>>> >>>> >>>> On Tue, Oct 30, 2018 at 4:56 PM Terence Scott < >>>> terence.sc...@rabiesalliance.org> wrote: >>>> >>>>> Dear Zubair, Nick >>>>> >>>>> I have upgraded the instance to 2.30 now and am attempting to once >>>>> again implement the sequential numbering using the TextPattern option. I >>>>> am >>>>> using it on a TEAttribute, but have not had any success. >>>>> >>>>> Thus far, my Defined program rule action looks as follows: >>>>> >>>>> d2:concatenate( V{enrollment_date}, '-', V{orgunit_code}, '-') >>>>> >>>>> This is currently working and generating the UID, but of course, >>>>> without the sequential numbers. I have attempted the following >>>>> combinations >>>>> to try include the sequential numbers to no avail: >>>>> d2:concatenate( V{enrollment_date}, '-', V{orgunit_code}, '-', >>>>> SEQUENTIAL(###)) >>>>> d2:concatenate( V{enrollment_date}, '-', V{orgunit_code}, '-', >>>>> Sequential(###)) >>>>> d2:concatenate( V{enrollment_date}, '-', V{orgunit_code}, '-', >>>>> V{Sequential(###)}) >>>>> d2:concatenate( V{enrollment_date}, '-', V{orgunit_code}, '-', >>>>> V{sequential(###)}) >>>>> d2:concatenate( V{enrollment_date}, '-', V{orgunit_code}, '-', >>>>> V{sequential###}) >>>>> d2:concatenate( V{enrollment_date}, '-', V{orgunit_code}, '-', >>>>> 'SEQUENTIAL(###)') - this one simply added the text in (as suspected). >>>>> d2:concatenate( V{enrollment_date}, '-', V{orgunit_code}, '-') + >>>>> SEQUENTIAL(###) >>>>> >>>>> None of these combinations have worked thus far. Clearly I am >>>>> misunderstanding something or missing something and would appreciate any >>>>> help. >>>>> >>>>> Kind regards, >>>>> Terence >>>>> >>>>> >>>>> Terence Scott >>>>> >>>>> Global Alliance for Rabies Control (GARC) >>>>> Pan-African Rabies Control Network (PARACON) Steering Committee >>>>> terence.sc...@rabiesalliance.org >>>>> https://paracon.rabiesalliance.org >>>>> Skype: tpscott1987 >>>>> >>>>> >>>>> >>>>> On Wed, Oct 10, 2018 at 3:06 PM Zubair Asghar Raja <zub...@dhis2.org> >>>>> wrote: >>>>> >>>>>> Hi Terence, >>>>>> There could be many reasons for that. >>>>>> Have you tried implementing what Nick suggested? The only limitation >>>>>> is that the TextPattern option is only available for TEAttribute and not >>>>>> to >>>>>> DataElement. >>>>>> >>>>>> >>>>>> Zubair Asghar >>>>>> DHIS-2 Developer >>>>>> University of Oslo >>>>>> zub...@dhis2.org <l...@dhis2.org> >>>>>> https://www.dhis2.org >>>>>> >>>>>> >>>>>> On Wed, Oct 10, 2018 at 2:48 PM Terence Scott < >>>>>> terence.sc...@rabiesalliance.org> wrote: >>>>>> >>>>>>> Dear Zubair >>>>>>> >>>>>>> Thank you for your rapid response. I have attempted to do this >>>>>>> without success. I think I am misunderstanding. >>>>>>> >>>>>>> 1) I created the program variable "auto-increment' as suggested >>>>>>> 2) In this step - is this a new program rule? I created a program >>>>>>> rule as follows: "d2:hasValue #UID", Assign "#auto-increment + 1" to >>>>>>> field >>>>>>> "auto-increment". I then set this as priority 2. >>>>>>> 3) I created my UID program rule as with the following action: >>>>>>> "d2:concatenate( V{enrollment_date}, '-', A{Closest Health Center}, >>>>>>> #{auto-increment})" assigned to the attribute for UID. This is set as >>>>>>> priority 1. >>>>>>> >>>>>>> Unfortunately, this does not create the sequential number, but the >>>>>>> concatenated sequence is showing in the UID Attribute. >>>>>>> >>>>>>> Do I have my priorities incorrect or have I done something else >>>>>>> incorrectly? >>>>>>> >>>>>>> Kind regards, >>>>>>> Terence >>>>>>> >>>>>>> Terence Scott >>>>>>> >>>>>>> Global Alliance for Rabies Control (GARC) >>>>>>> Pan-African Rabies Control Network (PARACON) Steering Committee >>>>>>> terence.sc...@rabiesalliance.org >>>>>>> https://paracon.rabiesalliance.org >>>>>>> Skype: tpscott1987 >>>>>>> >>>>>>> >>>>>>> >>>>>>> On Wed, Oct 10, 2018 at 2:01 PM Zubair Asghar Raja <zub...@dhis2.org> >>>>>>> wrote: >>>>>>> >>>>>>>> Hi Terence, >>>>>>>> Should be possible using CALCULATED_VALUE. >>>>>>>> Program rule variable having source type as CALCULATED_VALUE will >>>>>>>> get its value assigned by some other program rule. Try these steps >>>>>>>> 1. create program rule variable of source type CALCULATED_VALUE // >>>>>>>> Let say "auto-increment" >>>>>>>> 2. create program rule with Program Rule Action as Assign Value and >>>>>>>> select variable created in step 1 and assign it "#{auto-increment} + 1" >>>>>>>> 3. Use it in your program rule where ever needed for example >>>>>>>> v{current-date}-#{orgunit}-#{auto-increment} >>>>>>>> >>>>>>>> In order to use CALCULATED_CALUE make sure you are correctly >>>>>>>> setting rule *priority*. >>>>>>>> >>>>>>>> Zubair Asghar >>>>>>>> DHIS-2 Developer >>>>>>>> University of Oslo >>>>>>>> zub...@dhis2.org <l...@dhis2.org> >>>>>>>> https://www.dhis2.org >>>>>>>> >>>>>>>> >>>>>>>> On Wed, Oct 10, 2018 at 1:25 PM Terence Scott < >>>>>>>> terence.sc...@rabiesalliance.org> wrote: >>>>>>>> >>>>>>>>> Dear All >>>>>>>>> >>>>>>>>> I am creating a program rule to develop a UID for the patient. I >>>>>>>>> have currently created a program rule using d2:concatenate to bring >>>>>>>>> various >>>>>>>>> attributes and DEs together into the Unique ID (such as date and >>>>>>>>> OrgUnit >>>>>>>>> code). However, I would also like to include sequential numbering >>>>>>>>> after >>>>>>>>> this to ensure that more than 1 case can be registered on a single >>>>>>>>> day. >>>>>>>>> >>>>>>>>> I have looked through all of the documentation and am unable to >>>>>>>>> find anything along these lines. Is it possible? >>>>>>>>> >>>>>>>>> Example: >>>>>>>>> 2018-10-10-OrgUnit code-1; >>>>>>>>> 2018-10-10-OrgUnit code-2; >>>>>>>>> 2018-10-10-OrgUnit code-3; etc. (where 1,2 and 3 are the >>>>>>>>> sequential numbers generated). >>>>>>>>> >>>>>>>>> I have also looked at Program Rule variables and am unsure as to >>>>>>>>> what the "Calculated value" source type is, as in the documentation >>>>>>>>> it is >>>>>>>>> listed as "TBA" with no further information. >>>>>>>>> >>>>>>>>> I would appreciate any help or advise. >>>>>>>>> >>>>>>>>> Kind regards, >>>>>>>>> Terence >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> Terence Scott >>>>>>>>> >>>>>>>>> Global Alliance for Rabies Control (GARC) >>>>>>>>> Pan-African Rabies Control Network (PARACON) Steering Committee >>>>>>>>> terence.sc...@rabiesalliance.org >>>>>>>>> https://paracon.rabiesalliance.org >>>>>>>>> Skype: tpscott1987 >>>>>>>>> >>>>>>>>> _______________________________________________ >>>>>>>>> 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 >>>>>>>>> >>>>>>>> _______________________________________________ >>>>> 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 >>>>> >>>> >> >> -- >> Shurajit Dutta (MPH, MHI) >> Health Information Systems Adviser >> > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-us...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > -- Knut Staring Department of Information, Evidence and Research World Health Organization, Geneva, Switzerland Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522 Skype: knutstar
_______________________________________________ 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
