Re: kind of selection

2011-10-25 Thread Reiser, John J
Christoph, Table fields are just a view of the data stored in a form. So your first part is correct. The left side table would show results of the Character field of Form 1. Why are you processing this as a table when a menu would do? You can select menu items and have then concatenated

Re: EXTERNAL: Preserve full mail formatting on incoming emails, possible?

2011-10-31 Thread Reiser, John J
Jan, If you display the Advanced Options in the AR System Email Messages form (select Yes) you will see the Attachment Alternatives. The attachments there will be in the email format in which they were sent. Sometimes you get an HTML file and the original eml file. I have not tried to use workflow

Re: EXTERNAL: Re: Preserve full mail formatting on incoming emails, possible?

2011-11-01 Thread Reiser, John J
No, I said the email is attached as an .eml file AND sometimes there is an HTML version also attached to the incoming AR System Email Messages record. You must select the Display Advanced Options field "Yes" and the extra pages will appear. Go to the Advanced Options page and then the Attachment Al

Re: Consuming Web Service not WSDL

2011-11-02 Thread Reiser, John J
Chintan, I have a similar request. I am trying to interface with a REST API which can display the returned values in JSON? or XML. There is no WSDl available to load. The administrator of the site replied to my request for the WSDL location with "We are using REST, so you don’t need a WSDL file

Re: EXTERNAL: Re: Consuming Web Service not WSDL

2011-11-03 Thread Reiser, John J
et by updating individual fields to Remedy record. Hope this helps. Thanks Chintan. _ From: "Reiser, John J" To: arslist@ARSLIST.ORG Sent: Wednesday, November 2, 2011 2:19 PM Subject: Re: Consuming Web Service not WSDL Chintan, I have a similar request. I am

Re: SQL ?

2011-11-14 Thread Reiser, John J
Peter, Date fields count the number of days from the beginning of its range.( January 1, 4713 B.C.E. - January 1, C. E.) Date/Time fields count the number of seconds from the Unix epoch. (January 1, 1970 00:00:00 AM) I'm not brushed up on SQL statements but you could try to change the oper

Installing ARServer with windows authentication to the remote, shared DB

2011-12-05 Thread Reiser, John J
Hello Listers, ARS 7.6.03 MS SQL Server 2005 MS 2003 R2 enterprise on a VM I'm getting back to installing a shared server so I can eventually drop the original ARServer and replace it with the new one. When I try to specify the Windows authentication to the MS SQL server the installer keeps repo

Re: EXTERNAL: Re: Firing One Active Link on Multiple Controls

2011-12-23 Thread Reiser, John J
Moe, You still need one active link per control. You could use the Active Link on each button to just call a Guide like Misi suggested. Each AL would set the ID of the button to a display only field and call the guide. Then you only need the one AL that finds and displays your help messages.

Create a View form of a remote oracle DB on ARSystem (MS SQL)

2012-02-02 Thread Reiser, John J
Hello Listers, MS SQL 2005 on a SAN MS Windows 2003 Enterprise AR System 7.6.03 Build 001 Our system connects to a remote Sybase DB via the DB Link for ARS Croom Consulting. The Sybase DB is being replaced by an Oracle DB. We only need to read data so I am trying to make the oracle connection wi

Re: Create a View form of a remote oracle DB on ARSystem (MS SQL)

2012-02-23 Thread Reiser, John J
should not have to worry about the case sensitivity from Remedy. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J Sent: Thursday, February 02, 2012 3:50 PM To: arslist@ARSLIST.ORG Subject: Create a View

Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB

2012-03-06 Thread Reiser, John J
Gary, Jean-Louis is correct. I am trying the same thing on ARS 7.6.03. Had the DBA create a Linked Server on MS SQL using DTS. I created a view in the ARSystem database using MS SQL Server management Studio. SELECT CAST(CONTROL_UNIQUE_ID AS int) AS UNIQUE_ID, CAST(CONTROL_NUM AS varchar) AS

Re: EXTERNAL: Asset Tracking - Barcodes

2012-03-08 Thread Reiser, John J
Warren, Check with Phil Bautista at BullCreek. He's had "a little" experience with bar-coding and ARS ;^> --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be i

Re: EXTERNAL: Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB

2012-04-03 Thread Reiser, John J
, where I am at now, I do not have the elevated privileges. On 3/6/12, Reiser, John J wrote: > Gary, > > Jean-Louis is correct. > I am trying the same thing on ARS 7.6.03. > Had the DBA create a Linked Server on MS SQL using DTS. > I created a view in the ARSystem database using

Re: Question: Change Request ID Number

2006-04-24 Thread Reiser, John J
T. Check the developers community on Supportweb. I think here is a utility that someone created that lets you change the next id from an AR System form. Be careful, this is a powerful tool and can get you in a lot of trouble if not used with caution and a good backup. It's called nextID or some

Re: How to hide Modify field from top of page SURVEY page

2006-04-24 Thread Reiser, John J
** Dan,   On the current view properties dialog set the Web Title to hidden. I think it is the Appearance tab.   HTH,   John J. ReiserSoftware Development AnalystRemedy Administrator/DeveloperLockheed Martin - MS2The star that burns twice as bright burns half as long.Pay close attention and b

Re: How to hide Modify field from top of page SURVEY page

2006-04-24 Thread Reiser, John J
** Dan,   Since this is going to the Midtier I think ( not 100% ) that you must actually add the results field ( ID 1020) from the Form Action Fields and then either hide it with an on open Active Link or you may be able to take it out of the view. I haven't tried it but someone else may conf

Midtier browser Back function from an AL button

2006-04-24 Thread Reiser, John J
Hello Listers, ARS 6.3 Patch 13 Midtier 6.3 Patch 13 MS SQL 2000 Windows 2000 Server I looked through the Archives for a reference to supplying a "Back" button in Midtier but I didn't have much luck. Has anyone done this via an Active Link? I even tried a text field as a URL with GO BACK but i

Re: HTML Email Submissions

2006-04-27 Thread Reiser, John J
** Scott,   Couldn't you use the templates as described in the ARSystem Email documents?   I also remember someone posting an Outlook "form" that had the regular Remedy email format in the backend. HTH, John J. ReiserSoftware Development AnalystRemedy Administrator/DeveloperLockheed Martin -

Re: HTML Email Submissions

2006-04-27 Thread Reiser, John J
** Scott,   I believe there is a section in the docs that talks about sending HTML format out and allowing a ReplyTo to update that record( Permissions permitting of course) I would think that the incoming reply would be in HTML also. Maybe you could exploit that?   We have used and HTML form

First time DSO troubles

2006-04-27 Thread Reiser, John J
Hello Listers, ARS 6.3 Patch 13 MS SQL2000 We just got DSO licensed on our two servers and I am trying to gets things rolling. I've tried to follow the configuration documents but I still can not get any transfer to occur. The form on the target server is an import of the source. I'm not even sur

Re: First time DSO troubles - Resolved

2006-04-27 Thread Reiser, John J
trator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reis

Re: Password Change Form ?

2006-05-02 Thread Reiser, John J
** Mark,   Isn't that Phil's entry from Bullcreek?   John J. ReiserSoftware Development AnalystRemedy Administrator/DeveloperLockheed Martin - MS2The star that burns twice as bright burns half as long.Pay close attention and be illuminated by its brilliance. - paraphrased by me   From: Acti

Re: v7 Compatability Matrix

2006-05-09 Thread Reiser, John J
Rumor has it that ARS 7.0 is to be released today. I heard this at a ColumnIT event and was not told it was under NDA so I guess it is now public knowledge. John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns h

Re: v7 Compatability Matrix

2006-05-09 Thread Reiser, John J
he Support site as of a few minutes ago, though. ARS 7 has some cool new stuff, but it's not a major rewrite. ITSM 7, on the other hand... Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J Sent: Tuesday, Ma

Re: ARSLIST web site not up

2006-05-09 Thread Reiser, John J
Title: ARSLIST web site not up ** Peter, There appears to be a link problem. When the URL changes, add an "s" to the word archive or go to www.wwrug.org and choose the ARSlist link     John J. ReiserSoftware Development AnalystRemedy Administrator/DeveloperLockheed Martin - MS2The star that b

Re: Homepage link

2006-05-10 Thread Reiser, John J
Sarah, If you are talking about the home page on Midtier, then you have to force a cache flush or wait for the time out. HTH (Hope This Helps), John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long

Re: ARS 7: LDAP

2006-05-10 Thread Reiser, John J
Pat, SLOW DOWN. The mouse wheel is smoking. I like the Assignment Engine. Looks very promising. John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its

Re: DSO bypassing mapping

2006-05-12 Thread Reiser, John J
** Jim,   I'm just starting to use DSO so I know I don't have a DSO answer BUT can you create a dummy user form on the source server and pass it as your User form? DSO could duplicate the real user for to the dummy and the dummy would pass the values to the reporting form. In the absence of a

Re: Speech IVR and Remedy

2006-07-07 Thread Reiser, John J
Carey and Roger, OT from the original post but . . . There is one perfectly legal way to handle a situation like this. The "closure" action actually creates a new record in a "Closure" form. That sends a notification to an actual licensed user who in turn closes the Helpdesk Ticket. No violation s

Re: Speech IVR and Remedy

2006-07-07 Thread Reiser, John J
ssage- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J Sent: Friday, July 07, 2006 10:36 AM To: arslist@ARSLIST.ORG Subject: Re: Speech IVR and Remedy Carey and Roger, OT from the original post but . . . There is one perfectly legal w

Re: Speech IVR and Remedy

2006-07-07 Thread Reiser, John J
ow update and closure, so I know that it can be done through workflow at least nominally within the bounds of the license agreement. Regards, Adam Pederson ITSM Consultant Xinify Technologies, Inc. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PRO

Re: Speech IVR and Remedy

2006-07-07 Thread Reiser, John J
X: 973-490-3296 sf49fanv AIM IM RogerNall Yahoo IM -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J Sent: Friday, July 07, 2006 1:18 PM To: arslist@ARSLIST.ORG Subject: Re: Speech IVR and Remedy Adam, You'

Re: Remedy Import - Limits to 15 records

2006-08-03 Thread Reiser, John J
** Jason,   Some one may have stated this already but when you check your file do you use Excel or notepad/wordpad. I have seen "section breaks" in a .csv file when opened in Excel that just appears as a blank line in notepad. That could explain the "every 15th record" phenomenon.   Try a sim

Re: Enhancement idea: Field Label for fields

2006-08-08 Thread Reiser, John J
** Joe,   It may not retain the functionality but you could build it. An On Focus AL could SET the Value of the Field Name of the Actual field into the Advanced Search Bar via the Query Bar field (ID 1005). Maybe use a look up form to hold all of your text fields and the corresponding data

Re: Palm PC with Remedy

2006-08-09 Thread Reiser, John J
Brent, Try contacting Aeroprise. They make a wonder client that fits between WAPI enabled phones, PDAs, Blackberries, etc. It allows the end-user a means to customize alerts, replies and screen forms. It's a very versatile tool. We have been using it in a batch mode (non wireless) to process inven

Re: ADM: re. ahaha hehehe

2006-08-18 Thread Reiser, John J
Maybe Dan is trying to "keep the camel's nose" out of the tent; "closing the barn door" before the horse gets out; keeping that [EMAIL PROTECTED]& cat in the bag. OK that last one was a stretch. Remember we are a community and must consider what we post and it's affects on that community. Stran

Re: help, help, help

2006-08-22 Thread Reiser, John J
** Sara,   Welcome to the fold.   Use a unique index on the field in question. For the auto increment field try creating a form with a character field and an Integer field. Call the character field AR Form Name and the Integer can be called count. Enter the Schema name of your current form

Re: User Tool Margin

2006-08-24 Thread Reiser, John J
** Hi Roger, No there's no way to change that BUT you can hide that bar and put a Display as Text character filed up at the top of your form to display the appropriate data.   In the admin tool open the menu Form | Current View | Properties and look at the Appearances tab. Set the Details Pan

Re: User Tool Margin

2006-08-24 Thread Reiser, John J
** Wow You truly do learn something new everyday on the ARSList!! That's why I love it here.   Thanks Joe. That one goes into the "keep" pile.   John J. ReiserSoftware Development AnalystRemedy Administrator/DeveloperLockheed Martin - MS2The star that burns twice as bright burns half as long

Re: User Tool Margin

2006-08-24 Thread Reiser, John J
: Re: User Tool Margin ** You're welcome...  Joe - Original Message ----From: "Reiser, John J" <[EMAIL PROTECTED]>To: arslist@ARSLIST.ORGSent: Thursday, August 24, 2006 9:01:26 AMSubject: Re: User Tool Margin** Wow You truly do learn something new everyday on the

Re: OT - Friday Humor

2006-08-25 Thread Reiser, John J
Title: OT - Friday Humor ** You can raed it esaeir if you are dlsyeixc. Smoe teims a "hndsiacp" can wrok for you. And my sepll cechekr ddint filncth. John J. ReiserSoftware Development AnalystRemedy Administrator/DeveloperLockheed Martin - MS2The star that burns twice as bright burns half a

Re: BUW:ARSlist Awards .... Tonight!

2006-08-31 Thread Reiser, John J
We want pictures and video. Twinkie carnage everywhere. Oh the Humanity. John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased

Re: Hellllloooooo!!!!

2006-08-31 Thread Reiser, John J
Title: RE: Heloo ** Yeah, they are Blue Blaze Irregulars Why is there a watermelon there?   John J. ReiserSoftware Development AnalystRemedy Administrator/DeveloperLockheed Martin - MS2The star that burns twice as bright burns half as long.Pay close attention and be illuminated by

Re: Hellllloooooo!!!!

2006-08-31 Thread Reiser, John J
Sorry to butt in here Audrey and James. I have two questions. 1. Audrey did you present at the Column It Borgata event in New Jersey? 2. What DB are you using on your home setup? Maybe you could answer off list if you think it appropriate. Thanks, Sorry James, no questions for you. John J. Reiser

Re: Twinkie Experiments - Friday Humor

2006-09-01 Thread Reiser, John J
** Don't worry L ars. Twinkies can even withstand a Nucular[sic] blast. Just ask Peter Griffin John J. ReiserSoftware Development AnalystRemedy Administrator/DeveloperLockheed Martin - MS2The star that burns twice as bright burns half as long.Pay close attention and be illuminated by its b

Re: ARSLIST AWARDS

2006-09-01 Thread Reiser, John J
Hey Axton, Congratulations. John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -Original Message- From:

Re: Active Directory Users getting locked out

2008-01-09 Thread Reiser, John J
Harry, What version of the ARserver and User tool are they using? When we upgraded to ARS 5.1.2 and had users back on ARS4 they logged in Okay but their AD locked up. There was a change to the way ARS handles passwords in ARS 5 and up. John J. Reiser Software Development Analyst Remedy Adminis

ARSLIST Archives unavailable?

2008-01-11 Thread Reiser, John J
Hello Listers, I've been having no luck accessing the Archives. Anyone know if there is a problem? Thanks, John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminat

Re: Search shows only results list

2008-01-16 Thread Reiser, John J
Dwayne, If you use a Preference server check her entry in the AR System User Preference form. On the General tab there is a check box under the On Search settings to "Show Result List Only" If this is set by default for her she will get that condition even after a reinstall of the WUT. When it goe

Re: Sending emails to a Blackberry

2008-01-16 Thread Reiser, John J
Chris, Do you receive the email message in Outlook from "an address which goes to everyone on the help desk"? We had a problem sending email to Verizon cell phones and it turned out to be the way Verizon handled text email. It seems that it worked better as an HTML formatted message. We added an e

Re: Sending emails to a Blackberry

2008-01-16 Thread Reiser, John J
L one and see what happens. Thanks John! From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J Sent: Wednesday, January 16, 2008 12:30 PM To: arslist@ARSLIST.ORG Subject: Re: Sending emails to a Blackberry Chris, Do you recei

Re: Field names

2008-01-18 Thread Reiser, John J
Rudolf, Usually fields like z1D_Char02 are global fields. Look at the Field ID. Ranges of 1,000,000 - 1,999,999 ( commas added for clarity) are regular global fields. Window scoped global fields go from 3,000,000 to 3,999,999. And of course all that can change if BMC so chooses. zTmp... field

Re: Xtreme Integration Tools (ESS)

2008-01-24 Thread Reiser, John J
Gidd, I really like it. Is it tied only to ESS or can you "roll your own" integration with current forms? Nice job! John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and b

Re: Group Form, Floating Licenses Field

2008-01-25 Thread Reiser, John J
The 10 Licenses are reserved for the Group in the Pool. No one else can access those license tokens. The remaining licenses are given out by Group preference, lower number Group ID is the first considered group. This applies to users who are waiting for a token. If all of the Floating tokens are

Re: Problem while browsing the result list

2008-02-04 Thread Reiser, John J
and you can always teach them that F6 toggles between the results list and the details pane John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brill

Report Creator form and Status.TIME.Closed problem

2008-03-05 Thread Reiser, John J
Hello Listers, ARS 6.3 patch 021 MS SQL Server 2000 Has anyone experienced a problem when using the Report Creator form using the Status.TIME.Closed as a reporting field? It seems that when the report is created everything is fine but when the report runs there are two columns of Status.TIME.Clo

Re: Auto Refresh

2008-03-31 Thread Reiser, John J
Create an Active Link that executes on "Interval" and set the interval time to 600 seconds from the selection field. The action would be two Change Fields actions that perform refreshes on your table fields. That is the basic workflow needed. John J. Reiser Software Development Analyst Remedy Admi

Re: How to track changes

2008-04-16 Thread Reiser, John J
Masha, In the Administration Tool select the Server Information item from the File menu. Then go to the Server Events tab. Select the User and Group check boxes. This will enable entries in the Server Events form on your Remedy ARSystem server for all creations/changes/deletions of Groups and U

Re: How to track changes

2008-04-16 Thread Reiser, John J
tions Engineer Office of Information Technology, BYU 801-422-3323 801-372-6221 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J Sent: Wednesday, April 16, 2008 10:47 AM To: arslist@

Re: Track-It Helpdesk?

2008-04-23 Thread Reiser, John J
Hi Welton, We used View forms to pull data from TrackIt. We had an installation that was heavily modified. Croom Consulting's DBLink to SQLServer would be quick way to get Vendor form access to and from the TrashIt er TrackIt tables. I never worked much on the trackit side. Does that admin fo

Re: Administrative Access

2008-04-28 Thread Reiser, John J
Kathy, Take the new "Remedy guy" by the hand and add a Read-Only user called CRReporter. Give CRReporter read access to all the fields in the form on which you wish to report. You can build your entire CR output with this kind of access to the dev server. For the workflow portion, you're going to h

Re: Administrative Access

2008-04-28 Thread Reiser, John J
Kathy, So it's political. Well good luck. I can only suggest that you try to talk to this admin. Assure him that you won't damage his dev server and you won't show him up either. It depends on your status level whether you can walk over him or not but do tread carefully. The Sub-Administrator ro

Debugging runmacro in ARS 6.3

2008-05-14 Thread Reiser, John J
Hello Listers, ARS 6.3 Patch 21 MS SQLServer 2000 I am trying to update a runmacro used in an Escalation Run Process. Is there anyway to debug the runmacro to see why it stopped working? The macro logs in as a valid user. Performs a query passed in by the -p parameter and Reports To File a simple

Re: Remedy on a Blackberry

2008-05-29 Thread Reiser, John J
Gary, Check out Aeroprise. They have canned and customizable formats for the ARSystem. We used it for a wireless/docked handheld barcode scanner project. It is very flexible. John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twic

Admin tool anomaly with two monitors.

2008-06-02 Thread Reiser, John J
Hello Listers, ARS 6.3 Patch 014 ARS Admin tool 6.3 Patch 017 I came across a strange anomaly in the admin tool and I am not sure if it is a bug or just a HW driver issue. I have a Dell Laptop (D610) as my primary workstation with the admin tool loaded. I use a docking station to get access to a

Re: Admin tool anomaly with two monitors.

2008-06-02 Thread Reiser, John J
notification and Templete on both monitors. Primary monitor is Dell Ultrasharp and secondary is an old Optiquest. Using 2 video cards vs 1 video with dual output. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J Sent

Re: Admin tool anomaly with two monitors.

2008-06-02 Thread Reiser, John J
ication and Templete on both monitors. Primary monitor is Dell Ultrasharp and secondary is an old Optiquest. Using 2 video cards vs 1 video with dual output. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J Sent

Flashboards and Date Ranges

2008-06-05 Thread Reiser, John J
Hello Listers, ARS 6.3 Patch 021 I tried looking in the List but couldn't find any previous posts. I am trying to display a Stacked Bar Chart that displays the count of tickets by Asset Type per week ending date. I have all that working and now I am being asked to make the data range selectable i

Re: Flashboards and Date Ranges

2008-06-10 Thread Reiser, John J
27;Status' != ""Void"")") + "AND ('Create-date' >= """) + $ReportBeginDateTime$) + """) AND ( 'Create-date' <= """) + $ReportEndDateTime$) + """)" Hope that helps. Julie

Re: Flashboards and Date Ranges

2008-06-10 Thread Reiser, John J
T.ORG Subject: Re: Flashboards and Date Ranges Hi John, Yes they are. Julie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J Sent: Tuesday, June 10, 2008 6:47 AM To: arslist@ARSLIST.ORG Subject: Re: Flashboards and

Re: Firefox3

2008-06-19 Thread Reiser, John J
I just tried to view my home page with Firefox 3.0. All looks fine until I tried to view the page field with an Application List. I don't see the list but I do see a random Flashboard field from another page field. It also has trouble rendering the Flashboards once your view them. Though I don't kn

Re: Firefox3

2008-06-19 Thread Reiser, John J
riceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J Sent: Thursday, June 19, 2008 2:31 PM To: arslist@ARSLIST.ORG Subject: Re: Firefox3 I just tried

Re: Archiving Stopped?

2008-06-23 Thread Reiser, John J
Mark, Have you recently added an escalation that may be updating the tickets? Even Closed ones? That would prevent the Modified Date from ever getting close to your qualification. Maybe you could change it to Status-History.Closed-Cancelled.TIME in place of the Modified Date. Just a thought. Joh

Re: Archiving Stopped?

2008-06-23 Thread Reiser, John J
Kinetic Data, Inc. On Jun 23, 2008, at 9:19 AM, Reiser, John J wrote: ** Mark, Have you recently added an escalation that may be updating the tickets? Even Closed ones? That would prevent the Modified Date from ever getting close to your qualification. Maybe you could change it to St

Integrating with another company's ARSystem

2008-06-24 Thread Reiser, John J
Hello Listers, Current configuration ARS 6.3 Patch 014 Midtier 6.3 Patch 021 MS SQL Server 2000 Upgrade path ARS 7.1 Midtier 7 MS SQL Server 2000 maybe higher I know this is a long shot but has anyone put together an integration between two different ARSystem servers in two different companies?

Re: Integrating with another company's ARSystem

2008-06-24 Thread Reiser, John J
might be able to give better answers. Could be anything from very simple to you-gotta-be-kidding. Rick On Tue, Jun 24, 2008 at 7:40 AM, Reiser, John J <[EMAIL PROTECTED]> wrote: Hello Listers,

Re: Integrating with another company's ARSystem

2008-06-24 Thread Reiser, John J
___ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J Sent: Tuesday, June 24, 2008 1:53 PM To: arslist@ARSLIST.ORG Subject: Re: Integrating with another company's ARSystem Roger, Rick and Robert, Thanks for the replies.

Consuming a Web Service in ARS 6.03

2008-07-01 Thread Reiser, John J
Hello Listers, ARS 6.03 Patch 014 I am trying to test the Web Service feature of the AR System. I looked through the archives for some enlightenment but the problem I'm having doesn't seem to show up. I even found an old post of my own that was similar in scope but that project never progressed p

Notification philosophy - Use the Group List or a data driven form.

2008-07-10 Thread Reiser, John J
Hello Listers, ARS 6.3 Patch 21 SQL Server 2000 Windows 200 server I am reworking a small help desk application and I was wondering if there is a general philosophy for handling email lists. We are identifying a list of people "types": Management Field Rep Ticket Expediter Warranty Clerk etc. T

Re: Notification philosophy - Use the Group List or a data driven form.

2008-07-11 Thread Reiser, John J
: Thu, 10 Jul 2008 12:47:22 -0400 >From: "Reiser, John J" <[EMAIL PROTECTED]> >Subject: Notification philosophy - Use the Group List or a data driven form. >To: arslist@ARSLIST.ORG > >Hello Listers, > >ARS 6.3 Patch 21 >SQL Server 2000 >Windows 200 server &

Re: Blackberry Solutions

2008-07-14 Thread Reiser, John J
Brian, I've used Aeroprise with a handheld PDA a w/barcode scanner but it should be a similar situation with your Blackberry. It is very flexible and is not restricted to "Helpdesk" or other canned Remedy ARS forms. I made a custom form to "check-in" bar tagged equipment. Upon docking and running t

Send a Diary Field as an attachment.

2008-07-15 Thread Reiser, John J
Hello Listers, ARS 6.3 Patch 21 MS SQL Server 2000 MS Windows 2000 Am I missing something basic? I have been asked to forward the Call Log (Diary Field) along with a notification email as an attachment. The only way I can think of doing this is to 1. Use a RUN PROCESS runmacro.exe which runs a r

Re: Send a Diary Field as an attachment.

2008-07-16 Thread Reiser, John J
l reports, export it in various formats. You can easly call it from a filter to run the report and email it. HTH, Jason On Tue, Jul 15, 2008 at 1:50 PM, Reiser, John J <[EMAIL PROTECTED]> wrote: Hello Listers, ARS 6.3 Patch 21 MS SQL Server 20

Re: Check Box Problem

2008-07-17 Thread Reiser, John J
Didn't check boxes come about in the "dark days"? I asked a Peregrim [sic] rep about that at a demo session in Philly. His answer should have been telling me something. "I don't know why it was built like that. Yes a binary coded field would probably work." LJ, Have you done this yourself? I toy

Re: No spaces allowed in a character field

2008-07-22 Thread Reiser, John J
Atul, If you need to stop spaces at the left or right side of the data string use LTRIM() and RTRIM(). For spaces in the string you will need to use REPLACE($FieldID$," ","") You may need to check for additional spaces and loop through the string. I think REPLACE() will only affect the first insta

Re: No spaces allowed in a character field

2008-07-22 Thread Reiser, John J
o: arslist@ARSLIST.ORG Subject: Re: No spaces allowed in a character field Thanks for the response - My effort is to "error out" if there is a space - not replace it. Atul > - Original Message - > From: "Reiser, John J" <[EMAIL PROTECTED]> > To: arslist@ARSL

Re: Displaying search menu's label after selecting it

2008-08-05 Thread Reiser, John J
Dan, Are you using a search menu? What Joe described is the way to do it with a Search menu. Basically you can set the Value Field in the search menu to same field for the label. Then use an Active Link on Menu / Row Choice to find the record in the Search menu's form and set qualification strin

Re: Displaying search menu's label after selecting it

2008-08-06 Thread Reiser, John J
like to use another form to fill in the data to that menu (as a search menu would do). For sure this is much nicer and flexible. But I was just wondering if there is no way to display the menu label instead of the menu value after selecting an entry from the menu. Dan On Tue, Aug 5, 2008

Using a user account as a distribution list

2008-08-06 Thread Reiser, John J
Hello Listers, ARS 6.3 Patch 21 Email ARS 6.3 Patch 14 Server We use a "dummy" account, actually many accounts, as distribution lists. Email addresses are stored concatenated and delimited with semicolons (;). On one of our systems the EmailEngine stopped sending email to those addresses. I receiv

Re: Using a user account as a distribution list

2008-08-06 Thread Reiser, John J
dress' field.) -- 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 Wed, Aug 6, 2008 at 9:58 AM, Reiser, John J <[EMAIL PROTECTED]> wrote: > Hello

Email Engine Password reset

2008-08-06 Thread Reiser, John J
Hello Listers, ARS 6.3 Server ARS 6.3 AREmail MS SQL 2000 Windows 2000 Corporate security policy changes have required us to reset the password for the account that runs AR System Services and the AREMail Engine. The ARSystem has come back up fine but the email engine is not processing. I've chan

[no subject]

2008-08-07 Thread Reiser, John J
time around, we created a password that would be next to impossible to hack, that they let me have a non-expiring password for the email. Heck, I have trouble typing it! Claire From: Action Request System discussion list(ARSList) on behalf of Reiser, John J

Re: Email Engine Password reset

2008-08-07 Thread Reiser, John J
laire From: Action Request System discussion list(ARSList) on behalf of Reiser, John J Sent: Wed 8/6/2008 5:53 PM To: arslist@ARSLIST.ORG Subject: Email Engine Password reset Hello Listers, ARS 6.3 Server ARS 6.3 AREmail MS SQL 2000 Windows 2000 Corporate security policy changes have required us to

Outline of various system passwords.

2008-08-07 Thread Reiser, John J
Hello Listers, Does anyone have an outline or maybe a white paper that describes the different password settings throughout the Administration Tool? We had to change the password of the Windows account that runs the services as well as email for our system. There were some strange issues when the

Re: UNSUBSRIBE

2006-12-12 Thread Reiser, John J
Be nice Jennifer.'tis the season you know. Dan, can you put this at the TOP of every message too? UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" Peace to all. John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin -

Many to Many Child-Parent search

2006-12-13 Thread Reiser, John J
Hello Listers, ARS 6.3 patch13 MS 2000 with remote MS SQL 2000 I am trying to get a list of parents that have the same children to display in the parent form. I push the Parent GUID to the child record. That child record has another GUID field for the Group in which it belongs, lets say an eighth

Re: Many to Many Child-Parent search

2006-12-13 Thread Reiser, John J
eap Pick two. On 12/13/06, Reiser, John J <[EMAIL PROTECTED]> wrote: > Hello Listers, > > ARS 6.3 patch13 > MS 2000 with remote MS SQL 2000 > > I am trying to get a list of parents that have the same children to > display in the parent form. > I push the Parent GUI

Re: Many to Many Child-Parent search

2006-12-13 Thread Reiser, John J
the unique constraint, and creating a view form from that? Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message ---- From: "Reiser, John J" <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Wednesday, December 13, 2006 10:13:23 AM Subject: M

Re: Many to Many Child-Parent search

2006-12-13 Thread Reiser, John J
7;Material Request ' ID in a new ARS form that you join back to "Material Request" to show a table field of other data for the related "Material Request" records. HTH -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then

Re: Remedy's ENCRYPT function

2006-12-13 Thread Reiser, John J
Joe et al, The ENCRYPT function uses a key that you provide either as a hardcode text or stored in a field. I believe it is 56bit but I could be wrong. I know you need a lot more room in the character field if you encrypt data. I tried it once , just for fun, and my 11 character string would not

  1   2   3   4   5   6   >