Add/delete/remove/sync users

  • Resolved futurion

    (@futurion)


    5 years ago

    Dear developer,

    I have a particular question in regards to removing, deleting or better said synchronizing users from CSV files to wordpress. Let’s say in my case I have another mysql database which is a “master” database with all users data. I export this data to .csv files periodically and I want so sync this exported data to my wordpress page. What I would like to achieve is having at every moment the exact same situation inside wordpress as it is currently inside the master database.

    For instance, when making first import to wordpress, I have 600 users inside master database. All these users are exported to CSV, then imported into wordpress, everything ok. With next import I have only 550 users still in the master database, some are new, some old, which means that some users have to be updated inside wordpress, some added as new, and some removed, because they don’t exist anymore inside master. Is this somehow doable with your plugin?

    For now, the only way to achieve this in my opinion is to delete completely all wordpress users, and then import all of them again from CSV. This is of course not good in all cases, especially when some users make some changes to their existing accounts.

    What do you suggest would be the best option to achieve this?

    Kind regards, Tomaz.

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

    (@carazo)

    Tomaz,

    Good afternoon, yes this is doabled with this plugin.

    The best idea for this problem is:

    • Use the cron task
    • In the master, create a CSV and place it somewhere the plugin can read
    • Make the plugin delete not appearing users in the CSV
    • Plugin will also update users there and create new ones
    • You will have a log about how execution run

    Much users are using this functionality to do this kind of syncs.

    Any other question, please let me know.

    Thread Starter futurion

    (@futurion)

    Hello Mr. Carazo,

    thank you for this brief explanation. The process you described does exactly what I need to do, even better is that it can be also done with cron task. That’s actually perfect!

    I will do some extensive tests with CSV imports from master mysql DB and if I run into any kind of issues, I’ll report back.

    Thank you for now and kind regards from me!

    Plugin Author Javier Carazo

    (@carazo)

    If you have any problem, let us know.

    Thanks!

    Delete user if not present in CSV is not working for me. I tried both cron & admin. I just updated to latest plugin and still same issue.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Add/delete/remove/sync users’ is closed to new replies.