This forum has been moved here:
Helicon Tech Community Forum

  Active TopicsActive Topics  Display List of Forum MembersMemberlist  HelpHelp   RegisterRegister  LoginLogin
Helicon Ape
 Helicon Tech : Helicon Ape
Subject Topic: Complete Newbie Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
adamhw
Newbie
Newbie


Joined: 25 May 2011
Online Status: Offline
Posts: 2
Posted: 25 May 2011 at 4:12am | IP Logged Quote adamhw
Hi there

I've recently installed Helicon Ape on our IIS7 Windows 2008 64 bit server.

We are wanting to make SEF pages from our asp pages on certain websites and I am wantin to demo this software to see if it meets the needs before purchasing.

I'm wondering if this is the correct link for me to use to try and replicate a similiar effect on our server:

http://www.helicontech.com/articles/mod_seo/

thanks

Adam
Back to Top View adamhw's Profile Search for other posts by adamhw
 
Vyacheslav
Admin Group
Admin Group


Joined: 02 July 2008
Location: Ukraine
Online Status: Offline
Posts: 1542
Posted: 25 May 2011 at 3:52pm | IP Logged Quote Vyacheslav
Hello.
Yes, mod_seo is a powerful module for SEO. You may also read the documentation: http://www.helicontech.com/ape/doc/mod_seo.htm

Thank you for choosing Helicon Ape.

__________________
Slavik Shynkarenko,
Helicon Tech.
Back to Top View Vyacheslav's Profile Search for other posts by Vyacheslav Visit Vyacheslav's Homepage
 
adamhw
Newbie
Newbie


Joined: 25 May 2011
Online Status: Offline
Posts: 2
Posted: 01 June 2011 at 4:58am | IP Logged Quote adamhw
Thanks Slavik for your reply - I've tried to emulate what is laid out in www.helicontech.com/ape/doc/mod_seo.htm as below:

this is my htaccess file in the root of my website:

# Helicon Ape version 3.0.0.65

SetEnv mod_seo

DBDriver mssql
# include DBDParams
DBDParams "Data Source=(local)\SQLEXPRESS;Initial Catalog=myDB;User ID=MyUSR;Password=****"
DBDPrepareSQL "SELECT [productname]     FROM [myDB].[dbo].[tbl_product]  WHERE [productid] =@KEY" \
              getSeoTopic
DBDPrepareSQL "SELECT [category]  FROM [myDB].[dbo].[tbl_category]  WHERE [categoryid] =@KEY" \
              getSeoForum

RewriteMap SeoTopic dbd:getSeoTopic
RewriteMap SeoForum dbd:getSeoForum
RewriteMap slug int:slug

#SEO-ing
SeoRule items_by_category.asp\?id=(\d+)&PN=(\d+)$ \
        forum$1-${slug:${SeoForum:$1|not-found}}-$2.html [Redirect,Scope=A]
SeoRule items_by_category.asp\?productid=(\d+)$ \
        forum$1-${slug:${SeoForum:$1|not-found}}.html [Redirect,Scope=A]

SeoRule list_item.asp\?id=(\d+)(?:\&PN=(\d+)\&TPN=(\d+))?(?:&(get=last#\d+))?$ \
        $1-${slug:${SeoTopic:$1|not-found}}(?2-$3).html?4\?$4 [Redirect,Scope=A]

#rewrite to the original ones
RewriteRule ^/(\d+)-.*(?:-(\d+))\.html$ items_by_category.asp\?id=$1&PN=$2 [NC,QSA,L]
RewriteRule ^/(\d+)-.*\.html$ items_by_category.asp\?id=$1 [NC,QSA,L]

RewriteRule ^/(\d+)-.*(?:-(\d+))\.html$ alist_item.asp\?productid=$1&TPN=$2 [NC,QSA]
RewriteRule ^/(\d+)-.*\.html$ alist_item.asp\?productid=$1 [NC,QSA]

However, it doesn't seem to be doing anything.

Have I missed something?

thanks

Adam
Back to Top View adamhw's Profile Search for other posts by adamhw
 
Vyacheslav
Admin Group
Admin Group


Joined: 02 July 2008
Location: Ukraine
Online Status: Offline
Posts: 1542
Posted: 02 June 2011 at 5:37am | IP Logged Quote Vyacheslav
Hello.
Please make sure database settings are correct.
If you need us to design code for you, please consider our commercial services: http://www.helicontech.com/order/#support
Thank you.

__________________
Slavik Shynkarenko,
Helicon Tech.
Back to Top View Vyacheslav's Profile Search for other posts by Vyacheslav Visit Vyacheslav's Homepage
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You can vote in polls in this forum