Export Last Login with “Import and Export Users and Customers” Plugin

  • Resolved saskiabub

    (@saskiabub)


    1 month, 1 week ago

    Hi there,

    I’m trying to find out the tag to use to export the last user logins of your plugin.

    I found the _cbxuseronline table in the database but it only shows me the last hour of users. Where is the data saved?

    Thank you in advance.
    Saskia

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter saskiabub

    (@saskiabub)

    1 month, 1 week ago

    I would need the metakey for the entries

    Plugin Author Sabuj Kundu

    (@manchumahara)

    1 month, 1 week ago

    @saskiabub the meta key name is ‘_cbxuseronline_lastlogin_time’ and it’s a user meta key.

    let me know if that helps.

    Thread Starter saskiabub

    (@saskiabub)

    1 month, 1 week ago

    Hi there,

    thanks, when exporting I got weird numbers now like 1741115071 and 1742829104 but I would need the date the user was last online. Any idea how to get that?

    Plugin Author Sabuj Kundu

    (@manchumahara)

    1 month, 1 week ago

    Don’t worry. This is timestamp value.

    This is how you can convert the value to real readable

    $last_login = get_user_meta( $user_id, '_cbxuseronline_lastlogin_time', true );
    if ( $last_login != '' ) {
    $last_login = date_i18n( get_option( 'date_format' ) . ' ' . get_option( 'time_format' ), $last_login );
    }

    Thread Starter saskiabub

    (@saskiabub)

    1 month, 1 week ago

    Thanks, it worked using the “Convert timestamp data to date format”-setting I overlooked. 🙂

    Plugin Author Sabuj Kundu

    (@manchumahara)

    1 month, 1 week ago

    @saskiabub you are welcome. Happy to help you.

    I think we can expect a review for our plugin 🙂 https://wordpress.org/plugins/cbxuseronline/#reviews

Viewing 6 replies - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.