1. rjcroasdale
  2. RO CSVI
  3. Friday, 26 October 2018
  4.  Subscribe via email
Hello, I am having an issue with exporting user info from virtuemart using CSVI Pro Version: 7.9.0 Joomla! version: 3.8.5

It seems no matter which filters I set the query still uses WHERE #__users.id NOT IN and a long list of user IDs.

Trying to remove all filters or by selecting all the shopper groups or below
user address, dont use
vendor, dont use
enabled, dont use
activated, dont use
shoppper group, all groups and no assigned groups

I also checked one of the filtered user IDs in Joomla and VM.

Can you help please? I'm stuck. I cant figure out why is filtering so many user IDs.
Accepted Answer Pending Moderation
Hello,

Each filter will generate a list of IDs, just the condition changes from NOT IN to IN. Which users are you trying to export?

Are you not getting any users out on export?
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
I am trying to export all the users. I am getting users on export. I am not getting all users though as seems to filter out a long list of IDs.
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
The NOT IN condition in query filters users who do not have shopper groups assigned in VirtueMart. In your export template on Options tab if you set Shopper group name filter only to No assigned shoppergroups and run the export, what do you see in your export? Can you post the debug log of your export? To get the debug log check How to get debug information? document.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
It seems I cannot export all users at once. I tried and to get all users I perhaps have to make two exports, one all shopper groups and one no shopper groups.

Is there a way to export all users at once?

To answer your question, I get an export of users, but I cannot get all users in one export. Is there a way to remove all the filters and export all users in one step?
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
You cannot remove all the filters because the users in VirtueMart are assigned to a shopper group and so All shopper groups is set as default for the filter to export the VirtueMart users. But you should be able to export all the users when shopper group filter is set with All shopper groups and No assigned shopper groups. You can get that functionality by applying the attached patch file. In your shopper group name filter set both All shopper groups and No assigned shopper groups and run the export. Let me know if that gets all the users for you.

patch_vm_userinfo_2018_10_30.zip
Attachments (1)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
  • Page :
  • 1


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