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

[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:

https://github.com/dhis2/settings-app/issues/62

https://github.com/dhis2/dhis2-pivot/issues/5



Thanks again for the feedback.

regards,

Lars








On Wed, May 4, 2016 at 11:47 AM, Bob Jolliffe  wrote:

> 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 etc.  Confusion on this would be a recipe
> for disaster.
>
> Everyone seems to agree that how numbers display should be
> configurable.  Though I thought the question was more what would be
> the default appearance in the absence of any configuration.  In which
> case there are only two approaches:  (i) pick something, in which case
> space seems to be the most standard default, or (ii) infer something
> based on the locale.
>
> On 4 May 2016 at 09:56, Lars Helge Øverland  wrote:
> > 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 it makes Excel interpret the cell as text, not
> numbers.
> >
> > So as a short term solution (which could be back-ported) could be that
> when
> > downloading to Excel, the system could fall back to no separator when
> space
> > is selected as separator. This because space never seems useful for Excel
> > spreadsheets.
> >
> > Would that work?
> >
> >
> > regards,
> >
> > Lars
> >
> >
> >
> >
> >
> >
> >
> > ___
> > Mailing list: https://launchpad.net/~dhis2-devs
> > Post to : dhis2-d...@lists.launchpad.net
> > 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
l...@dhis2.org
http://www.dhis2.org 
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

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

[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 etc.  Confusion on this would be a recipe
for disaster.

Everyone seems to agree that how numbers display should be
configurable.  Though I thought the question was more what would be
the default appearance in the absence of any configuration.  In which
case there are only two approaches:  (i) pick something, in which case
space seems to be the most standard default, or (ii) infer something
based on the locale.

On 4 May 2016 at 09:56, Lars Helge Øverland  wrote:
> 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 it makes Excel interpret the cell as text, not numbers.
>
> So as a short term solution (which could be back-ported) could be that when
> downloading to Excel, the system could fall back to no separator when space
> is selected as separator. This because space never seems useful for Excel
> spreadsheets.
>
> Would that work?
>
>
> regards,
>
> Lars
>
>
>
>
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

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

[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. 

RegardsOn 4 May 2016 8:56 am, Lars Helge Øverland  wrote:
>
> 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 it makes Excel interpret the cell as text, not numbers.
>
> So as a short term solution (which could be back-ported) could be that when 
> downloading to Excel, the system could fall back to no separator when space 
> is selected as separator. This because space never seems useful for Excel 
> spreadsheets.
>
> Would that work?
>
>
> regards,
>
> Lars
>
>
>
>
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

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

[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 it makes Excel interpret the cell as text, not
numbers.

So as a short term solution (which could be back-ported) could be that when
downloading to Excel, the system could fall back to no separator when space
is selected as separator. This because space never seems useful for Excel
spreadsheets.

Would that work?


regards,

Lars
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

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

[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 than what
Lars originally intended :-)


> Morten Olav Hansen  hat am 4. Mai 2016 um 09:25 geschrieben:
> 
> 
> 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 
> wrote:
> 
> > 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 :
> >
> >> 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 
> >> wrote:
> >>
> >>> 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 this system setting should be
> >>>
> >>> Ola
> >>> --
> >>>
> >>> --
> >>> Ola Hodne Titlestad (Mr)
> >>> HISP
> >>> Department of Informatics
> >>> University of Oslo
> >>>
> >>> Mobile: +47 48069736
> >>> Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
> >>> 
> >>>
> >>> On 3 May 2016 at 21:12, Jim Grace  wrote:
> >>>
>  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 probably the best "factory" default for DHIS 2, so
>  that
>  large numbers are readable on demonstration systems, and so we follow
>  international and emerging standards.
> 
>  However, an implementation should be able to override this with an
>  implementation-wide default of comma, where a preponderance of users for
>  that implementation are more used to this, and/or where exporting to
>  Excel
>  is a concern.
> 
>  Expecting users to override the default every time they create a pivot
>  table is not very user-friendly.
> 
> 
>  On Tue, May 3, 2016 at 1:46 PM, Prosper BT  wrote:
> 
> > 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 the pivot table app.
> >>
> >> So lets decide with a poll.. Cast your vote here before Friday 6th!
> >>
> >> http://doodle.com/poll/vtyzgts226aqihev
> >>
> >>
> >> The digit group separator controls how large numbers are being split
> >> up, e.g.
> >>
> >> 1 432
> >> 1,432
> >> 1432
> >>
> >> The digit group separator can be controlled from Options.
> >>
> >> [image: Inline image 1]
> >>
> >> regards,
> >>
> >> Lars
> >>
> >>
> >>
> >> --
> >> Lars Helge Øverland
> >> Lead developer, DHIS 2
> >> University of Oslo
> >> Skype: larshelgeoverland
> >> l...@dhis2.org
> >> http://www.dhis2.org 
> >>
> >>
> >> ___
> >> Mailing list: https://launchpad.net/~dhis2-users
> >> Post to : dhis2-users@lists.launchpad.net
> >> Unsubscribe : https://launchpad.net/~dhis2-users
> >> More help   : https://help.launchpad.net/ListHelp
> >>
> >>
> >
> >
> > --
> > Prosper Behumbiize, MPH
> > Global HISP| University Of Oslo/HISP Uganda
> > +256 

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

[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 
wrote:

> 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 :
>
>> 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 
>> wrote:
>>
>>> 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 this system setting should be
>>>
>>> Ola
>>> --
>>>
>>> --
>>> Ola Hodne Titlestad (Mr)
>>> HISP
>>> Department of Informatics
>>> University of Oslo
>>>
>>> Mobile: +47 48069736
>>> Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
>>> 
>>>
>>> On 3 May 2016 at 21:12, Jim Grace  wrote:
>>>
 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 probably the best "factory" default for DHIS 2, so that
 large numbers are readable on demonstration systems, and so we follow
 international and emerging standards.

 However, an implementation should be able to override this with an
 implementation-wide default of comma, where a preponderance of users for
 that implementation are more used to this, and/or where exporting to Excel
 is a concern.

 Expecting users to override the default every time they create a pivot
 table is not very user-friendly.


 On Tue, May 3, 2016 at 1:46 PM, Prosper BT  wrote:

> 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 the pivot table app.
>>
>> So lets decide with a poll.. Cast your vote here before Friday 6th!
>>
>> http://doodle.com/poll/vtyzgts226aqihev
>>
>>
>> The digit group separator controls how large numbers are being split
>> up, e.g.
>>
>> 1 432
>> 1,432
>> 1432
>>
>> The digit group separator can be controlled from Options.
>>
>> [image: Inline image 1]
>>
>> regards,
>>
>> Lars
>>
>>
>>
>> --
>> Lars Helge Øverland
>> Lead developer, DHIS 2
>> University of Oslo
>> Skype: larshelgeoverland
>> l...@dhis2.org
>> http://www.dhis2.org 
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Prosper Behumbiize, MPH
> Global HISP| University Of Oslo/HISP Uganda
> +256 752 751 776 | +256 776 139 139
> pros...@hispuganda.org  | pros...@dhis2.org | Skype:
> prospertb
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


 --
 Jim Grace
 Core developer, DHIS 2
 HISP US Inc.
 http://www.dhis2.org 

 ___
 Mailing list: https://launchpad.net/~dhis2-devs
 Post to : dhis2-d...@lists.launchpad.net
 

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

[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 :

> 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 
> wrote:
>
>> 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 this system setting should be
>>
>> Ola
>> --
>>
>> --
>> Ola Hodne Titlestad (Mr)
>> HISP
>> Department of Informatics
>> University of Oslo
>>
>> Mobile: +47 48069736
>> Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
>> 
>>
>> On 3 May 2016 at 21:12, Jim Grace  wrote:
>>
>>> 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 probably the best "factory" default for DHIS 2, so that
>>> large numbers are readable on demonstration systems, and so we follow
>>> international and emerging standards.
>>>
>>> However, an implementation should be able to override this with an
>>> implementation-wide default of comma, where a preponderance of users for
>>> that implementation are more used to this, and/or where exporting to Excel
>>> is a concern.
>>>
>>> Expecting users to override the default every time they create a pivot
>>> table is not very user-friendly.
>>>
>>>
>>> On Tue, May 3, 2016 at 1:46 PM, Prosper BT  wrote:
>>>
 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 the pivot table app.
>
> So lets decide with a poll.. Cast your vote here before Friday 6th!
>
> http://doodle.com/poll/vtyzgts226aqihev
>
>
> The digit group separator controls how large numbers are being split
> up, e.g.
>
> 1 432
> 1,432
> 1432
>
> The digit group separator can be controlled from Options.
>
> [image: Inline image 1]
>
> regards,
>
> Lars
>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> l...@dhis2.org
> http://www.dhis2.org 
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


 --
 Prosper Behumbiize, MPH
 Global HISP| University Of Oslo/HISP Uganda
 +256 752 751 776 | +256 776 139 139
 pros...@hispuganda.org  | pros...@dhis2.org | Skype:
 prospertb

 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-users@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp


>>>
>>>
>>> --
>>> Jim Grace
>>> Core developer, DHIS 2
>>> HISP US Inc.
>>> http://www.dhis2.org 
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to : dhis2-d...@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Muhammad Abdul Hannan Khan
> Secretary
> HISP Bangladesh
>
> T +880-2- 

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

[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 
wrote:

> 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 this system setting should be
>
> Ola
> --
>
> --
> Ola Hodne Titlestad (Mr)
> HISP
> Department of Informatics
> University of Oslo
>
> Mobile: +47 48069736
> Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
> 
>
> On 3 May 2016 at 21:12, Jim Grace  wrote:
>
>> 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 probably the best "factory" default for DHIS 2, so that
>> large numbers are readable on demonstration systems, and so we follow
>> international and emerging standards.
>>
>> However, an implementation should be able to override this with an
>> implementation-wide default of comma, where a preponderance of users for
>> that implementation are more used to this, and/or where exporting to Excel
>> is a concern.
>>
>> Expecting users to override the default every time they create a pivot
>> table is not very user-friendly.
>>
>>
>> On Tue, May 3, 2016 at 1:46 PM, Prosper BT  wrote:
>>
>>> 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 the pivot table app.

 So lets decide with a poll.. Cast your vote here before Friday 6th!

 http://doodle.com/poll/vtyzgts226aqihev


 The digit group separator controls how large numbers are being split
 up, e.g.

 1 432
 1,432
 1432

 The digit group separator can be controlled from Options.

 [image: Inline image 1]

 regards,

 Lars



 --
 Lars Helge Øverland
 Lead developer, DHIS 2
 University of Oslo
 Skype: larshelgeoverland
 l...@dhis2.org
 http://www.dhis2.org 


 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-users@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp


>>>
>>>
>>> --
>>> Prosper Behumbiize, MPH
>>> Global HISP| University Of Oslo/HISP Uganda
>>> +256 752 751 776 | +256 776 139 139
>>> pros...@hispuganda.org  | pros...@dhis2.org | Skype:
>>> prospertb
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Jim Grace
>> Core developer, DHIS 2
>> HISP US Inc.
>> http://www.dhis2.org 
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Muhammad Abdul Hannan Khan
Secretary
HISP Bangladesh

T +880-2- 8816459, 8816412 ext 118
F +88 02 8813 875
M+88 01819 239 241
M+88 01534 312 066
E hann...@gmail.com
S hannan.khan.dhaka
B hannan-tech.blogspot.com
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

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

[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 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 democratic
> vote is the best choice.)
>
> Regards,
> Antonia
>
>  www.informa.pro - *Seguici su *LinkedIn
>  [image: In]
> 
> INFORMAPRO S.r.l. - via Luigi Rava 43,  Roma 00149 , Italy
> tel. +39 06 5758926, fax +39  06 62207168
> Skype: informa_antonia.bezenchek
> Eng. Antonia Bezenchek - CIO - ICT Engineer
>
> 2016-05-03 21:34 GMT+02:00 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 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 this system setting should be
>>>
>>> Ola
>>> --
>>>
>>
>>> --
>>> Ola Hodne Titlestad (Mr)
>>> HISP
>>> Department of Informatics
>>> University of Oslo
>>>
>>> Mobile: +47 48069736
>>> Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
>>> 
>>>
>>> On 3 May 2016 at 21:12, Jim Grace  wrote:
>>>
>> 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 probably the best "factory" default for DHIS 2, so that
 large numbers are readable on demonstration systems, and so we follow
 international and emerging standards.

 However, an implementation should be able to override this with an
 implementation-wide default of comma, where a preponderance of users for
 that implementation are more used to this, and/or where exporting to Excel
 is a concern.

 Expecting users to override the default every time they create a pivot
 table is not very user-friendly.


 On Tue, May 3, 2016 at 1:46 PM, Prosper BT  wrote:

> 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 the pivot table app.
>>
>> So lets decide with a poll.. Cast your vote here before Friday 6th!
>>
>> http://doodle.com/poll/vtyzgts226aqihev
>>
>>
>> The digit group separator controls how large numbers are being split
>> up, e.g.
>>
>> 1 432
>> 1,432
>> 1432
>>
>> The digit group separator can be controlled from Options.
>>
>> [image: Inline image 1]
>>
>> regards,
>>
>> Lars
>>
>>
>>
>> --
>> Lars Helge Øverland
>> Lead developer, DHIS 2
>> University of Oslo
>> Skype: larshelgeoverland
>> l...@dhis2.org
>> http://www.dhis2.org 
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Prosper Behumbiize, MPH
> Global HISP| University Of Oslo/HISP Uganda
> +256 752 751 776 | +256 776 139 139
> pros...@hispuganda.org  | pros...@dhis2.org | Skype:
> prospertb
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


 --
 Jim Grace
 Core developer, DHIS 2
 HISP US Inc.
 

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

[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 democratic
vote is the best choice.)

Regards,
Antonia

 www.informa.pro - *Seguici su *LinkedIn
 [image: In]

INFORMAPRO S.r.l. - via Luigi Rava 43,  Roma 00149 , Italy
tel. +39 06 5758926, fax +39  06 62207168
Skype: informa_antonia.bezenchek
Eng. Antonia Bezenchek - CIO - ICT Engineer

2016-05-03 21:34 GMT+02:00 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 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 this system setting should be
>>
>> Ola
>> --
>>
>> --
>> Ola Hodne Titlestad (Mr)
>> HISP
>> Department of Informatics
>> University of Oslo
>>
>> Mobile: +47 48069736
>> Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
>> 
>>
>> On 3 May 2016 at 21:12, Jim Grace  wrote:
>>
>>> 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 probably the best "factory" default for DHIS 2, so that
>>> large numbers are readable on demonstration systems, and so we follow
>>> international and emerging standards.
>>>
>>> However, an implementation should be able to override this with an
>>> implementation-wide default of comma, where a preponderance of users for
>>> that implementation are more used to this, and/or where exporting to Excel
>>> is a concern.
>>>
>>> Expecting users to override the default every time they create a pivot
>>> table is not very user-friendly.
>>>
>>>
>>> On Tue, May 3, 2016 at 1:46 PM, Prosper BT  wrote:
>>>
 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 the pivot table app.
>
> So lets decide with a poll.. Cast your vote here before Friday 6th!
>
> http://doodle.com/poll/vtyzgts226aqihev
>
>
> The digit group separator controls how large numbers are being split
> up, e.g.
>
> 1 432
> 1,432
> 1432
>
> The digit group separator can be controlled from Options.
>
> [image: Inline image 1]
>
> regards,
>
> Lars
>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> l...@dhis2.org
> http://www.dhis2.org 
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


 --
 Prosper Behumbiize, MPH
 Global HISP| University Of Oslo/HISP Uganda
 +256 752 751 776 | +256 776 139 139
 pros...@hispuganda.org  | pros...@dhis2.org | Skype:
 prospertb

 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-users@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp


>>>
>>>
>>> --
>>> Jim Grace
>>> Core developer, DHIS 2
>>> HISP US Inc.
>>> http://www.dhis2.org 
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to : dhis2-d...@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>> ___
>> 

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

[Elmarie Claasen]

Hi all,

 

I agree with Jim make the default configurable across the instance. 

 

Regards,

 

Elmarie Claasen

Hisp logo

Project Manager

Health Information Systems Program

Tel:  041-367 1027

Cell: 082 374 2209

E-mail:  <mailto:elma...@hisp.org> elma...@hisp.org

Skype:  elmarie.claasen52 

 

 

This message and any attachments are subject to a disclaimer published at  
<http://www.hisp.org/policies.html#comms_disclaimer> 
http://www.hisp.org/policies.html#comms_disclaimer .   Please read the 
disclaimer before opening any attachment or taking any other action in terms of 
this electronic transmission. 
If you cannot access the disclaimer, kindly send an email to  
<mailto:disclai...@hisp.org> disclai...@hisp.org and a copy will be provided to 
you. By replying to this e-mail or opening any attachment you agree to be bound 
by the provisions 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 should the default value be?

 

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 probably the best 
"factory" default for DHIS 2, so that large numbers are readable on 
demonstration systems, and so we follow international and emerging standards.

 

However, an implementation should be able to override this with an 
implementation-wide default of comma, where a preponderance of users for that 
implementation are more used to this, and/or where exporting to Excel is a 
concern.

 

Expecting users to override the default every time they create a pivot table is 
not very user-friendly.

 

 

On Tue, May 3, 2016 at 1:46 PM, Prosper BT <ptb3...@gmail.com> wrote:

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 <l...@dhis2.org> wrote:

Hi there,

 

we are getting many (conflicting) requests for what the default value should be 
for the "digit group separator" in the pivot table app.

 

So lets decide with a poll.. Cast your vote here before Friday 6th!

 

http://doodle.com/poll/vtyzgts226aqihev

 

 

The digit group separator controls how large numbers are being split up, e.g.

 

1 432

1,432

1432

 

The digit group separator can be controlled from Options.

 

Inline image 1

 

regards,


Lars

 

 

 

-- 

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

l...@dhis2.org

http://www.dhis2.org <https://www.dhis2.org/> 

 

 

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp





 

-- 

Prosper Behumbiize, MPH

Global HISP| University Of Oslo/HISP Uganda
+256 752 751 776 | +256 776 139 139

 <mailto:ptb3...@gmail.com> pros...@hispuganda.org |  
<mailto:pros...@dhis2.org> pros...@dhis2.org | Skype: prospertb


___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp





 

-- 

Jim Grace

Core developer, DHIS 2

HISP US Inc.

 <https://www.dhis2.org/> http://www.dhis2.org


-- 


*This message and any attachments are subject to a disclaimer published at 
http://www.hisp.org/policies.html#comms_disclaimer 
<http://www.hisp.org/policies.html#comms_disclaimer>.  Please read the 
disclaimer before opening any attachment or taking any other action in 
terms of this electronic transmission.  If you cannot access the 
disclaimer, kindly send an email to disclai...@hisp.org 
<disclai...@hisp.org> and a copy will be provided to you. By replying to 
this e-mail or opening any attachment you agree to be bound by the 
provisions of the disclaimer.*
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

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

[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 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 this system setting should be
>
> Ola
> --
>
> --
> Ola Hodne Titlestad (Mr)
> HISP
> Department of Informatics
> University of Oslo
>
> Mobile: +47 48069736
> Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
> 
>
> On 3 May 2016 at 21:12, Jim Grace  wrote:
>
>> 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 probably the best "factory" default for DHIS 2, so that
>> large numbers are readable on demonstration systems, and so we follow
>> international and emerging standards.
>>
>> However, an implementation should be able to override this with an
>> implementation-wide default of comma, where a preponderance of users for
>> that implementation are more used to this, and/or where exporting to Excel
>> is a concern.
>>
>> Expecting users to override the default every time they create a pivot
>> table is not very user-friendly.
>>
>>
>> On Tue, May 3, 2016 at 1:46 PM, Prosper BT  wrote:
>>
>>> 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 the pivot table app.

 So lets decide with a poll.. Cast your vote here before Friday 6th!

 http://doodle.com/poll/vtyzgts226aqihev


 The digit group separator controls how large numbers are being split
 up, e.g.

 1 432
 1,432
 1432

 The digit group separator can be controlled from Options.

 [image: Inline image 1]

 regards,

 Lars



 --
 Lars Helge Øverland
 Lead developer, DHIS 2
 University of Oslo
 Skype: larshelgeoverland
 l...@dhis2.org
 http://www.dhis2.org 


 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-users@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp


>>>
>>>
>>> --
>>> Prosper Behumbiize, MPH
>>> Global HISP| University Of Oslo/HISP Uganda
>>> +256 752 751 776 | +256 776 139 139
>>> pros...@hispuganda.org  | pros...@dhis2.org | Skype:
>>> prospertb
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Jim Grace
>> Core developer, DHIS 2
>> HISP US Inc.
>> http://www.dhis2.org 
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

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

[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 this system setting should be

Ola
--

--
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link


On 3 May 2016 at 21:12, Jim Grace  wrote:

> 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 probably the best "factory" default for DHIS 2, so that
> large numbers are readable on demonstration systems, and so we follow
> international and emerging standards.
>
> However, an implementation should be able to override this with an
> implementation-wide default of comma, where a preponderance of users for
> that implementation are more used to this, and/or where exporting to Excel
> is a concern.
>
> Expecting users to override the default every time they create a pivot
> table is not very user-friendly.
>
>
> On Tue, May 3, 2016 at 1:46 PM, Prosper BT  wrote:
>
>> 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 the pivot table app.
>>>
>>> So lets decide with a poll.. Cast your vote here before Friday 6th!
>>>
>>> http://doodle.com/poll/vtyzgts226aqihev
>>>
>>>
>>> The digit group separator controls how large numbers are being split up,
>>> e.g.
>>>
>>> 1 432
>>> 1,432
>>> 1432
>>>
>>> The digit group separator can be controlled from Options.
>>>
>>> [image: Inline image 1]
>>>
>>> regards,
>>>
>>> Lars
>>>
>>>
>>>
>>> --
>>> Lars Helge Øverland
>>> Lead developer, DHIS 2
>>> University of Oslo
>>> Skype: larshelgeoverland
>>> l...@dhis2.org
>>> http://www.dhis2.org 
>>>
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Prosper Behumbiize, MPH
>> Global HISP| University Of Oslo/HISP Uganda
>> +256 752 751 776 | +256 776 139 139
>> pros...@hispuganda.org  | pros...@dhis2.org | Skype:
>> prospertb
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Jim Grace
> Core developer, DHIS 2
> HISP US Inc.
> http://www.dhis2.org 
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp