Hi Calle, could you try to export as XML and see how those numbers look there?
It could be that the conversion to scientific notation might be an excel feature rather than DHIS 2. regards, Lars On Mon, Nov 9, 2015 at 9:41 PM, Calle Hedberg <[email protected]> wrote: > 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: [email protected] > > Skype: calle_hedberg > > ******************************************* > > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- Lars Helge Øverland Lead developer, DHIS 2 University of Oslo Skype: larshelgeoverland http://www.dhis2.org <https://www.dhis2.org>
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
