51 Reply by poncho1234 (edited by poncho1234 12/16/2017 06:19:14 pm)

  • From: Colombia
  • Registered: 12/29/2014
  • Posts: 627

Re: FA2.4.2 error getting exchange rate from Google

?????

I created a non ssl directory, still getting same results.

Not sure if relevant; but in network, I'm getting this error in firefox:-

An unbalanced tree was written using document.write() causing data from the network to be reparsed. For more information https://developer.mozilla.org/en/Optimizing_Your_Pages_for_Speculative_Parsing
exchange_rates.php:6

Nothing similar in chrome

in ie 10:-

DOM7011: The code on this page disabled back and forward caching. For more information, see: http://go.microsoft.com/fwlink/?LinkID=291337
File: exchange_rates.php
HTML1300: Navigation occurred.
File: exchange_rates.php
HTML1524: Invalid HTML5 DOCTYPE. Consider using the interoperable form "<!DOCTYPE html>".
File: exchange_rates.php, Line: 1, Column: 1
HTML1512: Unmatched end tag.
File: exchange_rates.php, Line: 6, Column: 541
HTML1514: Extra "<body>" tag found. Only one "<body>" tag should exist per document.
File: exchange_rates.php, Line: 7, Column: 1
HTML1423: Malformed start tag. Attributes should be separated by whitespace.
File: exchange_rates.php, Line: 19, Column: 299
HTML1409: Invalid attribute name character. Attribute names should not contain ("),('),(<), or (=).
File: exchange_rates.php, Line: 19, Column: 299

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/
  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: FA2.4.2 error getting exchange rate from Google

document.write is used only in lines 1438 and 1439 in includes/ui/ui_view.inc.
This affects the js_cache which you may choose to purge from the company folder.

apmuthu's Website

53 Reply by poncho1234 (edited by poncho1234 12/17/2017 12:31:25 am)

  • From: Colombia
  • Registered: 12/29/2014
  • Posts: 627

Re: FA2.4.2 error getting exchange rate from Google

For google only:-

File: \gl\includes\db\gl_db_rates.inc

219:         if (empty($val) || $val+0 <= 0.00001) {

changed to 

219:         if (empty($val) || $val+0 <= 0.1) {

works for all currencies tested before

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/

54 Reply by poncho1234 (edited by poncho1234 12/17/2017 12:40:42 am)

  • From: Colombia
  • Registered: 12/29/2014
  • Posts: 627

Re: FA2.4.2 error getting exchange rate from Google

I've also found a problem with bloomberg

Directly accessing:-

https://www.bloomberg.com/quote/GBPCOP:CUR

gives:-

The search for GBPCOP:CUR produced no matches. Try the symbol search.

and

https://www.bloomberg.com/quote/CADCOP:CUR

The search for CADCOP:CUR produced no matches. Try the symbol search.

???????

Whilst:

https://www.bloomberg.com/quote/USDCOP:CUR

gives the exchange rate.

So... does anyone else get the same results as me for the above url's?

If you are then Bloomberg does not give full currency exchange rates, if not there is probably regional restrictions.

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/
  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: FA2.4.2 error getting exchange rate from Google

Bloomberg seems to provide USD based rates only. Will check on Google decimal digits since inverted value is available for reverse rates.

apmuthu's Website

  • From: Colombia
  • Registered: 12/29/2014
  • Posts: 627

Re: FA2.4.2 error getting exchange rate from Google

At the moment the extremes seem to be Kuwaiti Dinar (KWD) to the Iranian Rial (IRR) if that works they all will. Not sure if your need extra decimal places

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/