× 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 #60506 by ptrouw
ptrouw replied the topic: Problem import with related categories
Seems to go wrong already with the category_path, I tried it with related_categories empty
Duplicate entry '2-50605-5336' for key 'opc_unique' again

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

More
1 month 4 days ago #60507 by tharuna
tharuna replied the topic: Problem import with related categories
Hello,
Can you post the latest debug log to check?

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 #60508 by ptrouw
ptrouw replied the topic: Problem import with related categories
although my related_category is empty in csv, it still finds entries?

product_sku^product_gtin^category_path^product_name^product_s_desc^product_desc^product_price^file_title^file_description^file_meta^file_url^file_url_thumb^product_id_tax^product_weight^COM_VIRTUEMART_PRODUCTDETAIL_BODY^COM_VIRTUEMART_PRODUCTDETAIL_DATE^VM_MERK^VM_MODEL^VM_PRODUCTCATEGORIE^VM_MATERIAAL^manufacturer_id^product_mpn^related_categories^customtitle^metadesc^published
ACUTEST2^80031^Testcat1^Acura silver^^"Test description"^100^Menabo Jackson aero roof rack bars^ ^Menabo Jackson aero roof rack bars^menabo-jackson-silver-roof-rack-set-1.jpg^resized/menabo-jackson-silver-roof-rack-set-1.jpg^3^14^MODEL_WAGON^2011-2014^Acura^TSX II | 2008-2014^VM_ROOF_RACK_BARS^VM_ALUMINIUM^42^M000112800000^^Acura TSX II Sport Wagon Menabo Jackson aero roof racks | Car Parts Expert^Acura TSX II Sport Wagon Menabo Jackson aero roof rack set. Top quality aerodynamic roof racks, easy to mount and a fast delivery at Car Parts Expert!^0
Attachments:

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

More
1 month 4 days ago #60510 by tharuna
tharuna replied the topic: Problem import with related categories
Hello,
One reason query is still processed even when related_categories is empty in import file should be because of CSVI is getting the categories from #__csvi_related_categories table. Did you empty the complete table or just few records?

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 #60511 by ptrouw
ptrouw replied the topic: Problem import with related categories
Just a few

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 #60512 by ptrouw
ptrouw replied the topic: Problem import with related categories
deleted 1000+ records, now it finish, only failure on last line:

1 Updated Success Product updated
1 Updated Success Product language updated
1 Updated Success Media file updated
1 Added Success Image added
1 Updated Success Product price updated
1 Updated Success Manufacturer language table updated
1 Added Success Product manufacturer reference added
1 Added Success Product custom field reference added
1 Added Success Product custom field reference added
1 Incorrect Failure COM_CSVI_NO_RELATED_CATEGORIES_FOUND

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