1. Stevent
  2. RO CSVI
  3. Monday, 15 November 2021
  4.  Subscribe via email

Yes you can update the custom fields for existing articles. You can either provide article id or title/alias and catid/category_path fields in your import. With these fields RO CSVI will check if there is any matching article and update the custom fields else a new article will be created with custom fields.


Can you update based on the article title (and category path)? The documentation states you need an alias to update.
I have a site where I import content from an external database to articles. But I don't have aliases (or article id's) in my import file.
Accepted Answer Pending Moderation
Hello,
I created your issue as a separate topic so the other user is not flooded with reply emails.

In Joomla content import title or alias and catid or category_path are the needed fields. If you have title, RO CSVI will generate alias from the title and if the generated alias and category path matches the existing record, article will be updated if not new article will be created. You need to check if the alias generated from title is same as the one stored in database.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Thank you. I'll test this. I have 2000 items, hopefully that works well.
  1. 2 weeks ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
We recommend you to test import with few records first and if everything is good, you can run the import for 2000 items.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
It works. Records are updated, new items are added.
But I have an additional question: in the import file there are not only new items, but also items have been deleted in the external source. I would like new and existing items to be published and deleted items to be trashed. The only way I could figure this out is bij adding an import field State and setting the default to 1. Then having the settings of my template set to Unpublish before import = Yes. Is that the only way to do this? It seems that newly imported articles are always set to unpublished. Is that correct?
  1. 2 weeks ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
But I have an additional question: in the import file there are not only new items, but also items have been deleted in the external source. I would like new and existing items to be published and deleted items to be trashed. The only way I could figure this out is bij adding an import field State and setting the default to 1. Then having the settings of my template set to Unpublish before import = Yes. Is that the only way to do this?

By setting Unpublish before import to yes, all the articles in database are set to unpublished before running the import and with import and state field set to 1, the records which are imported are set to published. Other articles stays unpublished. If you want articles to be trashed then you need to set state field value to -2 in import.

It seems that newly imported articles are always set to unpublished. Is that correct?

Thats correct. If you do not have state field in import file set to 1 then it is content database table configuration which sets state field as 0 by default which makes articles to stay unpublished.
Kind regards,

Tharuna

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


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