Quote Originally Posted by miamishop1 View Post
Thanks once again Conor!

I was able to figure out that if I were to query the db the code to use is:
INSERT INTO `zen_ceon_uri_mappings` (`uri`, `language_id`, `current_uri`, `main_page`, `query_string_parameters`, `associated_db_id`, `alternate_uri`,`redirection_type_code`, `date_added`) VALUES

follow by the values to insert...

QUESTION1 (most important):
Using the Insert or the query command, do I still need to associate the uri I'm entering with 'associated_db_id' for contact_us, about_us, shippinginfo and so forth? If not, I leave the value as empty? If I do need to enter an associated_db_id for them, how do I find the right one because if I do a search for value on contact_us, I get a few values...

QUESTION2 (very imporant):
For the about_us, contact_us, shippinginfo, and so on pages, for 'main_page' value, do we need to enter: index for value or for example: CONTACT-US main_page value would be:contact_us and so forth as anyone could see just pointing the cursor to the link and seeing the browser footer link it gives where index.php?main_page=value?

QUESTION2:
What is 'alternate_uri' for?

QUESTION3:
When using the Insert tool, do I need to enter the Null Values or just leave it blank and it automatically fill it with NULL value? I'm not familiar with the insert tool. I always used a query command...

Sorry for keep asking questions about it. I just want to use your addon and I need to have these solved so it could work for me. I'm pretty sure that this thread will help others having similar problem until a new version help handdling the current and historic URI from admin.

Thank you once again Conor!


Loyd
As Conor said you don't use SQL statement but you use the Insert function. Conor's instruction are very easy to follow if you follow them to the tee. I'm going to show you an image of what to inset into the fields. You have to do each link you want to change just like this. If you can not figure it out after this, you will need to pay someone to do it for you.
Here's the image link

Thanks Conor for your time and your hard work on explaining things with this module.