Categories
View Replies (6)

Resolved Import Multiple Custom Field Values - Vm Product

  1. codeingenia
    codeingenia
  2. RO CSVI
  3. Friday, 24 July 2015
  4.  Subscribe via email
CSVI PRO 6.0 RC1
Virtuemart 3.0.9
Joomla 3.4.3.

I installed correctly plg_csviext_param_csvi_6.0rc1 and plg_csviaddon_customfilters_csvi_6.0rc1 and I've published it.
I've also tried to Update Field in Avaible Fields (Maintenance) before export/import.

I've also correctly bought and installed "Virtuemart 2 Product Filter by Custom Fields" for Joomla 3.

I created the Custom Field correctly using this guide.

If I try to import Virtuemart product all works correctly using standard fields (product_name, product_sku etc...), but when I try to import using "Custom Field" Fields ("custom_title";"custom_value";"custom_param";) I receive these error:

An error has occured during the import. Below the information received from the server.
Status error: 200
Status message: OK

Notice: Undefined index: clearCustomValues in D:\xampp\htdocs\mysite\administrator\components\com_csvi\rantai\plugin\dispatcher.php on line 65

Warning: Invalid argument supplied for foreach() in D:\xampp\htdocs\mysite\administrator\components\com_csvi\rantai\plugin\dispatcher.php on line 65
{"error":true,"process":false,"url":"administrator\/index.php?option=com_csvi&view=imports","message":"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=INSERT INTO `lftop_virtuemart_product_custom_plg_param_values`"}


While if I try to import without ("custom_title";"custom_value";"custom_param";) on the header and in the structure, all works ok.

There's two file attached: import_error.csv that causes error and import_ok.csv that works ok.

How can i solve this error and how can I import vm product custom fields correctly? Thanks
0
Responses (6)
rolandd
rolandd
Accepted Answer Pending Moderation
CSVI PRO 6.0 RC1
The stable version is out now, if you want to update.

Your file with the custom fields is all good. It's the error preventing the import. Attached is a a patch file you can load. After that the import will complete.

This patch may also fix the other issue you posted. I imported your file which went fine and the export was fine as well.

Let me know how it goes.
Attachments (1)
patch_dispatcher_20150724.zip
Kind regards,

RolandD

=========================
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
codeingenia
codeingenia
Accepted Answer Pending Moderation
Fix doesn't work.

I've updated Csvi Rc1 to stable version 6.0, I've also updated all plugins at 6.0 then I've Fix Database and Update Avaible Fields.
Then I applied patch file.

If i try to import import_error.csv (that contains "custom_title";"custom_value";"custom_param";) I receive this error:

An error has occured during the import. Below the information received from the server.
Status error: 200
Status message: OK

Fatal error: Can't use method return value in write context in D:\xampp\htdocs\mysite\administrator\components\com_csvi\addon\com_virtuemart\table\productlang.php on line 111

Important: I receive this error also when import import_ok.csv (so without "custom_title";"custom_value";"custom_param";).
So there's problems with new version, because with RC1 without patch_dispatcher_20150724 import of import_ok.csv worked fine, now not works.

This patch not fix the other issue I posted. For export file, the result is the same. (export file)
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

The error is introduced in CSVI 6.0.0 but instead of doing another patch, I have released CSVI Pro 6.0.1 and an updated VirtueMart version as well, that contain all the changes. You can download these and install them on top of your existing ones. That should be all to get the import running.

As for the export, I will check that.
Kind regards,

RolandD

=========================
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
codeingenia
codeingenia
Accepted Answer Pending Moderation
Hello rolandd,
thanks for your work but I still have issues:

- If I import import_error.csv that contains ("custom_title";"custom_value";"custom_param";) I have this error:

An error has occured during the import. Below the information received from the server.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=INSERT INTO `lftop_virtuemart_product_custom_plg_param_values`

- If I import import_ok.csv now there aren't errors.

- Export: same previous situation

custom_param = n=""|s=""|ft=""|t=""|m=""|af=""|av=""|ld=""|z=""|
custom_title = Disponibilità (OK)
custom_value = (empty)

If can be useful, when I click to Update Custom Fields I ever see:

[...]
cf_customfields not an available table
cf_customfields not an available table
Available fields have been added for table categories
Available fields have been added for table categories


I'll upload site on-line and I'll send you FTP and login details.
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Send me the details and I will take a look because it is weird as it works all OK for me, I think there is something wrong in your setup.
Kind regards,

RolandD

=========================
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. # 5
codeingenia
codeingenia
Accepted Answer Pending Moderation
Problem solved by rolandd. Great support
  1. more than a month ago
  2. RO CSVI
  3. # 6
  • Page :
  • 1


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