← Back to team overview

dhis2-devs team mailing list archive

Re: [Dhis2-users] UID generation

 

Thanks Lars, Jason for the quick response !
That solution worked for me.

​Regards
,
- Arun Paul

On Thu, Sep 29, 2016 at 2:55 PM, Jason Pickering <
jason.p.pickering@xxxxxxxxx> wrote:

> 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