1. Anonymous User(DC)
  2. Pre-sale questions
  3. Tuesday, 07 September 2021
  4.  Subscribe via email
Hello,
is it possible to set the ROCSVI import of VM products so that the value is inserted only in empty fields? If there is a value, do not overwrite it.
The "overwrite existing data" setting prevents any further writing of data to the product.

Thanks a lot.
Accepted Answer Pending Moderation
Hello,
You do not have an active subscription with RO CSVI to get support on issues.

is it possible to set the ROCSVI import of VM products so that the value is inserted only in empty fields? If there is a value, do not overwrite it.

If there is a value in import file and database field is empty, RO CSVI writes the value to empty field. If there is already a value in database then value from import file will be updated. You can use skip template field for import columns which already have a value in database and should not be updated on import.

The "overwrite existing data" setting prevents any further writing of data to the product.

Correct. Setting this field to No will not update a row which is already existing.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer Pending Moderation
Hello Tharuna,
Thank you very much for the answer, I will definitely buy a subscription. I can't exist without the ROCSVI component.

"You can use skip template field for import columns which already have a value in database and should not be updated on import."
I have the opposite problem. There is no value in the database and I need to overwrite it with a value from a file. But I don't want to override values for other products where the value in the database is. Specifically, we are talking about product_name.
Accepted Answer Pending Moderation
Hello,
I have the opposite problem. There is no value in the database and I need to overwrite it with a value from a file. But I don't want to override values for other products where the value in the database is. Specifically, we are talking about product_name.

The problem here is RO CSVI does not know which product_name is empty in database and which one has a value. If the product row is available in import file, the values are updated regardless of value in database. The current RO CSVI rules process the values from import file but not with database values. Is there any way you know which products have empty product_name and which products have a value?
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!
DC
Submit Your Response
Upload files or images for this discussion by clicking on the upload button below. Supports gif,jpg,png,jpeg,zip,rar,pdf,csv,txt,tsv,xml,docx,doc,xls,xlsx,ods,tgz
• Insert • Remove Upload Files (Maximum File Size: 2 MB)
In this section you can provide your site details at here and it visible to the moderators only.