Re: Date Format - US/UK
In a similar mixed shop I found the only safe solution was to hide *all* date fields, make dates display with the month spelt out and use drop down lists for day/month/year and do the conversion under the covers. HTH -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: History of AR System
Can someone remind me: 1) What was the last version that would run on Windows 3.1? 2) What was the last version with a full set of tools on *nix? 3) What was the last version that could use the flat file "DB"? TIA -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
OT - Disk encryption
I know a lot of you work in sensitive areas - So, any experiences with whole disk encryption software for XP? Currently I am looking at: PGP Whole Disk Encryption DESlock+ And a new kid on the block, ZoneCentral TIA -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
OT Laptop encryption options
Sorry for the off topic post, but I know a lot of you work in sensitive places. I have a friend who is an Osteopath and she wants to use a laptop to record case notes. Now here in the UK that would be classed as medical records and need protection - Data Protection Act etc. She is also not very computer literate. So the question is; What possibilities are there such that anything she saves to her hard drive is automatically encrypted and decrypted when accessed, with pass phrase on access obviously. Also files would need to *stay* encrypted if copied to an external drive/DVD for backup purposes. And such backup should not prompt for decryption. Said laptop will be running XP or Vista - The former if I have much to do with it :-) TIA -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
UKRUG Registrations Now Open
Less than a month to go to the UKRUG ( UK Remedy User Group) on November 5th in London at One Great George Street, Please register your interests Technical or Business streams so we can gauge how may people are in each stream. Confirmed topics So far: BMC - Blade Logic how will it fit with Remedy BMC - ARS 7.1 what's inside & Others Met Office - customer story Partner Briefings TBC TBC Partner Fair: Sponsors: BMC Borland Devoteam Fusion GDCM Kinetic Data RMSTiberone Please register at http://www.ukrug.org/ukrug_2008/register.shtml and be entered in the prize draw at the end. -- Kind regards. Dave Saville UKRUG Committee Tel: 01689 823639 Mob: 07951 048876 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Remedy - sensitive to network performance?
On Fri, 27 Jun 2008 10:08:35 -0400, Axton wrote: >Dave, > >Unless you have a network that supports jumbo frames, all the data >sent over the network gets broken into 1500 or less bytes per packet. >There is no reason to use packets bigger than 1500 bytes unless you >want to test fragmentation/defragmentation at each of the end points. >For measuring throughput: firewalls are typically limited by packets >per second, not bytes per second, up to the bandwidth the links >support; switches typically have a fiber capacity measured in >throughput (bits). Fair point - But at at *least* use 1500 rather than the default 56 - I have seen what I said happen many times. -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Remedy - sensitive to network performance?
On Thu, 26 Jun 2008 12:06:25 -0600, Dave Wilmot wrote: >Dave, > >Your systems administrator(s) should easily be able to isolate the network >as the problem (or not) by running one or more utilities which will check >network "round-trip" times. One such tool might be the Solaris (Sun Unix) >"ping -sRv" command, which shows trip times to each "hop" or "router" on >the way to the remote location/server. Bear in mind that your average sysadmin will execute "ping server_appearing_slow_to_ars_client" and pronounce that there is nothing wrong with the network. This is because ping by default only generates a tiny packet, like 56 bytes or similar. You need to specify a *big* packet size ( integer number after host - ping host 8192 for example for an 8K packet.) Yes Remedy is very chatty over the network, but they are also often big packets -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: SQL Stored procedures
Warren Are you sure you have the correct invocation syntax in Remedy? ISTR it is a bit picky. -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Ping
On Sun, 3 Feb 2008 21:55:18 -0500, Axton wrote: >Some more digging revealed the following: > >http://www.opengroup.org/onlinepubs/009695399/functions/popen.html > >The *popen*() function should not be used by programs that have set user (or >group) ID privileges. The >*fork*()<http://www.opengroup.org/onlinepubs/009695399/functions/fork.html>and >*exec ><http://www.opengroup.org/onlinepubs/009695399/functions/exec.html>*family >of functions (except >*execlp*()<http://www.opengroup.org/onlinepubs/009695399/functions/execlp.html>and >*execvp*()<http://www.opengroup.org/onlinepubs/009695399/functions/execvp.html>), >should be used instead. This prevents any unforeseen manipulation of the >environment of the user that could cause execution of commands not >anticipated by the calling program. Basically all that says is whatever is run under popen runs as the caller. In this case ARS, which should not have those privileges - and if they are running as root they deserve all they get :-) Calling something that uses popen from ARS is no better or worse than invoking any other command with a run process. -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: GPL'd software in Remedy api
On Wed, 2 Jan 2008 10:35:35 -0500, Axton wrote: >Ah, I must be going blind. Sorry for the noise. > >Axton That's OK - We are all allowed one mistake per year :-) -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: SQL Procedure Excution in Oracle Vs Remedy.
On Tue, 11 Dec 2007 16:54:52 +0530, Gopala Krishna Peela wrote: > >Hi , > > > >I am trying to execute an external db procedure from my remedy >application through dblink connectivity. > > > >I am not getting any errors while executing it separately through in >Oracle using Toad. > >But I am facing the below error while executing it from Filter or >Activelink using DirectSQL action. > >Expenditure type does not exist. Are you sure that remedy is connecting to the external DB with the same user ID/permissions as when you test with TOAD? -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
UK Remedy User Group 10th of October 2007 London
There are still spaces for the next UKRUG meeting. Here is the provisional agenda: Industry trends in SM and the future direction of BMC and it's SM products - Doug Mueller. Yes *that* Doug Mueller. Empowering the Help Desk agent with tools and infrastructure to help them cope with the complexities of a rapidly evolving service environment. - Dr Orhan Ertughrul (D. Phil.) License Optimisation and Monitoring - Misi Mladoniczky Control Unplanned Change - Tripwire ITSM 6 ?> 7 Migration - Ben Chernys 20 Things You Didn't Know About BMC - Tony Goodwin, BMC Support Automation takes CenterBeam's IT Support Offering to a New Level - TiFiC Performance / Sizing / Scalability - Tim Harris. BMC ITIL 3 and How it Relates to the Remedy Suite - Fusion Implementation of Service Request Management - Devoteam Tertio Registration for this *free* event: http://www.ukrug.org/ukrug_2007/register.shtml See you there. -- Kind regards. Dave Saville UKRUG Committee ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
UK RUG 2007 - 10th of October 2007 Registration Open
Registration for this free event is now open : http://www.ukrug.org See you there. -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
UK Remedy user group 10th of October 2007
The next UK Remedy User group is on the 10th of October 2007 LOCATION: Institute of Civil Engineers, One George Street, London http://www.onegreatgeorgestreet.com/ Attendance is free to delegates as the cost of the event is covered by our sponsors. We are trying a new way to introduce the sponsors - "Speed Dating" - Each sponsor will be allowed a one-minute elevator pitch during the Welcome Opening speech. The purpose of this one-minute pitch is to invite you to listen to their 10 minute Breakout Track. Registration will open hopefully very soon at http://www.ukrug.org -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: how to escape quotes in setfield action ?
On Mon, 16 Jul 2007 15:07:47 -0400, Terry Bootsma wrote: As a general rule: You need a quoted string - so start with a " If you need a quote double the number you did last time "" close quotes use the opposite rule. So a quoting a string with a quote containing a quote would be (extra spaces for clarity) " I am a string that has "" a quote inside and a """" quote inside that """" "" " You often need this in *nix scripts where the string may be parsed more than once through the shell for example. HTH >I've done this several times using the following technique: > >Create a display only field... call it "_Quote". Set the default value to >the quotation mark. > >On active link firing do the following > >action1 - set _Quote to it's default value. > >action 2 - Use the set fields action such as $_Quote$ + "hello" + $_Quote$ > >Works for me all the time... > >Terry > > >-Original Message- >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] Behalf Of Andrew Hicox >Sent: Monday, July 16, 2007 2:16 PM >To: arslist@ARSLIST.ORG >Subject: how to escape quotes in setfield action ? > > >Everyone: > >I've got an active link with a set fields action. >I need to set a string containing quotes into a char field. > >For the sake of brevity, let's just say I need to set the string: >"hello" (including the quotes) into a char field. > >I can't figure out how to escape the quotes in the set fields action. >\" dosen't seem to work, nor "\ or \\". > >I can't find a thing in the documentation on this. >Can anyone help me ? > >thanks, > >-Andrew > > >Andrew N. Hicox >Hicox Information Systems LLC >Manassas, VA USA >http://hicox.com >[EMAIL PROTECTED] >703-367-9085 > >____ >___ >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" > -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Regarding the Replace function
Hm, there has got to be an easier method of bolting fields together :-) You have not blown the field length of the field that is the destination of that lot have you? -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Help On Perl Code
On Mon, 2 Apr 2007 11:29:06 +0530, Ravikumar_Tadi wrote:
>Hello Listers,
> I am currntly working on ARS 4.5. Perl script is unable
> to identify the pipe Symbol.
>
>>>open(Datafile, "$Datfile") || die("data file open failed");
>>>foreach $Sentance ()
>>> {
>>>
>>> @dataarray = split("|",$Sentance);
>>> print "$dataarray[0]\n";
>>> print "$dataarray[1]\n";
>>> print "$dataarray[2]\n";
>>>
>>>}
>>>close(Datafile);
>>>
>>>Where $Senctence = ABC|DEF|GHI
>>>
>>>When i run this the result is:
>>>A
>>>B
>>>C
>>>
>>>But expected result is :
>>>
>>>ABC
>>>DEF
>>>GHI
>
>Seems If I replace pipe with " , " ( with comma) it is working.
>Please help in this regard ASAP>
On opens you need "or" not pipe - Different level of binding.
open FILE, $filename or die "Can't open $filename $!\n";
HTH
--
Regards
Dave Saville
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
Re: BMC Support Doesn't
On Mon, 11 Dec 2006 15:55:14 -0500, David Charters wrote: >I do know that People Soft and SAP both handle there support the same as >Remedy. Even if you a 10 year veteran with all the certs you still have to >start and level 1 and work your way through the steps. Many many years ago when I was a systems programmer on MVS we discovered that our customer record at the IBM support centre had a notation on it that translated to "these guys *really* know what they are talking about" :-) -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: OT: Try this out... Friday Humour
On Fri, 13 Oct 2006 14:06:08 -0700, Thad Esser wrote: >I just got this one this morning: >-- >How Smart Is Your Right Foot? > >This is so funny that it will boggle your mind. And you will keep >trying it at least 50 more times to see if you can outsmart your foot. >But you can't. > >1. While sitting at your desk, lift your right foot off the floor and >make clockwise circles with it. > >2. Now, while doing this, draw the number "6" in the air with your >right hand. Your foot will change directions. > >I told you so...And there is nothing you can do about it. Make sure you >pass this on to your friends. They won't be able to do it either. I suspect a drummer, full drum kit type not a marcher, might find this dead easy. They are used to all appendages doing different things in different directions at different rates. :-) -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
UK Remedy User Group Conference - 12th October 2006 London
The next UK RUG is on the 12th of October in London. Venue: One Great George Street, Westminster, London, SW1P 3AA 9 am - 6 pm The event is FREE, but please complete the registration at http://www.ukrug.org/ * Separate Business and Technical Tracks. * Invited speakers from BMC, including Doug Mueller. * All day Partner Fair including technology, consulting and reseller partners offering solutions and services to enhance your investment. * Sponsored drinks reception. * A stone's throw from Parliament in the heart of Westminster. * Free registration thanks to the sponsorship of the Partner Fair exhibitors. For more information and to register for the event visit: http://www.ukrug.org/ We look forward to seeing you at the event! Jim Halliday, Dave Saville & Peter Tyrrell UKRUG Committee Partner Fair: BMC http://www.bmc.com/products/products_services_detail/0,,0_0_0_801,00.html Abydos http://www.abydos-workflow.com AlarmPoint Systems http://www.alarmpoint.com Dexterra http://www.dexterra.com Fusion http://www.fusion.co.uk Indus http://www.indus.com Kineticdata http://www.kineticdata.com newScale http://www.newscale.com Panacea Workflow Systems http://www.pws-europe.com Scapa Technologies http://www.scapatech.com Tertio-SMS http://www.tertio-sms.com TuringSMI -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Copy to / from Windows Clipboard
On Wed, 13 Sep 2006 10:06:53 -0700, Thad Esser wrote: >Could you use OLE actions (check BuoyantSolutions for SendKeys) to do a >ctrl-c/ctrl-v? > But it would not know what is "selected" assuming the OP wants to push stuff *into* the clipboard from the AL. >"clip.exe" (google it) is a command line utility that will let you >redirect text to the clipboard. I don't think it can pull text out. I have some DOSish code that *might* recompile for XP. Let me know if you get stuck and I will have a look. > >Thad >"Perfection is achieved, not when there is nothing more to add, but when >there is nothing left to take away." - Antoine de Saint-Exupéry > > > >"Eric Cleereman (IT)" <[EMAIL PROTECTED]> >Sent by: "Action Request System discussion list(ARSList)" > >09/13/2006 09:22 AM >Please respond to >arslist@ARSLIST.ORG > > >To >arslist@ARSLIST.ORG >cc > >Subject >Copy to / from Windows Clipboard > > > > > > >** >Hi All, >Using the WUT version 6.3, and Windows 2000/XP, does anyone know of a way >to copy to or from the Windows clipboard from an active link? >Eric Cleereman >__20060125___This posting was submitted with HTML in >it___ > >***IMPORTANT NOTICE: This communication, including any attachment, contains >information that may be confidential or privileged, and is intended solely for >the entity or individual to whom it is addressed. If you are not the intended >recipient, you should delete this message and are hereby notified that any >disclosure, copying, or distribution of this message is strictly prohibited. >Nothing in this email, including any attachment, is intended to be a legally >binding signature.*** > >___ >UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
UK Remedy User Group Conference - 12th October 2006 London
Dear Colleagues The 2006 UKRUG will take place on the 12th of October at: One Great George Street Westminster, London SW1P 3AA http://www.onegreatgeorgestreet.com The key note speaker is Doug Mueller, Service Management Business Unit R&D, Product Strategy VP, and, of course, co-founder of Remedy. The conference will follow the dual track format introduced at the last event with parallel technical and business streams. Once again the event is FREE due to the support of the participants of the Partner Fair which will be open all day with stands from BMC and at least 10 other partners. To register or see the latest details please go to http://www.ukrug.org The success of the UKRUG Conference is due to the enthusiasm of the community and the invaluable knowledge that we can share. We are still able to include additional speakers and are inviting all members of the Remedy community to consider presenting at our conference. Especially those with interesting stories to tell. As well as larger slots we would welcome shorter presentations too. If you would like to make a presentation please contact us at [EMAIL PROTECTED] We look forward to seeing you there. Dave Saville UK RUG Committee. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Request for Enhancement (RFE) community discussion at BMC Use rWorld - open invitation
I have not followed this thread. But a suggestion. I was at a programming development workshop in Switzerland around Easter. They webcasted the whole two day workshop and used an IRC chat session for people to ask the presenters questions. A couple of the audience kept an eye on the IRC session. Just a thought. -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Direct SQL
On Sun, 27 Aug 2006 10:38:01 -0700, Mimi Lakew wrote: >Dave, > > Thanks for your help but to make sure I understand correctly, are you saying > unless the forn name has a non alphanumeric character the table name should > be the same with the form name? If the form name is 'EmployeeInformation' > then the table name would be 'EmployeeInformation' kind of. Not the table name but the view of the table that is created has the names constructed as I said. And yes, the name would be EmployeeInformation. -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Direct SQL
On Sun, 27 Aug 2006 09:05:50 -0700, Mimi Lakew wrote: >Hi Lisr, > > I am trying to use Direct SQL action which I never used before. My > understanding is, on the SQL statement the table name has to be defined. Like > "select * from tablename" I am trying to search an ARS form, is there anyway > to find what the table name is on the database for the form? The *real* table name will be Tnnn where nnn are digits. However Remedy sets up "views" and you can use the form name with the proviso that any non alphanumeric character in the name will be changed to an underscore. So a form called "My Form" would be My_Form. This also applies to field names. It is better to use these views as they are consistent across the same tables on different installations of ARS. "MY Table" might be T123 one box and T456 on another - a maintenance nightmare and a wonderful source of error :-) HTH -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
