• Resolved baldure

    (@baldure)


    I’m having trouble importing users into a multisite setup.

    I’m trying to set the value ‘a:1:{s:10:”subscriber”;s:1:”1″;}’ into ‘wp_2_capabilities’, but it always gets mangled in the database.
    I’ve tried various combinationsof quotes; no quotes, quotes escaped with ‘\’ and with anoter doublequote, as stated in RFC4180.
    I can correct it in in my development database and make it work, but I don’t have the same access to the production database.

    Any ideas?

    Best regards
    Baldur

    https://www.ads-software.com/extend/plugins/import-users-from-csv/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Contributor Ulrich Sossou

    (@sorich87)

    Hi @baldure,

    How is it saved in the database?

    Thread Starter baldure

    (@baldure)

    When I use a csv file containing:

    "user_login","user_email","user_pass","first_name","wp_2_capabilities","wp_2_user_level"
    "gbs18","gbs18@hi.is","$P$BjoKdsT40gH4XUEhsVH96SYQ7TVIff0","Gunnar B Svavarsson","a:1:{s:10:""subscriber"";s:1:""1"";}","0"

    I get

    s:32:”a:1:{s:10:”subscriber”;s:1:”1″;}”;

    in the wp_2_capabilities field in wp_usermeta.

    Same result comes from

    "gbs18","gbs18@hi.is","$P$BjoKdsT40gH4XUEhsVH96SYQ7TVIff0","Gunnar B Svavarsson","a:1:{s:10:\"subscriber\";s:1:\"1\";}",0

    or

    gbs18,gbs18@hi.is,$P$BjoKdsT40gH4XUEhsVH96SYQ7TVIff0,Gunnar B Svavarsson,a:1:{s:10:"subscriber";s:1:"1";},0

    Plugin Contributor Ulrich Sossou

    (@sorich87)

    Thread Starter baldure

    (@baldure)

    Well done, this worked!

    Best Regards
    Baldur.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘[Plugin: Import Users from CSV] Subscribers don't show in sites userlist after import’ is closed to new replies.