dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

I do not really have a problem with this, but shouldn't this
information go in the "code" field? Or is it a problem with the number
of orgunits? It would seem unlikely that we would ever have more than
2,147,483,647 orgunits.

Are you inserting the ID as the organisationunitid? This seems this
might cause problems with possible clashes with the hibernate_sequence
which is used to generate IDs?

I have run into this issue only once, but since then, I always use the
hibernate_sequence to generate IDs when I directly insert data into
the DB.

Regards,
Jason


On 5/20/10, Knut Staring <knutst@xxxxxxxxx> wrote:
> Hello,
>
> In the process of converting WHO identifiers for administrative
> boundaries (LVLID) to ids usable for DHIS2, I've run into the limits
> of the integer datatype we use in DHIS2.
>
> The LVLID is a three letter ISO code followed by 18 digits. We are
> converting the alphabetical ISO for the country to an ISO numeric code
> (preceeded by 1 to make it numeric).
>
> Would it be problematic to change the datatype for organisationunitid
> from integer to bigint?
>
> Knut
>
> _______________________________________________
> 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:+260968395190