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

_____________________________

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.

_____________________________

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

_____________________________

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

_____________________________

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

_____________________________

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 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

_____________________________

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

_____________________________

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

_____________________________

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

_____________________________