iati / d-portal Goto Github PK

@xriss when you need reference or source material for the tracker, please pull it from the Single Source Of Truth repositories. https://github.com/IATI/IATI-Standard-SSOT

This helps us eat our own dog food on the SSOT, and should mean you have up to date documents.

People will have issues with data, the quality, the display etc.

How do we handle that?

I'll try to write something up.

This a feature that we would like to create for the country tracker.

It will be 3 simple tables, one for last year, one for this year, one for next year. More soon...

Kriss and Shi to work with the datastore to produce a front end representation of some data based around active projects, projects ending soon, and so on.

Just to get a feel for how the tracker might start to look.

Build a list of activities that have longitude and latitude.

Think of it as a data quality thing.

Maybe do it by publisher

maybe build a KML file

I known this is early stages, but with re-use as one of our main objectives, perhaps we could start on writing some 'how to deploy this yourself' instructions.

Could be part of the general ReadMe file for which I will create a new issue

From ideas on how we could get more blocks of key information above the fold on these pages https://docs.google.com/spreadsheet/ccc?key=0AjcB8bJJzWppdE5mT0tBaVFhdDBKVGliVlFMdTJBNGc#gid=0 please feed in any thoughts

bill-anderson and matt need adding to the team so we can assign tasks and they can manage issues

We need to add a simple README file. I'll start one, but may need contributions from others to get right.

Can we get an email address for the first phase of the mailing list feature?

I will be listing the sections that need rewording for the official app below but mainly, I would need a short and simple description of what the Country Tracker is to be placed in the footer and other areas of interest (eg. Introduction on http://dev.ctrack.iatistandard.org/ and footer on http://dev.ctrack.iatistandard.org/html/bangladesh/#about ).

Also, I need to replace the IATI copyright with something else - along the lines of "This was made/assembled/curated/lovingly created by (the A Team) in United Kingdom/Bristol/Up North" for example.

Some of the terminology we pull in from IATI we could simplify? At some point we could consider checking and changing throughout - some examples...
implementation (and other activity status) = in progress
participating organisations = who's involved
commitments (=total budget?)
budget = annual budget

linked to #31

This project needs it's own development server as well as a url (see issue: #10 )
Development server should be in place by Wednesday 15th Jan.

A lot of work has gone into this document:
https://docs.google.com/document/d/1gxvmYZSDXBTSMAU16bxfFd-hn1lYVY1c2olkXbuPBj4/edit

We should check that the dstore Q API takes this into account.

@xriss can you take a look, pls?

1. Where does the money come from
   • Tracking donor money
2. Who does what?
   • Tracking activities by geography and sector
3. Where does the money go?
   • By district and sector

4. What is new?

5. What is changing?

6. What works?

7. Who is responsible

Need to decide on prioritisation of how we display activities on single activity page

Duplicate of #20

The Development Assistance Committee of the Organisation for Economic Cooperation and Development (OECD DAC) maintains the Creditor Reporting System (CRS) which is a backward looking database of OECD assistance to developing countries. Not all OECD members are currently reporting data to IATI so we should use CRS data to fill the gap.

I suggest we maintain (on the datastore?/github?) a single matrix of the most recent year of CRS data where each row is an OECD DAC member country (coded with ISO country code) and each column is a developing country (also coded with ISO country code), The values are the total disbursements for the most recently published calendar year. Every January the data for Year - 2 is opublished (i.e. 2012 data has just been published.)

We can use this table to fill the gaps in missing IATI data.

I suggest we create this manually (requiring a manual update each January). I will get the current data and post it here.

Decide on top 3 or 4 most important missing elements in data

There is quite a big issue with double counting when adding up bilateral (government) and multilateral (UN agencies, World Bank, etc) disbursements together. @bill-anderson is working on this and will provide additional logic for summing disbursements asap.

This should not get in the way of current work on this task.

Fixefox will only load XSL Transforms from the same directory or a parent directory.

https://bugzilla.mozilla.org/show_bug.cgi?id=650844

Therefore, http://dev.ctrack.iatistandard.org:5000/api/1/access/activity.xml does not currently load in firefox.

What are we setting as a default currency for the application?

Should this be a configurable item at installation?

Should this be a configurable by a visitor to the site?

Where can we follow the development of the application?
And is the answer to this an appropriate place, or should it be moved?
Currently we can see things at:
http://wet.hopto.org:5000/static/ctrack/index.html

We need to work out where our source of historical currency data is for conversion.
We also need to agree our methodology for it.

See also: #1 (comment)

Suggested as follows

earliest date first, then ordered by
Commitment
Disbursement
Expenditure
others

Forward port 80 to the node backend.

We will need documents that tell people how they can customise their installation to fit their needs.

I'm thinking:

• language
• theme
• datastore calls

for a start

Group DAC sectors into broad categories, and do mapping of DAC 3 digit to 5 digit codes

The code needs a licence. I would suggest the AGPL.
http://www.gnu.org/licenses/agpl-3.0.html

Taken from iatistandard site by @xriss, seems to be missing text description for codes 15111 & 15112

Do we have a logo systems standard for IATI's corporate identity? This includes corporate colours / fonts and various ways to apply it, ie. smallest allowable size on screen, minimized version without globe icon or vice versa.

So far, I've only been able to source

Is there a source file floating out there that I can have access to?

README file will need:

How to install guidance
Licence information
Links to dev or live sites

We're going to end up drilling down into a single activity at some point. let's try to get some ideas around what this will look like. use the devtracker as an example/starting point. We could start this now.

We may need to take account of when people joined the Euro:
http://en.wikipedia.org/wiki/History_of_the_euro

For instance

http://dev.ctrack.iatistandard.org/q.xml?aid=41122-4380/A0/04/105/004

has the following

<sector code="12240" vocabulary="DAC" percentage="679" >
</sector>
<sector code="16050" vocabulary="DAC" percentage="-11" >
</sector>
<sector code="" vocabulary="DAC" percentage="-360" >
</sector>
<sector code="12240" vocabulary="DAC" percentage="-6" >
</sector>
<sector code="12110" vocabulary="DAC" percentage="-2" >
</sector>
<sector code="12230" vocabulary="DAC" percentage="-49" >
</sector>
<sector code="13020" vocabulary="DAC" percentage="-151" >
</sector>

and you will be glad to know that it does actually add up to 100%

Normally I adjust the percentages so if they are missing or add up to 200% then they will be scaled to retain their relative ratios but fit into 100%.

That won't work here so should I just drop the sign?
Or throw all the numbers away and split them equally across all sectors given?

Anyway it's bad data that needs to be flagged.

For pages with lists of (eg donor) activities such as via 'Where does the money come from' page https://docs.google.com/spreadsheet/ccc?key=0AjcB8bJJzWppdHNXX3JGUnlNeHZ3QjVjNVZ1djl3WlE#gid=0 suggestions on how to lay these pages out

Need logic to clean this up - the donor is not necessarily the reporting-org, for example for the UK this will include everything from the UK including government departments, NGOs, etc

We need to make sure we are getting the right data so lets make sure there is a way to see the working out on stuff.

Also check with Ben's stats stuff - that can generate stuff to see that we are getting e.g. the same number of activities in our datasets.

For Mexico we may want a number of countries available.
We need to list all the countries we want, so Kriss can pull all the data for each country.
(and then show each country in a subdirectory)

On E.g.
http://dev.ctrack.iatistandard.org/html/uganda/#view=donors

At the top somewhere explaining that the values are in USD for example.

How will people be able to reuse each module.

Each module will need documentation on how to do that.

Could start with the single activity viewer

We have a number of lists that we curate, such as currency to country mappings, that we need to work out how we maintain them, communicate with people about them, how they are built and how they will change over time.

Should these list be machine readable?

Look at incorporating these icons into the views;
http://thenounproject.com/collections/ocha-humanitarian-icons/

Not sure about this, but think that the footer might contain some explanation about the data or assumptions made.
e.g. years are calendar years or financial years, calculations used to add sums together, exceptions where data may have been left out and so on.

This might change on different 'page' views.

I was going to call this 'Show your working'

Should we be able to set the preferred language in the application?

1 - how to translate the text on the user interface (esp into country language)
2 - choosing to pull in any IATI data in the relevant/required language (eg any relevant IATI data in French) as the default/an option

eg DFID, Hewlett, World Bank

add activity IDs here, for checking

Where data is used (especially non-IATI data) the source should be referenced.

Equally we should try to ensure we are only re-using data that is licensed for re-use.

Add the link to the development site to the README

http://dev.ctrack.iatistandard.org/