See:

• APPENDIX 3: NATED TABLE VALUES (https://docs.google.com/document/d/1POLQ4pMvRa1FM81DBoGQwji1Ob4o7bwgc9YzSmVoWbw/edit?pli=1)

We need a geocoding script to locate campuses based on their addresses. This can later be incorporated as a management command.

I know these links are going to change but I noticed it needs two clicks on either Find or Project team login before it does anything

The Campus / Course should have a details page.

Outline

We need to allow the user to share the current results as a printable PDF. The format of the PDF is slightly different to the on screen version and hence a custom pdf should be generated.

Proposed solution

All the information required is already on the client side. It is hard to recreate the same map on the server. Therefore I suggest that we use a client side pdf generation tool.

(Also in #41)

The data models should be in accordance with:

• https://docs.google.com/document/d/1POLQ4pMvRa1FM81DBoGQwji1Ob4o7bwgc9YzSmVoWbw/edit?pli=1
• https://www.lucidchart.com/documents/edit/3f2314e8-4ee0-405d-89e4-b38c29c87554

Please note:

• Use full names not the acronyms (in accordance with our coding standards)

Since the search is very central in this application and the current page state hinges on that:

• keep those terms in the current search box
• have button to reset / restart search (now in #82)
• add search string to url (RESTful) so it can be bookmarked and shared (in spec c iv)

See:

• APPENDIX 4: NCV TABLE VALUES (https://docs.google.com/document/d/1POLQ4pMvRa1FM81DBoGQwji1Ob4o7bwgc9YzSmVoWbw/edit?pli=1)

The data models should be in accordance with:

• https://docs.google.com/document/d/1POLQ4pMvRa1FM81DBoGQwji1Ob4o7bwgc9YzSmVoWbw/edit?pli=1
• https://www.lucidchart.com/documents/edit/3f2314e8-4ee0-405d-89e4-b38c29c87554

Please note:

• Use full names not the acronyms (in accordance with our coding standards)

For the import, I've set some default values about the new fields :
course.py : _long_description
campus.py : _long_description, _complete

We may check that together Christian if we need.

See:

• APPENDIX 5: FOS TABLE VALUES (https://docs.google.com/document/d/1POLQ4pMvRa1FM81DBoGQwji1Ob4o7bwgc9YzSmVoWbw/edit?pli=1)

Currently we have 3 pages. The search and results, the login and the admin page(s). I would be great if the user experience could all happen from the front page. This would imply, Removing the find link. Changing the login page and to an ajax query hovering over the page.

I searched for 'fibre processing' and result included at least one record without that string

And I searched for 'fibre' and got no results!

The data models should be in accordance with:

• https://docs.google.com/document/d/1POLQ4pMvRa1FM81DBoGQwji1Ob4o7bwgc9YzSmVoWbw/edit?pli=1
• https://www.lucidchart.com/documents/edit/3f2314e8-4ee0-405d-89e4-b38c29c87554

Please note:

• Use full names not the acronyms (in accordance with our coding standards)

• Update / merge spreadsheet and MS Access database and load into PostgreSQL such that the FETI database is fully populated with all available course, provider and lookup table data. As clean as possible, no duplicates, etc.
• load geocoding results and update campus geometry column with them.
• test and confirm acceptance by FETI, than back up and use for deployment.

Thereafter, all data maintenance will happen on the live database via the admin functions of the website or via other backend db clients.

In the sidebar and popup results, it would be nice to more clearly see what each item in the result represents. (returned popup fields must be as per #13)

The name of the provider and list of courses are fairly obvious, but 'None' in the popups and the item before the colon in the sidebar results - what do they represent? and if they are empty, do we put dummy or greyed out text in their place?

Some campus have the same name and the same provider. We should add a counter to make them different.

RFC:

Problem:

The site is very search centric and as such choosing the best search solution is important.

Proposed Solution:

A very common search app is haystack (http://haystacksearch.org/). This in conjunction with Solar may be the correct solution for this site.

Expected Outcome:

• Briefly review alternatives and if there is a much better solution we should consider this.
• Investigate haystack and solar to define the system requirements and estimate the time and effort to implement this.
• Provide a implementation breakdown.

The data models should be in accordance with:

• https://docs.google.com/document/d/1POLQ4pMvRa1FM81DBoGQwji1Ob4o7bwgc9YzSmVoWbw/edit?pli=1
• https://www.lucidchart.com/documents/edit/3f2314e8-4ee0-405d-89e4-b38c29c87554

Please note:

• Use full names not the acronyms (in accordance with our coding standards)

The CSRF token is in the url after searching.

The data models should be in accordance with:

• https://docs.google.com/document/d/1POLQ4pMvRa1FM81DBoGQwji1Ob4o7bwgc9YzSmVoWbw/edit?pli=1
• https://www.lucidchart.com/documents/edit/3f2314e8-4ee0-405d-89e4-b38c29c87554

Please note:

• Use full names not the acronyms (in accordance with our coding standards)

Can we please implement git flow and rolling deployment as far as possible, as soon as possible.

• master deploys to http://feti.kartoza.com and only gets updated when Gavin requests a new release for client testing.
• make current work a new develop branch and deploy daily to http://staging.feti.kartoza.com

Refer to spec 3c i-iv

The results of a search must:

• appear in the RH panel, alphabetical order showing Providers incl campuses.
• appear in detailed list with courses that meet search criteria as in http://pi.mapaproject.org/, with same fields as popups (Gavin thinks all available info about a course should be returned -- i.e. all fields and lookups)
• if multiple courses per provider are returned, the provider itself must only appear once (slight modification of c i)
• download pdf of search results (as they appear below the map) (#67)
• --optional nice to have -- A email results link could be quite useful. Adding an email option can be achieved by simply sending a search query with the currently entered search terms.

input from March:

This seems to be some way off at the moment?
The key thing is to have one function for courses, where you can search for individual courses (partial name searches must work as well) and access / edit all fields for that course.
Ditto for Provider.

This is a jumble of different fields which are not navigable (e.g. to edit providers details there are three different options).

What is required is on point of entry per provider, where all the fields can be edited. Mandatory fields to be kept to an absolute minimum at this stage while the data is so raw.

This should all be achievable through Django admin configuration.

A popup on the map should provide the user with information on the selected course/ campus.

Provider popup

This for searches that exclude courses and for the home page where only Providers are mapped by default.

• Bubble to clearly locate the placemarker on the map and to include the following from the database: Provider, Provider Address, status, URL

Course popup

Active in all cases not covered by Provider popup conditions.

• Bubble to clearly locate the placemarker on the map and to include the following from the database: Provider, Provider address, Provider Status, Course name, Level and any information associated with the level. There are four different ‘Level’ fields. Where a value is NULL for any of those ‘Level’ fields, it should be invisible in the Pop-up bubble. In March's review of the data it looks as if there should be a maximum of two different ‘Levels’ in any record.

The course description needs to be shown next to the course and there should be a default showing users that this hasn't yet been loaded.

We currently show all the courses expanded under the various campuses. This may be a bit much. It would be better if these where minimized and when the user is allowed to expand the courses offered at each campus.

RFC

Problem.

The user permissions seem to be more finely grained than a simple binary flag can solve. For this purpose we should add a permissions module to grant users access to editing various models.

Proposed Solution

The built auth in conjunction with models.Permission could be set up to serve this purpose.

Expected Outcome

• Investigate alternatives.

- Provide an implementation breakdown.

The data models should be in accordance with:

• https://docs.google.com/document/d/1POLQ4pMvRa1FM81DBoGQwji1Ob4o7bwgc9YzSmVoWbw/edit?pli=1
• https://www.lucidchart.com/documents/edit/3f2314e8-4ee0-405d-89e4-b38c29c87554

Please note:

• Use full names not the acronyms (in accordance with our coding standards)

larger popups headers go under the top bar. The map should pan to show the whole popup.

very large popups cross the whole map and you lose control. They should be concertina'd or tabbed or reduced in some way.

It only seems to behave like this when clicking in the side bar. If you click on the map, it pans properly (though large popups still need to be reduced to fit on the screen.)

When the user navigates to the login page it is not clear how to return. When the user is here the find link should be shown.

The etqa institutes have been listed and should be imported into the database.

See

• APPENDIX 1: ETQA TABLE VALUES (https://docs.google.com/document/d/1POLQ4pMvRa1FM81DBoGQwji1Ob4o7bwgc9YzSmVoWbw/edit?pli=1)

The search is quite powerful. But also this causes issues when a user tries to search for something and he misspells. This may leave a 0 results page, which is quite frustrating. Increasing the fuzziness of the search results may assist here.

The course campus link should not be managed by a link model, but rather by django implicitly and as a many to many relationship between campus and course. (as attribute of the campus.)

The non-superuser admin page should allow the logged in users to add/edit those tables that they have permissions for.

The data models should be in accordance with:

• https://docs.google.com/document/d/1POLQ4pMvRa1FM81DBoGQwji1Ob4o7bwgc9YzSmVoWbw/edit?pli=1
• https://www.lucidchart.com/documents/edit/3f2314e8-4ee0-405d-89e4-b38c29c87554

Please note:

• Use full names not the acronyms (in accordance with our coding standards)

I can login now as gavin or March but then just get the same search page with an option to log out. No editing functionality?

Where is Django admin?

When a campus or course is selected (clicked on) on the panel the map zooms to the selection. The popup should be visible at this point.

The search box is currently in the side panel and hence when scrolling it can go out of view. Hence it should be moved into the navigation bar.

The nqf tables data should be imported into the database.

See:

• APPENDIX 2: NQF TABLE VALUES (https://docs.google.com/document/d/1POLQ4pMvRa1FM81DBoGQwji1Ob4o7bwgc9YzSmVoWbw/edit?pli=1)

Ref spec 3 b v and related.

• generic search box
• [ ](optional if single search box works well) Combo boxes and other controls. Use http://pi.mapaproject.org/ and the specs as reference.

Ref also #68 and #36

Set up a map to display all/ search results.

The data models should be in accordance with:

• https://docs.google.com/document/d/1POLQ4pMvRa1FM81DBoGQwji1Ob4o7bwgc9YzSmVoWbw/edit?pli=1
• https://www.lucidchart.com/documents/edit/3f2314e8-4ee0-405d-89e4-b38c29c87554

Please note:

• Use full names not the acronyms (in accordance with our coding standards)

Please add a list of results below the main map. These should be an expanded version of the list on the right.

IPSS and UWC logos are in django_project/feti/static/feti/images/.

Please provide specs (size and resolution) for final images to be supplied by client.

also feel free to move the images to a more django-best-practice location in the repo.

The data models should be in accordance with:

• https://docs.google.com/document/d/1POLQ4pMvRa1FM81DBoGQwji1Ob4o7bwgc9YzSmVoWbw/edit?pli=1
• https://www.lucidchart.com/documents/edit/3f2314e8-4ee0-405d-89e4-b38c29c87554

Please note:

• Use full names not the acronyms (in accordance with our coding standards)

several providers show what appear to be duplicate courses, e.g.

If these are not duplicates, then more fields should be shown to allow them to be discriminated.

If they are duplicates perhaps we need another round of improving the data import?

The default zoom should always include all results.

The zoom to a specific campus is too deep. A more reasonable zoom level should be selected there.