Re: ARERR [342] Cannot find/open the directory file: 0

2007-08-09 Thread Heider, Stephen
Lisa, I have experienced something like this before. The full path to the attachment is stored in the ARS table. When attempting to access it from a computer that does not have the same drive letter and/or folder structure it sometimes generates an error. When attachments are saved to the form I

Re: Default attachment on New form

2007-08-09 Thread Heider, Stephen
Chris, The PERFORM-ACTION-ADD-ATTACHMENT command in an active link would work. The file that you want to attach would either need to be accessible to the user logged in (ie. a network share \\server\folder\file.doc), or use a Set Fields command to pull the file from a regular from. This c

Re: Default attachment on New form

2007-08-09 Thread Heider, Stephen
...I forgot the most obvious way. Use a Set Fields to pull the file from another regular form directly into the attachment field. It's been a long day :) From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of H

Re: Inserting pause in workflow

2007-08-09 Thread Heider, Stephen
Another option is to use your RDBMS. For SQL Server, Set Fields SQL WAITFOR DELAY '00:00:10' Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Thursday, August 09, 2007 4:43 PM To: ars

Re: Inserting pause in workflow SOLVED

2007-08-10 Thread Heider, Stephen
quot;invalid SQL statement". Is that an Oracle statement? I looked in my Oracle book but can't find any "wait" command. Anyway, Thank you Stephen and Fred. You've solved my problem. Dwayne Martin Original message

Re: FAQ for Customer enforced licensing model in AR System 7.1.00 part II

2007-08-10 Thread Heider, Stephen
David, Regarding "If you have other questions, feel free to post them and I will answer them as best as I can.", thank you David, for posting this information and your continued participation in this online forum. Q: Will the unlicensed AR Server, which presently runs in Evaluation mode wit

Re: AR System Developer Studio Wishlists

2007-08-14 Thread Heider, Stephen
Here is a quick list: - Customizable. Ability to create add-ins similar to Outlook Addins that can be created with Visual Studio. - Remember last screens. For example, when looking at the 100th active link in a list of 300 for a form, when I click the Filters menu and the

OT: Favorite Freeware for Remedy Development

2007-08-14 Thread Heider, Stephen
Hello everyone, We all probably use one or more free programs to assist us with our Remedy development. At times I needed a program and recall that it was mentioned on the ARS List but can't remember the name. Is there a centralized list of links to all of these? If not, then perhaps we c

ARS Integration With RightNow

2007-08-14 Thread Heider, Stephen
We are considering integrating the RightNow knowledgebase package with our Remedy Help Desk system. Has anyone performed this type of implementation with this software? What was your experience? Stephen ___ U

Re: FAQ for Customer enforced licensing model in AR System 7.1.00 part I

2007-08-15 Thread Heider, Stephen
David, "Licensing policies have not changed. Purchasing requirements have not changed. The same restrictions on license usage will be in place with AR System 7.1.00 that are in place today. Licensing is not changing - only the need for keys." Have there been discussions within BMC on how to p

Re: AR System Developer Studio Wishlists

2007-08-15 Thread Heider, Stephen
Updating the synch objects as they are being saved would be the preferred approach as it would always be up to date. Another possibility I see is with ARS 7.1 and multiple escalation pools: A new $UpdateSynch$ command that runs from an escalation based on your schedule. A separate escalation pool

Re: AR System Developer Studio Wishlists

2007-08-15 Thread Heider, Stephen
I like the checksum idea. I think it would be fairly easy to implement by BMC. It would also then allow for accurate Modified Dates on objects. Presently when you import a .def file and overwrite existing, even if a particular object has not changed the Modified Date is updated to the current d

Re: AR System Developer Studio Wishlists

2007-08-16 Thread Heider, Stephen
...one more item that would save me time is Ctrl-Enter to save an object similar to saving a record while running the application. Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of CONDREA, Daniel Sent: Thursday, August

Re: WS2003 SP2

2007-08-20 Thread Heider, Stephen
We are using SP2 here with SQL Server 2000 and ARS 6.3 on the production AR server, and SP2 with IIS6 on the production mid-tier server without issues. One noteworthy item is that I schedule both servers to reboot each Sunday morning. Stephen From: Action

Re: Remedy Skilled Professionals

2007-08-24 Thread Heider, Stephen
...and as of today, me too! Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bowen, Marc Sent: Tuesday, July 31, 2007 1:25 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Skil

Re: Remedy Skilled Professionals

2007-08-24 Thread Heider, Stephen
Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen > Sent: Friday, August 24, 2007 11:25 AM > To: arslist@ARSLIST.ORG > Subject: Re: Remedy Skilled Professionals > > > ** > > > ...and as o

Re: Price and duration for Remedy RSP and RAC certification?

2007-08-27 Thread Heider, Stephen
Here are the costs for mine. Admin 1 - 6.x, 1 day (web), 500 Admin 2 - 6.x, 5 days, 2500 What's New 7.x, 1 day (web), 600 Admin 3 - 7.x, 5 days, 3000 Performance Tuning 6.x, 2 days, 1200 RADD 6.x, 3 days, 1800 RSP 6.x, 4 days, 2400 Total class cost: 12,000 Total class time: 19 days

Re: Attachment Pool - POSSIBLE VIRUS

2007-08-27 Thread Heider, Stephen
This looks like a virus. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of tarner Sent: Monday, August 27, 2007 10:30 AM To: arslist@ARSLIST.ORG Subject: Re: Attachment Pool You have received a secure email from tarner a

Re: Capture Computer Name USER is runing on

2007-08-28 Thread Heider, Stephen
Bruce, Here is another form of capturing the name of the computer. $PROCESS$ cmd.exe /c set COMPUTERNAME If at some point you want to capture a lot of information about the Windows computer have a look at the free WksInfo utility on ARS Wiki. Stephen Remedy Skilled Professional -Original M

Re: how to read the whole content of a drop-down menu

2007-09-06 Thread Heider, Stephen
Serouche, I would use a regular form to hold each of the banned email addresses, as suggested by Norm. Besides making it easier to search using a regular form allows for easy updating. You could also delegate the responsibility for maintaining the content of this form to someone else. In a set

Re: No action on attachments

2007-09-06 Thread Heider, Stephen
Nisha, Is the field on the target form Display Only? Have you checked the Filter log file? Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of RAMTRI, Nisha, IDC Sent: Thursda

Re: Push field sometimes happens and sometimes doesn't

2007-09-13 Thread Heider, Stephen
Dwayne, I implemented a similar approach to Carey here. One additional data element that I track is a notification code. This code is a small character field that is populated by the Push to the child form. Each filter, active link or other ARS object that needs to send a notification has a u

Re: Can a qualification be included in a Submit template

2007-09-14 Thread Heider, Stephen
Manjari, One approach to accomplish your goal is with a web application. The email would post to the web app. The web app would lookup the Request ID in Remedy. If the Request ID is valid, then proceed with the submit to the Survey form. If not, then display a message to the user. I use

Re: Running into issues when using the Remedy .NET API script against ARS 7.01 / ITSM 7.02

2007-09-14 Thread Heider, Stephen
Peter, Here is something to try. BTW, I am using a slightly newer version of BMC.ARSystem.dll, v7.0.2523.16350. objArSystemPub.SetServerPort(CInt(pRemedyPort), CInt(pRemedyRPCProgramNum) ' Try running this before Login() to see if it makes a difference. objArSystemPub.Login(pRemedySer

Re: Making a field in the form as unique index that leardy has duplicate values.

2007-09-18 Thread Heider, Stephen
Another SQL Server command to find dups: SELECT Field1, COUNT(*) FROM FormName GROUP BY Field1 HAVING COUNT(*) > 1 Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr

Re: Is it possible to fetch the database id

2007-09-27 Thread Heider, Stephen
Dipti, Here is a SQL Server method to get the FieldId of an attachment field (or any field) : CREATE FUNCTION dbo.udf_GetFieldId ( @FormName VARCHAR(60), @FieldName VARCHAR(60) ) RETURNS INT BEGIN RETURN (SELECT b.FieldID FROM arschema a

OT: Office 2003 SP3

2007-09-28 Thread Heider, Stephen
Has anyone experienced anomalies with SP3 which was released about a week ago? All of our Remedy email is sent via html templates with banner images pulling from our internal network (no firewall issues). The moment I installed SP3 every Remedy message with a banner image viewed in Outlook

Re: Splitting of a string

2007-10-01 Thread Heider, Stephen
Frans, If you only want to convert the string into a format that the email engine can use to send to multiple recipients, have you tried the REPLACE() function? Set Fields with something likeREPLACE($FieldName$, ";", "|") *For this email I used the pipe symbol (|) in place of a r

OT: BMC Whitepaper - Accelerating Problem Resolution in .NET Applications and Web Services

2007-10-04 Thread Heider, Stephen
http://i.i.com.com/cnwk.1d/html/itp/bmc_Identify_DotNET_Problem_Res_Whit epaper.pdf If the above link does not work here is the link from the Tech Republic email newsletter to download it http://whitepapers.techrepublic.com.com/abstract.aspx?docid=291770&promo =605&tag=nl.e605&cval=wit2&ctyp

Re: Filter Problem

2007-10-04 Thread Heider, Stephen
As I recall from Lenny's Performance Tuning class this summer that nothing on the Run If of a Filter causes an additional query of the database. The database record is retrieved at the start of the processing and used for comparison throughout the process. This is just for the Run If...the acti

Re: ARSlist Awards all but software categories over the line

2007-10-05 Thread Heider, Stephen
Moose calls? http://www.smouse.force9.co.uk/Moose3.wav From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Daniel Bloom Sent: Friday, October 05, 2007 9:55 AM To: arslist@ARSLIST.ORG Subject: ARSlist Awards all

Re: How to pass Date/Time varible to SQLstatement

2007-10-09 Thread Heider, Stephen
Hui, If you only want to use the integer value of a date/time, first set the value of $Start Date1$ to a temp integer value field. Then run the command: Select sum(C901001003-C901001002) from T255 Where C3 > $zTmp Int1$ HTH Stephen Remedy Skilled Professional _

Re: Phones at RUG - OT: Free Directory Assistance

2007-10-17 Thread Heider, Stephen
As we all know, dialing 411 on a cell phone is expensive - between $1 and $3 per call. Google and Microsoft now offer free directory assistance from your cell phone (or any phone). Here are a couple numbers you will want to keep with you. 800-GOOG-411 800-CALL-411 HTH Stephen Remedy Skilled

Re: Mid-Tier LoginServlet return errors

2007-10-25 Thread Heider, Stephen
Simon, Here is how I did it here. Make a backup of these two files on your mid tier server. C:\Program Files\AR System\Mid-Tier\WEB-INF\classes\ LocalizedMessages.properties C:\Program Files\AR System\Mid-Tier\WEB-INF\classes\LocalizedMessages_en.properties Open these two files in a

Re: Diary Fields

2007-10-25 Thread Heider, Stephen
On a related note, if you ever decide to convert your Diary fields into individual records in a separate form (which may then be viewed in table fields or 0-length display-only character fields), there is a free utility that will populate your new Diary form with all the diary entries in your ARS s

Re: Creating objectdatasource in asp.net

2007-10-29 Thread Heider, Stephen
Have you tried using this method to return a .Net DataTable? Then bind the datatable to the BindingSource.DataSource Then bind this to the DataGridView.DataSource. Another option is to return a BMC EntryFieldValueList object and iterate over it to populate a datatable. Server.GetListEnt

Re: Replace function on a special character

2007-10-31 Thread Heider, Stephen
Jackson, You can use your RDBMS to return special characters. You just need to find out the numeric value of them. For example, to get the Tab character, Set Fields SQL: SELECT CHAR(9) Once you have the value in a character field you can use that for your replacing. HTH Stephen R

Re: Replace function on a special character

2007-11-01 Thread Heider, Stephen
Jackson, The line feed character is decimal 10 (carriage return is decimal 13). To replace the line feed character in a character field with something else. Set Fields SQL $zTmpField1$ = SELECT CHAR(10) Set Fields $CharField$ = REPLACE($CharField$, $zTmpField1$, "x") If you on

Re: Possible DST Issue

2007-11-02 Thread Heider, Stephen
e L Sent: Friday, November 02, 2007 9:57 AM To: arslist@ARSLIST.ORG Subject: Re: Possible DST Issue ** Hi, Stephen: Thank you for the workaround and passing this along to the masses. Is there already a defect id for this? Thanks, Michelle "Heider, Stephen" <[EMAIL PROTECT

Re: Opening a PDF from the MidTier

2007-11-02 Thread Heider, Stephen
Just FYI, an update to FireFox was released last night - 2.0.0.9. See if the new version helps. Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Friday, November 02, 200

Re: Possible DST Issue

2007-11-02 Thread Heider, Stephen
Just wanted to pass this along... ARS 6.3 p22 (server, mid-tier, user tool), SQL Server 2000 (all patches), Windows Server 2003 (all patches). When passing a date in a date field within an active link to a Set Fields SQL User Defined Function Remedy changes the date to the previous day. T

Re: Starting a new ID

2007-11-05 Thread Heider, Stephen
Bola, If you know the specific SQL command you can do this in an Active Link. For example (SQL Server) - UPDATE ARSchema SET nextId = 1 WHERE [name] = 'HPD:HelpDesk' Stephen Remedy Skilled Professional From: Action Request System discuss

OT: Flying

2007-11-12 Thread Heider, Stephen
Slightly off-topic. I was thinking of Remedy at the time :) Stephen Remedy Skilled Professional ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Wh

Re: Diary History Order

2007-11-15 Thread Heider, Stephen
Dave, Have you considered switching to use a "diary form"? You could then use a table field on your ticket form that displays all diary entries for the customer. You wouldn't need to loop through all the tickets for the customer and concatenate. A table field also makes it really easy to sort b

Re: Export Form Data to Excel on Button Action

2007-11-19 Thread Heider, Stephen
Anesh, I have a lot of reports that are generated in Excel format by clicking a button. There are different approaches to accomplishing this. Here are several: The first is the easiest but requires the user to copy/paste the results into a new Excel sheet. In an active link loop through

Re: Print Hardcopy Notifications?

2007-11-19 Thread Heider, Stephen
Shawn, Here is one option; there are probably more... BCC all outgoing email to a separate Exchange account (I do this here but for a different reason). On a computer (not the Exchange server) that has Outlook create a Rule that prints email to a printer (or a pdf file) - either all email or t

Re: Export Form Data to Excel on Button Action

2007-11-20 Thread Heider, Stephen
Anesh, I can answer this indirectly... In the last paragraph in my previous email I forgot to mention that when you create the Excel sheet on the server it is then also available on the web. Since the Excel sheet will end up in an attachment field on some form, your client (web or Windo

Re: On-the-fly permissions in Attachment field

2007-11-29 Thread Heider, Stephen
Re "(I don't remember if it deletes the attachment from the original form or just copies it)"the utility does not delete or alter any of the existing attachment fields. After the conversion is complete and users are using the attachments form and your new workflow then the ARS developer may c

Re: E-mail Submit from BlackBerry Device

2007-11-30 Thread Heider, Stephen
Janet, There are products that you can buy (ie. Aeroprise, Mobile Reach) that are geared toward ARS on BlackBerry and other PDAs. Another option is to create a web app yourself. Aeroprise and Mobile Reach have good products. The cost was more than what the company wanted to spend, so I ended up

Re: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED)

2007-12-13 Thread Heider, Stephen
Brian, How about this approach: When the screen is opened or the entry retrieved - when the attachment field is not null - change the attachment field to Hidden, display the name (and optionally the size) of the attachment file in a read-only character field that is displayed as text. Un

Re: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED)

2007-12-13 Thread Heider, Stephen
The error you're describing sounds like a separate issue. You should be able to hide/unhide, set field, change field without getting an error message. In the example below the character field would be display-only with Disable Change Flag box checked. If you have a few minutes, try creating a ne

Re: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED)

2007-12-13 Thread Heider, Stephen
Of Heider, Stephen Sent: Thursday, December 13, 2007 1:42 PM To: arslist@ARSLIST.ORG Subject: Re: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED) ** Brian, How about this approach: When the screen is opened or the entry retrieved - when the attachment field is not null

Re: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED)

2007-12-13 Thread Heider, Stephen
:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Thursday, December 13, 2007 1:42 PM To: arslist@ARSLIST.ORG Subject: Re: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED) ** Brian, How about this approach: When the screen is opened or the entry retrieved - when the attachment

Re: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED)

2007-12-13 Thread Heider, Stephen
ional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Thursday, December 13, 2007 2:47 PM To: arslist@ARSLIST.ORG Subject: Re: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED) Brian, Is the attachment fie

Re: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED)

2007-12-13 Thread Heider, Stephen
_ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Thursday, December 13, 2007 2:58 PM To: arslist@ARSLIST.ORG Subject: Re: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED) ** Scratch that last message. I am workin

Email - & converted to &

2008-01-03 Thread Heider, Stephen
Welcome back everyone. Happy New Year. I noticed something with the Remedy HTML template emails.Inside one of the emails is a link that, when clicked by the recipient, logs into Remedy and then pops up a survey screen. The survey popup is triggered by a parameter I pass to the SSO app, whi

Re: Submit Yes/No response to ARS from a blackberry?

2008-01-04 Thread Heider, Stephen
Rabi, The way I did it here was to create a web app. This assumes that your BlackBerry can access a web app, which in turn can access your ARS system. When the email is created in Remedy workflow inserts a hidden URL into the top of the email. The URL is not visible in Outlook (our email clien

Re: LDAP Question

2008-01-09 Thread Heider, Stephen
Russ, This is a limitation of your LDAP server. It can be changed yet the network admins probably would not want to increase the limit on the LDAP server because of performance. However, there is always another way... Although you are limited to 500 records from LDAP you are not limited t

Re: Delete Records of Alert Events

2008-01-10 Thread Heider, Stephen
Tadeu, I dealt with this very thing yesterday. Here is what I did, and it did not affect the server. Deleting all these entries from a Remedy client will take forever and may not even complete. Use the TRUNCATE TABLE command (SQL Server) to instantly clear out all entries for this for

Re: Delete Records of Alert Events

2008-01-10 Thread Heider, Stephen
De: Action Request System discussion list(ARSList) em nome de Heider, Stephen Enviada: qui 10/1/2008 11:17 Para: arslist@ARSLIST.ORG Assunto: Re: Delete Records of Alert Events ** Tadeu, I dealt with this very thing yesterday. Here is what I did, and it did not affect the server. Dele

Re: Delete Records of Alert Events

2008-01-10 Thread Heider, Stephen
emedy View form of this SQL View. HTH Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Thursday, January 10, 2008 8:59 AM To: arslist@ARSLIST.ORG Subject: Re: Delete Recor

Re: CSV TO XLS via OLE

2008-01-10 Thread Heider, Stephen
Andy, There is a thread from Nov 19 entitled "Export Form Data to Excel on Button Action" that may help. Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Thursday, J

OT: Virtual PC 2007 Available

2007-02-26 Thread Heider, Stephen
For those who like to run test ARS installations in a virtual environment, version 2007 was just released (still free). It now works with Vista 32- and 64-bit. I am using it with Vista 64-bit and it runs fine and seems to be faster than VPC 2004. http://www.microsoft.com/downloads/details.aspx?

Server Logins with Multiple ARS Instances - Possible Bug

2007-02-26 Thread Heider, Stephen
I noticed something that doesn't seem right with logging into different instances of ARS on the same server. The server name that is visible in the User Tool (6.3 and 7.0) and from the .Net API (v7.x) lists the wrong server in certain circumstances. Environment: Windows Server 2003 with ARS 6.3

Re: Server Logins with Multiple ARS Instances - Possible Bug

2007-02-26 Thread Heider, Stephen
om: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Monday, February 26, 2007 3:34 PM To: arslist@ARSLIST.ORG Subject: Server Logins with Multiple ARS Instances - Possible Bug ** I noticed something that doesn't seem right with logging

Re: Server Logins with Multiple ARS Instances - Possible Bug

2007-02-27 Thread Heider, Stephen
PM To: arslist@ARSLIST.ORG Subject: Re: Server Logins with Multiple ARS Instances - Possible Bug Make sure that no ARTCPPORT env var is set! Ben >- --- Original Message --- - >From: "Heider, Stephen" <[EMAIL PROTECTED]> >To: arslist@ARSLIST.ORG

Re: Server Logins with Multiple ARS Instances - Possible Bug

2007-02-27 Thread Heider, Stephen
n the same box...you will get remedydev From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Monday, February 26, 2007 1:34 PM To: arslist@ARSLIST.ORG Subject: Server Logins with Multiple ARS Instances - Po

Re: DSTC Bug ARS 6.0.3 Patch 20 and User/Group Form Changes

2007-02-27 Thread Heider, Stephen
Jenni, With this installation option, are you saying that no forms were modified in any way, or just the User and Group forms were not modified? Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Wacholz, Jeanet

Re: DSTC Bug ARS 6.0.3 Patch 20 and User/Group Form Changes

2007-02-27 Thread Heider, Stephen
that install command. Jenni Wacholz 480-445-2517 Remedy Administrator Coventry Health Care From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Tuesday, February 27, 2007 8:29 AM To: arslist@ARS

Re: LOGOFF event capture

2007-02-28 Thread Heider, Stephen
One option would be to add an active-link on the main control form that pushes a new record to a logon/logoff form when the user opens the form, and also when they close the form (exit the application). Stephen -Original Message- From: Action Request System discussion list(ARSList) [mai

Re: Help with View Form

2007-02-28 Thread Heider, Stephen
Simon, What are the data types in the base table(s) of the SQL View? Try CASTing them to VARCHAR. If that doesn't work then add RTRIM or LEFT(fld, 255) to the colums. Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of

Re: Help with View Form

2007-02-28 Thread Heider, Stephen
ame in the Database tab?? If not you can try selecting the field by right clicking on your view form and choosing the first option on the menu that appears on right clicking which will list all the available fields on the view form... Cheers Joe - Original Message ---- From: "

Re: ARSList awards meeting refreshments

2007-03-01 Thread Heider, Stephen
Yes, but Twinkies have a 32 year shelf life :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of strauss Sent: Thursday, March 01, 2007 1:42 AM To: arslist@ARSLIST.ORG Subject: OT: ARSList awards meeting refreshments All vetera

Re: MID-TIER Patch 21 problem!

2007-03-07 Thread Heider, Stephen
Here is something I use here: Create an active link that runs at level 1000 on the Window Close event. The al runs SET-CHANGE-FLAG 0. For each form which I want to always clear the change flag when closing the form, I add to this one active link. HTH Stephen -Original Message- Fr

SQL Server 2005 CLR and ARS API

2007-03-08 Thread Heider, Stephen
List, I am attempting to create a stored procedure written in .Net that uses the ARS .Net API. Everything works as expected except when adding the ARS API part. I am not sure if this is even possible because it seems that you can only have one .dll file inside a SQL Assembly, and the BMC.ARSys

Re: DST Test Results on March 11th 8:00 AM

2007-03-12 Thread Heider, Stephen
Another, or additional, method would be to run a Direct SQL command each time users login (loads the main form) UPDATE AR_System_User_Preference SET Time_Zone = NULL WHERE Submitter = '$USER$' This would take effect the next time the user logged in. I actually do this with a stored procedure that

OT: TS Census ScanWkstn.exe Error

2007-03-12 Thread Heider, Stephen
We use TS Census (now Zen Asset Management) for tracking computers and software. Within Remedy users can select a computer and then click a button to force a rescan of the computer. Starting this morning (or just noticed) the ScanWkstn.exe console program is crashing. The only thing that has

Re: DST Test Results on March 11th 8:00 AM

2007-03-12 Thread Heider, Stephen
suggested would work for those users as well as those that use a preference server. -- 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 3/12/07, Heider, Stephen

Re: MS SQL -> Oracle ... Distributed Transaction failed ?

2007-03-12 Thread Heider, Stephen
Robert, Are you able to insert records in Query Analyzer while logged in as user ARAdmin? Try placing your INSERT commands in a Stored Procedure and test it in Query Analyzer. Then run the stored proc from workflow to see if it works. Here are a few posts that might be useful: "ROLLBACK

Re: AR E-mail Engine 6.3 and HTML emails bug - workaround

2007-03-12 Thread Heider, Stephen
..this behavior is also present in Outlook 2007. In the new Outlook, Word 2007 is used for all email - it can't be turned off. Even if you don't have Word 2007 a special version of Word 2007 is installed with Outlook 2007 for viewing emails. For additional details see the thread "OT: Remedy HTML

Re: AR E-mail Engine 6.3 and HTML emails bug - workaround

2007-03-12 Thread Heider, Stephen
*I think this posting was eaten by the List email engine. I posted one message before and one message after I sent this one and both have been received, except this one. From: Heider, Stephen Sent: Monday, March 12, 2007 1:33 PM To: arslist@ARSLIST.ORG Subject

Re: Send survey at close

2007-03-12 Thread Heider, Stephen
Rich, The way I do it here is to include a URL in the HTML email which the requester receives when their ticket is marked Resolved. When clicked, the employee is logged into remedyweb and workflow selects the tab that lists their tickets, selects the ticket that was just resolved, then opens the

Re: RESOLVE: DST Test Results on March 11th 8:00 AM

2007-03-12 Thread Heider, Stephen
Heider, Stephen Sent: Monday, March 12, 2007 9:21 AM To: arslist@ARSLIST.ORG Subject: Re: DST Test Results on March 11th 8:00 AM Another, or additional, method would be to run a Direct SQL command each time users login (loads the main form) UPDATE AR_System_User_Preference SET Time_Zone = NULL

Re: Windows Vista Question

2007-03-14 Thread Heider, Stephen
Timothy, There is an issue with installing SQL Server 2005 and Vista. SP2 for SQL is supposed to correct this but it didn't work on my computer. There is also an issue with Visual Studio 2005 and Vista. A VS patch was recently released but it didn't work. My computer and video card are new and

Re: Windows User Tool 7.x Crystal Reports bug - was RE: Sun's Bug Detail Page vs. BMC Product Defect Page

2007-03-14 Thread Heider, Stephen
David, I am getting ready to install the 7.0.01 User Tool on a computer that has not had any ARS software previously installed. The computer does have Office and Visual Studio. I understand from your email if User Tool 6.03 is installed first then the 7.0.01 uninstall issue does not occur. Wh

Re: Windows Vista Question

2007-03-14 Thread Heider, Stephen
it but hey if you like graphics (Dont get me started on Remedy) John Mosco W01/GS-11 IT Coordinator Customer Support Manager PNG JFHQ J6 'We the people' From: Action Request System discussion list(ARSList) on behalf of Heider, Stephen Sent: Wed 3

Re: How to show group recipients e-mailed in CC list

2007-03-14 Thread Heider, Stephen
... I am somewhat reluctant to mention this approach because of the scope. This would be a big project, not a quick fix. Yet it works and I have been using it here for almost 2 years. Create an email gateway form that handles all the processing of sending emails. In the filters, al's and escal

Re: Crystal Report Error

2007-03-21 Thread Heider, Stephen
If your username is using Centralized Preferences, have you tried deleting your record in the AR System User Preference form? Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bill H. Sent: Wednesday, March 21, 2

Re: MS SQL on Win 2k -> Win 2k3 issue

2007-03-21 Thread Heider, Stephen
Has DTC been enabled and configured on the Win 2003 server? Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr OC-ALC/ITMA Sent: Wednesday, March 21, 2007 10:57 AM To: arslist@ARSLIST.ORG Subje

Re: MS SQL on Win 2k -> Win 2k3 issue

2007-03-21 Thread Heider, Stephen
something configured incorrectly on my side? Thanks, Gary From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Wednesday, March 21, 2007 10:03 AM To: arslist@ARSLIST.ORG Subject: Re: MS SQL on Wi

Re: Outlook OLE

2007-03-26 Thread Heider, Stephen
Here is a different approach to creating Outlook appointments from Remedy that I implemented here about two years ago. I create iCal files which are either run or emailed to users or groups. Here are a couple threads that have addl details: "Remedy to Outlook Integration", Jan 2006 "Creating

Re: OT - Remedy Training In Clearwater

2007-03-26 Thread Heider, Stephen
Andy, There are a number of very good places to eat within walking distance. I don't recall the names at the moment, but anyone at EMS can tell you. There is a Starbucks two blocks away. I was there recently for the Admin 3 class as well. There is a lot of construction on the main street so you

Re: Outlook OLE

2007-03-26 Thread Heider, Stephen
I just noticed something looking at the two screenshots - the time is off by an hour. The DST bug has struck again :) From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Monday, March 26, 2007 1:24

Re: OT - Remedy Training In Clearwater

2007-03-26 Thread Heider, Stephen
Ah, Berns! That is the absolute best steak house. And yes, they do have the largest private wine collection in the world. Some of the wines go back almost 200 years. It's not cheap...expect to spend around $125 per person when it's all done. But it's worth it. With your dessert I highly re

Re: View Forms

2007-03-29 Thread Heider, Stephen
Roger, If you can create a SQL View on your Remedy database server pointing to any table on a remote database server then Remedy should be able to create a View Form on top of the local SQL View. Are you able to add a Linked Server connection from the Remedy database server to the remote databas

User Cache Issue

2007-03-30 Thread Heider, Stephen
An unusual situation happened today that is now resolved, but I want to understand how it could occur. An employee's email address changed. The employee has a record in User with a Read-Restricted license. When an email (any email) was sent from Remedy the AR System Email Messages form would lis

Re: .Net Server Login issue

2007-04-02 Thread Heider, Stephen
Bill, Here are a few questions that may help you narrow down the cause. HTH. Are you using Visual Studio 2003 or 2005? Are you using Vista? Are you using a 64-bit version of Windows? Have you tried creating a .Net Console application that just: logs into Remedy, outputs a GUID (for example

Re: View Forms

2007-04-02 Thread Heider, Stephen
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Thursday, March 29, 2007 11:19 AM To: arslist@ARSLIST.ORG Subject: Re: View Forms Roger, If you can create a SQL View on your Remedy database server pointing to any

Re: Validate field data - allowing some to be NULL

2007-04-02 Thread Heider, Stephen
Sue, Have you considered using your RDBMS to perform the qualification? For intricate validations I frequently find it's easier to create a user defined function in your database, then run a Set Fields SQL command in ARS to perform the validation. You can then call your function many times thro

Re: .Net Server Login issue

2007-04-03 Thread Heider, Stephen
both. *** - Original Message - From: Heider, Stephen <mailto:[EMAIL PROTECTED]> Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Monday, April 02, 2007 5:03 AM Subject: Re: .Net Server

<    1   2   3   4   5   6   >