convert lot of com_content item links into com_flexicontent

dear flexicontent team,

on an existing joomla-website, i installed flexicontent and imported all content-items.
the menu has about 500 items which all point to a com_content article.
is there a way to convert those menu-links into flexicontent links?

i have seen following difference in the database

index.php?option=com_content&view=article&id=289
into
index.php?option=com_flexicontent&view=item&cid=22&id=289

also the component and params should be changed.

i guess through mysql it should be possible, but i m not an expert in this.

many thanks for feedback,
bart

Hello

- First , you do not need the category id cid= into the URL, if it is missing the main category id is assumed
- Second you do not even need a complex regular expression

It is simple:

1. Backup your DB table #_content, also you can make a copy of the Table in phpmyadmin and test on the copy

2. Use a replacement tool like the one RegularLabs DB-Replacer Joomla extension
extensions.joomla.org/extension/db-replacer

And replace for DB columns "introtext" and "fulltext": with:
and everything should be work

hallo ggppdk,

many thanks for your feedback.
i actually asked how to change the menu-links, but the advice with db replacer helped me out.

thanks for reminding me i also should replace the content-links

cheers
bart