Normalised USD values available for budgets but not for transactions #2219

JoshStanleyDevInit · 2020-04-28T09:35:19Z

With IATI publishers reporting budgets and transactions in various currencies, comparison and aggrgation is made much easier when the values are converted to a normalised currency (particularly USD).

When retrieving activity information, budgets are indeed converted into USD and other currencies.

However, the same conversion is not done for transactions.

See the following query as an example:
https://iati.cloud/search/activity?q=(title_narrative:%22COVID%22%20OR%20description_narrative:%22COVID%22%20OR%20humanitarian_scope_code:%22EP-2020-000012-001%22%20OR%20humanitarian_scope_code:%22HCOVD20%22%20OR%20tag_code:%22EP-2020-000012-001%22)&wt=json&rows=500000

Example Budget Result

Example Transactions Result

@markbrough feel free to add anything to this!

The text was updated successfully, but these errors were encountered:

markbrough · 2020-04-29T15:49:24Z

Thanks @JoshStanleyDevInit - NB the values of other currencies in budgets all have the value 0. My understanding was that this was in the original TOR, so would suggest it is marked as BUG rather than ENHANCEMENT?

matmaxgeds · 2020-08-06T21:06:12Z

@JoshStanleyDevInit - Is there going to be a way that users can know the exchange rates (and source) that were used for these normalisations - that tends to be the most common question that I get asked when showing d-portal normalised figures. If this were d-portal you could have a link to the source, but in the datastore I guess something could be inserted in the output and I guess also at least in the query builder (i.e. not just a 'select output currency' dropdown but a link and an explanation of the methodology, and a way to identify which data returned was originally in USD [edit: I see this already exists as the normalised data uses a new element - I guess the new element should be within the datastore specific namespace though]? I am worried that users might mistake the USD figure for the data published by the publisher? Also what is going to be done for amount that are in the future, or which span long time periods - is there a discussion on the methodology somewhere? Also, why stop at USD, if we are building in currency conversion, persumably many other currencies are easily done?

k8hughes · 2020-08-13T07:54:25Z

As per slack conversation this issue needs to be reopened as it is not currently working as intended.

k8hughes · 2020-09-17T15:38:06Z

@siemvaessen @luminhan can this issue be reopened?

luminhan-zz · 2020-10-15T09:04:32Z

https://docs.google.com/document/d/1gKxQgjKctR9OA_9wJ-WsDCUXz0-Eujnj0XPgkYEvqw0/edit?usp=sharing

amy-silcock · 2020-10-16T08:49:59Z

Adding in comment from other linked issue #2397:

Once #2219 is done, both budgets and transactions are available in USD. The currency conversion is based on the IMF rates .

We would like to add the actual conversion used for any budget and/or transaction in the element and a link to raw source for conversion (IMF).

Example:

Budget or transaction, original currency EUR, amount: EUR1.000 on 01/01/2015 (monthly average is used)
To be converted to USD for 01/01/2015 that would amount to say USD1.100 based with that conversion.

I would expect the Budget or transaction to include raw EUR, converted USD amount, conversion nr + link to IMF currency data report.

amy-silcock · 2020-10-16T08:52:13Z

Spec for getting USD conversion into the Query Builder is here: https://docs.google.com/document/d/1f-BhnkvRsooIKo5COu9g-fYFbYK2tmvgewfiVsKGY1c/edit

Impact assessment by Zimmerman is here: https://docs.google.com/document/d/1gKxQgjKctR9OA_9wJ-WsDCUXz0-Eujnj0XPgkYEvqw0/edit?usp=sharing

Estimation is that this will take 9 days of work and can be completed by the end of the month.
Agreed that this work is to go ahead.

@luminhan @siemvaessen

siemvaessen · 2020-10-19T08:35:30Z

[FORMAL]: TOTALY DAYS REQUIRED: 9 DAYS (IMPLEMENTATION) AS PART OF PHASE 5. DELIVERY END OF MONTH INLCUDING NEW INDEXING/PARSE

amy-silcock · 2020-11-12T09:25:44Z

Testing on this work is complete.

Happy with how the currency conversion is working. This can be deployed.

matmaxgeds · 2020-11-12T09:31:04Z

Hi - how exciting - is there a sample of the output that we can see e.g. to setup parsers for the new USD conversion namespace?

amy-silcock · 2020-11-12T09:34:17Z

Hi @matmaxgeds, do you want to send a query and I'll return the test version? Note, that we've only got it tested on a handful of publishers so far.

matmaxgeds · 2020-11-12T09:38:52Z

Any random single activity would be great @amy-silcock thanks!

amy-silcock · 2020-11-12T10:09:39Z

<?xml version="1.0" encoding="UTF-8"?>
<iati-activities version="2.03">
  <iati-activity last-updated-datetime="2020-08-25T10:49:41Z" xml:lang="en" default-currency="EUR" humanitarian="0" hierarchy="1" linked-data-uri="">
    <iati-identifier>ET-MFA-0001989741-R177</iati-identifier>
    <reporting-org ref="ET-MFA-0001989741" type="21">
      <narrative>Amref Health Africa in Ethiopia</narrative>
    </reporting-org>

    <title>
      <narrative>Yes I do Ethiopia</narrative>
    </title>

    <description type="1">
      <narrative>description of Yes I do Ethiopia</narrative>
    </description>

    <participating-org ref="ET-MFA-0001989741" role="2" type="21">
      <narrative>Amref Health Africa in Ethiopia</narrative>
    </participating-org>
    <participating-org ref="ET-MFA-0001989741" role="4" type="21">
      <narrative>Amref Health Africa in Ethiopia</narrative>
    </participating-org>
    <participating-org ref="NL-KVK-41150298" role="1" type="21">
      <narrative>Amref Flying Doctors</narrative>
    </participating-org>

    <activity-status code="2"/>

    <activity-date iso-date="2020-12-31" type="3"/>
    <activity-date iso-date="2016-01-01" type="2"/>

    <recipient-country code="ET" percentage="100"/>

    <sector code="13020" percentage="50" vocabulary="1"/>
    <sector code="12261" percentage="50" vocabulary="1"/>

    <collaboration-type code="1"/>

    <default-flow-type code="30"/>

    <default-finance-type code="110"/>

    <default-aid-type code="C01" vocabulary="1"/>

    <default-tied-status code="5"/>

    <budget status="2" type="1"><period-start iso-date="2016-01-01"/><period-end iso-date="2016-12-31"/>
      <value currency="EUR" value-date="2016-01-01">265288.00</value>
      <imf:usd_budget xmlns:imf="https://www.imf.org/external/index.htm" currency="USD" exchange_rate="1.08579">
        <imf:usd-value>288046.86</imf:usd-value>
        <imf:url>http://www.imf.org/external/np/fin/ert/GUI/Pages/Report.aspx?Type=XML&amp;CU=%27EUR%27,%27JPY%27,%27GBP%27,%27USD%27,%27DZD%27,%27AUD%27,%27ATS%27,%27BHD%27,%27BEF%27,%27VEF%27,%27BWP%27,%27BRL%27,%27BND%27,%27CAD%27,%27CLP%27,%27CNY%27,%27COP%27,%27CYP%27,%27CZK%27,%27DKK%27,%27DEM%27,%27FIM%27,%27FRF%27,%27GRD%27,%27HUF%27,%27ISK%27,%27INR%27,%27IDR%27,%27IRR%27,%27IEP%27,%27ILS%27,%27ITL%27,%27KZT%27,%27KRW%27,%27EEK%27,%27KWD%27,%27LYD%27,%27LUF%27,%27MYR%27,%27MTL%27,%27MUR%27,%27MXN%27,%27NPR%27,%27NLG%27,%27NZD%27,%27NOK%27,%27PEN%27,%27PKR%27,%27UYU%27,%27PHP%27,%27PLN%27,%27PTE%27,%27QAR%27,%27OMR%27,%27RUB%27,%27SAR%27,%27SGD%27,%27SKK%27,%27SIT%27,%27ZAR%27,%27ESP%27,%27LKR%27,%27SEK%27,%27CHF%27,%27THB%27,%27TTD%27,%27TND%27,%27AED%27,%27VEB%27&amp;EX=SDRC&amp;P=DateRange&amp;CF=UnCompressed&amp;CUF=Period&amp;DS=Ascending&amp;DT=NA&amp;Fr=635872032000000000&amp;To=635897952000000000</imf:url>
      </imf:usd_budget>
    </budget>

    <transaction humanitarian="1" ref="18"><transaction-type code="4"/><transaction-date iso-date="2019-07-01"/>
      <value currency="EUR" value-date="2019-07-01">178512.00</value>
      <description>
        <narrative>6th Expenditure Jan -June 2019</narrative>
      </description><provider-org provider-activity-id="NL-KVK-41150298-4203" ref="NL-KVK-41150298 "/><receiver-org ref="ET-MFA-0001989741" type="21"/><disbursement-channel code="2"/><flow-type code="30"/><finance-type code="110"/><tied-status code="5"/>
      <imf:usd_transaction xmlns:imf="https://www.imf.org/external/index.htm" currency="USD" exchange_rate="1.12151">
        <imf:usd-value>200202.72</imf:usd-value>
        <imf:url>http://www.imf.org/external/np/fin/ert/GUI/Pages/Report.aspx?Type=XML&amp;CU=%27EUR%27,%27JPY%27,%27GBP%27,%27USD%27,%27DZD%27,%27AUD%27,%27ATS%27,%27BHD%27,%27BEF%27,%27VEF%27,%27BWP%27,%27BRL%27,%27BND%27,%27CAD%27,%27CLP%27,%27CNY%27,%27COP%27,%27CYP%27,%27CZK%27,%27DKK%27,%27DEM%27,%27FIM%27,%27FRF%27,%27GRD%27,%27HUF%27,%27ISK%27,%27INR%27,%27IDR%27,%27IRR%27,%27IEP%27,%27ILS%27,%27ITL%27,%27KZT%27,%27KRW%27,%27EEK%27,%27KWD%27,%27LYD%27,%27LUF%27,%27MYR%27,%27MTL%27,%27MUR%27,%27MXN%27,%27NPR%27,%27NLG%27,%27NZD%27,%27NOK%27,%27PEN%27,%27PKR%27,%27UYU%27,%27PHP%27,%27PLN%27,%27PTE%27,%27QAR%27,%27OMR%27,%27RUB%27,%27SAR%27,%27SGD%27,%27SKK%27,%27SIT%27,%27ZAR%27,%27ESP%27,%27LKR%27,%27SEK%27,%27CHF%27,%27THB%27,%27TTD%27,%27TND%27,%27AED%27,%27VEB%27&amp;EX=SDRC&amp;P=DateRange&amp;CF=UnCompressed&amp;CUF=Period&amp;DS=Ascending&amp;DT=NA&amp;Fr=636975360000000000&amp;To=637001280000000000</imf:url>
      </imf:usd_transaction>
    </transaction>

  </iati-activity>
</iati-activities>

matmaxgeds · 2020-11-12T10:34:30Z

Thanks @amy-silcock - that looks very IATI 3.0! and I am always happy when the namespace element is being used - and this is a great use-case for it!

I would not call the namespace "IMF" as that implies that the IMF are responsible, perhaps "IATI_Secretariat" and then update it to "usd_transaction_IMF_xrate"
Will there be a link to some sort of explanation e.g. via the initial instance of xmlns:iati_secretariat....that could be a webpage which describes the methodology e.g. what exchange rate is used for transactions in the future, or for transactions taking place over a whole year etc?
When I follow one of the IMF links I get the error "Object reference not set to an instance of an object."
Despite thinking this is very cool, I want to note that this really starts moving away from the original concept of the datastore as a way to access IATI data without needing to use the registry/parse all the files yourself. We are now loading up the new datastore with a lot of value added services e.g. this, conversion to 2.03 etc, and this breaks the modular nature of IATI. I think this would be best done as a separate service on top of the datastore, and there is no end to these requests, and it will load up technical debt of the kind that IATI was seeking to move away from e.g. now when DSv3 comes, it will have to have all of these features built in, rather than the service that does these value added things being separate/modular, and just being pointed to the new DSv3....... /end_old_school_IATI_philosophy_rant

amy-silcock · 2020-11-12T16:01:09Z

Good to hear your views @matmaxgeds.

We'll be updating the user guide with the conversion details and methodology.

@luminhan please do correct me if I'm wrong, the url is what's being used to programmatically grab the conversion rates. As you say, not so workable for users. Matt, if you've got a suggestion of another URL to use please do feel free to share.

matmaxgeds · 2020-11-12T16:32:48Z

Cool, putting the actual rate returned by the IMF query would also be helpful

The user guide sounds like what the namespace url should link to then, I don't think we can assume all users of the datastore (especially when they access IATI data via a third system that is using the datastore as a source) will know where to look to find this stuff out - hence if you provide the link, this can in turn be provided to the end user by the system consuming the data

amy-silcock · 2020-11-12T16:52:57Z

Is the exchange rate to 5 decimal points not enough?

matmaxgeds · 2020-11-12T16:55:34Z

Definitely! Sorry that I missed it hidden in the opening element :)

luminhan-zz · 2020-11-13T10:21:06Z

@matmaxgets The imf urls work well.

<iati-activity last-updated-datetime="2020-08-25T10:49:41Z" xml:lang="en" default-currency="EUR" humanitarian="0" hierarchy="1" linked-data-uri="">
<iati-identifier>ET-MFA-0001989741-R177</iati-identifier>
<reporting-org ref="ET-MFA-0001989741" type="21">
<narrative>Amref Health Africa in Ethiopia</narrative>
</reporting-org>
<title>
<narrative>Yes I do Ethiopia</narrative>
</title>
<description type="1">
<narrative>description of Yes I do Ethiopia</narrative>
</description>
<participating-org ref="ET-MFA-0001989741" role="2" type="21">
<narrative>Amref Health Africa in Ethiopia</narrative>
</participating-org>
<participating-org ref="ET-MFA-0001989741" role="4" type="21">
<narrative>Amref Health Africa in Ethiopia</narrative>
</participating-org>
<participating-org ref="NL-KVK-41150298" role="1" type="21">
<narrative>Amref Flying Doctors</narrative>
</participating-org>
<activity-status code="2"/>
<activity-date iso-date="2020-12-31" type="3"/>
<activity-date iso-date="2016-01-01" type="2"/>
<recipient-country code="ET" percentage="100"/>
<sector code="13020" percentage="50" vocabulary="1"/>
<sector code="12261" percentage="50" vocabulary="1"/>
<collaboration-type code="1"/>
<default-flow-type code="30"/>
<default-finance-type code="110"/>
<default-aid-type code="C01" vocabulary="1"/>
<default-tied-status code="5"/>
<budget status="2" type="1">
<period-start iso-date="2016-01-01"/>
<period-end iso-date="2016-12-31"/>
<value currency="EUR" value-date="2016-01-01">265288.00</value>
<imf:usd_budget xmlns:imf="https://www.imf.org/external/index.htm" currency="USD" exchange_rate="1.08579">
<imf:usd-value>288046.86</imf:usd-value>
<imf:url>http://www.imf.org/external/np/fin/ert/GUI/Pages/Report.aspx?Type=XML&CU=%27EUR%27,%27JPY%27,%27GBP%27,%27USD%27,%27DZD%27,%27AUD%27,%27ATS%27,%27BHD%27,%27BEF%27,%27VEF%27,%27BWP%27,%27BRL%27,%27BND%27,%27CAD%27,%27CLP%27,%27CNY%27,%27COP%27,%27CYP%27,%27CZK%27,%27DKK%27,%27DEM%27,%27FIM%27,%27FRF%27,%27GRD%27,%27HUF%27,%27ISK%27,%27INR%27,%27IDR%27,%27IRR%27,%27IEP%27,%27ILS%27,%27ITL%27,%27KZT%27,%27KRW%27,%27EEK%27,%27KWD%27,%27LYD%27,%27LUF%27,%27MYR%27,%27MTL%27,%27MUR%27,%27MXN%27,%27NPR%27,%27NLG%27,%27NZD%27,%27NOK%27,%27PEN%27,%27PKR%27,%27UYU%27,%27PHP%27,%27PLN%27,%27PTE%27,%27QAR%27,%27OMR%27,%27RUB%27,%27SAR%27,%27SGD%27,%27SKK%27,%27SIT%27,%27ZAR%27,%27ESP%27,%27LKR%27,%27SEK%27,%27CHF%27,%27THB%27,%27TTD%27,%27TND%27,%27AED%27,%27VEB%27&EX=SDRC&P=DateRange&CF=UnCompressed&CUF=Period&DS=Ascending&DT=NA&Fr=635872032000000000&To=635897952000000000</imf:url>
</imf:usd_budget>
</budget>
<transaction humanitarian="1" ref="18">
<transaction-type code="4"/>
<transaction-date iso-date="2019-07-01"/>
<value currency="EUR" value-date="2019-07-01">178512.00</value>
<description>
<narrative>6th Expenditure Jan -June 2019</narrative>
</description>
<provider-org provider-activity-id="NL-KVK-41150298-4203" ref="NL-KVK-41150298 "/>
<receiver-org ref="ET-MFA-0001989741" type="21"/>
<disbursement-channel code="2"/>
<flow-type code="30"/>
<finance-type code="110"/>
<tied-status code="5"/>
<imf:usd_transaction xmlns:imf="https://www.imf.org/external/index.htm" currency="USD" exchange_rate="1.12151">
<imf:usd-value>200202.72</imf:usd-value>
<imf:url>http://www.imf.org/external/np/fin/ert/GUI/Pages/Report.aspx?Type=XML&CU=%27EUR%27,%27JPY%27,%27GBP%27,%27USD%27,%27DZD%27,%27AUD%27,%27ATS%27,%27BHD%27,%27BEF%27,%27VEF%27,%27BWP%27,%27BRL%27,%27BND%27,%27CAD%27,%27CLP%27,%27CNY%27,%27COP%27,%27CYP%27,%27CZK%27,%27DKK%27,%27DEM%27,%27FIM%27,%27FRF%27,%27GRD%27,%27HUF%27,%27ISK%27,%27INR%27,%27IDR%27,%27IRR%27,%27IEP%27,%27ILS%27,%27ITL%27,%27KZT%27,%27KRW%27,%27EEK%27,%27KWD%27,%27LYD%27,%27LUF%27,%27MYR%27,%27MTL%27,%27MUR%27,%27MXN%27,%27NPR%27,%27NLG%27,%27NZD%27,%27NOK%27,%27PEN%27,%27PKR%27,%27UYU%27,%27PHP%27,%27PLN%27,%27PTE%27,%27QAR%27,%27OMR%27,%27RUB%27,%27SAR%27,%27SGD%27,%27SKK%27,%27SIT%27,%27ZAR%27,%27ESP%27,%27LKR%27,%27SEK%27,%27CHF%27,%27THB%27,%27TTD%27,%27TND%27,%27AED%27,%27VEB%27&EX=SDRC&P=DateRange&CF=UnCompressed&CUF=Period&DS=Ascending&DT=NA&Fr=636975360000000000&To=637001280000000000</imf:url>
</imf:usd_transaction>
</transaction>
<transaction humanitarian="1" ref="17">
<transaction-type code="4"/>
<transaction-date iso-date="2019-01-01"/>
<value currency="EUR" value-date="2019-01-01">218976.00</value>
<description>
<narrative>5th Expenditure July -Dec 2018</narrative>
</description>
<provider-org provider-activity-id="NL-KVK-41150298-4203" ref="NL-KVK-41150298 "/>
<receiver-org ref="ET-MFA-0001989741" type="21"/>
<disbursement-channel code="2"/>
<flow-type code="30"/>
<finance-type code="110"/>
<tied-status code="5"/>
<imf:usd_transaction xmlns:imf="https://www.imf.org/external/index.htm" currency="USD" exchange_rate="1.14189">
<imf:usd-value>250046.53</imf:usd-value>
<imf:url>http://www.imf.org/external/np/fin/ert/GUI/Pages/Report.aspx?Type=XML&CU=%27EUR%27,%27JPY%27,%27GBP%27,%27USD%27,%27DZD%27,%27AUD%27,%27ATS%27,%27BHD%27,%27BEF%27,%27VEF%27,%27BWP%27,%27BRL%27,%27BND%27,%27CAD%27,%27CLP%27,%27CNY%27,%27COP%27,%27CYP%27,%27CZK%27,%27DKK%27,%27DEM%27,%27FIM%27,%27FRF%27,%27GRD%27,%27HUF%27,%27ISK%27,%27INR%27,%27IDR%27,%27IRR%27,%27IEP%27,%27ILS%27,%27ITL%27,%27KZT%27,%27KRW%27,%27EEK%27,%27KWD%27,%27LYD%27,%27LUF%27,%27MYR%27,%27MTL%27,%27MUR%27,%27MXN%27,%27NPR%27,%27NLG%27,%27NZD%27,%27NOK%27,%27PEN%27,%27PKR%27,%27UYU%27,%27PHP%27,%27PLN%27,%27PTE%27,%27QAR%27,%27OMR%27,%27RUB%27,%27SAR%27,%27SGD%27,%27SKK%27,%27SIT%27,%27ZAR%27,%27ESP%27,%27LKR%27,%27SEK%27,%27CHF%27,%27THB%27,%27TTD%27,%27TND%27,%27AED%27,%27VEB%27&EX=SDRC&P=DateRange&CF=UnCompressed&CUF=Period&DS=Ascending&DT=NA&Fr=636818976000000000&To=636844896000000000</imf:url>
</imf:usd_transaction>
</transaction>
<transaction humanitarian="1" ref="13">
<transaction-type code="4"/>
<transaction-date iso-date="2018-01-01"/>
<value currency="EUR" value-date="2018-01-01">330978.36</value>
<description>
<narrative>3rd Expenditure July-Dec17</narrative>
</description>
<provider-org provider-activity-id="NL-KVK-41150298-4203" ref="NL-KVK-41150298 "/>
<receiver-org ref="ET-MFA-0001989741" type="21"/>
<disbursement-channel code="2"/>
<flow-type code="30"/>
<finance-type code="110"/>
<tied-status code="5"/>
<imf:usd_transaction xmlns:imf="https://www.imf.org/external/index.htm" currency="USD" exchange_rate="1.21945">
<imf:usd-value>403610.13</imf:usd-value>
<imf:url>http://www.imf.org/external/np/fin/ert/GUI/Pages/Report.aspx?Type=XML&CU=%27EUR%27,%27JPY%27,%27GBP%27,%27USD%27,%27DZD%27,%27AUD%27,%27ATS%27,%27BHD%27,%27BEF%27,%27VEF%27,%27BWP%27,%27BRL%27,%27BND%27,%27CAD%27,%27CLP%27,%27CNY%27,%27COP%27,%27CYP%27,%27CZK%27,%27DKK%27,%27DEM%27,%27FIM%27,%27FRF%27,%27GRD%27,%27HUF%27,%27ISK%27,%27INR%27,%27IDR%27,%27IRR%27,%27IEP%27,%27ILS%27,%27ITL%27,%27KZT%27,%27KRW%27,%27EEK%27,%27KWD%27,%27LYD%27,%27LUF%27,%27MYR%27,%27MTL%27,%27MUR%27,%27MXN%27,%27NPR%27,%27NLG%27,%27NZD%27,%27NOK%27,%27PEN%27,%27PKR%27,%27UYU%27,%27PHP%27,%27PLN%27,%27PTE%27,%27QAR%27,%27OMR%27,%27RUB%27,%27SAR%27,%27SGD%27,%27SKK%27,%27SIT%27,%27ZAR%27,%27ESP%27,%27LKR%27,%27SEK%27,%27CHF%27,%27THB%27,%27TTD%27,%27TND%27,%27AED%27,%27VEB%27&EX=SDRC&P=DateRange&CF=UnCompressed&CUF=Period&DS=Ascending&DT=NA&Fr=636503616000000000&To=636529536000000000</imf:url>
</imf:usd_transaction>
</transaction>
<transaction humanitarian="1" ref="11">
<transaction-type code="4"/>
<transaction-date iso-date="2016-08-01"/>
<value currency="EUR" value-date="2016-08-01">31774.70</value>
<description>
<narrative>1st Expenditure July-Dec16</narrative>
</description>
<provider-org provider-activity-id="NL-KVK-41150298-4203" ref="NL-KVK-41150298 "/>
<receiver-org ref="ET-MFA-0001989741" type="21"/>
<disbursement-channel code="2"/>
<flow-type code="30"/>
<finance-type code="110"/>
<tied-status code="5"/>
<imf:usd_transaction xmlns:imf="https://www.imf.org/external/index.htm" currency="USD" exchange_rate="1.12115">
<imf:usd-value>35624.20</imf:usd-value>
<imf:url>http://www.imf.org/external/np/fin/ert/GUI/Pages/Report.aspx?Type=XML&CU=%27EUR%27,%27JPY%27,%27GBP%27,%27USD%27,%27DZD%27,%27AUD%27,%27ATS%27,%27BHD%27,%27BEF%27,%27VEF%27,%27BWP%27,%27BRL%27,%27BND%27,%27CAD%27,%27CLP%27,%27CNY%27,%27COP%27,%27CYP%27,%27CZK%27,%27DKK%27,%27DEM%27,%27FIM%27,%27FRF%27,%27GRD%27,%27HUF%27,%27ISK%27,%27INR%27,%27IDR%27,%27IRR%27,%27IEP%27,%27ILS%27,%27ITL%27,%27KZT%27,%27KRW%27,%27EEK%27,%27KWD%27,%27LYD%27,%27LUF%27,%27MYR%27,%27MTL%27,%27MUR%27,%27MXN%27,%27NPR%27,%27NLG%27,%27NZD%27,%27NOK%27,%27PEN%27,%27PKR%27,%27UYU%27,%27PHP%27,%27PLN%27,%27PTE%27,%27QAR%27,%27OMR%27,%27RUB%27,%27SAR%27,%27SGD%27,%27SKK%27,%27SIT%27,%27ZAR%27,%27ESP%27,%27LKR%27,%27SEK%27,%27CHF%27,%27THB%27,%27TTD%27,%27TND%27,%27AED%27,%27VEB%27&EX=SDRC&P=DateRange&CF=UnCompressed&CUF=Period&DS=Ascending&DT=NA&Fr=636056064000000000&To=636081984000000000</imf:url>
</imf:usd_transaction>
</transaction>
</iati-activity>
</iati-activities>```

amy-silcock · 2020-11-25T09:12:30Z

@siemvaessen please can we keep this open until it's working in live. Testing this morning and there are no USD conversions when using the Query Builder

siemvaessen · 2020-11-26T12:50:43Z

@amy-silcock could you let us know exactly what it is you were testing? USD conversion works right? Just tested it on production as the Fresh.Parse/Index finished yesterday.

amy-silcock · 2020-11-26T16:34:27Z

I've had another look and it's now there! I probs tested it a little too soon yesterday.

I'll do a full test when I'm back in on Monday.

amy-silcock · 2020-12-07T16:55:27Z

We've tested this, the conversion is working as expected.

siemvaessen added the ENHANCEMENT Enhance things label Apr 29, 2020

siemvaessen assigned HeleneBourgoin May 26, 2020

HeleneBourgoin closed this as completed Jun 24, 2020

k8hughes unassigned HeleneBourgoin Sep 17, 2020

siemvaessen reopened this Sep 18, 2020

siemvaessen assigned luminhan-zz Sep 21, 2020

siemvaessen mentioned this issue Sep 28, 2020

Normalised USD values not available via the QB #2397

Closed

siemvaessen added FEATURE New items P5C and removed ENHANCEMENT Enhance things labels Oct 19, 2020

siemvaessen added the APPR label Nov 13, 2020

siemvaessen closed this as completed Nov 24, 2020

siemvaessen reopened this Nov 25, 2020

luminhan-zz closed this as completed Jan 4, 2021

markbrough mentioned this issue Jan 14, 2021

USD values missing for certain donors #2531

Closed

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Normalised USD values available for budgets but not for transactions #2219

Normalised USD values available for budgets but not for transactions #2219

JoshStanleyDevInit commented Apr 28, 2020

markbrough commented Apr 29, 2020

matmaxgeds commented Aug 6, 2020 •

edited

k8hughes commented Aug 13, 2020

k8hughes commented Sep 17, 2020

luminhan-zz commented Oct 15, 2020

amy-silcock commented Oct 16, 2020 •

edited

amy-silcock commented Oct 16, 2020 •

edited

siemvaessen commented Oct 19, 2020

amy-silcock commented Nov 12, 2020

matmaxgeds commented Nov 12, 2020

amy-silcock commented Nov 12, 2020

matmaxgeds commented Nov 12, 2020

amy-silcock commented Nov 12, 2020 •

edited

matmaxgeds commented Nov 12, 2020 •

edited

amy-silcock commented Nov 12, 2020

matmaxgeds commented Nov 12, 2020 •

edited

amy-silcock commented Nov 12, 2020

matmaxgeds commented Nov 12, 2020

luminhan-zz commented Nov 13, 2020 •

edited

amy-silcock commented Nov 25, 2020

siemvaessen commented Nov 26, 2020

amy-silcock commented Nov 26, 2020

amy-silcock commented Dec 7, 2020

Normalised USD values available for budgets but not for transactions #2219

Normalised USD values available for budgets but not for transactions #2219

Comments

JoshStanleyDevInit commented Apr 28, 2020

markbrough commented Apr 29, 2020

matmaxgeds commented Aug 6, 2020 • edited

k8hughes commented Aug 13, 2020

k8hughes commented Sep 17, 2020

luminhan-zz commented Oct 15, 2020

amy-silcock commented Oct 16, 2020 • edited

amy-silcock commented Oct 16, 2020 • edited

siemvaessen commented Oct 19, 2020

amy-silcock commented Nov 12, 2020

matmaxgeds commented Nov 12, 2020

amy-silcock commented Nov 12, 2020

matmaxgeds commented Nov 12, 2020

amy-silcock commented Nov 12, 2020 • edited

matmaxgeds commented Nov 12, 2020 • edited

amy-silcock commented Nov 12, 2020

matmaxgeds commented Nov 12, 2020 • edited

amy-silcock commented Nov 12, 2020

matmaxgeds commented Nov 12, 2020

luminhan-zz commented Nov 13, 2020 • edited

amy-silcock commented Nov 25, 2020

siemvaessen commented Nov 26, 2020

amy-silcock commented Nov 26, 2020

amy-silcock commented Dec 7, 2020

matmaxgeds commented Aug 6, 2020 •

edited

amy-silcock commented Oct 16, 2020 •

edited

amy-silcock commented Oct 16, 2020 •

edited

amy-silcock commented Nov 12, 2020 •

edited

matmaxgeds commented Nov 12, 2020 •

edited

matmaxgeds commented Nov 12, 2020 •

edited

luminhan-zz commented Nov 13, 2020 •

edited