Re: test
I broke my monitor screen, thanks guys! :} --Kevin From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Shellman, David Sent: Wednesday, September 16, 2009 11:47 AM To: arslist@ARSLIST.ORG Subject: Re: test I didn't try to hit it. Now days I leave bugs alone if they leave me alone. It was the sudden appearance and disappearance as I flipped through email. Took me a few seconds to catch what really happened. Dave From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Atherly Sent: Wednesday, September 16, 2009 11:28 AM To: arslist@ARSLIST.ORG Subject: Re: test Thanks for the update I was wondering how many people hit there screen trying to kill the bug. _ John Atherly | APC by Schneider Electric | Information, Process Organization (IPO) | Remedy Administrator / Developer Phone: +401-7899-5735 ext. 2120 | Fax: +401-789-3710 | Email: john.athe...@apcc.com mailto:%20john.athe...@apcc.com | Site: www.apc.com/ http://www.apc.com/ | Address: 132 Fairgrounds Road, West Kingston, RI 02892 USA *** Please consider the environment before printing this e-mail Shellman, David dave.shell...@tycoelectronics.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 09/16/2009 11:18 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: test ** John, Nice tag. You got me. Dave From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Atherly Sent: Wednesday, September 16, 2009 10:54 AM To: arslist@ARSLIST.ORG Subject: Re: test They are going out. _ John Atherly | APC by Schneider Electric | Information, Process Organization (IPO) | Remedy Administrator / Developer Phone: +401-7899-5735 ext. 2120 | Fax: +401-789-3710 | Email: john.athe...@apcc.com mailto:%20john.athe...@apcc.com | Site: www.apc.com/ http://www.apc.com/ | Address: 132 Fairgrounds Road, West Kingston, RI 02892 USA *** Please consider the environment before printing this e-mail _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ 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. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are image001.gif
Re: Oracle buys Sun
I don't expect sweeping changes, but I do fear slowly mySQL will disappear into outdatedness. It will give lots of people time migrate over to postgreSLQ solution etc. Although I do expect Oracle won't mind being able to keep a cheap good solution around for a while to get a foot in the door and attempt to up sell after they are on the inside. Should be interesting, also worried about Java... oracle doesn't always play nice and that could leave everyone with no cross platform solution. --Kevin From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault Sent: Monday, April 20, 2009 1:26 PM To: arslist@ARSLIST.ORG Subject: OT: Oracle buys Sun ** Not directly related to Remedy ARS, but still interesting news: http://www.computerworld.com/action/article.do?command=viewArticleBasicarticleI d=9131829 I believe Sun being acquired by Oracle is definitely better than if it was acquired by IBM. On the flip side, this probably means mySQL probably needs to find a new home I don't care much about mySQL, although I think it's still a good idea to have a viable open source database available for free -Guillaume _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ 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. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Remedy Search data export to xls
Hello, I haven't ran into this problem myself however here is a link to a handy web page that shows such problems are not Remedy specific and may help with your solving of them. .. ://www.creativyst.com/Doc/Articles/CSV/CSV01.htm http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm To sum it up, apparently you should be avoiding using manual linefeeds if possible, or at least if you want to easily convert around... Also depending if they are getting added to the csv file correctly, then importing in excel you may need manually import (or setup a script to do such), that used specific options rather than the default Excel will default to importing \n as a new field I believe. To test do Data- Import select your file, then selectee delimited, hit next and you should be able to select only the , option as the limiter (or other options as desired) and hit finish. (Instruction may vary depending on exact version of excel etc, if you are even using excel). You should now hopefully have your data with the /n in the same/full fields. Hope this helps a little bit at least. --Kevin From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Manish SINGLA Sent: Tuesday, January 20, 2009 4:29 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Search data export to xls ** Thanks Joe for replysing, Yes of course it's CVS option. problem is when i export to cvs my description value (if it is multiple lines with '\n') break into multiple rows. Can you please share how you avoid such situation. Thanks Regards Manish From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Monday, January 19, 2009 8:05 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Search data export to xls ** What do you mean exported to xls??? There is only a csv option and I didn't have any problems with using the csv option except that leading 0's get truncated if you manipulate the file later using Excel and as a workaround I use Access to do that. Joe From: Manish SINGLA manish.sin...@st.com To: arslist@ARSLIST.ORG Sent: Monday, January 19, 2009 7:40:13 AM Subject: Remedy Search data export to xls Hello List, There is issue of description field, which get copied in multiple rows when exported to xls, through search result reporting. Please note when we perform following: 1. Search field value based tickets on Helpdesk table 2. Run report on search results 3. Try exporting data to xls When data get exported to xls, \n there in Description field breaks description field value to multiple row. I need a solution through which I can export text fields like Description to single cell of xls. Thanks Regards Manish __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ 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. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Seasons Greetings..
For those special (like me) that are working today I will extend the same again today to everyone!! TeleTech(r) Kevin Redick | SMG - Service Monitoring Group | Verizon Online 250 York Street | Suite 100 | London, Ontario N6A 6K2 | Canada 519.931.1820 (direct) | www.teletech.com http://www.teletech.com/ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza Sent: Wednesday, December 24, 2008 10:14 AM To: arslist@ARSLIST.ORG Subject: OT: Seasons Greetings.. ** Wish you all on the list a Very Merry Christmas and a bright and prosperous New Year ahead. For those of you who are non Christians, I wish you a very happy holidays and a Happy New Year.. Have a safe celebration. Cheers Joseph D'Souza __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ 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. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: BMC Elite?
I have also received this BMC elite emails... Date: Mon, 20 Oct 2008 09:47:13 + From: Administrator Collectivex via CollectiveX [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Keep in mind the rmsportal.com address is manually typed in and did not come from rmsportal.com in any shape way or form. With links pointing to: CollectiveX.com and bmcelite.com I just wrote it off as spam of some sort...but wasn't sure what it was really. (Never follow any links in email unless I know what they are). --Kevin From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Will Du Chene Sent: Tuesday, October 21, 2008 12:05 AM To: arslist@ARSLIST.ORG Subject: Re: BMC Elite? ** I don't think so.. I haven't received anything from them personally. If they were harvesting addresses, my guess would be that there would be more traffic and/or complaints. The only exposure that I have had to them is here on the list. With that being said, I am *highly* amused when one does come through. The whole notion of an 'elite' is questionable at best (unless they are in the business of proving their members as such) and affixing the letters BMC on the front is just icing on the cake unless they are sactioned. Heh. IMNSHO - they could have used the name 'remedy monkeys/guys/cyborgs/people/whatever' and got the same effect. Remind me not to laugh when someone claims to be an 'elite' like their poop don't stink. Mon Oct 20 2008 04:16:39 PM CDT from Pierson, Shawn to arslist@ARSLIST.ORG Subject: Re: BMC Elite? ** Basically, I opted out before, but I started getting it again. I'm assuming they pull email addresses from the ARS List whether we signed up or not, and even if we opt out, when they harvest the email addresses here again, it apparently overwrites the opt out__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ 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. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Some receive emails from me with an odd font....
In the web based yahoo mail systems (both classic and their 'new mail') to the right of the subject line there should be a spot where it says Plain Text click on this and it will convert the email your composing to plain text. --Kevin From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Wednesday, October 15, 2008 12:46 AM To: arslist@ARSLIST.ORG Subject: OT: Some receive emails from me with an odd font ** I can't because I am using Yahoo to communicate with the ARS List and the only choices I have to choose from there are some of the standard fonts. I'll look up advanced options on Yahoo to see if they support plain text emails. Joe - Original Message From: Axton [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, October 14, 2008 11:47:07 PM Subject: Use plain text and don't worry about it. Axton Grams On Tue, Oct 14, 2008 at 9:28 PM, Joe DeSouza [EMAIL PROTECTED] wrote: ** I got a couple of listers complain to me that the font they receive my emails in is not very legible. On seeing a screen capture that one of them sent me I completely agree.. The weird thing however is that I am composing and sending my emails using a regular Times New Roman font size 10. I do not know where and how this conversion might be happening. I am wondering if this is impacting all of you or just some of you. In any case I apologize for any inconvenience caused while reading my emails in the format they seem to be going out in. Would some of you care to reply to me and let me know if you are receiving this email in a font other than Times New Roman? I would also appreciate a response from those actually receiving it in Times New Roman format. I have a small reason to believe this font conversion might be happening for those of you who are using Lotus Notes, as I think this same conversion occurs on mails sent to one of my customer here on site who uses Lotus Notes. I can send a screen shot of how outgoing emails appear on my browser before I send them for those interested in helping me find out how this is happening.. I tried to send the image on posting an hour ago and it bounced back because of the size of the email.. Cheers Joe __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ 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. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Arslist Awards, in peril of cancellation
I would just like to add that I have not been on the list very long, nor am I that knowledgeable on the systems discussed (yet) to be able to partake much. Hope that helps explain maybe why at least one of the 4k never submitted anyone. --Kevin From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of ZHANG, ERIC L Sent: Monday, August 18, 2008 9:57 AM To: arslist@ARSLIST.ORG Subject: FW: Arslist Awards, in peril of cancellation ** ** I vote for Chris to be MVP too. -Original Message- From: Frank, Gordon M. (CMS/CTR) [mailto:[EMAIL PROTECTED] Sent: Friday, August 15, 2008 10:06 AM Subject: Re: Arslist Awards, in peril of cancellation MVP! I vote for Dr. Christopher Strauss. He is a long contributor to the ARSlist and is greatly overdue. Chris is on the list constantly and is one of the most helpful Texan's I know. Thank you Chris for all the support you have given us all. I think everyone should vote for Chris and make it a landslide!! Come-on all of you regular contributors! Let's finally get Chris Strauss the MVP! Gordon M. Frank Remedy Skilled Professional ITIL V3 Certified Lockheed Martin From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Daniel Bloom Sent: Tuesday, August 12, 2008 8:16 PM To: arslist@ARSLIST.ORG Subject: ADM:Arslist Awards, in peril of cancellation Well, the nominations have not been impressive in numbers So far, quality yes, numbers no. To the 0.1% of you that have Contributed, thank-you. Perhaps the list as a whole feels that the Awards are no longer needed? That those that contribute so much should do so and don't really deserve some form of recognition for it? That 80% of people on the list can benefit from their knowledge without ever posting, even acknowledging the contributions of the other 20% when all it requires is a few minutes A year to show their appreciation? Or more accurately the 5-10% that provide solid technical responses? I don't have the time or energy to try and get the 4400 + subscribers to Get involved. I will just be disappointed that you don't. (ignore that there are 8000+ that read it). I have spent up to 200 hours preparing for the Awards and doing the presentations (for a single year), And I am not happy with the lack of participation. .. Daniel Founder of the ARSlist 1993 Creator of the Awards 1995 RAC 1995 etc. p.s. and I am contemplating cancelling them due to lack of interest, I give it until Friday evening __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___ 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. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: VBA aruser/Remedy newbie questions
Thank you all for the information, Thanks to LJ I now have runmacro up and working that will help me. Mark, As for the ODBC Data source, unfortunately as I suspect is part of my problem is IT hasn't really properly installed things.(Or as a result of still running V5 may not have these extras). Apparently there is no ODBC drivers installed on our production machines..(its not listed in Data Source anyhow). I suspect the fact I was missing runmacro as well indicates a lack of full/proper install. I'll see if I can work further with my IT to resolve the ODBC issue as I'd love to play with new ways to interact with data. (I often do batch data changes through ARuser as well (currently using macros). --Kevin From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mark Latta Sent: Monday, June 09, 2008 9:00 PM To: arslist@ARSLIST.ORG Subject: Re: VBA aruser/Remedy newbie questions ** 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 -0600 From: [EMAIL PROTECTED] Subject: VBA aruser/Remedy newbie questions To: arslist@ARSLIST.ORG ** 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 App Dim ARForm Dim sessionId ' create a new Remedy User Set App = CreateObject(Remedy.User) ' login, username and password sessionId = 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
VBA aruser/Remedy newbie questions
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 App Dim ARForm Dim sessionId ' create a new Remedy User Set App = CreateObject(Remedy.User) ' login, username and password sessionId = 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(r) 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. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are