Kevin,
I have been doing this for years and the simplest method that I have found is
to use the "AR System ODBC Data Source" available through MS Excel. This ODBC
driver is installed/available by default on workstations that have the Remedy
User Tool installed on it. The best part is that you can simply record an
Excel macro while you establish the ODBC connection to Remedy and define your
query criteria through MS Query. Once you have recorded the code you'll have
almost everything you need to tailor it and to add subsequent formatting,
charting and analysis code for reporting. Here are a few things to keep in
mind for security reasons:
1.) Password protect the excel VBA project (in the VB Editor) to protect the
login and password information which will be recorded for establishing the
database connection
2.) If you opt to return the data to Excel (which isn't necessary for
reporting) you will want to set the following Query/Table property:
EnableEditing = False
This prevents the users from being able to modify the query criteria after
it is retrieved from the database by simply right-clicking on the data in the
Excel worksheet.
Summary of steps for the macro:
1.) From the main Excel menu: Data -> Import External Data -> New Database
Query...
2.) In the "Choose Data Source" pop-up window select the "AR System ODBC Data
Source"
3.) Provide the ODBC login information when prompted.
4.) Select your query criteria through MS Query which was automatically
started. (Select columns, etc.)
You can choose to return the data to Excel or to continue editing in MS Query.
Note: MS Query is limited in capabilities and will not support all datatypes
in Remedy.
The format in which the query criteria is recorded is a bit difficult to edit.
However you can replace that with a query sting property which allows you to
enter plain text that is much simpler to read and edit than the array type
construction that it records it in.
Let me know if you need any additional help. Feel free to email me directly at
[EMAIL PROTECTED]
- Mark Latta
Date: Mon, 9 Jun 2008 10:17:00 -0600From: [EMAIL PROTECTED]: VBA aruser/Remedy
newbie questionsTo: [EMAIL PROTECTED]
Hi everyone I want to apologize as I think my questions may seem a bit to
simple and/or below the level that most of this group is, hoping to have better
questions and maybe some answers for other newbies like me.
Unfortunately due to my current system limitation/access I am stuck only
being able to use VBA and am currently pulling a lot of Data through ARUSER for
my reports.
Right now the method I am using to pull information is via the following
code:
################################
Sub LaunchRemedy(macroname)Dim AppDim ARFormDim sessionId
' create a new Remedy UserSet App = CreateObject("Remedy.User")
' login, username and passwordsessionId = App.Login("username", "password",
False)
Call App.RunMacro(sessionId, macroname, 0, 0)
#################################
This generally works, I pre-generate my Macro's using VBA and have this call
ARUSER and typically dump out my report for the data I need to a CSV that is
then picked up and my VBA program continues along.
My question would be, if there a way using only VBA that I
a. might be able to run a data set, or a macro without having to call the
ARUSER program?
(This is a problem as after only a few hours of continuous polling (My
current report pulls around 500+ unique tickets every 5 minutes) ARUSER runs
out of system memory.
or
b. just to get me started while I hopefully learn some better ways, is
there an easy way to close aruser directly? I currently have my code attempt to
close pull AR system user into focus after ~40 macro's to close it, and re-open
it. The code I am using right now is bad however.
###
' Close Remedy
SendKeys ("%F")SendKeys ("x")
###
Very bad code, and as I typically wish to have my reports running in the
background of my current work machine this can also cause problems...
P.S. we are using V5.01 I believe ... I only have access to ARUSER.EXE..
ARTASK.EXE doesn't load for me and I do not have registry access. Also I have
no armacro(?) program I have read about in the documentation to play with...
TeleTech®
Kevin Redick | SMG – Service Monitoring Group | Verizon Online
Please visit us at http://www.teletech.com
............................................................ This email and any
attachments may contain confidential, proprietary and/or privileged
information. If you are not the intended recipient, please immediately notify
the sender by return email, and delete this communication and any copies. Any
dissemination or use of this information by a person other than the intended
recipient is unauthorized and may be subject to criminal and civil proceedings.
Unless otherwise stated, opinions expressed in this email are those of the
author and are not endorsed by TeleTech Holdings.
............................................................
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___
_________________________________________________________________
It’s easy to add contacts from Facebook and other social sites through Windows
Live™ Messenger. Learn how.
https://www.invite2messenger.net/im/?source=TXT_EML_WLH_LearnHow
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
