• Resolved becalvin

    (@becalvin)


    Given hundreds of patrons and hundreds of users have already been bulk imported, Is there a way for adding those patrons to the according users more quickly, instead of assign them all one-by-one?

    Thx!

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Robert Heller

    (@robertpheller)

    No, there isn’t at this time.

    You could let the users do their own association with their patron record.

    Thread Starter becalvin

    (@becalvin)

    Oops…
    Don’t wana users can see other patrons and username….

    Will it possible to manually direct import to sql? If yes, which database name it refer to?

    Plugin Author Robert Heller

    (@robertpheller)

    The patron id gets stored as a user “meta data”, using the WP php function update_user_meta(). It should be possible to add elements to wp_usermeta, if you know *exactly* what you are doing.

    Here is what things look like from mysql (from my test site):

    mysql> describe wp_usermeta;
    +------------+---------------------+------+-----+---------+----------------+
    | Field      | Type                | Null | Key | Default | Extra          |
    +------------+---------------------+------+-----+---------+----------------+
    | umeta_id   | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
    | user_id    | bigint(20) unsigned | NO   | MUL | 0       |                |
    | meta_key   | varchar(255)        | YES  | MUL | NULL    |                |
    | meta_value | longtext            | YES  |     | NULL    |                |
    +------------+---------------------+------+-----+---------+----------------+
    4 rows in set (0.01 sec)
    
    mysql> select * from wp_usermeta where meta_key='PatronID';
    +----------+---------+----------+------------+
    | umeta_id | user_id | meta_key | meta_value |
    +----------+---------+----------+------------+
    |       36 |       1 | PatronID | 1          |
    |       41 |       2 | PatronID | 100        |
    +----------+---------+----------+------------+
    2 rows in set (0.01 sec)
    Thread Starter becalvin

    (@becalvin)

    Thx!

    Indeed, hopefully you’ll consider offer an upgrade to enhance bulk-add patron to user. It will be perfect and good news for general online libarian…

    ??

    Plugin Author Robert Heller

    (@robertpheller)

    Indeed, hopefully you’ll consider offer an upgrade to enhance bulk-add patron to user. It will be perfect and good news for general online libarian…

    This is not going to happen :-). This plugin is no longer in active development. I will fix bug and make security fixes, but won’t be adding new features or functionallity. You are free to fork the plugin and add your own enhancements.

    Thread Starter becalvin

    (@becalvin)

    Have successfully added per your instruction!
    Great thx!

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘How to deal with adding dose of patron to dose of users’ is closed to new replies.