dhis2-devs team mailing list archive

[Calle Hedberg <calle.hedberg@xxxxxxxxx>]

Hi

We are having problems capturing, storing, exporting and importing data
comprising large numbers - with an annual public health budget of around R
150 billion, SA has a considerable number of financial data values well
above 2 billion. While we CAN find ways of inserting such values since the
value field in the DataValue table is char var, they don't process well and
don't export/import well (e.g. the large values are exported into CSV as
exponential number strings, which in turn is rejected during import into
another instance).

Most database including PostgreSQL supports a BIGINT data type (8 bytes),
which would work for us. DHIS2 don't support BIGINT as a data type via the
UI, but:

1.
Anybody know of a way to circumvent that?

2.
What the code implications of adding another data type - does it require
code changes all over the place, or is the code reasonably contained?

Regards
Calle

*******************************************

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRIC

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@xxxxxxxxx

Skype: calle_hedberg

*******************************************