Forums

Importing users

Permalink
I just bought kino's import users add-on to import users from another CMS. It only imported 300 out of the 460 total users due to password required and didn't tell me which one's it imported. Now I don't see any way of deleting the one's I have in there and starting over so I'm worse off then before I bought the add-on.

And since Kino hasn't answered any support questions since 2010.. I'm kind of screwed here.

Is there really no easier way of importing users into Concrete5? Or at least a way of deleting all users aside from the admins?

Please help!
getjoel
 
Mainio replied on at Permalink Reply
Mainio
Hi,

Do you know how to run SQL commands on your database server?

If you do, there's always the manual way of doing it against your database. I can put together the commands if you're comfortable enough to open the hood of your car and do a little "oil change" there.

I'm not familiar with the described add-on but I would think that there are few reasons why it would've failed:
- The list is too long for the add-on (either timeout or a limitation for the file to be imported)
- There was some unexpected character in the CSV you're importing that the add-on is not prepared for

Probably I'd clean up the users table and try and import them in parts (e.g. 100 rows per time).

Br,
Antti / Mainio
getjoel replied on at Permalink Reply
getjoel
Thank you!

http://www.concrete5.org/marketplace/addons/kinos-import-users/supp...

Sent from my iPhone
Mainio replied on at Permalink Reply
Mainio
Ok, I assume that by that you mean that you're comfortable running the SQL commands?

Either way, always before any bigger database operation, PLEASE BE SURE TO BACKUP YOUR DATABASE! This can be done from Dashboard => System & Maintenance => Backup & Restore.

Please be sure that I do not take any responsibility if this messes up your database, I'm just providing the code.

Here's an SQL command which gives you the users that ARE NOT in the Administrators group AND is not the super user of your site that has the uID = 1:
SELECT * FROM Users U WHERE uID != 1 AND uID NOT IN (
   SELECT uID FROM UserGroups UG
      INNER JOIN Groups G ON UG.gID = G.gID
   WHERE G.gName = 'Administrators'
);


So, with small change to that command you should also be able to delete the users. I'll leave that up to you because if doing this, you should really know what you're doing.

Remember:
a) TAKE A BACKUP of the database before doing anything
b) BE SURE TO RUN THE SELECT-command before changing it into DELETE-command so that you really see what you're deleting


Br,
Antti / Mainio
getjoel replied on at Permalink Reply
getjoel
Thank you.. I have another question. The client apparently has addresses and phone numbers they want imported too.. but those are attributes. Is there a way to import users with certain attribute fields as well? I have a developer that's quoting me 5 hours to do it manually.. There has to be an easier way?
Mainio replied on at Permalink Reply
Mainio
5h seems to be quite reasonable amount of work for that. I would probably quote somewhere at the same range.

There are some add-ons at the marketplace that help you in importing but what I keep hearing from those is that they don't work 100% correctly and do not take everything into account that should be taken in all the cases.


Best,
Antti / Mainio


EDIT: Didn't read the first post (and this was an old topic), seems that you already know about the add-ons! :)