finding product URL in Access database?

[BevS97]

I am trying to create a Froogle feed - unfortunatly the prepared ones available from Actinic / MoleEnd etc don't work for us, as google require us to use the large images not the thumbnail ones, and we have our store set up with the larger images in the Extended Info Field, and the image field has thumbnails in it - consquently google is rejecting the feed.

I have managed to create 90% of the feed, but am really struggling with the URL to the product or catalog page - the page name is held in a field called CatalogSection.sPageName however, in my database it doesn't appear to be populated every time - it is only populated about half the time.
If I turn on 'View Page Names' in Actinic, then I can see all the correct page names, but out of 250 Sections, there are only about 100 that have this field populated on the table.

Is there another field that holds this URL? or a formula for converting the section name to a URL - it looks to be something like Catalog Name, Section Name, and then Section Number all compressed together.

[Bruce]

Hi Bev,

The sPageName field will only be populated if you have a 'Page Name' entered against 'Page Name' on the layout tab of the section.

An example would be /acatalog/Section_Name.html#PROD REF

Kind regards,

[BevS97]

yes, I realise that it's not always populated, but how do you determine the URL for those sections without a specified page name?
It's not simply section name,

eg - this section is called Bazzill, but the page is http://www.scrapbookshop.co.uk/acata...zill_BZ_7.html

and this one is called Really Big Letters

http://www.scrapbookshop.co.uk/acata...tters_404.html

Its ones like this that are tricky - Books / Magazines / CDs becomes
http://www.scrapbookshop.co.uk/acata...___CDs_96.html


so, at a guess, we are looking at "Online_catalogue_" + Section Name (with all spaces and punctuation converted to _) + Section Number

I just wondered if that was held anywhere, or that was an easier way to create it?

[Nadeem]

Hi Bev,

The reason why you have "Online_Catalogue_<Pagename>.html", is that Actinic will create this page, if the client hasn't put any 'Page Name' in the section. If you go to the section of Bazzill, and go to the layout tab, you may find under 'Page Name', it is blank. The "Online_Catalogue" part comes from main shop name. If you look at the content tree, after the brochure pages, you will have an green icon which will say "Online_Catalogue". Actinic uses this as a reference for sections which do not have any page name.

Hope this make sense

Kind Regards