dhis2-users team mailing list archive

[Shurajit Dutta <shurajitdutta@xxxxxxxxx>]

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.scott@xxxxxxxxxxxxxxxxxx> 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.scott@xxxxxxxxxxxxxxxxxx
> https://paracon.rabiesalliance.org
> Skype: tpscott1987
>
>
>
> On Tue, Oct 30, 2018 at 5:49 PM M.Selvaraaj Prabu <msp.cbe@xxxxxxxxx>
> 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.scott@xxxxxxxxxxxxxxxxxx> 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.scott@xxxxxxxxxxxxxxxxxx
>>> https://paracon.rabiesalliance.org
>>> Skype: tpscott1987
>>>
>>>
>>>
>>> On Wed, Oct 10, 2018 at 3:06 PM Zubair Asghar Raja <zubair@xxxxxxxxx>
>>> 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
>>>> zubair@xxxxxxxxx <lars@xxxxxxxxx>
>>>> https://www.dhis2.org
>>>>
>>>>
>>>> On Wed, Oct 10, 2018 at 2:48 PM Terence Scott <
>>>> terence.scott@xxxxxxxxxxxxxxxxxx> 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.scott@xxxxxxxxxxxxxxxxxx
>>>>> https://paracon.rabiesalliance.org
>>>>> Skype: tpscott1987
>>>>>
>>>>>
>>>>>
>>>>> On Wed, Oct 10, 2018 at 2:01 PM Zubair Asghar Raja <zubair@xxxxxxxxx>
>>>>> 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
>>>>>> zubair@xxxxxxxxx <lars@xxxxxxxxx>
>>>>>> https://www.dhis2.org
>>>>>>
>>>>>>
>>>>>> On Wed, Oct 10, 2018 at 1:25 PM Terence Scott <
>>>>>> terence.scott@xxxxxxxxxxxxxxxxxx> 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.scott@xxxxxxxxxxxxxxxxxx
>>>>>>> https://paracon.rabiesalliance.org
>>>>>>> Skype: tpscott1987
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>>
>>>>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>

-- 
Shurajit Dutta (MPH, MHI)
Health Information Systems Adviser