Site structure from database

[blessan]

hi all. I have been working on typolight for the last 4 months. Have to say the experience is good so far. And was even able to solve 1 or 2 posts in this forum. Im on my second project which is a online shop. I created all the pages and templates. Was able to make it as multilingual.
Now for this shop we use our own in house ERP system. The site is managed by typolight. I was able to bring a product listing from my ERP database by creating a custom module. The structure of the site is like

-Category 1
-Product 1
-Product 2
-Category 2
-Product 1
-Product 2

I need to create a description page for each product. The description is in the ERP database. I want to create a page without having to create that page in typolight site structure. Or atleast be able to programatically create pages based on products from my database. Is there a way? I really blank. Cant crack the BE of typolight.

[winanscreative]

Hi Blessan-

Sounds like you don't want to create TL pages to do what you need to do. You want to use the Catalog Ext or even a shop module like Isotope, which will allow you to define listing/reader pages for products and then pull the data from there rather than creating individual pages.

These can be a little trickier to set up, but that should definitely get you pointed in the right direction so that you can sync data in individual tables much easier...

[blessan]

Actually i checked out Isotope. Looks pretty good. But isnt that a complete ERP system. Like I told. We have our own which my company would like to work with Typolight. I am still going through the code of catalog ext. Is there any explanation for that. It looks pretty tricky.
Yesterday, i was able to make a solution. But I need to look for alternates. I made a common page in the site structure name 'product description' which has a link - http://www.typoexample/index.php/produc ... ption.html.
So i used javascript, to put the product Id in the session when a product is clicked in the product listing page. And then redirect control to the above link. So in the 'product-description' page I had a custom module that took product id from the session and took realted info from my ERP database. So basically I got the desired result. But still there are problems like, when i click on a product like 'bulb' I want the link to be
http://www.typoexample/index.php/bulb.html
But right now, all links to products are
http://www.typoexample/index.php/produc ... ption.html.

Any links describing the catalog extension would be grateful.

[blessan]

Ya my boss want a differnt url for each product. Is there a way for this. I just cant understand the code for catalog extension.

[winanscreative]

Hi Bessan-

Check out: http://dev.typolight.org/wiki/typolight ... CatalogExt

Basically you need to set up a Catalog and define the fields. Make sure you set up an alias field so that you can get a custom URL on the reader page.

Then set up two modules and two pages for them: Catalog Lister and Catalog Reader. The lister will list the products, and then will generate a link to the reader module.

It is a little complicated to explain in a single post. I actually did a screencast on using it a few weeks ago:

http://www.winanscreative.com/typolight ... art-i.html

I would also check the forums here for some help:

viewforum.php?f=27

Hope this helps!