KitWallace / AIDVIEW-DB

A repository, browser and API for IATI activities
1 stars 0 forks source link

Canada data #117

Open stevieflow opened 11 years ago

stevieflow commented 11 years ago

Just checking AidView and cant locate any data from Canada via the Organisation grouping - although this does look to be in the Corpus: http://data.aidinfolabs.org/data/corpus/main/Publisher/acdi_cida

I can find some activities, such as this:

https://www.aidview.net/activity/CA-1-A021378002 - but it doesn't have any info for Reporting org

I noticed in their XML that reporting-org is :

reporting-org ref="CA-1" type="10"/

Will continue to investigate

KitWallace commented 11 years ago

The organisation identifier is CA-1

http://data.aidinfolabs.org/data/corpus/main/facet/Reporter/code/CA-1

but there is no name for this organisation - its not in the organisation list and neither is it provided in any of the activities. Hence it is given a name of 'not listed' in the query form and they are retrievable via the API but n the result there is no name element. I can only think that the lack of a name may be why its not viewable in AIDVIEW

stevieflow commented 11 years ago

Thanks Kit

Ill see if they can include the name to resolve that particular issue

This should perhaps be a new issue ticket, but I'm also missing some activities that are in the corpus, but not on AidView.

So, for example:

http://data.aidinfolabs.org/data/corpus/main/set/acdi_cida-act/activity/CA-1-A020449003

is

Page Not Found:

https://www.aidview.net/activity/CA-1-A020449003

caprenter commented 11 years ago

@KitWallace "it is not in the organisation list" - I'm not sure which list you mean, but I do see it here: http://data.aidinfolabs.org/data/codelist/OrganisationIdentifier.

I'm guessing AidView might not be looking up against the ID, and just taking the string between the element braces?

KitWallace commented 11 years ago

Oh so it is- I answered without really looking - It's an error during the OLAP construction for Organisations - I'll fix it this afternoon.

stevieflow commented 11 years ago

I have raised it with Canada anyway - as they will also want to have a fr and en version ....

KitWallace commented 11 years ago

We will need to provide multilingual organisation codelists to do that though

KitWallace commented 11 years ago

OLAP corrected and CA-1 now has a name derived form the master OrgansationIdentifier list. Missing codes have names mined form the activities

stevieflow commented 11 years ago

Thanks

Do you know when this would have an impact in terms of being evident in AidView?

KitWallace commented 11 years ago

cache cleared and now data appears in Adview

KitWallace commented 11 years ago

In an Activity the organisations appear in duplicate because there are two entries for each with different language descriptons. However nothing in the AIDVIEW system takes account of this although the summary data is stll correct, its not clear how best to handle this situation.