Categories
View Replies (9)

Resolved Multiple custom fields filter - duplicate values

  1. mtrcek
    mtrcek
  2. RO CSVI
  3. Thursday, 30 April 2015
  4.  Subscribe via email
I am using Multiple customfields filter for virtuemart. I created csv file according to this instructions

http://www.csvimproved.com/en/csvi-documentation/tutorials/922-multiple-customfields-filter-for-virtuemart

I also created values in the custom field parameters section.
When I import the values, the program seems to create unique search value for every value in the custom_param field. How can I prevent duplicate value creation?

I am using Joomla 3.3.6, CSVI pro 5.21.2 and VM 3.0.8.
The site is http://www.slovenski-tarok.si/et-test/ponudba

User: test
pass: testme_xa534

Notice, that there are many duplicate values in the Filter sidebar.
0
Responses (9)
rickdegroot
rickdegroot
Accepted Answer Pending Moderation
Rolandd,

I just loaded your patch as I was having the same issue!

Perfect solution! Thanks for a easy to search forum, I didn't have to BUG you!

All the best

Rick
  1. more than a month ago
  2. RO CSVI
  3. # 1
mtrcek
mtrcek
Accepted Answer Pending Moderation
Yes, it works now! Great! I tested it also on my live site and it works there also. Thank you!
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
That did it, I found the issue. Attached is a patch file, you can load the patch file and after that run your import again. You will need to empty the table once more, so it can be populated with a clean dataset.

Let me know how it goes.
Attachments (1)
patch_paramplugin_20150502.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. # 3
mtrcek
mtrcek
Accepted Answer Pending Moderation
Here is the log file.

This is the data from the xml install file of the plugin:

Param Filter: Virtuemart 2 search module
Version: 3.0.3 (2015.01.28)
Attachments (1)
com_csvi.log.1430463612.zip
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
Can you post your debug log after you truncated the table and imported the file fresh? I would like to compare it against my debug log since it worked fine for me.

In addition, which version of the Multiple custom fields filter are you using?
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
mtrcek
mtrcek
Accepted Answer Pending Moderation
I have tried with truncate and with manual deletion, but the result is the same... lots of duplicate values.
I can email you login details if you need more detailed look.
  1. more than a month ago
  2. RO CSVI
  3. # 6
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

I just tried your file on my test site and the import runs OK. Do this, remove all the values from the Barva custom field and run your import file again, all unique values should be created in the custom field for you.

If this is the only custom field you have for this plugin you can also do it directly on the database using this command: 
truncate table X_virtuemart_product_custom_plg_param_values;
replace X with your prefix.

Let me know how it goes.
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. # 7
mtrcek
mtrcek
Accepted Answer Pending Moderation
It would be a bit of work due to the large ammount of values.
Best thing to do - login to admin with the username and password, you can see the custom field (second from top). The values I created are the las tones, with ordering numbers from 1 - 15.
This site is development enviroment, but I have simmilar site live.
  1. more than a month ago
  2. RO CSVI
  3. # 8
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Your file looks good, the debug log looks good but your site doesn't look good ;) Can you post a screenshot of the custom field Barva that you created?

The debug log seems to indicate that the custom field has multiple values with the same name. It will help me to try and recreate your situation.
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. # 9
  • Page :
  • 1


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