deleting accounts

[sk1983]

hello?

can anybody tell me how I can delete an account in Sugar5?
I've already search on the forum and I found only topics of 2005 and of sugar 3.5.
there I read about a script to input in the readview.html in the usermap.
or that it is not possible to delete the accounts

but, is there no possilbe way to delete the accounts in Sugar5?

can Anybody telll me how I can delele some accounts?

greets,

Stefan

[andopes]

Hi, sk1983

Are you talking about the Accounts module itself or the User module?
Account records is deletable but User I think not through layout.

--
André Lopes
Lâmpada Global Services
Rua Bela Cintra, 299 conjunto. 51
São Paulo, SP 01415-000
tel1. 55 11 3237-3110
cel. 55 11 7636-5859
e-mail: info@lampadacrm.com.br

[sk1983]

Hey Andre,

I'm talking about the user management in the admin tab.
you have only the choice edit and clear, but I cannot find a delete button to delete some accounts.

Is it now clear?

greets,

Stefan.

[JVWay]

No, there is no facility to "delete" an account. You set them either active or inactive. If you set to inactive the system will ask if you want to assign records that belonged to that user to another. I have deleted users through the database but you stand the chance of leaving orphaned records around. I took the step of querying most of the other tables to see if that users id existed.

This was early on and I didn't feel it was too dangerous. Don't know if I'd want to do it now.

[sk1983]

Hey Jerry,

I work with a custom module form and I maked a new contact with a test-account so the record is assigned to the test-account, but if I go to the user management and set the Test-account on Inactive then I dont get the message if I want to assing the record to a other.

But, You wanna tell me that if a worker that works with sugar, and the worker is leaving the company, that you cannot delete this persons-account even is it for 5years or more. thats realy strange. Is there no other solution to delete a account?

greets,

Stefan.

[JVWay]

At this point it's only through direct interaction with the database. Use a MySQL admin tool or connect through ODBC using OpenOffice Base or Access. You should check for orphaned records or potential orphaned records like the case of a custom module and reassign or delete.

I know there is ongoing discussion regarding this and I have seen other systems where they don't let you actually delete the account.

[tomgood]

Hi, everyone.

Please teach me how to delete users/accounts with mysqladmin,
because I'm poor at mysql...

Thanks,

Tom

[andopes]

Hi, tomgood

If you really want and need to delete Users then:

1. Access the desired database using phpmyadmin;
2. Go to the users table;
3. Click in the link Search and fill into user_name, click in Run.

Then it will be visible only the user you want to delete.
So you can edit it and change the deleted field from 0 to 1.

Cheers.

--
André Lopes
Lâmpada Global Services
Rua Bela Cintra, 299 conjunto. 51
São Paulo, SP 01415-000
tel1. 55 11 3237-3110
cel. 55 11 7636-5859
e-mail: info@lampadacrm.com.br

[pblag]

Hi Stefan!

I think that you should only update users table.
If you remove the row from database you can have some problems with existing data.
Also it is possible to customize your sugarcrm so you can delete users from sugarcrm user management. (you can ask us to do it if you want)

Regards,

[kuske]

Yes you should not delete users, but if everybody does only things he should do, we would drive in storeage cars like freddy flintstone....

For version 4.5.1 I described in thread http://www.sugarcrm.com/forums/showthread.php?t=28209 how to delete the demo users and their data from the database.