Keyword

Importing users from external database via CSV

  • Thor Johannes Wang
  • Thor Johannes Wang's Avatar Topic Author
  • Offline
  • New Member
More
14 years 3 months ago #84590 by Thor Johannes Wang
Importing users from external database via CSV was created by Thor Johannes Wang
Hi everybody! I am quite new to Joomla! and just found out about K2!I have a problem that I can't seem to find a good solution or plugin for.
I need to be able to add users form an external database into Joomla! and K2. (CSV?)
The users have more fields than the default ones for a user in Joomla! and consequently, all new users have to be able to fill out these extra fields.

After some trial and error I was able to add new columns in jos_users and corresponding order of columns in the CSV-file. This resulted in a successful addition in the table, however the user is not to be found under User Management, and therefore cannot be used.

I have looked at various plugins and techniques, (userport, scripts etc) but can't seem to find anything suited my task. Also: will the passwords(MD5-hashed) transfer over smoothly?

Help is greatly appreciated! Thanks

Please Log in or Create an account to join the conversation.

More
14 years 3 months ago #84591 by william white
Replied by william white on topic Importing users from external database via CSV
Add a new user in Joomla thru site-user manager
Go to K2 - users
The user is there but has no group
you will have to do more than just put entries in the K2_users table
See if you can find the code that makes the k2 import joomla users button work
also take a look at the k2 login code to see what it does

Please Log in or Create an account to join the conversation.


Powered by Kunena Forum