1. zifou
  2. RO CSVI
  3. Monday, 16 August 2021
  4.  Subscribe via email
Hello,

I have setup Csvi and Icecat and working.

But I want to know if we can change the product name with the field in Csv or Xml by the field : GeneratedLocalTitle

I think it's more pertinent because often the name is only a Reference and not a translated title.

If you have a patch why not.

Thank for your help.

[attachment]Capture d’écran 2021-08-16 à 20.26.18.jpg[/attachment]
Attachments (1)
Accepted Answer
Accepted Answer Pending Moderation
Hello,

Yes this won't work. I completely forgot there is more than 1 place to change. I only changed the place where you can test the SFTP connection. Attached is a new patch with all the updated files.

Please load this patch file and let me know how it goes.
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
Accepted Answer Pending Moderation
Hello,
To import GeneratedLocalTitle instead of name

1. In your import template settings on File tab set Use file for configuration to No. Save the template.
2. In RO CSVI template fields, add product_name field, in Your Field set XML Path of GeneratedLocalTitle and save the template. You can use RO CSVI Analyser to get the XML path for fields in import file. Copy XML path for GeneratedLocalTitle from Analyser and use it in Your Field.
3. Run the import.

Let me know if it solves the issue.
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
Accepted Answer Pending Moderation
Hello,
I realised ICECat data is updated based on Import based on field and if the Import based on field value matches the value in database and in file then data is read directly from database table and updated. In this case you can set product_name to Skip during import by setting it in import template settings. Run the import so other fields are updated except product_name.

You can then create another import template with only product_sku and product_name and follow the instructions sent in my previous reply.

1. In your import template settings on File tab set Use file for configuration to No. Save the template.
2. In RO CSVI template fields, add product_sku and for product_name field, in Your Field set XML Path of GeneratedLocalTitle and save the template. You can use RO CSVI Analyser to get the XML path for fields in import file. Copy XML path for GeneratedLocalTitle from Analyser and use it in Your Field.
3. Run the import. That should update the product_name from import file.
Attachments (1)
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. # 2
Accepted Answer Pending Moderation
Hello Tharuna,

And thank you for your reply.

I understand that's possible to import this field, but actually I don't have the file (XML or CSV) because it's stored directly in Icecat Index.

My question is how it's possible to get the field GeneratedLocalTitle after read the icecat index. I have actually more than 1000x products to batch import, and in my import file I only have "Product SKU" & "Manufacturer_Name".

If it'

Thank you.
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello,
There is no direct way to do this. The product_name field has been linked to name node of XML file in RO CSVI code. So if you want to change to use GeneratedLocalTitle instead of Name then you need to hack the core code of RO CSVI which we do not recommend.
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. # 4
Accepted Answer Pending Moderation
It is possible to have this work from your company and paid for this service ?
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello,
We are looking into improving ICECat code to extend product_name to use Localized title or International title or Name based on how it is set in template. Will send you the patch file when the feature is ready to test.
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. # 6
Accepted Answer Pending Moderation
Hello,
ICECat feature for product_name has been extended in VirtueMart Product import template and code has been added with the attached patch file. You need to

1. Load the attached patch file.
2. In import template settings on File tab set Use for product name to Generated Local Title and save the template. See attached screenshot.
3. Run the import.

Please remember the patch file is created based on RO CSVI 8.0.0 beta1 files. So would recommend you to test the import with patch file on a test site first with RO CSVI 8.0.0 beta1 version installed and then update the production site.

Let me know on how that goes.
Attachments (2)
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. # 7
Accepted Answer Pending Moderation
Very nice !!! thank you so much. I will try and give you a feedback.

Thank you
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
I have a problem to download by ftp since the version 8 beta.
Here is the error :

Class 'phpseclib\Net\SFTP' not found


Joomla version 3.10
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Here is the error
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hello,
The library for SFTP is missing with RO CSVI 8.0.0 beta version and so you are seeing the error. To solve this

1. Login to the server via SSH (Shell)
2. Go to path administrator/components/com_csvi/assets/
3. Run the command composer install. This will download the needed library packages.
4. Run the import and check.

Let me know on how that goes.
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. # 11
Accepted Answer Pending Moderation
It's seems that there is no update
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
Hello,
We are looking into this. Will get back to your with an update.
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. # 13
Accepted Answer Pending Moderation
Hello,

Apologies, the issue is not with the composer install as indicated earlier but with how we call SFTP. Please load the attached patch file as explained in How to load a patch file and the SFTP should work after that.

Let me know how it goes.
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. # 14
Accepted Answer Pending Moderation
Sorry don't work
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 15
Accepted Answer Pending Moderation
Perfect it's working thank you ;-)
  1. more than a month ago
  2. RO CSVI
  3. # 16
Accepted Answer Pending Moderation
Hello,

Thank you for confirming all is working now. These changes will be included in the next release.
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. # 17
  • Page :
  • 1


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