Support is online

When import categories to virtuemart it fails #7422

Open OPERCON opened this topic Wednesday, 24 June 2015 · 11 replies
Author

Joomla! 3.4.1
csvi 5.21.2
VirtueMart 3.0.6.2
file for import was exported from k2.
file is attached.
language of import was set up to Russian.
field headers was written for each field.
category name and last category in category path are equal, but import fails saying "not equal". all files are attached.
Maybe there's something i missed?

Support

Hello,

When you have the category_path field, the name field is basically obsolete. So you can leave that out if you want to. As far as I can tell your CSV file is not UTF-8. At least I can't read it as a UTF-8 file. This will cause the issue of being not equal. If you fix the file to be a UTF-8 file, it should all be OK.

Kind regards,

RolandD

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

Author

You want to say, that k2 export with csvi pro makes not utf-8 file?

Support

I am not saying that. All data should be stored in Joomla in UTF-8 format. CSVI simply reads it from the database and puts it into a file, it doesn't do anything with the encoding itself.

Just the file posted here has issues. Importing the file, does the data look OK in the website? You can import it by removing the name field as mentioned earlier.

Kind regards,

RolandD

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

Author

First lines look ok. They are imported successfully. All the rest are failed

Support

This file looks good to me and is UTF-8.

Your message is too cryptic. For the last time, the name column has no value because you have the category_path, so just remove it. Actually the same goes for the parent_category_path, this field is not used on import.

Kind regards,

RolandD

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

Author

Understood, ill try

Author

I've remmoved category_path both from file and from template (attached log and options and file). it failed(

Support

You should not remove category_path but the name field.

Kind regards,

RolandD

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

Author

I've done it. result is the same

Support

I think there is a little miscommunication. You only should use the category_path field, not the category_name. The XML node should be empty because you are not importing an XML file. Make chose changes and give it another try.

Kind regards,

RolandD

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

Author

OMG!
It was so easy??
Sorry my dullness
Thank you!

Log in to reply to this topic.