akvo / akvo-rsr

Akvo Really Simple Reporting

Akvo Really Simple Reporting (Akvo RSR)

Akvo Foundation is a non-profit foundation that builds open source internet and mobile phone software which is used to make international development cooperation and governance more effective and transparent.

Akvo RSR is part of the Akvo platform. Akvo RSR is a web and Android-based system that makes it easy for international development teams to bring complex networks of projects online and instantly share progress with everyone involved and interested, with a strong focus on the IATI standard.

We believe that Akvo RSR can be used in many other scenarios, including environmental programs and monitoring.

For more information on Akvo RSR, use these links to go directly to one of the corresponding pages:

• Knowledge base
• Developer Documentation
• License

Read more about other Akvo Products.

akvo-rsr's Issues

Deployments should also perform file system housekeeping

The deployment process currently uses various temp directories to store code archives and data archives. A high number of files in these directories could lead to server space running out so we should keep at most 2-3 files and remove any older archives as part of the deployment process.

Add language to the url path

We should have the current language in the url path. (https://docs.djangoproject.com/en/dev/topics/i18n/translation/#url-internationalization)

Enable zoom using scroll wheel on large maps

On the larger maps with the "full" map UI it would be nice to be able to use the scroll wheel to zoom in and out rather than having to resort to the clunky zoom widget. One of the great advantages of scroll wheel zoom is that the map centers on the cursor position making it much easier to choose an area to zoom in on.

SSL (estimate: 64)

Expansion of this should be included here.

Scroll Down Menus not big enough for content

In Spanish (and likely also in other languages) the drop-down box is not big enough to fit the full content that should be displayed there.

https://www.dropbox.com/s/1ez4hqxvgc1pi33/01.png

Bug in Site funding totals

I just noticed the following:
If you start on the link of a partnersite - the donations are not up to date - Water for Life zero Euro...
http://www.sendadrop.akvoapp.org/en/
or through the main site:
http://akvo.org/rsr/projects/all/?title=water+for+life&continent=af&locations__country=12&organisation=679

If you press on the project itself its updated....

http://www.sendadrop.akvoapp.org/en/project/489/

Organisation Link from Update not working

When you are viewing an update such as:
http://akvo.org/rsr/project/469/update/1611/

And you click on the Organisation link directly below the title of the update (NETWAS), then you end up at an error page:
http://akvo.org/rsr/project/469/update/1611/%7Borg_url%7D%7D

Size multi-location maps to make all points visible.

If multiple locations on project/org page, I want the map to be sized and zoomed such that I can see all of them.

Automate execution of the acceptance tests

Our BDD and other acceptance tests should be executed automatically as part of the continuous deployment process so that we can ensure our deployed software functions as expected.

Partner List Navigation is broken

The Navigation of Parnter lists on Akvo.org is not working correctly. When following the flow:
Akvo.org -> Partners -> Project Partners -> List of Support Partners

This gives you a list with 62 ORganisations. Clicking on next page gives you page 2 of a list with 611 Orgs.

https://www.dropbox.com/s/ek1ddvcoqjxtf06/Partner_filter.mov

Partner Map Widget Error

The standard Map Widget for Partners is no longer working. The widget itself is showing an error message.

https://www.dropbox.com/s/67g63fyqrujhhn7/Partner_Map_Widget_Error.png

Update Hosting Environment

Multiple locations associated with a project

As a programme manager with large programmes which stretch over multiple locations I would like to be able to associate my programme with more than one location and have multiple map points displayed, because otherwise it is hard to understand the geographic layout of a programme.

Add multiple locations, try to set both to primary: no error is returned.

In Admin give a project multiple locations. Accidentally try to set both to primary, Save: no error msg returned. Last one added remains set to project location.

Sort on continent/country in listing widget returns FieldError.

Sign in to org with Premium account, go to widget machinery => project listing widget OR go to embedded listing widget. Click Continent or Country in column header to sort: FieldError.

Partners column missing in project list widget

The Partners column in the project list widget shows no organisations

Example: http://www.akvo.org/rsr/widget/project-list/organisation/42/

Edit: @adriancollier 29th October 2012.

There are additional requirements that are not mentioned here that while they do not relate specifically to fix, are relevant to the code being written. These include standard items such as Widgets should be viewable ion a variety of browsers and systems. If further information is needed on these standard requirements, please contact @adriancollier.

• The widget should contain the following columns: Project, Location, Status/Last Updated, Partners, Total Budget/Funding Needed
• All columns visible on the Widget should be populated by relevant content from Akvo RSR
• The Partners Column should contain a list of all partner organisations for this project
• If a partner is linked to the project under 2 or more roles, then only a single entry for this partner should be displayed on the Partners list in the widget column

This work has been estimated at 1 day of development time. Formal initiation of this work will be given shortly along with the assigning of this issue.

A comment at this time will be added to provide the estimated delivery time.

Feature cleanup

Make sure to test the donation system & write release notes.

test

Refactor location model

Currently the akvo.rsr.models.Location model is designed as a generic foreign key. Whilst this was the most flexible solution when locations were first added to the system, it is unwieldy and inflexible to work with going forward.

Locations should be refactored as normal foreign keys to Project and Organisation.

Rich Text Functionality being enabled for Akvo RSR Updates

The form that is provided for users to be able to enter Updates to Projects in RSR should be modified to use Markdown.

This will allow links and media to be included directly within a Project Update.

Correct documentation to be provided on-screen to ensure that users can use the functionality required - e.g. how to include a link within your project update.

Maps - continuation

Continuation of the previous Maps work done.

Image slider thumbs not faded on init

The image slider on the project main page consists of the large current image and a slider below with thumbnails of all images for the project including updates. It seems the thumbs should be "faded" except the thumb for the current image, but this is bugged and only happens if you hover over the thumbs. Maybe check for an update of the js library we use for the slider?

Edit 29th October 2012 @adriancollier:

There are further generic requirements not mentioned below that may be relevant to this fix. If further information on these is needed to complete this issue, then please contact @adriancollier.

An example of this can be seen here: http://www.akvo.org/rsr/project/476/

• The thumbnails of images should be faded on page loading
• The thumbnails should be full-colour when hovering over with the mouse cursor
• The thumbnail for the selected image should be in full-colour
• The behaviour of the slider should be consistent on loading and during interaction
• The behaviour of the slider should be consistent between Akvo RSR and Partner Sites

This work has been estimated at 3 days of development time. Formal initiation of this work will be given shortly along with the assigning of this issue.

A comment at this time will be added to provide the estimated delivery time.

Default zoom for empty maps should show whole world

When the lazy loading maps have yet to be populated you get a zoomed in view of coord 0.00, 0.00, i.e. the Atlantic ocean/Gulf of Guinea. If it's possible to set the zoom level for the map while the locations are loading I'd suggest setting zoom so the whole world is shown instead.

AJAX maps need loading animation

Currently, when the JSON data that powers the global project and organisation maps is not returned immediately from memcache, it can take around 3 seconds or so to fetch it.

Since the map pins do not render until the JSON data has been fetched it is probably worthwhile to have an AJAX loading animation to give the user a visual clue that rendering is not quite complete.

Add automated deployment to build a copy of the live server

We frequently need a copy of the live server build and data for training and documentation purposes as well as being able to diagnose issues with the live server without having to run any tests on the live server.

Provide partners with ability to get project location information via simple API calls

Fix second batch of translation markup issues

Build new Ubuntu 12.04 base Vagrant box

Since there is no available base box with Ubuntu 12.04 (our target OS) we need to build or own development (vagrant) base box. We would first create a base box and then use puppet & our own scripts for building a full running instance. Dev machines needs some more packages so we can use django-pipeline without the need to manually install css/js compressors and such. Maybe it's better to just have one installation and just not use it on non dev machines.

A good alternative seems to be to use VeeWee (A tool to easily build vagrant base boxes or kvm, virtualbox and fusion images)
https://github.com/jedi4ever/veewee/

An other alternative is this script:
http://tumblr.nrako.com/post/22319686853/ubuntu-precise-vagrant-box

Error Message Missing on Registration process

Go to register a new user: select valid org, go to step 2 and enter all fields BUT mismatch the email address and confirmation. The registration fails with NO error message: user is left sitting on step 2 page with no error message.

PS Widget Wording Error

The page for getting a PS Widget, displays incorrect information about how to widget will work. It says that the widget will redirect back to the Akvo.org page and it will redirect back to the original partner site page.

Long fields causing display issues on Org Page

"Long email names are displaying across 1 line & outside the ""box"" on the organisation's page. As an example: http://www.akvo.org/rsr/organisation/340/

Long websites also have same issue: http://www.akvo.org/rsr/organisation/606/

Daniel
March 9th, 2011 @ 03:06 PM
We could:

1. Hide what floats over.
2. Not type the email address but have an ""email"" link.
3. Make if fancy like described below:
   While at it we could work on a solution that hides the email addresses from being viewable in clear text by crawlers. It's not hard to pass a ROT13 encoded email address to the template and then create the link with JavaScript. It would then not be hard to also truncate long email addresses.
   I have done this in my project Bob.gae

I think we should go with option 2 here, and keep it very simple.

On pp OTHER than project main, maps should show one pin for multiple-location projects, but with differentiation.

RSS update feed from all projects in user interface

0.9.14 added a new feature, RSS feeds for all updates from every project. But there is currently no user interface for this feature. One suggestion is to place this on the home page in the blue box, on the same line as "Projects you can fund" but right aligned.

Proposed wording in UI:
Subscribe to all project updates via RSS [RSS icon]

Benchmark Refactor

Based on the discussions mentioned and the requirements stated in this document:

https://docs.google.com/document/d/1tu-UsXF7w7am_h1FNoafPwyscmj2yAry4Wiihg_U22Q/edit

We need to perform the refactor of the benchmark fields.

Please shoult if we need to discuss further the solution.

Upgrade to Python 2.7

Various Python packages are no longer supported on Python 2.5 (e.g. selenium, lettuce and others) and Python 2.7 is now the recommended and most supported 2.x release for many packages.

Project location.state not appearing correctly in XML API output

With the Django 1.2 upgrade, the state field for a project location is now listed in the XML API output but doesn't appear to be translating to the actual state value (e.g. Dhaka for project 22: http://test.akvo.org/rsr/api/project.xml/22/)

Bangladesh <_state><django.db.models.base.ModelState object at 0x2171090> 4 2

Non-Sortable fields omitted from Translation

Due to the different CSS Styling of fields which cannot be sorted in Project Lists, the fields were not included within the Translation requirements and so have not been translated.

Additionally, the difference in styling for these should be modified so it is not so strange looking.

https://www.dropbox.com/s/1ez4hqxvgc1pi33/01.png

Use embed.ly for embedded video.

Currently we are using the djangoembed pluggable app to handle embedded video in RSR and partner sites.

This app is no longer maintained and is rather cumbersome. Embedding should be ported to use the embed.ly API.

http://embed.ly/

Incorrect Error for Add an Update to Unpublished Project

If you try to add an update to a project which is not published, you are told that you can only add updates to projects which you are linked to:

https://www.dropbox.com/s/9w2eaqw1neubbfk/Screen%20Shot%202012-06-25%20at%2016.02.36%20PM.png

This should be changed to something more accurate: "You can post updates to this project as it is not published yet" or something more generic: "This project is currently not accepting updates - please contact your Organisation Administrator for details".

Add a language choser

The language choser will sit in the top right corner.

Prototype map - not appearing

The Project Map which should show on the homepage and on the Global Projects page is not showing.

The Organisation Map is showing on the Global Organisation page as expected with the delayed pin loading after first background image displays.

Maps that should be displayed on Partner Sites are also not appearing.

Partner sites must run with settings.DEBUG = True

In 2.0.6 partner sites have a bug where the site crashes if a request is made without the language part of the path included and settings.DEBUG = False. Changing DEBUG to True solves the issue.

Limit content length in the breadcrum

On projects with long project title the breadcrum can overflow when we introduce the language picker e.g. http://uat.akvo.org/rsr/project/306/update/1070/ we should probably just allow 3 words in each breadcrum item with https://docs.djangoproject.com/en/1.4/ref/templates/builtins/#truncatewords

Remove "People who get..." watsan-specific box from organisation page.

Akvo is no longer watsan only. We should remove this box from the organisation page as soon as possible. Story https://www.pivotaltracker.com/story/show/28850471 covers later re-implementation after Indicators/Benchmarks refactor.

Inline the PublishingStatus into the Project form

In Django 1.4 permissions for inline objects in admin forms are honoured. This allows us to inline the PublishingStatus into the Project and use permissions to only allow editing of the status by certain groups.

Map Zoom Level on Rare Case Partner Site

The Partner Site for Water Bedrijf Groningen, ha only 1 project at the moment:

http://waterbedrijfgroningen.akvoapp.org/en/

The map being displayed it shows the street that this project is on. This zoom level is too much.

Having a maximum default zoom for these maps - something around the same as currently displayed on the Project Page: http://waterbedrijfgroningen.akvoapp.org/en/project/543/

It's not likely to happen frequently, but when it does happen it will be very visible - as all people within that organisation are likely to see the site - plus their partners.

Additionally, this should be applied to projects as well, as a street view as shown on the PS is not very useful.

We should discuss during the RSR Dev Meeting on Tuesday 3rd July.

Show multiple project/org locations clearly in listings.

On project/org listing pages, if there are multiple locations, I want that information to be obvious at a glance.

One way to do this would be to sub text for [country], [continent] as follows

1. if locations in same country - Multiple locations, [country],[continent]
2. if locations on same continent, different countries - "Multiple locations, [continent]"
3. if locations on different continents - "Multiple locations" only

On the project/org main page map, multiple locations should be differentiated.

On project page, user would like to see all locations associated with the project. Difference between primary and all secondary locations should be easy to see.

Remove unused featured project update code

On the home page we have three "Most recent project updates". These used to be a selection from staff picks called "featured updates". We still have the old "featured updates" functionality in our system, hence the translators will get strings related to this to translate.

We should remove the feature.

Layout Broken in Funding Box on Partner Site Project

The Funding box shown on the top right of every Project Page is broken on certain projects within Partner Sites.

For example project 528 on the UNDP Partner Site:
http://undp.akvoapp.org/en/project/528/

The amounts are large and are running outside of the container.

https://www.dropbox.com/s/w1p808slxz71p3u/Screen%20Shot%202012-06-26%20at%2013.49.11%20PM.png