Re: History of AR System
Hey Tim, same here. Remember that I took over for you in '99. :) Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Timothy Powell Sent: Monday, July 06, 2009 8:51 AM To: arslist@ARSLIST.ORG Subject: Re: History of AR System ** I got tossed in to it in June 1997 at GTE in Tampa, FL. We were on V3.0. I was handed a manual and told to go forth and build applications. I didn't step foot in any Remedy class until Sept 1998 when I took the Admin class. Tim From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Sent: Monday, June 29, 2009 3:18 PM To: arslist@ARSLIST.ORG Subject: Re: History of AR System ** Back in 97, I sat down with the Remedy manual, read it cover to cover and was a Remedy administrator. There were only two apps (I think); Helpdesk and Asset. Today, I looking at all the manuals if you have the whole ITSM suite, I no longer think that's possible. I'm curious, how many folks started Remedy by just reading the docs, or did most people go out and get formal training. Ben Cantatore Remedy Manager (914) 457-6209 Emerging Health IT 3 Odell Plaza Yonkers, New York 10701 robert.w.r...@gmail.com 06/29/09 10:56 AM ** I began working with the point release of 2.1 late in 1994 or early 1995 when I was at Winstar, a gone-broke telecommunications company. I wrote the help-desk app for the network ops center, as well as configuration forms, certification forms, lots of stuff. Back then it was a good front-end for a database. We worked with voice communications, so the FCC required a lot of auditing, all of which had to be written. I got into Remedy as a C programmer who didn't have a project at the moment. I was horrified to find no Else statements built into the system. I can't remember when that came along, but it was quite an advance in programming. We worked with HP-UX and an early version of Oracle. Installation of just about anything was a bear, but once all the ducks were lined up it went well. Ever since then I've worked with the ARS. Now it's quite sophisticated in comparison with the old days. On Sun, Jun 28, 2009 at 4:39 PM, Daniel Bloom danielbl...@rogers.commailto:danielbl...@rogers.com wrote: From a bit of googling . Remedy Corp. The Company was incorporated on November 20, 1990 in Delaware Headquarters Mountain View, California, USA Key people Larry Garlick, Founder CEO Dave Mahler, VP Marketing Doug Mueller, Chief Architect Version 1.0 ? Version 1.1 Approx. Nov 1992 still looking for confirmation Version 2.0 was May 19, 1995 Version 4.0 was Jan 27, 1999 -Original Message- From: Action Request System discussion list(ARSList) _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: .NET Fast-Export BMC-Remedy Export Utility
Did anyone receive the full attachment? I did not. If it is greater than 5MB our email system will remove it. Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Brian Goralczyk Sent: Sunday, April 20, 2008 10:12 PM To: arslist@ARSLIST.ORG Subject: Re: .NET Fast-Export BMC-Remedy Export Utility ** Upon review, I have the same attachment. On Sun, Apr 20, 2008 at 7:45 PM, Axton [EMAIL PROTECTED] wrote: I see the attachment in the email, but it is 1k and has the following contents: This attachment was removed. Are you able to open the attachment? Axton Grams On Sun, Apr 20, 2008 at 4:40 PM, Brian Goralczyk [EMAIL PROTECTED] wrote: ** I got the attachment. I am using gmail. On Sun, Apr 20, 2008 at 9:32 AM, Axton [EMAIL PROTECTED] wrote: fyi, gmail, or someone in the middle, removed the attachment. Axton Grams On Sun, Apr 20, 2008 at 3:21 AM, Ali Musa [EMAIL PROTECTED] wrote: ** Hi all: Please find attached the latest version of .NET fast-Export utility, since I was not able to upload it on BMC community-site. Fast Export .NET is a migration utility tools that copy a data of a schema from server to server for an identical schema (schema-to-schema) or as a normal export utility (schema-to-file) send output to (.arx) file that can be imported by Remedy Import. Able to migrate data generated in AR3-7 and was developed using features of both API 4.5.2 and API 5.1.2 libraries. and latest version of C# a .NET programming language for Window and WEB. Please not that in the documentation page there is no html all I c hanged to .exe fro security, the only html page is README.htm that instruct you how to use the page. I would like to thank you all in anticipation and the arslist management for overing me this chance to present my product and I look forward to hearing your feed-back and comments. Ali. - Disclaimer: The information in this email and in any files transmitted with it, is intended only for the addressee and may contain confidential and/or privileged material. Access to this email by anyone else is unauthorized. If you receive this in error, please contact the sender immediately and delete the material from any computer. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is strictly prohibited. Statement and opinions expressed in this e-mail are those of the sender, and do not necessarily reflect those of STC. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: How to know when a table is full ??
Tadeu, This is the column in the view named RequestID. It is a unique value generated from the CHECKSUM() function. It doesn't matter too much how you get this number as long as it's different for each record. In this case I just used a built-in SQL command. In the Remedy Administrator tool: 1. Select File New Server Object 2. Select View Form and click OK 3. Enter in the name of the SQL View in the first field: ARSystem.dbo.udv_ARS_FormRowCounts and click Load 4. Click Add All to move all the column names you see in the left pane over to the right pane 5. In the drop-down menu select the RequestID column 6. Click create, then save the form. Login to the Remedy User Tool to see and browse the new form. If you were already logged in then re-login to the User Tool. With most View forms (and this one in particular) take care not to add, delete, or change any data or records. One way is to add a Filter to the new ARS View form that Executes On Submit, Modify, Delete, Merge. It has one Message commend of type Error. Note: As you already know if you are using ARS in Demo mode then there is a maximum of 2000 records per form. If you have more than 2000 ARS tables then you will receive an error message when you try to browse this ARS View form. If so, then just view the SQL View outside of ARS (ie. SQL Query Analyzer). Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Friday, April 18, 2008 2:05 PM To: arslist@ARSLIST.ORG Subject: Re: How to know when a table is full ?? ** Create a view form, but that view must have at least one eligible field that would meet the following criteria.. 1) The field must be Non-NULL 2) It must be anywhere between 5 to 15 characters 3) Data in this field must be unique Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of tricky maybe Sent: Friday, April 18, 2008 1:53 PM To: arslist@ARSLIST.ORG Subject: Re: How to know when a table is full ?? ** Once I run the script it created that view on the SQL side now how do you create an ARS view form from this? Or how can I make that show up on the Remedy side like the admin tool or user tool? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Friday, April 18, 2008 10:39 AM To: arslist@ARSLIST.ORG Subject: FW: How to know when a table is full ?? ** Tadeu, If you are using a version of SQL Server you could use the attached script to create a SQL View, then create an ARS View form for the SQL View. Here is how my screen looks: HTH Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Monday, April 07, 2008 10:34 AM To: arslist@ARSLIST.ORG Subject: RES: How to know when a table is full ?? Hi John, Thanks for your reply... But I would like to create this in a AR Sytem Form... (like Alert Events, AR System Email Messages) Could I create new Fields in these kind of forms without any worry about modify AR System Forms??? Att, Tadeu Augusto Dutra Pinto __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
FW: How to know when a table is full ??
Tadeu, If you are using a version of SQL Server you could use the attached script to create a SQL View, then create an ARS View form for the SQL View. Here is how my screen looks: HTH Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Monday, April 07, 2008 10:34 AM To: arslist@ARSLIST.ORG Subject: RES: How to know when a table is full ?? Hi John, Thanks for your reply... But I would like to create this in a AR Sytem Form... (like Alert Events, AR System Email Messages) Could I create new Fields in these kind of forms without any worry about modify AR System Forms??? Att, Tadeu Augusto Dutra Pinto ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are image001.pngCREATE VIEW dbo.udv_ARS_FormRowCounts AS SELECT a.schemaId, b.Name FormName, CONVERT(VARCHAR,a.TableName) TableName, a.TotalRows, CHECKSUM(a.TableName) RequestID FROM(SELECT so.Name TableName, MAX(si.rows) TotalRows, CASE ISNUMERIC(SUBSTRING(so.Name, 2, 99)) WHEN 1 THEN SUBSTRING(so.Name, 2, 99) ELSE CASE ISNUMERIC(SUBSTRING(so.Name, 3, 1)) WHEN 0 THEN SUBSTRING(so.Name, 2, 1) ELSE CASE ISNUMERIC(SUBSTRING(so.Name, 4, 1)) WHEN 0 THEN SUBSTRING(so.Name, 2, 2) ELSE CASE ISNUMERIC(SUBSTRING(so.Name, 5, 1)) WHEN 0 THEN SUBSTRING(so.Name, 2, 3) ELSE CASE ISNUMERIC(SUBSTRING(so.Name, 6, 1)) WHEN 0 THEN SUBSTRING(so.Name, 2, 4) ELSE CASE ISNUMERIC(SUBSTRING(so.Name, 7, 1)) WHEN 0 THEN SUBSTRING(so.Name, 2, 5) ELSE CASE ISNUMERIC(SUBSTRING(so.Name, 8, 1)) WHEN 0 THEN SUBSTRING(so.Name, 2, 6) END END END END END END END schemaId FROMsysobjects so JOINsysindexes si ON si.id = OBJECT_ID(so.name) WHERE so.xtype = 'U' AND LEFT(so.Name,1) IN ('T','B','H') AND ISNUMERIC(SUBSTRING(so.Name,2,1)) = 1 GROUP BY so.Name) a JOINarSchema b ON a.schemaId = b.schemaId
Re: ARS6.3 + SQL Question (UNCLASSIFIED)
Charlie, Use an OPENQUERY in a local SQL View that points to the remote server. CREATE VIEW dbo.uvw_MyRemoteView AS SELECT * FROM OPENQUERY(SERVERNAME, 'SELECT FirstName, LastName FROM SERVERNAME.phonebook.dbo.vw_tbl_ARS') Then in your workflow: SELECT FirstName, LastName FROM uvw_MyRemoteView WHERE LastName LIKE '%$Submitter$%' Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bennett, Charlie CTR MDA/DOCC Sent: Thursday, March 27, 2008 8:52 AM To: arslist@ARSLIST.ORG Subject: ARS6.3 + SQL Question (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Hi All! I'm having a small problem getting my Remedy 6.3 app to talk to a remote MSSQL Server 2K SP3 database running on a Win2k3, SP2 machine. My AR server is running on a Win2k SP4 machine, with the AR System database running on a MSSQL Server 2K SP4 database on the same machine. I've created an active link to grab some user information stored in the remote server upon Return/Table or Level Dbl-Clk in a Set Field (SQL) action - it's supposed to go out, query based on the name entered into a submitter field and find possible matches and populate related user info fields, or display a select list if multiple matches come back. Here's a chopped down and simplified version of the query I'm working with (I've simplified it as much as possible, but to no avail): SELECT FirstName, LastName FROM SERVERNAME.phonebook.dbo.vw_tbl_ARS TARS WHERE TARS.LastName LIKE '%$Submitter$%' I've verified that I've got DTC running on both machines. I've set the remote server up as a linked server, with it set to impersonate with a specific security context. I've verified this is working because I can see the views/tables under the linked server in EntpMgr. I am able to run the above query from my active link in QryAlzr just fine. However, when I go in through the user tool and enter a name into the submitter field and fire the active link, I get this error: ARERR [552] Failure during SQL operation to the database : The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. (SQL Server 3903) The preceding message occurred during the execution of active link +NTFAR:050-Set Submitter Info - TEST -- action 1. (ARNOTE 1101) I'm at the end of my rope here. Hopefully someone has seen this before and knows what's up. Perhaps I'm overlooking something embarassingly silly here? - I hope so! Thanks in advance!! Charlie Bennett Remedy Developer Missile Defense Integration Operations Center Schriever AFB Colorado Springs, CO (719) 721-7470 Classification: UNCLASSIFIED Caveats: NONE ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Form Aliases (UNCLASSIFIED)
Gordon, There is a message entitled Delete Records of Alert Events from Jan 10 with a SQL script attached that lists all the ARS forms with their corresponding DB table names. Is this what you are looking for? Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of FRANK, GORDON CTR DISA JSSC Sent: Tuesday, March 25, 2008 8:05 AM To: arslist@ARSLIST.ORG Subject: Form Aliases (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Does anyone know what DB table the form aliases and labels are held in? I had thought it was arschema, but they don't appear to be there. Gordon M. Frank Remedy Skilled Professional ITIL V3 Certified DISA\Verizon FNS Office phone: 703-614-6130 Office email: [EMAIL PROTECTED] Classification: UNCLASSIFIED Caveats: NONE ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
FW: Moving records to the top based on a condition
Rashmi, Here is one way it can be done, however it might not be useful due to performance. I present this to spark ideas... Overview: Using SQL, create a SQL View that includes a calculated column. This column would contain the sort order based on whatever criteria you require. Then create an ARS View form on top of this SQL View. Your table field would reference this calculated column to sort the records on screen. Here is the SQL View: CREATE VIEW dbo.uvw_MySQLViewForARS AS SELECT Summary, Last_Modified_Date, Priority, State, dbo.udf_SortOrder AS SortOrder FROM dbo.SHR_ConsolidatedList Here is the function: CREATE FUNCTION dbo.udf_SortOrder ( @Last_Modified_Date INT, @Priority INT, @State INT ) RETURNS VARCHAR(20) BEGIN DECLARE @SortOrder VARCHAR(20) SET @SortOrder = CONVERT(VARCHAR,@Last_Modified_Date) + '|' + CONVERT(VARCHAR,@Priority) + '|' + CONVERT(VARCHAR,@State) IF @State = 0 AND @Priority = 1 AND (SELECT * FROM dbo.uvw_CurrentRemedyTime) (@Last_Modified_Date + (45 * 60)) RETURN '0|' + @SortOrder RETURN '1|' + @SortOrder END Add whatever other parameters to the function you may need for sorting. For criteria that matches your condition prefix a number. In this example there is only one condition, so I am using only a 0 and a 1 to provide the proper sorting. If you had 5 conditions then you would use numbers 0-5 (or 1-6, or 100 - 105, etc.). Here is the SQL View that the function needs to get the current date/time in Remedy time. *With SQL Server you can't use a non-deterministic value (such as GETDATE()) directly, so you have to use a View to return the value. CREATE VIEW [dbo].[uvw_CurrentRemedyTime] AS SELECT DATEDIFF(s, '01/01/1970', GETDATE()) CurrentRemedyTime HTH Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rashmi Amruth Sent: Monday, March 24, 2008 1:09 AM To: arslist@ARSLIST.ORG Subject: Re: Moving records to the top based on a condition ** Hi Joe, The table records are being retrieved from a view form. But this view form already has sort criteria set for existing records. Now, I need to sort only a subset of these records for the criteria which I have defined. Thanks, Rashmi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Moving records to the top based on a condition
...use this Select instead SELECT Summary, Last_Modified_Date, Priority, State, dbo.udf_SortOrder(Last_Modified_Date, Priority, State) AS SortOrder As someone once wrote: If cups_of_coffee 2 Then refill From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Monday, March 24, 2008 9:13 AM To: arslist@ARSLIST.ORG Subject: FW: Moving records to the top based on a condition Rashmi, Here is one way it can be done, however it might not be useful due to performance. I present this to spark ideas... Overview: Using SQL, create a SQL View that includes a calculated column. This column would contain the sort order based on whatever criteria you require. Then create an ARS View form on top of this SQL View. Your table field would reference this calculated column to sort the records on screen. Here is the SQL View: CREATE VIEW dbo.uvw_MySQLViewForARS AS SELECT Summary, Last_Modified_Date, Priority, State, dbo.udf_SortOrder AS SortOrder FROM dbo.SHR_ConsolidatedList Here is the function: CREATE FUNCTION dbo.udf_SortOrder ( @Last_Modified_Date INT, @Priority INT, @State INT ) RETURNS VARCHAR(20) BEGIN DECLARE @SortOrder VARCHAR(20) SET @SortOrder = CONVERT(VARCHAR,@Last_Modified_Date) + '|' + CONVERT(VARCHAR,@Priority) + '|' + CONVERT(VARCHAR,@State) IF @State = 0 AND @Priority = 1 AND (SELECT * FROM dbo.uvw_CurrentRemedyTime) (@Last_Modified_Date + (45 * 60)) RETURN '0|' + @SortOrder RETURN '1|' + @SortOrder END Add whatever other parameters to the function you may need for sorting. For criteria that matches your condition prefix a number. In this example there is only one condition, so I am using only a 0 and a 1 to provide the proper sorting. If you had 5 conditions then you would use numbers 0-5 (or 1-6, or 100 - 105, etc.). Here is the SQL View that the function needs to get the current date/time in Remedy time. *With SQL Server you can't use a non-deterministic value (such as GETDATE()) directly, so you have to use a View to return the value. CREATE VIEW [dbo].[uvw_CurrentRemedyTime] AS SELECT DATEDIFF(s, '01/01/1970', GETDATE()) CurrentRemedyTime HTH Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rashmi Amruth Sent: Monday, March 24, 2008 1:09 AM To: arslist@ARSLIST.ORG Subject: Re: Moving records to the top based on a condition ** Hi Joe, The table records are being retrieved from a view form. But this view form already has sort criteria set for existing records. Now, I need to sort only a subset of these records for the criteria which I have defined. Thanks, Rashmi __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Change Database Entry Mode - Optional to Display Only
One way is to copy the field Id to your buffer. Delete the field and save the form. Then immediately create a new display-only field with the same name and Paste the field Id. Then save the form. That should work...just make sure that no-one is using that form when you make the change. If the field is a drop-down menu or radio button and you don't want to re-enter each individual value, copy the field itself and paste it into a new temporary form. This should also preserve the field Id. Delete the field from the original form, save, then Paste the field into the original form, change the field type to display-only and save. Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Monday, March 24, 2008 11:22 AM To: arslist@ARSLIST.ORG Subject: OT: Change Database Entry Mode - Optional to Display Only Are there any utilities that would allow me to change a database field from Optional to Display Only? ARS 7.0.01 (patch 002) Thanks! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Phone number formatting...
Joe, Here is a SQL Server function that can be used to format your phone numbers. It works with US 7 and 10 digit phone numbers and 10 digit phone numbers with extensions. I like using a function because you can call it with one line of code in ARS workflow, or from a SQL-based database (ARS or non-ARS), and also from a SQL prompt. HTH CREATE FUNCTION dbo.udf_FormatPhoneNumber ( @Phone VARCHAR(100) ) RETURNS VARCHAR(30) AS BEGIN IF ISNULL(@Phone ,'') = '' RETURN NULL DECLARE @tmpPhone VARCHAR(30), @ReturnValue VARCHAR(30), @Pos INT, @Character VARCHAR(1), @Ext VARCHAR(10) -- Remove any existing formatting. SET @tmpPhone = REPLACE(REPLACE(REPLACE(REPLACE(ISNULL(@Phone, ''), '(', '') , ')', ''), '-', ''), ' ', '') set @ReturnValue = '' SET @Pos = 1 -- Build string of only numbers. WHILE @Pos = LEN(@tmpPhone) BEGIN SET @Character = SUBSTRING(@tmpPhone, @Pos, 1) IF @Character BETWEEN '0' AND '9' SET @ReturnValue = @ReturnValue + @Character SET @Pos = @Pos + 1 END IF @ReturnValue = '' RETURN NULL IF LEN(@ReturnValue) 10 SET @Ext = ' x' + SUBSTRING(@ReturnValue, 11, 10) ELSE SET @Ext = '' IF LEN(@ReturnValue) = 10 SET @ReturnValue = RTRIM('(' + LEFT(@ReturnValue, 3) + ') ' + SUBSTRING(@ReturnValue, 4, 3) + '-' + SUBSTRING(@ReturnValue, 7, 4) + ' ' + @Ext) ELSE SET @ReturnValue = RTRIM(LEFT(@ReturnValue, 3) + '-' + SUBSTRING(@ReturnValue, 4, 4) + @Ext) RETURN @ReturnValue END Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Wednesday, March 12, 2008 10:20 PM To: arslist@ARSLIST.ORG Subject: Phone number formatting... snipped to size for arslist Joe D'Souza __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: White Space
If I could add to this... Add another REPLACE() that surrounds the one below that changes ;; into ;. This is just in case there already are some semi-colons in the list of email addresses. Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ron Tavares Sent: Monday, March 10, 2008 3:48 PM To: arslist@ARSLIST.ORG Subject: Re: White Space ** Just before the Notify action to send the e-mail, do a 'Set Field' action: REPLACE ($your email address field$, , ;). I blieve this will do the trick. On 3/10/08, Brittain, Mark [EMAIL PROTECTED] wrote: ** HI All, I am having a challenge with white space in emails. If a use selects multiple email addresses from a menu, there is a white space. Of course this barfs when the email goes out. Is there a way to replace the white space on submit with a semi-colon. Thanks Mark Mark Brittain ESM Remedy Developer NaviSite Inc. 315-453-2912 x5418 (office) 315-317-2897 (cell) This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: LDAP arplugin failure problem
Maria, Another option to get around the LDAP query limitation is to create a single SQL View comprised of multiple SELECTs that are UNIONed together. You can then query this view and retrieve all LDAP entries. See the email from January 9 entitled Re: LDAP Question. There is a script attached that can be used to create the SQL View. Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Bean Sent: Thursday, March 06, 2008 7:20 PM To: arslist@ARSLIST.ORG Subject: Re: LDAP arplugin failure problem Hi Maria, I would guess that your LDAP server has an entry count limit on the number of records that can be returned by a search. This is fairly common -- usually LDAP servers are set to an entry count limit of 1 or 2 thousand records. If the LDAP admin is unwilling or unable to alter this setting, you might try breaking it up into multiple escalations that search for the users in manageable chunks (e.g., all users with user names starting with A, then B, then C, etc.). Each letter of the alphabet would have to return fewer entries than the LDAP entry count limit, of course. That would a whopping 26 escalations instead of one, but it might work, depending upon how many users you have in LDAP. If you can go another route, I have found that it is much easier to set up this kind of import using a view form to an external database rather than an vendor form using the ARDBC LDAP plugin. --Thomas - Original Message - From: Maria C Delagarza mailto:[EMAIL PROTECTED] Newsgroups: gmane.comp.crm.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, March 06, 2008 1:07 PM Subject: LDAP arplugin failure problem ** Hi Listers, I am appealing to people smarter than myself. I currently am having an issue with an LDAP import. Here is the scenario: We are connected to the LDAP and can run queries on the Vendor Form that return the record we want to see. However, when we run the same query through a filter escalation the arplugin fails and does not give an error messageit fails around 50K records or so. Any thoughts? We are running ARS 7.1 Patch 006 MS SQL 2005 Windows Server 2003 Any help is much appreciated, we are trying to get to a pilot on Monday and this problem is preventing our CTM:People population. Thanks. MCD Maria C Delagarza AR System Specialist Eluri Designs eluridesign.com [EMAIL PROTECTED] __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Output of field contents to file via a filter action
Fred, That's cool. I did not know that about that part of the Notify command. For reference, in ARS 6.3, the BasicGuide-630.pdf describes it on page 524. In my testing this morning I am not sure if I can use it here. I see three challenges to overcome: 1. The first 8 lines and the last 3 need to be removed from the file. This is extra text inserted by the Notify command. a. The application or process that ultimately receives the file will need to remove these extra lines. 2. Each time the Notify command is run it appends to the existing file. a. After each run the file needs to be deleted or renamed. 3. The filename is not unique. For example, notify4.arn. This prevents multiple simultaneous users from running this command. Even though you can have up to 80 different file names (notify4.arn through notify83.arn) there is no guarantee that two users will not run the process that creates these files at the same time. a. An indirect work-around is to create a queue for these command whereby only one command is run at one time. Since this a new command for me, are there any work-arounds for these items? Items 2 and 3 could have been dealt with if ARS allowed for custom (unique) filenames. Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Thursday, March 06, 2008 9:28 PM To: arslist@ARSLIST.ORG Subject: Re: Output of field contents to file via a filter action An easier way to do it would be to use the Notify action. Change the Mechanism field to Other and put a number (4 and above) in the Other Code. This will create a file on your server. The Other mechanism is documented in the Workflow Objects manual (pg 76 for 7.0.x) Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Thursday, March 06, 2008 2:52 PM To: arslist@ARSLIST.ORG Subject: Re: Output of field contents to file via a filter action Mike, Here is one option (there are probably many). Since you are on Windows create a small .Net console app with the .Net ARS API that retrieves the email contents by querying the form, then creates a text file of the contents of the email, then attaches the file to an Attachment Field in Remedy. Your filters would first determine the length of the email, and then only call the console app when it is greater than a certain number. When you call the console app you would pass in the $1$ value so it knows which record to work with. Afterwards, if you wanted to take this concept further you could design the console app to work with any form, and field, and any attachment field. You could then use this with other forms. Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mike Balogh Sent: Thursday, March 06, 2008 3:28 PM To: arslist@ARSLIST.ORG Subject: Output of field contents to file via a filter action Hi everyone - I'm attempting to output the contents of a large character field to a file via a filter action. I must use a filter because this process will be used for processing emails coming in to our server. Above a certain size I want to output the email body to a file and then attach that file to a Helpdesk ticket. I've tried using the following via as a Run Process command: %ComSpec% /C Echo $FieldValue$ c:\file.txt This works great until the field has a carriage return in the value. Once a carriage return is introduced into the field, the process fails completely and the file is not created at all. Unfortunately, virtually every time we use this process, the field value is going to have potentially thousands of carriage returns in it. I've tried various combinations with the /A and /S switches as well as putting double-quotes around the $FieldValue$. Anyone have any other suggestions or a completely different way I could try to do this? Windows Server 2003 Enterprise MS SQL 2005 ARS 7.0.01 p2 Thanks in advance! ~Mike --- Michael J Balogh Wingspan Systems Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Output of field contents to file via a filter action
Carey, Precisely. Thanks for the confirmation. I don't think I can make use of this command for the purpose of creating a file from the contents of an ARS field. Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Friday, March 07, 2008 8:42 AM To: arslist@ARSLIST.ORG Subject: Re: Output of field contents to file via a filter action Stephen, I am certain that the design intent was that there would be a process that parses the file and does the right thing with what it finds in the file. So #2 and #3 are totally by design. Also the process was envisioned as a standing server process and not something that is invoked over and over again. But I guess you could do that too. You just have to manage the high water mark for the entries that you have already processed between invocations. If you need to pass data to the process that is monitoring the file then the value needs to be a field that is written to the entry in the file. The process parses the entry and does what it needs to do from there. If my vague memory is correct, I would be careful about altering/renaming/moving the file while the ARS server is running. You may find that multiple users are writing to the file and that there are some bad times to alter the file. Also the ARS server may be confused by the files length changing or disappearing out from underneath it too. ( I seem to remember issues like that from when I played with this many years ago. But my memory might be poor about the details from that long ago. Do some testing at least.) The thing that I do not like about the approach is that it builds in a queue. (and thus a likely delay in the process) If what you need is in line processing then look toward the Filter Plugin. If the queue effect it desired and/or helpful then the Notify-Other model may work well for you too. HTH. -- 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 Fri, Mar 7, 2008 at 7:53 AM, Heider, Stephen [EMAIL PROTECTED] wrote: ** Fred, That's cool. I did not know that about that part of the Notify command. For reference, in ARS 6.3, the BasicGuide-630.pdf describes it on page 524. In my testing this morning I am not sure if I can use it here. I see three challenges to overcome: The first 8 lines and the last 3 need to be removed from the file. This is extra text inserted by the Notify command. The application or process that ultimately receives the file will need to remove these extra lines. Each time the Notify command is run it appends to the existing file. After each run the file needs to be deleted or renamed. The filename is not unique. For example, notify4.arn. This prevents multiple simultaneous users from running this command. Even though you can have up to 80 different file names (notify4.arn through notify83.arn) there is no guarantee that two users will not run the process that creates these files at the same time. An indirect work-around is to create a queue for these command whereby only one command is run at one time. Since this a new command for me, are there any work-arounds for these items? Items 2 and 3 could have been dealt with if ARS allowed for custom (unique) filenames. Stephen Remedy Skilled Professional ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Refresh Table - Maintain Sort
ARS 6.3 p23 (server and user tool) I have noticed an undesirable behavior with refreshing tables when using the Run Process PERFORM-ACTION-TABLE-REFRESH command. I hope there is a work-around. Here is the issue: A user clicks on a table field column in order to sort by that column. The user then clicks a Refresh button. When workflow uses the Change Field - Refresh Table Field command the table field remains sorted by the column the user had selected. When workflow uses the Run Process - PERFORM-ACTION-TABLE-REFRESH command the sort order is reset to the default. Which means the user has to click the column again to sort by that column. Is there any way to stop ARS from resetting the default sort order for the table field? BTW, I use the PERFORM-ACTION-TABLE-REFRESH command so that users can determine how many rows to return. For example, on one of my screens I have a radio button that reads Show up to: o 100 o 250 o 500 o 750 o 1000 with 100 as the default. For most searches 100 is enough, yet users have the option to show more as needed. The full Run Process command is PERFORM-ACTION-TABLE-REFRESH 536870938 1 $zTmpInt1$. TIA Stephen Remedy Skilled Professional ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Refresh Table - Maintain Sort
Tony, My understanding is that PERFORM-ACTION-TABLE-REFRESH is the only command which allows you to specify the number of rows to return [from a field]. With PERFORM-ACTION-ACTIVE-LINK, can you specify the number of rows to return? Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tony Worthington Sent: Thursday, March 06, 2008 9:43 AM To: arslist@ARSLIST.ORG Subject: Re: Refresh Table - Maintain Sort ** Not a solution to the actual problem .. but a workaround might be to push the refresh button in an a/l with perform-action-active-link 1 field id of refresh button -- Tony Worthington Sr. Technical Analyst Kohl's Department Stores [EMAIL PROTECTED] 262-703-5911 Heider, Stephen [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 03/06/2008 08:28 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Refresh Table - Maintain Sort ** ARS 6.3 p23 (server and user tool) I have noticed an undesirable behavior with refreshing tables when using the Run Process PERFORM-ACTION-TABLE-REFRESH command. I hope there is a work-around. Here is the issue: A user clicks on a table field column in order to sort by that column. The user then clicks a Refresh button. When workflow uses the Change Field - Refresh Table Field command the table field remains sorted by the column the user had selected. When workflow uses the Run Process - PERFORM-ACTION-TABLE-REFRESH command the sort order is reset to the default. Which means the user has to click the column again to sort by that column. Is there any way to stop ARS from resetting the default sort order for the table field? BTW, I use the PERFORM-ACTION-TABLE-REFRESH command so that users can determine how many rows to return. For example, on one of my screens I have a radio button that reads Show up to: o 100 o 250 o 500 o 750 o 1000 with 100 as the default. For most searches 100 is enough, yet users have the option to show more as needed. The full Run Process command is PERFORM-ACTION-TABLE-REFRESH 536870938 1 $zTmpInt1$. TIA Stephen Remedy Skilled Professional __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Refresh Table - Maintain Sort
Kalyan, The default sort, as defined in the table properties, is fine. It's when the user sorts it differently by clicking a column that I want to retain after a table refresh. The Change Field works but does not allow you to specify the number of rows to return. The PERFORM-ACTION-TABLE-REFRESH does allow you to specify the number of rows to return but resets the sort order to what is defined in the table properties. The goal is to prevent ARS from resetting the sort during a table refresh with the PERFORM-ACTION-TABLE-REFRESH command. Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kalyan Krishna Nethy Sent: Thursday, March 06, 2008 11:03 AM To: arslist@ARSLIST.ORG Subject: Re: Refresh Table - Maintain Sort ** Hi Stephen, I think you can mention the the fields to sort with in the table properties. I hope that will work. Regards, Kalyan. On Thu, Mar 6, 2008 at 9:22 PM, Heider, Stephen [EMAIL PROTECTED] wrote: ** Tony, My understanding is that PERFORM-ACTION-TABLE-REFRESH is the only command which allows you to specify the number of rows to return [from a field]. With PERFORM-ACTION-ACTIVE-LINK, can you specify the number of rows to return? Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tony Worthington Sent: Thursday, March 06, 2008 9:43 AM To: arslist@ARSLIST.ORG Subject: Re: Refresh Table - Maintain Sort ** Not a solution to the actual problem .. but a workaround might be to push the refresh button in an a/l with perform-action-active-link 1 field id of refresh button -- Tony Worthington Sr. Technical Analyst Kohl's Department Stores [EMAIL PROTECTED] 262-703-5911 Heider, Stephen [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 03/06/2008 08:28 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Refresh Table - Maintain Sort ** ARS 6.3 p23 (server and user tool) I have noticed an undesirable behavior with refreshing tables when using the Run Process PERFORM-ACTION-TABLE-REFRESH command. I hope there is a work-around. Here is the issue: A user clicks on a table field column in order to sort by that column. The user then clicks a Refresh button. When workflow uses the Change Field - Refresh Table Field command the table field remains sorted by the column the user had selected. When workflow uses the Run Process - PERFORM-ACTION-TABLE-REFRESH command the sort order is reset to the default. Which means the user has to click the column again to sort by that column. Is there any way to stop ARS from resetting the default sort order for the table field? BTW, I use the PERFORM-ACTION-TABLE-REFRESH command so that users can determine how many rows to return. For example, on one of my screens I have a radio button that reads Show up to: o 100 o 250 o 500 o 750 o 1000 with 100 as the default. For most searches 100 is enough, yet users have the option to show more as needed. The full Run Process command is PERFORM-ACTION-TABLE-REFRESH 536870938 1 $zTmpInt1$. TIA Stephen Remedy Skilled Professional __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Output of field contents to file via a filter action
Mike, Here is one option (there are probably many). Since you are on Windows create a small .Net console app with the .Net ARS API that retrieves the email contents by querying the form, then creates a text file of the contents of the email, then attaches the file to an Attachment Field in Remedy. Your filters would first determine the length of the email, and then only call the console app when it is greater than a certain number. When you call the console app you would pass in the $1$ value so it knows which record to work with. Afterwards, if you wanted to take this concept further you could design the console app to work with any form, and field, and any attachment field. You could then use this with other forms. Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mike Balogh Sent: Thursday, March 06, 2008 3:28 PM To: arslist@ARSLIST.ORG Subject: Output of field contents to file via a filter action Hi everyone - I'm attempting to output the contents of a large character field to a file via a filter action. I must use a filter because this process will be used for processing emails coming in to our server. Above a certain size I want to output the email body to a file and then attach that file to a Helpdesk ticket. I've tried using the following via as a Run Process command: %ComSpec% /C Echo $FieldValue$ c:\file.txt This works great until the field has a carriage return in the value. Once a carriage return is introduced into the field, the process fails completely and the file is not created at all. Unfortunately, virtually every time we use this process, the field value is going to have potentially thousands of carriage returns in it. I've tried various combinations with the /A and /S switches as well as putting double-quotes around the $FieldValue$. Anyone have any other suggestions or a completely different way I could try to do this? Windows Server 2003 Enterprise MS SQL 2005 ARS 7.0.01 p2 Thanks in advance! ~Mike --- Michael J Balogh Wingspan Systems Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: OT - Possible Friday Humor from BMC's Knowledgebase
Does anyone know if ARS contains any Easter eggs? Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Lammey, Peter A. Sent: Friday, February 22, 2008 10:12 AM To: arslist@ARSLIST.ORG Subject: OT - Possible Friday Humor from BMC's Knowledgebase I was out on BMC's Knowledge website looking up knowledge regarding table fields and their retrieving values from the a Table field column that is linked to a Selection field (or drop down field). After the list of knowledge articles was returned I opened up one titled Can I query for the values in the column within a Table Field?. This is knowledge article KM-3274. When you read this article the author wrote the Solution in a very funny manner. It seems like this person must have read too many Dr. Seuss books or something. Take a look out on BMC's website at this Knowledge article where the solution reads: Query on Columns within a Table field. You can not do it in a box with a fox, nor in a house with a mouse, or with a punk on a skunk. You can not do it here or there you can not do it anywhere, you can not Query on a Table you can not do it, you just arent able :) Thanks Peter Lammey ESPN MIT Technical Services Applications Management 860-766-4761 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Check within workflow for users licence type / state
Albert, If I understand your question, couldn't you do a regular Set Fields from the User form with a Set Field If set to: 'Login Name' = $USER$ AND ('License Type' = Fixed OR 'License Type' = Floating) Set the value of the Login Name field from the User form to a zTmp field on your form. The next filter or active link would check to see if the zTmp field was $NULL $ or not. If not, then the user has a license to write. Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Albert Bihler Sent: Thursday, February 21, 2008 11:14 AM To: arslist@ARSLIST.ORG Subject: Check within workflow for users licence type / state Hi list, is there a way to check using workflow whether the user that is running the workflow has currently a read, read (floting) or write (floating) license? Whenever a user leaves our main form we write some field values to a user preferences form (on window close). This works fine as long as the user has got a proper license. However if the user only has a read token it fails with ARERR [8932] You do not have write license Possible solutions that are coming to my mind are: - Do a direct sql instead of a push-field action. This is not nice because we are talking of about 50 fields and I think this could violate the license agreement. - Push values to a new form and create always a new record there Then let an escalation push the values to the users properties form. Not nice because a lot of workflow and there is a time delay because of the escalation. - check for the users license and only save the fields when he has a write token. Not nice either. Any suggestions? ARS 7.0.1 Solaris 10 Oracle 10gR2 Kind regards, Albert ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARinside
Have you tried here? http://www.mattreinfeldt.com/site/component/option,com_docman/task,cat_v iew/gid,35/Itemid,28/ Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gayford, Matthew C. Sent: Wednesday, February 20, 2008 12:34 PM To: arslist@ARSLIST.ORG Subject: Re: ARinside The site used to be system.devdor.net but that link no longer works, it just takes you to a domain parking page. I've got the installer for 2.07.2 if that helps. -Matt Matthew C. Gayford Technology Research Development Information Technology Systems Division University of North Carolina Wilmington (910) 962-7177 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Toby White Sent: Wednesday, February 20, 2008 12:10 PM To: arslist@ARSLIST.ORG Subject: ARinside ** What is the latest version of ARinside? Where can I find it? Thanks, Toby. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Escalations ARS 7.x
On my wish list (for years), I want to be able to right-click any escalation and select Run Now. Maybe in a later version of ARS. You could create a separate regular form to hold your escalations which has filters attached to it. An escalation would then check this small form every 1 minute to see if anything needs to be done. If so, then the escalation would push a value to the Status field, which would run the filters and update the schedule for the next run. With your escalations in a separate form you could then test any escalation by manually updating the Status field. HTH Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Friday, February 15, 2008 5:41 PM To: arslist@ARSLIST.ORG Subject: Re: Escalations ARS 7.x If that's the case I do agree that sucks especially if you have the need to run that one time escalation over lets say 500 K records.. It would be harder to design one in a minutes interval. The workaround would be to create a flag that the escalation would set after its run on a record.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Russ Grant Sent: Friday, February 15, 2008 5:10 PM To: arslist@ARSLIST.ORG Subject: Escalations ARS 7.x ** Apparently there is a change to the way Escalations execute in ARS 7.x. In previous versions of ARS, going back MANY years, when you created an escalation which runs on an interval - it would execute upon saving it and then on the interval. In version 7.1 the escalation will not execute immediately but will wait until the interval time to execute. While I can appreciate that people might want to wait until the interval time has expired before running the escalation I wish that Remedy would have made it an option, I want it to run immediately so I can test the results. I realize I can set a short interval, test the results, then reset the interval but in many cases I only want to run the escalation once to clean up data, in which case I would set the interval to 99 days (just in case I get side tracked , I still have 99 days to turn off the escalation). Russ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Newbie: form with links to frequently accessed forms
Ravi, Here is another approach, something I implemented here. I have about 80 forms that I frequently need to open and search. Using the Find option in the Object List (Ctrl+O, Find, enter text, click Find) is not convenient to me. I use a Table Field on a display-only/control panel form that points to a Regular form containing the names of forms I wish to open. I use an active link that opens the form when I double-click a row in the Table field. Regular form fields: 'Display Name' A friendly name for the form. 'Form Name' ARS form name, or URL. 'VUI Name' ARS VUI name. 'URL' Checkbox if the entry is a URL. The Table Field shows the 'Display Name' and 'Form Name' columns. The URL field is included but hidden. On double-click the active link opens the form, or if the 'URL' checkbox is checked then it opens the URL. For opening ARS forms (not URLs) the Open Window command uses $SERVER$ for the Server Name field, $col Form Name$ for the Form Name field, and $col VUI Name$ for the Form View field. The Window Type is set to Search and the Target Location is set to New. For opening URLs, I use this Run Process command: rundll32 url.dll,FileProtocolHandler $col Form Name$ I only need this for Windows User Tool. You could use the Run Process command PERFORM-ACTION-OPEN-URL new to open URLs in mid-tier. Creating this only took about 30 minutes and I use it every single day for my administration. Anytime I find myself opening a form that is not in this list of forms I just add a record to the Regular form field (described above) and from them on all I need to do is double-click in the Table field and it's opened for me. To enhance this you could add a checkbox to open the form in New mode instead of Search mode. I seldom need to open in New mode so when I need to, I first open in Search modem then select Edit Copy to New. Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: Friday, February 08, 2008 7:40 AM To: arslist@ARSLIST.ORG Subject: Re: Newbie: form with links to frequently accessed forms This is all I am looking for. Thank you. One more question about the active link. Can the active link take the name of the button as an argument. What I am saying is the following: if I have 5 buttons opening 5 different forms, can I just have one active link taking the name of the button as an argument or do I have to create 5 active links? Thanks Ravi MUNJAL, Jaya, IDC wrote: ** Ravi § Create a Display Only Form § Create 5 buttons (name them according to the form they open) § Create 5 Active Link with Open Window Action. In the open Window specify which Form you want to open For more details on the Open Window action of active link refer to Basic User Guide. Hope this helps. Thanks Jaya Munjal IEA Remedy Team RBS India Development Centre (P) Ltd T +91 124 6724163 M +91 9811405409 [EMAIL PROTECTED] Unitech Business Park, Block F, Sector 41, South City 1, Gurgaon, Harayana India 122001 P Please don't print this e-mail unless you really need to. www.rbs.com Visit our Sharepoint site here Raise a fault with one of our systems here -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: 08 February 2008 08:52 To: arslist@ARSLIST.ORG Subject: Newbie: form with links to frequently accessed forms Hi: I typically access about 5 forms as a user from the remedy client. Can somebody point me to the right doc which explains how I can create a simple form with links to these forms in search or new mode? I have searched many docs and can't seem to find it. TIA Ravi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are *** The Royal Bank of Scotland plc. Registered in Scotland No 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. Authorised and regulated by the Financial Services Authority This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc does not accept responsibility for changes made to this message after it was sent. Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward
Re: Parenthesis
Lisa, Tip: When I need to edit a qualification where ARS automatically (and not wanted) adds a bunch of parenthesis, I copy/paste the entire qualification into notepad and quickly perform a search replace for ) and then for ( to remove all parenthesis. Then I add back the few parentheses that actually mean something and then copy/paste back into the ARS object. If I know I will be working and testing the qualification for a while I leave notepad open (with the qualification text). This way I can do all my editing in notepad and not have to deal with ARS continually adding its own parenthesis. HTH Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Tuesday, February 05, 2008 1:54 PM To: arslist@ARSLIST.ORG Subject: Re: Parenthesis This worked, Thanks everyone!! Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Tuesday, February 05, 2008 1:48 PM To: arslist@ARSLIST.ORG Subject: Re: Parenthesis ( 'Status' = ACTIVE) AND ('tmp_SurveyDate' = $NULL$) AND ((( 'Q1' != $NULL$ ) AND ( 'Response 1' = $NULL$ )) OR (( 'Q2' != $NULL$ ) AND ( 'Response 2' = $NULL$ ))) On Feb 5, 2008 1:43 PM, Kemes, Lisa [EMAIL PROTECTED] wrote: ** I'm having a heck of a time trying to get this Run If statement to work: (( 'Status' = ACTIVE) AND ('tmp_SurveyDate' = $NULL$) AND ( 'Q1' != $NULL$ ) AND ( 'Response 1' = $NULL$ )) OR (( 'Q2' != $NULL$ ) AND ( 'Response 2' = $NULL$ )) I want this filter to run if: (Q1 is not null and Response 1 is Null) OR (Q2 is not Null or Response 2 is Null) but only if the Status is Active and the tmp_SurveyDate is Null No matter where I put my parenthesis, Remedy keeps putting them where it wants to and it's running my filter even though the tmp_SurveyDate field NOT Null. Any ideas? Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax [EMAIL PROTECTED] __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
ServletExec Max Concurrent Requests Exceeded
All users receiving this error from mid tier server: ServletExec Max Concurrent Requests Exceeded When not registered, ServletExec supports a maximum of 3 concurrent requests. Nothing has changed on that server for a long time, except flushing the cache periodically. I rebooted the mid-tier server and everything appears fine now. Any idea as to how this may have occurred? ARS server ARS 6.3 p22 SQL Server 2000 Windows Server 2003 Mid Tier server Mid Tier 6.3 p22 Windows Server 2003 IIS 6 New Atlanta ServletExec 5.0 (from the ARS 6.3 mid-tier installation program) Thanks. Stephen Remedy Skilled Professional ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Find EXCEL.EXE full path
Here is the way I do it - it's been in production for about 3 years now. I test for the usual places the various versions of Excel reside. Active Link 1 (check for Excel 2003) Run If Qual: nothing Set Fields zTmpField1 = C:\Program Files\Microsoft Office\OFFICE11\Excel.exe Set Fields zTmpField2 = $PROCESS$ cmd.exe /c if exist $zTmpField1$ (echo Yes) else (echo No) Active Link 2 (not found, check for Excel XP) Run If Qual: NOT 'zTmpField2' LIKE Y% OR 'zTmpField2' = $NULL$ Set Fields zTmpField1 = C:\Program Files\Microsoft Office\OFFICE10\Excel.exe Set Fields zTmpField2 = $PROCESS$ cmd.exe /c if exist $zTmpField1$ (echo Yes) else (echo No) Else Action (means it found it in Active Link 1) Set Fields Global - Excel Path = $zTmpField1$ ...and so on until you find a match. Right now I only check for Excel 2003, Excel XP, Excel 2000. This reminds me, I need to add a check for Excel 2007 since several users are beginning to use that version. There is another option available to you - WksInfo from http://arswiki.org/projects/dotnetutil. Click on the Downloads link located in the upper-right part of the screen. This free open source utility gathers a number of details from the user's computer (from Windows User Tool, not Mid-Tier) and makes them available to your workflow. The Excel path is included (although it needs to be updated to check for Excel 2007). The utility is written in VB.Net 2005 and the ARS .Net API. Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of CONDREA, Daniel Sent: Thursday, January 24, 2008 7:49 AM To: arslist@ARSLIST.ORG Subject: Find EXCEL.EXE full path Hi All, Can anyone share 'How to get EXCEL.EXE full path from user tool?' Usually EXCEL.EXE path is C:\Program Files\Microsoft Office\OFFICE11 Thank you very much, Daniel Condrea ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: how to remove duplicate entries
serouche, If you know SQL you could write a stored procedure that would identify the duplicates and then update a separate field on the form (ie. Set an Optional Checkbox field to 0). Followed by a filter that would delete each of the records which have a value in this checkbox field. If you need users to be able to run this at anytime trigger it from an Active Link. HTH Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Misi Mladoniczky Sent: Monday, January 21, 2008 6:28 AM To: arslist@ARSLIST.ORG Subject: Re: how to remove duplicate entries Hi, You could create a table-field that sorts its content on the field(s) you want to remove duplicates from. Also include the request-id in one column. Table Field with Columns: - TblColValue - TblColReqID Create a display-only-temp-fields: - TempPrevValue Then you create Active Links for a table-loop-guide: AL 1: Run If: $TblColValue$ = $TempPrevValue$ Action Run Process: @@:Application-Delete-Entry Form $TblColReqID$ AL 2: Run If: Action Set Fields: TempPrevValue = $TblColValue$ Create the Guide and add the above Active Links: Create an Active Link that calls the guide with Table Loop activated. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. dear all, I would like to clean-up duplicate entries in a character field. I must use AL on the web. How can I do this? Through filters I would do something like RUN PROCESS echo MYFIELD | sort | uniq and that will do but through AL on the web I don't see. Please help. Thank you. serouche /because there is always a remedy to help you/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
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. 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 form. To do so, find out the table names that comprise the Remedy form. Run the following command to get the schema number. SELECT schemaId FROM ARSchema WHERE name = 'Alert Events' On my system it is 6. Then run these three commands to clear out all entries (substitute the number 6 for the number on your system). TRUNCATE TABLE T6 TRUNCATE TABLE H6 TRUNCATE TABLE B6 Now that the form is clear add workflow to automatically maintain the form size. Add a display-only radio button field to the form named something like 'Delete This Record'. Add a filter that runs on Modify when this field = 0. The filter will use a Run Process with the command Application-Delete-Entry $SCHEMA$ $1$ to delete the record. Create an escalation that runs once a night which sets the value of 0 to the 'Delete This Record' field when 'Create Date' ($TIMESTAMP$ - (86400 * 21)) This will keep only that last 21 days of entries in this form. Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Thursday, January 10, 2008 8:00 AM To: arslist@ARSLIST.ORG Subject: Delete Records of Alert Events Hello for all, How can I clean up records from a table that growths abnormaly?? I'm facin' a serious problem with Alert Events table. Since 2004 it's been growing without control... Nowadays, this table has around 7 GB... I want to know if have a way that I can delete all records of this table with a security mode (not crashing the server)... Could it be with Escalations? If Yes, how? With Application-Delete-Entry? Application-Query-Delete-Entry?? I thought in a way to delete records based in a range of date... Like taking the date of First record saved in this table and going to deleting month by month (in a range of a month/day)... Is it possible?? Gimme your suggestions, please! Thankx-in-advance... Regards... P.S.1: I have knowledge tha exists the Escalation CleanUpAlertEvents but I think that this way will crash my ARS server if I runs it... P.S.2: I have another tables like that... but Alert Events is the greater... Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Delete Records of Alert Events
Tadeu, The form on my server had 500,000 records. However, with the TRUNCATE TABLE command the RDBMS handles the deletions differently than a DELETE FROM command (which is what the Remedy clients use). The DELETE FROM command updates the Transaction Log so in the event of an error it can Rollback the deletions. When you want to completely empty a table then you certainly would not want to use the DELETE FROM. You could end up with a 7GB increase in the size of the Transaction Log and it would take forever because, in your situation, it would need to re-write all 35 million records to the log. The TRUNCATE TABLE command wipes out every record in a table instantly and discards all the data in one command. The Transaction Log is not updated which is why it runs so quickly. I have no reservations at all with running this command in a production environment - so long as you get the table names correct :) However, this is your environment not mine. If you are a little unsure of performing this operation during regular hours (although it should not matter with this command on this particular Remedy form) then you could clear out these entries off-hours after performing a backup of the database. HTH Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Thursday, January 10, 2008 8:46 AM To: arslist@ARSLIST.ORG Subject: RES: Delete Records of Alert Events Hi Stephen, Thank you very much for your post... I did the test on my 'test server'... that I have only 2000 records it's runs very well... But, it's safe to execute this command in my 'production server'?? Alert Events on this server has 35.626.325 records... How many records did you delete from your system when you did it? Around 35 million, too?? Thankx-in-advance, again... Regards, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. 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. 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 form. To do so, find out the table names that comprise the Remedy form. Run the following command to get the schema number. SELECT schemaId FROM ARSchema WHERE name = 'Alert Events' On my system it is 6. Then run these three commands to clear out all entries (substitute the number 6 for the number on your system). TRUNCATE TABLE T6 TRUNCATE TABLE H6 TRUNCATE TABLE B6 Now that the form is clear add workflow to automatically maintain the form size. Add a display-only radio button field to the form named something like 'Delete This Record'. Add a filter that runs on Modify when this field = 0. The filter will use a Run Process with the command Application-Delete-Entry $SCHEMA$ $1$ to delete the record. Create an escalation that runs once a night which sets the value of 0 to the 'Delete This Record' field when 'Create Date' ($TIMESTAMP$ - (86400 * 21)) This will keep only that last 21 days of entries in this form. Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Thursday, January 10, 2008 8:00 AM To: arslist@ARSLIST.ORG Subject: Delete Records of Alert Events Hello for all, How can I clean up records from a table that growths abnormaly?? I'm facin' a serious problem with Alert Events table. Since 2004 it's been growing without control... Nowadays, this table has around 7 GB... I want to know if have a way that I can delete all records of this table with a security mode (not crashing the server)... Could it be with Escalations? If Yes, how? With Application-Delete-Entry? Application-Query-Delete-Entry?? I thought in a way to delete records based in a range of date... Like taking the date of First record saved in this table and going to deleting month by month (in a range of a month/day)... Is it possible?? Gimme your suggestions, please! Thankx-in-advance... Regards... P.S.1: I have knowledge tha exists the Escalation CleanUpAlertEvents but I think that this way will crash
Re: Delete Records of Alert Events
...this got me thinking. It would be useful to see the number of records in each of Remedy's data forms. I just created the attached SQL Server View that lists row counts of just the data tables (T, H, B) and their corresponding form names. To see this inside of Remedy, create a Remedy 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 Records of Alert Events Tadeu, The form on my server had 500,000 records. However, with the TRUNCATE TABLE command the RDBMS handles the deletions differently than a DELETE FROM command (which is what the Remedy clients use). The DELETE FROM command updates the Transaction Log so in the event of an error it can Rollback the deletions. When you want to completely empty a table then you certainly would not want to use the DELETE FROM. You could end up with a 7GB increase in the size of the Transaction Log and it would take forever because, in your situation, it would need to re-write all 35 million records to the log. The TRUNCATE TABLE command wipes out every record in a table instantly and discards all the data in one command. The Transaction Log is not updated which is why it runs so quickly. I have no reservations at all with running this command in a production environment - so long as you get the table names correct :) However, this is your environment not mine. If you are a little unsure of performing this operation during regular hours (although it should not matter with this command on this particular Remedy form) then you could clear out these entries off-hours after performing a backup of the database. HTH Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Thursday, January 10, 2008 8:46 AM To: arslist@ARSLIST.ORG Subject: RES: Delete Records of Alert Events Hi Stephen, Thank you very much for your post... I did the test on my 'test server'... that I have only 2000 records it's runs very well... But, it's safe to execute this command in my 'production server'?? Alert Events on this server has 35.626.325 records... How many records did you delete from your system when you did it? Around 35 million, too?? Thankx-in-advance, again... Regards, Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. 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. 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 form. To do so, find out the table names that comprise the Remedy form. Run the following command to get the schema number. SELECT schemaId FROM ARSchema WHERE name = 'Alert Events' On my system it is 6. Then run these three commands to clear out all entries (substitute the number 6 for the number on your system). TRUNCATE TABLE T6 TRUNCATE TABLE H6 TRUNCATE TABLE B6 Now that the form is clear add workflow to automatically maintain the form size. Add a display-only radio button field to the form named something like 'Delete This Record'. Add a filter that runs on Modify when this field = 0. The filter will use a Run Process with the command Application-Delete-Entry $SCHEMA$ $1$ to delete the record. Create an escalation that runs once a night which sets the value of 0 to the 'Delete This Record' field when 'Create Date' ($TIMESTAMP$ - (86400 * 21)) This will keep only that last 21 days of entries in this form. Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Thursday, January 10, 2008 8:00 AM To: arslist@ARSLIST.ORG Subject: Delete Records of Alert Events Hello for all, How can I clean up records from a table that growths abnormaly?? I'm facin' a serious problem with Alert Events table. Since 2004 it's been growing without control... Nowadays, this table has around 7 GB... I want to know if have
Re: CSV TO XLS via OLE
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, January 10, 2008 12:39 PM To: arslist@ARSLIST.ORG Subject: CSV TO XLS via OLE Has anyone out there ever tried to utilize OLE to convert .csv files to .xls files? I've been trying to use the example on Gidd's website, but I think I have something wrong. I can get it to convert the .csv file to an .xls file, but it basically seems to be putting all the data in a single cell with the data being separated by a comma. I would have expected it to display the data as it would have the original .csv file, with all the data separated into the rows and columns. Does anyone have any pointers for me on this? I'm open to any suggestions. I just need to be able to have Remedy generate a report and save it in the .xls format. I really don't care about the field formatting or anything like that. Just has to be an .xls file. Thanks, Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: LDAP Question
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 to the number of queries. By using a SQL View you can return every record from LDAP. Attached is a view which I used at one point. It breaks down the query into 26 sub queries - each by the first letter of the user's names. Because you have 60K records you would need to further refine the sub queries to never match more than 500 records. Big caveat: You should only use this type of query sparingly and with 60K records, probably only after hours. This is because the SQL View will first return all 60K records to your SQL Server then extract out the matching records (WHERE clause) and return them to your query screen (or ARS View form). Example: You want to see a list of the people whose login names start with the letter R. You run the following command: SELECT sAMAccountName FROM udv_LDAP WHERE sAMAccountName LIKE 'R%' SQL Server will first retrieve all 60,000 records from LDAP (ouch). Then extract out the 100 login names that match your WHERE clause and display them. Just wanted you to be aware. One situation where it is beneficial to retrieve all records is when you need to initially populate an ARS form with LDAP data. If you need to do this every day then you will likely want to schedule this to run when no-one is on the system and the backups are not running (depending upon your topology). Windows Server 2003 Active Directory SQL Server 2000 Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Russ Grant Sent: Wednesday, January 09, 2008 9:46 AM To: arslist@ARSLIST.ORG Subject: LDAP Question Greetings ARList! I'm connecting to a LDAP server using ARDBC LDAP plug-in and then creating a vendor form for workflow. For some reason when I query the vendor form I can only get the first 500 records returned and there should be well over 60k records. There is some history here, I've been using ARDBC LDAP plug-in to connect to a local LDAP server for some time now and I haven't had any problems, I'm able to perform a query on the vendor form and get the correct number of records returned. One of the applications that we use locally now needs to expand to other sites so I need to connect to a global LDAP server instead of the local LDAP server (which doesn't include employees outside our site). This is were I'm having a problem, connecting to the global LDAP server using ARDBC only returns the top 500 records. I realize this probably isn't a Remedy problem but I wanted to see if there were any LDAP gurus that might have a suggestion. Thanks in advance! Russ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are CREATE view [dbo].[udv_LDAP] as SELECT * FROM OpenQuery(ADSI, 'SELECT PwdLastSet, GivenName, sn, sAMAccountName, cn, mail, displayName, department, telephoneNumber, streetAddress, st, distinguishedName, physicalDeliveryOfficeName, userPrincipalName, mailNickname, l, postalCode, msExchHomeServerName, whenCreated, whenChanged, userAccountControl FROM ''LDAP://YOURDCSERVER'' WHERE objectClass=''User'' AND objectCategory=''Person'' AND sn=''A*''') UNION SELECT * FROM OpenQuery(ADSI, 'SELECT PwdLastSet, GivenName, sn, sAMAccountName, cn, mail, displayName, department, telephoneNumber, streetAddress, st, distinguishedName, physicalDeliveryOfficeName, userPrincipalName, mailNickname, l, postalCode, msExchHomeServerName, whenCreated, whenChanged, userAccountControl FROM ''LDAP://YOURDCSERVER'' WHERE objectClass=''User'' AND objectCategory=''Person'' AND sn=''B*''') UNION SELECT * FROM OpenQuery(ADSI, 'SELECT PwdLastSet, GivenName, sn, sAMAccountName, cn, mail, displayName, department, telephoneNumber, streetAddress, st, distinguishedName, physicalDeliveryOfficeName, userPrincipalName, mailNickname, l, postalCode, msExchHomeServerName, whenCreated, whenChanged, userAccountControl FROM ''LDAP://YOURDCSERVER'' WHERE objectClass=''User'' AND objectCategory=''Person'' AND sn=''C*''') UNION SELECT * FROM OpenQuery(ADSI, 'SELECT PwdLastSet, GivenName, sn, sAMAccountName, cn, mail, displayName, department, telephoneNumber, streetAddress, st, distinguishedName, physicalDeliveryOfficeName, userPrincipalName, mailNickname, l, postalCode, msExchHomeServerName, whenCreated, whenChanged, userAccountControl FROM ''LDAP://YOURDCSERVER'' WHERE objectClass=''User'' AND objectCategory=''Person'' AND sn=''D*''') UNION SELECT
Re: Submit Yes/No response to ARS from a blackberry?
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 client) but appears when viewing on a BlackBerry. The user clicks this link which starts the web app. The URL will include at least one parameter that links back to a ticket or record. Although not required, I use a GUID in the URL and each email recipient gets a different GUID (even if the email is being sent to a group). I have a form that keeps track of the GUIDs with the Request Ids and a expiration date. After a certain amount of time (1 week) the link is no longer valid. I use ASP.Net and the ARS .Net API to retrieve ticket details and display to the user. The user can then update the work log, reassign the ticket, and/or change the status. A button is available for them to Submit their changes to the ticket. When clicked the web app updates the ticket in Remedy. For just a Yes/No response you could have two buttons, labeled Yes and No. If you want to ensure that only the recipient of the email can update the ticket you could add a password field to the web app, which the user would enter. The web app would validate the password before updating ARS. HTH Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rabi Tripathi Sent: Friday, January 04, 2008 11:40 AM To: arslist@ARSLIST.ORG Subject: Submit Yes/No response to ARS from a blackberry? All: I need to provide blackberry users ability to receive an email from ARS, from which they should be able to, through some easy means, provide a Yes/No answer back to ARS. Obvious solution is to have them reply to the email with YES or NO text or some other unique string and parse the email in Remedy to process the response... ...but is there a better way? It has been suggested that I can use a Web Service to accomplish this, but I just don't see how I can have blackberry users consume a ARS Web Service, and have that consumption be available in/thru that email. I could have a simple URL in the email that takes them to a simple Remedy form with yes/no buttons, but I am guessing a Mid-tier generated Remedy form isn't visible, functional in blackberry. I have never been sophisticated enough to use/own a blackberry, but I'm pretty sure remedy screens won't show properly. Somebody shout me down, if this is not true, or if there is a workaround. So what has been suggested is provide two URLS in the email, corresponding to Yes and No responses. Again, I don't see what kind of URLs I can construct to communicate yes and no responses back to ARS. I certainly don't see any kind of URL directly consuming any Web Service I might write in ARS. Is my analysis so far reasonable? Do you guys know of any good way to send yes/no to ARS from blackberry? A quick google serach shows stuff like NetBeans allowing code to consume Web Services from blackberries, but I don't know enough to even conceive of a way that could be used in my situation. Ok, I do have some half baked ideas that may or may not work. If I construct a mid-tier URL that queries a form, called say Yes Response Form with a certain record ID (and possibly a security key as well), and write a Get filter on that form to look for the combination of the record ID and the security key and on match interprete that as a Yes response, then although the query result may not show correctly on blackberry, on the server side, the response will have been processed. Worth trying? -- View this message in context: http://www.nabble.com/Submit-Yes-No-response-to-ARS-from-a-blackberry--t p14620271p14620271.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Email - converted to amp;
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, which then logs into the mid-tier app, which then detects this value and displays the popup. The link includes the character, used by a web app to pass in the survey parameter. At some point from the moment Remedy sends the email and when the recipient receives it the is being converted into amp;. This is causing the parameter not be detected by the web app. I keep the email records for 90 days so I can see that the link is formatted correctly. Here is the link as I format it via workflow: How did we do? To fill out a very brief survey, click a href=https://remedyweb.pbsj.com/ARS_SSO/Default.aspx?RID=HD8649 1Survey=Yeshere/a. When you open the email and select View Source, there is out the link looks: href=https://remedyweb.pbsj.com/ARS_SSO/Default.aspx?RID=HD8649 1amp;Survey=Yes Notice the Survey has been changed to amp;Survey. I have been trying to track this down for a while. I'm not sure if it's the Remedy Email Engine, Exchange, or Outlook. Any ideas? Thanks. ARS 6.3 (all modules are patch 22) Windows Server 2003 Exchange 2003 Outlook 2003 Web app is ASP.Net 2005/VB.Net 2005 Stephen Remedy Skilled Professional ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
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 - 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. Unhide a button next to this character field that, when clicked, opens the attachment. This allows the user to open, print, save a local copy, but does not allow them to make any changes to the attachment or remove the attachment from the record. In the above example, only the presence of an attachment will trigger your workflow to make it read-only. You probably would want to add a condition that will not make the attachment read-only if the user is part of a certain group, ie. 'App-Administrator'. This will provide the ability for certain users to have access to remove or update an attachment. Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Thursday, December 13, 2007 1:30 PM To: arslist@ARSLIST.ORG Subject: Re: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED) I don't want the submitter to be able to change it once he or she attaches it to the form. I had thought of using a separate form but I am not sure that would prevent the submitter from changing it as well. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Thursday, December 13, 2007 1:09 PM To: arslist@ARSLIST.ORG Subject: Re: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED) ** Well, even assuming that you didn't want to build a separate form for attachments, couldn't you use the permissions on the field to control the R/W access to it (i.e. allow Submitter only)? Or perhaps only allow write access to the field from a Submit window. Rick On 12/13/07, FRANK, GORDON CTR DISA JSSC [EMAIL PROTECTED] wrote: Classification: UNCLASSIFIED Caveats: NONE You can't use a Change Display action, but you might be able to use an error Filter with the syntax: TR.Attachment field != DB.Attachment field I haven't tried it but I'll bet you can. Let me know. Gordon M. Frank DISA\Version FNS -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Thursday, December 13, 2007 12:42 PM To: arslist@ARSLIST.ORG Subject: Can An Attachment Field Be Made Read Only? ** I have an attachment field on a form. Once a file is attached I want to prevent anyone from changing or deleting the attachment. I would like them to be able to view the attached file. I thought this would be simple using the Change Field action and making it Read Only. Unfortunately that option is not available for that type of field. I know I can hide the field but I would prefer if it was made read only. Is this possible? Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com http://www.Scholastic.com http://www.Scholastic.com __20060125___This posting was submitted with HTML in it___ Classification: UNCLASSIFIED Caveats: NONE ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED)
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 new form with which to test. Add the attachment field, the character field and the button. Then create one active-link that either makes the attachment 'read-only' or updatable. If you can get this to work on your test form then you should be able to make it work on your current form. HTH Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Thursday, December 13, 2007 1:44 PM To: arslist@ARSLIST.ORG Subject: Re: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED) I tried that and for some reason the error message fires if I change any field and try to save the request even if I do not touch the attachment field. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of FRANK, GORDON CTR DISA JSSC Sent: Thursday, December 13, 2007 1:00 PM To: arslist@ARSLIST.ORG Subject: Re: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE You can't use a Change Display action, but you might be able to use an error Filter with the syntax: TR.Attachment field != DB.Attachment field I haven't tried it but I'll bet you can. Let me know. Gordon M. Frank DISA\Version FNS -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Thursday, December 13, 2007 12:42 PM To: arslist@ARSLIST.ORG Subject: Can An Attachment Field Be Made Read Only? ** I have an attachment field on a form. Once a file is attached I want to prevent anyone from changing or deleting the attachment. I would like them to be able to view the attached file. I thought this would be simple using the Change Field action and making it Read Only. Unfortunately that option is not available for that type of field. I know I can hide the field but I would prefer if it was made read only. Is this possible? Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com http://www.Scholastic.com __20060125___This posting was submitted with HTML in it___ Classification: UNCLASSIFIED Caveats: NONE ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED)
Hi Brian, I just tested that here (ARS 6.3) and the changes are not saved back to the attachment field. The WUT did not even detect that a field was changed on the record. I also tried changing another field to get the WUT to detect a field change, and then saved the record. The attachment file did not update. Any anyone else experienced this? Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Thursday, December 13, 2007 2:14 PM To: arslist@ARSLIST.ORG Subject: Re: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED) Hi Stephen, I just tried your approach and I am hoping I did something wrong because this would be a perfect solution. When I click on the button I run an AL with a Run Process action. It performs the following: PERFORM-ACTION-OPEN-ATTACHMENT FieldID This opens the file fine but if I modify the file and save it, the changes are written back to the attachment file. Brian From: Action Request System discussion list(ARSList) [mailto:[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 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. Unhide a button next to this character field that, when clicked, opens the attachment. This allows the user to open, print, save a local copy, but does not allow them to make any changes to the attachment or remove the attachment from the record. In the above example, only the presence of an attachment will trigger your workflow to make it read-only. You probably would want to add a condition that will not make the attachment read-only if the user is part of a certain group, ie. 'App-Administrator'. This will provide the ability for certain users to have access to remove or update an attachment. Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Thursday, December 13, 2007 1:30 PM To: arslist@ARSLIST.ORG Subject: Re: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED) I don't want the submitter to be able to change it once he or she attaches it to the form. I had thought of using a separate form but I am not sure that would prevent the submitter from changing it as well. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Thursday, December 13, 2007 1:09 PM To: arslist@ARSLIST.ORG Subject: Re: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED) ** Well, even assuming that you didn't want to build a separate form for attachments, couldn't you use the permissions on the field to control the R/W access to it (i.e. allow Submitter only)? Or perhaps only allow write access to the field from a Submit window. Rick On 12/13/07, FRANK, GORDON CTR DISA JSSC [EMAIL PROTECTED] wrote: Classification: UNCLASSIFIED Caveats: NONE You can't use a Change Display action, but you might be able to use an error Filter with the syntax: TR.Attachment field != DB.Attachment field I haven't tried it but I'll bet you can. Let me know. Gordon M. Frank DISA\Version FNS -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Thursday, December 13, 2007 12:42 PM To: arslist@ARSLIST.ORG Subject: Can An Attachment Field Be Made Read Only? ** I have an attachment field on a form. Once a file is attached I want to prevent anyone from changing or deleting the attachment. I would like them to be able to view the attached file. I thought this would be simple using the Change Field action and making it Read Only. Unfortunately that option is not available for that type of field. I know I can hide the field but I would prefer if it was made read only. Is this possible? Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com http://www.Scholastic.com http://www.Scholastic.com __20060125___This posting was submitted with HTML in it___ Classification: UNCLASSIFIED Caveats: NONE ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are __20060125___This posting was submitted with HTML in it___
Re: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED)
Brian, Is the attachment field on the form display-only (probably not)? Try this, when the user clicks the button do a Set Fields from the regular attachment field to a hidden display-only attachment field. Then run the PERFORM-ACTION-OPEN-ATTACHMENT command. This way it should be impossible for anything to get written . Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Thursday, December 13, 2007 2:23 PM To: arslist@ARSLIST.ORG Subject: Re: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED) I changed the action to PERFORM-ACTION-SAVE-ATTACHMENT FieldID and that will work but I would rather have them be able to view the attachment directly. From: Sokol, Brian Sent: Thursday, December 13, 2007 2:14 PM To: arslist@ARSLIST.ORG Subject: RE: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED) Hi Stephen, I just tried your approach and I am hoping I did something wrong because this would be a perfect solution. When I click on the button I run an AL with a Run Process action. It performs the following: PERFORM-ACTION-OPEN-ATTACHMENT FieldID This opens the file fine but if I modify the file and save it, the changes are written back to the attachment file. Brian From: Action Request System discussion list(ARSList) [mailto:[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 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. Unhide a button next to this character field that, when clicked, opens the attachment. This allows the user to open, print, save a local copy, but does not allow them to make any changes to the attachment or remove the attachment from the record. In the above example, only the presence of an attachment will trigger your workflow to make it read-only. You probably would want to add a condition that will not make the attachment read-only if the user is part of a certain group, ie. 'App-Administrator'. This will provide the ability for certain users to have access to remove or update an attachment. Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Thursday, December 13, 2007 1:30 PM To: arslist@ARSLIST.ORG Subject: Re: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED) I don't want the submitter to be able to change it once he or she attaches it to the form. I had thought of using a separate form but I am not sure that would prevent the submitter from changing it as well. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Thursday, December 13, 2007 1:09 PM To: arslist@ARSLIST.ORG Subject: Re: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED) ** Well, even assuming that you didn't want to build a separate form for attachments, couldn't you use the permissions on the field to control the R/W access to it (i.e. allow Submitter only)? Or perhaps only allow write access to the field from a Submit window. Rick On 12/13/07, FRANK, GORDON CTR DISA JSSC [EMAIL PROTECTED] wrote: Classification: UNCLASSIFIED Caveats: NONE You can't use a Change Display action, but you might be able to use an error Filter with the syntax: TR.Attachment field != DB.Attachment field I haven't tried it but I'll bet you can. Let me know. Gordon M. Frank DISA\Version FNS -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Thursday, December 13, 2007 12:42 PM To: arslist@ARSLIST.ORG Subject: Can An Attachment Field Be Made Read Only? ** I have an attachment field on a form. Once a file is attached I want to prevent anyone from changing or deleting the attachment. I would like them to be able to view the attached file. I thought this would be simple using the Change Field action and making it Read Only. Unfortunately that option is not available for that type of field. I know I can hide the field but I would prefer if it was made read only. Is this possible? Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com http://www.Scholastic.com http://www.Scholastic.com __20060125___This posting was submitted with HTML in it___ Classification
Re: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED)
Scratch that last message. I am working on a separate display-only form for all attachments. On regular forms there doesn't seem to be an option to create a display-only attachment field. However... you can still use the same method of doing a Set Fields into another attachment field. This second attachment field would be set to $NULL $ either when saving or in the active-link (after the PERFORM-ACTION-OPEN-ATTACHMENT command). Because the user is really opening a copy of the file the original file remains intact. Stephen Remedy Skilled Professional 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 field on the form display-only (probably not)? Try this, when the user clicks the button do a Set Fields from the regular attachment field to a hidden display-only attachment field. Then run the PERFORM-ACTION-OPEN-ATTACHMENT command. This way it should be impossible for anything to get written . Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Thursday, December 13, 2007 2:23 PM To: arslist@ARSLIST.ORG Subject: Re: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED) I changed the action to PERFORM-ACTION-SAVE-ATTACHMENT FieldID and that will work but I would rather have them be able to view the attachment directly. From: Sokol, Brian Sent: Thursday, December 13, 2007 2:14 PM To: arslist@ARSLIST.ORG Subject: RE: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED) Hi Stephen, I just tried your approach and I am hoping I did something wrong because this would be a perfect solution. When I click on the button I run an AL with a Run Process action. It performs the following: PERFORM-ACTION-OPEN-ATTACHMENT FieldID This opens the file fine but if I modify the file and save it, the changes are written back to the attachment file. Brian From: Action Request System discussion list(ARSList) [mailto:[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 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. Unhide a button next to this character field that, when clicked, opens the attachment. This allows the user to open, print, save a local copy, but does not allow them to make any changes to the attachment or remove the attachment from the record. In the above example, only the presence of an attachment will trigger your workflow to make it read-only. You probably would want to add a condition that will not make the attachment read-only if the user is part of a certain group, ie. 'App-Administrator'. This will provide the ability for certain users to have access to remove or update an attachment. Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Thursday, December 13, 2007 1:30 PM To: arslist@ARSLIST.ORG Subject: Re: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED) I don't want the submitter to be able to change it once he or she attaches it to the form. I had thought of using a separate form but I am not sure that would prevent the submitter from changing it as well. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Thursday, December 13, 2007 1:09 PM To: arslist@ARSLIST.ORG Subject: Re: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED) ** Well, even assuming that you didn't want to build a separate form for attachments, couldn't you use the permissions on the field to control the R/W access to it (i.e. allow Submitter only)? Or perhaps only allow write access to the field from a Submit window. Rick On 12/13/07, FRANK, GORDON CTR DISA JSSC [EMAIL PROTECTED] wrote: Classification: UNCLASSIFIED Caveats: NONE You can't use a Change Display action, but you might be able to use an error Filter with the syntax: TR.Attachment field != DB.Attachment field I haven't tried it but I'll bet you can. Let me know. Gordon M. Frank DISA\Version FNS -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL
Re: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED)
I do that here but with a Set Fields from another form. Try this: perform the Set Fields from the same form by '1' = $1$ This should cause Remedy to retrieve the file from the server. Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Thursday, December 13, 2007 3:35 PM To: arslist@ARSLIST.ORG Subject: Re: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED) Looks like you can not use a Set Field to copy from one attachment field to the other. Any other ideas? From: Sokol, Brian Sent: Thursday, December 13, 2007 3:16 PM To: arslist@ARSLIST.ORG Subject: RE: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED) Ok tried this -when I click on the button I do a Set Field from the protected Attachment field to it's copy. I then do a PERFORM-ACTION-OPEN-ATTACHMENT command on the 2nd attachment field. When i try this I get the following error; An invalid argument was encountered. It looks like the set field fails to copy the attachment . 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 working on a separate display-only form for all attachments. On regular forms there doesn't seem to be an option to create a display-only attachment field. However... you can still use the same method of doing a Set Fields into another attachment field. This second attachment field would be set to $NULL $ either when saving or in the active-link (after the PERFORM-ACTION-OPEN-ATTACHMENT command). Because the user is really opening a copy of the file the original file remains intact. Stephen Remedy Skilled Professional 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 field on the form display-only (probably not)? Try this, when the user clicks the button do a Set Fields from the regular attachment field to a hidden display-only attachment field. Then run the PERFORM-ACTION-OPEN-ATTACHMENT command. This way it should be impossible for anything to get written . Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Thursday, December 13, 2007 2:23 PM To: arslist@ARSLIST.ORG Subject: Re: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED) I changed the action to PERFORM-ACTION-SAVE-ATTACHMENT FieldID and that will work but I would rather have them be able to view the attachment directly. From: Sokol, Brian Sent: Thursday, December 13, 2007 2:14 PM To: arslist@ARSLIST.ORG Subject: RE: Can An Attachment Field Be Made Read Only? (UNCLASSIFIED) Hi Stephen, I just tried your approach and I am hoping I did something wrong because this would be a perfect solution. When I click on the button I run an AL with a Run Process action. It performs the following: PERFORM-ACTION-OPEN-ATTACHMENT FieldID This opens the file fine but if I modify the file and save it, the changes are written back to the attachment file. Brian From: Action Request System discussion list(ARSList) [mailto:[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 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. Unhide a button next to this character field that, when clicked, opens the attachment. This allows the user to open, print, save a local copy, but does not allow them to make any changes to the attachment or remove the attachment from the record. In the above example, only the presence of an attachment will trigger your workflow to make it read-only. You probably would want to add a condition that will not make the attachment read-only if the user is part of a certain group, ie. 'App-Administrator'. This will provide the ability for certain users to have access to remove or update an attachment. Stephen Remedy Skilled Professional From: Action Request
Re: E-mail Submit from BlackBerry Device
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 writing my own apps. The apps were developed in ASP.Net using the ARS .Net APIs. There are other languages of the ARS APIs; I just am most comfortable with .Net. On a related note, I am presently developing three other apps that connect into non-ARS systems for managers to submit approvals on their BlackBerry. Once you create one BlackBerry/PDA app you will likely be asked to create many more :) Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mahan, Janet L [EQ] Sent: Friday, November 30, 2007 9:59 AM To: arslist@ARSLIST.ORG Subject: Re: E-mail Submit from BlackBerry Device I tried this from the list and thought it would include the previous post, sorry. What I am trying to find out how to do is, submit from a web page into Remedy. We have a Sybase database and are on version 6.0.1 of the Remedy server. We do not want to use the mid-tier to do this. I have not used the Remedy APIs, is that pretty easy to do? Janet Mahan Network Systems Administrator II EMBARQ Voice: 941-766-6199 | Wireless: 321-356-0128 | Fax: 941-766-6199 Email: [EMAIL PROTECTED] Voice | Data | Internet | Wireless | Entertainment This e-mail is the property of EMBARQ and may contain confidential and privileged material for the sole use of the intended recipient(s). Any review, use, distribution or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive for the recipient), please contact the sender and delete all copies of the message. -Original Message- From: Mahan, Janet L [EQ] Sent: Friday, November 30, 2007 9:42 AM To: [EMAIL PROTECTED] Cc: Mahan, Janet L [EQ] Subject: Re: E-mail Submit from BlackBerry Device So is this the best way to submit from a web page into Remedy? We have a homegrown application that users want to be able to submit entries into Remedy from an existing web interface. The ARS API is all we need? Where can I find documentation on that API? Thanks! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: On-the-fly permissions in Attachment field
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 choose to delete the attachment fields to free up space. Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jason Miller Sent: Wednesday, November 28, 2007 11:43 PM To: arslist@ARSLIST.ORG Subject: Re: On-the-fly permissions in Attachment field Another options is to use an attachments form and not use an attachment field directly on the form but a table that allows you to interact with the attachment record. Now the attachment has its own record you have complete control over the read/write security of the file using row level permissions and workflow. Stephen Heider created a attachments form and a utility that will add your attachments from the original form to the new attachments form (I don't remember if it deletes the attachment from the original form or just copies it). Check out the ARS_CreateAttachmentsForm application in the downloads section on http://arswiki.org/projects/dotnetutil. Jason -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Wednesday, November 28, 2007 2:58 PM To: arslist@ARSLIST.ORG Subject: Re: On-the-fly permissions in Attachment field Dwayne, I would think that a Join of A and B would be a better option than using read-only/read-write display properties of the client. ( That by the way: the display property is not a real security feature.) The join could inherit the Assignee from Form B as the Assignee for the join and the Assignee group could be granted change access to the field. ( Hope that makes sense. Hope that Helps) -- 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 Nov 28, 2007 3:05 PM, Dwayne Martin [EMAIL PROTECTED] wrote: Hello Everyone, We have a Form A with Attachment fields. Form B is a sub-file to Form A. We want anyone who is an Assignee in a Form B subfile entry, to be able to add/change/delete attachments in Form A. You could make an ordinary field read-only, then On Display, you could check to see if the User was in the subfile, and if so, make the field read-write. But I don't see any way of making Attachments read-only. Any suggestions? (ARS 7.1, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Export Form Data to Excel on Button Action
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 Windows) can simply do a Set Fields to pull it to the client. I use this here so web users can generate the same reports as the WUT users. Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Anesh A Kurian Sent: Tuesday, November 20, 2007 11:04 AM To: arslist@ARSLIST.ORG Subject: Re: Export Form Data to Excel on Button Action Hi listers, Thank you to all for their prompt reply, to my earlier posting on how to export data to excel. A key point I forgot to mention is that the application runs on web so many it leaves me with lesser options. I was exploring on DDE and OLE to my disappointment I found later that these are not supported over web. Then I switched to running a report using the Open Window action on an Active Link. But here too I face a problem that the user has to rename the file from filename.rep to filename.xls and do a save. Is there any way I can force it always to save with a .xls. I have seen a same posting on the same requirement. Hope to see some ideas. Thanks and regards, Anesh A Kurian __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Export Form Data to Excel on Button Action
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 the records you want to include in the report and concatenate the results into a 0-length display-only temp character field. In between each column insert a Tab character. You can get a tab character by using a single Set Fields SQL of SELECT CHAR(9) and storing the result into a temp field. The temp field can then be referenced in your Set Fields to your 0-length temp field while looping. The user would then open Excel and copy/paste the contents of the 0-length temp field into a new sheet. Because it is tab-delimited each field in the temp field will be placed in a separate column in the sheet. Note that as you are looping through the records you will need to replace any tab or return characters in the Remedy fields - because Excel will interpret these characters as column separators or new line characters. Another approach to this is to call a SQL function (that you create) which processes the records and returns a varchar value that contains the entire report. Calling a function has limitations. In SQL Server the varchar data type is limited to 8000 characters. If this is too limited then you could call a stored procedure (that you create) which processes the records in the format you want but instead of returning the text directly to your workflow it adds records to a temp SQL table which is used exclusively for reports. After this table is populated your workflow would then query this table (by a unique Id). In order for multiple users to create reports simultaneously a unique Id (ie. GUID) would need to be passed into your stored procedure (along with any report parameters (ie. data range, Category, Type, Item, Requester, etc.) These approaches will generate the text formatted for Excel. Now, to get the system to automatically create an Excel sheet with the report contents... Somehow you need to create a file that contains the report contents with the file extension of .txt. This is necessary otherwise Excel will try to convert numbers to numeric values and remove any leading zeros. You could create this file either from the client (active links) or at the server (filters). On the client you could loop through each line of the report and ECHO the results to a text file on the client's computer. I prefer the server approach for several reasons whereby, after populating the temp SQL table with report data, I run the bcp.exe (SQL Server) command line utility to query the table and create a text file on the server. The next command in the filter is to run a $PROCESS$ PERFORM-ACTION-ADD-ATTACHMENT to attach the text file to an attachment field. In order to get the client to request the report I PUSH a new record to a command form. The next command in the active link is a Set Fields using $LASTID$ to retrieve the attachment from the new record. Now we have the report in a text file on the client. The next step is to load Excel with this file... At some point before you generate reports (I do this when the main control panel is opened when the user logs in) you will need to set two Global character fields. The first is the full path to the %TMP% or %TEMP% environment variables. This folder is where the Remedy Windows User Tool stores the attachments when you Set Fields to an attachment field. The other Global field will store the full path to Excel.exe. There are multiple ways to obtain this value. *One option is via a free utility on ARS Wiki (dotnetutil) named WksInfo. With these two values set a temp field ($zTmp Char1$) to the value of $Global - Excel$ + + $Global - TMP$ + \ + $zTmp Attachment$ Then, use a run process command using the $zTmp Char1$ field. Note that if there are spaces in the folder names you will need to surround them with double-quotes. I prefer to use the 8.3 names for the folders because you don't need the additional double-quotes. That should create the file you want and the user will see a new Excel sheet just by clicking a button. To take this one step further, you could create the Excel file on the server and then use PERFORM-ACTION-ADD-ATTACHMENT to add the Excel sheet directly. This approach has the advantage of being able to email the report to the user, if you want. It also provides the ability to schedule these reports so that they are auto-generated every Monday morning (for example) and emailed to various users. HTH Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Anesh A Kurian Sent: Monday, November 19, 2007 7:30 AM To: arslist@ARSLIST.ORG Subject: Export Form
Re: Print Hardcopy Notifications?
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 those that match a certain condition. The computer will need to be logged in (and preferably locked) as the user for the separate email account. This computer would be logged in all the time. *If you don't have a spare computer available you could build a virtual WinXP computer using Virtual Server and have it running on some little-used server. If you don't want to automatically print email then you wouldn't need to create a Rule - just wait until someone asks you (or someone you designate to handle this process) to print the email. If you enjoy programming you could use the built-in Outlook VBA to make the emails do anything you want. Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Stonequist Sent: Monday, November 19, 2007 11:00 AM To: arslist@ARSLIST.ORG Subject: Print Hardcopy Notifications? Greetings List! We've setup a series of notifications for one of our customers. They are requesting that these notifications be printed manually as well when email isn't viable, yet have the print outs maintain the same look and feel as the emails. I saw in the OLE that there's several Print selections in the OLE Automation Control, but I have no idea how to use them. Does anyone know if these are what I'm looking for, and if so, where I can find more information about how to use them? Will this allow me to use the HTML Templates we have to email the printer? Or is there another way to go about this? HUGE THX!!! Shawn Stonequist EMNS, Inc. Remedy 6.03 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
OT: Flying
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: Where the Answers Are ÿØÿà JFIF ` ` ÿáExif II* ª ° Ì Ô ( 1 Ü 2 ì ?i ¤ ÿÿ¤ ¤ ¤ Canon Canon EOS DIGITAL REBEL XT ` ` Paint.NET v3.08 2007:11:10 11:37:24 ' Jr 0221 2 F N V ( ¸r ^ f 0100 3¿ Z «¼¢ n ¢ v ¢ Z 2007:11:10 11:37:24 2007:11:10 11:37:24 Ô¤ W j d F ÿÛ C 2%,%2,),852;K}QKEEKmsZ}µ¾»²¯¬ÈáÿóÈÔÿ׬¯úÿýÿÿÁðÿÿÛ C588KBKQQÿίÎÿÿÿÀ « ÿÄ ÿÄ µ } !1AQaq2¡#B±ÁRÑð$3br %'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚáâãäåæçèéêñòóôõö÷øùúÿÄ ÿÄ µ w !1AQaq2B¡±Á #3RðbrÑ $4á%ñ'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ¢£¤¥¦§¨©ª²³´µ¶·¸¹ºÂÃÄÅÆÇÈÉÊÒÓÔÕÖ×ØÙÚâãäåæçèéêòóôõö÷øùúÿÚ [EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@ E- RÑ@ E- ´Q@E- RÑ@ E- RÒPEPEPEPEPEPEPEP0¢( ¢( ¢( §F»Ü mOíBç©àP1ɽøü(n)[EMAIL PROTECTED])ËëQhL(¢ )h ( ¢ (Å- %´PRÑE %´PRSI@ IKE %´P©)[EMAIL PROTECTED]@ E- QE RÑ@ E- RÑ@E-J)h z±1ØW·nyÏAGÞÏãHT(íQR1¨ÍHÄ QJ(O õ¦Säì)HAE´ÀJ)h ([EMAIL PROTECTED])h¤ ¢( J )(¢ (¢E)¤ AES ¢( ¢( ¢( ¢( ¢) QE RÑ@ E- RÑ@ E- QE QE QE QE QE QE QE QE QE QE QE QE ´5ºn'[EMAIL PROTECTED] [EMAIL PROTECTED])ëIHaN^´¼hËJZ*ÄQE RÑ@ [EMAIL PROTECTED](¢ (¢ ))h ¢ J)h ¢ (¢ (¢ (¢ (¢ (¢ (¢ (¥ òà÷j¬9¬NÙ;~)1©Kÿ Ê»wcÇ#FM´P0æáqëH£$ëJhLmQTHQE- ([EMAIL PROTECTED]@ E- QE (¢4Pi)(¢ (¢ (¢ (¢ (¢ (¢ JZ( ¢ J)h ¥íE=©[EMAIL PROTECTED] SçéEÀ1ïIih¸XJ)h§qXJ)h.\Q.\{Ñw(¥Å% (¢ (¢ (¢ (¢ (¢vÔËË=J.*ÝÝ©¹BíÃæÓÓ3HE( cy$Óú%2©Ä¥¢`QE QE QK@ E(@ ¥£´ ¢bãI@ EP ¢( ¢((¥¢h¥4À))h ¢ J)h ¢( ¢( ¢( ¢( ¢( ¢( ¢(XsZkS#¨e8ȧFw ö l+õ¤¸âô´P0£ò¢ ´ÜüǧQ 3ïFh£ ~qF(ǽ yâ4qïF JÄc£·®iÓtTT\ DǸ¢aÜ.Åb5}Å8:âZ|[EMAIL PROTECTED])h)hÅ)i- -´ b J -! ÑE(¢ (¢ J)[EMAIL PROTECTED]@[EMAIL PROTECTED]@ E- RÑ@KQE% í¢Ñä¤dS¨¢Ã¸à`RQK..(Å.ãíG(\J)w{QèiXwòúÑê)XÑNÚi4 RâC?APÔóô oojWøn KA Pñ´TéH )ô ÓøÕ˸G®j¡«²¢ñ ¥ a=)ãúT Fp3Å0}Þi^´é{R (§7õ¤QCòx C3M¶;ZFË{ CFO OA vãêhÞßÞ4#¨¤ yýãN98 QÔ±®MPÆ1¦tõ¤^síNâ%ÝíFÿ jfhÏÒýÃÐѼzS*)Ü,;[EMAIL PROTECTED] ÑL´\VEDͪ{õ§p±=Í(Îp(¸XÒS4Õ(¢ (¥¢Z((¥¤ ( ( J)h ¢ (¢ (¢ (¢ JZ((¥¢Z((¥¢'Ö(w3íIE+I8ô¨L Û¬QVAr4R©Í#{ôÂ2*BÖAÇbeZ³:v¥Ö«W#ê~íHËVI©¨0Ùô©;~æ!~¸¤4i( 'µ/jAÉ£4 rSI Ph×mªj±©%9?Jb«1ùA4%MãU8§[EMAIL PROTECTED]©'[EMAIL PROTECTED])[EMAIL PROTECTED] 1Ó¥8)ERBi¦i PÑKE QE RÑ@ E- RÑ@ ¢ J)h ¢( ¢( ¢( ¢( ¢( ¤¥¢ZJ (¢ (¢ (¥¢ (¥Å %$êÛéOÚ}(*GjC!U$'ÒÔb*G(Å4®äÁèj$d²zÓ¨U ¸¨A$Õw°ðÕ})[EMAIL PROTECTED]@ÀqE¢Ôb¤Ú{ÓãvqqSJ qÓSBdF8óʦ9Ú w¤y°ÛTgÞW0'¹$ҨϨ¤³È5*)%pdbÝ}MH±*Ó -]® QFÑïKE+ÄÚ=èÀõ¥ÅX.ÑëFÏz\RÑ`¸Ýâaö§ÒEãvME´m4üRÑ`¹ñQ6[À«4Q`¹\.)àT¹4X.0/:b(´P!Æy¦`7êJ JZ( ( ( ( ( ¢ J)h ¢ J)h ¢( ¤¥¢Z((¥¢( ( )h ¡eòä_x÷ S¶àÕ/aY#Ê=»~Rr*£´ãkå} NйsëQçr6åéØÔ¦n-¶þ$SOpÎåà:ëVS%î´Ò%±ÊÑtqSQí}çn?:Nî#îú ¢Î\ç¡ö¡Ð@|¿iÑ(ßÏaFI?ZµÏSV/9'JâxZa¦ÀCÉ wö ô¥CBiJûpW´ÚiqóÖ²V8 ÔSiE;È\0 zÍâLaÆâG°¨¨l2xá,H2=éæ89Êîõn~ð8§xç§J¤ØÜRâbZ( £´P1 [EMAIL PROTECTED](¥¢F)iq@ ¢LPbRÑ@ F(¥J)Ø£n(Å;PB)æhÊ)M%0J-´(¢ (¢ (¢)h´RÑ@ E- RÑ@E-% QE ´PQKE %´b\Q@ EPâiA£)o1BÇ©¦Î¹°q¶¢;رùWIçýÎÌ{ú×7ÚÐévå)ÕáÐUÕåû£¼NvVw%ÎT)ÞÀR0äÑþø*z(öz¦ zU²En=©2Ôà2i£§Ö¤A ®=)´´U%*H½øÎ×Fq@ ujcMÜ6}¹ª 36 i®ÄÛ·Z¯Sb®5Wj;S¨¢¨¤¥¢ ZJ(h¤¥ ¥¢ Z(n)[EMAIL PROTECTED]( aEPEP1KE %%- RÑ@ E- ¢PQK1@
Re: Starting a new ID
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 discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Oyefeso, Bola Sent: Monday, November 05, 2007 11:41 AM To: arslist@ARSLIST.ORG Subject: Re: Starting a new ID Obviously, this has to be done at the database level. I am not the database administrator. Is there a way to do it on my end without contacting the administrator. Thanks. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, November 05, 2007 9:38 AM To: arslist@ARSLIST.ORG Subject: Re: Starting a new ID Bola, Find out the schema ID of that form, you will be able to find this from the table arschema.. Corresponding to that row in the arschema table, modify the nextid value to 1. Also make sure that you have deleted all related tickets in case you have related information stored in other tables. Reset those ID's as well. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Oyefeso, Bola Sent: Monday, November 05, 2007 9:33 AM To: arslist@ARSLIST.ORG Subject: Starting a new ID ** Hello everyone, I created some tickets on a new application that I am implementing tomorrow. I will be deleting all these tickets, but I want the user to begin with Case ID 001. Any quick idea on how to do this? Thanks all. Bola Oyefeso __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are image002.gif
Re: Opening a PDF from the MidTier
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, 2007 11:26 AM To: arslist@ARSLIST.ORG Subject: Re: Opening a PDF from the MidTier Thanks Carey, I just tried it but get the same exact results. The PDF in Firefox looks like this: 005086 0 n 005334 0 n 005561 0 n 008230 0 n 008328 0 n 011033 0 n 018108 0 n 018337 0 n 018521 0 n 000796 0 n trailer 7FAF49E0F79CE0D2C017FF7C94E3C35F582EF4B25F50364FB99AF1931835654A] startxref 0 %%EOF 56 0 objstream x b```a`` a`e`Pc g@ ~ +sL`bh T 韷? AD05 tY 5/q )^ a $ M : / 虳gdy```TRj `@ 0 [EMAIL PROTECTED] @Z ʕx ~h1 jjv`u X%` !4 ; 7 F . PJ30 R [EMAIL PROTECTED] ?~iF b0 3 endstream endobj 33 0 obj endobj 34 0 obj endobj 35 0 obj/ColorSpace/Font/ProcSet[/PDF/Text/ImageC/ImageI]/ExtGState endobj 36 0 obj endobj 37 0 obj[/ICCBased 49 0 R] endobj 38 0 obj[/Indexed 37 0 R 15 50 0 R] endobj 39 0 obj endobj 40 0 obj endobj 41 0 objstream H W n F} W #T./-R'm ^ 6* ` V K H ļ 왙sά_ Q } | t^. HXn 4알 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Friday, November 02, 2007 11:12 AM To: arslist@ARSLIST.ORG Subject: Re: Opening a PDF from the MidTier Brian, I use the Active link action PERFORM-ACTION-OPEN-URL and have not noticed any problems launching a PDF (also hosted on our Mid-Tier server) from a button. Maybe you can use a button instead of a Text object? -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Possible DST Issue
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. This only occurs for dates starting this last Sunday through this coming Sunday. The work-around is to set the date field to a tmp character field first, then pass the tmp character field to the SQL user defined function. HTH Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Thursday, November 01, 2007 5:09 PM To: arslist@ARSLIST.ORG Subject: Re: Possible DST Issue Wow! That's weird. Does that happen from the native client too? Just for information purposes - what if you save it on the mid tier and then view the record from the mid-tier? What is the date displayed as? Also if you save from the native client does it display it correctly on the mid-tier? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Suwanski, Ron Sent: Thursday, November 01, 2007 4:25 PM To: arslist@ARSLIST.ORG Subject: Re: Possible DST Issue ** Yes I saw it too.. but it was only for 11/1/2007. If you try 11/2/2007 it is fine.. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso Sent: Thursday, November 01, 2007 12:51 PM To: arslist@ARSLIST.ORG Subject: Possible DST Issue ** ARS 6.3 p20 Solairs\Sybase MidTier p20 Apache\TomCat TZ:EST Have a form with a date (not date time) field. User enters the date 11/01/2007. When they save the record the MidTier is changing the date to 10/31/2007. I was not able to find any way of setting 11/1/2007 in that field. Also, if I enter the date as 11/1/2007 4:00:00 PM it puts 11/0/2007 as the date. Anybody else seeing this scenario? Thank you Frank __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Replace function on a special character
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 Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jack Samson Sent: Wednesday, October 31, 2007 4:19 PM To: arslist@ARSLIST.ORG Subject: Re: Replace function on a special character Hi All, I am using ARS version 6.3 and am trying to perform a REPLACE() function using a filter. I have a few special characters that I can see using a hex editor and the editor gives me the hex equivalent. My question is how do I perform a replace on a special character? Thanks, Jackson Boo! Scare away worms, viruses and so much more! Try Windows Live OneCare! Try now! http://onecare.live.com/standard/en-us/purchase/trial.aspx?s_cid=wl_hot mailnews __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Creating objectdatasource in asp.net
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.GetListEntryWithFields Method (String, String, Int32[], UInt32, UInt32, Int32, ArrayList, String, Boolean, String[], Type[]) Get the list of entries with values for specified fields. Also gets the number of matches. Allows for retrieving the results in specified sort order. Also allows for specifyinig the vui name to use to translate field labels (expressed in the qualifications) to field ids, and the whether to consider the locale. public DataTable ms-help://MS.NETFrameworkSDKv1.1/cpref/html/frlrfSystemDataDataTableCla ssTopic.htm GetListEntryWithFields( string ms-help://MS.NETFrameworkSDKv1.1/cpref/html/frlrfSystemStringClassTopic .htm formName, string ms-help://MS.NETFrameworkSDKv1.1/cpref/html/frlrfSystemStringClassTopic .htm qualification, int[] ms-help://MS.NETFrameworkSDKv1.1/cpref/html/frlrfSystemInt32ClassTopic. htm fieldIdList, uint ms-help://MS.NETFrameworkSDKv1.1/cpref/html/frlrfSystemUInt32ClassTopic .htm firstRetrieve, uint ms-help://MS.NETFrameworkSDKv1.1/cpref/html/frlrfSystemUInt32ClassTopic .htm maxRetrieve, out int ms-help://MS.NETFrameworkSDKv1.1/cpref/html/frlrfSystemInt32ClassTopic. htm numMatches, ArrayList ms-help://MS.NETFrameworkSDKv1.1/cpref/html/frlrfSystemCollectionsArray ListClassTopic.htm sortInfoList, string ms-help://MS.NETFrameworkSDKv1.1/cpref/html/frlrfSystemStringClassTopic .htm vuiName, bool ms-help://MS.NETFrameworkSDKv1.1/cpref/html/frlrfSystemBooleanClassTopi c.htm useLocale, string[] ms-help://MS.NETFrameworkSDKv1.1/cpref/html/frlrfSystemStringClassTopic .htm colNames, Type[] ms-help://MS.NETFrameworkSDKv1.1/cpref/html/frlrfSystemTypeClassTopic.h tm colTypes ); HTH Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rem Valenzuela Sent: Thursday, October 25, 2007 11:20 AM To: arslist@ARSLIST.ORG Subject: Creating objectdatasource in asp.net Hi All, I am familiar with how to connect using asp/vbscript to access remedy and update/retrieve data using the API. I am not familiar with creating a objectdatasource in asp.net 2005 and using a datagrid to view data (not necessarily to update it). Has anyone done this successfully? If so, How? I'm using API v7.1, ASP.NET 2005, ARServer is 6.3 patch 20. Not sure that matters, but there it is. Thanks. Boo! Scare away worms, viruses and so much more! Try Windows Live OneCare! Try now! http://onecare.live.com/standard/en-us/purchase/trial.aspx?s_cid=wl_hot mailnews __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Phones at RUG - OT: Free Directory Assistance
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 Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Doug Blair Sent: Wednesday, October 17, 2007 1:36 PM To: arslist@ARSLIST.ORG Subject: Re: Phones at RUG Stan et al, My Sprint rep says that price expired on October 8, and the minute rate is now 30 cents (US). That's still better than 59 cents. Time for me to remember my Skype user name :-). That should be under 50 cents an hour. ___ Doug Blair Remedy Skilled Professional dougatblairingdotcom +1-224-558-5462 .. Original Message ... On Mon, 15 Oct 2007 12:16:02 -0700 Stan Feinstein [EMAIL PROTECTED] wrote: Hi, For those with Sprint PCS, I just added the Canada roaming option for $2.99 per month. The per minute cost is $.20. Stan Feinstein Project Remedies Inc. www.pri-us.com - Original Message - From: Mac Rhoades [EMAIL PROTECTED] Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Monday, October 15, 2007 10:33: AM Subject: Re: Phones at RUG All, Just an update for those interested. I went to an ATT store, got the package for $3.99 and 0.59 per minute and will drop it as soon as the bill comes in (that was actually recommended by the store clerk). Mac Rhoades Sr. Remedy Developer IT Application Development DataPath, Inc. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Seth Wrye Sent: Wednesday, October 10, 2007 11:00 AM To: arslist@ARSLIST.ORG Subject: Re: Phones at RUG Thanks for the heads up. Just checked with ATT and their rate is 0.79 per min and you can add a package for 5.99 and it will drop the rate to 0.59 per min. Seth From: Action Request System discussion list(ARSList) on behalf of Rick Cook Sent: Tue 10/9/2007 5:58 PM To: arslist@ARSLIST.ORG Subject: Phones at RUG ** Just a heads-up for those of you from the States who plan to do lots of cell calling while in Vancooover. While you won't have a problem with coverage, you might ask your cellular provider about some sort of different package (I know that Verizon offers one) that includes Canada, for a higher flat rate that will be cheaper than even a relatively small number of roaming minutes (at $0.50~ per). Voice of experience on this one... -- Rick Cook __20060125___This posting was submitted with HTML in it___ ___ _ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are Disclaimer for DataPath This electronic message, together with any attachments, is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is privileged or confidential and is the intellectual property of the sender. If you are not the named addressee, you are expressly prohibited from reading, printing, retaining, copying, distributing or disseminating this message or any part of it or any attachments or any information contained therein. Doing so may be actionable under state or federal laws. If you have received this message in error, please notify the sender immediately either by phone (866-855-3800) or reply to this e-mail and immediately delete all copies of this message and any attachments. All electronic messages and attachments sent and received are subject to monitoring, reading and archival by DataPath. The recipient of this electronic message is responsible for ensuring that it and any attachments are free from viruses or other software or defects that may affect any computer system into which it is received or opened. DataPath accepts no responsibility for any damage that may arise from the receipt or use of this electronic message or any attachments. ___ 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: How to pass Date/Time varible to SQLstatement
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 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bao, Hui-Qing Sent: Tuesday, October 09, 2007 1:47 PM To: arslist@ARSLIST.ORG Subject: How to pass Date/Time varible to SQLstatement Hello All, I have a SQL statement in Set Field action, and I have to pass a Date/Time variable ($Start Date1$) to the query: Select sum(C901001003-C901001002) from T255 Where C3 $Start Date1$ I got incorrect syntax error. The sql statement looks like this the database log: Select sum(C901001003-C901001002) from T255 Where C3 10/7/2007 12:00:00 AM I know Remedy store Date/Time as integer in the database (by the way, we are using MS SQL 2000), I wonder if there is any function I can use to convert Date/Time to Int before I can pass the variable to the query??? I tried server side table loop to perform the same task, but since the table is huge (couple hundreds thousands of records) always get time out, so I figure I have to use direct SQL. I opened a ticket with BMC last week, they just sent me the pdf of DatebaseRefGuide. Please help!! Hui __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARSlist Awards all but software categories over the line
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 but software categories over the line We have enough votes for BMC Remedy Beyond the Call of Duty and the ARSlist MVP Awards. This doesn't mean you should stop voting. so far we are at best ½ way to the 50 votes required for any of the software categories. Surprising since we easily did that last year. Also, perhaps the 15 people that have voted for Axton and Matt would like to try again? Excellent candidates indeed, but not eligible or nominated this year. Also a reminder to thank the current sponsors of the ARSlist: www.Kifinti.com http://www.kifinti.com/ and Daniel Bloom Consulting Inc. and www.wwrug.org http://www.wwrug.org/ Happy Thanksgiving Weekend! (might as well start getting used to the Canadian way of things :-), start practicing your moose calls for UserWorld ) ... Daniel Bloom p.s. coming soon: the annual questionnaire about who will be at BMC UserWorld location will be posted on Tuesday morning __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are image001.jpg
OT: BMC Whitepaper - Accelerating Problem Resolution in .NET Applications and Web Services
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=291770promo =605tag=nl.e605cval=wit2ctype=default Stephen Remedy Skilled Professional ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Filter Problem
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 action items inside the filters can and do perform additional queries of the database. Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Thursday, October 04, 2007 12:43 PM To: arslist@ARSLIST.ORG Subject: Re: Filter Problem A flaw, maybe. The solutions I see to address this would be some type of record locking to prevent updates based on stale data. I guess there could be a couple of approaches to this: - return an error if you attempt to update and the data you are using for the update is stale - disallow the retrieval of records for update if someone else has a lock - return a note that the record was updated by another user One has to weigh the consequences of implementing something to address this behavior against the consequences of not implementing something to address it. The third, obviously, is what is currently implemented. I have to correct myself on one item. It appears Misi was right that the entire record is fetched during each ARSetEntry call. Ah well, something changed when I wasn't looking. Axton Grams On 10/4/07, Joe D'Souza [EMAIL PROTECTED] wrote: ** That's what I thought that it should perform a fetch for DB values too. The DB value could be changed by another user after the initial fetch of the record, hence what displays on the client tool after the initial fetch of the record, may not represent the true DB value. I wonder though what would happen if lets say the value of a field is XYZ. User 1 opens the record.. At about the same time User 2 opens the same record, and changes the value of XYZ to abc and performs the save. User 1 then changes what he sees on his screen XYZ to abc. Considering that the DB value now is already abc due to the change done earlier by User 2, would the TR value now be NULL? Or would it be abc? From your conclusion based on the SQL logs that TR doesn't perform a fetch, the system would not know that the value has changed. Isn't that a flaw in the design? Joe D'Souza -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Misi Mladoniczky Sent: Thursday, October 04, 2007 6:31 AM To: arslist@ARSLIST.ORG Subject: Re: Filter Problem Hi, You are correct in the assumption that TR-values can save a little bit on performance. The server looks through the run-if-qualification of all filters. If anywhere there is a 'Field' or 'DB.Field', the server will need fetch these values from the database. And the values of all other fields of the form as well! If you only have 'TR.Field', static values or keywords. This fetch is not needed. Note that my test form has a lot of fields, and only two filters. One is disabled and one is enabled in the samples below: ('TR.Assigned To' != $NULL$) http://www.rrr.se/tmp/TestAssignedToTR.html ('Assigned To' != 'DB.Assigned To' AND 'Assigned To' != $NULL$) http://www.rrr.se/tmp/TestAssignedToDB.html All fields will be fetched as soon as you have one 'Field' or 'DB.Field' in your filters, so adding fields will do nothing to performance. I have noticed this behaviour in previous versions. The verion I am testing is version 7.0.1 patch 003. I think that the TR-values can have a legitimate use sometimes. Either for the reason of performance, or the reason of simplifying your run-ifs: Example 1: ('TR.CustID' != $NULL$) Your filter makes sure that the CustName is in sync with your CustID. It does not matter much if this filter sometimes run when it is not really neccessary. Example 2: ('TR.Assigned To' != $NULL$ AND 'TR.Assigned To' != $USER$) Your filter sends a notification to the assigned person. If the field has not really been changed, an extra notification is sent, but does no real damage. Example 3: ('TR.Status' != $NULL$) Your filter controls something or other connected with the status. Extra controls may happen, but does not affect things much. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. While the TR is confusing isn't there a performance benefit? If I remember correctly a TR check will not run a query against the database (I haven't actually logged it to verify). Say you run a daily import of 500k employees (the requirement is to do it
Re: Splitting of a string
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 return. Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ferreira, Frans F Sent: Monday, October 01, 2007 3:14 AM To: arslist@ARSLIST.ORG Subject: Splitting of a string Hi All I need to split the following string: vimals;appadmin;rianaj a filter must use the first logon id vimals and then appadmin and then rianaj etc. therefore it must split the string on ; I want to pass it to the E-Mail engine, which uses Hard returns to send a message to a list of people as per Email engine 700 documentation page 89 To specify one or more recipients, enter any of the following choices separated by hard returns (the server evaluates each line separately) in the User Name field: _ AR System user logins _ AR System groups _ Direct email addresses Any suggestions will be of great help. Regards Frans Ferreira Senior Technical Consultant African Legend Indigo Tel +27118086300 Mobile +27836263674 Fax +27118020797 Web www.alindigo.com BLOCKED::BLOCKED::http://www.alindigo.com __ Standard Bank Disclaimer and Confidentiality Note This e-mail, its attachments and any rights attaching hereto are, unless the context clearly indicates otherwise, the property of Standard Bank Group Limited and/or its subsidiaries (the Group). It is confidential, private and intended for the addressee only. Should you not be the addressee and receive this e-mail by mistake, kindly notify the sender, and delete this e-mail, immediately and do not disclose or use same in any manner whatsoever. Views and opinions expressed in this e-mail are those of the sender unless clearly stated as those of the Group. The Group accepts no liability whatsoever for any loss or damages whatsoever and howsoever incurred, or suffered, resulting, or arising, from the use of this email or its attachments. The Group does not warrant the integrity of this e-mail nor that it is free of errors, viruses, interception or interference. Licensed divisions of the Standard Bank Group are authorised financial services providers in terms of the Financial Advisory and Intermediary Services Act, No 37 of 2002 (FAIS). For information about the Standard Bank Group Limited visit our website http://www.standardbank.co.za __ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
OT: Office 2003 SP3
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 now prevents the images from being displayed. I have to right-click and instruct Outlook to trust the Sender (and also tried the Domain). This is for every email message even though the Sender and the Domain are the same for each email. When I exit Outlook and re-open Outlooks forgets the settings and I have to right-click and tell Outlook to trust the sender and domain. Has this happened to anyone else? Any work-around? SP3 is so new there is little info on google or microsoft. Stephen Remedy Skilled Professional ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Is it possible to fetch the database id
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 JOIN [field] b ON a.SchemaID = b.SchemaID WHERE a.[name] = @FormName ANDb.FieldName = @FieldName) END In your workflow, issue a Set Fields SQL command like this: SELECT dbo.udf_GetFieldId('CHG:Change', 'Test Plan') HTH Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Deepti Sent: Thursday, September 27, 2007 4:06 AM To: arslist@ARSLIST.ORG Subject: Is it possible to fetch the database id ** Hi All Is it possible to fetch the selected attachment field's database id which is inside the attachment pool thro work flow which is inside the attachment pool thro work flow please let me know thanks dipti size=1 width=100% align=center Unlimited freedom, unlimited storage. Get it now http://in.rd.yahoo.com/tagline_mail_2/*http:/help.yahoo.com/l/in/yahoo/ mail/yahoomail/tools/tools-08.html/ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Making a field in the form as unique index that leardy has duplicate values.
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 OC-ALC/ITMA Sent: Tuesday, September 18, 2007 2:12 PM To: arslist@ARSLIST.ORG Subject: Re: Making a field in the form as unique index that leardy has duplicate values. I believe you must go in first and change/delete the tickets. The system will fail to build the index if there are duplicate values. I would suggest going on the database level to find the duplicate tickets. You can join the table with itself to find them. For instance, to find tickets that have duplicate values for 'Field1' you can use: Select record_id from table a, table b where a.record_id != b.record_id and a.field1 = b.field1 You may have to tweak the syntax a bit, but this should give you a list of all duplicate records. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: Tuesday, September 18, 2007 1:08 PM To: arslist@ARSLIST.ORG Subject: Making a field in the form as unique index that leardy has duplicate values. Hi: I have a form which already has data. I want to make a field value Unique in the form properties. Some of the records already have duplicate values for this field. Will the system delete these records or change the field values? Thanks Ravi ___ 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: Can a qualification be included in a Submit template
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 this here with approvals. When someone needs access to an application or server Remedy sends out a chain of approval emails. Each recipient selects either Approve or Deny with optional comments, and then clicks the Submit button (inside the email). The response is captured by an ASP.Net app that updates Remedy. Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shrestha, Manjari R. Sent: Friday, September 14, 2007 8:03 AM To: arslist@ARSLIST.ORG Subject: Can a qualification be included in a Submit template Hello List, I have a .Net application which sends an e-mail template once the Customers (who do not have access to remedy) complete the Survey to E-mail Engine. I am using a submit action in the template. Is there a way to put in a qualification in the submit template that will see if the Request ID for the ticket exists and if it does then only it will push in the values? Or is there a workflow I can create to get the same result. I asked the Support and they informed me that the submit action does not have any such capability. Right now the problem I am facing is, I am sending the Request ID for the ticket but if someone changes the Request ID, it will still submit the survey to the survey form, which is scary. Please advise. Thanks! Manjari __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Running into issues when using the Remedy .NET API script against ARS 7.01 / ITSM 7.02
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(pRemedyServer, pRemedyUID, pRemedyPWD, ) Call objArSystemPub.GenerateGUID() right after logging in to verify the login. If not successfully logged in, then it will generate an error. There are also several examples that may help on http://arswiki.org/projects/dotnetutil. Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Lammey, Peter A. Sent: Friday, September 14, 2007 8:43 AM To: arslist@ARSLIST.ORG Subject: Running into issues when using the Remedy .NET API script against ARS 7.01 / ITSM 7.02 We are in the process of developing and testing a .NET API script against our ARS 7.01 / ITSM 7.02 and some of the commands seem to work but when we run the script the command returns Error(623) Authentication failed error. When attempting this command: EntryId = objARSystem.CreateEntry(pRemedySchema, FieldValues) Here are all the versions of the Remedy .NET API and the programs that we are using: BMC.arnettoc.dll7.0.0.0 BMC.ARSystem.dll7.0.2391.24945 Visual Basic .NET 2005 Windows Server 2003 However we can successfully connect with the following string: Call objArSystemPub.Login(pRemedyServer, pRemedyUID, pRemedyPWD, ) Call objArSystemPub.SetServerPort(Microsoft.VisualBasic.Conversion.Int(pRemed yPort), Microsoft.VisualBasic.Conversion.Int(pRemedyRPCProgramNum)) Is there is any .NET API expertise out there that can help us with this? Our Remedy AR System is version 7.01 patch 002 and our ITSM version is 7.02 patch 005. Thanks Peter Lammey ESPN MIT Technical Services Applications Management 860-766-4761 __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Push field sometimes happens and sometimes doesn't
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 unique code. This code appears on all html emails in a tiny font at the bottom of the email. If a user has a question as to why they received a particular email, the code allows me to rapidly track down what process (ie. ARS object) initiated the notification. For those few notifications where the code should not appear I include it as hidden text within the html email. If I need to see it I select View Source in the email to see the html code. HTH Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Thursday, September 13, 2007 1:35 PM To: arslist@ARSLIST.ORG Subject: Re: Push field sometimes happens and sometimes doesn't Dwayne, I actually prefer a slight variation on the archive form approach IMHO, the root problem is that you want to keep a parent child relationship in a diary field content. I suggest that you let go of the v3 and v4 thinking and use a table field to the child records. Instead of having AR System Email Messages have custom workflow/fields start with the creation of the child record and then have the child record create a record in AR System Email Messages. ( The more we can leave the BMC generated/maintained forms unchanged, the better IMO. ) What this does is effectively what your after. There is no way that the person gets the email without a record in the child form. The support agents have a table field showing the whole (or parts) of the email that was queued to be sent. You do not loose any kind of delivery or error messages that the other ordered approach would have given you either. You would need to use a Push action to do a Notify action, but that should really not be an issue. And your child form could even do a Notify action if you want it to. ( Well, if the templates your using can be supported from data stored in the child form. However, the child form would also allow you to publish [to Public] some fields that are private [non-Public] on the parent form too.) In short I think you already have the forms in place, I just think the data flow is in the wrong direction between a few of the forms. :) HTH. -- 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 9/13/07, Dwayne Martin [EMAIL PROTECTED] wrote: Doug, Thanks! I can see some advantages of your approach over mine. I'll have to consider it. Dwayne Original message Date: Thu, 13 Sep 2007 09:21:15 -0400 From: Tanner, Doug [EMAIL PROTECTED] Subject: Re: Push field sometimes happens and sometimes doesn't To: arslist@ARSLIST.ORG ** Dwayne, An approach I like to take is 1) Create a form for historical storage of email messages I do this by creating a form called CMN:Email Correspondence This form has a lot of the fields - To, From, Subject, Body, etc From AR System Email Messages In addition to other fields I use for workflow Basically On Submit (Or Modify - Your choice) ON AR Email Messages I push (Create) a Permanent record over in CMN:Email Correspondence Passing my GUID from the original Entry This way I can tie it together Typically in a table field on the request. Hit me off list if you want some more details Doug Dwayne Martin Computing Support James Madison University ___ 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: how to read the whole content of a drop-down menu
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 of active links loop through each email address the user entered in the $CC List$ field. Use a Set Fields command to search the new BannedEmailAddress form to see if the address is found. If found, then display a message to the user. To loop through each email address in the $CC List$ field test for the separator (space, comma, semi-colon, etc.) in the Run If qualification. Use a Set Fields with the LEFT() and STRSTR() functions to extract out a single email address to a temp field. For example, AL1 - Execution Order 1 Run If: blank If Action 1: Set Fields the value of $CC List$ to $zTmp Char1$ AL2 - Execution Order 2 Run If: 'zTmp Char 1' LIKE %,% If Action 1: Set Fields the value of RTRIM(LTRIM(LEFT($zTmp Char 1$, STRSTR($zTmp Char 1$, , to $zTmp Char 2$ If Action 2: Set Fields the value of RTRIM(LTRIM(SUBSTR($zTmp Char 1$, STRSTR($zTmp Char 1$, ,) + 1))) to $zTmp Char 1$ Else Action 1: Set Fields the value of RTRIM(LTRIM($zTmp Char 1$)) to $zTmp Char 2$ Else Action 2: Set Fields the value of $NULL$ to $zTmp Char 1$ AL3 - Execution Order 3 Run If: 'zTmp Char 2' If Action 1: Set Fields from the BannedEmailAddress form with 'Email Address' = $zTmp Char 2$ ...the Request ID of the matching BannedEmailAddress record is stored in $zTmp Char 3$ AL4 - Execution Order 4 Run If: 'zTmp Char 2' AND 'zTmp Char 3' != $NULL$ If Action 1: Message of Address $zTmp Char 2$ is banned. If Action 2: Goto 1000 AL5 - Execution Order 5 Run If: 'zTmp Char 1' != $NULL$ If Action 1: Goto 2 The above example uses the comma as the separator. You could use the REPLACE() function in AL1 to change spaces, semi-colons, etc into commas. HTH Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Serouche Rahimpour Sent: Thursday, September 06, 2007 3:26 AM To: arslist@ARSLIST.ORG Subject: Re: how to read the whole content of a drop-down menu Hi, sorry my concern lead everyone into confusion. So I'll try to explain my problem from scratch and in a simple way. I have a form let say A. In that form I have a character field called CC list. People can add logins in that field so each login corresponds to an email address. What I want to do is simply: do not allow people from putting in that field some logins. These later are mailing-lists. So I though I could put all these mailing-lists in a file and read from that file and compare with what is typed in. ... At this point I make it short because I tried different solutions either form myself or solutions given by you gentlemen of this list. ... Anyway, the problem I have at the end is my SET FIELD does not work if I use something like ((% + $CC list) + %) LIKE 'My Mailing-list' No matter if 'My Mailing-list' is stored as a file and red in a form through a menu. Or if 'My Mailing-list' is a form with for every mailing-list a record. Also no matter how I write the SET FIELD . i.e it also doesn't work if I write 'My Mailing-list' LIKE ((% + $CC list) + %) ... I hope I was clear enough. ... Any help/idea/suggestion will be very welcomed. ... I am about to try the solution given by Fred Grooms with 2 tempfields. ... Serouche Shellman, David wrote: Serouche, I think your original question may have lead all of us down a path that works but is becoming increasingly difficult. One of your recent statements has made me rethink your original question. If I understand correctly, you want folks to be able to populate a field from a menu but you don't want them to be able to type in to the field. Have you tried setting the Display Type on the field to Drop-Down List? This sets up the menu in a manner that prevents individuals from typing directly in the field. Dave ___ 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: No action on attachments
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: Thursday, September 06, 2007 10:03 AM To: arslist@ARSLIST.ORG Subject: Re: No action on attachments Forgot to mention that the push field action is on filter! Warm Regards, Nisha Ramtri Phone: +91 124 433 6098 Fax: +91 124 433 6500 From: RAMTRI, Nisha, IDC Sent: 06 September 2007 19:10 To: 'arslist@ARSLIST.ORG' Subject: No action on attachments Hello All, I have a file in an attachment pool in one form and now I need to push this file in an attachment pool to another form. I am currently writing a Push Field action to do the same. But unfortuntefly the file is not being pushed to the second pool. I am on ARS 6.3, Sybase. Can anyone throw up any ideas as to what I should check in this case. Thanks. Warm Regards, Nisha Ramtri *** The Royal Bank of Scotland plc. Registered in Scotland No 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. Authorised and regulated by the Financial Services Authority This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc does not accept responsibility for changes made to this message after it was sent. Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by The Royal Bank of Scotland plc in this regard and the recipient should carry out such virus and other checks as it considers appropriate. Visit our websites at: www.rbs.com www.rbs.com/gbm www.rbsgc.com *** __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Capture Computer Name USER is runing on
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 Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr OC-ALC/ITMA Sent: Tuesday, August 28, 2007 9:02 AM To: arslist@ARSLIST.ORG Subject: Re: Capture Computer Name USER is runing on I don't know of any keywords either, but you could fork a windows shell process like below: Set fields with the following: The Value for the set fields for an XP machine would be $PROCESS$ c:\windows\system32\cmd.exe /c hostname. The downside of this is you would need a different active link for each OS the machines might have, as with NT machines, the path the cmd.exe is different. So the run-if would need to be something like $OS$ = Windows XP. This may not be the best way to do it, so you might wait on other responses from the list. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Wilson, Bruce B Sent: Tuesday, August 28, 2007 7:46 AM To: arslist@ARSLIST.ORG Subject: Capture Computer Name USER is runing on ** I am using an active link on the home page firing on the Window Loaded event to check the $VERSION$ of the user's Windows client via a qualification. If the version is out-of-date, I execute a push-fields action to create/update a record in a regular form. The regular form has a filter on it that executes a Notify action, which sends me an email informing me the user needs to upgrade. The above is working fine. However, because my users can log in from many different workstations, I need to know the Computer Name they are running the Remedy User client on. Is there a way to capture this information? I don't see a Keyword that I can use... Thanks, Bruce Wilson CS Remedy Administrator Norfolk Southern Corporation __20060125___This posting was submitted with HTML in it___ ___ 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: Price and duration for Remedy RSP and RAC certification?
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 Stephen Remedy Administrator/Developer From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sharma, Tarun Sent: Monday, August 27, 2007 5:27 AM To: arslist@ARSLIST.ORG Subject: Price and duration for Remedy RSP and RAC certification? Hi, Please share if someone has an idea about the Total cost and Total duration required to do Remedy RAC and RSP certification. Also suggest what is basic knowledge required to attend these trainings. Regards, Tarun Sharma This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Attachment Pool - POSSIBLE VIRUS
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 at Great Lakes Higher Education Corporation and Affiliates Please pick up the package at the following Web address: https://securemail.glhec.org/ime?x=4-3606271-1830398-CYJSBUOUlang=en_US The package will expire on Sunday November 25, 2007 at 08:31:03 CST6 ... Need help picking up your package? * If the Web address above is highlighted, click on it to open a browser window. You will automatically be taken to the package. * If the Web address above is not highlighted, follow these steps: - Open a Web browser window. - Copy and paste the entire Web address into the location or address bar of the browser. - Press enter. ___ ___ 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: Remedy Skilled Professionals
...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 Skilled Professionals Me too. Marc Bowen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rootuja Ghatge Sent: Tuesday, July 31, 2007 1:12 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Skilled Professionals I'm an RSP. -Rootuja Ghatge From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Scott Ames Sent: Tuesday, July 31, 2007 8:01 AM To: arslist@ARSLIST.ORG Subject: Remedy Skilled Professionals ** How many Remedy Skilled Professionals are out there? __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ *** The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this email are subject to the terms and conditions expressed in the governing KPMG client engagement letter. *** __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Remedy Skilled Professionals
Ever since version 6.3 you are only able to shake one person's hand at one time. If you are shaking someone's hand you must release the grip prior to shaking another hand, otherwise this would be a handshake violation :) Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Durrant, Michael M. - ITSD Sent: Friday, August 24, 2007 3:18 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Skilled Professionals The new version of the secret handshake has a more customer-centric licensing system... And beware! As I understand, similar to other fraternal organizations, there are severe penalties for revealing the hand shake. I heard that they invalidate your table qualifications and delete field-dependent workflow just for thinking of talking about it. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gayford, Matthew C. Sent: Friday, August 24, 2007 1:08 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Skilled Professionals You have to buy separate licensing for it... Matthew C. Gayford Technology Research Development Information Technology Systems Division University of North Carolina Wilmington (910) 962-7177 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jarl Grøneng Sent: Friday, August 24, 2007 3:00 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Skilled Professionals ?? What secret handshake? - Jarl On 8/24/07, Rick Cook [EMAIL PROTECTED] wrote: ** Congratulations! Be sure to practice that secret handshake... Rick From: 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 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 Skilled Professionals Me too. Marc Bowen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rootuja Ghatge Sent: Tuesday, July 31, 2007 1:12 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Skilled Professionals I'm an RSP. -Rootuja Ghatge From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Scott Ames Sent: Tuesday, July 31, 2007 8:01 AM To: arslist@ARSLIST.ORG Subject: Remedy Skilled Professionals ** How many Remedy Skilled Professionals are out there? __20060125___This posting was submitted with HTML in it_20060125___This posting was submitted with HTML in it___ *** The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this email are subject to the terms and conditions expressed in the governing KPMG client engagement letter. *** __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ 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 The information contained in this email may be privileged, confidential or otherwise protected from disclosure. All persons are advised that they may face penalties under state and federal law for sharing this information with unauthorized individuals. If you received this email in error, please reply to the sender that you have received this information in error. Also, please delete this email after replying to the sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers
Re: WS2003 SP2
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 Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Wheeler, Dylan Sent: Monday, August 20, 2007 2:22 PM To: arslist@ARSLIST.ORG Subject: WS2003 SP2 Is anyone running SP2 for Windows Server 2003? Or anyone have problems with it? We are running 2003 with no service pack, ARS 6.3, IIS6 and we're having problems with a memory leak. The server guys want to install SP2 but I want to be sure we aren't going to break our production box :) Thanks - Dylan Wheeler Production Control Analyst Principal IT Operations Downey Savings Loan Association, F.A. Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] This message and any attachments are for the intended recipient(s) only and may contain privileged, confidential and/or proprietary information about Downey Savings or its customers, which Downey Savings does not intend to disclose to the public. If you received this message by mistake, please notify the sender by reply e-mail and delete the message and attachments. __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: AR System Developer Studio Wishlists
...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 16, 2007 9:45 AM To: arslist@ARSLIST.ORG Subject: Re: AR System Developer Studio Wishlists Hi All, Define an AL on WL with SET-CHANGE-FLAG 0 with 999 order The alternative is to remove SAVE button from the interface Best regards, Daniel -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Hicox Sent: Thursday, August 16, 2007 4:24 PM To: arslist@ARSLIST.ORG Subject: Re: AR System Developer Studio Wishlists I'd second that. I've had it happen many times where I open a form, and immediately, the save button unlocks, and if I close it, it asks me if I want to save changes, but I made no changes. Most of the time, I'm too chicken to save it. I'd LOVE to know what it thinks changed. -A On Aug 16, 2007, at 7:39 AM, Carey Matthew Black wrote: OH.. here is another idea that I have had many times before When you close an object window and you get that dialog object has not been saved. Save before closing? (Yes/No/Cancel) I would really like to see a 4th button that shows you What changed so that you can decide if you want to answer Yes, No, or Cancel. -- 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 8/14/07, Willem Nel [EMAIL PROTECTED] wrote: ** Since David admitted that we are going to be getting a new Admin Tool pretty soon, it must mean that they are already working on it. Now would probably be a good time to put together a wish list. Maybe someone involved in the product is watching the list and can pick out some of the stuff we want. Who knows, we might get lucky and actually get some of them as part of the replacement. Here's my wishlist: - Undo/Redo - Larger windows for editing the workflow - Multi-platform (Yes, I know this is probably never going to happen) - I want to be able to edit everything in one place. Groups and Users is part of the admin process, and should be editable in the administration tool. So, what's your wishes for the new tool? __ _ 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: FAQ for Customer enforced licensing model in AR System 7.1.00 part I
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 provide an affordable means for independent consultants, or developers who desire to learn other ARS products on their home computers, to acquire some type of limited license? For me, the 2000-record limit is fine. I can still learn to administer and develop with each of the OOB packages with small record sets. My employer has spent a good deal of money on ARS licenses and they are happy with the product. They won't however spend $10,000 to $20,000 per OOB package just so I can increase my development experience. I would be willing to spend $500 - $1000 per year out of my own pocket for a limited license to use all the ARS packages on my home (not office) computers. I am sure others would as well. This could be another revenue stream (albeit small) for BMC with probably no additional overhead for your company. I could purchase the license through a regular Remedy support provider. My $0.02. I hope a solution is forthcoming. Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Easter, David Sent: Friday, August 10, 2007 7:05 PM To: arslist@ARSLIST.ORG Subject: Re: FAQ for Customer enforced licensing model in AR System 7.1.00 part I I thought I would just put all my answers into one E-mail so that there aren't a bunch of separate threads flying around... Q: Will the unlicensed AR Server, which presently runs in Evaluation mode with 3 fixed licensed and a 2000-record limit per table, still be available with v7.1? Yes. Q: Will we (Remedy developers) now have the ability to run AR Server (in Evaluation mode) on our own personal computer with the other Remedy applications (Change, Asset, etc) without having to purchase licenses for the applications? 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. If somebody logs in that has a defined float license - but performs no actions that require a license (say submits their own record) - will a license usage be logged? License behavior has not change in AR System 7.1.00. Actions or situations that consume a license today will continue to consume a license in AR System 7.1.00. Only the need for keys has changed in AR System 7.1.00. If a license is consumed, it will be logged as such and appear in your usage report. One of the major troubles with MidTier is that it seems to generate different versions of HTML-Forms for each combination of user groups This has been updated in AR System 7.1.00 in pre-fetching. Each form is prefetched according to the set of permissions for that form and its fields. For example, if the administrator selects a form that has 75 fields, the entire form (all 75 fields plus workflow) is cached. As a user accesses the form, the Mid-Tier will only grant the user access to those fields and workflow objects that match the group permissions of that user - but the original form is not cached a second time as it is today. It's a bit more technical than this - but the general answer is it's better than in AR System 7.0.01. The final documentation will explain it better than I probably just did. ;-) you will be able to configure a ceiling for each license type, which is supposed to correspond to the number of licenses you've purchased. It is correct that administrators may still set a ceiling for each license type. What was done in keys previously is now controlled by the administrator. If the administrator chooses to set a maximum number of user licenses, for example, AR System will behave just like it does today. Licensing is not changing - only the need for keys. Note that the maximum does not have to correspond to the number of licenses you've purchased, although many administrators will find it most convenient to do so. This was detailed in the original FAQ. I would continue the argument that the recorded values are not accurate with the way the mid-tier handles floating licenses, e.g., not releasing the token when the user ends the session (i.e., closes the browser). This topic is a bit tangential to the changes made in AR System 7.1.00. The issue of the Mid-Tier not being able to recognize a session closing when the user does not logout properly is not addressed in this release - but the feedback from the customer base has been heard and BMC will look into the issue further in a future release. This was the #2 issue cited in the recently performed survey as a restriction for moving to a web-client only environment. Thanks for the feedback so
Re: AR System Developer Studio Wishlists
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 would be used for this one process so it wouldn't interfere with other escalations. This could be scheduled to run once a day, once an hour, etc. Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr OC-ALC/ITMA Sent: Wednesday, August 15, 2007 9:37 AM To: arslist@ARSLIST.ORG Subject: Re: AR System Developer Studio Wishlists Well, this might get hairy. I believe that whenever you save a form, that it saves each object on that form, which would then trigger the syncing of the search database for each of those objects, essentially syncing the entire form each time you saved it. Some how it needs to be transactional just like the saving of at ticket. This would also make the admin tool faster as well. Modifying a filter or active link would not have any extra impact. My biggest request would be for us to be able just to sync one form at a time, or multiple. Select a list of forms, or all forms with a given prefix just like whenever you go to View Forms list in the current admin tool you can choose all forms, selected forms (up to 10 I think), or forms by prefix. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Wednesday, August 15, 2007 7:24 AM To: arslist@ARSLIST.ORG Subject: Re: AR System Developer Studio Wishlists I think the performance impact would be negligible to keep the sync search database up to date real time. Think about it, you are updating or deleting maybe a dozen records each time you modify an object... It might add a bit of time to bulk updates. Axton Grams On 8/15/07, Rick Cook [EMAIL PROTECTED] wrote: Nice list, Matt. I would add one more to the third one - how about a tab in each workflow object that shows every container in which it resides? It would be nice to see whether an Active Link I'm looking at runs in a Guide, since there's no obvious marking (apart from clues like no firing condition) on those presently. And even if I know or suspect that an AL is in a Guide, it's a pain to figure out which one it's in. And on the Related Objects stuff - while I share your desire to keep it real time, without some restructured storage mechanisms for that data, the performance impact would make it not worth it. Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Tuesday, August 14, 2007 8:06 PM To: arslist@ARSLIST.ORG Subject: Re: AR System Developer Studio Wishlists How about they fix the stuff they already have? * Provide detailed, explanations for why each and every RFE is either: Accepted, Rejected or Deferred. * Keep the Search DB up to date without a Sync process. (one object at a time when the object is changed.) * Ability to add an object to a Packing List via a context menu in the Admin tool lists windows. (And also from the individual object windows) * Use the Related Workflow idea on all objects. (Like for menus, views) * Ability to search for (or better have pre-indexed) hard coded string values used in workflow. ( Qualifications, actions, etc...) * Improve the ability of the Admin Tool to actually update container windows when new objects are created, or when the Names are changed of any of the items in the container. * Integration to a server side Objects Source control system. (SVN would be great, but anything that is not platform specific and hopefully open sourced.) * provide packing lists for each and every application they sell. So that it is easy to get a list of everything that is OOB and to verify that all the right stuff was installed. * Improve the overall performance. Switching from action 1 to action 2 of an active link should not require the client to cache all fields on the form(s) involved every time the selected action is changed. However... if we are in dream mode * STOP using names as the unique identifier for an ARS object. An internal GUID would go a long way to making the whole development process easier. ( Change a name and move it to production and it should stomp on the old name of the object. ) * All ARS workflow should be runtime enabled. There should be no quality or setting that a workflow action can do that can not be data driven at runtime. * The ability to script and plugin a new action would be fantastic. (and a registry for these things on the server) * A local field registry so that instead of just adding a
Re: AR System Developer Studio Wishlists
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 date/time. A checksum might also provide the ability to track the Create Date as well as the Modified Date of objects. Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Wednesday, August 15, 2007 10:54 AM To: arslist@ARSLIST.ORG Subject: Re: AR System Developer Studio Wishlists A checksum that accompanies the gguid (generated based on the object properties and gguid) for the object would be nice as well. This could be used by things like upgrade installers to generate a list of objects that have been changed but retained the original gguid. App installers could then be aware of which objects to update and which ones to include in a report of exceptions. This would probably work very well for things like application patches, but still miss the target for full application upgrades. dreaming It would be nice to see BMC get into the practice of providing patches for the applications on a regular basis, in an automated way (not the import def X, arx Y, then def Z). The application versions could then be tags at patch level A, B, C. etc. The patch process could be an executable or arf plugin that simply retrieves a list of available patches from a BMC patch server, generates a list of the patches, then gives you the option of whether or not you want to apply one or all of the available patches. No more upgrades, just staying current with the patches. /dreaming Axton Grams On 8/15/07, Carey Matthew Black [EMAIL PROTECTED] wrote: David has the idea... but I will add a bit more to it since there appears to be some interest in the idea When an object is first created it would get its own GGUID (Guaranteed Global Unique ID) from the ARS server at that time and it would be unchangeable while the object exists on the ARS server. (Sure maybe you could do some funny stuff with a def/xml object file, but who would want to? Anyway..) And just to be clear.. .the GGUID should be part of the object and it would be retained if the object is moved from ARS server 1 to ARS Server 2 during an object Import process. So the value is only generated during _create_ time for the object. So a Save As... would produce a new object with a new GGUID. But a Save would not change the GGUID. If every object has a GGUID then it would be simple for application install verification to be automated to. ( Because it would become a list of GGUID's and a process to verify that all of them exist on the ARS server.) You could reaname the OOB object to Didnot use-Foo and the application verification stuff would still work. (Extra, or changed parts are ok. Missing parts are likely indications of problems.) And if you add one more layer to that... where the packing list/applications keep track of the verification list during object create/deletes then the OOB's would have a standard list and any customized OOB would have its own list. The lists could be compared and all missing OOB objects could be identified, and all new objects could be identified. Yes this stops short of a full Version control system, but it really should. All I want is identification of objects and not version control. However once identification is established then version control becomes much easier to tackle too. If every object has a GGUID then Source control systems would be able to deal with prod/dev/test systems in a sane way. And you could do things like diff objects that were renamed on dev/test/prod because the GGUID would tie them together. And I am sure there are other gains that can be made once you know that your looking at an object that was _created_ from server X. The GGUID's could be used like Request ID are used for data. They could be the pointers in the objects that point at each other. (Containers would not need names, they could use shorter, better indexes, less memory intensive values.) And just a bit of an idea about how the GGUID could be generated... How about a combination for the Support Contract ID and the Server key where the object was created. It could be encoded/encrypted so that it looks like garbage to us, but could actually tell BMC quite a bit about the source of the object if push came to shove. :) Heck it could even include the date/time that the object was created. ( It has always struck me as odd that objects do not have a Create date, but data records do.) -- 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 8/15/07, Shellman, David [EMAIL
Re: AR System Developer Studio Wishlists
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 then click back to Active Links, the Admin Tool displays the first active link which means I have to scroll back down to the 100th link. - The $ NULL$ keyword available as a button to insert into workflow (instead of having to select from a menu or typing it). I use this keyword far more than any other and I use it daily in my development. - Ability to right-click on a form and a popup menu appears allowing me to create a new Active Link, Filter, etc. and then that form is pre-selected in the new object. - An extension of the above item: Ability to assign to the form an object name prefix. When a new active link, filter, etc. is created this prefix will be auto-populated with the form's prefix. An example, right-click on a form named HPD:HelpDesk, select New Filter, and the new filter has the HPD:HelpDesk form selected with the Name of the filter auto-populated with HPD:HelpDesk- All but the 1st one should be relatively easy to implement. Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Willem Nel Sent: Tuesday, August 14, 2007 10:34 AM To: arslist@ARSLIST.ORG Subject: AR System Developer Studio Wishlists ** Since David admitted that we are going to be getting a new Admin Tool pretty soon, it must mean that they are already working on it. Now would probably be a good time to put together a wish list. Maybe someone involved in the product is watching the list and can pick out some of the stuff we want. Who knows, we might get lucky and actually get some of them as part of the replacement. Here's my wishlist: - Undo/Redo - Larger windows for editing the workflow - Multi-platform (Yes, I know this is probably never going to happen) - I want to be able to edit everything in one place. Groups and Users is part of the admin process, and should be editable in the administration tool. So, what's your wishes for the new tool? __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
OT: Favorite Freeware for Remedy Development
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 could add it to ARS Wiki for example. Here is a list of free programs (Windows) I use directly and indirectly with my development. I am sure there are more available. What do you use? Screen Capture ScreenHunter 5 Free http://wisdom-soft.com/products/screenhunter_free.htm Real-time Log File Viewer BareTail http://www.baremetalsoft.com/baretail/ Browser Cache Cleaner CCleaner http://www.ccleaner.com/ Streaming Video Recorder (you can mark a rectangle on your screen and it will record it - good for recording online training videos for reviewing later) CamStudio 2.0 http://www.camstudio.org/ .Net IDE SharpDevelop http://www.icsharpcode.net/OpenSource/SD/Default.aspx Resource Editor (used to remove splash screen or hide the B.C checkbox on Date fields) XN Resource Editor http://www.wilsonc.demon.co.uk/d10resourceeditor.htm PDF Assembler/Splitter MbtPDFAsm (with front-end GUI BeCyPDFAsm) http://thierry.schmit.free.fr/dev/mbtPdfAsm/enMbtPdfAsm2.html http://www.becyhome.de/download_eng.htm Hex Editor XVI32 http://www.chmaas.handshake.de/delphi/freeware/xvi32/xvi32.htm Other The free utilities at http://rrr.se http://rrr.se/ RTL - http://www.sourceforge.net/projects/rtl JOARSE - http://www.sourceforge.net/projects/joarse COARSE - http://www.sourceforge.net/projects/coarse Stephen ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
ARS Integration With RightNow
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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: FAQ for Customer enforced licensing model in AR System 7.1.00 part II
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 with 3 fixed licensed and a 2000-record limit per table, still be available with v7.1? Q: Will we (Remedy developers) now have the ability to run AR Server (in Evaluation mode) on our own personal computer with the other Remedy applications (Change, Asset, etc) without having to purchase licenses for the applications? These applications cost 10's of thousands of dollars, which places them completely out of reach of 99% of Remedy developers who want to learn more about your applications and increase their programming and administration knowledge and experience of Remedy products on a home computer. If the answer to both questions is 'Yes', then this will probably be the happiest Friday I have experienced :) Thank you. Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Easter, David Sent: Thursday, August 09, 2007 8:46 PM To: arslist@ARSLIST.ORG Subject: FAQ for Customer enforced licensing model in AR System 7.1.00 part II Q: How will BMC monitor my usage? A: BMC will not actively monitor your usage. BMC trusts its customers to self-report their usage and notify BMC or BMC partner when licenses are added or removed so that customer billing matches usage. Q: You mean no one from BMC will ever check on my usage? A: BMC reserves the right to audit any customer if it appears that a misuse of licenses has occurred. This would typically be initiated by the customer sales representative and would typically involve an interactive conversation with the customer to determine actual usage as compared to purchases. Q: Can I still request BMC to help me with my own self-audits? A: Yes. BMC will still assist those customers who wish to ensure that they are in compliance with their license contracts. Q: How will I know what I've purchased? A: BMC can, upon request, provide a reconciliation report that documents all purchases made. These purchases can then be compared to the usage report to determine compliance. We hope to provide this report in the future as a self-service option through Support Central. Q: I've written my own AR System application and want to make sure I get paid for licenses. How will I do that if there are no keys? A: While BMC does not require customer to submit their usage reports, partners or independent developers may make such requirements of their users. This would enable a partner or independent developer to audit a customer's usage remotely. Q: If I've written my own application, do I have to change anything to be able to use this new license key model on AR System 7.1.00? A: No. All license requests from the applications are unchanged. In other words, applications will still query the server to determine if an application is licensed and AR System will still return the answer in the same format as it currently uses. The only difference is that AR System will determine if there is a license without the need for a key. Q: What about my existing AR System Server? How will my licenses be converted to this new model? A: During an upgrade, AR System 7.1.00 will automatically convert an existing .lic file to the new model. In addition, after installation, the ability to import a previously created .lic file will be available within the Administration Console. Q: So it will update the .lic file? A: No. Licensing in AR System 7.1.00 is now kept within the database, not in a file. The .lic file will no longer be needed in AR System 7.1.00. Q: What about servergroups? How will they work if there's no .lic file anymore? A: Servergroups will all point to a common database - and thus each server in the group will have access to the same license information. It is no longer necessary to have unique licenses for floating users, for example, on each server. Q: So can I have multiple rows of user licenses per server like I had in my .lic file? A: There is no need for this anymore. Only one row per license type is needed and represents the maximum number of licenses for that type. For example, if you used to have rows within the .lic file that represented keys for 10, 15, and 30 users each; those rows would be collapsed into one row that had 55 user licenses defined. Q: But each server requires a unique key - so I need multiple rows for servers, right? A: Yes. Servers are unique rows, so you will see one row per server. However servers are the only license type that now requires multiple rows. Q: If I don't want to use an application anymore, how do I remove the license? A: The Administration Console still has the ability to delete any
Re: ARServer.exe crashing
Hey Rogerio, Did you find a solution for this? Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rogerio Sent: Monday, July 30, 2007 10:39 AM To: arslist@ARSLIST.ORG Subject: RES: ARServer.exe crashing I'll take a look on that. Thanks, Rogerio Bronzoni Aguiar CMagnani -Mensagem original- De: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Em nome de Heider, Stephen Enviada em: segunda-feira, 30 de julho de 2007 11:26 Para: arslist@ARSLIST.ORG Assunto: Re: ARServer.exe crashing Rogerio, After googling this http://www.google.com/search?q=0x0001bd02+ntdll.dllbtnG=Search (not many matches) I found one solution that might help http://www.svnforum.org/2017/viewtopic.php?p=9633sid=a8dd34e057a8dd4f1c 8f7131a76a1bf0 In the C:\WINDOWS\ServicePackFiles\i386 to change ntdll.dll for ntdll.old Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Monday, July 30, 2007 10:20 AM To: arslist@ARSLIST.ORG Subject: Re: ARServer.exe crashing Rogerio, I understand. I wish I had a better answer for you. Has Windows or SQL been updated recently (ie. security patches, service packs)? Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rogerio Sent: Monday, July 30, 2007 10:19 AM To: arslist@ARSLIST.ORG Subject: RES: ARServer.exe crashing Stephen, The fact that is not supported doesn't mean that doesn't work. We have used this configuration since a long time and the error appeared recently. Thanks, Rogerio Bronzoni Aguiar CMagnani -Mensagem original- De: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Em nome de Heider, Stephen Enviada em: segunda-feira, 30 de julho de 2007 11:10 Para: arslist@ARSLIST.ORG Assunto: Re: ARServer.exe crashing Rogerio, It may be due to SQL Server 2005 not being supported with v5.1.2. Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rogerio Sent: Monday, July 30, 2007 10:09 AM To: arslist@ARSLIST.ORG Subject: ARServer.exe crashing Hi everyone, Need some help. We are receiving this error randomly during the day: AR System Server Executable (SQL Server) encountered a problem and needed to close Then I see this in event viewer: Faulting application arserver.exe, version 5.1.2.0, faulting module ntdll.dll, version 5.2.3790.3959, fault address 0x0001bd02. Anyone have seen this before or have any idea about? Enviroment: ARS 5.1.2 - Windows 2003 SP2 - SQL Server 2005 Thanks, Rogerio Bronzoni Aguiar CMagnani ___ 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 ___ 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: ARERR [342] Cannot find/open the directory file: 0
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 run a process that removes the path and only leaves the filename. HTH To see how filenames are stored run a SQL command on the base table, for example: SELECT TOP 10 * FROM B611 where the primary table name is T611. Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Thursday, August 09, 2007 1:25 PM To: arslist@ARSLIST.ORG Subject: ARERR [342] Cannot find/open the directory file: 0 I'm trying to push an attachment field to another form (with the same Attachment Pool number and Attachment field number) via an Active Link. I can do this with a Filter no problem, but when trying to do it through an Active Link (via a push), I'm getting this error: ARERR [342] Cannot find/open the directory file: 0 I checked the ErrMsgsGuide for 6.3, but it really doesn't tell me much. We are on Server 6.3, User 7.0.1 Patch 003, Sun Solaris. Lisa ___ 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: Default attachment on New form
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 copies the file to the user's %TMP% folder (in WUT). Once on the user's computer you would use the above command to set it to the attachment field on the form. Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Moore, Chris Sent: Thursday, August 09, 2007 3:20 PM To: arslist@ARSLIST.ORG Subject: Default attachment on New form I've been asked to place a document on a custom form I've built on a 6.3 install. Basically, I would like to know if there is a way to have a default value added to an attachment field, so that the attachment is on the form when opened in New mode. ARS ITSM Customized 6.3 Oracle 10g RHEL server Thanks for any help! Chris Moore __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Default attachment on New form
...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 Heider, Stephen Sent: Thursday, August 09, 2007 3:29 PM To: arslist@ARSLIST.ORG Subject: Re: Default attachment on New form 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 copies the file to the user's %TMP% folder (in WUT). Once on the user's computer you would use the above command to set it to the attachment field on the form. Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Moore, Chris Sent: Thursday, August 09, 2007 3:20 PM To: arslist@ARSLIST.ORG Subject: Default attachment on New form I've been asked to place a document on a custom form I've built on a 6.3 install. Basically, I would like to know if there is a way to have a default value added to an attachment field, so that the attachment is on the form when opened in New mode. ARS ITSM Customized 6.3 Oracle 10g RHEL server Thanks for any help! Chris Moore __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Inserting pause in workflow
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: arslist@ARSLIST.ORG Subject: Re: Inserting pause in workflow Do the PROCESS inside of a Set Fields Action A Run Process action does not wait. A PROCESS inside of a Set Fields action waits for the external program to complete. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Thursday, August 09, 2007 3:23 PM To: arslist@ARSLIST.ORG Subject: Re: Inserting pause in workflow I could be mistaken about this, but I believe the way it works is, when Remedy runs an external process, it does NOT wait for the external process to finish executing before it continues workflow processing. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Thursday, August 09, 2007 3:05 PM To: arslist@ARSLIST.ORG Subject: Inserting pause in workflow Hello Everyone, (ARS 7.01 patch 2, Linux server, Oracle 10.2 db) How do you insert a pause in an active link or a filter? I have heard that you should run a process then call that process. So I have a pause program on our server that says sleep $1. On the server if I enter /opt/remedy/HelpDesk/pause 10 it waits ten seconds then returns the cursor. So I set up both an active link and a filter to do the pause 10 command then send a message. The active link does a Run Process of @@:/opt/remedy/HelpDesk/pause 10. The filter is the same but without the @@:. In both cases I get the message right away. The active link log shows: ACTL Process: /opt/remedy/HelpDesk/pause 10 ACTL Success The filter has a `! after it to make it run in phase 1, and the filter log shows it running before the message, but the message still appears right away. What am I doing wrong? Is there a better way of solving this altogether? It seems like pausing is such a normal thing to do that there should be a built-in Remedy function. Dwayne Martin Computing Support James Madison University ___ 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: Attachement Updation
Kathy, Here is one approach but it will take a little time to implement... create a separate form to store all of the attachments. On the tickets use either a table field to display the attachments linked to the ticket or a dialog. I use a dialog here. Users click a button and a popup is displayed. From this popup users [based on permissions] can add, view, save to disk or delete attachments. The 'delete' option does not really delete the attachment record but marks it as disabled. There is a checkbox on the screen to show 'deleted' attachments. Each attachment on this dialog displays the user and the timestamp of when they added it and/or deleted it. This approach preserves the attachments and tracks who did what when. Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kathy Morris Sent: Tuesday, August 07, 2007 9:48 PM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation This has been a SOX requirement for us. When a Change has been approved based upon certain conditions, we do not want someone modifying the attachments later. Get a sneak peek of the all-new AOL.com http://discover.aol.com/memed/aolcom30tour/?ncid=AOLAOF0002000982 . __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Multiple values from tiered menus
Michael, The way I do it here is to have the menu return the Entry Id of the menu option. Then with the Entry Id I query the source form to retrieve the Tier 1, 2, 3 options. I display those options in a separate read-only field. To the user, it looks like this: Category / Type / Item. Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Durrant, Michael M. - ITSD Sent: Tuesday, August 07, 2007 3:38 PM To: arslist@ARSLIST.ORG Subject: Multiple values from tiered menus I think I may have asked this already but I can't find the thread... Running ARS 7... Is is possible to get multiple values from a tiered menu selection? Example: User selects value from Tier 3 of a menu. I want to know which Tier 1 and Tier 2 values they chose to get there. The information contained in this email may be privileged, confidential or otherwise protected from disclosure. All persons are advised that they may face penalties under state and federal law for sharing this information with unauthorized individuals. If you received this email in error, please reply to the sender that you have received this information in error. Also, please delete this email after replying to the sender. __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
FW: Attachement Updation
How about converting everything to 3D, which then requires the red/blue glasses :) http://heuristicresearch.com/media/convertto3d.html Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Tuesday, August 07, 2007 4:21 PM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation FYI: As long as it is displayed on the screen a person can capture it to send it to the printer using Alt-PrintScreen. Fred, this is very true as well. They could also paste the capture screen into a Word Document. I might bring this up if they continue to make this an issue. Thanks! Lisa ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are image001.jpg
Re: OT: Attachement Updation - File Contents Changed
I agree. I would like to see this built in to ARS - obtaining the checksum is very simple in a compiled language such as C or .Net. This info should also be available on a display only form/field (eg. before it gets pushed back to the server). Along with checksums, the file size should be obtainable on a display only form/field. As it is now a file has to be pushed back to the server in a form to get the file size. In active links I would like to know if a file is too large [for the user, based on permissions] prior to pushing it back to the server. Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hugo Visser Sent: Friday, August 03, 2007 4:31 AM To: arslist@ARSLIST.ORG Subject: Re: OT: Attachement Updation - File Contents Changed ** Stephen, That's very clever, thanks for sharing :) Maybe BMC should put some kind of PERFORM-ACTION-FOOBAR to do this in a DB independent way. Hugo On 8/2/07, Heider, Stephen [EMAIL PROTECTED] wrote: ** Hugo, Your post got me thinking: How can you determine if the file contents have changed? I have wanted to create something like this for a while... so I just wrote this SQL Server 2000 function that returns the checksum of an attachment field (actually any field of Image data type. The current and new values could be compared to see if it changed. You can also use this to find duplicates in the attachment fields in your system. CREATE FUNCTION dbo.udf_GetImageChecksum ( @ImageField IMAGE ) RETURNS INT AS BEGIN DECLARE @Len BIGINT, @Pos BIGINT, @CheckSum VARCHAR(8000) SET @Len = DATALENGTH(@ImageField) SET @Pos = 1 SET @CheckSum = '' WHILE @Pos @Len BEGIN SET @CheckSum = @CheckSum + CONVERT(VARCHAR, BINARY_CHECKSUM(SUBSTRING(@ImageField, @Pos, 8000))) IF LEN(@CheckSum) 7900 SET @CheckSum = CONVERT(VARCHAR, CHECKSUM(@CheckSum)) SET @Pos = @Pos + 8000 END RETURN CHECKSUM(@CheckSum) END In a Set Fields SQL command: SELECT dbo.udf_GetImageChecksum(c536880912) FROM b611c536880912 WHERE entryId = 'ATTACH16929' HTH someone. Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hugo Visser Sent: Thursday, August 02, 2007 5:15 AM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation ** You cannot compare the file contents, but using TR you should be able to detect that a file was attached again (if the DB value wasn't $NULL$). The value contains the file size in bytes, the compressed size in the DB and the full filename on the client. Also note that user cannot change the attachment from the attachment field without re-attaching it. Just changing the attachment (open-edit-save) doesn't update the DB, it only updates the local temporary copy of the file. Hugo On 8/2/07, Meenakshinathan [EMAIL PROTECTED] wrote: Hi Robert, Thanks for the information. Anyhow this solution is not working. Remedy stores the attachments in the following way number of characters,no of bytes(i am sure. but it might bytes),filename with extenstion. I am not user this TR and DB can apply for attachement fields. can any one give me a alternative solution on this? Looking for your inputs. Thanks, Meenakshinathan On Jul 28, 2:36 am, Robert Halstead [EMAIL PROTECTED] wrote: I'm not entirely sure on this, but couldn't you do a filter on modify with a run-if condition as: 'TR.Attachment' != ' DB.Attachment' ?? I'm not entirely sure how remedy stores the attachments. It might work Anyone else ?? On 7/27/07, Meenakshinathan [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi Listers, In my application, at first stage users can attach 3-4 files. when the request assinged to next stage, that next stage user can edit or modify the attachment and can upload it again. In this stage my client has an requirement like, first stage user to be notified whenever any
Re: Attachement Updation - File Contents Changed
Shawn, There is a free utility available on ARS Wiki that will assist in setting up and populating an Attachments form like you describe - ARS_CreateAttachmentsForm. http://arswiki.org/projects/dotnetutil Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Stonequist Sent: Friday, August 03, 2007 8:19 AM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation - File Contents Changed ** Just a thought, but instead of attaching the files directly to the request you are on, what if it was a child form, with a Submit-Only, single field, attachment pool? This way, to upload a new attachment, a new child record has to be created, and you know who when did it. This would also keep historical records, you could compare the file at each and every stage/change that took place, or if you don't need this, you could simply delete the previous records. I've not worked through this completely, so I'm not sure what complications might arise (though, immediately I can think of the fact users will have to open the child record before they can get to the attachment) . HTH Shawn Stonequist EMNS, Inc. On 8/2/07, Meenakshinathan [EMAIL PROTECTED] wrote: Hi Robert, Thanks for the information. Anyhow this solution is not working. Remedy stores the attachments in the following way number of characters,no of bytes(i am sure. but it might bytes),filename with extenstion. I am not user this TR and DB can apply for attachement fields. can any one give me a alternative solution on this? Looking for your inputs. Thanks, Meenakshinathan On Jul 28, 2:36 am, Robert Halstead [EMAIL PROTECTED] wrote: I'm not entirely sure on this, but couldn't you do a filter on modify with a run-if condition as: 'TR.Attachment' != ' DB.Attachment' ?? I'm not entirely sure how remedy stores the attachments. It might work Anyone else ?? On 7/27/07, Meenakshinathan [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi Listers, In my application, at first stage users can attach 3-4 files. when the request assinged to next stage, that next stage user can edit or modify the attachment and can upload it again. In this stage my client has an requirement like, first stage user to be notified whenever any attachement is updated. If anybody came throrough this , can you please let me know how do i implement this? Thanks, Meenakshinathan ___- UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the Answers Are -- A fool acts, regardless; knowing well that he is wrong. The ignoramus acts on only what he knows, but all that he knows. The ignoramus may be saved, but the fool knows that he is doomed. Robert Halstead ___- UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
OT: Attachement Updation - File Contents Changed
Hugo, Your post got me thinking: How can you determine if the file contents have changed? I have wanted to create something like this for a while... so I just wrote this SQL Server 2000 function that returns the checksum of an attachment field (actually any field of Image data type. The current and new values could be compared to see if it changed. You can also use this to find duplicates in the attachment fields in your system. CREATE FUNCTION dbo.udf_GetImageChecksum ( @ImageField IMAGE ) RETURNS INT AS BEGIN DECLARE @Len BIGINT, @Pos BIGINT, @CheckSum VARCHAR(8000) SET @Len = DATALENGTH(@ImageField) SET @Pos = 1 SET @CheckSum = '' WHILE @Pos @Len BEGIN SET @CheckSum = @CheckSum + CONVERT(VARCHAR, BINARY_CHECKSUM(SUBSTRING(@ImageField, @Pos, 8000))) IF LEN(@CheckSum) 7900 SET @CheckSum = CONVERT(VARCHAR, CHECKSUM(@CheckSum)) SET @Pos = @Pos + 8000 END RETURN CHECKSUM(@CheckSum) END In a Set Fields SQL command: SELECT dbo.udf_GetImageChecksum(c536880912) FROM b611c536880912 WHERE entryId = 'ATTACH16929' HTH someone. Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hugo Visser Sent: Thursday, August 02, 2007 5:15 AM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation ** You cannot compare the file contents, but using TR you should be able to detect that a file was attached again (if the DB value wasn't $NULL$). The value contains the file size in bytes, the compressed size in the DB and the full filename on the client. Also note that user cannot change the attachment from the attachment field without re-attaching it. Just changing the attachment (open-edit-save) doesn't update the DB, it only updates the local temporary copy of the file. Hugo On 8/2/07, Meenakshinathan [EMAIL PROTECTED] wrote: Hi Robert, Thanks for the information. Anyhow this solution is not working. Remedy stores the attachments in the following way number of characters,no of bytes(i am sure. but it might bytes),filename with extenstion. I am not user this TR and DB can apply for attachement fields. can any one give me a alternative solution on this? Looking for your inputs. Thanks, Meenakshinathan On Jul 28, 2:36 am, Robert Halstead [EMAIL PROTECTED] wrote: I'm not entirely sure on this, but couldn't you do a filter on modify with a run-if condition as: 'TR.Attachment' != ' DB.Attachment' ?? I'm not entirely sure how remedy stores the attachments. It might work Anyone else ?? On 7/27/07, Meenakshinathan [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi Listers, In my application, at first stage users can attach 3-4 files. when the request assinged to next stage, that next stage user can edit or modify the attachment and can upload it again. In this stage my client has an requirement like, first stage user to be notified whenever any attachement is updated. If anybody came throrough this , can you please let me know how do i implement this? Thanks, Meenakshinathan ___- UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the Answers Are -- A fool acts, regardless; knowing well that he is wrong. The ignoramus acts on only what he knows, but all that he knows. The ignoramus may be saved, but the fool knows that he is doomed. Robert Halstead ___- UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
EIE 7.0.1 p5 Install
List, I am trying to install EIE 7.0.1 patch 5 and the installation program can not authenticate any Remedy user. I also tried removing the password for Demo. I disabled all external authentication (it was using LDAP) and restarted the services. No other ARS applications are installed, other than those that come with the base ARS Server package. Any ideas? Stephen Windows Server 2003 ARS 7.0.1 p3, using Port Mapper SQL Server 2005 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: EIE 7.0.1 p5 Install - SOLVED
Right. I disabled external auth before removing the Demo password. The cause: Min API Level. It was set to version 7 in the Admin Tool. I cleared it and restarted the services, then it worked. I wish BMC would address this issue of installers and the API level. EIE 7 is a version 7 application and should use the version 7 API. If they must use old API's to install new applications then at least display an accurate error message. BMC makes all the software involved: ARS, API, EIE. Their installation programs should test to see if the login error is due to Min API Level and report it to the installer. At the very least they could compile a [very] tiny v7 API console application that uses the v7 API to report back to the installer the Min API Level. Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Roger Justice Sent: Wednesday, August 01, 2007 4:35 PM To: arslist@ARSLIST.ORG Subject: Re: EIE 7.0.1 p5 Install ** When you removed the Demo password the system will try to authenicate with the AD you must have a Demo password. -Original Message- From: Heider, Stephen [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wed, 1 Aug 2007 3:40 pm Subject: EIE 7.0.1 p5 Install List, I am trying to install EIE 7.0.1 patch 5 and the installation program can not authenticate any Remedy user. I also tried removing the password for Demo. I disabled all external authentication (it was using LDAP) and restarted the services. No other ARS applications are installed, other than those that come with the base ARS Server package. Any ideas? Stephen Windows Server 2003 ARS 7.0.1 p3, using Port Mapper SQL Server 2005 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org/ ARSlist:Where the Answers Are AOL now offers free email to everyone. Find out more about what's free from AOL at AOL.com http://www.aol.com?ncid=AOLAOF0002000437 . __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARServer.exe crashing
Rogerio, It may be due to SQL Server 2005 not being supported with v5.1.2. Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rogerio Sent: Monday, July 30, 2007 10:09 AM To: arslist@ARSLIST.ORG Subject: ARServer.exe crashing Hi everyone, Need some help. We are receiving this error randomly during the day: AR System Server Executable (SQL Server) encountered a problem and needed to close Then I see this in event viewer: Faulting application arserver.exe, version 5.1.2.0, faulting module ntdll.dll, version 5.2.3790.3959, fault address 0x0001bd02. Anyone have seen this before or have any idea about? Enviroment: ARS 5.1.2 - Windows 2003 SP2 - SQL Server 2005 Thanks, Rogerio Bronzoni Aguiar CMagnani ___ 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: ARServer.exe crashing
Rogerio, I understand. I wish I had a better answer for you. Has Windows or SQL been updated recently (ie. security patches, service packs)? Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rogerio Sent: Monday, July 30, 2007 10:19 AM To: arslist@ARSLIST.ORG Subject: RES: ARServer.exe crashing Stephen, The fact that is not supported doesn't mean that doesn't work. We have used this configuration since a long time and the error appeared recently. Thanks, Rogerio Bronzoni Aguiar [EMAIL PROTECTED] (11)2168-3705 -Mensagem original- De: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Em nome de Heider, Stephen Enviada em: segunda-feira, 30 de julho de 2007 11:10 Para: arslist@ARSLIST.ORG Assunto: Re: ARServer.exe crashing Rogerio, It may be due to SQL Server 2005 not being supported with v5.1.2. Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rogerio Sent: Monday, July 30, 2007 10:09 AM To: arslist@ARSLIST.ORG Subject: ARServer.exe crashing Hi everyone, Need some help. We are receiving this error randomly during the day: AR System Server Executable (SQL Server) encountered a problem and needed to close Then I see this in event viewer: Faulting application arserver.exe, version 5.1.2.0, faulting module ntdll.dll, version 5.2.3790.3959, fault address 0x0001bd02. Anyone have seen this before or have any idea about? Enviroment: ARS 5.1.2 - Windows 2003 SP2 - SQL Server 2005 Thanks, Rogerio Bronzoni Aguiar CMagnani ___ 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: ARServer.exe crashing
Rogerio, After googling this http://www.google.com/search?q=0x0001bd02+ntdll.dllbtnG=Search (not many matches) I found one solution that might help http://www.svnforum.org/2017/viewtopic.php?p=9633sid=a8dd34e057a8dd4f1c 8f7131a76a1bf0 In the C:\WINDOWS\ServicePackFiles\i386 to change ntdll.dll for ntdll.old Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Monday, July 30, 2007 10:20 AM To: arslist@ARSLIST.ORG Subject: Re: ARServer.exe crashing Rogerio, I understand. I wish I had a better answer for you. Has Windows or SQL been updated recently (ie. security patches, service packs)? Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rogerio Sent: Monday, July 30, 2007 10:19 AM To: arslist@ARSLIST.ORG Subject: RES: ARServer.exe crashing Stephen, The fact that is not supported doesn't mean that doesn't work. We have used this configuration since a long time and the error appeared recently. Thanks, Rogerio Bronzoni Aguiar [EMAIL PROTECTED] (11)2168-3705 -Mensagem original- De: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Em nome de Heider, Stephen Enviada em: segunda-feira, 30 de julho de 2007 11:10 Para: arslist@ARSLIST.ORG Assunto: Re: ARServer.exe crashing Rogerio, It may be due to SQL Server 2005 not being supported with v5.1.2. Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rogerio Sent: Monday, July 30, 2007 10:09 AM To: arslist@ARSLIST.ORG Subject: ARServer.exe crashing Hi everyone, Need some help. We are receiving this error randomly during the day: AR System Server Executable (SQL Server) encountered a problem and needed to close Then I see this in event viewer: Faulting application arserver.exe, version 5.1.2.0, faulting module ntdll.dll, version 5.2.3790.3959, fault address 0x0001bd02. Anyone have seen this before or have any idea about? Enviroment: ARS 5.1.2 - Windows 2003 SP2 - SQL Server 2005 Thanks, Rogerio Bronzoni Aguiar CMagnani ___ 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Associating .ARTASK Files to VBS
Norm, You should be able to change the associated program for file extensions here: My Computer Tools Options File Types file extension. How are you handling the User Tool authentication? The Windows user name is easy enough to capture, but how do you handle feeding the User Tool the password? Or how are you bypassing the password? Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Monday, July 30, 2007 11:40 AM To: arslist@ARSLIST.ORG Subject: Associating .ARTASK Files to VBS ** Hello everyone: I have a creative problem and I'd sincerely appreciate any/all suggestions or ideas. I don't even know if what I'm trying to do is possible, but I'm open to all ideas. I've written a neat little application that, when executed, launches the Remedy User client and logs the user on automatically. What I really like about it is that it also works with .artask attachments. That is, Remedy shoots the user a message: You have a ticket assigned to you. Click the attachment below to view it. The user double clicks the attachment, and my executable first checks to see if Remedy is running. If it is not, it launches Remedy as the user logged on to the OS, and then it launches ARTask, which in turn, displays the ticket. It's a very simple (poor man's) SSO. It works great. Here's the problem. The application I wrote is, well, an application. That is, it's an .EXE. In my environment, putting new .EXE files on workstations is a no-no, but putting scripts (such as VBS) is perfectly fine. So I completely re-wrote the application as a VB script. It works fine...except for the .ARTASK association. Evidently in Windows XP, one cannot associate a file to be run by a VB script the way one would, say, associate a .DOC file be opened with Word. So now I'm stuck. I need some way to change the file association of .ARTASK to ARtask.exe to .ARTASK to custom VBS. Any ideas? Norm __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Say what about that knowledge base?
Dave, Here is the email that may answer your question. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Stephen Sent: Wednesday, May 16, 2007 10:24 AM To: arslist@ARSLIST.ORG Subject: New Open Source .Net App Available - ARS_KBImport ** I just released a new .Net console application on ARSWiki that provides the ability to automatically import kb web pages into a Remedy form. Once in Remedy, you can perform searches using regular ARS search options (equal, not equal, like, and, or, not, less than, greater than, etc.). Periodically people on the List have asked about the application I wrote a year and a half ago. Although the original version worked I wanted to completely rewrite it before releasing to improve the performance and make the code more readable. As Remedy developers, much of our development time is spent automating tasks and improving efficiency. When you view a kb you could copy/paste the information into a Remedy form and attach the web page [that is automatically copied to your internet temp folder] in an attachment field. This app automates the process. It imports the kb web page and parses it into individual fields, from which you can search. The initial reason for creating this was because for a period of 4-6 months the supportweb KB search engine would lock up after performing one or two searches. I would have to close all browser windows and start over to perform another search. Additionally, I wanted the ability to specify more detailed searches than what was available online. The readme.txt has all the details to install, but basically you import one form and copy a few files to a new folder. The .Net 2.0 runtime and the current ARS .Net API need to be installed prior to running or developing. Tested with ARS 6.3 and 7.0. I would like to thank Jason Miller, Nii Addy, and Brent Goodman for their testing. Their feedback and suggestions helped in making this a more useful tool. Please post any comments or suggestions on the new ARSWiki mailing lists Main Projects Page http://arswiki.org/projects/dotnetutil Downloads http://arswiki.org/projects/dotnetutil/downloads Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shellman, David Sent: Thursday, July 26, 2007 8:45 AM To: arslist@ARSLIST.ORG Subject: Re: Say what about that knowledge base? No need to feel silly. I tried to use Fire Fox for many months before I worked with the Customer Cares folks (Support can't help). Hopefully Stephen can give us an explanation of how his tool can retrieve data from the BMC/Remedy knowledgebase. Dave -- [EMAIL PROTECTED] (Wireless) - Original Message - From: Action Request System discussion list(ARSList) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Open Excel doc from a Command Line process
Henry, It must be ARS Wiki day :) I created a utility that obtains the Excel path (and other values) for the installed version and store it in a Global Field. Then, when I need to run Excel I use the value inside this field. The name of the utility is WksInfo. http://arswiki.org/projects/dotnetutil Another approach would be to use a series of Set Fields $PROCESS $ commands to test the existence of the application file. For example: $PROCESS$ cmd.exe /c if exist $zTmpField1$ (echo Yes) else (echo No) Set zTmpField1 to C:\Program Files\Microsoft Office\OFFICE11\Excel.exe. If it doesn't exist then try it with C:\Program Files\Microsoft Office\OFFICE10\Excel.exe, and so on until you find. Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Douglas, Henry Sent: Thursday, July 26, 2007 11:12 AM To: arslist@ARSLIST.ORG Subject: Open Excel doc from a Command Line process ** Hello ARSList I am rewriting several hard coded functions on the system I have inherited. The latest is a Run Process command to open Excel a user maintained spreadsheet. The current working Command Line in the Run Process action is: C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE \\servername\drive\folder\filename.xls I need to rewrite this to function for multiple versions of excel not just from the OFFICE11 install directory. I have tried many interactions with no success even some that work from Start Run in windows but not from the User tool. TIA Thanks Henry STATEMENT OF CONFIDENTIALITY: The information contained in this message or any attachments to this message are intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material as well as being protected from disclosure. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Say what about that knowledge base?
Louise, This was the primary reason I created the ARS_KBImport utility. Perhaps this may be a solution for you. HTH http://arswiki.org/projects/dotnetutil Click on the Downloads link to download the utility. Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of E. Louise van Hine Sent: Thursday, July 26, 2007 6:36 AM To: arslist@ARSLIST.ORG Subject: Say what about that knowledge base? I haven't been able to get a search to run on the BMC Knowledge base, even when I select a product. I have just put in a support request for it, but perhaps someone else has a tip or trick for running a search, because keyword searching with that top panel does not seem to function without a huge JSP error. Could it have something to do with running Mozilla Firefox 2.0? -- Regards, Louise van Hine KTSL Limited [EMAIL PROTECTED] ___ 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: Attachments Drag-n-Drop Multiple Files - SOLVED
It worked when I shrank the attachment pool from 10x10 to 7x7. Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Friday, July 20, 2007 8:54 AM To: arslist@ARSLIST.ORG Subject: Attachments Drag-n-Drop Multiple Files List, With our Remedy system users add attachments (Windows User Tool only) via a single dialog I created. Screenshot attached. The files are stored in a separate form that only has attachments. This has been working fine for over a year. A new requirement is to provide the ability to also drag-n-drop an attachment onto the form as an option instead of using the File Add window. So, I display the Attachment Pool as a 10 pixel by 10 pixel square that is positioned on top of the Add button. Users can drag a file onto the tiny square and drop it when the plus sign appears. *Because there is no event that fires when an attachment is dropped onto an attachment pool, the user still has to click the Add button. This works great. Now the requirement is to drag-n-drop multiple files at one time. So, I added several more Attachment Fields to the attachment pool (5 total). I can drag up to 5 files onto the form at one time, followed by clicking the Add button. Here is where it gets interesting... Sometimes it works fine - all the files are successfully dropped onto the attachment pool. However, about half the time the User Tool prompts the user if they want to overwrite an existing file. What is happening is this, if I drag 3 files onto the attachment pool I get prompted to overwrite the 1st file with the 2nd file. Then I get prompted to overwrite the 2nd file with the 3rd file. The end result is that only the last file ends up in the attachment pool. I have not found any pattern to this. I am setting the Attachment Fields to $NULL $ after each processing so I know it's not that. It even sometimes occurs when I first open the attachments screen. Why does this occur? Since my code is not changing between the times I run it, I think it must be something with Remedy. How are others using drag-n-drop with an attachments screen? Thanks. Stephen ARS 6.3 ___ 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