× Looking for a useful answer?

Read this first and make sure you checked all steps: csvimproved.com/support/getting-started

Don't just say it doesn't work but describe in detail what is happening and add the following information:
* Version of the extension you are using
* CSVI version (Latest is not a version number)
* Sample of the file being imported
* A copy of the template you are using. Use the maintenance menu to create a backup of your template
* Collected debug information

Without this information you won't get a useful answer. If no debug log is attached, you will get a request to post it.

Where to get the debug information?

A tutorial ( csvimproved.com/support/questions-and-answers/390-how-to-collect-debug-information ) has been written to help you collect your debug information.

Problem import with related categories

  • ptrouw
  • Topic Author
  • Offline
  • Expert Boarder
  • Expert Boarder
More
1 month 4 days ago - 1 month 4 days ago #60500 by ptrouw
ptrouw created the topic: Problem import with related categories
Using
PHP version 7.3.4
Joomla! version 3.9.4
CSVI 7.11.0
VirtueMart 3.4.2

I have an import script which always worked, after upgrade to 7.11.0 I am getting a error on related_categories: Duplicate entry '2-50605-5336' for key 'opc_unique'
If I look in log file its seems there is already alink with related_categories. It tries checking for existing related_categories based on wrong info.
In my test csv I have a related_categories called "Testcat2" but it finds a relation with an old related_categories called "Acura" and 2 more.

Any ideas?

File Attachment:

File Name: com_csvi.log.4774.txt
File Size:36 KB

File Attachment:

File Name: PU143 - Me...test.csv
File Size:1 KB
Attachments:
Last edit: 1 month 4 days ago by ptrouw.

Please Log in or Create an account to join the conversation.

More
1 month 4 days ago #60501 by tharuna
tharuna replied the topic: Problem import with related categories
Hello,
In your database, can you look for #__csvi_related_categories table and see if you have any entries for product_sku ACUTEST2? It looks like there is already an entry in this table and the code is reading that related categories. Can you check and confirm?

Kind regards,

Tharuna

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

Please Log in or Create an account to join the conversation.

More
1 month 4 days ago #60502 by tharuna
tharuna replied the topic: Problem import with related categories
Hello,
If you are having any difficulty in accessing your database. You can create a custom table export template, set table name to be csvi_related_categories on Options tab, add fields product_sku and related_cat as template fields, do the export and send us the export file. We will check for the entries for product_sku ACUTEST2 from the export file. You can also use the custom export template attached in this post for export.

Kind regards,

Tharuna

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

Please Log in or Create an account to join the conversation.

  • ptrouw
  • Topic Author
  • Offline
  • Expert Boarder
  • Expert Boarder
More
1 month 4 days ago #60503 by ptrouw
ptrouw replied the topic: Problem import with related categories
Yes there is. Should I delete it? But the strange thing I did a complete clean new record, with new SKU and Category, just so to overcome any "old" data.

Please Log in or Create an account to join the conversation.

More
1 month 4 days ago #60504 by tharuna
tharuna replied the topic: Problem import with related categories
Hello,

Yes there is. Should I delete it?

Not sure how you have those records because after importing Related categories, CSVI will empty the table. Yes, you can delete those entries and then try the import.

But the strange thing I did a complete clean new record, with new SKU and Category, just so to overcome any "old" data.

In that case we need to confirm if there is already an entry for product_sku ACUTEST2. So before you clean the table, Can you do the custom table export and send the file as requested in my previous post?

Kind regards,

Tharuna

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

Please Log in or Create an account to join the conversation.

  • ptrouw
  • Topic Author
  • Offline
  • Expert Boarder
  • Expert Boarder
More
1 month 4 days ago #60505 by ptrouw
ptrouw replied the topic: Problem import with related categories
btw there is no index of prim key on this table.
So I have multiple double entries some how:
ACU2TXRM Acura[TSX II | 2008-2014
ACU2TXRM Acura[TSX II | 2008-2014
ACU2TXRM Acura[TSX II | 2008-2014
ACU2TXRM Acura[TSX II | 2008-2014
ACU3RXRM Acura[RDX I
ACU3RXRM 2007-2012
ACU4RXRM Acura[RDX II
ACU4RXRM 2012-2018
ALF5STRM Alfa Romeo[Stelvio (949)
ALF5STRM 2017-present
ALF659RM Alfa Romeo[159
ALF659RM 2005-2011
ALF856RM Alfa Romeo[156
ALF856RM 1997-2007
ALF856RM Alfa Romeo[156 | 1997-2007
ALF856RM Alfa Romeo[156 | 1997-2007
ALF856RM Alfa Romeo[156 | 1997-2007

Please Log in or Create an account to join the conversation.