search

BD-IATI / edi

Interface to import IATI data to Bangladesh AIMS
GNU Affero General Public License v3.0
7 stars 3 forks source link

Map provider organisations in transactions #118

Open markbrough opened 7 years ago

markbrough commented 7 years ago

We have a problem in UNDP data where commitments and disbursements are included from different organisations. We need to fairly attribute each commitment / disbursement to the relevant organisation.

The data looks like below.

Can we do something like the following? 1) Take all unique provider-org/narrative/text() elements, if they are not blank 2) Include them in the implementing organisation screen (step 3) to ask the organisation to map them to specific organisation objects in the AIMS 3) Attach a commitment / disbursement to a specific Fund Source; or to the organisation we're currently working with if unknown. 4) On step 6, with the transaction pop-up box, show the name of the provider organisation. 5) When inserting, show the transaction Development Partner as the relevant organisation.

<transaction>
    <transaction-type code="1"/>
    <transaction-date iso-date="2012-12-31"/>
    <value currency="USD" value-date="2012-12-31">3952174</value>
    <provider-org ref="10159" type="40">
        <narrative>EUROPEAN COMMISSION</narrative>
    </provider-org>
    <receiver-org ref="XM-DAC-41114">
        <narrative>United Nations development Programme</narrative>
    </receiver-org>
    <disbursement-channel code="2"/>
</transaction>
<transaction>
    <transaction-type code="2"/>
    <transaction-date iso-date="2016-12-31"/>
    <value currency="USD" value-date="2016-12-31">1</value>
    <provider-org type="40" ref="XM-DAC-41114">
        <narrative>UNITED NATIONS DEVELOPMENT PROGRAMME</narrative>
    </provider-org>
    <receiver-org type="40" ref="XM-DAC-41114">
        <narrative>United Nations development Programme</narrative>
    </receiver-org>
    <disbursement-channel code="2"/>
</transaction>