← Back to team overview

dhis2-users team mailing list archive

Re: [Dhis2-devs] UID generation

 

If you are using Postgres to inject the data directly, you can use this

https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/uid.sql

Regards,
Jason

On Thu, Sep 29, 2016 at 11:23 AM, Lars Helge Øverland <lars@xxxxxxxxx>
wrote:

> In fact,  generateCode(); will do.
>
> Lars
>
>
> On Thu, Sep 29, 2016 at 11:23 AM, Lars Helge Øverland <lars@xxxxxxxxx>
> wrote:
>
>> Hi Arun,
>>
>> if you are using the DHIS 2 Java service layers there is no need to
>> manually generate and set UIDs. They will be automatically set before the
>> object is saved.
>>
>> To generate UIDs you should use this class: org.hisp.dhis.commonCodeGenerator
>> -> generateCode( 11 );
>>
>> Javadoc:
>>
>> http://ci.dhis2.org/job/dhis2-2.24-javadoc/javadoc/org/hisp/
>> dhis/common/CodeGenerator.html
>>
>>
>>
>> regards,
>>
>> Lars
>>
>>
>> On Thu, Sep 29, 2016 at 11:17 AM, Arun Paul <paul.arun@xxxxxxxxx> wrote:
>>
>>> Hello everyone,
>>>
>>> I am trying to import legacy data into a new DHIS2 installation using
>>> custom code.
>>>
>>> While adding new entries into a database table, I need to assign new UID
>>> values. What is the algorithm I should use to generated these IDs ? I tried
>>> using a postgresql extension called uuid-ossp and the
>>> function uuid_generate_v1() that comes with that extension. But it
>>> generates uuid of the format ebe87e56-8624-11e6-a4ce-040157be4e01 and
>>> it's bigger than what CHARACTER VARYING(11) can hold. Any idea what
>>> strategy should I follow here to easily generate UIDs while inserting
>>> database entries?
>>>
>>> Thanks in advance.
>>> - Arun Paul
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Lars Helge Øverland
>> Lead developer, DHIS 2
>> University of Oslo
>> Skype: larshelgeoverland
>> lars@xxxxxxxxx
>> http://www.dhis2.org <https://www.dhis2.org/>
>>
>>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> lars@xxxxxxxxx
> http://www.dhis2.org <https://www.dhis2.org/>
>
>
> _______________________________________________
> 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
>
>


-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049

Follow ups

References