dhis2-users team mailing list archive

[Morten Olav Hansen <morten@xxxxxxxxx>]

A third alternative is to just get it from DHIS2 itself,

https://play.dhis2.org/dev/api/system/id.json?limit=1000
https://play.dhis2.org/dev/api/system/id.xml?limit=1000
https://play.dhis2.org/dev/api/system/id.csv?limit=1000

-- 
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.org

On Thu, Sep 29, 2016 at 5:00 PM, Arun Paul <paul.arun@xxxxxxxxx> wrote:

> 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
>>
>
>
> _______________________________________________
> 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
>
>