1. iguson
  2. RO CSVI
  3. Wednesday, 26 May 2021
  4.  Subscribe via email
Hi, we've run into an issue where an import cannot be completed due to a duplicate in the slug field, we're not entering slugs/aliases on the CSV (si it should be creating them automatically) and already have tried checking and unchecking the 'recreate alias' option in the template, to no avail. We've seen messages on this forum related to the same problem, but with previous CSVI versions, so none helps us...
Can you please advice us as to how to troubleshoot this issue?
We're using Joomla 3.9.26 + RO CSVI 7.20.0 + VM 3.8.8

Many thanks in advance.
Accepted Answer Pending Moderation
Hello,
We need these details to check on the issue.

1. Latest import debug log. To get the debug log check How to collect debug information? document.
2. Import template XML file. To get your template XML file, in RO CSVI maintenance menu select RO CSVI on first option, backup templates on second option, select your template and download the XML file. Post the XML file.
3. Import file you are using so we can reproduce the error.
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
Hi Tharuna,

you'll find attached all the info requested,
the CSV only contains 2 rows because the original (with 250,000 entries) is about 15Mb, but these are the first two to 'collide'

many thanks
Attachments (3)
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
Thank you for posting the requested files. I was able to see the error with your template and import file. When there is no slug defined in the import file, RO CSVI uses product_name to generate the slugs. Now the cause for the duplicate is the length of characters VirtueMart stores in slug field in database. In virtuemart products language table the slug field is defined to have about 192 characters(see screenshot) and that is the maximum it can store when you run the import. If the slug is more than this defined length, the value above 192 characters are truncated. In your case products are getting same slug after the values are truncated and so the duplicate issue.


nox-hummer-mc-pro-caja-semitorre-atx-y-micro-atx---cristal-templado---iluminacion-argb---2x-ssd-2-5---2x-hdd-3-5---usb-3-0-usb-2-0---soporta-refrigeracion-liquida---2-ventiladores-120mm-inclui


Recreate slug option will not help here as RO CSVI adds an increment value at the end of the slug if a duplicate is found. Even the increment value is truncated so recreate slug option does not help.

The slug is also used for your SEF URLs, so you will be getting some crazy long URLs. To fix this add the slug field to your CSV file and create your own slugs. Each slug must be unique and should not be long.
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. # 3
  • Page :
  • 1


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