Ceon URI Mapping (SEO)

[new2u]

I LOVE this site:
http://www.cssplay.co.uk/
This guy has all kinds of CSS only solutions.. VERY cool stuff..

Thx for the link diva... how well do those drop downs index?

[DivaVocals]

Thx for the link diva... how well do those drop downs index?

You're welcome.. The menu itself doesn't index (nor does it need to.. it's just a menu) The menu itself doesn't need to index at all since the menus simply repeat links that are indexed already via my XML sitemap (I hope I understood your question correctly..) The Zen Cart menu add-on will correctly "fix" the automated links once you apply the Ceon URI mod.

Looking at this article

URL based session id's not only index poorly but they are a security risk. Is there any mod anyone knows of to force these to use cookies? He goes into detail on how to use the .htaaccess file to do this... anyone try it yet?

Not to be the detail police or anything.. But we probably don't want take Conor's support thread too far off topic.. That said, I've seen quite a few posts on this subject sprinkled liberally through out the forum.. Try doing a search for "zenid" and see if you come across anything helpful..

[new2u]

I don't mean to hijack it at all. Just might be a nice touch to the .htaccess file if it works.. I support I could try it and see if zen tanks..

[alan145]

Hello Conor,
I installed the Ceon URI Mapping3.2.4, and it run well on my web, but today, I found a problem. before not installing Ceon URI Mapping, when I click "see all", then it dispaly all my products Directory, but after installing the Ceon URI Mapping, I found that, when I click the "see all", the page is blank, and display nothing, and other EZ pages like wholesale, dropship and gifts are same problems, what the problem is, hope you can help me.
Thank you.
Alan

[alan145]

Hello Conor,
I installed the Ceon URI Mapping3.2.4, and it run well on my web, but today, I found a problem. before not installing Ceon URI Mapping, when I click "see all", then it dispaly all my products Directory, but after installing the Ceon URI Mapping, I found that, when I click the "see all", the page is blank, and display nothing, and other EZ pages like wholesale, dropship and gifts are same problems, what the problem is, hope you can help me.
Thank you.
Alan

this is the pictures

[alan145]

after further checking, I found that, before installing Ceon URI Mapping 3.2.4, my zen cart web already has all the files in the modified_core_files of 1.3.8a.
When I install it, I cover these files which already in my web. is there cause the problem?

[buddhaflow]

So, I've been trying to figure out the mechanics of how your module works a little bit.

My hope is that I could directly work with the SQL tables to do mass changes to my whole things. For instance, I wanted to add a new top level directory to every page on my site.

So, I downloaded the ceon_uri_mappings table, did all the changes I needed in a spreadsheet, converted to back to SQL, and inserted it again (AFTER BACKING EVERYTHING UP FIVE TIMES!). But it didn't work I kept getting a lot of 404 pages, and , for the URL would show http://site.com/dir/subdir/NULL

So, just a couple quick questions.

1) In theory, should it be possible to directly alter the SQL data to add or delete URI mappings? Am I doing something wrong?

2) Are the links created on the page - for categories and products, stored in SQL anymore? I realized that, even when I changed all of the URI mappings, on my web page the category/product links were still all the same, and did not take into account the new URIs. Is there a table where the links are stored?

Is it unwise what I am doing, or should it work if I am careful and do it properly?

Thank you,
Sasha
HyosungSource.com

[kiddo]

There is no problem at all writing to the MySQL table for this mod. I'd say to install it (on a test site perhaps) and look at the data doing it the normal way generates. Once you see how easy it is to enter mappings via sql stmnts, you can write a script to do it however you want.

This may give a clue from one of my own auto mappers:

		$ceon_sql = "insert into ceon_uri_mappings(
			uri,
			language_id,
			current_uri,
			main_page,
			associated_db_id
			) values (
			$uri,
			1,
			1,
			'$page',
			$new_zen_id)";

[buddhaflow]

Right, it should be quite simple, and thank you for your reply.

What I did was (using PHPMyAdmin), I exported the whole table, changed EVERYTHING using Gnumeric spreadsheet, saved to CSV, converted to SQL using a web utility, and inserted everything back into the spreadsheet.

In theory, it should all work. In reality...everything is all messed up! On the home page, the category links all now go to dead product links product links. Nothing works, the whole thing is bonkers.

When I drop the table and reinsert the original exported SQL backup, it still doesn't work. I have to copy over a backup table back, and then it all works.

Weird, weird, weird...maybe it is a problem with PHPMyadmin, or maybe I just screwed something up doing all of those data operations. I'll let you know if I sort it out, or if I still have any questions...

[buddhaflow]

Ah! I figured it out. The whole problem was I was using an online CSV to SQL tool, which was putting quote characters around the "associated_db_id" field, turning them from an int to a string. This was causing the whole thing to choke up. I fixed it by just doing a CSV import into phpMyAdmin.

I am SOOOO happy to see how easy it is to mass edit the mappings by using phpMyAdmin and a basic spreadsheet to manipulate the ceon_uri_mappings SQL table. This makes the extension so much more useful for me. That earns a donation for you. THANK YOU!!!