Support » Plugin: Import and export users and customers » Adding values to custom fields in `wp_users` table while import from excel

  • Resolved dushyant2141

    (@dushyant2141)


    Hi,

    The plugin is best as it is! I simply love it!

    I have added 2 custom fields in wp_users table. I want to fill in the values in them as well while importing users from CSV. I tried the same.
    There are 2 scenarios:

    Scenario 1: When I check “Show fields in profile?” check box and import users from csv, I can see the additional fields in user’s profile. But they are not reflected into DB.

    Scenario 2: When I uncheck “Show fields in profile?” check box and import users from csv, I neither see those fields in user’s profile nor the DB gets updated.

    Can we have any workaround for this?

    • This topic was modified 4 years, 5 months ago by dushyant2141.
    • This topic was modified 4 years, 5 months ago by dushyant2141.
Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Javier Carazo

    (@carazo)

    @dushyant2141,

    Data which is part of wp_users cannot be shown, this is imported but this is saved into this table and will be shown by standard WordPress methods.

    Thread Starter dushyant2141

    (@dushyant2141)

    Hi @carazo,

    Thanks for such a quick reply! 🙂

    But I want to reflect the data from csv into the DB, I dont see the data reflected in either cases. Can this be done from the plugin and without additional coding?

    I’m going on a long leave. Will be working on this after 5 days.

    Thanks, in advance! Cheers 🙂

    Plugin Author Javier Carazo

    (@carazo)

    @dushyant2141,

    The data is reflected in the DB in the wp_users table. All the other data is reflected in the wp_usermeta.

    Which data is not being reflected?

    Thread Starter dushyant2141

    (@dushyant2141)

    @carazo,

    I’m talking about data to wp_users table. I manually added 2 new fields to this table. I want to fill these 2 fields in database with the help of import csv plugin which is not happening.

    Anyways, it is not a feature of the plugin. But may be you can consider this for the next release.

    Thanks,
    Dushyant

    Plugin Author Javier Carazo

    (@carazo)

    @dushyant2141,

    If you have made an ALTER of wp_users you are doing wrong. You have to use de WordPress “meta” table.

    If you need to do it for some reason (performance is the only one I can consider), we can create some addon for you.

    Tell me your requirements and we will give you a quote.

    Thread Starter dushyant2141

    (@dushyant2141)

    @carazo,

    Thanks for your support but I’m developing this website for learning purpose and I have user base of only 8 people. I think I will go with current manual method for now.

    I will surely get back whenever I will start freelancing! 😉

    Cheers, Dushyant!

    Plugin Author Javier Carazo

    (@carazo)

    Ah ok 🙂

    Good luck.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Adding values to custom fields in `wp_users` table while import from excel’ is closed to new replies.