<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — FA2.4.2 error getting exchange rate from Google]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=7072&amp;type=atom" />
	<updated>2017-12-17T06:51:27Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=7072</id>
		<entry>
			<title type="html"><![CDATA[Re: FA2.4.2 error getting exchange rate from Google]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=30067#p30067" />
			<content type="html"><![CDATA[<p>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</p>]]></content>
			<author>
				<name><![CDATA[poncho1234]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=19944</uri>
			</author>
			<updated>2017-12-17T06:51:27Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=30067#p30067</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: FA2.4.2 error getting exchange rate from Google]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=30066#p30066" />
			<content type="html"><![CDATA[<p>Bloomberg seems to provide USD based rates only. Will check on Google decimal digits since inverted value is available for reverse rates.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2017-12-17T04:53:33Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=30066#p30066</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: FA2.4.2 error getting exchange rate from Google]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=30063#p30063" />
			<content type="html"><![CDATA[<p>I&#039;ve also found a problem with bloomberg</p><p>Directly accessing:-</p><p><a href="https://www.bloomberg.com/quote/GBPCOP:CUR">https://www.bloomberg.com/quote/GBPCOP:CUR</a></p><p>gives:-</p><p>The search for GBPCOP:CUR produced no matches. Try the symbol search. </p><p>and</p><p><a href="https://www.bloomberg.com/quote/CADCOP:CUR">https://www.bloomberg.com/quote/CADCOP:CUR</a></p><p>The search for CADCOP:CUR produced no matches. Try the symbol search. </p><p>???????</p><p>Whilst:</p><p><a href="https://www.bloomberg.com/quote/USDCOP:CUR">https://www.bloomberg.com/quote/USDCOP:CUR</a></p><p>gives the exchange rate.</p><p>So... does anyone else get the same results as me for the above url&#039;s?</p><p>If you are then Bloomberg does not give full currency exchange rates, if not there is probably regional restrictions.</p>]]></content>
			<author>
				<name><![CDATA[poncho1234]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=19944</uri>
			</author>
			<updated>2017-12-16T20:54:50Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=30063#p30063</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: FA2.4.2 error getting exchange rate from Google]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=30062#p30062" />
			<content type="html"><![CDATA[<p>For google only:-</p><p>File: \gl\includes\db\gl_db_rates.inc<br /></p><div class="codebox"><pre><code>219:         if (empty($val) || $val+0 &lt;= 0.00001) {</code></pre></div><p>changed to </p><div class="codebox"><pre><code>219:         if (empty($val) || $val+0 &lt;= 0.1) {</code></pre></div><p>works for all currencies tested before</p>]]></content>
			<author>
				<name><![CDATA[poncho1234]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=19944</uri>
			</author>
			<updated>2017-12-16T20:17:03Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=30062#p30062</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: FA2.4.2 error getting exchange rate from Google]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=30060#p30060" />
			<content type="html"><![CDATA[<p><strong>document.write</strong> is used only in lines 1438 and 1439 in <strong>includes/ui/ui_view.inc</strong>.<br />This affects the js_cache which you may choose to purge from the company folder.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2017-12-16T18:46:01Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=30060#p30060</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: FA2.4.2 error getting exchange rate from Google]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=30057#p30057" />
			<content type="html"><![CDATA[<p>?????</p><p>I created a non ssl directory, still getting same results.</p><p>Not sure if relevant; but in network, I&#039;m getting this error in firefox:-</p><p>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<br />exchange_rates.php:6</p><p>Nothing similar in chrome</p><p><s>in ie 10:-</s></p><p><s>DOM7011: The code on this page disabled back and forward caching. For more information, see: http://go.microsoft.com/fwlink/?LinkID=291337<br />File: exchange_rates.php<br />HTML1300: Navigation occurred.<br />File: exchange_rates.php<br />HTML1524: Invalid HTML5 DOCTYPE. Consider using the interoperable form &quot;&lt;!DOCTYPE html&gt;&quot;.<br />File: exchange_rates.php, Line: 1, Column: 1<br />HTML1512: Unmatched end tag.<br />File: exchange_rates.php, Line: 6, Column: 541<br />HTML1514: Extra &quot;&lt;body&gt;&quot; tag found. Only one &quot;&lt;body&gt;&quot; tag should exist per document.<br />File: exchange_rates.php, Line: 7, Column: 1<br />HTML1423: Malformed start tag. Attributes should be separated by whitespace.<br />File: exchange_rates.php, Line: 19, Column: 299<br />HTML1409: Invalid attribute name character. Attribute names should not contain (&quot;),(&#039;),(&lt;), or (=).<br />File: exchange_rates.php, Line: 19, Column: 299</s></p>]]></content>
			<author>
				<name><![CDATA[poncho1234]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=19944</uri>
			</author>
			<updated>2017-12-16T17:54:52Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=30057#p30057</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: FA2.4.2 error getting exchange rate from Google]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=30036#p30036" />
			<content type="html"><![CDATA[<p>Then Google must be playing random tricks for your IP range....<br />Their search results have become very diluted in the last 6 months or so.<br />Time for a brand new human vetted one sans corporate control.<br />I will revert when I ave a new test OpenVZ install ready.<br />You can PM me a temporary PPTP VPN for your ISP for me to test.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2017-12-16T02:45:24Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=30036#p30036</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: FA2.4.2 error getting exchange rate from Google]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=30029#p30029" />
			<content type="html"><![CDATA[<p>Open ssl would affect all exchange rates? Its working for some, but not for others?</p>]]></content>
			<author>
				<name><![CDATA[poncho1234]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=19944</uri>
			</author>
			<updated>2017-12-15T18:34:54Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=30029#p30029</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: FA2.4.2 error getting exchange rate from Google]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=30025#p30025" />
			<content type="html"><![CDATA[<p>OpenSSL issue?</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2017-12-15T16:58:23Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=30025#p30025</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: FA2.4.2 error getting exchange rate from Google]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=30024#p30024" />
			<content type="html"><![CDATA[<p>So, if your installations are functioning, it would seem I have additional setup issues with my servers, any ideas on fault finding?</p>]]></content>
			<author>
				<name><![CDATA[poncho1234]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=19944</uri>
			</author>
			<updated>2017-12-15T16:57:05Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=30024#p30024</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: FA2.4.2 error getting exchange rate from Google]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=29997#p29997" />
			<content type="html"><![CDATA[<p>Done that, php info is giving the following:-</p><p>Directive&nbsp; &nbsp; Local Value&nbsp; &nbsp; Master Value<br />allow_url_fopen&nbsp; &nbsp; On&nbsp; &nbsp; On<br />allow_url_include&nbsp; &nbsp; Off&nbsp; &nbsp; Off</p><p>so fopen is enabled</p><p>fopen faults now do not appear</p><p>But I&#039;m am still getting the same results</p>]]></content>
			<author>
				<name><![CDATA[poncho1234]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=19944</uri>
			</author>
			<updated>2017-12-14T19:07:09Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=29997#p29997</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: FA2.4.2 error getting exchange rate from Google]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=29994#p29994" />
			<content type="html"><![CDATA[<p>Looks like you have a php.ini issue as well.</p><p>Set in php.ini: <strong>allow_url_fopen=1</strong> and restart your webserver.<br />It works well in PHP 5.3.1, 5.3.3 and 5.5.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2017-12-14T17:32:50Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=29994#p29994</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: FA2.4.2 error getting exchange rate from Google]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=29986#p29986" />
			<content type="html"><![CDATA[<p>For v7.1.12</p><p>I&#039;m getting these faults for CAD &amp; GBP using Bloomberg and the exchange rate is blank:- (Obviously the currency code changes accordingly in the fault)</p><div class="codebox"><pre><code>file_get_contents(): https:// wrapper is disabled in the server configuration by allow_url_fopen=0 in file: /gl/includes/db/gl_db_rates.inc at line 161
file_get_contents(https://www.bloomberg.com/quote/CADCOP:CUR): failed to open stream: no suitable wrapper could be found in file: /gl/includes/db/gl_db_rates.inc at line 161
number_format() expects parameter 2 to be integer, float given in file: /includes/current_user.inc at line 319</code></pre></div><p>For CLP, euro, MXN, PEN &amp; USD using Bloomberg these faults, but the correct exchange rate:-(Obviously the currency code changes accordingly in the fault)</p><div class="codebox"><pre><code>file_get_contents(): https:// wrapper is disabled in the server configuration by allow_url_fopen=0 in file: /gl/includes/db/gl_db_rates.inc at line 161
file_get_contents(https://www.bloomberg.com/quote/CLPCOP:CUR): failed to open stream: no suitable wrapper could be found in file: /gl/includes/db/gl_db_rates.inc at line 161</code></pre></div><p>Google gives the same results, under 1000 working fine, over gives weird rates as above</p><p>I only have access to change PHP versions to:</p><p>v5.6.32<br />v7.0.26<br />v7.1.12</p><p>Although I can go backwards, but don&#039;t think thats applicable - unless you tell me otherwise?</p>]]></content>
			<author>
				<name><![CDATA[poncho1234]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=19944</uri>
			</author>
			<updated>2017-12-14T14:46:21Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=29986#p29986</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: FA2.4.2 error getting exchange rate from Google]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=29982#p29982" />
			<content type="html"><![CDATA[<p>Only v5.6.32,</p><p>I&#039;ll test some other versions as well..</p>]]></content>
			<author>
				<name><![CDATA[poncho1234]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=19944</uri>
			</author>
			<updated>2017-12-14T12:56:35Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=29982#p29982</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: FA2.4.2 error getting exchange rate from Google]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=29974#p29974" />
			<content type="html"><![CDATA[<p>What versions of PHP did you check earlier?</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2017-12-14T04:16:31Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=29974#p29974</id>
		</entry>
</feed>
