1. jjnxpct
  2. RO CSVI
  3. Thursday, 02 June 2022
  4.  Subscribe via email
Hi! Can we use RO CSVI in this scenario:

Website 1 -> Has a blog (Jomla content article category) with a number of blogs (joomla content articles).
Website 2 -> We would like to display the same artices from website 1 on this website.

Can we do this?

  • Create an export (template) on website 1
  • Put the XML in a (publically accessible) folder on website 1
  • Create and an import template on website 2 (pointing to the foler on website 1 for the XML)
  • Set a cron to tirgger the export template on website one (for example daily at 8:00)
  • Set a cron to trigger the import template on website 2 (for example daily at 9:00)


When this is possible I do have some questions:

  • How do we make sure only published articles on website 1 are exported?
  • Will this SYNC the articles between website 1 and 2? So when blogs are removed on website 1 they will also be removed on website 2?
  • When website 2 already has the articles (form an earlier import) they will not be overwritten (ingnored) on the import? Otherwise the article ID might change?


Hop you can clarify this for me. Thanks!
Accepted Answer Pending Moderation
Hello,

The short answer to your first question is yes, you can do this. Create an export template and store the file in a folder on one site and create an import file on the other site and read the exported file from the URL. Whether it be XML or CSV, that does not really matter, only CSV is a lot easier to setup.

Now to your follow-up questions.

How do we make sure only published articles on website 1 are exported?
Set the option in your template to only export published articles.

Will this SYNC the articles between website 1 and 2? So when blogs are removed on website 1 they will also be removed on website 2?
No it will not. You are not exporting deleted articles ;)

When website 2 already has the articles (form an earlier import) they will not be overwritten (ingnored) on the import? Otherwise the article ID might change?
Set the option in your import template to not overwrite existing data. RO CSVI uses the alias and category ID to determine if an article already exists. If you are going to sync the article ID as well, you need to set the option Keep existing ID. You must be very sure that you are not creating new content on site 2 that has the same ID as on site 1, otherwise no new articles will be added because the ID already exists.

Let me know if that helps.
Kind regards,

RolandD

=========================
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
Accepted Answer Pending Moderation
Thanks Roland! I think I have enough info to do some testing with this. And yes CSV would be the beteer choice here,

I do have two follow-up questions:

1) When te content of the article on the first website has been changed (not the alias) and we set the mentioned import template to 'overwrite existing data' this will update the article content on the second site. Correct? This 'update' will not change the articel ID on the second site right? So if we want to keep the content 'in sync', that would be the way to go. Right?

2) What would you suggest we do when we would like to remove all articles that have been imported before on website 2 but now have been deleted on website 1? Basically creating a sync of articles in a specific category. The only way I can think of at this point is creating a plugin to remove all artivcles from that category and trigger this before the import template cron. Correct? Creating a sync between a export CSV and an exisiting article category would be outside of the scope of the RO CSVI extension?

Kind regards,
Jip
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello Jip,

To answer your follow-up questions:
1. Correct. It will update only but it will update all fields that are in the import file
2. You can use the option Unpublish before import, this will unpublish all articles and then publish the ones in your import file. Only downside is that you will have to import all articles as this option has no settings like which categories to unpublish.

Correct, creating a sync is out-of-scope for RO CSVI however in the upcoming version 8.3.0 we have added the option for global rules. That way you can create your own rule and apply it to the template. This way you can add your logic in your own rule to unpublish with your own criteria.
Kind regards,

RolandD

=========================
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
Accepted Answer Pending Moderation
Great! And thanks for your explanations. Very much apreciated.
  1. more than a month ago
  2. RO CSVI
  3. # 4
  • Page :
  • 1


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