Categories
View Replies (3)

Resolved Edit URL during Joomla Content export - or add to ID field

  1. sandstorm871
    sandstorm871
  2. RO CSVI
  3. Monday, 04 February 2019
  4.  Subscribe via email
I have a question regarding exporting/importing Joomla Articles & Menus.

I have set up my categories, and have a CSV working for importing a lot of articles.

I want to set up an import for creating menu links. I've tested this and have most of it working, but as there are lots of articles, I'm trying to export the article ID or URL, so this will assist me with the "link" field when running the menu import.

Exporting the Article URL, currently looks like this;
https://www.mydomain.co.uk/index.php?option=com_content&view=article&id=1&catid=2

Can I export this without "https://www.mydomain.co.uk/" and also without the "&catid=2" on the end?

Alternatively, can I export the Article ID, but add this before the id - index.php?option=com_content&view=article&id=

I'm fairly sure I've done both of these in the past, but can't recall how its done & can't find any support docs.

Thanks in advance,

Andy
0
Responses (3)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Andy,
Can I export this without " http://www.mydomain.co.uk/ " and also without the "&catid=2" on the end?

"http://www.mydomain.co.uk/" is the domain name set in CSVI Options page. Export won't run without the domain name so you need to use CSVI Multi replace plugin, find the text "http://www.mydomain.co.uk/" and replace it with empty for article_url.
You need to do the same thing for removing catid find and replace with empty but that is only possible using Regular expression as catid value will change for each article.

Alternatively, can I export the Article ID, but add this before the id - index.php?option=com_content&view=article&id=

In CSVI Multi replace rule plugin, you can select Operation to be Add before value and set the Value field to be 'index.php?option=com_content&view=article&id=', apply the rule on article id field and run the export.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
sandstorm871
sandstorm871
Accepted Answer Pending Moderation
Excellent Tharuna,
I knew that was there, just forgot where it was - I opted to add a URL string before the "ID"on content export, to give me the URL for creating a Menu import :)
I'm not sure if last time I used that; the plugins were already enabled, already included in CSVi or maybe I had enabled them.

Is there a support/documentation article for what these plugins can do? I'd be interested in reading up on it.

Thanks again,
Andy
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Andy,
You can check the plugin documentation page to know on what each CSVI rule plugins are used for.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!