[Hx] Surprise on new collection

3 views
Skip to first unread message

Anton as@sommer-equity.de

unread,
Jun 5, 2022, 11:51:49 AMJun 5
to Helix-L Discussion List
After 10 years, I just started a new collection. (RADE 8.01 b.6350)
Surprise;
Number fields with 2 decimal points assigned only accept „ . “ (Full stop) as decimal sign.
Here in Europe it always accepted „ , “ (comma) as decimal sign. Had no problem with that in the past
Any suggestions here on the list ?

regards
Tony Sommer
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

You received this message because you are subscribed to the mailing list <Hel...@gibhenry.com>.
To unsubscribe, send an email <Helix...@gibhenry.com>; to switch to DIGEST mode, send an email to <Helix-L...@gibhenry.com>; to contact a human being, send an email to <Helix-L...@gibhenry.com>.
Google archive since 20 August 2006: http://groups.google.com/group/helix-l.
Basic archive since March 2017: https://gibhenry.com:9100/Lists/Helix-L/List.html

kanuk kanuk@compuserve.com

unread,
Jun 5, 2022, 12:18:21 PMJun 5
to Helix-L Discussion List
Always been like that.  The Collection keeps the system formatting at birth, and will keep it afterwards.  

I suspect you gave birth to this collection with a comma in system preferences instead of a « , »


kanuk kanuk@compuserve.com

unread,
Jun 5, 2022, 12:20:56 PMJun 5
to Helix-L Discussion List

https://www.qsatoolworks.com/kb/kbfiles/wwhelix/international.html




A Helix collection’s resources are set at the time a collection is created. The setting is taken from the System installed on the computer. Once a database is created, changing those without careful consideration of the ramifications could create serious issues. For example, if your database is created with US resources, currency is shown in dollars. If your database is created with UK resources, currency is shown in pounds. If Helix were to adapt to the current settings of your computer, these values could change not just in terms of display, but in actual terms of meaning. If the dollars (US) display changed to pounds (UK) $500 would suddenly become £500; the meaning of the data would be different, and that could be disastrous.
If your collections were created with a different localization and that is a distraction to you, you will benefit from rolling up your sleeves and learning how to customize those resources. Of course, always experiment on a copy of your collection and run the modified copy through both Helix utilities after making any changes.

Another option
Although resource editing is not very difficult, the notion of messing around ‘inside’ the collection scares some people away from trying. For those people, there is another solution, although it requires much more work.
Since a collection’s itlx resources are set at the time a collection is created, another way to convert a collection is to set up macOS (10.8 or earlier, as per the note above) with the desired localization, then create a new collection. Then copy the structure from the old collection and paste it into the new one. You must then export and import the data from the old collection to the new one.
Of course, Helix won’t do any sort of measurement conversion when importing the data, so it falls upon you to convert the actual numbers stored in field that was formerly displayed as (for



Gib Henry Gib@GibHenry.com

unread,
Jun 5, 2022, 12:21:07 PMJun 5
to Helix-L Discussion List

There may be an AppleScript to change that; worth checking the scripts Matt has put online.  Cheers,


Gib

Anton as@sommer-equity.de

unread,
Jun 5, 2022, 12:42:07 PMJun 5
to Helix-L Discussion List
Hi Gib,
Wish that would be the reason.
I have exactly entered there the signs as used here in Germany.  Comma before decimals. And full stops to group numbers by the thousands.
regards
Tony Sommer

Am 05.06.2022 um 18:20 schrieb Gib Henry G...@GibHenry.com <Hel...@gibhenry.com>:

There may be an AppleScript to change that; worth checking the scripts Matt has put online.  Cheers,


Gib

On 6/5/22 11:16 AM, kanuk ka...@compuserve.com wrote:
Always been like that.  The Collection keeps the system formatting at birth, and will keep it afterwards.  

I suspect you gave birth to this collection with a comma in system preferences instead of a « , »


<PastedGraphic-1.png>
Reply all
Reply to author
Forward
0 new messages