iansamz

I wanted to add users with their IDs from another database and noticed that the plugin does not allow a user to import users with a specific ID.

I was able to achieve this by first importing the csv with their IDs via mysql terminal using the script below

LOAD DATA INFILE "~/Downloads/members-import.csv"
INTO TABLE wp_users
COLUMNS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES
(ID, user_login, user_pass, user_nicename, user_email, user_status, display_name);

Afterwards I imported the users remaining data using the plugin which saved me a lot of time.

I hope this might help someone else in the future.