Here is a fuller explanation.

I think I have solved my problem. 

For some reason (that I no longer remember) I changed my locale settings to 
France.  I am an Englishman living in France and usually do everything as if in 
the UK (even via a VPN normally).  I am not even sure if this change occurred 
by me fiddling on the Mac or if it has carried over from my iPhone (doubt that) 
but by changing from UK to France the decimal separator changed from a point 
(0.00) to a comma (0,00).

Reading the error messages I realised (guessed) this change might be the issue. 
 Did some tests and eventually reversed my regional settings so everything is 
once more UK based and after closing and re-opening Gnucash a couple of times 
the problem has disappeared.

I should have noticed earlier because the change also affected the date format 
from dd/mm/yyyy to dd.mm.yyyy but as I upgrade from 5.8 to 5.9 at the same time 
to try to overcome the issue I assumed it was a change that had been made with 
the code!

Perhaps the code should be amended to accept both a comma and a point as a 
separator?  It is made worse by the flexibility of the Mac OS as I can select 
my region as France yet have my number system as 0.00 and not traditional 
French 0,00. The joys of software.


Geoff Jankowski
+44 20 7100 1092
+44 7770 58 48 38
+33 9 85 20 68 20
+33 6 22 93 00 53







> On 23 Oct 2024, at 22:21, Geoff Jankowski via gnucash-user 
> <[email protected]> wrote:
> 
> Yes it was a locale issue but the odd thing is that even though I selected 
> France as my locale, I overrode the comma so that it used a point but it did 
> not work.  I have reversed it all back top a UK setting and it is fine again.
> 
> 
> Geoff Jankowski
> +44 20 7100 1092
> +44 7770 58 48 38
> +33 9 85 20 68 20
> +33 6 22 93 00 53
> 
> 
> 
> 
> 
> 
> 
>> On 23 Oct 2024, at 17:23, Derek Atkins <[email protected]> wrote:
>> 
>> Hi Geoff,
>> 
>> I agree with Fred here.  It looks like the SX was written with one locale
>> of decimal, but you are now in a different locale of decimal.  The SX
>> processor is sensitive in that it stores the raw text and needs the same
>> locale it was written in to properly parse it.
>> 
>> Did you perhaps change your system locale after entering the SX?  Or is
>> the data file with SX from another machine that was in a different locale?
>> 
>> Thanks,
>> 
>> -derek
>> 
>> On Wed, October 23, 2024 11:08 am, Fred Bone wrote:
>>> On 23 October 2024 at 16:42, Geoff Jankowski said:
>>> 
>>>> Hi All, (Again! I am trying to send it as plain text to see if the image
>>>> gets through the server)
>>>> 
>>>> I have resent this with the image attached as suggested.
>>> 
>>> Looks as though it's expecting a comma as the decimal separator, and you
>>> have used dot.
>>> 
>>> _______________________________________________
>>> gnucash-user mailing list
>>> [email protected]
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -----
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>> 
>> 
>> 
>> -- 
>>      Derek Atkins                 617-623-3745
>>      [email protected]             www.ihtfp.com
>>      Computer and Internet Security Consultant
>> 
>> _______________________________________________
>> gnucash-user mailing list
>> [email protected]
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> _______________________________________________
> gnucash-user mailing list
> [email protected]
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

_______________________________________________
gnucash-user mailing list
[email protected]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Reply via email to