Everybody,
Appreciate the responses and ideas! Thad Esser noted that this is
deceptively simple, and it is (d**n brain-lock on my part). Now, off to
the lab with some different approaches to try.
Thank you!
Joseph Kasell
Senior Systems Engineer
Navy Federal Credit Union
"Kemes, Lisa"
<lisa.ke...@tycoe
LECTRONICS.COM> To
Sent by: "Action arslist@ARSLIST.ORG
Request System cc
discussion list
(ARSList)" Subject
<arsl...@arslist. Re: Reservation/Scheduling in ARS
ORG>
07/01/2009 08:53
AM
Please respond to
arsl...@arslist.o
RG
--_000_46CDC1E68702E54387E9EAEDC0A02CA207C2FF1993us194mx002tyc_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
I have an On Call system that I created that checks to make sure when
someo=
ne adds a person to the schedule that it does not conflict with what's
alre=
ady out there.
I have them fill out Start Date and an End Date (these are Date/Time
Fields=
). Have them click on submit that kicks of an active link Guide that
loops=
through the table of the On Call Schedule.
The first AL in the ALG sets the column Start Date and column End Date
fiel=
ds to temporary fields (from the on call schedule table) (tmp_StartDate
and=
tmp_EndDate)
Then the second AL in the ALG simply makes sure that the Start Date and
End=
Date fields do not over lap ( 'Start Date' < 'tmp_EndDate') AND ( 'End
Dat=
e' > 'tmp_StartDate')
If they do, I have a tmp_answer field that says "Allow" or "Not Allow"
The third AL in the ALG checks to see if that field (tmp_answer) equals
"No=
t Allow" if at any time it does say "Not Allow" then an error message
pop=
s up and the ALG is exited.
Hope this helps....
Lisa
________________________________
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslis=
T.ORG] On Behalf Of Joe DeSouza
Sent: Tuesday, June 30, 2009 4:42 PM
To: arslist@ARSLIST.ORG
Subject: Re: Reservation/Scheduling in ARS
**
Joseph,
I had done something similar once. Its not that hard. For something like a
=
reservation system you always invariably have an entity that you need to
re=
serve, be it a room, a car, a seat in an aircraft or a bus, whatever, for
a=
blocked period of time during which no one should be allowed to be able
to=
access it.
You need to check against both this entity and the start and end time
that=
these do not clash with any combination of start and end time for the
same=
entity.
You also might want to design a wait list or a preferential queue, for
cust=
omers requesting for the same entity, when it has already been booked in
th=
e event of a cancelation. And have this queue adjusted as and when they
adj=
ust their itenery, or the end date has passed whichever happens earlier.
Joe
________________________________
From: Joseph Kasell <joseph_kas...@navyfederal.org>
To: arslist@ARSLIST.ORG
Sent: Tuesday, June 30, 2009 2:35:17 PM
Subject: Reservation/Scheduling in ARS
Hello!
I wanted to canvass the group for ideas on the following scenario.
One of our users is wanting to set up a scheduling/reservation system in
Re=
medy for an application he manages, which has a finite number of accounts.
=
What he'd like is a means for a user to sign up for account access to the
=
app by blocking out a period of time. Should another person sign up for
th=
at account during that time block, he/she would get a popup indicating a
co=
nflict. I'm wondering if somebody out there has designed something which
a=
ccomplishes this. Also, I don't have the funds to purchase a third-party
s=
olution, so that's out (things being what they are, our belts are tight
her=
e as well). We're using ARS 7.0.01 and ITSM 6.
Appreciate the help!
Joseph Kasell
Senior Systems Engineer
Navy Federal Credit Union
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are=
"_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
--_000_46CDC1E68702E54387E9EAEDC0A02CA207C2FF1993us194mx002tyc_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
**
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.6000.16825" name=3DGENERATOR></HEAD>
<BODY>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D344184812-01072009><FONT
face=3DA=
rial=20
color=3D#000080 size=3D2>I have an On Call system that I created that
check=
s to make=20
sure when someone adds a person to the schedule that it does not conflict
w=
ith=20
what's already out there.</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D344184812-01072009><FONT
face=3DA=
rial=20
color=3D#000080 size=3D2></FONT></SPAN> </DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D344184812-01072009><FONT
face=3DA=
rial=20
color=3D#000080 size=3D2>I have them fill out Start Date and an End Date
(t=
hese are=20
Date/Time Fields). Have them click on submit that kicks of an active
=
link=20
Guide that loops through the table of the On Call
Schedule.</FONT></SPAN></=
DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D344184812-01072009><FONT
face=3DA=
rial=20
color=3D#000080 size=3D2></FONT></SPAN> </DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D344184812-01072009><FONT
face=3DA=
rial=20
color=3D#000080 size=3D2>The first AL in the ALG sets the column Start
Date=
and=20
column End Date fields to temporary fields (from the on call schedule
table=
)=20
(tmp_StartDate and tmp_EndDate)</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D344184812-01072009><FONT
face=3DA=
rial=20
color=3D#000080 size=3D2></FONT></SPAN> </DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D344184812-01072009><FONT
face=3DA=
rial=20
color=3D#000080 size=3D2>Then the second AL in the ALG simply makes sure
th=
at the=20
Start Date and End Date fields do not over lap ( 'Start Date' <=20
'tmp_EndDate') AND ( 'End Date' > 'tmp_StartDate')</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D344184812-01072009><FONT
face=3DA=
rial=20
color=3D#000080 size=3D2></FONT></SPAN> </DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D344184812-01072009><FONT
face=3DA=
rial=20
color=3D#000080 size=3D2>If they do, I have a tmp_answer field that says
"A=
llow" or=20
"Not Allow"</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D344184812-01072009><FONT
face=3DA=
rial=20
color=3D#000080 size=3D2></FONT></SPAN> </DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D344184812-01072009><FONT
face=3DA=
rial=20
color=3D#000080 size=3D2>The third AL in the ALG checks to see if that
fiel=
d=20
(tmp_answer) equals "Not Allow" if at any time it does say
"Not=
=20
Allow" then an error message pops up and the ALG is
exited.</FONT></SPAN></=
DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D344184812-01072009><FONT
face=3DA=
rial=20
color=3D#000080 size=3D2></FONT></SPAN> </DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D344184812-01072009><FONT
face=3DA=
rial=20
color=3D#000080 size=3D2>Hope this helps....</FONT></SPAN></DIV>
<DIV> </DIV><!-- Converted from text/rtf format -->
<P><SPAN lang=3Den-us><FONT face=3DArial color=3D#000080
size=3D2>Lisa</FON=
T></SPAN>=20
</P>
<DIV> </DIV><BR>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft>
<HR tabIndex=3D-1>
<FONT face=3DTahoma size=3D2><B>From:</B> Action Request System discussion=
=20
list(ARSList) [mailto:arsl...@arslist.org] <B>On Behalf Of </B>Joe=20
DeSouza<BR><B>Sent:</B> Tuesday, June 30, 2009 4:42 PM<BR><B>To:</B>=20
arslist@ARSLIST.ORG<BR><B>Subject:</B> Re: Reservation/Scheduling in=20
ARS<BR></FONT><BR></DIV>
<DIV></DIV>**=20
<STYLE type=3Dtext/css>DIV {
MARGIN: 0px
}
</STYLE>
<DIV=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Courier New, courier, monaco,
monosp=
ace, sans-serif">
<DIV>Joseph,</DIV>
<DIV> </DIV>
<DIV>I had done something similar once. Its not that hard. For something
li=
ke a=20
reservation system you always invariably have an entity that you need to=20
reserve, be it a room, a car, a seat in an aircraft or a bus, whatever,
for=
a=20
blocked period of time during which no one should be allowed to be able to=
=20
access it.</DIV>
<DIV> </DIV>
<DIV>You need to check against both this entity and the start and end
time&=
nbsp;=20
that these do not clash with any combination of start and end time for the
=
same=20
entity.</DIV>
<DIV> </DIV>
<DIV>You also might want to design a wait list or a preferential queue,
for=
=20
customers requesting for the same entity, when it has already been booked
i=
n the=20
event of a cancelation. And have this queue adjusted as and when they
adjus=
t=20
their itenery, or the end date has passed whichever happens earlier.</DIV>
<DIV> </DIV>
<DIV>Joe<BR></DIV>
<DIV=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Courier New, courier, monaco,
monosp=
ace, sans-serif">
<DIV=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: times new roman, new york, times,
se=
rif"><FONT=20
face=3DTahoma size=3D2>
<HR SIZE=3D1>
<B><SPAN style=3D"FONT-WEIGHT: bold">From:</SPAN></B> Joseph Kasell=20
<joseph_kas...@navyfederal.org><BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">To:</SPAN></B> arslist@ARSLIST.ORG<BR><B><SPAN=
=20
style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B> Tuesday, June 30, 2009
2:35:17=
=20
PM<BR><B><SPAN style=3D"FONT-WEIGHT: bold">Subject:</SPAN></B>=20
Reservation/Scheduling in ARS<BR></FONT><BR>Hello!<BR><BR>I wanted to
canva=
ss=20
the group for ideas on the following scenario.<BR><BR>One of our users
is=20
wanting to set up a scheduling/reservation system in Remedy for an
applicat=
ion=20
he manages, which has a finite number of accounts. What he'd like is
=
a=20
means for a user to sign up for account access to the app by blocking out
a=
=20
period of time. Should another person sign up for that account
during=
that=20
time block, he/she would get a popup indicating a conflict. I'm
wonde=
ring=20
if somebody out there has designed something which accomplishes
this. =
=20
Also, I don't have the funds to purchase a third-party solution, so that's
=
out=20
(things being what they are, our belts are tight here as well).
We're=
=20
using ARS 7.0.01 and ITSM 6.<BR>Appreciate the help!<BR><BR>Joseph=20
Kasell<BR>Senior Systems Engineer<BR>Navy Federal Credit=20
Union</DIV></DIV></DIV><BR>_Platinum Sponsor: rmisoluti...@verizon.net
ARSl=
ist:=20
"Where the Answers Are"_</BODY></HTML>
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_
--_000_46CDC1E68702E54387E9EAEDC0A02CA207C2FF1993us194mx002tyc_--
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
