• Resolved phayuk

    (@phayuk)


    I am using the template to import new members. It creates the users but does not create the membership record. If I look at error log it says :

    The membership ID (membership_id) column does not contain a numeric membership Level for user (ID: 2612). (Membership data not imported!)

    In the csv fie the fields have the number 1 or 4 which match the level ID’s listed in my Membership Levels.
    Knowing that the format has to be correct I have tried to the format for the column to be Number. I have also tried building the import file using both Excel and Google Sheets.
    Any help appreciated

Viewing 15 replies - 1 through 15 (of 15 total)
  • I have exactly the same problem. Version 2.31 of the plugin

    If I add a line of debug in the plugin to print $this->pmpro_fields[‘membership_id’] to the log when it errors, it is always empty. The CSV file has a column titled ‘membership_id’ and there is a number in each cell. All other columns are imported correctly

    Plugin Author Thomas S

    (@eighty20results)

    Thank you both for the problem report and apologies for the problems.

    Would you be able to share a sample of the file you’re trying to import, to help me troubleshoot this issue? (Dropbox or pastebin link would be appreciated!)

    Thread Starter phayuk

    (@phayuk)

    Thomas,
    Thank you for getting back to me.
    I have uploaded my file to
    https://www.dropbox.com/s/p8dr2gtck3y60n6/Test_Example_import_2.csv?dl=0

    Just to let you know I am about to go away for 4 days, so I won’t be able to get back to you for a little while if you reply.

    I appreciate your help.

    I won’t upload a separate one as phayuk’s file is pretty much identical to mine

    Plugin Author Thomas S

    (@eighty20results)

    Thank you for sharing the example file.

    Am debugging now and will report back as quickly as possible.

    Thanks again for trying to use my plugin, and apologies for the inconvenience!

    Plugin Author Thomas S

    (@eighty20results)

    Hi,

    I’ve been trying various options for the import and I cannot reproduce any issues when importing the example file provided…

    It imports fine on my test system when using Paid Memberships Pro v1.9.5.3 and v2.31 of the Paid Memberships Pro Import Members from CSV plugin.

    I’m wondering if there perhaps may be a PHP Notice|Warning|Error or some plugin conflict on your systems?

    Could you review the web server error log file (for PHP errors/notices) during an import attempt?

    Also, would you be able to provide me with a list of the PMPro add-ons being used on the server and try a ‘bare bones’ import (I.e. only Paid Memberships Pro and the import plugin active) to see if there could be a plugin or theme conflict somewhere?

    Aha! Bingo…

    I had another plugin installed, which somehow I hadn’t noticed.

    Paid Memberships Pro – Import Users from CSV Add On by Stranger Studios. Disabling this fixed it .

    Thanks for the suggestion!

    Plugin Author Thomas S

    (@eighty20results)

    Thank you for following up.

    I’ll spend some time testing with the Import Users from CSV add-on and try and figure out what the conflict is so it can be resolved.

    Thread Starter phayuk

    (@phayuk)

    Thomas,
    Sorry it has taken me so long to reply, I was away longer than expected.
    I have now tried it again with SUCCESS !
    Just like @kineticpulse , I also had the Paid Memberships Pro – Import Users from CSV Add On by Stranger Studios and after disabling it, the import has created my membership record.
    So thank you both very much.

    I just want to check one thing. The import created the user record and the membership record but it didn’t create an order record. Is that to be expected ? and would it cause me a problem if there is no order record ? The import is for non paying members anyway.

    Edit : Actually there is an issue, in that without the order, I cannot amend the address fields once the user/member is created

    • This reply was modified 6 years, 4 months ago by phayuk.
    Plugin Author Thomas S

    (@eighty20results)

    Hi @phayuk,

    I just updated the plugin to v2.40 which includes a fix that should resolve the problem with importing member info when the “Import Users from CSV Integration” Add-on is active on the site.

    To create an order record you need to include order related information in the import file _and_ check the “Add Order” setting (well, you can check the “Add Order” setting, or make sure you have both the membership_gateway and membership_subscription_transaction_id columns present in the import file).

    Not having an order record isn’t really a problem (the PMPro considers order records “informational” and not essential).

    Thread Starter phayuk

    (@phayuk)

    Thomas,
    Thanks so much. I can’t believe I missed the “Add order” check box. That has created the order for me. I didn’t seem to need the membership_gateway and membership_subscription_transaction_id columns present in my import file.

    I do have one question though, and this may need to be aimed at the Paid Membership Pro team but I will try asking now.

    The import has now created a user, a membership record and an order. The membership record shows me the address when I display the Members list for the imported member. However, that screen does not give the ability to make a change to the address. If I go into the order, I can change the address, but this has no affect on the members address shown in the list. How can I, as admin, make a change to the member record ?
    As I say, if this goes beyond your remit, please feel free to tell me.

    Thread Starter phayuk

    (@phayuk)

    Thomas,
    BTW, I should have added that after installing your update the import worked with the other plug in activated. Thank you.
    Paul

    Plugin Author Thomas S

    (@eighty20results)

    However, that screen does not give the ability to make a change to the address. If I go into the order, I can change the address, but this has no affect on the members address shown in the list. How can I, as admin, make a change to the member record

    Billing information in Paid Memberships Pro is managed through the “Billing Information” page. Any limitations there will need to be handled through the PMPro Support forum. For instance if the payment isn’t recurring, the member is informed of that but can’t update the billing data – But they _can_ re-supply it when they renew manually on the checkout page instead.

    Thread Starter phayuk

    (@phayuk)

    Thomas, Thank you. I have now found somebody that has helped with the Membership Pro side and has managed to get the address fields showing.

    In conclusion to this thread, I have now, with your wonderful help, managed to import over 2600 members into the membership system.

    So thank you very much for your help and patience. Naturally, I have also clicked the donate PayPal button. worth every cent !

    Best regards,
    Paul

Viewing 15 replies - 1 through 15 (of 15 total)
  • The topic ‘membership ID does not contain a numeric membership Level’ is closed to new replies.