Sortable table/database, that can have attributes applied to each entry
Permalink
I had a meeting this morning with a client who has a very ambitious idea for a database of projects. His company is an architectural practice with over thirty years experience and a database of nearly 2500 completed projects.
First off, he wants to have Featured Projects or Case Studies of 5-10 projects in each category within different sectors, eg Cultural, Education, Residential, Agri, Manufacturing etc. that show off what they can do. These projects will be individual pages that will have attributes defined, that make them sortable via the following categories - Sector, Year of Project, Project Location.
All pretty straight forward so far.
He also wants to have a database that he can import via CSV that will have the remaining projects that they have done in table format.
Where things get tricky is that he wants this table of projects to be sortable using the same attributes as the Featured Projects, (which will all be pages) and to appear below the featured projects when the user filters projects.
I intend on using ChadStrats AJAX Page Tools add on as my filter, which allows filtering of pages via Attributes so I'm wondering if these page attributes could be applied in some way to entries in a list.
First off, he wants to have Featured Projects or Case Studies of 5-10 projects in each category within different sectors, eg Cultural, Education, Residential, Agri, Manufacturing etc. that show off what they can do. These projects will be individual pages that will have attributes defined, that make them sortable via the following categories - Sector, Year of Project, Project Location.
All pretty straight forward so far.
He also wants to have a database that he can import via CSV that will have the remaining projects that they have done in table format.
Where things get tricky is that he wants this table of projects to be sortable using the same attributes as the Featured Projects, (which will all be pages) and to appear below the featured projects when the user filters projects.
I intend on using ChadStrats AJAX Page Tools add on as my filter, which allows filtering of pages via Attributes so I'm wondering if these page attributes could be applied in some way to entries in a list.
Thanks for responding to this John. We had discussed in the meeting that the import would create pages but the table when generated wouldn't link to them. The client thought that having all these empty pages could get to be a bit of a disaster for managing, and also we wondered about updating the list, and would a new import create duplicate pages.
Alternatively, you could create a bunch of empty pages with the appropriate attributes for the extra projects and prevent them from showing, then use the page-list teasers to do what you want.