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

CSV Bulk (Non-WP) Member Import Failing

Simple Membership Plugin › Forums › Simple Membership Plugin › CSV Bulk (Non-WP) Member Import Failing

Tagged: auto increment, bulk import, csv, import, member database, member list

  • This topic has 16 replies, 3 voices, and was last updated 9 years, 1 month ago by sezg.
Viewing 15 posts - 1 through 15 (of 17 total)
1 2 →
  • Author
    Posts
  • January 23, 2017 at 4:36 pm #9820
    sezg
    Participant

    Hi,
    Thanks for the great product. I need to import non-Wordpress users to my database. I have installed the WP CSV to DB plugin and followed the instructions here exactly, but they seem to be outdated.

    I used the CSV template from your website and did not add, remove or alter any column headers. Perhaps the file is outdated as well?

    I can’t complete the following step because there is no “Columns” section: Enter the content of this text file in the “Column Names” field.

    When I click the “Import to DB” button, I receive this error:
    * Starting Row value exceeds the number of entries being updated to the database from the .csv file.

    I have unique values in all of the columns and tried the import with “auto-increment” both checked and unchecked, but I also consistently get this alert: This table contains an “auto increment” column.
    Please be sure to use unique values in this column from the .csv file.
    Alternatively, the “auto increment” column may be bypassed by clicking the checkbox above.

    Please advise? Is there another way to bulk import a large number of users for membership?
    Thanks.

    January 23, 2017 at 11:05 pm #9826
    mbrsolution
    Moderator

    Hi, did you replace the headers in the csv example file with the headers in the text file?

    January 24, 2017 at 2:42 pm #9847
    sezg
    Participant

    Ah, yes, that worked. Thanks for the clarification; I didn’t understand it from the instructions. Why don’t you just have an accurate .csv file for download?
    Thanks for the help!

    January 24, 2017 at 7:47 pm #9852
    mbrsolution
    Moderator

    Yes I think that would be a great idea. I am glad it worked.

    Thank you

    March 8, 2017 at 6:55 pm #10400
    sezg
    Participant

    Hello, I have a follow-up question for this. My bulk import from your CSV template worked well except for the “membership level.”

    On the overview table, the membership level column is blank. When I enter the record of an individual member, change nothing, and then save it, the membership level is now showing.

    Until I do this for each individual record one at a time, they cannot access the site. In the attached image, I’m using member “jackie”

    3 steps for each member to set a level

    Any ideas? Thank you!

    March 8, 2017 at 9:40 pm #10401
    mbrsolution
    Moderator

    Can you provide step by step on how you are importing the csv file into your site?

    Thank you

    March 13, 2017 at 3:36 pm #10442
    sezg
    Participant

    I followed your instructions exactly (https://simple-membership-plugin.com/simple-membership-bulk-import-member-data-csv-file/). Like I said, the import was successful except for populating the Membership Level

    1) Installed the WP CSV to DB plugin.
    2) Downloaded the csv template file and open it using Microsoft Excel https://simple-membership-plugin.com/wp-content/uploads/downloadables/members.csv
    3) Filled the member details. One member per row (Replaced two example entries them with actual details).
    4) Replaced the headers in the csv example file with the headers in the text file https://simple-membership-plugin.com/wp-content/uploads/downloadables/swpm_column_names.txt
    5) In the plugin, entered 2 in the “Starting Row” field.
    6) Entered “wp_swpm_members_tbl” in the “Database Table Name” field
    7) uploaded the CSV file
    8) Hit the “Import to DB” button

    Thanks.

    March 13, 2017 at 10:00 pm #10445
    mbrsolution
    Moderator

    Just two questions does your CSV file have a membership level entry added? If it does, does it coincide with the membership level already existing in your website?

    March 15, 2017 at 1:34 pm #10489
    sezg
    Participant

    Thank you. The csv has a column titled ” membership_level”
    And every members cell is populated. It looks like there’s a space in the csv that is not in the level title, so I will try again first and let you know if that works!

    March 15, 2017 at 3:44 pm #10491
    sezg
    Participant

    I just emptied the wp_swpm_members_tbl database and re-imported the csv.
    The membership level “CCCC-Active” is exactly as it appears in the site. Every row in the csv has the membership level populated with CCCC-Active, yet the level is *still* not displaying on the overview page and I *still* need to save each member manually to apply it. all other information from the csv imported correctly. Any ideas?

    March 15, 2017 at 10:31 pm #10493
    mbrsolution
    Moderator

    Hi, I have submitted a message to the plugin developers to investigate further your issue.

    Thank you

    March 23, 2017 at 2:37 pm #10574
    sezg
    Participant

    Hello, Is there any update on this? Also, I’ve purchased the premium Data Exporter plugin. It appears when I actually export the data, it only exports manually registered members; it does not include the full database of imported members as well. Is there a way to get all members?
    Thanks.

    March 23, 2017 at 9:17 pm #10575
    mbrsolution
    Moderator

    Hi, in regards to your premium addon please create a premium support ticket.

    Thank you

    March 28, 2017 at 1:31 pm #10619
    sezg
    Participant

    Hi, The premium issue is resolved (was related to access date) but I’m still rather desperate to fix the member import issue. The membership level is still not populating unless I individually re-save each member!

    I just deleted the members tbl in the db and reimported all members as Active instead of Inactive, but this did not make a difference. Please help!
    Thanks.

    March 29, 2017 at 12:23 am #10623
    mbrsolution
    Moderator

    Hi, the plugin developers will investigate further your issue.

    Thank you

  • Author
    Posts
Viewing 15 posts - 1 through 15 (of 17 total)
1 2 →
  • 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