1. elisa
  2. RO CSVI
  3. Tuesday, 12 March 2024
  4.  Subscribe via email
Hi Roland and Tharuna,
can you add a feature / setting to skip an import if use existing id is enabled but the id does not exist?
The problem is that I want to import / overwrite content articles with a table but the table seems to contain content that does not exist anymore.
thank you :O)
Elisa
Accepted Answer
Accepted Answer Pending Moderation
Hello Elisa,

the Scenario is, that when I do this I get the error message that the title needs a default value.
Can you post a screenshot of the actual error? I checked Joomla and the database definition does not require the title field because it has a default value of an empty string and in RO CSVI we only require this field if the ID field is not used. There is no check in RO CSVI to see if this field is empty.

The only real problem I see without a title is there is no way you can edit the article as Joomla removed the Edit button from the toolbar :D So you cannot click on the title to edit the article. Which is fine because manually adding an article the title is a required field.

can you add a feature / setting to skip an import if use existing id is enabled but the id does not exist?
This is your original request and I think this may not require a new setting. If you want to import new articles, you do not need to set the Skip new items to Yes. However if you are updating existing items, you will set this to Yes and the Keep ID can be Yes so you only update existing values. RO CSVI should not add any new IDs when the Skip new items is set to Yes. That will be fixed.

Edit: Attached is a patch file you can use that will skip the IDs that are non-existent when Skip new items is enabled.
Attachments (1)
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. # Permalink
Sorry, the discussion is currently locked. You will not be able to post a reply or a comment at the moment.