I need to ask a question before we decide to use Umbraco for a project.
We have a database table with 600 rows. Each row must be used to generate a unique page on the site (so we end up with 600 unique pages).
I know we can just make a single page that uses request string parameters (like "http://www.example.com/page?id=123")
But for SEO reasons, we need the pages to get unique urls based on the data in one of the columns in the database table.
So if the data in the column is "umbraco-project", the url of the matching page must be "http://www.example.com/umbraco-project/". And if the data in the column is "something-umbraco-related", the url of the matching page must be "http://www.example.com/something-umbraco-related/", etc.
Is it possible in Umbraco to generate pages with such urls (without creating each page manually)?
I Think you need CMSImport package wich does the job, it takes wahtever data source you provide to generate content in the content area, it maps your database table fields to your document type property to generate nodes ......
Generating pages based on a database table
Hi,
I need to ask a question before we decide to use Umbraco for a project.
We have a database table with 600 rows. Each row must be used to generate a unique page on the site (so we end up with 600 unique pages).
I know we can just make a single page that uses request string parameters (like "http://www.example.com/page?id=123")
But for SEO reasons, we need the pages to get unique urls based on the data in one of the columns in the database table.
So if the data in the column is "umbraco-project", the url of the matching page must be "http://www.example.com/umbraco-project/". And if the data in the column is "something-umbraco-related", the url of the matching page must be "http://www.example.com/something-umbraco-related/", etc.
Is it possible in Umbraco to generate pages with such urls (without creating each page manually)?
Thanks,
Mads
Hi Mads,
I Think you need CMSImport package wich does the job, it takes wahtever data source you provide to generate content in the content area, it maps your database table fields to your document type property to generate nodes ......
check this out : http://our.umbraco.org/projects/developer-tools/cmsimport
cheers,
jigs
Excellent idea.
I'll try that - and just make a quick program that create the pages if CMSImport doesn't work out.
Thanks a lot for your help.
is working on a reply...