Re: RSS feeds to Remedy data
Here is a little something I did with Klink and Ruby.
It writes an xml file properly formatted for rss for each and every
group in "Group".
It populates the rss with a query against a fictitious table
"KineticRequests" where Status = 2 (Assigned) and Group = "Group Name".
(It is written in my new favorite language Ruby -- however -- Klink
will work with any language)
Get klink here http://www.kineticdata.com/Products/KineticLink.html
If you are interested in my 'link' library for Ruby (uses Kinetic
Link) -- email me direct off the list.
require 'rss/maker'
require 'link'
Kinetic::Link::entries('Group').each do |group|
group_detail = Kinetic::Link::entry('Group',group)
group_name = group_detail['105']
content = RSS::Maker.make("2.0") do |m|
m.channel.title = "#{group_name} Open Requests"
m.channel.link = "http://somewhere";
m.channel.description = "#{group_name} list of assigned requests"
m.items.do_sort = true # sort items by date
Kinetic::Link.entries('KineticRequests', "\'Status\'=\"2\" AND
\'Assigned_to\' = \"#{group_name}\"").each do |entry|
entry_detail = Kinetic::Link.entry('KineticRequests',entry)
i = m.items.new_item
i.title = entry_detail['8']
i.link = "http://someserver/someprogram?#{entry_detail['1']}"
i.date = Time.now
end
end
File.open("rss-feed-#{group_name}.xml","w") do |f|
f.write(content)
f.close
end
end
-John
--
John David Sundberg
235 East 6th Street, Suite 400B
St. Paul, MN 55101
(651) 556-0930-work
(651) 247-6766-cell
(651) 695-8577-fax
[EMAIL PROTECTED]
On Sep 25, 2008, at 4:16 AM, Steven Pataray wrote:
**
Great I understand. So for my support staffs request I would have to
create an xml file that only displays his groups tickets using an
Escalation. But to set this up so others can see there own data
(bigger picture) I would have to create a form available via Mid-Tier
with a drop down box of all the different groups and they would have
to select what groups tickets they would like to see. Then with
workflow create the xml and post it. Sounds pretty easy as long as I
can get the xml to look correct.
By the way, I tried to use the Data Visualization, but found out that
the Data Visualization Server needs to be configured on Mid-Tier to
get it to work. Mid-Tier 6.3 doesn't have that field in the available
in the config_general.jsp. I'm guessing that it's in 7.x version.
The Klink doesn't work on ServletExec which my Mid-Tier is setup on.
This is the same problem I ran into getting the Kinetic survey lite to
work. I have ServletExec running my Mid-Tier on the same server as the
arsystem application. I was told that both ServletExec and Tomcat can
co-exist on the same server but the arsystem Java requirements for
arserver 6.3 is 1.4 and Tomcat is a minimum of 1.5 so it had a
conflict. :-/ I'm still interested in the Klink product so I'll
probably just setup a virtual webserver to handle this instead.
Mahalo for all your suggestions.
Steve
On Wed, Sep 24, 2008 at 6:26 AM, Theo Fondse <[EMAIL PROTECTED]> wrote:
**
Steve,
You can DIY in any version of ARS simply by creating workflow that
creates a .xml text file that complies to the format requirements for
RSS (see http://cyber.law.harvard.edu/rss/rss.html ) and publishing it
on your web server – Easy.
The BMCDN utility is also easy to use.
Best Regards,
Theo
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG
] On Behalf Of Steven Pataray
Sent: 23 September 2008 21:59
To: arslist@ARSLIST.ORG
Subject: Re: RSS feeds to Remedy data
**
View fields are suported so that's promissing. I'll see if the .def
files which were provided will work.
Mahalo,
Steve
On Tue, Sep 23, 2008 at 7:48 AM, Joe DeSouza <[EMAIL PROTECTED]>
wrote:
**
Data Visualization fields are an extension to View fields - in
architecture I think its the same rose with a different name..
Does it not work with MT 6.3?
Joe
- Original Message
From: Steven Pataray <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Tuesday, September 23, 2008 1:40:27 PM
Subject: Re: RSS feeds to Remedy data
**
I looked at the BMC Developers Network which David Easter pointed me
to and then also looked within the forums for more info and they all
are hinting that we have to be at Mid-Tier/Arsystem of 7.1x because it
uses the Data Visualization. Is that really required? Does using the
Data Visualization the only way to publish the xml? Our company is
currently at Mid-Tier/Arsystem 6.3. Can this be done on this lower
version?
Mahalo,
Steve
Re: RSS feeds to Remedy data
Great I understand. So for my support staffs request I would have to create an xml file that only displays his groups tickets using an Escalation. But to set this up so others can see there own data (bigger picture) I would have to create a form available via Mid-Tier with a drop down box of all the different groups and they would have to select what groups tickets they would like to see. Then with workflow create the xml and post it. Sounds pretty easy as long as I can get the xml to look correct. By the way, I tried to use the Data Visualization, but found out that the Data Visualization Server needs to be configured on Mid-Tier to get it to work. Mid-Tier 6.3 doesn't have that field in the available in the config_general.jsp. I'm guessing that it's in 7.x version. The Klink doesn't work on ServletExec which my Mid-Tier is setup on. This is the same problem I ran into getting the Kinetic survey lite to work. I have ServletExec running my Mid-Tier on the same server as the arsystem application. I was told that both ServletExec and Tomcat can co-exist on the same server but the arsystem Java requirements for arserver 6.3 is 1.4 and Tomcat is a minimum of 1.5 so it had a conflict. :-/ I'm still interested in the Klink product so I'll probably just setup a virtual webserver to handle this instead. Mahalo for all your suggestions. Steve On Wed, Sep 24, 2008 at 6:26 AM, Theo Fondse <[EMAIL PROTECTED]> wrote: > ** > > Steve, > > > > You can DIY in any version of ARS simply by creating workflow that creates > a .xml text file that complies to the format requirements for RSS (see > http://cyber.law.harvard.edu/rss/rss.html ) and publishing it on your web > server – Easy. > > > > The BMCDN utility is also easy to use. > > > > > > Best Regards, > > Theo > > > > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Steven Pataray > *Sent:* 23 September 2008 21:59 > *To:* arslist@ARSLIST.ORG > > *Subject:* Re: RSS feeds to Remedy data > > > > ** > > View fields are suported so that's promissing. I'll see if the .def files > which were provided will work. > > > > Mahalo, > > Steve > > On Tue, Sep 23, 2008 at 7:48 AM, Joe DeSouza <[EMAIL PROTECTED]> wrote: > > ** > > Data Visualization fields are an extension to View fields - in architecture > I think its the same rose with a different name.. > > > > Does it not work with MT 6.3? > > > > Joe > > > > - Original Message > From: Steven Pataray <[EMAIL PROTECTED]> > To: arslist@ARSLIST.ORG > Sent: Tuesday, September 23, 2008 1:40:27 PM > Subject: Re: RSS feeds to Remedy data > > ** > > I looked at the BMC Developers Network which David Easter pointed me to and > then also looked within the forums for more info and they all are hinting > that we have to be at Mid-Tier/Arsystem of 7.1x because it uses the Data > Visualization. Is that really required? Does using the Data Visualization > the only way to publish the xml? Our company is currently at > Mid-Tier/Arsystem 6.3. Can this be done on this lower version? > > Mahalo, > > Steve > > On Tue, Sep 23, 2008 at 12:26 AM, Theo Fondse <[EMAIL PROTECTED]> wrote: > > ** > > Hi Steve! > > > > Been there, done that. Created a console form for adding messages and an > escalation that publishes the xml file on the web server. Very easy to do. > > > > > > > > Best Regards, > > Theo > > > > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Steven Pataray > *Sent:* 23 September 2008 01:48 > > > *To:* arslist@ARSLIST.ORG > *Subject:* RSS feeds to Remedy data > > > > ** > > One of my support people asked if Remedy data can be available via RSS > feeds. I guess he was thinking he could subscribe to a groups queue and > access it to have a quick lookup of what is outstanding. Does anyone know if > this type of service is possible or would be possible in the future? > > > > Windows 2003 - Remedy 6.3 > > Oracle 10GR1 > > > > Mahalo, > > Steve > > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: RSS feeds to Remedy data
Steve, You can DIY in any version of ARS simply by creating workflow that creates a .xml text file that complies to the format requirements for RSS (see http://cyber.law.harvard.edu/rss/rss.html ) and publishing it on your web server - Easy. The BMCDN utility is also easy to use. Best Regards, Theo From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Steven Pataray Sent: 23 September 2008 21:59 To: arslist@ARSLIST.ORG Subject: Re: RSS feeds to Remedy data ** View fields are suported so that's promissing. I'll see if the .def files which were provided will work. Mahalo, Steve On Tue, Sep 23, 2008 at 7:48 AM, Joe DeSouza <[EMAIL PROTECTED]> wrote: ** Data Visualization fields are an extension to View fields - in architecture I think its the same rose with a different name.. Does it not work with MT 6.3? Joe - Original Message From: Steven Pataray <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Tuesday, September 23, 2008 1:40:27 PM Subject: Re: RSS feeds to Remedy data ** I looked at the BMC Developers Network which David Easter pointed me to and then also looked within the forums for more info and they all are hinting that we have to be at Mid-Tier/Arsystem of 7.1x because it uses the Data Visualization. Is that really required? Does using the Data Visualization the only way to publish the xml? Our company is currently at Mid-Tier/Arsystem 6.3. Can this be done on this lower version? Mahalo, Steve On Tue, Sep 23, 2008 at 12:26 AM, Theo Fondse <[EMAIL PROTECTED]> wrote: ** Hi Steve! Been there, done that. Created a console form for adding messages and an escalation that publishes the xml file on the web server. Very easy to do. Best Regards, Theo From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Steven Pataray Sent: 23 September 2008 01:48 To: arslist@ARSLIST.ORG Subject: RSS feeds to Remedy data ** One of my support people asked if Remedy data can be available via RSS feeds. I guess he was thinking he could subscribe to a groups queue and access it to have a quick lookup of what is outstanding. Does anyone know if this type of service is possible or would be possible in the future? Windows 2003 - Remedy 6.3 Oracle 10GR1 Mahalo, Steve __Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: RSS feeds to Remedy data
Steven, You may want to give KLink a shot at this too. http://www.kineticdata.com/Products/KineticLink.html " Kinetic Link is an open-source web framework that allows almost any language to interact with your BMC Remedy AR system. Through Klink you can create records, view data, and update or delete information. The framework provides a consistent XML over HTTP interface utilizing Java Servlets and Apache Struts. " I would expect that it would be fairly trivial to setup a Klink page to produce an XML output compatible with most RSS readers. ( If you ask really nicely you might even get the Kinetic group to publish a small working example. :) They do watch the list, and this kind of example might be useful to others too. ) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Tue, Sep 23, 2008 at 3:59 PM, Steven Pataray <[EMAIL PROTECTED]> wrote: > ** > View fields are suported so that's promissing. I'll see if the .def files > which were provided will work. > > Mahalo, > Steve > >>> From: Action Request System discussion list(ARSList) >>> [mailto:[EMAIL PROTECTED] On Behalf Of Steven Pataray >>> Sent: 23 September 2008 01:48 >>> To: arslist@ARSLIST.ORG >>> Subject: RSS feeds to Remedy data >>> >>> >>> >>> ** >>> >>> One of my support people asked if Remedy data can be available via RSS >>> feeds. I guess he was thinking he could subscribe to a groups queue and >>> access it to have a quick lookup of what is outstanding. Does anyone know if >>> this type of service is possible or would be possible in the future? >>> >>> >>> >>> Windows 2003 - Remedy 6.3 >>> >>> Oracle 10GR1 >>> >>> >>> >>> Mahalo, >>> >>> Steve ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: RSS feeds to Remedy data
View fields are suported so that's promissing. I'll see if the .def files which were provided will work. Mahalo, Steve On Tue, Sep 23, 2008 at 7:48 AM, Joe DeSouza <[EMAIL PROTECTED]> wrote: > ** > > Data Visualization fields are an extension to View fields - in architecture > I think its the same rose with a different name.. > > > > Does it not work with MT 6.3? > > > > Joe > > - Original Message > From: Steven Pataray <[EMAIL PROTECTED]> > To: arslist@ARSLIST.ORG > Sent: Tuesday, September 23, 2008 1:40:27 PM > Subject: Re: RSS feeds to Remedy data > > ** I looked at the BMC Developers Network which David Easter pointed me to > and then also looked within the forums for more info and they all are > hinting that we have to be at Mid-Tier/Arsystem of 7.1x because it uses the > Data Visualization. Is that really required? Does using the Data > Visualization the only way to publish the xml? Our company is currently at > Mid-Tier/Arsystem 6.3. Can this be done on this lower version? > Mahalo, > Steve > On Tue, Sep 23, 2008 at 12:26 AM, Theo Fondse <[EMAIL PROTECTED]> wrote: > >> ** >> >> Hi Steve! >> >> >> >> Been there, done that. Created a console form for adding messages and an >> escalation that publishes the xml file on the web server. Very easy to do. >> >> >> >> >> >> >> >> Best Regards, >> >> Theo >> >> >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> [EMAIL PROTECTED] *On Behalf Of *Steven Pataray >> *Sent:* 23 September 2008 01:48 >> *To:* arslist@ARSLIST.ORG >> *Subject:* RSS feeds to Remedy data >> >> >> >> ** >> >> One of my support people asked if Remedy data can be available via RSS >> feeds. I guess he was thinking he could subscribe to a groups queue and >> access it to have a quick lookup of what is outstanding. Does anyone know if >> this type of service is possible or would be possible in the future? >> >> >> >> Windows 2003 - Remedy 6.3 >> >> Oracle 10GR1 >> >> >> >> Mahalo, >> >> Steve >> > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: RSS feeds to Remedy data
Data Visualization fields are an extension to View fields - in architecture I think its the same rose with a different name.. Does it not work with MT 6.3? Joe - Original Message From: Steven Pataray <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Tuesday, September 23, 2008 1:40:27 PM Subject: Re: RSS feeds to Remedy data ** I looked at the BMC Developers Network which David Easter pointed me to and then also looked within the forums for more info and they all are hinting that we have to be at Mid-Tier/Arsystem of 7.1x because it uses the Data Visualization. Is that really required? Does using the Data Visualization the only way to publish the xml? Our company is currently at Mid-Tier/Arsystem 6.3. Can this be done on this lower version? Mahalo, Steve On Tue, Sep 23, 2008 at 12:26 AM, Theo Fondse <[EMAIL PROTECTED]> wrote: ** Hi Steve! Been there, done that. Created a console form for adding messages and an escalation that publishes the xml file on the web server. Very easy to do. Best Regards, Theo From:Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Steven Pataray Sent: 23 September 2008 01:48 To: arslist@ARSLIST.ORG Subject: RSS feeds to Remedy data ** One of my support people asked if Remedy data can be available via RSS feeds. I guess he was thinking he could subscribe to a groups queue and access it to have a quick lookup of what is outstanding. Does anyone know if this type of service is possible or would be possible in the future? Windows 2003 - Remedy 6.3 Oracle 10GR1 Mahalo, Steve ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: RSS feeds to Remedy data
I looked at the BMC Developers Network which David Easter pointed me to and then also looked within the forums for more info and they all are hinting that we have to be at Mid-Tier/Arsystem of 7.1x because it uses the Data Visualization. Is that really required? Does using the Data Visualization the only way to publish the xml? Our company is currently at Mid-Tier/Arsystem 6.3. Can this be done on this lower version? Mahalo, Steve On Tue, Sep 23, 2008 at 12:26 AM, Theo Fondse <[EMAIL PROTECTED]> wrote: > ** > > Hi Steve! > > > > Been there, done that. Created a console form for adding messages and an > escalation that publishes the xml file on the web server. Very easy to do. > > > > > > > > Best Regards, > > Theo > > > > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Steven Pataray > *Sent:* 23 September 2008 01:48 > *To:* arslist@ARSLIST.ORG > *Subject:* RSS feeds to Remedy data > > > > ** > > One of my support people asked if Remedy data can be available via RSS > feeds. I guess he was thinking he could subscribe to a groups queue and > access it to have a quick lookup of what is outstanding. Does anyone know if > this type of service is possible or would be possible in the future? > > > > Windows 2003 - Remedy 6.3 > > Oracle 10GR1 > > > > Mahalo, > > Steve > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: RSS feeds to Remedy data
Hi Steve! Been there, done that. Created a console form for adding messages and an escalation that publishes the xml file on the web server. Very easy to do. Best Regards, Theo From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Steven Pataray Sent: 23 September 2008 01:48 To: arslist@ARSLIST.ORG Subject: RSS feeds to Remedy data ** One of my support people asked if Remedy data can be available via RSS feeds. I guess he was thinking he could subscribe to a groups queue and access it to have a quick lookup of what is outstanding. Does anyone know if this type of service is possible or would be possible in the future? Windows 2003 - Remedy 6.3 Oracle 10GR1 Mahalo, Steve __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: RSS feeds to Remedy data
Hi Steven, Check out the BMC Developer's Network. http://developer.bmc.com/communities/docs/DOC-2782 -David J. Easter Sr. Product Manager, Solution Strategy and Development BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Steven Pataray Sent: Monday, September 22, 2008 4:48 PM To: arslist@ARSLIST.ORG Subject: RSS feeds to Remedy data ** One of my support people asked if Remedy data can be available via RSS feeds. I guess he was thinking he could subscribe to a groups queue and access it to have a quick lookup of what is outstanding. Does anyone know if this type of service is possible or would be possible in the future? Windows 2003 - Remedy 6.3 Oracle 10GR1 Mahalo, Steve __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
RSS feeds to Remedy data
One of my support people asked if Remedy data can be available via RSS feeds. I guess he was thinking he could subscribe to a groups queue and access it to have a quick lookup of what is outstanding. Does anyone know if this type of service is possible or would be possible in the future? Windows 2003 - Remedy 6.3 Oracle 10GR1 Mahalo, Steve ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
