Utility to Execute SQL queries from Remedy a form

2007-10-28 Thread Mike Buick
Dear Listeners,
 
Remedy SQL Utility?
 
With no direct access to the live Oracle database (managed by the DBAs),  but 
need to run some sql queries and capture the results.
 
Have built some basic solutions, which work okay, even returning  multiple 
entries in the search results, but presentation is not  ideal.
 
So wondering if a utility has already been put together  somewhere using 
Remedy forms which is a little more practical?
 
Thanks a lot
Mike



   

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are


Flashboard Refresh Automatically

2007-10-28 Thread Rami S Ayoub
**

Hi List,

 

I have a problem with dashboard didn't refresh at all , there is any solution I 
have configured the flashboard variables to be refresh every one mint but there 
is no action happen.

 

Any one has experience with this issue.

 

Regards,

Rami

 

 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are


Re: Will Infopath kill custom ARS development?

2007-10-28 Thread Roelandse, Ton
As a long time Remedy Person, since 1993, and a 4 year Sharepoint 2003
and now also MOSS2007 (Microsoft Office Sharepoint Services)
knowledgeable person, that has seen this implement with infopath.. I
would like to weigh in on this a little, (and agree with Guillaume's
view).

From what I have seen from MOSS Architecture, and a bit of future
direction stuff, Sharepoint will be at the core of Microsofts
productivity apps (for instance Microsoft Team Foundation Server uses
sharepoint components for collaboration), all office2007 products use
either bits of sharepoint or are natively prepared to integrate into
MOSS. Outlook address lists will be managed as 'lists' on MOSS, instead
of a separate outlook format, etc. So it is very likely that this will
lead to more MS apps based on sharepoint .Net architecture. Nothing
wrong with that.

However, the workflow capabilities that currently exist in Remedy ARS,
and the Admin functions are far advanced and are not easily recplicated.
Sharepoint requries a lot of hardcore programming to make anything work.
Performance is not really suberb either. For now, MOSS2007 is mainly a
team and document collaboration platform (Blog, Wiki, document storage,
metadata, etc. with basic document approval workflow build in... If you
need more, get your .Net architects and programmers in, its gonna get
costly. Oh yes, the MOSS .Net platform was not designed by MS to be High
Available..just so you know.

I would actually see a nice integration where attachments currently
stored maybe in Remedy can be stored in Sharepoint, now that would make
some sense...

My 2 cents..
Ton Roelandse
EDS, Office of the CIO.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Guillaume Rheault
Sent: Thursday, October 25, 2007 10:17 AM
To: arslist@ARSLIST.ORG
Subject: Re: Will Infopath kill custom ARS development?

Shawn,

There's been many threads over and over about Remedy's competitors, not
just recently, but for ever since Remedy's inception. My take on this
subject is that there will always be competitors to Remedy ARS and BMC
in general, and in my opinion, that's just a natural and inherent
benefit/risk of a competitive market. So we just have to live with it. 

My $0.02

Guillaume


-Original Message-
From: Action Request System discussion list(ARSList) on behalf of
Pierson, Shawn
Sent: Thu 10/25/07 8:08 AM
To: arslist@ARSLIST.ORG
Subject: Will Infopath kill custom ARS development?
 
Good morning folks,

This isn't a question to get help per se, but rather just to start a
discussion.  I recently started using Office 2007 at work and started
looking at one of the new applications - Infopath.  It is a form
development tool that you can use to connect to databases, web services,
etc.  You can then take these forms and upload them to Sharepoint, so
they become gui written web enabled applications.  While it currently
does not have anything close to the functionality of Remedy, I hear a
lot of excitement about this tool.  Given the fact that Microsoft is
going to release their own ITSM type software and all the enhancements
they are putting into Sharepoint, I'm wondering how many companies out
there are talking about going down the Microsoft route and ditching
Remedy.

What are your thoughts on this software, and what do you think it means
for the future of ARS development?

Shawn Pierson

Private and confidential as detailed a
href=http://www.sug.com/disclaimers/default.htm#Mail;here/a.  If you
cannot access hyperlink, please e-mail sender.


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where
the Answers Are




___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where
the Answers Are


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where
the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are


Re: Flashboard Refresh Automatically

2007-10-28 Thread Roger Justice
You need an Active Link on the Form with the Flashboard that refreshes the 
Flashboard object.


-Original Message-
From: Rami S Ayoub [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Sun, 28 Oct 2007 11:02 am
Subject: Flashboard Refresh Automatically


** 

**

Hi List,

 

I have a problem with dashboard didn’t refresh at all , there is any solution I 
have configured the flashboard variables to be refresh every one mint but there 
is no action happen.

 

Any one has experience with this issue.

 

Regards,

Rami

 

 

__20060125___This posting was submitted with HTML in it___ 


Email and AIM finally together. You've gotta check out free AOL Mail! - 
http://mail.aol.com

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are


Re: Trying to write some data to a file using Active link runprocess

2007-10-28 Thread Angus Comber
That's great.

I am currently doing this:

%ComSpec% /c Echo DIAL $Caller ID$   C:\Documents and
Settings\%USERNAME%\Application Data\MyAppName\commandfile.txt

Which works.

I now ideally would like to make a file of the format:

CommandFiledatetimestamp.txt

Would this be possible?

I think some of the date time stamp characters may be illegal in a filename
(environment is the client so Windows).

Anyone know how to create a filename out of date or time stamp type
variables in Remedy - so I can put in the Run Process command line field?

Angus

- Original Message -
From: Schryver, Curt [EMAIL PROTECTED]
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Sent: Friday, October 26, 2007 5:33 PM
Subject: Re: Trying to write some data to a file using Active link
runprocess


You can do it, but you must understand that this method will write the
file to the user's machine.  The format I'm using is:

%ComSpec% /c Echo $MyRemedyField$  C:\mytextfile.txt

Good luck.

BTW, I'm tinkering with Escalations to see if I can write the file to
the server.


Curt A. Schryver
717-810-2109 tel
[EMAIL PROTECTED]

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Angus Comber
Sent: Friday, October 26, 2007 1:16 PM
To: arslist@ARSLIST.ORG
Subject: Trying to write some data to a file using Active link
runprocess

Hello

I would like to use an active link runprocess to write data to a text
file.
I have tried this sort of thing:

'echo $MyRemedyField$  C:\mytextfile.txt'

(and yes realise will have to use different path for a real system)

But I keep getting the error: The system cannot find the file specified.

And I am ensuring the file exists.

Can anyone help.  I basically want to write some text in a Remedy form
text
field out to a text file on a user clicking a button.

Angus


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where
the Answers Are


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the
Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are


Re: Trying to write some data to a file using Active link runprocess

2007-10-28 Thread Carlos Ungil
On 10/26/07, Schryver, Curt [EMAIL PROTECTED] wrote:
 You can do it, but you must understand that this method will write the
 file to the user's machine.

You can also run the process on the server, adding @@: before the command.

Carlos

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are


Re: Vancouver...

2007-10-28 Thread Kendhammer, Mike
Hey all,
I have been here since Wednesday night. Just logged in today, family trip... 
:-)  sorry

Here is a long recap...


Went to Whistler on Thursday.  Drive is very scenic, but slow.  A lot of road 
construction.  Whistler itself is a ski village, but will be hosting all the 
skiing events for the 2010 Olympics.  It has a neat market square 
area(including an Olympic information center).  The gondola ride up Mt. 
Whistler was closed until Nov (bummer).  Shannon Falls was neat to see as well, 
but didn't do the really long hike.  It is about a two hour drive.  Squamish is 
a village about half where there.

Went to Lonsdale Ave. in North Vancouver Thurs. night.  Nice view of Vancouver 
across Burrard Inlet.

Went to Victoria (via Ferry) on Friday.  There are two different ferry 
terminals to choose from.  Neither is in Vancouver.  We went to Tsawwassen 
which is about a 30/45 minute drive south of Vancouver.  The ferry goes to 
Swartz Bay.  There is another 1/2 hour drive to downtown Victoria.  Horseshoe 
Bay is in West Vancouver (maybe 15 minutes???), however, it is about a 2 hr 
drive to downtown Victoria.  We drove to Tsawwassen and left our car, but then 
picked up Pacific Coach Tours while on the ferry and caught a bus to downtown 
and back to the ferry.  They do tours from Hotels.  There are a number neat 
places to go to in Victoria (we only caught a few), but make sure you leave an 
entire day to do so.  Also make sure you check the ferry schedules.

Hit downtown Vancouver on Saturday.  Although Granville Island doesn't look 
like much, it is pretty neat.  The Market area was really busy when we were 
there.  After Granville Island, we went to Chinatown. We only spent about an 
hour there, but an interesting area to tour. Be careful though, just north 
northwest of Chinatown (Hastings St, starting from Carrall past Main St), the 
neighborhood is kind of rugged.  Gastown was next which is walking distance 
from the convention center/Pan Pacific Hotel.  Another restaurant/shopping 
area. Again, be careful as Gastown is not too far from Chinatown.

In the afternoon, we went to Stanley Park.  The park is huge.  We drove around 
it stopping at the many attractions.  The Totem Pole area and Prospect Point 
were probably the highlights.  Lions Gate Bridge is a mini Golden gate (from 
Vancouver/Stanley Park across Burrard Inlet to West/North Vancouver).  Didn't 
get a chance to see the Aquarium.

Finally drove through Robson Street Sat. evening.  Seems like an upscale or 
more modern shopping area.  Maybe only 7-8 blocks from the Convention Center??? 
 It was extremely busy...


If I had to choose any of the place I've been to, I guess I'd go to Granville 
Island and Stanley Park for sure if you can.  If you have the time, any/all 
would be worth the visit.  We ran out of time, but wanted to see the Lynn 
Canyon suspension bridge (free compared to the Campilano Bridge), the Campilano 
Fish Hatchery, and Grouse Mountain.  Those could be interesting to see as well. 
 There is a lookout tower downtown (maybe 2-3 block from the convention center) 
that might be of interest as well.

Good luck!  Any questions, let me know!  Maybe see you at RUG, er, UserWorld.

Mike



-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Jarl Grøneng
Sent: Wednesday, October 24, 2007 9:08 AM
To: arslist@ARSLIST.ORG
Subject: Vancouver...

Hi,

Got a couple of days before the conference, anyone have some tip to
spend these days in Vancouver... Like; What not to miss in
Vancouver...

Thanks,
Jarl

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are