Hello Everyone,

Here's hoping that all of you are having a wonderful holiday season. I
thought I would put this out to all of you who will have more of a clue
about this then I do. We have two systems that are used extensively
throughout our company. One system of course is ARS on a SQL 7.0 database.
The second system is written in FoxPro. We need to be able to see data that
is in the FoxPro tables. To date this data has been entered into an ARS form
either by importing using import tool or manual entry of the data. Both of
these methods are not an option. Will the new functionality in ARS 5.0 allow
someone in ARS to be able to pull information from the FoxPro tables based
on a unique identifier? Can this info then be stored in an ARS field on
designated forms. I hope that you can understand all of this. Any help at
all would be very appreciated.

Thanks,

Roger A. Nall
Project Manager
Remedy Administrator
Covista Communication
888-890-7600x7446
rnall@covista.com

_____________________________

From what I understand, you can build an interface (similar to an ODBC
connection) that will allow you to pull data from external sources and
store it as data in Remedy tables. They didn't even begin to show us
how to do that, so you'd have to dig into the documentation for that.

Rick Cook
Senior Remedy Consultant
Denali Advanced Integration

-----Original Message-----
From: Roger Nall [mailto:RNall@COVISTA.COM]
Sent: Wednesday, December 19, 2001 11:25 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: 5.0 Functionality


**

Hello Everyone,

Here's hoping that all of you are having a wonderful holiday season. I
thought I would put this out to all of you who will have more of a clue
about this then I do. We have two systems that are used extensively
throughout our company. One system of course is ARS on a SQL 7.0
database.
The second system is written in FoxPro. We need to be able to see data
that
is in the FoxPro tables. To date this data has been entered into an ARS
form
either by importing using import tool or manual entry of the data. Both
of
these methods are not an option. Will the new functionality in ARS 5.0
allow
someone in ARS to be able to pull information from the FoxPro tables
based
on a unique identifier? Can this info then be stored in an ARS field on
designated forms. I hope that you can understand all of this. Any help
at
all would be very appreciated.

Thanks,

Roger A. Nall
Project Manager
Remedy Administrator
Covista Communication
888-890-7600x7446
rnall@covista.com

____________
_________________


You may also control your subscription options, including UNSUBSCRIBE,
at www.ARSLIST.org

_____________________________

I think the feature that is being referenced is called "ARDBC". (Check the
V5 programming pdf for more info.)

Technically this is implemented with a the new plug in (C) API. So if you
can write C well enough to talk to an ODBC data source, and FoxPro offers
such a feature, then it _should_ be possible. Technically the C code does
not need ODBC, it could do anything including grep'ing files on the os, or
anything that you can get C to do for you. You just need to "program" a set
of functions (4-5 I think) that are required by the ARDBC plug in API.)

Here are a few "details": (From memory, please read the docs.)

1) The ARDBC allows you to created a "vender" (type) form. (In many ways
like a display only form, only it uses the associated plug in to "talk to
the data source".)
The data is not "stored" in ARS. (Unless you build workflow to do
that. Then you would need a regular form in ARS as well that you Push the
data to. This would lead to "consistency" problems between the two data
stores.) By design it is retrieved when the user performs the search.

2) There are specific requirements that must be meet by the "other data
source". (Like having a suitable 'Entry ID'/'Request Id' column. I think
there are some other items as well. )

Hope that helps.

--
Carey Matthew Black
Remedy Skilled Professional

-----Original Message-----
From: Rick Cook [mailto:rcook@DENALIAI.COM]
Sent: Wednesday, December 19, 2001 1:55 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: 5.0 Functionality

From what I understand, you can build an interface (similar to an ODBC
connection) that will allow you to pull data from external sources and store
it as data in Remedy tables. They didn't even begin to show us how to do
that, so you'd have to dig into the documentation for that.

Rick Cook
Senior Remedy Consultant
Denali Advanced Integration

-----Original Message-----
From: Roger Nall [mailto:RNall@COVISTA.COM]
Sent: Wednesday, December 19, 2001 11:25 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: 5.0 Functionality

Hello Everyone,

Here's hoping that all of you are having a wonderful holiday season. I
thought I would put this out to all of you who will have more of a clue
about this then I do. We have two systems that are used extensively
throughout our company. One system of course is ARS on a SQL 7.0 database.
The second system is written in FoxPro. We need to be able to see data that
is in the FoxPro tables. To date this data has been entered into an ARS form
either by importing using import tool or manual entry of the data. Both of
these methods are not an option. Will the new functionality in ARS 5.0 allow
someone in ARS to be able to pull information from the FoxPro tables based
on a unique identifier? Can this info then be stored in an ARS field on
designated forms. I hope that you can understand all of this. Any help at
all would be very appreciated.

Thanks,

Roger A. Nall
Project Manager
Remedy Administrator
Covista Communication
888-890-7600x7446
rnall@covista.com

_____________________________

Hello Roger,

I've been playing around with this a bit, here's what I've learned.

In ARS 5, you can use a View Form to access non-Remedy data that your
database (MS_SQL, Oracle, etc) can 'reach'. Example and linked server in
MS-SQL. I've done this and it's working fine.

Also in ARS 5, you can use a Vendor Form to access data sources, that a
View Form can't, using LDAP. Haven't tried Vendor Forms yet.

HTH

Eric

Eric Evans
Senior Groupware Developer
Remedy Skilled Professional





Roger Nall
To: ARSLIST@LISTSERV.VISTAIT.COM
Sent by: "Action cc:
Request System Subject: 5.0 Functionality
discussion
list(ARSList)"
STAIT.COM>


12/19/2001 02:25 PM
Please respond to
"Action Request
System discussion
list(ARSList)"




**

Hello Everyone,

Here's hoping that all of you are having a wonderful holiday season. I
thought I would put this out to all of you who will have more of a clue
about this then I do. We have two systems that are used extensively
throughout our company. One system of course is ARS on a SQL 7.0 database.
The second system is written in FoxPro. We need to be able to see data that
is in the FoxPro tables. To date this data has been entered into an ARS
form
either by importing using import tool or manual entry of the data. Both of
these methods are not an option. Will the new functionality in ARS 5.0
allow
someone in ARS to be able to pull information from the FoxPro tables based
on a unique identifier? Can this info then be stored in an ARS field on
designated forms. I hope that you can understand all of this. Any help at
all would be very appreciated.

Thanks,

Roger A. Nall
Project Manager
Remedy Administrator
Covista Communication
888-890-7600x7446
rnall@covista.com

_____________________________



You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

_____________________________

Eric,

He's an example I put to the instructor last week. I have MS SQL on my
server and I wanted to connect to the sample Northwind SQL Employee table
via a
view form. Not a problem and you can test this easily, quickly and it
works.
However, I was puzzled by the fact that the resulting columns available to
me
in the Remedy view form were just two choices. I opened the table in SQL
and these
columns are integer fields. Ok, the instructor pointed out that Remedy is
only going
to recognize the field types it recognizes !! Bingo the light went off as
he explained the process. Simply create a new SQL VIEW of the table with
compatible field types
and then re-run the View Form process, there is my data, wow.

Once again I am amazed at how simple to process has become. This is a
totally
awesome release and raises the bar significantly. For Geeks like me this is
a great Christmas present, now if I can just remember where I left my car
keys.....

Regards...Gidd



-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Eric Evans
Sent: Wednesday, December 19, 2001 4:46 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: 5.0 Functionality


**

Hello Roger,

I've been playing around with this a bit, here's what I've learned.

In ARS 5, you can use a View Form to access non-Remedy data that your
database (MS_SQL, Oracle, etc) can 'reach'. Example and linked server in
MS-SQL. I've done this and it's working fine.

Also in ARS 5, you can use a Vendor Form to access data sources, that a
View Form can't, using LDAP. Haven't tried Vendor Forms yet.

HTH

Eric

Eric Evans
Senior Groupware Developer
Remedy Skilled Professional





Roger Nall
To:
ARSLIST@LISTSERV.VISTAIT.COM
Sent by: "Action cc:
Request System Subject: 5.0
Functionality
discussion
list(ARSList)"
STAIT.COM>


12/19/2001 02:25 PM
Please respond to
"Action Request
System discussion
list(ARSList)"




**

Hello Everyone,

Here's hoping that all of you are having a wonderful holiday season. I
thought I would put this out to all of you who will have more of a clue
about this then I do. We have two systems that are used extensively
throughout our company. One system of course is ARS on a SQL 7.0 database.
The second system is written in FoxPro. We need to be able to see data that
is in the FoxPro tables. To date this data has been entered into an ARS
form
either by importing using import tool or manual entry of the data. Both of
these methods are not an option. Will the new functionality in ARS 5.0
allow
someone in ARS to be able to pull information from the FoxPro tables based
on a unique identifier? Can this info then be stored in an ARS field on
designated forms. I hope that you can understand all of this. Any help at
all would be very appreciated.

Thanks,

Roger A. Nall
Project Manager
Remedy Administrator
Covista Communication
888-890-7600x7446
rnall@covista.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

_____________________________

Cool, thanks Gidd. The View forms are a snap. I've also used the SQL view
idea - to display dates stored in epoch time as integers in a format more
readable for users.

Had any luck with Vendor forms? I'd really like to be able to connect to
our AS400/DB2, JD Edwards, and Lotus Notes databases.

Thanks again,

Eric



Gidd Calden
To: ARSLIST@LISTSERV.VISTAIT.COM
Sent by: "Action cc:
Request System Subject: Re: 5.0 Functionality
discussion
list(ARSList)"
STAIT.COM>


12/19/2001 09:47 PM
Please respond to
"Action Request
System discussion
list(ARSList)"




**

Eric,

He's an example I put to the instructor last week. I have MS SQL on my
server and I wanted to connect to the sample Northwind SQL Employee table
via a
view form. Not a problem and you can test this easily, quickly and it
works.
However, I was puzzled by the fact that the resulting columns available to
me
in the Remedy view form were just two choices. I opened the table in SQL
and these
columns are integer fields. Ok, the instructor pointed out that Remedy is
only going
to recognize the field types it recognizes !! Bingo the light went off as
he explained the process. Simply create a new SQL VIEW of the table with
compatible field types
and then re-run the View Form process, there is my data, wow.

Once again I am amazed at how simple to process has become. This is a
totally
awesome release and raises the bar significantly. For Geeks like me this
is
a great Christmas present, now if I can just remember where I left my car
keys.....

Regards...Gidd



-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Eric Evans
Sent: Wednesday, December 19, 2001 4:46 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: 5.0 Functionality


**

Hello Roger,

I've been playing around with this a bit, here's what I've learned.

In ARS 5, you can use a View Form to access non-Remedy data that your
database (MS_SQL, Oracle, etc) can 'reach'. Example and linked server in
MS-SQL. I've done this and it's working fine.

Also in ARS 5, you can use a Vendor Form to access data sources, that a
View Form can't, using LDAP. Haven't tried Vendor Forms yet.

HTH

Eric

Eric Evans
Senior Groupware Developer
Remedy Skilled Professional





Roger Nall
To:
ARSLIST@LISTSERV.VISTAIT.COM
Sent by: "Action cc:
Request System Subject: 5.0
Functionality
discussion
list(ARSList)"
STAIT.COM>


12/19/2001 02:25 PM
Please respond to
"Action Request
System discussion
list(ARSList)"




**

Hello Everyone,

Here's hoping that all of you are having a wonderful holiday season. I
thought I would put this out to all of you who will have more of a clue
about this then I do. We have two systems that are used extensively
throughout our company. One system of course is ARS on a SQL 7.0 database.
The second system is written in FoxPro. We need to be able to see data that
is in the FoxPro tables. To date this data has been entered into an ARS
form
either by importing using import tool or manual entry of the data. Both of
these methods are not an option. Will the new functionality in ARS 5.0
allow
someone in ARS to be able to pull information from the FoxPro tables based
on a unique identifier? Can this info then be stored in an ARS field on
designated forms. I hope that you can understand all of this. Any help at
all would be very appreciated.

Thanks,

Roger A. Nall
Project Manager
Remedy Administrator
Covista Communication
888-890-7600x7446
rnall@covista.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

_____________________________

Eric,

Sorry I didn't get back to you sooner but AT&T is giving me fits out here !!

The issue with Vendor Forms is the availability of an ARDBC Plug-in.
Essentially
this is custom built using Remedy's API interface (your options are, you
build or
buy - none commercially available yet). Capabilities are huge and you can
interface
with your external data sources, you can use this for LDAP, other legacy
sources that
can include spreadsheets and more...

So, if you create an ARDBC Plug-in using the new API's then please shoot me
a copy
and I will test for you otherwise we wait for someone out there to realize
the
opportunity and produce commercially available Plug-In's.

Somewhere there is an example for version 5.0 but I have not found it yet.
If I do I will let you know.

Regards...Gidd



-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Eric Evans
Sent: Wednesday, December 26, 2001 11:01 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: 5.0 Functionality


**

Cool, thanks Gidd. The View forms are a snap. I've also used the SQL view
idea - to display dates stored in epoch time as integers in a format more
readable for users.

Had any luck with Vendor forms? I'd really like to be able to connect to
our AS400/DB2, JD Edwards, and Lotus Notes databases.

Thanks again,

Eric



Gidd Calden
To:
ARSLIST@LISTSERV.VISTAIT.COM
Sent by: "Action cc:
Request System Subject: Re: 5.0
Functionality
discussion
list(ARSList)"
STAIT.COM>


12/19/2001 09:47 PM
Please respond to
"Action Request
System discussion
list(ARSList)"




**

Eric,

He's an example I put to the instructor last week. I have MS SQL on my
server and I wanted to connect to the sample Northwind SQL Employee table
via a
view form. Not a problem and you can test this easily, quickly and it
works.
However, I was puzzled by the fact that the resulting columns available to
me
in the Remedy view form were just two choices. I opened the table in SQL
and these
columns are integer fields. Ok, the instructor pointed out that Remedy is
only going
to recognize the field types it recognizes !! Bingo the light went off as
he explained the process. Simply create a new SQL VIEW of the table with
compatible field types
and then re-run the View Form process, there is my data, wow.

Once again I am amazed at how simple to process has become. This is a
totally
awesome release and raises the bar significantly. For Geeks like me this
is
a great Christmas present, now if I can just remember where I left my car
keys.....

Regards...Gidd



-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Eric Evans
Sent: Wednesday, December 19, 2001 4:46 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: 5.0 Functionality


**

Hello Roger,

I've been playing around with this a bit, here's what I've learned.

In ARS 5, you can use a View Form to access non-Remedy data that your
database (MS_SQL, Oracle, etc) can 'reach'. Example and linked server in
MS-SQL. I've done this and it's working fine.

Also in ARS 5, you can use a Vendor Form to access data sources, that a
View Form can't, using LDAP. Haven't tried Vendor Forms yet.

HTH

Eric

Eric Evans
Senior Groupware Developer
Remedy Skilled Professional





Roger Nall
To:
ARSLIST@LISTSERV.VISTAIT.COM
Sent by: "Action cc:
Request System Subject: 5.0
Functionality
discussion
list(ARSList)"
STAIT.COM>


12/19/2001 02:25 PM
Please respond to
"Action Request
System discussion
list(ARSList)"




**

Hello Everyone,

Here's hoping that all of you are having a wonderful holiday season. I
thought I would put this out to all of you who will have more of a clue
about this then I do. We have two systems that are used extensively
throughout our company. One system of course is ARS on a SQL 7.0 database.
The second system is written in FoxPro. We need to be able to see data that
is in the FoxPro tables. To date this data has been entered into an ARS
form
either by importing using import tool or manual entry of the data. Both of
these methods are not an option. Will the new functionality in ARS 5.0
allow
someone in ARS to be able to pull information from the FoxPro tables based
on a unique identifier? Can this info then be stored in an ARS field on
designated forms. I hope that you can understand all of this. Any help at
all would be very appreciated.

Thanks,

Roger A. Nall
Project Manager
Remedy Administrator
Covista Communication
888-890-7600x7446
rnall@covista.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

_____________________________