Topic Options
Rate This Topic
#94064 - 12/30/03 09:04 AM Adding a value in the middle of the Status Field
peter_lammey Offline
Stealth Member

Registered: 03/11/04
Posts: 36
My supervisor who is considering changes to one of our customized Remedy applications came up with scary idea on changing one of the forms that has been in for use for years.

He asked me to consider the implications of adding a value in the selection list for the Status field (called "Pending" that would be placed in the middle of the selection list.

I know that such a change off the bat means I must modify all records to adjust for this new status (ie. Our Status list is Initiated, In Progress, Complete, Cancelled....If we put "Pending" after "In Progress", I will have to modify the status for all record that were in a status of Complete or Cancelled after this new status is added).

I also know that anywhere that I have workflow with an Execute On condition of Status > "Some Value" these types of workflow need to be adjusted.

The part I don't know is what would happen to workflow where I set the Status of a transaction explicitly to "Complete" or "Cancelled"
Will these types of actions be corrupted by adding a status in the middle of the selection list?

Thanks
Peter Lammey
HR-Payroll Services
Hartford, CT
860-308-8127




Top
#94065 - 12/30/03 09:36 AM Re: Adding a value in the middle of the Status Field [Re: johan_wasserman]
Matt Reinfeldt Offline
Old Hand
***

Registered: 06/12/01
Posts: 1419
Loc: Madison, WI
oh, I forgot to add... make sure to test the change on a dev box before
touching production!!!! 'cause it would really suck having to do a rollback
or major datafix when you weren't planning on it!!

matt

Peter,

download the latest archgsel from the developer's community downloads... it
allows you to add/delete/move selection values at whim... ;-) it does a
data fix for you on all records in that form... and it modifies the entire
data dictionary (workflow, menus, etc...). Well, it does the best job of
any tool I've seen for this, in any case. It has saved me countless hours
in datafixing, not to mention tracking down all the workflow items that
touch the selection field....

Hope that helps!

matt r.

-----Original Message-----
From: Lammey, Peter [mailto:peter.lammey@CITIGROUP.COM]
Sent: Tuesday, December 30, 2003 3:04 PM
To: ARSLIST@ARSLIST.ORG
Subject: Adding a value in the middle of the Status Field


My supervisor who is considering changes to one of our customized Remedy
applications came up with scary idea on changing one of the forms that has
been in for use for years.

He asked me to consider the implications of adding a value in the selection
list for the Status field (called "Pending" that would be placed in the
middle of the selection list.

I know that such a change off the bat means I must modify all records to
adjust for this new status (ie. Our Status list is Initiated, In Progress,
Complete, Cancelled....If we put "Pending" after "In Progress", I will have
to modify the status for all record that were in a status of Complete or
Cancelled after this new status is added).

I also know that anywhere that I have workflow with an Execute On condition
of Status > "Some Value" these types of workflow need to be adjusted.

The part I don't know is what would happen to workflow where I set the
Status of a transaction explicitly to "Complete" or "Cancelled"
Will these types of actions be corrupted by adding a status in the middle of
the selection list?

Thanks
Peter Lammey
HR-Payroll Services
Hartford, CT
860-308-8127



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com




Top
#94066 - 12/30/03 09:34 AM Re: Adding a value in the middle of the Status Field [Re: johan_wasserman]
Matt Reinfeldt Offline
Old Hand
***

Registered: 06/12/01
Posts: 1419
Loc: Madison, WI
Peter,

download the latest archgsel from the developer's community downloads... it
allows you to add/delete/move selection values at whim... ;-) it does a
data fix for you on all records in that form... and it modifies the entire
data dictionary (workflow, menus, etc...). Well, it does the best job of
any tool I've seen for this, in any case. It has saved me countless hours
in datafixing, not to mention tracking down all the workflow items that
touch the selection field....

Hope that helps!

matt r.

-----Original Message-----
From: Lammey, Peter [mailto:peter.lammey@CITIGROUP.COM]
Sent: Tuesday, December 30, 2003 3:04 PM
To: ARSLIST@ARSLIST.ORG
Subject: Adding a value in the middle of the Status Field


My supervisor who is considering changes to one of our customized Remedy
applications came up with scary idea on changing one of the forms that has
been in for use for years.

He asked me to consider the implications of adding a value in the selection
list for the Status field (called "Pending" that would be placed in the
middle of the selection list.

I know that such a change off the bat means I must modify all records to
adjust for this new status (ie. Our Status list is Initiated, In Progress,
Complete, Cancelled....If we put "Pending" after "In Progress", I will have
to modify the status for all record that were in a status of Complete or
Cancelled after this new status is added).

I also know that anywhere that I have workflow with an Execute On condition
of Status > "Some Value" these types of workflow need to be adjusted.

The part I don't know is what would happen to workflow where I set the
Status of a transaction explicitly to "Complete" or "Cancelled"
Will these types of actions be corrupted by adding a status in the middle of
the selection list?

Thanks
Peter Lammey
HR-Payroll Services
Hartford, CT
860-308-8127



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com




Top
#94067 - 12/30/03 09:59 AM Re: Adding a value in the middle of the Status Field [Re: johan_wasserman]
RickW Offline
enthusiast

Registered: 08/29/03
Posts: 208
**

I am considering a similar move (adding a Status in the middle of the list) so I downloaded the archgsel utility just now and noticed this text in the ReadMe file:

NOTE: This utility will update the definiton of the selection field and will
update data values within the selection field based on your request. It will
not update the definitions of workflow (active links, escalations, and
filters) or of table field qualifications with the state changes you specify.
Those definitions will have to be updated separately using AR System Administrator.


The one thing that would prevent me from adding another status is the large amount of workflow (filters, active links and escalations) that I would have to modify by hand. I have inherited a very complex application from the previous Remedy Admin (who in turn inherited a lot from her predecessor) so I'm not all that confident that I can ferret out every little detail that I need to change. (A quick peek in Application Explorer shows 60 pieces of workflow tied to that field at minimum.)


-Rick

-----Original Message-----
From: Reinfeldt, Matt [ mailto:Matt.Reinfeldt@USCELLULAR.COM]
Sent: Tuesday, December 30, 2003 1:36 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Adding a value in the middle of the Status Field


oh, I forgot to add... make sure to test the change on a dev box before
touching production!!!! 'cause it would really suck having to do a rollback
or major datafix when you weren't planning on it!!

matt

Peter,

download the latest archgsel from the developer's community downloads... it
allows you to add/delete/move selection values at whim... ;-) it does a
data fix for you on all records in that form... and it modifies the entire
data dictionary (workflow, menus, etc...). Well, it does the best job of
any tool I've seen for this, in any case. It has saved me countless hours
in datafixing, not to mention tracking down all the workflow items that
touch the selection field....

Hope that helps!

matt r.

-----Original Message-----
From: Lammey, Peter [ mailto:peter.lammey@CITIGROUP.COM]
Sent: Tuesday, December 30, 2003 3:04 PM
To: ARSLIST@ARSLIST.ORG
Subject: Adding a value in the middle of the Status Field


My supervisor who is considering changes to one of our customized Remedy
applications came up with scary idea on changing one of the forms that has
been in for use for years.

He asked me to consider the implications of adding a value in the selection
list for the Status field (called "Pending" that would be placed in the
middle of the selection list.

I know that such a change off the bat means I must modify all records to
adjust for this new status (ie. Our Status list is Initiated, In Progress,
Complete, Cancelled....If we put "Pending" after "In Progress", I will have
to modify the status for all record that were in a status of Complete or
Cancelled after this new status is added).

I also know that anywhere that I have workflow with an Execute On condition
of Status > "Some Value" these types of workflow need to be adjusted.

The part I don't know is what would happen to workflow where I set the
Status of a transaction explicitly to "Complete" or "Cancelled"
Will these types of actions be corrupted by adding a status in the middle of
the selection list?

Thanks
Peter Lammey
HR-Payroll Services
Hartford, CT
860-308-8127

This posting was submitted via the Web interface

Top
#94068 - 12/30/03 10:26 AM Re: Adding a value in the middle of the Status Field [Re: johan_wasserman]
Matt Reinfeldt Offline
Old Hand
***

Registered: 06/12/01
Posts: 1419
Loc: Madison, WI
**
Rick,

I would say, "Test it". When I've run it, I see it updating Active Links, Filters, Escalations, etc.... Take a complete def file of your dev system to fall back on, and then try it... double-check your workflow items to see whether or not they have actually been changed. My guess is that they will have been. But, my experience may not be yours... or maybe the utility has changed since I last downloaded it (I have version 5.1 patch 1).

Matt R.

-----Original Message-----
From: Rick Westbrock [mailto:RickW@PETCO.COM]
Sent: Tuesday, December 30, 2003 4:00 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Adding a value in the middle of the Status Field


**

I am considering a similar move (adding a Status in the middle of the list) so I downloaded the archgsel utility just now and noticed this text in the ReadMe file:

NOTE: This utility will update the definiton of the selection field and will
update data values within the selection field based on your request. It will
not update the definitions of workflow (active links, escalations, and
filters) or of table field qualifications with the state changes you specify.
Those definitions will have to be updated separately using AR System Administrator.


The one thing that would prevent me from adding another status is the large amount of workflow (filters, active links and escalations) that I would have to modify by hand. I have inherited a very complex application from the previous Remedy Admin (who in turn inherited a lot from her predecessor) so I'm not all that confident that I can ferret out every little detail that I need to change. (A quick peek in Application Explorer shows 60 pieces of workflow tied to that field at minimum.)


-Rick

-----Original Message-----
From: Reinfeldt, Matt [ mailto:Matt.Reinfeldt@USCELLULAR.COM]
Sent: Tuesday, December 30, 2003 1:36 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Adding a value in the middle of the Status Field


oh, I forgot to add... make sure to test the change on a dev box before
touching production!!!! 'cause it would really suck having to do a rollback
or major datafix when you weren't planning on it!!

matt

Peter,

download the latest archgsel from the developer's community downloads... it
allows you to add/delete/move selection values at whim... ;-) it does a
data fix for you on all records in that form... and it modifies the entire
data dictionary (workflow, menus, etc...). Well, it does the best job of
any tool I've seen for this, in any case. It has saved me countless hours
in datafixing, not to mention tracking down all the workflow items that
touch the selection field....

Hope that helps!

matt r.

-----Original Message-----
From: Lammey, Peter [ mailto:peter.lammey@CITIGROUP.COM]
Sent: Tuesday, December 30, 2003 3:04 PM
To: ARSLIST@ARSLIST.ORG
Subject: Adding a value in the middle of the Status Field


My supervisor who is considering changes to one of our customized Remedy
applications came up with scary idea on changing one of the forms that has
been in for use for years.

He asked me to consider the implications of adding a value in the selection
list for the Status field (called "Pending" that would be placed in the
middle of the selection list.

I know that such a change off the bat means I must modify all records to
adjust for this new status (ie. Our Status list is Initiated, In Progress,
Complete, Cancelled....If we put "Pending" after "In Progress", I will have
to modify the status for all record that were in a status of Complete or
Cancelled after this new status is added).

I also know that anywhere that I have workflow with an Execute On condition
of Status > "Some Value" these types of workflow need to be adjusted.

The part I don't know is what would happen to workflow where I set the
Status of a transaction explicitly to "Complete" or "Cancelled"
Will these types of actions be corrupted by adding a status in the middle of
the selection list?

Thanks
Peter Lammey
HR-Payroll Services
Hartford, CT
860-308-8127

This posting was submitted via the Web interface

This posting was submitted via the Web interface

Top
#94069 - 12/30/03 10:30 AM Re: Adding a value in the middle of the Status Field [Re: johan_wasserman]
RickW Offline
enthusiast

Registered: 08/29/03
Posts: 208
**
That's encouraging to hear. I think that I will give it a try on my development server and see what comes of it. I would probably still have to manually verify that all changes happened properly but it should be quicker than manually making the changes in the first place.


-Rick

-----Original Message-----
From: Reinfeldt, Matt [mailto:Matt.Reinfeldt@USCELLULAR.COM]
Sent: Tuesday, December 30, 2003 2:26 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Adding a value in the middle of the Status Field


**
Rick,

I would say, "Test it". When I've run it, I see it updating Active Links, Filters, Escalations, etc.... Take a complete def file of your dev system to fall back on, and then try it... double-check your workflow items to see whether or not they have actually been changed. My guess is that they will have been. But, my experience may not be yours... or maybe the utility has changed since I last downloaded it (I have version 5.1 patch 1).

Matt R.

-----Original Message-----
From: Rick Westbrock [mailto:RickW@PETCO.COM]
Sent: Tuesday, December 30, 2003 4:00 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Adding a value in the middle of the Status Field


**

I am considering a similar move (adding a Status in the middle of the list) so I downloaded the archgsel utility just now and noticed this text in the ReadMe file:

NOTE: This utility will update the definiton of the selection field and will
update data values within the selection field based on your request. It will
not update the definitions of workflow (active links, escalations, and
filters) or of table field qualifications with the state changes you specify.
Those definitions will have to be updated separately using AR System Administrator.


The one thing that would prevent me from adding another status is the large amount of workflow (filters, active links and escalations) that I would have to modify by hand. I have inherited a very complex application from the previous Remedy Admin (who in turn inherited a lot from her predecessor) so I'm not all that confident that I can ferret out every little detail that I need to change. (A quick peek in Application Explorer shows 60 pieces of workflow tied to that field at minimum.)


-Rick

-----Original Message-----
From: Reinfeldt, Matt [ mailto:Matt.Reinfeldt@USCELLULAR.COM]
Sent: Tuesday, December 30, 2003 1:36 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Adding a value in the middle of the Status Field


oh, I forgot to add... make sure to test the change on a dev box before
touching production!!!! 'cause it would really suck having to do a rollback
or major datafix when you weren't planning on it!!

matt

Peter,

download the latest archgsel from the developer's community downloads... it
allows you to add/delete/move selection values at whim... ;-) it does a
data fix for you on all records in that form... and it modifies the entire
data dictionary (workflow, menus, etc...). Well, it does the best job of
any tool I've seen for this, in any case. It has saved me countless hours
in datafixing, not to mention tracking down all the workflow items that
touch the selection field....

Hope that helps!

matt r.

-----Original Message-----
From: Lammey, Peter [ mailto:peter.lammey@CITIGROUP.COM]
Sent: Tuesday, December 30, 2003 3:04 PM
To: ARSLIST@ARSLIST.ORG
Subject: Adding a value in the middle of the Status Field


My supervisor who is considering changes to one of our customized Remedy
applications came up with scary idea on changing one of the forms that has
been in for use for years.

He asked me to consider the implications of adding a value in the selection
list for the Status field (called "Pending" that would be placed in the
middle of the selection list.

I know that such a change off the bat means I must modify all records to
adjust for this new status (ie. Our Status list is Initiated, In Progress,
Complete, Cancelled....If we put "Pending" after "In Progress", I will have
to modify the status for all record that were in a status of Complete or
Cancelled after this new status is added).

I also know that anywhere that I have workflow with an Execute On condition
of Status > "Some Value" these types of workflow need to be adjusted.

The part I don't know is what would happen to workflow where I set the
Status of a transaction explicitly to "Complete" or "Cancelled"
Will these types of actions be corrupted by adding a status in the middle of
the selection list?

Thanks
Peter Lammey
HR-Payroll Services
Hartford, CT
860-308-8127

This posting was submitted via the Web interface

This posting was submitted via the Web interface

This posting was submitted via the Web interface

Top
#94070 - 12/30/03 07:48 PM Re: Adding a value in the middle of the Status Field [Re: johan_wasserman]
Jarl Groneng Offline
enthusiast

Registered: 03/10/05
Posts: 2371
Matt,

The last time I used archgsel it did not update the workflow. I had to do that manually.

I did an export of the workflow(al, filters and escalations) definition in XML format, and then search for the fieldids and then manually updated the definitions file.

--
Jarl

-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:ARSLIST@ARSLIST.ORG]On Behalf Of Reinfeldt, Matt
Sent: 30. desember 2003 23:26
To: ARSLIST@ARSLIST.ORG
Subject: Re: Adding a value in the middle of the Status Field


**
Rick,

I would say, "Test it". When I've run it, I see it updating Active Links, Filters, Escalations, etc.... Take a complete def file of your dev system to fall back on, and then try it... double-check your workflow items to see whether or not they have actually been changed. My guess is that they will have been. But, my experience may not be yours... or maybe the utility has changed since I last downloaded it (I have version 5.1 patch 1).

Matt R.
-----Original Message-----
From: Rick Westbrock [mailto:RickW@PETCO.COM]
Sent: Tuesday, December 30, 2003 4:00 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Adding a value in the middle of the Status Field


**
I am considering a similar move (adding a Status in the middle of the list) so I downloaded the archgsel utility just now and noticed this text in the ReadMe file:
NOTE: This utility will update the definiton of the selection field and will
update data values within the selection field based on your request. It will
not update the definitions of workflow (active links, escalations, and
filters) or of table field qualifications with the state changes you specify.
Those definitions will have to be updated separately using AR System Administrator.


The one thing that would prevent me from adding another status is the large amount of workflow (filters, active links and escalations) that I would have to modify by hand. I have inherited a very complex application from the previous Remedy Admin (who in turn inherited a lot from her predecessor) so I'm not all that confident that I can ferret out every little detail that I need to change. (A quick peek in Application Explorer shows 60 pieces of workflow tied to that field at minimum.)


-Rick
-----Original Message-----
From: Reinfeldt, Matt [mailto:Matt.Reinfeldt@USCELLULAR.COM]
Sent: Tuesday, December 30, 2003 1:36 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Adding a value in the middle of the Status Field


oh, I forgot to add... make sure to test the change on a dev box before
touching production!!!! 'cause it would really suck having to do a rollback
or major datafix when you weren't planning on it!!
matt
Peter,
download the latest archgsel from the developer's community downloads... it
allows you to add/delete/move selection values at whim... ;-) it does a
data fix for you on all records in that form... and it modifies the entire
data dictionary (workflow, menus, etc...). Well, it does the best job of
any tool I've seen for this, in any case. It has saved me countless hours
in datafixing, not to mention tracking down all the workflow items that
touch the selection field....
Hope that helps!
matt r.
-----Original Message-----
From: Lammey, Peter [mailto:peter.lammey@CITIGROUP.COM]
Sent: Tuesday, December 30, 2003 3:04 PM
To: ARSLIST@ARSLIST.ORG
Subject: Adding a value in the middle of the Status Field


My supervisor who is considering changes to one of our customized Remedy
applications came up with scary idea on changing one of the forms that has
been in for use for years.
He asked me to consider the implications of adding a value in the selection
list for the Status field (called "Pending" that would be placed in the
middle of the selection list.
I know that such a change off the bat means I must modify all records to
adjust for this new status (ie. Our Status list is Initiated, In Progress,
Complete, Cancelled....If we put "Pending" after "In Progress", I will have
to modify the status for all record that were in a status of Complete or
Cancelled after this new status is added).
I also know that anywhere that I have workflow with an Execute On condition
of Status > "Some Value" these types of workflow need to be adjusted.
The part I don't know is what would happen to workflow where I set the
Status of a transaction explicitly to "Complete" or "Cancelled"
Will these types of actions be corrupted by adding a status in the middle of
the selection list?
Thanks
Peter Lammey
HR-Payroll Services
Hartford, CT
860-308-8127
This posting was submitted via the Web interface
This posting was submitted via the Web interface




Top
#94071 - 12/31/03 01:48 AM Re: Adding a value in the middle of the Status Field [Re: johan_wasserman]
Matt Reinfeldt Offline
Old Hand
***

Registered: 06/12/01
Posts: 1419
Loc: Madison, WI
Jarl (and everyone else!),

you know what, I think you're right... I just ran a test and that does seem
to be the case. I was confusing archgsel and archgid (also an incredibly
cool program!!!). Thanks for the correction!


Matt R.

-----Original Message-----
From: Jarl Groneng [mailto:jarl.groneng@TELENOR.COM]
Sent: Wednesday, December 31, 2003 1:49 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Adding a value in the middle of the Status Field


Matt,

The last time I used archgsel it did not update the workflow. I had to do
that manually.

I did an export of the workflow(al, filters and escalations) definition in
XML format, and then search for the fieldids and then manually updated the
definitions file.

--
Jarl

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG]On Behalf Of Reinfeldt, Matt
Sent: 30. desember 2003 23:26
To: ARSLIST@ARSLIST.ORG
Subject: Re: Adding a value in the middle of the Status Field


**
Rick,

I would say, "Test it". When I've run it, I see it updating Active Links,
Filters, Escalations, etc.... Take a complete def file of your dev system to
fall back on, and then try it... double-check your workflow items to see
whether or not they have actually been changed. My guess is that they will
have been. But, my experience may not be yours... or maybe the utility has
changed since I last downloaded it (I have version 5.1 patch 1).

Matt R.
-----Original Message-----
From: Rick Westbrock [mailto:RickW@PETCO.COM]
Sent: Tuesday, December 30, 2003 4:00 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Adding a value in the middle of the Status Field


**
I am considering a similar move (adding a Status in the middle of the list)
so I downloaded the archgsel utility just now and noticed this text in the
ReadMe file:
NOTE: This utility will update the definiton of the selection field and will

update data values within the selection field based on your request. It
will
not update the definitions of workflow (active links, escalations, and
filters) or of table field qualifications with the state changes you
specify.
Those definitions will have to be updated separately using AR System
Administrator.


The one thing that would prevent me from adding another status is the large
amount of workflow (filters, active links and escalations) that I would have
to modify by hand. I have inherited a very complex application from the
previous Remedy Admin (who in turn inherited a lot from her predecessor) so
I'm not all that confident that I can ferret out every little detail that I
need to change. (A quick peek in Application Explorer shows 60 pieces of
workflow tied to that field at minimum.)


-Rick
-----Original Message-----
From: Reinfeldt, Matt [mailto:Matt.Reinfeldt@USCELLULAR.COM]
Sent: Tuesday, December 30, 2003 1:36 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Adding a value in the middle of the Status Field


oh, I forgot to add... make sure to test the change on a dev box before
touching production!!!! 'cause it would really suck having to do a rollback

or major datafix when you weren't planning on it!!
matt
Peter,
download the latest archgsel from the developer's community downloads... it

allows you to add/delete/move selection values at whim... ;-) it does a
data fix for you on all records in that form... and it modifies the entire
data dictionary (workflow, menus, etc...). Well, it does the best job of
any tool I've seen for this, in any case. It has saved me countless hours
in datafixing, not to mention tracking down all the workflow items that
touch the selection field....
Hope that helps!
matt r.
-----Original Message-----
From: Lammey, Peter [mailto:peter.lammey@CITIGROUP.COM]
Sent: Tuesday, December 30, 2003 3:04 PM
To: ARSLIST@ARSLIST.ORG
Subject: Adding a value in the middle of the Status Field


My supervisor who is considering changes to one of our customized Remedy
applications came up with scary idea on changing one of the forms that has
been in for use for years.
He asked me to consider the implications of adding a value in the selection
list for the Status field (called "Pending" that would be placed in the
middle of the selection list.
I know that such a change off the bat means I must modify all records to
adjust for this new status (ie. Our Status list is Initiated, In Progress,
Complete, Cancelled....If we put "Pending" after "In Progress", I will have
to modify the status for all record that were in a status of Complete or
Cancelled after this new status is added).
I also know that anywhere that I have workflow with an Execute On condition
of Status > "Some Value" these types of workflow need to be adjusted.
The part I don't know is what would happen to workflow where I set the
Status of a transaction explicitly to "Complete" or "Cancelled"
Will these types of actions be corrupted by adding a status in the middle of

the selection list?
Thanks
Peter Lammey
HR-Payroll Services
Hartford, CT
860-308-8127

UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com This posting was submitted via the Web interface

UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com This posting was submitted via the Web interface



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com




Top
#94072 - 12/31/03 02:01 AM Re: Adding a value in the middle of the Status Field [Re: johan_wasserman]
peter_lammey Offline
Stealth Member

Registered: 03/11/04
Posts: 36
Does this mean any workflow where the Status gets set to "Complete" or "Cancelled" (in my case) the Run If or any If Action needs to be changed once I add the value in the middle of the Status field? (This means the workflow that says Run If Status = "Complete" will change to Status = "Pending" once I add pending to the 3rd position)?

Thanks
Peter Lammey
HR-Payroll Services
Hartford, CT
860-308-8127


-----Original Message-----
From: Reinfeldt, Matt [mailto:Matt.Reinfeldt@USCELLULAR.COM]
Sent: Wednesday, December 31, 2003 8:49 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Adding a value in the middle of the Status Field


Jarl (and everyone else!),

you know what, I think you're right... I just ran a test and that does seem
to be the case. I was confusing archgsel and archgid (also an incredibly
cool program!!!). Thanks for the correction!


Matt R.

-----Original Message-----
From: Jarl Groneng [mailto:jarl.groneng@TELENOR.COM]
Sent: Wednesday, December 31, 2003 1:49 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Adding a value in the middle of the Status Field


Matt,

The last time I used archgsel it did not update the workflow. I had to do
that manually.

I did an export of the workflow(al, filters and escalations) definition in
XML format, and then search for the fieldids and then manually updated the
definitions file.

--
Jarl

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG]On Behalf Of Reinfeldt, Matt
Sent: 30. desember 2003 23:26
To: ARSLIST@ARSLIST.ORG
Subject: Re: Adding a value in the middle of the Status Field


**
Rick,

I would say, "Test it". When I've run it, I see it updating Active Links,
Filters, Escalations, etc.... Take a complete def file of your dev system to
fall back on, and then try it... double-check your workflow items to see
whether or not they have actually been changed. My guess is that they will
have been. But, my experience may not be yours... or maybe the utility has
changed since I last downloaded it (I have version 5.1 patch 1).

Matt R.
-----Original Message-----
From: Rick Westbrock [mailto:RickW@PETCO.COM]
Sent: Tuesday, December 30, 2003 4:00 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Adding a value in the middle of the Status Field


**
I am considering a similar move (adding a Status in the middle of the list)
so I downloaded the archgsel utility just now and noticed this text in the
ReadMe file:
NOTE: This utility will update the definiton of the selection field and will

update data values within the selection field based on your request. It
will
not update the definitions of workflow (active links, escalations, and
filters) or of table field qualifications with the state changes you
specify.
Those definitions will have to be updated separately using AR System
Administrator.


The one thing that would prevent me from adding another status is the large
amount of workflow (filters, active links and escalations) that I would have
to modify by hand. I have inherited a very complex application from the
previous Remedy Admin (who in turn inherited a lot from her predecessor) so
I'm not all that confident that I can ferret out every little detail that I
need to change. (A quick peek in Application Explorer shows 60 pieces of
workflow tied to that field at minimum.)


-Rick
-----Original Message-----
From: Reinfeldt, Matt [mailto:Matt.Reinfeldt@USCELLULAR.COM]
Sent: Tuesday, December 30, 2003 1:36 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Adding a value in the middle of the Status Field


oh, I forgot to add... make sure to test the change on a dev box before
touching production!!!! 'cause it would really suck having to do a rollback

or major datafix when you weren't planning on it!!
matt
Peter,
download the latest archgsel from the developer's community downloads... it

allows you to add/delete/move selection values at whim... ;-) it does a
data fix for you on all records in that form... and it modifies the entire
data dictionary (workflow, menus, etc...). Well, it does the best job of
any tool I've seen for this, in any case. It has saved me countless hours
in datafixing, not to mention tracking down all the workflow items that
touch the selection field....
Hope that helps!
matt r.
-----Original Message-----
From: Lammey, Peter [mailto:peter.lammey@CITIGROUP.COM]
Sent: Tuesday, December 30, 2003 3:04 PM
To: ARSLIST@ARSLIST.ORG
Subject: Adding a value in the middle of the Status Field


My supervisor who is considering changes to one of our customized Remedy
applications came up with scary idea on changing one of the forms that has
been in for use for years.
He asked me to consider the implications of adding a value in the selection
list for the Status field (called "Pending" that would be placed in the
middle of the selection list.
I know that such a change off the bat means I must modify all records to
adjust for this new status (ie. Our Status list is Initiated, In Progress,
Complete, Cancelled....If we put "Pending" after "In Progress", I will have
to modify the status for all record that were in a status of Complete or
Cancelled after this new status is added).
I also know that anywhere that I have workflow with an Execute On condition
of Status > "Some Value" these types of workflow need to be adjusted.
The part I don't know is what would happen to workflow where I set the
Status of a transaction explicitly to "Complete" or "Cancelled"
Will these types of actions be corrupted by adding a status in the middle of

the selection list?
Thanks
Peter Lammey
HR-Payroll Services
Hartford, CT
860-308-8127

UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com This posting was submitted via the Web interface

UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com This posting was submitted via the Web interface



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com







Top
#94073 - 12/31/03 02:37 AM Re: Adding a value in the middle of the Status Field [Re: johan_wasserman]
Matt Reinfeldt Offline
Old Hand
***

Registered: 06/12/01
Posts: 1419
Loc: Madison, WI
Peter,

to the best of my knowledge, you are correct... you will need to go edit
those workflow items. BUT... you won't have to data-fix records in that
table, nor status-history values.... oh, one other thing to watch out
for... if you push/pull that Selection field to/from other forms, make sure
that you keep those forms in synch as well. i.e., if you have a form for
logging Status Changes and their timings (we always call ours TimeSlips),
where you have a duplicate of your Status field, you'll need to add Pending
there as well, otherwise your workflow mappings will not line up.

Hope that makes sense...

Matt

-----Original Message-----
From: Lammey, Peter [mailto:peter.lammey@CITIGROUP.COM]
Sent: Wednesday, December 31, 2003 8:02 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Adding a value in the middle of the Status Field


Does this mean any workflow where the Status gets set to "Complete" or
"Cancelled" (in my case) the Run If or any If Action needs to be changed
once I add the value in the middle of the Status field? (This means the
workflow that says Run If Status = "Complete" will change to Status =
"Pending" once I add pending to the 3rd position)?

Thanks
Peter Lammey
HR-Payroll Services
Hartford, CT
860-308-8127


-----Original Message-----
From: Reinfeldt, Matt [mailto:Matt.Reinfeldt@USCELLULAR.COM]
Sent: Wednesday, December 31, 2003 8:49 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Adding a value in the middle of the Status Field


Jarl (and everyone else!),

you know what, I think you're right... I just ran a test and that does seem
to be the case. I was confusing archgsel and archgid (also an incredibly
cool program!!!). Thanks for the correction!


Matt R.

-----Original Message-----
From: Jarl Groneng [mailto:jarl.groneng@TELENOR.COM]
Sent: Wednesday, December 31, 2003 1:49 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Adding a value in the middle of the Status Field


Matt,

The last time I used archgsel it did not update the workflow. I had to do
that manually.

I did an export of the workflow(al, filters and escalations) definition in
XML format, and then search for the fieldids and then manually updated the
definitions file.

--
Jarl

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG]On Behalf Of Reinfeldt, Matt
Sent: 30. desember 2003 23:26
To: ARSLIST@ARSLIST.ORG
Subject: Re: Adding a value in the middle of the Status Field


**
Rick,

I would say, "Test it". When I've run it, I see it updating Active Links,
Filters, Escalations, etc.... Take a complete def file of your dev system to
fall back on, and then try it... double-check your workflow items to see
whether or not they have actually been changed. My guess is that they will
have been. But, my experience may not be yours... or maybe the utility has
changed since I last downloaded it (I have version 5.1 patch 1).

Matt R.
-----Original Message-----
From: Rick Westbrock [mailto:RickW@PETCO.COM]
Sent: Tuesday, December 30, 2003 4:00 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Adding a value in the middle of the Status Field


**
I am considering a similar move (adding a Status in the middle of the list)
so I downloaded the archgsel utility just now and noticed this text in the
ReadMe file:
NOTE: This utility will update the definiton of the selection field and will

update data values within the selection field based on your request. It
will
not update the definitions of workflow (active links, escalations, and
filters) or of table field qualifications with the state changes you
specify.
Those definitions will have to be updated separately using AR System
Administrator.


The one thing that would prevent me from adding another status is the large
amount of workflow (filters, active links and escalations) that I would have
to modify by hand. I have inherited a very complex application from the
previous Remedy Admin (who in turn inherited a lot from her predecessor) so
I'm not all that confident that I can ferret out every little detail that I
need to change. (A quick peek in Application Explorer shows 60 pieces of
workflow tied to that field at minimum.)


-Rick
-----Original Message-----
From: Reinfeldt, Matt [mailto:Matt.Reinfeldt@USCELLULAR.COM]
Sent: Tuesday, December 30, 2003 1:36 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Adding a value in the middle of the Status Field


oh, I forgot to add... make sure to test the change on a dev box before
touching production!!!! 'cause it would really suck having to do a rollback

or major datafix when you weren't planning on it!!
matt
Peter,
download the latest archgsel from the developer's community downloads... it

allows you to add/delete/move selection values at whim... ;-) it does a
data fix for you on all records in that form... and it modifies the entire
data dictionary (workflow, menus, etc...). Well, it does the best job of
any tool I've seen for this, in any case. It has saved me countless hours
in datafixing, not to mention tracking down all the workflow items that
touch the selection field....
Hope that helps!
matt r.
-----Original Message-----
From: Lammey, Peter [mailto:peter.lammey@CITIGROUP.COM]
Sent: Tuesday, December 30, 2003 3:04 PM
To: ARSLIST@ARSLIST.ORG
Subject: Adding a value in the middle of the Status Field


My supervisor who is considering changes to one of our customized Remedy
applications came up with scary idea on changing one of the forms that has
been in for use for years.
He asked me to consider the implications of adding a value in the selection
list for the Status field (called "Pending" that would be placed in the
middle of the selection list.
I know that such a change off the bat means I must modify all records to
adjust for this new status (ie. Our Status list is Initiated, In Progress,
Complete, Cancelled....If we put "Pending" after "In Progress", I will have
to modify the status for all record that were in a status of Complete or
Cancelled after this new status is added).
I also know that anywhere that I have workflow with an Execute On condition
of Status > "Some Value" these types of workflow need to be adjusted.
The part I don't know is what would happen to workflow where I set the
Status of a transaction explicitly to "Complete" or "Cancelled"
Will these types of actions be corrupted by adding a status in the middle of

the selection list?
Thanks
Peter Lammey
HR-Payroll Services
Hartford, CT
860-308-8127

UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com This posting was submitted via the Web interface

UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com This posting was submitted via the Web interface



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com




Top


Moderator:  Matt Reinfeldt