No assign the Membership Level

Hi,

Thank you for using my plugin!

Typically, the refusal to import membership information is linked to the plugin finding problems with the data being imported. It could be a case of dates having the wrong format, incorrect membership ID information, membership status, etc.

Please make sure you review the FAQ section for some details on the expected/correct formats for dates, etc.

Also, if you could provide me with a link to an example (small sample) of the data you’re trying to import, I can review it and maybe give you a few pointers.

Hey,

Thank for your reply.

Date Format: YYYY-MM-DD HH:MM:SS

Membership ID: 1

Status – active

I have import your same report then also only created the users not created the membership lit at the paid membership pro section.

Hi,

This would be a lot easier if you provided an example import file. Please use a pastebin, a dropbox account, or some other online resource that will then let you post the link to the file to this forum.

We have added the CSV and change the level manually now.

Hi,

I’m not following, sorry?

Hello
I am following on this ticket as I am also having issue importing the members.
All datas are imported correctly but member are not assigned their respective membership level.
I have used the template file downloaded next to the import button and my first test was just to reimport this one, the user are well created but no membership level assigned
after importing the users, I received a warning in WP about the error log, here is the content:

BEGIN 2018-06-06 08:26:22
BEGIN 2018-06-06 08:26:41
[Line 1] The membership ID (membership_id) column was not found when importing member data for this user (ID: 45). (Skipped!)
[Line 1] The membership ID (membership_id) column was not found when importing member data for this user (ID: 46). (Skipped!)
[Line 1] The membership ID (membership_id) column was not found when importing member data for this user (ID: 47). (Skipped!)
BEGIN 2018-06-06 08:26:49
BEGIN 2018-06-06 08:27:43
BEGIN 2018-06-06 08:39:00
BEGIN 2018-06-06 08:39:18
[Line 1] The membership ID (membership_id) column was not found when importing member data for this user (ID: 48). (Skipped!)
[Line 1] The membership ID (membership_id) column was not found when importing member data for this user (ID: 49). (Skipped!)
[Line 1] The membership ID (membership_id) column was not found when importing member data for this user (ID: 50). (Skipped!)
BEGIN 2018-06-06 08:39:25
BEGIN 2018-06-06 08:41:59
BEGIN 2018-06-06 08:42:44
[Line 1] The membership ID (membership_id) column was not found when importing member data for this user (ID: 51). (Skipped!)
[Line 1] The membership ID (membership_id) column was not found when importing member data for this user (ID: 52). (Skipped!)
[Line 1] The membership ID (membership_id) column was not found when importing member data for this user (ID: 53). (Skipped!)
BEGIN 2018-06-06 08:42:59
BEGIN 2018-06-06 08:52:22
BEGIN 2018-06-06 08:59:27
BEGIN 2018-06-06 09:00:05
[Line 1] The membership ID (membership_id) column was not found when importing member data for this user (ID: 54). (Skipped!)
BEGIN 2018-06-06 09:00:14

this is the import file downloaded next to the file selection button in the plugin (the example) – which is not working for membership level
https://www.dropbox.com/s/k2ukkct5wsuxb3x/import.csv?dl=0

this is my import file, which also create member but does not attribute the membership level
https://www.dropbox.com/s/lv4cnt6ucczojoa/test.csv?dl=0

FYI, We have 11 member level in PMpro (ID from 1 to 11) and I check that the import file well contain the membership_id column

Thanks for your help

Pascal

Hi Pascal,

In the future, please open a separate topic even if the issue appears to be related.

Did you attempt to open those .csv files in a spreadsheet?

I ask because they both contain the incorrect date formats (the dates _have_ to be YYYY-MM-DD HH:MM:SS, _no_ exceptions).

Also, the column lists are incorrect for one of them (commas are missing causing data from one column type to be assigned to another one).

In the one where you used the example file, you’re winding up with the start date in the membership_id column on the 2nd line, and then it goes downhill from there (which is why the plugin is objecting to the import of those lines).