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-d...@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-d...@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-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp