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

Reply via email to