× Here you can get community support related to ReDJ.

Content from Zoo to Seblod

More
7 years 1 day ago #6071 by Stef
Content from Zoo to Seblod was created by Stef
Hi I need an advice here...
recently I had to move content from Zoo component to Seblod...
(For info, At the same time, the whole website moved from J1.5 to J3.6)
My customer also asked me to change to organisation of the content so category are not the same from Zoo to Seblod...
The URL table is now something like :

Example 01
OLD URL : index.php?option=com_zoo&task=item&item_id=199
NEW URL : 36-annuaire-adherents/annuaire-entreprises/164-la-garonne-aluminium

Example 02
OLD URL : index.php?option=com_zoo&task=item&item_id=68
NEW URL : 36-annuaire-adherents/annuaire-entreprises/240-socalait

Etc...

SO as you can see, the path, the ID has change...
What I wanna do a mass redirection cause it is easy for me handle and manage this on excel sheet.
There's about 300 URL to manage...

My first question is :
maybe do you have a better suggestion using RedJ ?

My second question is :
I don't have any mass importation in Redj... What if I use Redj for some regex rule I have already written for other component of that wesbite AND using AT THE SAME TIME Joomla Core redirection (as it has a mass iportation for that kind of problem). Will it be a problem of performance or anything else if I use both at the same time on the same website ?
Thank you in advance for any information or advice...

Please Log in or Create an account to join the conversation.

More
6 years 11 months ago #6072 by admin
Replied by admin on topic Content from Zoo to Seblod
Hi,
unfortunately I can't see any relation between the old URLs and the new ones, so it is not possible to write a rule based only on the source URL. A solution (warmly suggested if you have a loto of URLs to redirect) could be to create a mapping table with the old item id and the new URL:

item_id=199 => 36-annuaire-adherents/annuaire-entreprises/164-la-garonne-aluminium

And create a single ReDJ rule with a table lookup to get the new URL from the current item_id.

Kind regards,
Luigi
The following user(s) said Thank You: Stef

Please Log in or Create an account to join the conversation.

More
6 years 11 months ago #6073 by Stef
Replied by Stef on topic Content from Zoo to Seblod
Hi Luigi,
Thank a lot a lot for taking time to answer, that's great :)
Yeah the problem IS that "no relation" between both...
But your suggestion look great.

Sorry for the newbie question below, but redirection is not my best knowledge ...

So I understand that I have to create a table in Mysql database called in example PREFIX__redjmanual with 3 columns :
ID | old URL | New URL
That's the part I can easily do...

But what I don't know how to do is that part : "a single ReDJ rule with a table lookup to get the new URL from the current item_id"... Is there any tutorial to do that you can suggest me ?
Thanks in advance...

PS : In waiting any advice I have begun to going to Google Webmaster tools, looking for all 404 with com_zoo, clic on the URL and then going back to my REDJ "Error" backend link and fix the 404 with the good URL. A long process, isn't ? :)

Please Log in or Create an account to join the conversation.

More
6 years 11 months ago - 6 years 11 months ago #6074 by Stef
Replied by Stef on topic Content from Zoo to Seblod
Sorry i didn't find how to edit my previous topic...
I have found the database macro in your documentation (should probably read this first)..

SO with my example, i can probably do something like :
(SEE ATTACHMENT, AS YOUR SERVER CONSIDER MY CODE AS SQL INJECTION)

Knowing that a FROM URL can be
index.php?option=com_zoo&task=item&item_id=135
or
index.php?option=com_zoo&task=item&item_id=135&Itemid=59
and I want TO URL
mysite.com/mysection/mycategory/mi-item
Where "mysection/mycategory/mi-item" is what i wrote in my newurl column
Do you agree ?
Attachments:
Last edit: 6 years 11 months ago by Stef.

Please Log in or Create an account to join the conversation.

More
6 years 11 months ago #6075 by admin
Replied by admin on topic Content from Zoo to Seblod
You need to define a placeholder for the matching rule:
id={queryvar item_id}

And put the placeholder in the table lookup macro:
{tableselect table,column,key}${id}{/tableselect}

Kind regards,
Luigi
The following user(s) said Thank You: Stef

Please Log in or Create an account to join the conversation.

More
6 years 11 months ago #6076 by Stef
Replied by Stef on topic Content from Zoo to Seblod
Incredibile !!!
It worked at my first try! I'm so surprised :-)
Thank you very much...
Let's go to the JED voting for your tools and your so efficient help !
(No way to mark the topic "Solved" ?)

Please Log in or Create an account to join the conversation.

Time to create page: 0.119 seconds