Forum Replies Created

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter dexr

    (@dexr)

    Thanks Thomas. Here are my steps today:
    1. Updgrade the plugin to v2.10
    2. Go to the subsite dashboard where the member levels 1 through 6 are set up
    3. Fix the date formats in the input file to 2018-01-01 08:00:00,2018-06-30 23:59:00
    4. Leave the membership_id as 1, 2 and 3 for the three data rows (all valid)
    5. Import using Memberships > Import Members

    ==> Data format error(s) detected during the import. Some records may not have been imported!

    Error log:

    BEGIN 2018-03-21 04:38:23
    [Line 1] The membership ID column in the import .CSV file must exist, contain a number (the membership level ID) and be an existing membership level ID. (Skipped!)
    BEGIN 2018-03-21 04:38:24
    [Line 1] The membership ID column in the import .CSV file must exist, contain a number (the membership level ID) and be an existing membership level ID. (Skipped!)
    BEGIN 2018-03-21 04:38:24
    [Line 1] The membership ID column in the import .CSV file must exist, contain a number (the membership level ID) and be an existing membership level ID. (Skipped!)

    However, the three users have been imported, they do show up on the member list, they do have the correct membership level attached to them and orders were created as required. So case closed.

    What I will do now is abandon this ‘sample data’ file and build a real import file from my member data, using membership levels as they are set up. I will see how that fares.

    Thomas thanks again for your help and for your extremely useful plugin.

    Thread Starter dexr

    (@dexr)

    Thanks for your quick reply Thomas.

    Today I see there were new updates for both the native Import Users from CSV with meta (1.11.3.1) and PMPro Import Users from CSV (3.3) so I have upgraded both.

    I re-imported via Memberships > Import Members in a subsite and see error report:

    BEGIN 2018-03-20 07:34:51
    [Line 1] The membership ID column in the import .CSV file must exist, contain a number (the membership level ID) and be an existing membership level ID. (Skipped!)
    BEGIN 2018-03-20 07:34:52
    [Line 1] The membership ID column in the import .CSV file must exist, contain a number (the membership level ID) and be an existing membership level ID. (Skipped!)
    BEGIN 2018-03-20 07:34:52
    [Line 1] The membership ID column in the import .CSV file must exist, contain a number (the membership level ID) and be an existing membership level ID. (Skipped!)
    BEGIN 2018-03-20 07:34:52
    [Line 1] Created user login field for record at row 2
    [Line 2] Created user login field for record at row 3
    [Line 3] Created user login field for record at row 4

    I’m guessing this is because I was in a subsite Dashboard when I did the import. When I delete the users and go back to the master site, the same file imports clean ‘Member import was successful.’

    However, in both cases it still does not import the memberships and the users show in the subsite as ‘Membership Level = None’

    Perhaps this is because at the master site level I have not set up any membership levels. On the subsite I have set up membership levels 1-6 and in the import data I have nominated levels 1, 2 & 3.

    Here is the import CSV file: https://www.dropbox.com/s/0070468g5cu8lgk/import_sample_fix.csv?dl=0

    Any further clues please?
    thanks again
    Dex

Viewing 2 replies - 1 through 2 (of 2 total)