Delete User

[dc50093]

Recently we imported more than 32,000 lead records and all seemed to have gone well; that is until we discovered that we now have 302 user records. Originally there were seven users accounts. Clearly the import went astray. If it were five or ten stray records I would simply set the user records as inactive but with this many excess user records I'm at a loss as to what to do. Can anyone offer input relating to what went wrong and, more importantly, what can I do with the 295 excess users accounts that we now have....

I suspect that the root of the problem may relate to the *.csv import data not having been as clean as it should have been- a stray coma here and their. For example: the coma in "ABC, Inc." should have been removed prior to the import.

Thanks in advance for any assistance....

[sandeeplakshmi]

Hello dc50093!!

rather than thinking what to do with the 295 users you can think about the 7 other records.
form user management listview using 'select all' option just select all the 309 users and change them to 'Inactive' from massupdate,then change the 7 users to active independently. this way you can restrict the 295 users.

If you want to delete the 295 users from sugar{after doing the above procedure } you can run a simple query like -
update users set deleted =1 where status = 'inactive';

[dc50093]

Thank you Sandeep for your reply. Prior to posting my message I had already set the records to inactive or active so this was not the issue per say. It was just bothering me that I could not delete users. Can you expand on the tail end of your post relating to running a query to actually delete the user record? Do I do this from the command line? If so, what is the actual command?

Thanks so much for your help!

[Spinaker]

Dear dc50093,

You must to login into phpmyadmin (same address in the internet browser, but behind the ip number or name of the server you must to put phpmyadmin, for example 192.168.1.1/phpmyadmin.
Now you must to put password and login. Rest - mysql or mssql manual

[sandeeplakshmi]

Hello dc50093,

If you have phpMyAdmin installed you can easily fire the query against the db.
if its installed in your local system just type -> http://localhost/phpmyadmin in the address bar of browser
select the sugar db from the left side listview. then click sql tab on the top - you will be presented with a text box to run query. just paste the query there & its finished.

if u dont have phpmyadmin then you need to go through terminal.
in your terminal type ->
mysql -u yourusername -p {enter}
you will be prompted for password .
then msql> prompt appears
here select your db by typing -> use databasename;
then type the query i had given & press enter. thats it.