Home › Forums › Plugin Support › Only Partial Export
- This topic has 9 replies, 2 voices, and was last updated 6 years, 7 months ago by
sourov amin.
-
AuthorPosts
-
March 7, 2019 at 3:23 am #8880March 7, 2019 at 3:31 pm #8883
sourov amin
MemberHello,
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.
March 7, 2019 at 5:22 pm #8884kentropolis
MemberThere 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.
March 7, 2019 at 5:25 pm #8885kentropolis
MemberI also realized that this happens when doing the default export. The one from ‘User Export (ID:2)’ appears to be working.
March 7, 2019 at 10:03 pm #8886kentropolis
MemberUPDATE: 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.
???
March 7, 2019 at 10:07 pm #8887kentropolis
MemberDiscovered 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 6 years, 8 months ago by
kentropolis.
March 8, 2019 at 8:12 am #8889sourov amin
MemberHello,
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.
March 8, 2019 at 3:59 pm #8890kentropolis
MemberWill do. Thanks.
March 17, 2019 at 10:29 pm #8896kentropolis
MemberFigured 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.
March 18, 2019 at 9:02 am #8897sourov amin
MemberHello,
Thanks for pointing it out. We will evaluate the situation and solve the problem.
Thanks.
-
This reply was modified 6 years, 8 months ago by
-
AuthorPosts
- You must be logged in to reply to this topic.
