Custom Thousands Separator

If you are using a custom thousands separator in SuperWEB2 (configured using the numberFormat.localeOverride.groupingSeparator setting in SuperWEB2’s configuration.properties file) then you must also configure Job Queue Manager to use the same thousands separator character. While the separator character is not used in cell values in any downloads, it is used in labels in some cases (such as quantiles and ranges that show the range boundaries in the label).

To configure the separator character for Job Queue Manager:

1. Open the file <tomcat_home>\webapps\queuedjobservice\WEB-INF\config\common\service-config.xml in a text editor.

2. Locate the jobResultProvider bean, which will be similar to the following:

   CODE

       <bean id="jobResultProvider" class="au.com.str.jobqueue.server.springImpl.producer.XTabResultProviderTableManagerImpl">
           <!-- fileTemplateDirectory must be relative to web application, e.g. WEB-INF/templates -->
           <property name="fileTemplateDirectory" value="WEB-INF/templates"/>
           <property name="defaultSuppressedZeroString" value="0"/>
           <property name="defaultNonTabulatedSuppressedZeroString" value="-"/>
           <!-- defaultResourceBundleName must be on the classpath, e.g. relative to WEB-INF/classes -->
           <property name="defaultResourceBundleName" value="labels"/>
           <property name="compressionLevel" value="5"/>
           <property name="defaultConcealedString" value="..C"/>
           <property name="defaultNotANumberString" value="..NaN"/>
           <property name="showNaNasZero" value="true"/>
           <property name="formatNumbers" value="true"/>
           <property name="defaultFileTemplates">
               <list>
                   <value>Template.xls</value>
                   <value>Template.xlsx</value>
                   <value>Template.csv</value>
                   <value>Template.csvString</value>
               </list>
           </property>
           <property name="configServerFailOnUnknownProperties" value="true" /> <!-- defaults to true -->
           <property name="tabulationPriority" value="-10000" />
       </bean>

3. Add a groupingSeparator property within the bean, with the value set to the custom separator character you want to use. Specify your character as its HTML entity code. For example, to use a narrow non-breaking space, you would add the following:

   CODE

   <property name="groupingSeparator" value="&#x202F;"/>

   Your complete bean would then look similar to the following:

   CODE

       <bean id="jobResultProvider" class="au.com.str.jobqueue.server.springImpl.producer.XTabResultProviderTableManagerImpl">
           <!-- fileTemplateDirectory must be relative to web application, e.g. WEB-INF/templates -->
           <property name="fileTemplateDirectory" value="WEB-INF/templates"/>
           <property name="defaultSuppressedZeroString" value="0"/>
           <property name="defaultNonTabulatedSuppressedZeroString" value="-"/>
           <!-- defaultResourceBundleName must be on the classpath, e.g. relative to WEB-INF/classes -->
           <property name="defaultResourceBundleName" value="labels"/>
   		<property name="groupingSeparator" value="&#x202F;"/>
           <property name="compressionLevel" value="5"/>
           <property name="defaultConcealedString" value="..C"/>
           <property name="defaultNotANumberString" value="..NaN"/>
           <property name="showNaNasZero" value="true"/>
           <property name="formatNumbers" value="true"/>
           <property name="defaultFileTemplates">
               <list>
                   <value>Template.xls</value>
                   <value>Template.xlsx</value>
                   <value>Template.csv</value>
                   <value>Template.csvString</value>
               </list>
           </property>
           <property name="configServerFailOnUnknownProperties" value="true" /> <!-- defaults to true -->
           <property name="tabulationPriority" value="-10000" />
       </bean> 

4. Save your changes and restart SuperWEB2 and Job Queue Manager.