Setting Expiration date when importing CVS

  • Resolved matthewhearne

    (@matthewhearne)


    12 years ago

    I am using a plugin called “Import Users from CSV” to import users into the site.

    I want to be able to specify the expiration date for the users on the import and set the other expiration actions (change of role etc).

    I can specify custom user meta data in the CSV that I am importing.

    Can you please let me know what I should be putting as field names / values to get this to work?

    I have looked in the MySQL DB for field names and can find _expire_user_date and _expire_user_settings, but the format for the date field looks like just a random lot of numbers and not a date format.

    Any help is greatly appreciated.

    https://wordpress.org/plugins/expire-users/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Ben Huson

    (@husobj)

    12 years ago

    The _expire_user_settings are stored as serialised array in the database so I’m not sure it will be importable via the the Import Users from CSV plugin.

    Thread Starter matthewhearne

    (@matthewhearne)

    12 years ago

    Thanks for the info. I managed to get it to work on the import but have to set the date in a Unix format so will have to do some conversion before the upload by the looks of it.

    Thanks again
    Matt

    theresa.webdev@gmail.com

    (@theresawebdevgmailcom)

    11 years, 9 months ago

    matthewhearne, which table does the data go into?

    michael walker

    (@michael-walker)

    11 years, 7 months ago

    @theresa: It is listed as a meta key/value in wp_usermeta

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

The topic ‘Setting Expiration date when importing CVS’ is closed to new replies.