Master Detail the Concrete5 way
Permalink
I can't seem to wrap my head around the best way to code this in C5.
I would like to create a custom table that can spit back a typical master/detail view yet still keep in searchable.
The client will be sending over an excel page once a year to update the table.
The table format will be something like:
UniqueID
Title
ThumbnailPath
ImagePath
ShortDesc
FullDesc
The master page will display Title and Thumbnail
The detail page will display all.
I for some reason think that it is wasteful to create all these as Pages as there may be up to 1000 entries.
Can someone please point me in the right direction.
Very much appreciated, and i have to say if this can be figured out nice and clean then c5 hands down is the BEST system out there!
I would like to create a custom table that can spit back a typical master/detail view yet still keep in searchable.
The client will be sending over an excel page once a year to update the table.
The table format will be something like:
UniqueID
Title
ThumbnailPath
ImagePath
ShortDesc
FullDesc
The master page will display Title and Thumbnail
The detail page will display all.
I for some reason think that it is wasteful to create all these as Pages as there may be up to 1000 entries.
Can someone please point me in the right direction.
Very much appreciated, and i have to say if this can be figured out nice and clean then c5 hands down is the BEST system out there!
storing that information as pages is actually a very typical concrete approach to doing it. that same approach is also done on things like the calendar package and the real estate package. just use that in conjunction with the page list block, and you'll probably need to make a custom template for it to get a thumbnail to show. but if you don't want to do it that way for whatever reason, you can just make a database table and do it the conventional php way if you want.
Thanks Tony,
I guess i would like to keep it in a simple database table as I'm not sure how I would update the table based upon the clients internal database. If i did make it the conventional way, is there any way for the c5 search system to pick up the content?
I guess i would like to keep it in a simple database table as I'm not sure how I would update the table based upon the clients internal database. If i did make it the conventional way, is there any way for the c5 search system to pick up the content?
no, not that I can think off. you'll probably have to do something custom if you're not using the pages approach.
I am new to C5, too, and have spent a couple of hours looking at videos, and reading.
My background is mostly in Joomla, but I am looking to C5 and the Attribute system as a sort of "CCK" (in Joomla/Drupal lingo).
I am looking to do something mostly similar to the OP, not real estate, but renovation projects, with categories and drilldown.
I too, am a little strung out about not having a table for my "records" in the database, but OK, I'll play along, and I have to make Pages...
(Andrew also says in his interview with the guy from EllisLabs that people are doing stuff like this using C5 pages as a kind of CCK/object model, using the attributes - cool!) - is there any recipe for this?
So, I installed locally on my VPS so that I could get a crack at the database, and after a spin through, I can't find where I would import my data. The table called Pages doesn't have any content. I see the relationship of PageTypes to Attributes, but can't find the sample data to make sense of the data model.
I have some 80 or so renovation projects to import, and they have attributes like : Flooring, Appliances, Plumbing, Backsplash, Neighborhood, Description, etc., and categories/tags like Kitchen Remodel, Bath Remodel, etc.
I am scraping the data out of the old site, and have several tools to inject the data into the C5 db, I just can't see where.
Thanks in advance!
My background is mostly in Joomla, but I am looking to C5 and the Attribute system as a sort of "CCK" (in Joomla/Drupal lingo).
I am looking to do something mostly similar to the OP, not real estate, but renovation projects, with categories and drilldown.
I too, am a little strung out about not having a table for my "records" in the database, but OK, I'll play along, and I have to make Pages...
(Andrew also says in his interview with the guy from EllisLabs that people are doing stuff like this using C5 pages as a kind of CCK/object model, using the attributes - cool!) - is there any recipe for this?
So, I installed locally on my VPS so that I could get a crack at the database, and after a spin through, I can't find where I would import my data. The table called Pages doesn't have any content. I see the relationship of PageTypes to Attributes, but can't find the sample data to make sense of the data model.
I have some 80 or so renovation projects to import, and they have attributes like : Flooring, Appliances, Plumbing, Backsplash, Neighborhood, Description, etc., and categories/tags like Kitchen Remodel, Bath Remodel, etc.
I am scraping the data out of the old site, and have several tools to inject the data into the C5 db, I just can't see where.
Thanks in advance!
i wouldn't just inject it into the db,
use the api to add pages and such, make the information into an array and then use api methods to add it to the db,
also, instead of looking in pages look in collections
Mike
Get the c5bundle for only $50!
http://j.mp/i61Far
For a limited time only!
use the api to add pages and such, make the information into an array and then use api methods to add it to the db,
also, instead of looking in pages look in collections
Mike
Get the c5bundle for only $50!
http://j.mp/i61Far
For a limited time only!
