Lost password?    Lost username?    Create an account
OverviewDownloadsForumSupport
CSV Improved

CSV Improved

  • Free upgrades for 1 year
  • Extended replacement rules
  • Advanced XML support
  • Multiple component support
  • Automatic import/export
  • Advanced import/export features
  • Forum access for 1 year
  • Forum access for 10 days
Welcome, Guest
Username: Password: Remember me
Looking for a useful answer?

Read this first and make sure you checked all steps: www.csvimproved.com/frequently-asked-questions/635-troubleshooting-import-errors

Don't just say it doesn't work but describe in detail what is happening and add the following information:
* VirtueMart version
* CSVI version (Latest is not a version number)
* Sample of the file being imported
* 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 (www.csvimproved.com/frequently-asked-questions/390-how-to-collect-debug-information) has been written to help you collect your debug information. For CSVI 3, there is a video available (www.csvimproved.com/downloads/file/18-collect-debug-information)
  • Page:
  • 1

TOPIC: Category name does not match category path - id

Category name does not match category path - id 10 months 2 weeks ago #29428

  • stawebnice
  • stawebnice's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
  • Karma: 0
Hi,
I created a csv file with three columns - category_id, category_name and category_path.

the import fails and shows this error: Category name does not match category path.

I read the advice about leaving out the category_id, but>
1. I need to use the category_id
2. it fails even if I only leave category_name and category_path - need to use both because they differ

Is there any way to import fresh new categories with the product_id? (we're transferring eshop from another system and the IDs need to be kept the same)
Attachments:
The administrator has disabled public write access.

Re: Category name does not match category path - id 10 months 2 weeks ago #29438

  • rolandd
  • rolandd's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 14655
  • Thank you received: 609
  • Karma: 295
Hello,
the import fails and shows this error: Category name does not match category path.
The category_name must be the same as the last name in your category_path. There is no need for the category_name field if you have the category_path.

You can only use the category_id field for existing categories, not for creating new categories. The only way around this is to import a list of IDs directly in the database using PhpMyAdmin and after that you can use them for import.

When using the category_id, do not use the category_path with it but only the category_name.
Kind regards,

RolandD

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
The administrator has disabled public write access.

Re: Category name does not match category path - id 10 months 2 weeks ago #29439

  • stawebnice
  • stawebnice's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
  • Karma: 0
Hi,
I imported the categories with the ids through PhpMyAdmin first.
Then I adjusted the template so there only is category_id and category_name
But even then when I import the csv file with only those two columns I get the same error> imtp.me/3db7006q4.p

This is the settings of the import template>
http://imtp.me/3db9006q4.p
http://imtp.me/3dba006q4.p


First of all I don't understand why the Virtuemart ignores the categories when I create them using the import through PhpMyAdmin. I inserted two categories manually, then made a sample csv export from database and created the exact same import - the categories are in the database but when I go to Virtuemart, they're not there...only those I created manually. I don't know what the fields cdate and mdate numbers are so they are the same for all the lines in my csv import...can this be the problem?
Attachments:
The administrator has disabled public write access.

Re: Category name does not match category path - id 10 months 2 weeks ago #29465

  • rolandd
  • rolandd's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 14655
  • Thank you received: 609
  • Karma: 295
Hello,

Seems I was a little off, in your version you must also include the category_path into your import file. The last category in the path must match the category_name field. You may give it a try to just duplicate the category_name column and name it category_path.
First of all I don't understand why the Virtuemart ignores the categories when I create them using the import through PhpMyAdmin.
There is most likely an inconsistency.

You can ignore the cdate and mdate fields.
Kind regards,

RolandD

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
The administrator has disabled public write access.
  • Page:
  • 1
Moderators: rolandd
Time to create page: 0.319 seconds
Powered by Kunena Forum

TESTIMONIAL

Excellent extension, SUPERB support
5 stars
2013-02-26
That extension is what you need to fill your VM store with products! it's not hard to understand how it works (just read the manual) and if you need anything they have a forum that aswers to EVERYTHING! I just love this extension and is a part of my store-maintenance tools! It's a pity not to mention that this roland guy is awsome when it comes to support!

STAY INFORMED


Stay informed with the CSVI newsletter.