FX updated fail on non-English locale

[GoogleCodeExporter]

See: https://code.google.com/p/hle-ofx-quotes/wiki/Update_FX_Table_Automatically

Comment section.

Original issue reported on code.google.com by hle...@gmail.com on 10 Jan 2013 at 5:57

[GoogleCodeExporter]

Dear hleOFxqoute project member,

Thank you for your help.

I've attached my fx.csv and log.txt here.
When executed fx update with the fx.csv file, only NZD is updated then 
following error message is displayed. Other currency are not updated because of 
the exception error.

8<----------------------------------------------------------->8
Exception in thread "main" java.lang.UnsupportedOperationException: FIXME cannot
 write indexes of this type yet, see Database javadoc for info on enabling large
 index support
        at com.healthmarketscience.jackcess.IndexData.update(IndexData.java:379)

        at com.healthmarketscience.jackcess.Table.updateTableDefinition(Table.ja
va:1556)
        at com.healthmarketscience.jackcess.Table.updateRow(Table.java:1487)
        at com.healthmarketscience.jackcess.Cursor.setCurrentRowValue(Cursor.jav
a:931)
        at com.le.sunriise.currency.UpdateExchangeRates.update(UpdateExchangeRat
es.java:153)
        at com.le.sunriise.currency.UpdateExchangeRates.update(UpdateExchangeRat
es.java:68)
        at com.le.sunriise.currency.UpdateExchangeRates.main(UpdateExchangeRates
.java:50)
        at app.UpdateExchangeRates.main(UpdateExchangeRates.java:9)

8<----------------------------------------------------------->8

Thanks,
Katsuya

Original comment by ka2...@gmail.com on 12 Feb 2013 at 1:02

Attachments:

• fx.csv
• log.txt

[GoogleCodeExporter]

Is forcing java to use English not solving the problem?
try to add -Duser.language=en to the command line

It worked for me, on French version of the OS.

Original comment by nonok...@hotmail.fr on 13 Sep 2013 at 4:43

[GoogleCodeExporter]

Dear HLE

I use this tool to update both currencies exchange rates and stockes values in 
my MS Money. It works very well for all the data in €uros ! tks !
But as soon as I have a stock in USD for example, let's take IBM as un example :
- I write "ibm" in the Yahoo / Symbols tab
- I get "IBM -International Bus - 183,1900 EUR - 2/18/2014 - 4:02pm" in the 
Prices tab
=> the value 183,1900 is right but the currency is wrong : it should be 
183,1900 USD

Do you know how I could fix that ?
Because, obviously, when it arrives in Money at 251.850$ !

tks in advance

Original comment by mmalhuis...@gmail.com on 19 Feb 2014 at 2:34