Membership Plugin

WordPress Membership Plugin

  • Home
  • Documentation
  • Addons
  • Support
    • Quick Setup
    • Documentation
    • Premium Addon Support
    • Paid Support
    • Support Forum
    • Support Forum Search
    • Forum Login
    • Forum Registration
  • Contact

[Resolved] Bulk Member Importer Addon accept only half of csv-file

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.
Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • August 15, 2018 at 9:31 am #15205
    nosch
    Participant

    Hello,
    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
    Norbert

    August 15, 2018 at 11:55 am #15206
    The Assurer
    Moderator
    1. Is it only specific CSV entries that fail to import?
       
    2. For the entries that fail to import; do WP user entries with the same username already exist?
       
    3. For the entries that fail to import; do WP user entries with the same email already exist?
       
    August 15, 2018 at 2:45 pm #15208
    nosch
    Participant

    Thanks 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
    Norbert

    August 15, 2018 at 8:33 pm #15209
    The Assurer
    Moderator

    I’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 #15213
    nosch
    Participant

    Good 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
    Norbert

    August 16, 2018 at 10:14 am #15214
    nosch
    Participant

    I 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.
    Norbert

    August 16, 2018 at 3:33 pm #15221
    The Assurer
    Moderator

    So 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 #15222
    nosch
    Participant

    A 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

  • Author
    Posts
Viewing 8 posts - 1 through 8 (of 8 total)
  • You must be logged in to reply to this topic.
Log In

Please read this message before using our plugin.

Search

Featured Addons and Extensions

  • Membership Form Builder Addon
  • Member Directory Listing Addon
  • WooCommerce Payment Integration
  • Member Data Exporter Addon

Documentation

  • Documentation Index Page

Copyright © 2026 | Simple Membership Plugin | Privacy Policy