Simple Membership Plugin › Forums › Simple Membership Plugin › Bulk Member Importer Addon accept only half of csv-file
Tagged: Bulk Importer Failure
- This topic has 7 replies, 2 voices, and was last updated 8 years, 3 months ago by
nosch.
-
AuthorPosts
-
August 15, 2018 at 9:31 am #15205
nosch
ParticipantHello,
first your plugin is realy fine, it works as it should. But we have a problem with Bulk Member Importer Addon. Our csv-file contains 127 new members. I’ve uploadet as described. On wordpress I can see, that all was successfully. But if I changed to the Members, there are only the half of all persons. I tried it some times again, but nothing. In the log-file I can see: “FAILURE: Bulk Import Addon Error – Member record insert failed for: …”. The mailadress is correct.
Where can I find the missing members? What is wrong?
Thank you.
Best wishes
NorbertAugust 15, 2018 at 11:55 am #15206The Assurer
Moderator- Is it only specific CSV entries that fail to import?
- For the entries that fail to import; do WP user entries with the same username already exist?
- For the entries that fail to import; do WP user entries with the same email already exist?
August 15, 2018 at 2:45 pm #15208nosch
ParticipantThanks for your fast response. Here are my comments:
1. Yes, there are only CSV entries. I tried nothing else but CSV-file comma-separateted.
2. No, all new users are unique. No WP user with the same name.
3. No, all emails are unique and new.
Manually there is no problem, I can add new members.
Thank you for your help.
best wishes
NorbertAugust 15, 2018 at 8:33 pm #15209The Assurer
ModeratorI’d like to rephrase question 1. Are there ANY particular characteristics about the failed import entries; such as special characters, etc? In other words, if you were to copy the failed entries to another CSV file, and try importing them, will there be a 100% failure?
August 16, 2018 at 7:24 am #15213nosch
ParticipantGood annotation. I tried your way, and it works! No failure anymore! All members are in system.
I build a new file by notepad++, copy and paste all data entries from the excel-csv-file to the notepad-csv-file. Then I imported the data – and it is fine!
Thank you for your assistance, I am very glad about it.
Best wishes
NorbertAugust 16, 2018 at 10:14 am #15214nosch
ParticipantI found an other problem with member login. We have some members with special characters (ä, ö, ü) in the login-name. By Bulk import these characters are accepted. But login doesn’t, they can’t log in.
Do you have a hint for me to handle this problem? Or is the only possibility to delete the members and import new without special characters?
Thank you and best wishes.
NorbertAugust 16, 2018 at 3:33 pm #15221The Assurer
ModeratorSo the issue may have been with the things such as non-printable characters in the CSV file.
SWPM is an extension of the WP user account system; which does not permit non-Latin characters in the user name. However, if you do a search of the WP plugin directory; you will find a plugin that permits the use of non-Latin characters in the WP user name table. HOWEVER, be aware that each non-Latin character can occupy up to 3 bytes in the WP user name field. In the worst case, if every character in a user name was non-Latin (Japanese?) the maximum size of a user name could be cut by 66%.
August 17, 2018 at 8:17 am #15222nosch
ParticipantA last hint concerning Bulk importer: I remarked, that the importer automatically transformed “ß” into “ss”. Maybe in one of the next versions in can realised for the other special characters like Ä,ä,Ö,ö,Ü,ü into Ae, ae, … too?
Thank you for your support and have a good time!
Norbert - Is it only specific CSV entries that fail to import?
-
AuthorPosts
- You must be logged in to reply to this topic.