Skip to content

Working with Transaction CSV

Anjana Rupakheti edited this page Mar 6, 2019 · 2 revisions

Transactions can be uploaded along with activity or individually per activity both. If you are looking for uploading of transaction along with activity, do visit Working with CSV file for Uploading & Transaction Fields.

As an activity might contain several transactions, uploading them along with activity or entering them manually can be a tedious job. Therefore to simplify the task, only transaction file can be uploaded through the Element list. The necessary steps are as follows:

  1. From the list of activities, go to your respective activity.

  2. On right side scroll down until you find **transaction ** element then click it.

aidstream - activity data 2 Transaction Importer interface will open.

  1. Click on the Import New Transaction button.

aidstream - activity transactions - test123123 no title 1

  1. Select and download the template as per your requirement.

aidstream - upload activity transaction - 2017-20-tech susasan - technology

The attribute difference in simple and detail transactions templates are:

Detail Transaction Template Simple Transaction Template
Transaction Internal Reference Transaction Internal Reference
Humanitarian Humanitarian
Transaction Type Transaction Type
Transaction Date Transaction Date
Transaction Amount Transaction Amount
Transaction Value Date Transaction Value Date
Transaction Currency Transaction Currency
Transaction Description Transaction Description
Sector Vocabulary Sector Vocabulary
Sector Code Sector Code
Recipient Country Code Recipient Country Code
Recipient Region Code Recipient Region Code
Provider Organisation Identifier Provider Organisation Identifier
Provider Organisation Type Provider Organisation Type
Provider Organisation Activity Identifier Provider Organisation Activity Identifier
Provider Organisation Description Provider Organisation Description
Receiver Organisation Identifier Receiver Organisation Identifier
Receiver Organisation Type Receiver Organisation Type
Receiver Organisation Activity Identifier Receiver Organisation Activity Identifier
Receiver Organisation Description Receiver Organisation Description
Disbursement Channel Code
Flow Type Code
Finance Type Code
Aid Type Code
Tied Status Code
  1. Fill in the CSV File.

Concept and filling of CSV is same as of Working with CSV file for Uploading

Note:

  • The date should be in yy/dd/mm format.
  • The header of the template should not be edited or deleted.
  • The cell must be left empty if there is no data for the related heading.
  1. Choose the file and click Upload button.

  2. You will then be redirected to Import Transaction status page.

Here the importer will validate your data in your csv file. All the correct transactions will be marked green and can be imported. If any of the transaction is incorrect then those data will be marked red; you won't be able to import them. You can filter the data according to valid, invalid and all options.

If you click on the red marked transaction's file, data that needs to be corrected will be visible as: aidstream - import status

You can correct those data and upload the file again.

  1. Once all the transaction are correct, you can import them all by ticking on the check boxes and clicking the Import button on the top right. aidstream - import status 1

  2. Successful upload of files will be visible in step 3 inteface as: aidstream - activity transactions - idontknowfile i don t know

Congratulations your transaction file has been uploaded.

Once the transactions have been imported, you can always edit them manually and update the data.

Overwriting the Transaction data through CSV

Clone this wiki locally