See Jim McKenzie's earlier comment about "additional workflow".
Instead of leaving "dead" userids on your system, laying dormant until
somebody else with a similar name pattern enrolls and bombs your automatic
userid create, why don't you automatically manage former student
"clean-up"? Somebody at the facility responsible for enrollment, transfer,
etc., should be able to give you notice when students leave. If their
records are to be retained for some period afterwards, you can add a
"delete on" date, advanced by whatever time you need. (I'd recommend a
separate table, not User).
This is where Jim's point comes in. You need to identify every form
involved in "cases" or any other "historical data" you want to remove. AN
Escalation on the side table/form could be triggered by the "delete on"
date to set another field "delete" which would trigger Filters to delete
the appropriate records from each table - either by updating a trigger
field to fire other Filters to do the work, or possibly with a Filter loop
to manage it all in one stream. At the end, you'd retrieve the user's
Request ID and run the delete process. I'd also supplement it with a
Filter to fire on delete to check the other tables to make sure no records
exist (to prevent direct delete from leaving "residue").
And this doesn't prevent duplicate userids. If you want to go a little
further, with additional workflow (on Merge), you could identify
duplication and append a unique identifier before/during create. If you
already have a "jdoe", it could make a "jdoe1". If "jode1" exists, it
could increment to "jdoe2", and so on. Separate integer field, and filter
loop. If you tinker with it, you could get it to automatically resolve
duplication - unless you want manual control.
Mike White
Office: 813-978-2192
E-mail: [EMAIL PROTECTED]
"Michael LoSapio"
<[EMAIL PROTECTED] To: [email protected]
TEVENS.EDU> cc:
Sent by: "Action Subject: FW: delete user -
need help??????
Request System
discussion
list(ARSList)"
<[EMAIL PROTECTED]
RG>
08/23/2006 16:39
Please respond to
arslist
**
Purge users that are in a file.
What I will do it take the output from arimportcmd
>
AR System Import Tool Wed Aug 23 01:30:00 2006
**** Import of D:\autoimport\remedy_users.csv started.
**** Record 1 : -- Login name (jdoe) already exists. Enter a different
login name. ( 43334)
"jdoe","Doe","Jane","Jane Doe","None"
**** Import completed with errors:
14 Records were imported to form SHR:People; 1 Records were not.
------------------------------------------------------------------------------------------------------------------------------------
And script that output into a new file… and run against something to remove
John Doe (also jdoe) from the system completely (including all historical
data)… so that Jane Doe’s import doesn’t have any problems.
The scenario is
John Doe is no longer a student here and purged from all of our primary
systems… and when jane doe comes along and registers for classes….. her
login name is now jdoe because john doe no longer exists.
Well, when Jane logs into the system….all of John Doe’s historical data
(previous cases) are tied to her account.
Management here has said that they just want to purge John Doe completely
and give Jane a fresh slate.
Now, if John Doe is a student currently… and Jane Doe registers for
classes… Jane is not jdoe1 and this problem error never happens.
Michael
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Chris Cook
Sent: Wednesday, August 23, 2006 4:16 PM
To: [email protected]
Subject: Re: delete user - need help??????
**
Hi Michael,
We have a similar import for user data here.
Are you looking to purge the users that are in the file or users that are
no longer in the file?
- Chris
Michael LoSapio <[EMAIL PROTECTED]>
Sent by: "Action Request System discussion
list(ARSList)" <[email protected]>
To
[EMAIL PROTECTED]
08/23/2006 02:47 PM .ORG
cc
Subject
delete user -
need help??????
Please respond to
[email protected]
I'll start off with a disclaimer that I am very new to the Remedy software
suite***
With that said,
We run a nightly import with arimportcmd (run from a .bat file) to import
data from a .csv file into a standard form (SHR:People)....
This loads users first names, last names and login names into the
form...then the users are able to login and report problems.
Is there an easy way to purge users completely from the system (as so if
they never existed in the system)...based off the exact same file (or one
very similar)?
TIA!
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
__20060125_______________________This posting was submitted with HTML in
it___
__20060125_______________________This posting was submitted with HTML in
it___
