i have a tough problem. From an existing database with user-data I need to transfer those users as subscribers to my wordpress database.
My user-profiles have various additional custom fields that I need for my user-details.
login email first_name last_name institut country_code city zip street phone country_code_person city_person zip_person street_person homepage sex entry_year student payed
Exactly the same columns are in my excel (or csv) sheet. How can I iterate through an excel sheet and transfer all the users to the database?
Since I'm fairly new to this I have no clue. Do I do this with MySQL or any other way?
Do you have tipps or tricks for me, maybe a snippet or anything?
Thank you in advance, Matt