Transition Technology: Ticket Query

#457: Projects form - Enhance form entry

laura — Thu, 08 Nov 2012 18:15:44 GMT

1 - Entry Form:

Set up new fields and permissions and groupings
Enhance ‘helper’ texts and any links to other parts of TN listed on form to enhance usability and context.
CSS and potential of custom templating/panels if needed for style and layouts

#523: Database intergrity

ed — Tue, 19 Mar 2013 11:33:38 GMT

Following on from comment 4 of ticket 516 (https://tech.transitionnetwork.org/trac/ticket/516#comment:4) , I wanted to check the integrity of the field tables, so I crafted and ran this query:

SELECT count(cck.nid) FROM content_field_region cck LEFT JOIN node node on cck.nid = node.nid WHERE node.nid IS NULL

Which returned 1,173 rows. I then replaced the 'content_field_region' with other fields found on the user profile nodes (which have their own database table) so the full breakdown is:

content_field_region = 1173 content_field_initiative = 1165 content_field_themes = 6256 content_field_training_attended = 1165 content_field_roles_offered = 1285 content_field_other_websites = 1181 content_field_user_types = 1165

So what this means is there are around 1200 entries in field database storage for the above tables that do not have an associated node. This means the data is not properly referentially integral, and ideally these should be cleaned up one day.

The risk is low but it's worth doing a the rest of the audit (with the other fields that have tables of their own) and then cleaning these up at some point. These will have been caused by manual deletes and imports over the years. Drupal would normally keep these sorted but we've had to bypass Drupal a few times.

Or we can leave it as is and let the migration to Drupal 8 resolve this. The cost is a bit more database space and a slightly slower site... Though this *may* cause a bug or two.

#459: Projects form - Project Directory display

laura — Thu, 08 Nov 2012 18:19:53 GMT

3 - Projects Directory (frontend of website) Create new tabbed views for a variety of outputs. New views result listings to be mainly in display format of:

Title (heading)
City/Country? (bold, slightly larger and possible on right)
New summary field and ‘read more about this project’ link

Similar to the ‘full’ PSE widget output list (except not showing distance but town or city and Country)

Tabs: Tab One (default) Projects Home – Introduction short paragraph text and link to adding projects. Lists featured projects Pagination

Tab Two Find by theme – Introduction brief sentence. Search functionality (exposed view filter) for selection of projects by theme. Default view: random pagination

Tab Three Find by location - Introduction brief sentence. Search functionality (exposed view filter) for selection of projects by location to use Names rather than miles. Default view: random or London? (note: LW will test ideas on this) pagination

Tab Four Find by benefits – note this may need to be set up ready but hidden initially until a substantial number of projects have updated their profiles with inclusion of the benefits/outcomes field Introduction brief sentence. Search functionality (exposed view filter) for selection of projects by outcome/benefits Default view: all by date added. pagination

Tab five [Similar to existing projects home page] Find by title with exposed search as is present. and tabular layout with a-z Custom CSS may be needed

Longer term: (possible January?) Enhance projects map page to show attached view of latest projects with relational popups on hover for easy browsing, and / or map filters by theme or benefit to enable a more usable feature of the map ability.

#458: Projects form - Project profile page display

laura — Thu, 08 Nov 2012 18:17:09 GMT

2 – Project Profile individual page display

Panels to re-arrange layout.
Summary on left upper brick, findability on right upper brick with map under (will be a case of working on mockups via LW’s virtual machine, map may need to go further down, but a listing of town, country still to appear in top part). Description to become an expanding box and other data underneath - full width.
Tidy up image display to be more attractive for users. Enable ‘contact’ button for project contact to be more visible.
Panels, views, and CSS theming for frontend enhanced display.