Categories
View Replies (1)

Resolved Custom Filters not showing after import and emptying tables in database (CF Pro)

  1. raydekker
    raydekker
  2. RO CSVI
  3. Wednesday, 17 May 2017
  4.  Subscribe via email
I'm not too sure wether if it's CSVI related but I think it is as when I manually create Custom Fields they are working but after importing through CSVI they only work after clicking on the "VM Custom Filters" Component.
This only happens when I trunkate table "cf_customfields" in the database. So when adding new Custom Fields.
When I make changes to existing Custom Fields ad import them all is ok (so without trunkating "cf_customfields".

So normally I don't change the Custom Fields as these are already set and useable (and imported before). In that case I can for example change a name of the Custom Field and that change goes through (so after importing that), that's working fine.

But when for example adding a new filter I can't just use the CSVI import function, I manually have to empty that database table (cf_customfields), then run the CSVI import and then click on the "VM Custom Filters Pro" Component to load the filters.
So clicking on the "VM Custom Filters Pro" Component does something to the database that enables these filters to be used in the Custom Filters Pro addon.

Testing this would involve:
- emptying the VM database (including cf_customfields)
- importing 1) Custom Fields
- importing 2) Products and categories

Then by going to the shopfront there are no active Filters unless clicking on VM Custom Filters Pro Component in the backend once.
I must admit that I also import IDs of the Custom Fields, that way I can use the "Stockable Custom Fields" plugin with designated ids (that's what that plugin needs), if I don't use these IDs it generates a new random ID and not the ones I can use. Maybe this has got something to do with it?

I hope this story makes sense and you can see if it's CSVI related or not, as I said already this might be something simple but if not don't worry about it as I can just easily manually click on that component to fix it.

I believe you've still got my relevant import files: 1) CF and 2) Products.
Access to the test website is still valid.
0
Responses (1)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Ray,
Thank you for explaining on the issue. I had a look at it and yes the cf_customfields table gets populated when VM Custom Filters Pro component is clicked from administrator components menu. This is not only with CSVI but it is the same with VirtueMart too. If you add a new custom field from VirtueMart you have to anyways click on the "VM Custom Filters Pro" Component to load these fields. We will still have a look at it and see what can be done.
Kind regards,

Tharuna

=========================
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
  • Page :
  • 1


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