first request for UI / data model improvements [general collection]

[cccs-ip]

This page assembles a list of requested 'fixes' for the CV data management system. This currently includes both requests to change the data model as well as requests to change the UI. I can separate out these issues as necessary. Currently, this is a brainstorming sheet.

An easy mechanism for tracking completion toward each line raised here can be found via this Google Spreadsheet:

https://docs.google.com/a/crossculturalconsult.com/spreadsheets/d/1zG9BjsQPZKPzv-FM_sCKxXvGQiXQ3JyAGy8lZen9oh0/edit#gid=0

admin/projects/project/

• Where it currently says 'loan or grant', we should allow a y/n binary. If the user clicks yes, they could be prompted to enter a number. Loan or grant numbers can be alphanumerical (text entry field). For simplicity, we could allow this field to show my default, or we could allow it to appear for 'administrators' but to have it be invisible to users.
• Would it be possible to allow nested sub-projects? For examples, there is the overall Weda Bay Nickel Project, which subsumes several independent contracts (WBN BFS-ESHIA, WBN FTMP-LS, etc.).

admin/projects/project/###/

• Can we include on this admin page a print-out of which associates are connected each project?
• Increase the viewing box to be able to read more of the sector and sub-sector name.
• Ideally, I would like a different interface, which lists those themes/subthemes already assinged and which has a button for 'add subtheme' similar to how sub-sectors and sub-themes are added.
• I would like the ability to add in CCCS themes without having to specify subthemes, and to easily add in subthemes based on the main theme.
• We should re-name "IFC Sub Themes" to IFC Performance Standard. Where to do this? (I assume in the database.)
• I would like to improve the country selector mechanism. Current system demands scrolling and holding of control, which invites accidental clearance and not transparent in terms of currently-assigned countries.

admin/projects/cccssubsector/

• When I click on the linked sub-theme name, I receive an error, e.g. clicking: https://production.crossculturalconsult.com/admin/projects/cccssubsector/46/?_changelist_filters=p%3D1 -gives error

admin/cvs/cv/11/

• can be make a from- to- date section for consultant time on project (different each consultant; multiple per project)
• can we allow project lists to be sortable by name, date, ect? (current sort in order added, but most recent were at top / now at bottom).

admin/cccsmap/village/

• possible to enable sort and filtering on data series?

admin/cvs/cv/

• I would like to add a field that allows us to define each consultant's role within CCCS so that we can print out a dynamic list similar to how things are shown here: http://crossculturalconsult.com/index.php/en/cccs-network/people-index (and actually replacing this page)

admin/cvs/cv/12/

• It would be great if we could have the capacity to add multiple phone numbers, and to designate between office, mobile, and and home.
• Can we add from- and to- dates for consultation employment on a project (that would run differently that the total duration of the project?

admin/projects/country/

• This table currently doesn’t link to anything, correct? Where / how are we recording country information? Is there a reporting feature if a consultant were to "add country" from their CV project entry form? What happens if they do?

admin/cccsmap/village/

• Is it possible to enable sort and filtering on data series? That is, if I would like to see only projects within one sub-district, or to sort by quartile or population size?