Only Partial Export

[kentropolis]

Export is only providing the first 29 users (out of over 1100), alphabetically by email address.

There are no error messages and the license is valid.

[sourov amin]

Hello,

Make sure you are using these export options right.
Is there any Start or End Date specified in User Export form?
Whatever configuration you set, is it produce 29 users in all instances?

Thanks.

[kentropolis]

There is nothing specified as a filter except to not include pending users. When I change filters, the list may even be shorter.

No matter how I asked it to sort, at first the output was alphabetical order by email address. Trying it today, the list is different depending on what it is sorted by, and when sorted by ‘display_name’, it only renders 8 users with no other filters in place.

There seems to be no rhyme or reason to this.

[kentropolis]

I also realized that this happens when doing the default export. The one from ‘User Export (ID:2)’ appears to be working.

[kentropolis]

UPDATE: My client added fields to User Export ID:2 and it’s truncating again — the first 26 users MOSTLY alphabetically by email address or last name, same as before.

???

[kentropolis]

Discovered that no matter how sorted, it always ends with a particular user. I filtered them out and it still had the same number of users, but the next name.

• This reply was modified 5 years, 1 month ago by kentropolis.

[sourov amin]

Hello,

This problem is rather unusual. Can you set a temp admin and send the credentials to support(at)user-meta.com, so the issue can be checked closely?

Thanks.

[kentropolis]

Will do. Thanks.

[kentropolis]

Figured it out.

Your private response helped me find it:

It seems that the problem is with two specific fields (meta key): street_address_/_po_box and notes_private.
If you do not include fields in export with these meta keys, everything should work fine.
There might be some unsanitized data with special characters in those fields. You can do a search for these.

It’s the “#” character. When found it in the address (such as “Apt #4”) or anywhere in notes, it kills the file at that point. I did a search and replace in the ‘wphx_usermeta’ table and it seems to work now.

Thanks. I hope you can eliminate this in the future, as I am sure many people will enter such a character in fields.

[sourov amin]

Hello,

Thanks for pointing it out. We will evaluate the situation and solve the problem.

Thanks.

[Author]

Posts