Utility to Execute SQL queries from Remedy a form
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
** 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?
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
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
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
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...
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