Can it be done with CMS made simple?

[Terabyte]

Hi,

I hope you had a great New Year!

New year and new sites have to be done

This time I don't know if I can set up CMSMS, so I thought asking you.

Except for the usual content of a company site, also a listing of business will be made. Around 300 of them stored in a database. NO problem for me to list them on the site as a list, on one page, but ......

... they business have also to be listed idividually, linked from the page with the listing, on own pages that are SEO optimized in some sence, so I have to be able to set "title", "meta tags" and the file name so it looks good without in the CMS making 300 individual pages.

Let's say the businesses have to be listed as
www.domain.xx/business/name1.html
www.domain.xx/business/name2.html
....
...
..

Can this be done without making 300 individal pages??

[cubix]

dont understand exactly but why dont you try...

cataloger module or company directory.

i know the cataloger module supports pretty urls

and i think the company directory uses id/returnid (site/1/1)

both modules allow you to set up categories and a default template with input boxes. text fields etc....

hopefully this helps

[Terabyte]

Thanks. But I would like to use the database that is already done and not fill in 300 listing into the CMS all over again, so the plugins are not interesting for the moment.

I thought that maybe with sending variables in the URL I can without any problem list the business on individual pages and that is probabaly not a problem. The problem is to have customized title, meta tags in each and every individual page.

[Terabyte]

I guess the CMS can handle it since nobody has an idea .... 

[calguy1000]

The companydirectory module does this already....

of course if you've got the entries in the database, then you could

a) learn the companydirectory module and see how it works
b) migrate your data into the companydirectory module

or

c) write your own module in PHP to extract data from the database and display it the way you want.

Yes, CMS made simple will handle this stuff.... you just may have to write something to either convert data, or to display it in it's native format.

[Terabyte]

Thanks. I tried the module you've suggested. Looks promising and after I have looked at the table structure I'll write some script to get my database migrate everyday for that purpose. I just have to see if I can get all the other things to work before I do that.

But I have some problems that I can't figure out after reading the "help" for the companydirectory module.

For the "detail view" I would like to have this, for the SEO reasons (priority number one) and I can't figure it out how to do it:

- pretty urls as for the rest of the site
- being able to set the "title tag"
- being able to set the "meta tag".

Is it possible or it's not?

Also for custom flelds I see that the {$customfield->value} is not listing the value on the website for the detail template. The field is marked as "public" and as I see it it is stored in the tabase.

[Terabyte]

Could you point me in the right direction?

The customfield value in the detail view is not showing up. I'm trying to find the reason, but get lost in the files for this module .... I guess the problem should be in the GetFieldDefsForCompany function or?

When looking at action.details.php the $fielddef->value in "$field->value = $fielddef->value;" is empty. I have veryfied it by putting in a static value there and then it shows up.

[Terabyte]

Well there was a problem in the GetFieldDefsForCompany funktion, more precisly in the DB queries.

The cms_db_prefix variable was only set for the first query that is used only for admin.

Example:

$query = 'SELECT b.* FROM  cms_module_compdir_fielddefs a, cms_module_compdir_fieldvals b WHERE a.id = b.fielddef_id AND a.public > 0 and b.company_id = ?';

Should be:

$query = 'SELECT b.* FROM  '.cms_db_prefix().'module_compdir_fielddefs a, '.cms_db_prefix().'module_compdir_fieldvals b WHERE a.id = b.fielddef_id AND a.public > 0 and b.company_id = ?';