Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic DOORS (steve huntington)
Decrease font size
Increase font size
Topic Title: Delete Users via DXL
Topic Summary: How to create a script where i can delete users not manually.
Created On: 5-Mar-2007 18:21
Status: Post and Reply
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Quick Reply Quick Reply
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
 5-Mar-2007 18:21
User is offline View Users Profile Print this message


Doors Group

Posts: 61
Joined: 31-Jan-2007

I receive like 10 MIS emails a day with almost 40 Users to remove from the system. What i'm looking for is can i create a script where i can put the name and if exist delete it. I know it's kind of hard but i think with a little help i can maake it. If someone have an IDEA please don't have any doubt into share it with me. I'm new with DXL, literally new.
Report this to a Moderator Report this to a Moderator
 5-Mar-2007 19:24
User is offline View Users Profile Print this message


David Pechacek

Posts: 674
Joined: 5-Dec-2006

Make a text box, copy the names into it (comma delimited), and have a button to hit to delete them. Use the existsUser() function to check if each user exists. If so, delete them. You'd first have to get a handle to the user with that name though.

-------------------------
David Pechacek
AAI Services Textron
dpechacek@sc-aaicorp.com
David.Pechacek@gmail.com
Report this to a Moderator Report this to a Moderator
 6-Mar-2007 13:56
User is offline View Users Profile Print this message


David Pechacek

Posts: 674
Joined: 5-Dec-2006

Look at the DXL Help (accessed by hitting Help in the DXL Editor Window). Look at dialog boxes for how to do the dialog box with the text box and the button. You'll have to write a function to tokenize the usernames by commas. For the actual delete code you can do this:

-------------------------
David Pechacek
AAI Services Textron
dpechacek@sc-aaicorp.com
David.Pechacek@gmail.com
Report this to a Moderator Report this to a Moderator
 4-Dec-2007 11:35
User is offline View Users Profile Print this message


Doors Group

Posts: 61
Joined: 31-Jan-2007

Yes, but how to delete a list of users in a spread sheet or a module, or a text file.
Report this to a Moderator Report this to a Moderator
 4-Dec-2007 15:07
User is offline View Users Profile Print this message


Louie Landale

Posts: 2070
Joined: 12-Sep-2002

Read the text file and parse it, resulting in a list of users to delete. Then try the attached.

- Louie
Report this to a Moderator Report this to a Moderator
 14-Dec-2007 20:05
User is offline View Users Profile Print this message


Doors Group

Posts: 61
Joined: 31-Jan-2007

I'm almost done with the script, but i have a little problem,

1. I need to validate that is the correct user
2. I need to compare the user at least in two ways by name and Username or System Login Name.
3. I need to create a way to match the names i received with the actual names in the Database. (Some of the names in the DB are shortnames like, Rich for Richard, Alex for Alexis)
I'm working with it right know and i got something but it's not too much. The things is that i can't work in the real DB so I'm practicing in the Training DB.

Any ideas are welcome
Report this to a Moderator Report this to a Moderator
 17-Dec-2007 09:30
User is offline View Users Profile Print this message


Tony Goodman

Posts: 1098
Joined: 12-Sep-2002

This is beginning to worry me now.

You say the list of names may not match the exact user names in doors?

Have all the users in doors got their system user name attribute set correctly? I bet they haven't.

By the soind of it you have a lot of users. It is highly likely that users have similar names.

If you really are not sure that the user names you are given exactly match those in doors then you risk deleting users that you shouldn't.

I would strongly recommend that you do not delete any users ever. Instead set their disabled flag.

There is no way to undelete a user.

-------------------------
Tony Goodman
http://www.smartdxl.com
Report this to a Moderator Report this to a Moderator
 17-Dec-2007 14:28
User is offline View Users Profile Print this message


Doors Group

Posts: 61
Joined: 31-Jan-2007

Tony,
You are so correct, 300 users approximately. But my plan is to place the correct information for each user, Complete names, correct system user id, and with the DOORS user name we have a unique way to set them. I'm not worry about deleting an user. The thing is that i receive more than 500 users that leave the company and some of them are DOORS users, some not.


But thanks any way, you just opened my mind. I don't need to delete them, I will just create a log with the users that exist in DOORS and the ones that don't and then I will delete them. This will save me time and money, since a 2 -10% of the users i received are non DOORS Users.


Thanks a lot.

I will still need some help at least to compare the system user ID and the username.
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic DOORS forum.
There are currently 2 users logged in.
The most users ever online was 15 on 15-Jan-2009 at 16:36.
There are currently 0 guests browsing this forum, which makes a total of 2 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.