Re: [Dhis2-devs] [Dhis2-users] Digit group separator in pivot table - what should the default value be?

2016-05-06 Thread Lars Helge Øverland
Hi there, many thanks for all the feedback and the votes. The feedback clearly tells that there are multiple needs / views out there, and that having this configurable per system is desired. So we will turn this into a system setting for 2.24. Issues:

Re: [Dhis2-devs] [Dhis2-users] Digit group separator in pivot table - what should the default value be?

2016-05-04 Thread Bob Jolliffe
I *think* we discuss the space separator business purely related to display. So when exporting to excel, or any other case where the number is expected to be consumed as a number (including storage in the database), exported via api in json/xml datavalueset etc there should be no spaces, commas

Re: [Dhis2-devs] [Dhis2-users] Digit group separator in pivot table - what should the default value be?

2016-05-04 Thread Adedayo Adeyomoye
Hi Lars, Since most people would export to excel and excel in turn would ignore the space hence making it "no separator" option as you mentioned, I would suggest that the comma be used as it quickly gives the number scale at a glance. But whichever way, the majority carries the vote I guess.

Re: [Dhis2-devs] [Dhis2-users] Digit group separator in pivot table - what should the default value be?

2016-05-04 Thread Lars Helge Øverland
Hi all, many thanks for all the feedback. Will make this configurable per system then given the all the various opinions. Another point of clarification: It seems that space is a preferred separator in the Web based pivot table. However, when downloading to Excel, it seems space is useless as

Re: [Dhis2-devs] [Dhis2-users] Digit group separator in pivot table - what should the default value be?

2016-05-04 Thread Uwe Wahser
Good point: actually it's not only the digit group for pivot table, but rather [digit group, decimal point, default number of decimals] for any [input, output, import and export] that should be defined in the systems settings. But I fear that the implications on the coding will be much bigger

Re: [Dhis2-devs] [Dhis2-users] Digit group separator in pivot table - what should the default value be?

2016-05-04 Thread Morten Olav Hansen
In Vietnam it's also comma, so a system wide solution would be good (not for output only, but only for input would be good.. if possible) -- Morten Olav Hansen Senior Engineer, DHIS 2 University of Oslo http://www.dhis2.org On Wed, May 4, 2016 at 12:56 PM, ramaso hasina

Re: [Dhis2-devs] [Dhis2-users] Digit group separator in pivot table - what should the default value be?

2016-05-03 Thread ramaso hasina
Supporting Jim's suggestion. For Madagascar, the default separator is 'space'. Best regards, - *Hasinarivelo RAMASOMANANA* *mHealth Specialist* Population Services International Antananarivo - Madagascar *​Vies Saines - Résultats mesurables* 2016-05-04 8:44 GMT+03:00 Hannan Khan

Re: [Dhis2-devs] [Dhis2-users] Digit group separator in pivot table - what should the default value be?

2016-05-03 Thread Hannan Khan
Supporting Jim and Ola on implementation wide settings to configure a default system-wide separator with provision to override for each pivot table. For Bangladesh the default separator is 'Comma'. Regards Hannan HISP Bangladesh On Wed, May 4, 2016 at 1:32 AM, Ola Hodne Titlestad

Re: [Dhis2-devs] [Dhis2-users] Digit group separator in pivot table - what should the default value be?

2016-05-03 Thread Paulo Grácio
Why not use https://docs.oracle.com/javase/tutorial/i18n/format/numberFormat.html where the default format depends on user/setup locale? On Wed, 4 May 2016 at 00:32, Antonia - Pro wrote: > At the start of voting I felt in total minority. > But according to the SI/ISO 31-0

Re: [Dhis2-devs] [Dhis2-users] Digit group separator in pivot table - what should the default value be?

2016-05-03 Thread Antonia - Pro
At the start of voting I felt in total minority. But according to the SI/ISO 31-0 standard he space is the only neutral separator. The space is appropriate also because in some countries the comma is the decimal separator (not always the

Re: [Dhis2-devs] [Dhis2-users] Digit group separator in pivot table - what should the default value be?

2016-05-03 Thread Elmarie Claasen
of the disclaimer. From: Dhis2-devs [mailto:dhis2-devs-bounces+elmarie=hisp@lists.launchpad.net] On Behalf Of Jim Grace Sent: 03 May 2016 09:13 PM To: Prosper BT Cc: DHIS 2 Users list; DHIS 2 Developers list Subject: Re: [Dhis2-devs] [Dhis2-users] Digit group separator in pivot table - what

Re: [Dhis2-devs] [Dhis2-users] Digit group separator in pivot table - what should the default value be?

2016-05-03 Thread Bob Jolliffe
https://en.wikipedia.org/wiki/Decimal_mark#Digit_grouping seems to support Jim's suggestion of space as default. On 3 May 2016 at 21:32, Ola Hodne Titlestad wrote: > Supporting Jim's suggestion on a system/implementation setting to > configure a default system-wide separator

Re: [Dhis2-devs] [Dhis2-users] Digit group separator in pivot table - what should the default value be?

2016-05-03 Thread Ola Hodne Titlestad
Supporting Jim's suggestion on a system/implementation setting to configure a default system-wide separator in addition to the possibility of overriding this for each pivot table or other type of report with display options. I guess the result of the vote could still be what the default value for

Re: [Dhis2-devs] [Dhis2-users] Digit group separator in pivot table - what should the default value be?

2016-05-03 Thread Jim Grace
To me the most important way to address this is to allow an implementation-wide default. The space character is in many ways the "correct" separator according to international norms, and is even making inroads into countries such as the US that traditionally use the comma. I think the space is

Re: [Dhis2-devs] [Dhis2-users] Digit group separator in pivot table - what should the default value be?

2016-05-03 Thread Prosper BT
I vote for having none as default (1432) then one can choose what they want in options On Tue, May 3, 2016 at 7:36 PM, Lars Helge Øverland wrote: > Hi there, > > we are getting many (conflicting) requests for what the default value > should be for the "digit group separator" in