Remedy and Cold Fusion - MattReinfeldt.com - Remedy Discussion Site

You are not logged in. [Log In] MattReinfeldt.com » Forums » ARSList Archives » Archives - 2001 » Remedy and Cold Fusion

Page 1 of 3

1

Topic Options

Rate This Topic

#45002 - 03/28/01 02:49 PM Remedy and Cold Fusion
bmcmillan Stealth Member Registered: 06/12/01 Posts: 10	We are attempting to provide a web-based user tool using Cold Fusion. Has anyone ever been able to read and submit request through Cold Fusion? Our developer is building a "read-only" view reading directly from the underlying database tables, but we want users to be able to use the interface just like the ARS User Client. (same functionality and appearance). Advise?? Bethel McMillan (Mac) Applications Specialist - Remedy Xypoint Corporation (206) 674-1094 (253) 208-2164 (cell) http://www.xypoint.com _____________________________
Top

#45003 - 03/28/01 02:55 PM Re: Remedy and Cold Fusion [Re: anschutz]
gsundt Stealth Member Registered: 06/12/01 Posts: 52	I can only tell you what I was told in the ARWeb class: Web authoring tools are nice, but don't always sync with AR System workflow. For more info, you would have to contact the instructor, or Remedy Tech Support. _____________________________
Top

#45004 - 03/28/01 03:11 PM Re: Remedy and Cold Fusion [Re: anschutz]
mohit jain Stealth Member Registered: 06/12/01 Posts: 71	You can build a web interface using CGI. and use ARS Perl to submit and modify requests. Mohit S. Jain User Support Engineering Group Voice 212-855-0251 Fax 212-493-0170 Email Mohit.Jain@gs.com -----Original Message----- From: Mac McMillan [mailto:BMcMillan@XYPOINT.COM] Sent: 28 March, 2001 15:49 To: ARSLIST@LISTSERV.VISTAIT.COM Subject: Remedy and Cold Fusion ** We are attempting to provide a web-based user tool using Cold Fusion. Has anyone ever been able to read and submit request through Cold Fusion? Our developer is building a "read-only" view reading directly from the underlying database tables, but we want users to be able to use the interface just like the ARS User Client. (same functionality and appearance). Advise?? Bethel McMillan (Mac) Applications Specialist - Remedy Xypoint Corporation (206) 674-1094 (253) 208-2164 (cell) http://www.xypoint.com ________________ _____________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________
Top

#45005 - 03/28/01 03:33 PM Re: Remedy and Cold Fusion [Re: anschutz]
refaey Stealth Member Registered: 06/12/01 Posts: 189	Hi Bathel, It's very hard to do it using Cold Fusion 'cause you have to know every little detail about how remedy stores data in the database tables. Even if you did that, you can not guarantee compatibility with other versions of remedy because the way remedy stores data in the database is not documented, so remedy can change it anytime, and in that case your application will stop working if you decided to use that new version of remedy. It's like the old game that Microsoft used to play by using undocumented functions in their Windows and Office applications and then used this to make DR-DOS incompatible with Windows. Anyway, as far as I know, you have two choices here: 1. Using Perl CGI, with ARSPerl 2. Using ASP, with www.croomweb.com 3. Using remedy web products (I don't think you wanna do that). Your Cold Fusion programmer should find using ARSPerl very easy. Best regards, Ashraf Elrefaey Remedy Consultant Workflow Solutions Ltd * Phone: +64 4 385 2885 * Cellular: +64 21 377523 * Fax: +64 4 385 2911 * E-Mail: mailto:refaey@workflow.co.nz 1 Webpage: http://www.workflow.co.nz -----Original Message----- From: Mac McMillan [mailto:BMcMillan@XYPOINT.COM] Sent: Thu, 29 March 2001 08:49 To: ARSLIST@LISTSERV.VISTAIT.COM Subject: Remedy and Cold Fusion ** We are attempting to provide a web-based user tool using Cold Fusion. Has anyone ever been able to read and submit request through Cold Fusion? Our developer is building a "read-only" view reading directly from the underlying database tables, but we want users to be able to use the interface just like the ARS User Client. (same functionality and appearance). Advise?? Bethel McMillan (Mac) Applications Specialist - Remedy Xypoint Corporation (206) 674-1094 (253) 208-2164 (cell) http://www.xypoint.com ________________ _____________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________
Top

#45006 - 03/28/01 03:10 PM Re: Remedy and Cold Fusion [Re: anschutz]
ravi bommareddy Stealth Member Registered: 06/12/01 Posts: 248	Beth, It's doable and we're planing to use web app developed with CF or Vis. IntDev. ( using the existing Remedy DB), so that we can eliminate Remedy Lic fee every year. You can do Inserts, Updates and deletes with Coldfusion ( you nedd CF app server too). But, you might miss all tose notification events, and you have to mimic all Remedy inserts during a call insert into a form. I mean Remedy inserts the records to more than one for form( a HD call goes to two forms), so you have to be careful to impliment the entire functionality. Regards... Ravi Mac McMillan @LISTSERV.VISTAIT.COM> on 03/28/2001 04:49:02 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Remedy and Cold Fusion ** We are attempting to provide a web-based user tool using Cold Fusion. Has anyone ever been able to read and submit request through Cold Fusion? Our developer is building a "read-only" view reading directly from the underlying database tables, but we want users to be able to use the interface just like the ARS User Client. (same functionality and appearance). Advise?? Bethel McMillan (Mac) Applications Specialist - Remedy Xypoint Corporation (206) 674-1094 (253) 208-2164 (cell) http://www.xypoint.com _____________________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________
Top

#45007 - 03/28/01 03:46 PM Re: Remedy and Cold Fusion [Re: anschutz]
refaey Stealth Member Registered: 06/12/01 Posts: 189	Ravi, If you're going to do all of this, wasn't it better to build your application from scratch rather than using remedy?, just a thought :-) Ashraf Elrefaey Remedy Consultant Workflow Solutions Ltd * Phone: +64 4 385 2885 * Cellular: +64 21 377523 * Fax: +64 4 385 2911 * E-Mail: mailto:refaey@workflow.co.nz 1 Webpage: http://www.workflow.co.nz -----Original Message----- From: Ravi Bommareddy [mailto:Ravi.Bommareddy@JWT.COM] Sent: Thu, 29 March 2001 09:11 To: ARSLIST@LISTSERV.VISTAIT.COM Subject: Re: Remedy and Cold Fusion Beth, It's doable and we're planing to use web app developed with CF or Vis. IntDev. ( using the existing Remedy DB), so that we can eliminate Remedy Lic fee every year. You can do Inserts, Updates and deletes with Coldfusion ( you nedd CF app server too). But, you might miss all tose notification events, and you have to mimic all Remedy inserts during a call insert into a form. I mean Remedy inserts the records to more than one for form( a HD call goes to two forms), so you have to be careful to impliment the entire functionality. Regards... Ravi Mac McMillan @LISTSERV.VISTAIT.COM> on 03/28/2001 04:49:02 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Remedy and Cold Fusion We are attempting to provide a web-based user tool using Cold Fusion. Has anyone ever been able to read and submit request through Cold Fusion? Our developer is building a "read-only" view reading directly from the underlying database tables, but we want users to be able to use the interface just like the ARS User Client. (same functionality and appearance). Advise?? Bethel McMillan (Mac) Applications Specialist - Remedy Xypoint Corporation (206) 674-1094 (253) 208-2164 (cell) http://www.xypoint.com ________________ _____________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org ________________ _____________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________
Top

#45008 - 03/28/01 04:15 PM Re: Remedy and Cold Fusion [Re: anschutz]
greg gibson Stealth Member Registered: 06/12/01 Posts: 128	You do NOT want to use Cold Fusion or any other product to "INSERT" a new ticket. You DO want to use ARSperl or the API to create a new ticket. That's because their are other factors, i.e. the next Ticket id number is stored in Remedy tables. Ravi Bommareddy @LISTSERV.VISTAIT.COM> on 03/28/2001 01:10:48 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Beth, It's doable and we're planing to use web app developed with CF or Vis. IntDev. ( using the existing Remedy DB), so that we can eliminate Remedy Lic fee every year. You can do Inserts, Updates and deletes with Coldfusion ( you nedd CF app server too). But, you might miss all tose notification events, and you have to mimic all Remedy inserts during a call insert into a form. I mean Remedy inserts the records to more than one for form( a HD call goes to two forms), so you have to be careful to impliment the entire functionality. Regards... Ravi Mac McMillan @LISTSERV.VISTAIT.COM> on 03/28/2001 04:49:02 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Remedy and Cold Fusion We are attempting to provide a web-based user tool using Cold Fusion. Has anyone ever been able to read and submit request through Cold Fusion? Our developer is building a "read-only" view reading directly from the underlying database tables, but we want users to be able to use the interface just like the ARS User Client. (same functionality and appearance). Advise?? Bethel McMillan (Mac) Applications Specialist - Remedy Xypoint Corporation (206) 674-1094 (253) 208-2164 (cell) http://www.xypoint.com _____________________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________
Top

#45009 - 03/28/01 04:19 PM Re: Remedy and Cold Fusion [Re: anschutz]
ravi bommareddy Stealth Member Registered: 06/12/01 Posts: 248	Greg, Even that NEXT ID thing can be done with CF or any other web dev. tool Regards.. Ravi Greg Gibson @LISTSERV.VISTAIT.COM> on 03/28/2001 06:15:49 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion You do NOT want to use Cold Fusion or any other product to "INSERT" a new ticket. You DO want to use ARSperl or the API to create a new ticket. That's because their are other factors, i.e. the next Ticket id number is stored in Remedy tables. Ravi Bommareddy @LISTSERV.VISTAIT.COM> on 03/28/2001 01:10:48 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Beth, It's doable and we're planing to use web app developed with CF or Vis. IntDev. ( using the existing Remedy DB), so that we can eliminate Remedy Lic fee every year. You can do Inserts, Updates and deletes with Coldfusion ( you nedd CF app server too). But, you might miss all tose notification events, and you have to mimic all Remedy inserts during a call insert into a form. I mean Remedy inserts the records to more than one for form( a HD call goes to two forms), so you have to be careful to impliment the entire functionality. Regards... Ravi Mac McMillan @LISTSERV.VISTAIT.COM> on 03/28/2001 04:49:02 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Remedy and Cold Fusion ** We are attempting to provide a web-based user tool using Cold Fusion. Has anyone ever been able to read and submit request through Cold Fusion? Our developer is building a "read-only" view reading directly from the underlying database tables, but we want users to be able to use the interface just like the ARS User Client. (same functionality and appearance). Advise?? Bethel McMillan (Mac) Applications Specialist - Remedy Xypoint Corporation (206) 674-1094 (253) 208-2164 (cell) http://www.xypoint.com _____________________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________
Top

#45010 - 03/28/01 04:16 PM Re: Remedy and Cold Fusion [Re: anschutz]
ravi bommareddy Stealth Member Registered: 06/12/01 Posts: 248	Asgraf.. Your absolutly right, we're using base tables only, also lot of columns will get deleted. ex: HD table We won't follow the Remedy's Business rules, so we don't have to worry Remedy ref. tables. We create our primary and foriegn keys and look up tables. The reason we're using is, the HD, CM and Am are simpler, and we can use the main tables. I just copy the table SQL create script from Remedy DB and run it to create the table new DB. My clients got pissed off with Remedy Support pricing system.. Regards... Ravi Ashraf Elrefaey @LISTSERV.VISTAIT.COM> on 03/28/2001 05:46:30 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion ** Ravi, If you're going to do all of this, wasn't it better to build your application from scratch rather than using remedy?, just a thought :-) Ashraf Elrefaey Remedy Consultant Workflow Solutions Ltd * Phone: +64 4 385 2885 * Cellular: +64 21 377523 * Fax: +64 4 385 2911 * E-Mail: mailto:refaey@workflow.co.nz 1 Webpage: http://www.workflow.co.nz -----Original Message----- From: Ravi Bommareddy [mailto:Ravi.Bommareddy@JWT.COM] Sent: Thu, 29 March 2001 09:11 To: ARSLIST@LISTSERV.VISTAIT.COM Subject: Re: Remedy and Cold Fusion Beth, It's doable and we're planing to use web app developed with CF or Vis. IntDev. ( using the existing Remedy DB), so that we can eliminate Remedy Lic fee every year. You can do Inserts, Updates and deletes with Coldfusion ( you nedd CF app server too). But, you might miss all tose notification events, and you have to mimic all Remedy inserts during a call insert into a form. I mean Remedy inserts the records to more than one for form( a HD call goes to two forms), so you have to be careful to impliment the entire functionality. Regards... Ravi Mac McMillan @LISTSERV.VISTAIT.COM> on 03/28/2001 04:49:02 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Remedy and Cold Fusion We are attempting to provide a web-based user tool using Cold Fusion. Has anyone ever been able to read and submit request through Cold Fusion? Our developer is building a "read-only" view reading directly from the underlying database tables, but we want users to be able to use the interface just like the ARS User Client. (same functionality and appearance). Advise?? Bethel McMillan (Mac) Applications Specialist - Remedy Xypoint Corporation (206) 674-1094 (253) 208-2164 (cell) http://www.xypoint.com ________________ _____________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org ________________ _____________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________
Top

#45011 - 03/28/01 05:01 PM Re: Remedy and Cold Fusion [Re: anschutz]
greg gibson Stealth Member Registered: 06/12/01 Posts: 128	Yes it can but, if you use SQL to modify NEXT ID, you have to be concerned that you are not modifying NextId at the same time Remedy is trying to modify Next Id. Ravi Bommareddy @LISTSERV.VISTAIT.COM> on 03/28/2001 02:19:58 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Greg, Even that NEXT ID thing can be done with CF or any other web dev. tool Regards.. Ravi Greg Gibson @LISTSERV.VISTAIT.COM> on 03/28/2001 06:15:49 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion You do NOT want to use Cold Fusion or any other product to "INSERT" a new ticket. You DO want to use ARSperl or the API to create a new ticket. That's because their are other factors, i.e. the next Ticket id number is stored in Remedy tables. Ravi Bommareddy @LISTSERV.VISTAIT.COM> on 03/28/2001 01:10:48 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Beth, It's doable and we're planing to use web app developed with CF or Vis. IntDev. ( using the existing Remedy DB), so that we can eliminate Remedy Lic fee every year. You can do Inserts, Updates and deletes with Coldfusion ( you nedd CF app server too). But, you might miss all tose notification events, and you have to mimic all Remedy inserts during a call insert into a form. I mean Remedy inserts the records to more than one for form( a HD call goes to two forms), so you have to be careful to impliment the entire functionality. Regards... Ravi Mac McMillan @LISTSERV.VISTAIT.COM> on 03/28/2001 04:49:02 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Remedy and Cold Fusion We are attempting to provide a web-based user tool using Cold Fusion. Has anyone ever been able to read and submit request through Cold Fusion? Our developer is building a "read-only" view reading directly from the underlying database tables, but we want users to be able to use the interface just like the ARS User Client. (same functionality and appearance). Advise?? Bethel McMillan (Mac) Applications Specialist - Remedy Xypoint Corporation (206) 674-1094 (253) 208-2164 (cell) http://www.xypoint.com _____________________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________
Top

#45012 - 03/29/01 09:30 AM Re: Remedy and Cold Fusion [Re: anschutz]
ravi bommareddy Stealth Member Registered: 06/12/01 Posts: 248	I just want to know how Remedy solving this concurency issue ( NextID ) when more than one user creating calls at the same time? Regards.. Greg Gibson @LISTSERV.VISTAIT.COM> on 03/28/2001 07:01:30 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Yes it can but, if you use SQL to modify NEXT ID, you have to be concerned that you are not modifying NextId at the same time Remedy is trying to modify Next Id. Ravi Bommareddy @LISTSERV.VISTAIT.COM> on 03/28/2001 02:19:58 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Greg, Even that NEXT ID thing can be done with CF or any other web dev. tool Regards.. Ravi Greg Gibson @LISTSERV.VISTAIT.COM> on 03/28/2001 06:15:49 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion You do NOT want to use Cold Fusion or any other product to "INSERT" a new ticket. You DO want to use ARSperl or the API to create a new ticket. That's because their are other factors, i.e. the next Ticket id number is stored in Remedy tables. Ravi Bommareddy @LISTSERV.VISTAIT.COM> on 03/28/2001 01:10:48 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Beth, It's doable and we're planing to use web app developed with CF or Vis. IntDev. ( using the existing Remedy DB), so that we can eliminate Remedy Lic fee every year. You can do Inserts, Updates and deletes with Coldfusion ( you nedd CF app server too). But, you might miss all tose notification events, and you have to mimic all Remedy inserts during a call insert into a form. I mean Remedy inserts the records to more than one for form( a HD call goes to two forms), so you have to be careful to impliment the entire functionality. Regards... Ravi Mac McMillan @LISTSERV.VISTAIT.COM> on 03/28/2001 04:49:02 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Remedy and Cold Fusion ** We are attempting to provide a web-based user tool using Cold Fusion. Has anyone ever been able to read and submit request through Cold Fusion? Our developer is building a "read-only" view reading directly from the underlying database tables, but we want users to be able to use the interface just like the ARS User Client. (same functionality and appearance). Advise?? Bethel McMillan (Mac) Applications Specialist - Remedy Xypoint Corporation (206) 674-1094 (253) 208-2164 (cell) http://www.xypoint.com _____________________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________
Top

#45013 - 03/29/01 10:00 AM Re: Remedy and Cold Fusion [Re: anschutz]
Anonymous Unregistered	Transaction control in the database. -- Jarl Groneng jarl@nextra.com http://www.arutil.com > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Ravi Bommareddy > Sent: 29. mars 2001 17:31 > To: ARSLIST@LISTSERV.VISTAIT.COM > Subject: Re: Remedy and Cold Fusion > > > > > I just want to know how Remedy solving this concurency issue ( > NextID ) when > more than one user creating calls at the same time? > Regards.. > > > > > > Greg Gibson @LISTSERV.VISTAIT.COM> on > 03/28/2001 07:01:30 > PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > Subject: Re: Remedy and Cold Fusion > > > > > Yes it can but, if you use SQL to modify NEXT ID, you have to be concerned > that you are not modifying > NextId at the same time Remedy is trying to modify Next Id. > > > > > Ravi Bommareddy @LISTSERV.VISTAIT.COM> on > 03/28/2001 02:19:58 PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > > Subject: Re: Remedy and Cold Fusion > > > > > Greg, > Even that NEXT ID thing can be done with CF or any other web dev. tool > Regards.. > Ravi > > > > > > Greg Gibson @LISTSERV.VISTAIT.COM> on 03/28/2001 > 06:15:49 > PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > Subject: Re: Remedy and Cold Fusion > > > > > You do NOT want to use Cold Fusion or any other product to "INSERT" a new > ticket. > You DO want to use ARSperl or the API to create a new ticket. That's > because their are other factors, i.e. > the next Ticket id number is stored in Remedy tables. > > > > > Ravi Bommareddy @LISTSERV.VISTAIT.COM> on > 03/28/2001 01:10:48 PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > > Subject: Re: Remedy and Cold Fusion > > > > > Beth, > It's doable and we're planing to use web app developed with CF or Vis. > IntDev. > ( using the existing Remedy DB), so that we can eliminate Remedy Lic fee > every > year. > You can do Inserts, Updates and deletes with Coldfusion ( you nedd CF app > server > too). But, you might miss all tose notification events, and you have to > mimic > all Remedy inserts during a call insert into a form. I mean Remedy inserts > the > records to more than one for form( a HD call goes to two forms), so you > have to > be careful to impliment the entire functionality. > Regards... > Ravi > > > > > > Mac McMillan @LISTSERV.VISTAIT.COM> on 03/28/2001 > 04:49:02 PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > Subject: Remedy and Cold Fusion > > > > > We are attempting to provide a web-based user tool using Cold Fusion. > > Has anyone ever been able to read and submit request through Cold Fusion? > Our developer is building a "read-only" view reading directly from the > underlying database tables, but we want users to be able to use the > interface just like the ARS User Client. (same functionality and > appearance). > > Advise?? > > Bethel McMillan (Mac) > Applications Specialist - Remedy > Xypoint Corporation > > (206) 674-1094 > (253) 208-2164 (cell) > > http://www.xypoint.com > > ______ > _______________________ > > > > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > You may also control your subscription options, including > UNSUBSCRIBE, at www.ARSLIST.org > > _____________________________
Top

#45014 - 03/29/01 10:15 AM Re: Remedy and Cold Fusion [Re: anschutz]
ravi bommareddy Stealth Member Registered: 06/12/01 Posts: 248	Then, no problem using CF. I don't see any NEW problem using CF and Remedy together, because DB will take care of Next ID issue. Or, You can set up reocrd lock, so the other transaction will wait for Next ID Regards.. Ravi Jarl Groneng @LISTSERV.VISTAIT.COM> on 03/29/2001 12:00:44 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Transaction control in the database. -- Jarl Groneng jarl@nextra.com http://www.arutil.com > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Ravi Bommareddy > Sent: 29. mars 2001 17:31 > To: ARSLIST@LISTSERV.VISTAIT.COM > Subject: Re: Remedy and Cold Fusion > > > > > I just want to know how Remedy solving this concurency issue ( > NextID ) when > more than one user creating calls at the same time? > Regards.. > > > > > > Greg Gibson @LISTSERV.VISTAIT.COM> on > 03/28/2001 07:01:30 > PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > Subject: Re: Remedy and Cold Fusion > > > > > Yes it can but, if you use SQL to modify NEXT ID, you have to be concerned > that you are not modifying > NextId at the same time Remedy is trying to modify Next Id. > > > > > Ravi Bommareddy @LISTSERV.VISTAIT.COM> on > 03/28/2001 02:19:58 PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > > Subject: Re: Remedy and Cold Fusion > > > > > Greg, > Even that NEXT ID thing can be done with CF or any other web dev. tool > Regards.. > Ravi > > > > > > Greg Gibson @LISTSERV.VISTAIT.COM> on 03/28/2001 > 06:15:49 > PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > Subject: Re: Remedy and Cold Fusion > > > > > You do NOT want to use Cold Fusion or any other product to "INSERT" a new > ticket. > You DO want to use ARSperl or the API to create a new ticket. That's > because their are other factors, i.e. > the next Ticket id number is stored in Remedy tables. > > > > > Ravi Bommareddy @LISTSERV.VISTAIT.COM> on > 03/28/2001 01:10:48 PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > > Subject: Re: Remedy and Cold Fusion > > > > > Beth, > It's doable and we're planing to use web app developed with CF or Vis. > IntDev. > ( using the existing Remedy DB), so that we can eliminate Remedy Lic fee > every > year. > You can do Inserts, Updates and deletes with Coldfusion ( you nedd CF app > server > too). But, you might miss all tose notification events, and you have to > mimic > all Remedy inserts during a call insert into a form. I mean Remedy inserts > the > records to more than one for form( a HD call goes to two forms), so you > have to > be careful to impliment the entire functionality. > Regards... > Ravi > > > > > > Mac McMillan @LISTSERV.VISTAIT.COM> on 03/28/2001 > 04:49:02 PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > Subject: Remedy and Cold Fusion > > > ** > > We are attempting to provide a web-based user tool using Cold Fusion. > > Has anyone ever been able to read and submit request through Cold Fusion? > Our developer is building a "read-only" view reading directly from the > underlying database tables, but we want users to be able to use the > interface just like the ARS User Client. (same functionality and > appearance). > > Advise?? > > Bethel McMillan (Mac) > Applications Specialist - Remedy > Xypoint Corporation > > (206) 674-1094 > (253) 208-2164 (cell) > > http://www.xypoint.com > > ______ > _______________________ > > > > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > You may also control your subscription options, including > UNSUBSCRIBE, at www.ARSLIST.org > > _____________________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________
Top

#45015 - 03/29/01 11:46 AM Re: Remedy and Cold Fusion [Re: anschutz]
greg gibson Stealth Member Registered: 06/12/01 Posts: 128	Wrong. example. Your app and Remedy get the Next Id value at the same time. Both apps think they have the correct value. Both apps use the same Id and both will increment and update Next Id. Ravi Bommareddy @LISTSERV.VISTAIT.COM> on 03/29/2001 08:15:12 AM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Then, no problem using CF. I don't see any NEW problem using CF and Remedy together, because DB will take care of Next ID issue. Or, You can set up reocrd lock, so the other transaction will wait for Next ID Regards.. Ravi Jarl Groneng @LISTSERV.VISTAIT.COM> on 03/29/2001 12:00:44 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Transaction control in the database. -- Jarl Groneng jarl@nextra.com http://www.arutil.com > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Ravi Bommareddy > Sent: 29. mars 2001 17:31 > To: ARSLIST@LISTSERV.VISTAIT.COM > Subject: Re: Remedy and Cold Fusion > > > > > I just want to know how Remedy solving this concurency issue ( > NextID ) when > more than one user creating calls at the same time? > Regards.. > > > > > > Greg Gibson @LISTSERV.VISTAIT.COM> on > 03/28/2001 07:01:30 > PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > Subject: Re: Remedy and Cold Fusion > > > > > Yes it can but, if you use SQL to modify NEXT ID, you have to be concerned > that you are not modifying > NextId at the same time Remedy is trying to modify Next Id. > > > > > Ravi Bommareddy @LISTSERV.VISTAIT.COM> on > 03/28/2001 02:19:58 PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > > Subject: Re: Remedy and Cold Fusion > > > > > Greg, > Even that NEXT ID thing can be done with CF or any other web dev. tool > Regards.. > Ravi > > > > > > Greg Gibson @LISTSERV.VISTAIT.COM> on 03/28/2001 > 06:15:49 > PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > Subject: Re: Remedy and Cold Fusion > > > > > You do NOT want to use Cold Fusion or any other product to "INSERT" a new > ticket. > You DO want to use ARSperl or the API to create a new ticket. That's > because their are other factors, i.e. > the next Ticket id number is stored in Remedy tables. > > > > > Ravi Bommareddy @LISTSERV.VISTAIT.COM> on > 03/28/2001 01:10:48 PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > > Subject: Re: Remedy and Cold Fusion > > > > > Beth, > It's doable and we're planing to use web app developed with CF or Vis. > IntDev. > ( using the existing Remedy DB), so that we can eliminate Remedy Lic fee > every > year. > You can do Inserts, Updates and deletes with Coldfusion ( you nedd CF app > server > too). But, you might miss all tose notification events, and you have to > mimic > all Remedy inserts during a call insert into a form. I mean Remedy inserts > the > records to more than one for form( a HD call goes to two forms), so you > have to > be careful to impliment the entire functionality. > Regards... > Ravi > > > > > > Mac McMillan @LISTSERV.VISTAIT.COM> on 03/28/2001 > 04:49:02 PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > Subject: Remedy and Cold Fusion > > > > > We are attempting to provide a web-based user tool using Cold Fusion. > > Has anyone ever been able to read and submit request through Cold Fusion? > Our developer is building a "read-only" view reading directly from the > underlying database tables, but we want users to be able to use the > interface just like the ARS User Client. (same functionality and > appearance). > > Advise?? > > Bethel McMillan (Mac) > Applications Specialist - Remedy > Xypoint Corporation > > (206) 674-1094 > (253) 208-2164 (cell) > > http://www.xypoint.com > > ______ > _______________________ > > > > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > You may also control your subscription options, including > UNSUBSCRIBE, at www.ARSLIST.org > > _____________________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________
Top

#45016 - 03/29/01 12:17 PM Re: Remedy and Cold Fusion [Re: anschutz]
ravi bommareddy Stealth Member Registered: 06/12/01 Posts: 248	Greg, Then tell me how Remedy doing this ( from prev. mail ) > I just want to know how Remedy solving this concurency issue ( > NextID ) when > more than one user creating calls at the same time? > Regards.. Ravi Greg Gibson @LISTSERV.VISTAIT.COM> on 03/29/2001 01:46:42 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Wrong. example. Your app and Remedy get the Next Id value at the same time. Both apps think they have the correct value. Both apps use the same Id and both will increment and update Next Id. Ravi Bommareddy @LISTSERV.VISTAIT.COM> on 03/29/2001 08:15:12 AM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Then, no problem using CF. I don't see any NEW problem using CF and Remedy together, because DB will take care of Next ID issue. Or, You can set up reocrd lock, so the other transaction will wait for Next ID Regards.. Ravi Jarl Groneng @LISTSERV.VISTAIT.COM> on 03/29/2001 12:00:44 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Transaction control in the database. -- Jarl Groneng jarl@nextra.com http://www.arutil.com > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Ravi Bommareddy > Sent: 29. mars 2001 17:31 > To: ARSLIST@LISTSERV.VISTAIT.COM > Subject: Re: Remedy and Cold Fusion > > > > > I just want to know how Remedy solving this concurency issue ( > NextID ) when > more than one user creating calls at the same time? > Regards.. > > > > > > Greg Gibson @LISTSERV.VISTAIT.COM> on > 03/28/2001 07:01:30 > PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > Subject: Re: Remedy and Cold Fusion > > > > > Yes it can but, if you use SQL to modify NEXT ID, you have to be concerned > that you are not modifying > NextId at the same time Remedy is trying to modify Next Id. > > > > > Ravi Bommareddy @LISTSERV.VISTAIT.COM> on > 03/28/2001 02:19:58 PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > > Subject: Re: Remedy and Cold Fusion > > > > > Greg, > Even that NEXT ID thing can be done with CF or any other web dev. tool > Regards.. > Ravi > > > > > > Greg Gibson @LISTSERV.VISTAIT.COM> on 03/28/2001 > 06:15:49 > PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > Subject: Re: Remedy and Cold Fusion > > > > > You do NOT want to use Cold Fusion or any other product to "INSERT" a new > ticket. > You DO want to use ARSperl or the API to create a new ticket. That's > because their are other factors, i.e. > the next Ticket id number is stored in Remedy tables. > > > > > Ravi Bommareddy @LISTSERV.VISTAIT.COM> on > 03/28/2001 01:10:48 PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > > Subject: Re: Remedy and Cold Fusion > > > > > Beth, > It's doable and we're planing to use web app developed with CF or Vis. > IntDev. > ( using the existing Remedy DB), so that we can eliminate Remedy Lic fee > every > year. > You can do Inserts, Updates and deletes with Coldfusion ( you nedd CF app > server > too). But, you might miss all tose notification events, and you have to > mimic > all Remedy inserts during a call insert into a form. I mean Remedy inserts > the > records to more than one for form( a HD call goes to two forms), so you > have to > be careful to impliment the entire functionality. > Regards... > Ravi > > > > > > Mac McMillan @LISTSERV.VISTAIT.COM> on 03/28/2001 > 04:49:02 PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > Subject: Remedy and Cold Fusion > > > ** > > We are attempting to provide a web-based user tool using Cold Fusion. > > Has anyone ever been able to read and submit request through Cold Fusion? > Our developer is building a "read-only" view reading directly from the > underlying database tables, but we want users to be able to use the > interface just like the ARS User Client. (same functionality and > appearance). > > Advise?? > > Bethel McMillan (Mac) > Applications Specialist - Remedy > Xypoint Corporation > > (206) 674-1094 > (253) 208-2164 (cell) > > http://www.xypoint.com > > ______ > _______________________ > > > > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > You may also control your subscription options, including > UNSUBSCRIBE, at www.ARSLIST.org > > _____________________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________
Top

#45017 - 03/29/01 01:44 PM Re: Remedy and Cold Fusion [Re: anschutz]
greg gibson Stealth Member Registered: 06/12/01 Posts: 128	I don't really know, here is my guess. When they need a new Next Id, each Remedy process must ask the traffic control process (arservtcd) for a Next Id. Arservtcd is probably the only process allowed to manage (i.e select, update) the Next Id field. Ravi Bommareddy @LISTSERV.VISTAIT.COM> on 03/29/2001 10:17:41 AM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Greg, Then tell me how Remedy doing this ( from prev. mail ) > I just want to know how Remedy solving this concurency issue ( > NextID ) when > more than one user creating calls at the same time? > Regards.. Ravi Greg Gibson @LISTSERV.VISTAIT.COM> on 03/29/2001 01:46:42 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Wrong. example. Your app and Remedy get the Next Id value at the same time. Both apps think they have the correct value. Both apps use the same Id and both will increment and update Next Id. Ravi Bommareddy @LISTSERV.VISTAIT.COM> on 03/29/2001 08:15:12 AM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Then, no problem using CF. I don't see any NEW problem using CF and Remedy together, because DB will take care of Next ID issue. Or, You can set up reocrd lock, so the other transaction will wait for Next ID Regards.. Ravi Jarl Groneng @LISTSERV.VISTAIT.COM> on 03/29/2001 12:00:44 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Transaction control in the database. -- Jarl Groneng jarl@nextra.com http://www.arutil.com > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Ravi Bommareddy > Sent: 29. mars 2001 17:31 > To: ARSLIST@LISTSERV.VISTAIT.COM > Subject: Re: Remedy and Cold Fusion > > > > > I just want to know how Remedy solving this concurency issue ( > NextID ) when > more than one user creating calls at the same time? > Regards.. > > > > > > Greg Gibson @LISTSERV.VISTAIT.COM> on > 03/28/2001 07:01:30 > PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > Subject: Re: Remedy and Cold Fusion > > > > > Yes it can but, if you use SQL to modify NEXT ID, you have to be concerned > that you are not modifying > NextId at the same time Remedy is trying to modify Next Id. > > > > > Ravi Bommareddy @LISTSERV.VISTAIT.COM> on > 03/28/2001 02:19:58 PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > > Subject: Re: Remedy and Cold Fusion > > > > > Greg, > Even that NEXT ID thing can be done with CF or any other web dev. tool > Regards.. > Ravi > > > > > > Greg Gibson @LISTSERV.VISTAIT.COM> on 03/28/2001 > 06:15:49 > PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > Subject: Re: Remedy and Cold Fusion > > > > > You do NOT want to use Cold Fusion or any other product to "INSERT" a new > ticket. > You DO want to use ARSperl or the API to create a new ticket. That's > because their are other factors, i.e. > the next Ticket id number is stored in Remedy tables. > > > > > Ravi Bommareddy @LISTSERV.VISTAIT.COM> on > 03/28/2001 01:10:48 PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > > Subject: Re: Remedy and Cold Fusion > > > > > Beth, > It's doable and we're planing to use web app developed with CF or Vis. > IntDev. > ( using the existing Remedy DB), so that we can eliminate Remedy Lic fee > every > year. > You can do Inserts, Updates and deletes with Coldfusion ( you nedd CF app > server > too). But, you might miss all tose notification events, and you have to > mimic > all Remedy inserts during a call insert into a form. I mean Remedy inserts > the > records to more than one for form( a HD call goes to two forms), so you > have to > be careful to impliment the entire functionality. > Regards... > Ravi > > > > > > Mac McMillan @LISTSERV.VISTAIT.COM> on 03/28/2001 > 04:49:02 PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > Subject: Remedy and Cold Fusion > > > > > We are attempting to provide a web-based user tool using Cold Fusion. > > Has anyone ever been able to read and submit request through Cold Fusion? > Our developer is building a "read-only" view reading directly from the > underlying database tables, but we want users to be able to use the > interface just like the ARS User Client. (same functionality and > appearance). > > Advise?? > > Bethel McMillan (Mac) > Applications Specialist - Remedy > Xypoint Corporation > > (206) 674-1094 > (253) 208-2164 (cell) > > http://www.xypoint.com > > ______ > _______________________ > > > > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > You may also control your subscription options, including > UNSUBSCRIBE, at www.ARSLIST.org > > _____________________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________
Top

#45018 - 03/29/01 02:20 PM Re: Remedy and Cold Fusion [Re: anschutz]
jsmith Stealth Member Registered: 06/12/01 Posts: 5	Check out Remedy's knowledge base id #000000000005754 which is quoted here: Category 1 Administration Category 2 Database Full Problem Description How does Remedy determine the next fieldid? Solution In Remedy, this is actually done in memory and you will not see this in logging. To see this for yourself, follow these steps: From the database query tool such as Query Analyzer in MS SQL Server 7 or SQL Plus in Oracle, login as aradmin with a password of ar#admin#. This is with the assumption that the default login id or password have not been changed and will ensure you are running your queries on the ARSystem database. You will need to know the corresponding T table number and name. For instance if I wanted to know the T table number of my Help Desk form I could run the following: select name, schemaid from arschema where name like "HPD%" If you want an entire list of T table numbers and corresponding names, omit the "where" clause: select name, schemaid from arschema Once you know the T table number you can run the following select statement to determine what the next fieldid is on the table (form): select max(fieldid) +1 from field where schemaid = # and fieldid like "53687%" ("#" represents the T table number) NOTE: In SQL Plus for Oracle, you will have to add a ; to the end of the statement and use single quotes instead of double quotes. Conclusion: This is how ARServer determines what the next fieldid is for a form. It is also important to mention that while there is a column called nextfieldid in arschema, and it is updated, it is not used to determine the next fieldid. This column may be used in future but is not utilized at this time. Platform+ Knowledge Base ID 000000000005754 -----Original Message----- From: Greg Gibson [mailto:Greg.Gibson@HSC.COM] Sent: Thursday, March 29, 2001 1:45 PM To: ARSLIST@LISTSERV.VISTAIT.COM Subject: Re: Remedy and Cold Fusion * I don't really know, here is my guess. When they need a new Next Id, each Remedy process must ask the traffic control process (arservtcd) for a Next Id. Arservtcd is probably the only process allowed to manage (i.e select, update) the Next Id field. Ravi Bommareddy @LISTSERV.VISTAIT.COM> on 03/29/2001 10:17:41 AM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Greg, Then tell me how Remedy doing this ( from prev. mail ) > I just want to know how Remedy solving this concurency issue ( > NextID ) when > more than one user creating calls at the same time? > Regards.. Ravi Greg Gibson @LISTSERV.VISTAIT.COM> on 03/29/2001 01:46:42 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Wrong. example. Your app and Remedy get the Next Id value at the same time. Both apps think they have the correct value. Both apps use the same Id and both will increment and update Next Id. Ravi Bommareddy @LISTSERV.VISTAIT.COM> on 03/29/2001 08:15:12 AM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Then, no problem using CF. I don't see any NEW problem using CF and Remedy together, because DB will take care of Next ID issue. Or, You can set up reocrd lock, so the other transaction will wait for Next ID Regards.. Ravi Jarl Groneng @LISTSERV.VISTAIT.COM> on 03/29/2001 12:00:44 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Transaction control in the database. -- Jarl Groneng jarl@nextra.com http://www.arutil.com > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Ravi Bommareddy > Sent: 29. mars 2001 17:31 > To: ARSLIST@LISTSERV.VISTAIT.COM > Subject: Re: Remedy and Cold Fusion > > > > > I just want to know how Remedy solving this concurency issue ( > NextID ) when > more than one user creating calls at the same time? > Regards.. > > > > > > Greg Gibson @LISTSERV.VISTAIT.COM> on > 03/28/2001 07:01:30 > PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > Subject: Re: Remedy and Cold Fusion > > > > > Yes it can but, if you use SQL to modify NEXT ID, you have to be concerned > that you are not modifying > NextId at the same time Remedy is trying to modify Next Id. > > > > > Ravi Bommareddy @LISTSERV.VISTAIT.COM> on > 03/28/2001 02:19:58 PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > > Subject: Re: Remedy and Cold Fusion > > > > > Greg, > Even that NEXT ID thing can be done with CF or any other web dev. tool > Regards.. > Ravi > > > > > > Greg Gibson @LISTSERV.VISTAIT.COM> on 03/28/2001 > 06:15:49 > PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > Subject: Re: Remedy and Cold Fusion > > > > > You do NOT want to use Cold Fusion or any other product to "INSERT" a new > ticket. > You DO want to use ARSperl or the API to create a new ticket. That's > because their are other factors, i.e. > the next Ticket id number is stored in Remedy tables. > > > > > Ravi Bommareddy @LISTSERV.VISTAIT.COM> on > 03/28/2001 01:10:48 PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > > Subject: Re: Remedy and Cold Fusion > > > > > Beth, > It's doable and we're planing to use web app developed with CF or Vis. > IntDev. > ( using the existing Remedy DB), so that we can eliminate Remedy Lic fee > every > year. > You can do Inserts, Updates and deletes with Coldfusion ( you nedd CF app > server > too). But, you might miss all tose notification events, and you have to > mimic > all Remedy inserts during a call insert into a form. I mean Remedy inserts > the > records to more than one for form( a HD call goes to two forms), so you > have to > be careful to impliment the entire functionality. > Regards... > Ravi > > > > > > Mac McMillan @LISTSERV.VISTAIT.COM> on 03/28/2001 > 04:49:02 PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > Subject: Remedy and Cold Fusion > > > > > We are attempting to provide a web-based user tool using Cold Fusion. > > Has anyone ever been able to read and submit request through Cold Fusion? > Our developer is building a "read-only" view reading directly from the > underlying database tables, but we want users to be able to use the > interface just like the ARS User Client. (same functionality and > appearance). > > Advise?? > > Bethel McMillan (Mac) > Applications Specialist - Remedy > Xypoint Corporation > > (206) 674-1094 > (253) 208-2164 (cell) > > http://www.xypoint.com > > ______ > _______________________ > > > > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > You may also control your subscription options, including > UNSUBSCRIBE, at www.ARSLIST.org > > ________________ _____________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org ________________ _____________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org ________________ _____________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org ________________ _____________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org ________________ _____________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________
Top

#45019 - 03/29/01 02:29 PM Re: Remedy and Cold Fusion [Re: anschutz]
evanson_matthew Stealth Member Registered: 06/12/01 Posts: 43	I don't know about other databases, but you can do this with oracle. SELECT nextid FROM arschema WHERE name = 'Schema Name' FOR UPDATE; Note the FOR UPDATE clause. You can then use that number to create your ticket, etc. Also update next id. Remedy will not be able to get the next id until you commit. If you forget to commit and leave your connection open, remedy will hang (and probably timeout) without submitting. I think this standard SQL and it will work with other dbs as well. --matt Greg Gibson Sent by: "Action Request System discussion list(ARSList)" 03/29/01 02:44 PM Please respond to "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion I don't really know, here is my guess. When they need a new Next Id, each Remedy process must ask the traffic control process (arservtcd) for a Next Id. Arservtcd is probably the only process allowed to manage (i.e select, update) the Next Id field. Ravi Bommareddy @LISTSERV.VISTAIT.COM> on 03/29/2001 10:17:41 AM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Greg, Then tell me how Remedy doing this ( from prev. mail ) > I just want to know how Remedy solving this concurency issue ( > NextID ) when > more than one user creating calls at the same time? > Regards.. Ravi Greg Gibson @LISTSERV.VISTAIT.COM> on 03/29/2001 01:46:42 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Wrong. example. Your app and Remedy get the Next Id value at the same time. Both apps think they have the correct value. Both apps use the same Id and both will increment and update Next Id. Ravi Bommareddy @LISTSERV.VISTAIT.COM> on 03/29/2001 08:15:12 AM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Then, no problem using CF. I don't see any NEW problem using CF and Remedy together, because DB will take care of Next ID issue. Or, You can set up reocrd lock, so the other transaction will wait for Next ID Regards.. Ravi Jarl Groneng @LISTSERV.VISTAIT.COM> on 03/29/2001 12:00:44 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Transaction control in the database. -- Jarl Groneng jarl@nextra.com http://www.arutil.com > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Ravi Bommareddy > Sent: 29. mars 2001 17:31 > To: ARSLIST@LISTSERV.VISTAIT.COM > Subject: Re: Remedy and Cold Fusion > > > > > I just want to know how Remedy solving this concurency issue ( > NextID ) when > more than one user creating calls at the same time? > Regards.. > > > > > > Greg Gibson @LISTSERV.VISTAIT.COM> on > 03/28/2001 07:01:30 > PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > Subject: Re: Remedy and Cold Fusion > > > > > Yes it can but, if you use SQL to modify NEXT ID, you have to be concerned > that you are not modifying > NextId at the same time Remedy is trying to modify Next Id. > > > > > Ravi Bommareddy @LISTSERV.VISTAIT.COM> on > 03/28/2001 02:19:58 PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > > Subject: Re: Remedy and Cold Fusion > > > > > Greg, > Even that NEXT ID thing can be done with CF or any other web dev. tool > Regards.. > Ravi > > > > > > Greg Gibson @LISTSERV.VISTAIT.COM> on 03/28/2001 > 06:15:49 > PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > Subject: Re: Remedy and Cold Fusion > > > > > You do NOT want to use Cold Fusion or any other product to "INSERT" a new > ticket. > You DO want to use ARSperl or the API to create a new ticket. That's > because their are other factors, i.e. > the next Ticket id number is stored in Remedy tables. > > > > > Ravi Bommareddy @LISTSERV.VISTAIT.COM> on > 03/28/2001 01:10:48 PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > > Subject: Re: Remedy and Cold Fusion > > > > > Beth, > It's doable and we're planing to use web app developed with CF or Vis. > IntDev. > ( using the existing Remedy DB), so that we can eliminate Remedy Lic fee > every > year. > You can do Inserts, Updates and deletes with Coldfusion ( you nedd CF app > server > too). But, you might miss all tose notification events, and you have to > mimic > all Remedy inserts during a call insert into a form. I mean Remedy inserts > the > records to more than one for form( a HD call goes to two forms), so you > have to > be careful to impliment the entire functionality. > Regards... > Ravi > > > > > > Mac McMillan @LISTSERV.VISTAIT.COM> on 03/28/2001 > 04:49:02 PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > Subject: Remedy and Cold Fusion > > > ** > > We are attempting to provide a web-based user tool using Cold Fusion. > > Has anyone ever been able to read and submit request through Cold Fusion? > Our developer is building a "read-only" view reading directly from the > underlying database tables, but we want users to be able to use the > interface just like the ARS User Client. (same functionality and > appearance). > > Advise?? > > Bethel McMillan (Mac) > Applications Specialist - Remedy > Xypoint Corporation > > (206) 674-1094 > (253) 208-2164 (cell) > > http://www.xypoint.com > > ______ > _______________________ > > > > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > You may also control your subscription options, including > UNSUBSCRIBE, at www.ARSLIST.org > > _____________________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________
Top

#45020 - 03/29/01 02:56 PM Re: Remedy and Cold Fusion [Re: anschutz]
evanson_matthew Stealth Member Registered: 06/12/01 Posts: 43	This is how remedy determines the next fieldid not next entry id. To create entries at the db level you need to get the next entry id. --matt John Smith Sent by: "Action Request System discussion list(ARSList)" 03/29/01 03:20 PM Please respond to "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion ** Check out Remedy's knowledge base id #000000000005754 which is quoted here: Category 1 Administration Category 2 Database Full Problem Description How does Remedy determine the next fieldid? Solution In Remedy, this is actually done in memory and you will not see this in logging. To see this for yourself, follow these steps: From the database query tool such as Query Analyzer in MS SQL Server 7 or SQL Plus in Oracle, login as aradmin with a password of ar#admin#. This is with the assumption that the default login id or password have not been changed and will ensure you are running your queries on the ARSystem database. You will need to know the corresponding T table number and name. For instance if I wanted to know the T table number of my Help Desk form I could
Top

#45021 - 03/29/01 03:22 PM Re: Remedy and Cold Fusion [Re: anschutz]
greg gibson Stealth Member Registered: 06/12/01 Posts: 128	Until now, I have never noticed "for update" in a select clause. Apparently, it is SQL standard. "For update" is also in my Sybase manual. Still, I think it is better to use Remedy API or ARSperl to Create a ticket since I don't know how the Remedy process would react if they got temporay "locked" out due to a "For Update". EVANSON_MATTHEW@LILLY.COM@LISTSERV.VISTAIT.COM> on 03/29/2001 12:29:08 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion I don't know about other databases, but you can do this with oracle. SELECT nextid FROM arschema WHERE name = 'Schema Name' FOR UPDATE; Note the FOR UPDATE clause. You can then use that number to create your ticket, etc. Also update next id. Remedy will not be able to get the next id until you commit. If you forget to commit and leave your connection open, remedy will hang (and probably timeout) without submitting. I think this standard SQL and it will work with other dbs as well. --matt Greg Gibson To: Sent by: "Action ARSLIST@LISTSERV.VISTAI Request System T.COM discussion cc: list(ARSList)" Subject: IT.COM> Fusion 03/29/01 02:44 PM Please respond to "Action Request System discussion list(ARSList)" I don't really know, here is my guess. When they need a new Next Id, each Remedy process must ask the traffic control process (arservtcd) for a Next Id. Arservtcd is probably the only process allowed to manage (i.e select, update) the Next Id field. Ravi Bommareddy @LISTSERV.VISTAIT.COM> on 03/29/2001 10:17:41 AM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Greg, Then tell me how Remedy doing this ( from prev. mail ) > I just want to know how Remedy solving this concurency issue ( > NextID ) when > more than one user creating calls at the same time? > Regards.. Ravi Greg Gibson @LISTSERV.VISTAIT.COM> on 03/29/2001 01:46:42 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Wrong. example. Your app and Remedy get the Next Id value at the same time. Both apps think they have the correct value. Both apps use the same Id and both will increment and update Next Id. Ravi Bommareddy @LISTSERV.VISTAIT.COM> on 03/29/2001 08:15:12 AM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Then, no problem using CF. I don't see any NEW problem using CF and Remedy together, because DB will take care of Next ID issue. Or, You can set up reocrd lock, so the other transaction will wait for Next ID Regards.. Ravi Jarl Groneng @LISTSERV.VISTAIT.COM> on 03/29/2001 12:00:44 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Transaction control in the database. -- Jarl Groneng jarl@nextra.com http://www.arutil.com > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Ravi Bommareddy > Sent: 29. mars 2001 17:31 > To: ARSLIST@LISTSERV.VISTAIT.COM > Subject: Re: Remedy and Cold Fusion > > > > > I just want to know how Remedy solving this concurency issue ( > NextID ) when > more than one user creating calls at the same time? > Regards.. > > > > > > Greg Gibson @LISTSERV.VISTAIT.COM> on > 03/28/2001 07:01:30 > PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > Subject: Re: Remedy and Cold Fusion > > > > > Yes it can but, if you use SQL to modify NEXT ID, you have to be concerned > that you are not modifying > NextId at the same time Remedy is trying to modify Next Id. > > > > > Ravi Bommareddy @LISTSERV.VISTAIT.COM> on > 03/28/2001 02:19:58 PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > > Subject: Re: Remedy and Cold Fusion > > > > > Greg, > Even that NEXT ID thing can be done with CF or any other web dev. tool > Regards.. > Ravi > > > > > > Greg Gibson @LISTSERV.VISTAIT.COM> on 03/28/2001 > 06:15:49 > PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > Subject: Re: Remedy and Cold Fusion > > > > > You do NOT want to use Cold Fusion or any other product to "INSERT" a new > ticket. > You DO want to use ARSperl or the API to create a new ticket. That's > because their are other factors, i.e. > the next Ticket id number is stored in Remedy tables. > > > > > Ravi Bommareddy @LISTSERV.VISTAIT.COM> on > 03/28/2001 01:10:48 PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > > Subject: Re: Remedy and Cold Fusion > > > > > Beth, > It's doable and we're planing to use web app developed with CF or Vis
Top

#45022 - 03/30/01 06:09 AM Re: Remedy and Cold Fusion [Re: anschutz]
hite1 Stealth Member Registered: 06/12/01 Posts: 37	Hi, I've been out of town a few days and just now got a chance to see these posts. You may have already been given the information I am about to provide. If so, I apologize. I have written a complete Remedy web site in Cold Fusion for our support people. I used the ARS42i Helper Component, a free tool from James Croom (www.croomweb.com). We are able to add new tickets, modify existing tickets, view tickets, etc. I used JavaScript to perform the validation that we normally perform with Active Links. I let Remedy process all the filters and then use exception handling if problems occur. I played around with ARSPerl, but I was able to develop a fully functional site more quickly with this tool. I highly recommend you look into it. If you have any questions about it, please feel free to contact me. Sharon -----Original Message----- From: Greg Gibson [mailto:Greg.Gibson@HSC.COM] Sent: Thursday, March 29, 2001 4:23 PM Subject: Re: Remedy and Cold Fusion Until now, I have never noticed "for update" in a select clause. Apparently, it is SQL standard. "For update" is also in my Sybase manual. Still, I think it is better to use Remedy API or ARSperl to Create a ticket since I don't know how the Remedy process would react if they got temporay "locked" out due to a "For Update". EVANSON_MATTHEW@LILLY.COM@LISTSERV.VISTAIT.COM> on 03/29/2001 12:29:08 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion I don't know about other databases, but you can do this with oracle. SELECT nextid FROM arschema WHERE name = 'Schema Name' FOR UPDATE; Note the FOR UPDATE clause. You can then use that number to create your ticket, etc. Also update next id. Remedy will not be able to get the next id until you commit. If you forget to commit and leave your connection open, remedy will hang (and probably timeout) without submitting. I think this standard SQL and it will work with other dbs as well. --matt Greg Gibson To: Sent by: "Action ARSLIST@LISTSERV.VISTAI Request System T.COM discussion cc: list(ARSList)" Subject: Cold IT.COM> Fusion 03/29/01 02:44 PM Please respond to "Action Request System discussion list(ARSList)" I don't really know, here is my guess. When they need a new Next Id, each Remedy process must ask the traffic control process (arservtcd) for a Next Id. Arservtcd is probably the only process allowed to manage (i.e select, update) the Next Id field. Ravi Bommareddy @LISTSERV.VISTAIT.COM> on 03/29/2001 10:17:41 AM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Greg, Then tell me how Remedy doing this ( from prev. mail ) > I just want to know how Remedy solving this concurency issue ( > NextID ) when > more than one user creating calls at the same time? > Regards.. Ravi Greg Gibson @LISTSERV.VISTAIT.COM> on 03/29/2001 01:46:42 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Wrong. example. Your app and Remedy get the Next Id value at the same time. Both apps think they have the correct value. Both apps use the same Id and both will increment and update Next Id. Ravi Bommareddy @LISTSERV.VISTAIT.COM> on 03/29/2001 08:15:12 AM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Then, no problem using CF. I don't see any NEW problem using CF and Remedy together, because DB will take care of Next ID issue. Or, You can set up reocrd lock, so the other transaction will wait for Next ID Regards.. Ravi Jarl Groneng @LISTSERV.VISTAIT.COM> on 03/29/2001 12:00:44 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Re: Remedy and Cold Fusion Transaction control in the database. -- Jarl Groneng jarl@nextra.com http://www.arutil.com > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Ravi Bommareddy > Sent: 29. mars 2001 17:31 > To: ARSLIST@LISTSERV.VISTAIT.COM > Subject: Re: Remedy and Cold Fusion > > > > > I just want to know how Remedy solving this concurency issue ( > NextID ) when > more than one user creating calls at the same time? > Regards.. > > > > > > Greg Gibson @LISTSERV.VISTAIT.COM> on > 03/28/2001 07:01:30 > PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > Subject: Re: Remedy and Cold Fusion > > > > > Yes it can but, if you use SQL to modify NEXT ID, you have to be concerned > that you are not modifying > NextId at the same time Remedy is trying to modify Next Id. > > > > > Ravi Bommareddy @LISTSERV.VISTAIT.COM> on > 03/28/2001 02:19:58 PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > > Subject: Re: Remedy and Cold Fusion > > > > > Greg, > Even that NEXT ID thing can be done with CF or any other web dev. tool > Regards.. > Ravi > > > > > > Greg Gibson @LISTSERV.VISTAIT.COM> on 03/28/2001 > 06:15:49 > PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > Subject: Re: Remedy and Cold Fusion > > > > > You do NOT want to use Cold Fusion or any other product to "INSERT" a new > ticket. > You DO want to use ARSperl or the API to create a new ticket. That's > because their are other factors, i.e. > the next Ticket id number is stored in Remedy tables. > > > > > Ravi Bommareddy @LISTSERV.VISTAIT.COM> on > 03/28/2001 01:10:48 PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > > Subject: Re: Remedy and Cold Fusion > > > > > Beth, > It's doable and we're planing to use web app developed with CF or Vis. > IntDev. > ( using the existing Remedy DB), so that we can eliminate Remedy Lic fee > every > year. > You can do Inserts, Updates and deletes with Coldfusion ( you nedd CF app > server > too). But, you might miss all tose notification events, and you have to > mimic > all Remedy inserts during a call insert into a form. I mean Remedy inserts > the > records to more than one for form( a HD call goes to two forms), so you > have to > be careful to impliment the entire functionality. > Regards... > Ravi > > > > > > Mac McMillan @LISTSERV.VISTAIT.COM> on 03/28/2001 > 04:49:02 PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > Subject: Remedy and Cold Fusion > > > > > We are attempting to provide a web-based user tool using Cold Fusion. > > Has anyone ever been able to read and submit request through Cold Fusion? > Our developer is building a "read-only" view reading directly from the > underlying database tables, but we want users to be able to use the > interface just like the ARS User Client. (same functionality and > appearance). > > Advise?? > > Bethel McMillan (Mac) > Applications Specialist - Remedy > Xypoint Corporation > > (206) 674-1094 > (253) 208-2164 (cell) > > http://www.xypoint.com > > ______ > _______________________ > > > > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ______ > _______________________ > > > You may also control your subscription options, including > UNSUBSCRIBE, at www.ARSLIST.org > > __________ ___________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org __________ ___________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org __________ ___________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org __________ ___________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org __________ ___________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________
Top

#45023 - 03/30/01 07:54 AM Re: Remedy and Cold Fusion [Re: anschutz]
nickym Stealth Member Registered: 06/12/01 Posts: 277	Hi, Basically, all transactions are queued and processed in the order received. You get Next ID updated in the moment when single transaction is completed. From the DB point of view, ARS behaves as a single entity, so no place for confusion there. It is not tcd talking to the db. HTH, Nicky Madjarov Intellico Solutions, Inc. 1507 Hermitage Pk. Dr. Hermitage, TN 37076 Phone: (615) 883 7591 Mobil : (201) 747 8672 Pager: 2017478672@mobile.att.net e-mail: nickym@intellicosolutions.net http://www.intellicosolutions.net ----- Original Message ----- From: "Greg Gibson" To: Sent: Thursday, March 29, 2001 1:44 PM Subject: Re: Remedy and Cold Fusion > > > I don't really know, here is my guess. > > When they need a new Next Id, each Remedy process must ask the traffic > control process (arservtcd) > for a Next Id. Arservtcd is probably the only process allowed to manage > (i.e select, update) the Next Id > field. > > > > > > > > Ravi Bommareddy @LISTSERV.VISTAIT.COM> on > 03/29/2001 10:17:41 AM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > > Subject: Re: Remedy and Cold Fusion > > > > > Greg, > Then tell me how Remedy doing this ( from prev. mail ) > > I just want to know how Remedy solving this concurency issue ( > > NextID ) when > > more than one user creating calls at the same time? > > Regards.. > > Ravi > > > > > > Greg Gibson @LISTSERV.VISTAIT.COM> on 03/29/2001 > 01:46:42 > PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > Subject: Re: Remedy and Cold Fusion > > > > > Wrong. > example. > Your app and Remedy get the Next Id value at the same time. Both apps > think they have the correct value. > Both apps use the same Id and both will increment and update Next Id. > > > > > Ravi Bommareddy @LISTSERV.VISTAIT.COM> on > 03/29/2001 08:15:12 AM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > > Subject: Re: Remedy and Cold Fusion > > > > > Then, no problem using CF. I don't see any NEW problem using CF and Remedy > together, because DB will take care of Next ID issue. Or, You can set up > reocrd > lock, so the other transaction will wait for Next ID > Regards.. > Ravi > > > > > > Jarl Groneng @LISTSERV.VISTAIT.COM> on 03/29/2001 12:00:44 > PM > > Please respond to "Action Request System discussion list(ARSList)" > > > Sent by: "Action Request System discussion list(ARSList)" > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > cc: > Subject: Re: Remedy and Cold Fusion > > > > > Transaction control in the database. > > -- > Jarl Groneng > jarl@nextra.com > http://www.arutil.com > > > > -----Original Message----- > > From: Action Request System discussion list(ARSList) > > [mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Ravi Bommareddy > > Sent: 29. mars 2001 17:31 > > To: ARSLIST@LISTSERV.VISTAIT.COM > > Subject: Re: Remedy and Cold Fusion > > > > > > > > > > I just want to know how Remedy solving this concurency issue ( > > NextID ) when > > more than one user creating calls at the same time? > > Regards.. > > > > > > > > > > > > Greg Gibson @LISTSERV.VISTAIT.COM> on > > 03/28/2001 07:01:30 > > PM > > > > Please respond to "Action Request System discussion list(ARSList)" > > > > > > Sent by: "Action Request System discussion list(ARSList)" > > > > > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > > cc: > > Subject: Re: Remedy and Cold Fusion > > > > > > > > > > Yes it can but, if you use SQL to modify NEXT ID, you have to be > concerned > > that you are not modifying > > NextId at the same time Remedy is trying to modify Next Id. > > > > > > > > > > Ravi Bommareddy @LISTSERV.VISTAIT.COM> on > > 03/28/2001 02:19:58 PM > > > > Please respond to "Action Request System discussion list(ARSList)" > > > > > > Sent by: "Action Request System discussion list(ARSList)" > > > > > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > > cc: > > > > Subject: Re: Remedy and Cold Fusion > > > > > > > > > > Greg, > > Even that NEXT ID thing can be done with CF or any other web dev. tool > > Regards.. > > Ravi > > > > > > > > > > > > Greg Gibson @LISTSERV.VISTAIT.COM> on 03/28/2001 > > 06:15:49 > > PM > > > > Please respond to "Action Request System discussion list(ARSList)" > > > > > > Sent by: "Action Request System discussion list(ARSList)" > > > > > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > > cc: > > Subject: Re: Remedy and Cold Fusion > > > > > > > > > > You do NOT want to use Cold Fusion or any other product to "INSERT" a > new > > ticket. > > You DO want to use ARSperl or the API to create a new ticket. That's > > because their are other factors, i.e. > > the next Ticket id number is stored in Remedy tables. > > > > > > > > > > Ravi Bommareddy @LISTSERV.VISTAIT.COM> on > > 03/28/2001 01:10:48 PM > > > > Please respond to "Action Request System discussion list(ARSList)" > > > > > > Sent by: "Action Request System discussion list(ARSList)" > > > > > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > > cc: > > > > Subject: Re: Remedy and Cold Fusion > > > > > > > > > > Beth, > > It's doable and we're planing to use web app developed with CF or Vis. > > IntDev. > > ( using the existing Remedy DB), so that we can eliminate Remedy Lic fee > > every > > year. > > You can do Inserts, Updates and deletes with Coldfusion ( you nedd CF app > > server > > too). But, you might miss all tose notification events, and you have to > > mimic > > all Remedy inserts during a call insert into a form. I mean Remedy > inserts > > the > > records to more than one for form( a HD call goes to two forms), so you > > have to > > be careful to impliment the entire functionality. > > Regards... > > Ravi > > > > > > > > > > > > Mac McMillan @LISTSERV.VISTAIT.COM> on 03/28/2001 > > 04:49:02 PM > > > > Please respond to "Action Request System discussion list(ARSList)" > > > > > > Sent by: "Action Request System discussion list(ARSList)" > > > > > > > > To: ARSLIST@LISTSERV.VISTAIT.COM > > cc: > > Subject: Remedy and Cold Fusion > > > > > > ** > > > > We are attempting to provide a web-based user tool using Cold Fusion. > > > > Has anyone ever been able to read and submit request through Cold Fusion? > > Our developer is building a "read-only" view reading directly from the > > underlying database tables, but we want users to be able to use the > > interface just like the ARS User Client. (same functionality and > > appearance). > > > > Advise?? > > > > Bethel McMillan (Mac) > > Applications Specialist - Remedy > > Xypoint Corporation > > > > (206) 674-1094 > > (253) 208-2164 (cell) > > > > http://www.xypoint.com > > > > ______ > > _______________________ > > > > > > > > > > > > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > > www.ARSLIST.org > > > > ______ > > _______________________ > > > > > > > > > > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > > www.ARSLIST.org > > > > ______ > > _______________________ > > > > > > > > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > > www.ARSLIST.org > > > > ______ > > _______________________ > > > > > > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > > www.ARSLIST.org > > > > ______ > > _______________________ > > > > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > > www.ARSLIST.org > > > > ______ > > _______________________ > > > > > > You may also control your subscription options, including > > UNSUBSCRIBE, at www.ARSLIST.org > > > > > > ________________ _____________ > > > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ________________ _____________ > > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ________________ _____________ > > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ________________ _____________ > > > > You may also control your subscription options, including UNSUBSCRIBE, at > www.ARSLIST.org > > ________________ _____________ > > You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________
Top

#45024 - 03/28/01 03:10 PM Re: Remedy and Cold Fusion [Re: anschutz]
ravi bommareddy Stealth Member Registered: 06/12/01 Posts: 248	Beth, It's doable and we're planing to use web app developed with CF or Vis. IntDev. ( using the existing Remedy DB), so that we can eliminate Remedy Lic fee every year. You can do Inserts, Updates and deletes with Coldfusion ( you nedd CF app server too). But, you might miss all tose notification events, and you have to mimic all Remedy inserts during a call insert into a form. I mean Remedy inserts the records to more than one for form( a HD call goes to two forms), so you have to be careful to impliment the entire functionality. Regards... Ravi Mac McMillan @LISTSERV.VISTAIT.COM> on 03/28/2001 04:49:02 PM Please respond to "Action Request System discussion list(ARSList)" Sent by: "Action Request System discussion list(ARSList)" To: ARSLIST@LISTSERV.VISTAIT.COM cc: Subject: Remedy and Cold Fusion We are attempting to provide a web-based user tool using Cold Fusion. Has anyone ever been able to read and submit request through Cold Fusion? Our developer is building a "read-only" view reading directly from the underlying database tables, but we want users to be able to use the interface just like the ARS User Client. (same functionality and appearance). Advise?? Bethel McMillan (Mac) Applications Specialist - Remedy Xypoint Corporation (206) 674-1094 (253) 208-2164 (cell) http://www.xypoint.com _____________________________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________ _____________________________
Top

#45025 - 03/28/01 03:33 PM Re: Remedy and Cold Fusion [Re: anschutz]
refaey Stealth Member Registered: 06/12/01 Posts: 189	** Hi Bathel, It's very hard to do it using Cold Fusion 'cause you have to know every little detail about how remedy stores data in the database tables. Even if you did that, you can not guarantee compatibility with other versions of remedy because the way remedy stores data in the database is not documented, so remedy can change it anytime, and in that case your application will stop working if you decided to use that new version of remedy. It's like the old game that Microsoft used to play by using undocumented functions in their Windows and Office applications and then used this to make DR-DOS incompatible with Windows. Anyway, as far as I know, you have two choices here: 1. Using Perl CGI, with ARSPerl 2. Using ASP, with www.croomweb.com 3. Using remedy web products (I don't think you wanna do that). Your Cold Fusion programmer should find using ARSPerl very easy. Best regards, Ashraf Elrefaey Remedy Consultant Workflow Solutions Ltd * Phone: +64 4 385 2885 * Cellular: +64 21 377523 * Fax: +64 4 385 2911 * E-Mail: mailto:refaey@workflow.co.nz 1 Webpage: http://www.workflow.co.nz -----Original Message----- From: Mac McMillan [mailto:BMcMillan@XYPOINT.COM] Sent: Thu, 29 March 2001 08:49 To: ARSLIST@LISTSERV.VISTAIT.COM Subject: Remedy and Cold Fusion ** We are attempting to provide a web-based user tool using Cold Fusion. Has anyone ever been able to read and submit request through Cold Fusion? Our developer is building a "read-only" view reading directly from the underlying database tables, but we want users to be able to use the interface just like the ARS User Client. (same functionality and appearance). Advise?? Bethel McMillan (Mac) Applications Specialist - Remedy Xypoint Corporation (206) 674-1094 (253) 208-2164 (cell) http://www.xypoint.com ________________ _____________ You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org _____________________________ _____________________________
Top

Page 1 of 3

1

View All Topics

Moderator: Matt Reinfeldt