**

Good Morning List.

I am looking at getting access to external data and bringing it into the ARS
in real time if possible. We are using an external ODBC tool to take data
out of the ARS, data is then moved around and built up to build a client
profile. This data then needs to be put back into the ARS. The ODBC tool we
are using is not allowing us to do this. Will upgrading to Version 5.0.1
help us with this if so how?

I have not used version 5 as yet and would appreciate any info.

SQL Server 7
ARS 4.5.2 moving to 5.0.1

Regards

Alan

**

I am doing this, but on a SQL Server level. I use the MSDTC service to connect to the remote server, then I can run select statements and the like on it just as easily as I can on local servers.

Shawn Pierson

-----Original Message-----
From: West Consulting [mailto:westconsultinglimited@HOTMAIL.COM]
Sent: Monday, July 01, 2002 7:03 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: External Data Source


**

Good Morning List.

I am looking at getting access to external data and bringing it into the ARS
in real time if possible. We are using an external ODBC tool to take data
out of the ARS, data is then moved around and built up to build a client
profile. This data then needs to be put back into the ARS. The ODBC tool we
are using is not allowing us to do this. Will upgrading to Version 5.0.1
help us with this if so how?

I have not used version 5 as yet and would appreciate any info.

SQL Server 7
ARS 4.5.2 moving to 5.0.1

Regards

Alan

ARS 5.x offers two solutions. For simple data "mapping" (display only), ARS 5.x has an external data form. To actually fetch information for workflow processing, ARS 5.x has a new tool, the AR Database Connectivity (ARDBC).


-- Bing

Bradford Bingel ("Bing")
QMX Support Services Inc. ( http://www.qmxs.com/)
bing@qmxs.com (email)
925-260-6394 (mobile)


-----Original Message-----
From: Action Request System discussion list(ARSList)
[ mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of West Consulting
Sent: Monday, July 01, 2002 5:03 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: External Data Source


**

Good Morning List.

I am looking at getting access to external data and bringing it into the ARS
in real time if possible. We are using an external ODBC tool to take data
out of the ARS, data is then moved around and built up to build a client
profile. This data then needs to be put back into the ARS. The ODBC tool we
are using is not allowing us to do this. Will upgrading to Version 5.0.1
help us with this if so how?

I have not used version 5 as yet and would appreciate any info.

SQL Server 7
ARS 4.5.2 moving to 5.0.1

Regards

Alan

**

Alan,

If you are using Help Desk 4.0, look in the Workflow Reference Guide,
Chapter 5-1. Using the rappreq command you can create, modify or delete an
entry in an ARS Form.

We use this process to
create an entry in an empty, input form
run filters to push data to another form to update records
delete the entry (in the input form) after processing and
wait for the next entry.

We are using "awk" in AIX to prepare/parse the data, but I am sure that
many different languages could be used to get the data into the required
format.

This is probably not a supported feature.

Ron Fariss




West Consulting
OTMAIL.COM> cc:
Sent by: "Action Request Subject: External Data Source
System discussion
list(ARSList)"
T.COM>


07/01/2002 07:03 AM
Please respond to
"Action Request System
discussion
list(ARSList)"






**

Good Morning List.

I am looking at getting access to external data and bringing it into the
ARS
in real time if possible. We are using an external ODBC tool to take data
out of the ARS, data is then moved around and built up to build a client
profile. This data then needs to be put back into the ARS. The ODBC tool we
are using is not allowing us to do this. Will upgrading to Version 5.0.1
help us with this if so how?

I have not used version 5 as yet and would appreciate any info.

SQL Server 7
ARS 4.5.2 moving to 5.0.1

Regards

Alan



To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

**

Hello Alan,

If you need to transfer data into ARS from external data source, and ARS
acts as server towards your ODBC tool, you can do it with OLE Automation be
automating Remedy User and instructing it to either create new or modify
existing request.

Remedy User can be automated through custom-built ActiveX DLL component
written in VB or C++, or at the SQL Server level through the set of OLE
Automation system stored procedures.

If your ODBC tool can issue SQL commands to SQL Server, you can then
instruct it to run custom-built stored procedure which will automate Remedy
User, ask it to load particular form and either create new or modify
existing request using data supplied from ODBC tool.

If this solution is suitable for you, let me know, and I send you some T-SQL
code samples of how to create or modify records in HPD:HelpDesk form. You
can do it with any other form.

Regards,

Mikhail Gvozdev
Peregrine Product Support Engineer
Planwell Technology Australia Ltd.
1-5 Railway Street
CHATSWOOD NSW 2067

Phone: +61 2 9412 - 8763
Fax: +61 2 9419 - 7803
mailto:mikhailg@planwell.com.au

"We cannot solve the problems we have created with the same thinking that
created them."
Albert Einstein



-----Original Message-----
From: West Consulting [mailto:westconsultinglimited@HOTMAIL.COM]
Sent: Monday, 1 July 2002 10:03 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: External Data Source


**

Good Morning List.

I am looking at getting access to external data and bringing it into the ARS
in real time if possible. We are using an external ODBC tool to take data
out of the ARS, data is then moved around and built up to build a client
profile. This data then needs to be put back into the ARS. The ODBC tool we
are using is not allowing us to do this. Will upgrading to Version 5.0.1
help us with this if so how?

I have not used version 5 as yet and would appreciate any info.

SQL Server 7
ARS 4.5.2 moving to 5.0.1

Regards

Alan



To UNSUBSCRIBE, email the message "unsubscribe arslist" to:
listserv@listserv.vistait.com
You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org