Re: ARS Illustrator

2011-07-29 Thread Kirill Eitvid
Hello Matt,

Thank you for the hint.
I tried to send you a valid log file, so you can check whether it's OS  or
log file problem, but arslist blocked it. If you give me your e-mail, I can
send you a log file, which 100% works. I will check OS compatibilities
later, but it will not be an issue. See, it's completely cross-platform,
thanks to Qt library. When release version is finished, I will build it for
Windows x32/64, Linux and Mac.

On Thu, Jul 28, 2011 at 5:58 PM, Matt Reinfeldt
arsl...@mattreinfeldt.comwrote:

 Kirill,

 I downloaded it and ran it on my Windows 7 x64 workstation and tried to
 open
 a 7.6.04 SP1 workflow log file... it crashed.  Repeated a couple times to
 validate.  Can you validate which systems this is built to run on and which
 versions of log files it has been tested with?

 I know that you're in the early development stages, so just wanted to point
 out that that type of information will be key going forward.

 Thanks,

 Matt R.

 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:arslist@ARSLIST.ORG] On Behalf Of Kirill Eitvid
 Sent: Thursday, July 28, 2011 2:36 AM
 To: arslist@ARSLIST.ORG
 Subject: Re: ARS Illustrator

 Hello guys,

 I am working on a first release version now to present it officially. I
 guess it will be ready in a month. So I am looking for a little feedback
 here. Any ideas are wellcome :)

 Best regards, Kirill.



 Kirill Eitvid wrote:
 
  Hi,
 
  I am working on the project, which goal is to make ARS development a
  little bit easier. It's called ARS Illustrator. Here is a very short
  introduction:
 
  1. ARS log files visualisation.
  This is a GUI tool, which parses ARS logs and generates several views:
  tree view, sequence diagram view, time tracking view, source view and
  related objects index. Also you can save workflow model to XML.
  Beta version is done now. Although I work in German company, so it
 handles
  only German log files now.
 
  2. ARS Project Bay. This is a database with GUI access, which is a nice
  place to keep all information about your use-cases: requirements,
  technical documentation and tests. It can easily replace tools like
  testbench in you process. Also if you don't mind turning on logging while
  testing your application, it will create relations between workflow
  objects and test-cases. This gives you additional benefits like test-case
  relations, workflow coverage tracking, automatic regression tests
 planning
  etc.
 
  This should be finished around December this year.
 
  The thing is I am not quite sure that my company will use it at all. I
  would like to know whether anybody of you is interested to use this kind
  of technology in your projects, so this work makes any sense. Please feel
  free to ask any questions.
 
  And here are a few screenshots of beta version:
 
   http://old.nabble.com/file/p32137640/screen01.jpg
   http://old.nabble.com/file/p32137640/screen02.jpg
 

 --
 View this message in context:
 http://old.nabble.com/ARS-Illustrator-tp32137640p32154349.html
 Sent from the ARS (Action Request System) mailing list archive at
 Nabble.com.


 
 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 attend wwrug11 www.wwrug.com ARSList: Where the Answers Are




-- 
Best regards, Kirill

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


how to display a Sybase error message on the mid-tier

2011-07-29 Thread Remedy Maniac

dear list,

ARS 6.01 (... am upgrading to 7.6.4 ... :-))
Sybase 12.5.3

I have got a trigger which works fine except I'd like it to send back an 
error message to the user connected on the web (Apache/Tomcat)

The message simply doesn't display.
I have got something similar:

...
create trigger
...
if (condition met)
rollback transaction
raiserror err_nbr 'text'
...


Remedy seems not even getting the message
Would be great if anyone would have a clue on this ?

Greetings



__
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
__


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Re: ARS Illustrator

2011-07-29 Thread Matt Reinfeldt
Sent to you off-list.  

 

Thank you,

 

Matt

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kirill Eitvid
Sent: Friday, July 29, 2011 2:46 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARS Illustrator

 

** Hello Matt,

Thank you for the hint.
I tried to send you a valid log file, so you can check whether it's OS  or
log file problem, but arslist blocked it. If you give me your e-mail, I can
send you a log file, which 100% works. I will check OS compatibilities
later, but it will not be an issue. See, it's completely cross-platform,
thanks to Qt library. When release version is finished, I will build it for
Windows x32/64, Linux and Mac.

On Thu, Jul 28, 2011 at 5:58 PM, Matt Reinfeldt arsl...@mattreinfeldt.com
wrote:

Kirill,

I downloaded it and ran it on my Windows 7 x64 workstation and tried to open
a 7.6.04 SP1 workflow log file... it crashed.  Repeated a couple times to
validate.  Can you validate which systems this is built to run on and which
versions of log files it has been tested with?

I know that you're in the early development stages, so just wanted to point
out that that type of information will be key going forward.

Thanks,

Matt R.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kirill Eitvid
Sent: Thursday, July 28, 2011 2:36 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARS Illustrator

Hello guys,

I am working on a first release version now to present it officially. I
guess it will be ready in a month. So I am looking for a little feedback
here. Any ideas are wellcome :)

Best regards, Kirill.



Kirill Eitvid wrote:

 Hi,

 I am working on the project, which goal is to make ARS development a
 little bit easier. It's called ARS Illustrator. Here is a very short
 introduction:

 1. ARS log files visualisation.
 This is a GUI tool, which parses ARS logs and generates several views:
 tree view, sequence diagram view, time tracking view, source view and
 related objects index. Also you can save workflow model to XML.
 Beta version is done now. Although I work in German company, so it handles
 only German log files now.

 2. ARS Project Bay. This is a database with GUI access, which is a nice
 place to keep all information about your use-cases: requirements,
 technical documentation and tests. It can easily replace tools like
 testbench in you process. Also if you don't mind turning on logging while
 testing your application, it will create relations between workflow
 objects and test-cases. This gives you additional benefits like test-case
 relations, workflow coverage tracking, automatic regression tests planning
 etc.

 This should be finished around December this year.

 The thing is I am not quite sure that my company will use it at all. I
 would like to know whether anybody of you is interested to use this kind
 of technology in your projects, so this work makes any sense. Please feel
 free to ask any questions.

 And here are a few screenshots of beta version:

  http://old.nabble.com/file/p32137640/screen01.jpg
  http://old.nabble.com/file/p32137640/screen02.jpg


--
View this message in context:
http://old.nabble.com/ARS-Illustrator-tp32137640p32154349.html
Sent from the ARS (Action Request System) mailing list archive at
Nabble.com.


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are




-- 
Best regards, Kirill

_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Re: Atrium 7.6.04 SP1

2011-07-29 Thread Rick Cook
3800810.

Rick

On Thu, Jul 28, 2011 at 7:31 PM, Brett Azzopardi 
brett.azzopa...@planwell.net wrote:

 ATTN: Rick Cook

 Hi Rick,

 I am having issues with BMC support associating my issue to the similar if
 not replicated problem that you had. Can I please ask for the INC number you
 have logged with them to increase the speediness of their return. If you can
 you can send it to me offline to brett.azzopa...@planwell.net.

 Many thanks,


 -Original Message-
 From: Action Request System discussion list(ARSList) on behalf of Rick Cook
 Sent: Wed 7/27/2011 12:47 PM
 To: ARSList
 Subject: Re: Atrium 7.6.04 SP1

 **

 It was Red hat 6. Not sure of the exact version.

 Rick

 On Jul 26, 2011 7:28 PM, Brett Azzopardi brett.azzopa...@planwell.net
 wrote:
  Sorry Rick,
 
  One last question, was it due to the Environment you were installed it
 on? Did you also use RHEL v6.1?
 
 
  Kind regards,
 
  Brett Azzopardi
  (02)6265 0050
 
 
 
  -Original Message-
  From: Action Request System discussion list(ARSList) on behalf of Rick
 Cook
  Sent: Wed 7/27/2011 11:45 AM
  To: ARSList
  Subject: Re: Atrium 7.6.04 SP1
 
  In one of the installation XML files there is a setting that needs to be
  reset. BMC should know about it, because they have been working the same
  issue with us.
 
  Rick
  On Jul 26, 2011 6:28 PM, Brett Azzopardi brett.azzopa...@planwell.net
 
  wrote:
  Hi all,
 
  I am having some serious trouble installing Atrium (including AIS and
 AIE,
  no WS) on RHEL6.1 OS with an Oracle 11G database.
 
  Each time I get a failed result and the only thing I can find in the
 error
  log is;
 
   SEVERE
 
 
 com.bmc.install.product.atriumfoundation.cmdb.CMDBRuleEngineInstallerExecutorTask
 
  THROWABLE EVENT {Description=[Failed to prepare CMDB Rule Engine]} 
 
  I have checked communities website and the result suggested to remove
 the
  sample data, this
  created another error on the failed install. This is a fresh install,
 ARS
  was successful though
  approval server sanity check failed. Can anyone help?
 
  Kind regards,
 
  Brett Azzopardi


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


NOMail

2011-07-29 Thread John Kelley



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Re: ARX File Reader Utility

2011-07-29 Thread John Sundberg
I am getting closer :)


If the .arx value of a DATE field is 2455767  

How does that get converted to human readable?

Meaning -- does anybody know the conversion strategy?


1) Upload (which gets parsed for field names, types etc...) 
https://skitch.com/johnsundberg/fc1ye/kinetic-data-inc

2) Select fields you want to see
https://skitch.com/johnsundberg/fct9m/kinetic-data-inc

3) View
https://skitch.com/johnsundberg/fct95/kinetic-data-inc


4) Party!!!


-John


On Jul 24, 2011, at 4:03 PM, Mike Buck wrote:

**
Thank you

I'll take a look.

Kind regards

On Sun, Jul 24, 2011 at 11:59 AM, Misi Mladoniczky m...@rrr.se wrote:
Hi,

We have a tool that can do something like that, and more.

It is called RRR|ArxToHTML, and can be downloaded from:
https://www.rrr.se/cgi/tools/main#rrrArxToHTML

You will get the best result if you have a def-file with the
form-definition, as it will allow the tool to sort field by the form
layout, use labels instead of database names, selection field values etc.
You will get a result list with the normal entry-list-fields and links to
individual records.

The quick way to use it to convert an ARX-file to a table is to run it
like this:
rrrArxToHTML.exe -a xxx.arx -glf ALL -l xxx.html

This will create a single HTML-file with a table including all fields of
the ARX-file.

   Best Regards - Misi, RRR AB, http://www.rrr.se

Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.

 It would be SO good to view ARX files, without having to import to the
 target form, in order see all the data.

 Is anyone willing to share a utility, or build one to share, which will
 parse an ARX file and present it in an easy to digest form?

 The data could be presented with column headers in notepad for example, or
 even better in Excel (similar to how a CSV file is presented).

 This would be a really fantastic tool for code reviews and carry out
 pre-deployment checks.

 I really do hope someone is able to help:)

 Thanks very much
 Mike

 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are

_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_

--
John Sundberg

Kinetic Data, Inc.
Building a Better Service Experience
Recipient of:
WWRUG10 Best Customer Service/Support Award
WWRUG09 Innovator of the Year Award

john.sundb...@kineticdata.com
651.556.0930  I  www.kineticdata.com










___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Re: ARX File Reader Utility

2011-07-29 Thread Kirill Eitvid
John,

as far I remember it's the number of days passed since 01.01.1970 for DATE
and number of seconds since 01.01.1970 00:00:00 for DATETIME. Try it.

On Fri, Jul 29, 2011 at 7:43 PM, John Sundberg 
john.sundb...@kineticdata.com wrote:

 **
 I am getting closer :)


 If the .arx value of a DATE field is 2455767 

 How does that get converted to human readable?

 Meaning -- does anybody know the conversion strategy?


 1) Upload (which gets parsed for field names, types etc...)
 https://skitch.com/johnsundberg/fc1ye/kinetic-data-inc

 2) Select fields you want to see
 https://skitch.com/johnsundberg/fct9m/kinetic-data-inc

 3) View
 https://skitch.com/johnsundberg/fct95/kinetic-data-inc


 4) Party!!!


 -John


 On Jul 24, 2011, at 4:03 PM, Mike Buck wrote:

 **
 Thank you

 I'll take a look.

 Kind regards

 On Sun, Jul 24, 2011 at 11:59 AM, Misi Mladoniczky m...@rrr.se wrote:

 Hi,

 We have a tool that can do something like that, and more.

 It is called RRR|ArxToHTML, and can be downloaded from:
 https://www.rrr.se/cgi/tools/main#rrrArxToHTML

 You will get the best result if you have a def-file with the
 form-definition, as it will allow the tool to sort field by the form
 layout, use labels instead of database names, selection field values etc.
 You will get a result list with the normal entry-list-fields and links to
 individual records.

 The quick way to use it to convert an ARX-file to a table is to run it
 like this:
 rrrArxToHTML.exe -a xxx.arx -glf ALL -l xxx.html

 This will create a single HTML-file with a table including all fields of
 the ARX-file.

Best Regards - Misi, RRR AB, http://www.rrr.se

 Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
 * RRR|License - Not enough Remedy licenses? Save money by optimizing.
 * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.

  It would be SO good to view ARX files, without having to import to the
  target form, in order see all the data.
 
  Is anyone willing to share a utility, or build one to share, which will
  parse an ARX file and present it in an easy to digest form?
 
  The data could be presented with column headers in notepad for example,
 or
  even better in Excel (similar to how a CSV file is presented).
 
  This would be a really fantastic tool for code reviews and carry out
  pre-deployment checks.
 
  I really do hope someone is able to help:)
 
  Thanks very much
  Mike
 
 
 ___
  UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
  attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
 


 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


 _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_

 --
 John Sundberg

 Kinetic Data, Inc.
 Building a Better Service Experience
 Recipient of:
 WWRUG10 Best Customer Service/Support Award
 WWRUG09 Innovator of the Year Award

 john.sundb...@kineticdata.com
 651.556.0930  I  www.kineticdata.com









 _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_




-- 
Best regards, Kirill

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Re: ARX File Reader Utility

2011-07-29 Thread LJ LongWing
John,

I don't know if this will help you much, but this is a function I pulled off
the list a few years ago to help with that conversion

 

ALTER FUNCTION [dbo].[RemedyDateToHuman] (@dateint int)  

RETURNS datetime  AS  

BEGIN 

  DECLARE @sql_date datetime;

  -- SQL Server datetime values begin at 01/01/1753

  -- Remedy Date-only values begin at 01/01/4713 B.C.

  -- Remedy Date-only integer value for 01/01/1753 is 2361331

  

  IF @dateint  2361331

SET @sql_date = '17530101'

  ELSE

SET @sql_date = DATEADD(dd,@dateint - 2361331,'17530101');

  RETURN @sql_date;

END

 

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of John Sundberg
Sent: Friday, July 29, 2011 9:43 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARX File Reader Utility

 

** 

I am getting closer :)

 

 

If the .arx value of a DATE field is 2455767  

 

How does that get converted to human readable?

 

Meaning -- does anybody know the conversion strategy?

 

 

1) Upload (which gets parsed for field names, types etc...) 

https://skitch.com/johnsundberg/fc1ye/kinetic-data-inc

 

2) Select fields you want to see

https://skitch.com/johnsundberg/fct9m/kinetic-data-inc

 

3) View

https://skitch.com/johnsundberg/fct95/kinetic-data-inc

 

 

4) Party!!!

 

 

-John

 

 

On Jul 24, 2011, at 4:03 PM, Mike Buck wrote:


** 

Thank you

 

I'll take a look.

 

Kind regards

 

On Sun, Jul 24, 2011 at 11:59 AM, Misi Mladoniczky m...@rrr.se wrote:

Hi,

We have a tool that can do something like that, and more.

It is called RRR|ArxToHTML, and can be downloaded from:
https://www.rrr.se/cgi/tools/main#rrrArxToHTML

You will get the best result if you have a def-file with the
form-definition, as it will allow the tool to sort field by the form
layout, use labels instead of database names, selection field values etc.
You will get a result list with the normal entry-list-fields and links to
individual records.

The quick way to use it to convert an ARX-file to a table is to run it
like this:
rrrArxToHTML.exe -a xxx.arx -glf ALL -l xxx.html

This will create a single HTML-file with a table including all fields of
the ARX-file.

   Best Regards - Misi, RRR AB, http://www.rrr.se http://www.rrr.se/ 

Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.


 It would be SO good to view ARX files, without having to import to the
 target form, in order see all the data.

 Is anyone willing to share a utility, or build one to share, which will
 parse an ARX file and present it in an easy to digest form?

 The data could be presented with column headers in notepad for example, or
 even better in Excel (similar to how a CSV file is presented).

 This would be a really fantastic tool for code reviews and carry out
 pre-deployment checks.

 I really do hope someone is able to help:)

 Thanks very much
 Mike




___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
http://www.arslist.org/ 
 attend wwrug11 www.wwrug.com http://www.wwrug.com/  ARSList: Where the
Answers Are



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
http://www.arslist.org/ 
attend wwrug11 www.wwrug.com http://www.wwrug.com/  ARSList: Where the
Answers Are


_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ 

 

--

John Sundberg

Kinetic Data, Inc.
Building a Better Service Experience
Recipient of:

WWRUG10 Best Customer Service/Support Award

WWRUG09 Innovator of the Year Award

john.sundb...@kineticdata.com
651.556.0930  I   http://www.kineticdata.com/ www.kineticdata.com

 

 

 

 

 

 





 

_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Crystal Reports and Labels

2011-07-29 Thread Kathy Morris
Hi,
 
Are there any gotchas with modifying the field labels with asterisks.   The 
reason I am asking is because the team is making all the labels with an  * 
to show the fields are required.  I know database names are referenced  for 
formulas (i.e. Crystal Reports).. However I just want to make sure this will 
 not cause issues.   Does Crystal ever reference the labels  instead of the 
database names? 
 
i.e. Summary *
Description*
Priority*
 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
 

Re: ARX File Reader Utility

2011-07-29 Thread Grooms, Frederick W
From the Docs

Date and time fields 
There are three types of date and time fields: 

Date/time fields   
Store calendar dates and time together. You can set the display type to Date 
Only or Time Only so that the user sees only the date or time.
AR System stores date/time values as the integer number of seconds since 
00:00:00 GMT, January 1, 1970. Dates from January 1, 1970 through January 18, 
2038 GMT are valid in date/time fields. 

If the user enters only a time, then the current date is assumed. If the user 
enters only a date, then the time defaults to 12:00:00 AM. 

Date fields   
Store date information only, as the number of days from the beginning of its 
range. Use a Date field when you want to compare two dates or perform 
calculations based on the date, such as calculating the number of days between 
two dates. Users can enter dates from January 1, 4713 B.C. to January 1,  
A.D. in the Date field.

Time fields   
Store time information only, as the number of seconds from 12:00:00 AM. Use a 
time field to compare two times or perform calculations based on time, such as 
the number of seconds elapsed. 
The value in a time field is independent of the time zone. While a date/time 
field adjusts the displayed value to reflect the user's time zone, the time 
value in a time field remains unchanged when displayed on the client. 

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kirill Eitvid
Sent: Friday, July 29, 2011 10:51 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARX File Reader Utility

** John,

as far I remember it's the number of days passed since 01.01.1970 for DATE and 
number of seconds since 01.01.1970 00:00:00 for DATETIME. Try it.


-Original Message-
On Fri, Jul 29, 2011 at 7:43 PM, John Sundberg  wrote:
** 
I am getting closer :)


If the .arx value of a DATE field is 2455767  

How does that get converted to human readable?

Meaning -- does anybody know the conversion strategy?


1) Upload (which gets parsed for field names, types etc...) 
https://skitch.com/johnsundberg/fc1ye/kinetic-data-inc

2) Select fields you want to see
https://skitch.com/johnsundberg/fct9m/kinetic-data-inc

3) View
https://skitch.com/johnsundberg/fct95/kinetic-data-inc


4) Party!!!


-John

--
John Sundberg

Kinetic Data, Inc.
Building a Better Service Experience
Recipient of:
WWRUG10 Best Customer Service/Support Award
WWRUG09 Innovator of the Year Award
john.sundb...@kineticdata.com
651.556.0930  I  www.kineticdata.com


-Original Message-
On Jul 24, 2011, at 4:03 PM, Mike Buck wrote:

** 
Thank you

I'll take a look.

Kind regards

-Original Message-
On Sun, Jul 24, 2011 at 11:59 AM, Misi Mladoniczky  wrote:
Hi,

We have a tool that can do something like that, and more.

It is called RRR|ArxToHTML, and can be downloaded from:
https://www.rrr.se/cgi/tools/main#rrrArxToHTML

You will get the best result if you have a def-file with the
form-definition, as it will allow the tool to sort field by the form
layout, use labels instead of database names, selection field values etc.
You will get a result list with the normal entry-list-fields and links to
individual records.

The quick way to use it to convert an ARX-file to a table is to run it
like this:
rrrArxToHTML.exe -a xxx.arx -glf ALL -l xxx.html

This will create a single HTML-file with a table including all fields of
the ARX-file.

       Best Regards - Misi, RRR AB, http://www.rrr.se

Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.

-Original Message-
 It would be SO good to view ARX files, without having to import to the
 target form, in order see all the data.

 Is anyone willing to share a utility, or build one to share, which will
 parse an ARX file and present it in an easy to digest form?

 The data could be presented with column headers in notepad for example, or
 even better in Excel (similar to how a CSV file is presented).

 This would be a really fantastic tool for code reviews and carry out
 pre-deployment checks.

 I really do hope someone is able to help:)

 Thanks very much
 Mike

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Re: Email Engine Installation in DMZ

2011-07-29 Thread Reiser, John J
Chris,
 That's good to know.
I can telnet from the AR server to the mail host some I'm good for outbound
email.
I have a ticket open with BMC because the installation still doesn't load
the Email forms .

--- 
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 illuminated by its brilliance. - paraphrased by
me 


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of strauss
Sent: Thursday, July 28, 2011 4:47 PM
To: arslist@ARSLIST.ORG
Subject: EXTERNAL: Re: Email Engine Installation in DMZ

We are switching from MAPI to POP3/SMTP for 7.6.04.01 - I have installed
quite a few Email Engines on Windows 2003 and 2008 that way, and they work
against both the Exchange server and the failover server, defined as the
primary campus email server which is *nix something.  These are just my
settings:

Email Engine RMI Port 1100, RPC Program Number 0
AREmail_In
POP3
Email Server requires SSL = Yes
fqdn of my mail server : 995
Email account domain\mailboxuser
AREmail_Out
SMTP
arsmail...@mymaildomain.acs.unt.edu
Email Server requires SSL = No
fqdn of my mail server: 25
BLANK OUT ACCOUNT
(MUST DO THIS AGAIN IN CONFIGURATION AFTER INSTALL!!  IT FILLS IT
BACK IN AGAIN FROM _In record)

The trick for you will be to decide where the mailbox is for incoming mail -
my POP3 connection is to an account which could do MAPI if I wanted to keep
fighting problems with Outlook.

When I specify the *nix mail server as my _Out server on port 25, mail goes
out just fine; that mail server is set up to allow our campus servers to use
it to forward mail.  There will be an issue with mail coming back in without
a real mailbox to receive it.

Christopher Strauss, Ph.D.
Call Tracking Administration Manager
University of North Texas Computing  IT Center
http://itsm.unt.edu/

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J
Sent: Thursday, July 28, 2011 3:34 PM
To: arslist@ARSLIST.ORG
Subject: Email Engine Installation in DMZ

Hello Listers,
ARS 7.6.04 SP1
Windows 2003 Enterprise x64 Edition SP2 (Virtual Machine)
Everything is installed as 32 bit.
SQL Server 2005 is on a remote machine

I am trying to install the Email Engine (7.6.04 SP1) and I don't get the AR
System Email xxx forms loaded to the system. I also have a situation where
the domain that hosts our ARSystem Server does not have a mail server.
There is a port (25) open through the firewall to allow sendmail to connect
to a Unix mail forwarding server.
Since the OS is Windows I'm not sure what I need to do to get the outgoing
email to send mail if there is no MS Exchange server to access.
I just did an uninstall of the Email Engine and will try to re-install it
tomorrow.

TIA,
 

--- 
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 illuminated by its brilliance. - paraphrased by
me 




___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


smime.p7s
Description: S/MIME cryptographic signature


Re: ARX File Reader Utility

2011-07-29 Thread John Sundberg


Question -- has ANYBODY -- EVER -- used any date in BC?

And if so -- why?



-John


On Jul 29, 2011, at 11:50 AM, Kirill Eitvid wrote:

** John,

as far I remember it's the number of days passed since 01.01.1970 for DATE and 
number of seconds since 01.01.1970 00:00:00 for DATETIME. Try it.

On Fri, Jul 29, 2011 at 7:43 PM, John Sundberg john.sundb...@kineticdata.com 
wrote:
**
I am getting closer :)


If the .arx value of a DATE field is 2455767  

How does that get converted to human readable?

Meaning -- does anybody know the conversion strategy?


1) Upload (which gets parsed for field names, types etc...) 
https://skitch.com/johnsundberg/fc1ye/kinetic-data-inc

2) Select fields you want to see
https://skitch.com/johnsundberg/fct9m/kinetic-data-inc

3) View
https://skitch.com/johnsundberg/fct95/kinetic-data-inc


4) Party!!!


-John


On Jul 24, 2011, at 4:03 PM, Mike Buck wrote:

**
Thank you

I'll take a look.

Kind regards

On Sun, Jul 24, 2011 at 11:59 AM, Misi Mladoniczky m...@rrr.se wrote:
Hi,

We have a tool that can do something like that, and more.

It is called RRR|ArxToHTML, and can be downloaded from:
https://www.rrr.se/cgi/tools/main#rrrArxToHTML

You will get the best result if you have a def-file with the
form-definition, as it will allow the tool to sort field by the form
layout, use labels instead of database names, selection field values etc.
You will get a result list with the normal entry-list-fields and links to
individual records.

The quick way to use it to convert an ARX-file to a table is to run it
like this:
rrrArxToHTML.exe -a xxx.arx -glf ALL -l xxx.html

This will create a single HTML-file with a table including all fields of
the ARX-file.

   Best Regards - Misi, RRR AB, http://www.rrr.se

Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.

 It would be SO good to view ARX files, without having to import to the
 target form, in order see all the data.

 Is anyone willing to share a utility, or build one to share, which will
 parse an ARX file and present it in an easy to digest form?

 The data could be presented with column headers in notepad for example, or
 even better in Excel (similar to how a CSV file is presented).

 This would be a really fantastic tool for code reviews and carry out
 pre-deployment checks.

 I really do hope someone is able to help:)

 Thanks very much
 Mike

 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are

_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_

--
John Sundberg

Kinetic Data, Inc.
Building a Better Service Experience
Recipient of:
WWRUG10 Best Customer Service/Support Award
WWRUG09 Innovator of the Year Award

john.sundb...@kineticdata.com
651.556.0930  I  www.kineticdata.com









_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_



-- 
Best regards, Kirill

_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_

--
John Sundberg

Kinetic Data, Inc.
Building a Better Service Experience
Recipient of:
WWRUG10 Best Customer Service/Support Award
WWRUG09 Innovator of the Year Award

john.sundb...@kineticdata.com
651.556.0930  I  www.kineticdata.com










___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Re: ARX File Reader Utility

2011-07-29 Thread Grooms, Frederick W
I can see of a museum using Remedy to track their collections inventory and if 
an item is out on loan to another museum.

I think they picked January 1, 4713 B.C. as 0 for a DATE as it is also the 0 
for an Oracle Julian date

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of John Sundberg
Sent: Friday, July 29, 2011 11:12 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARX File Reader Utility


Question -- has ANYBODY -- EVER -- used any date in BC?

And if so -- why?

--
John Sundberg

Kinetic Data, Inc.
Building a Better Service Experience
Recipient of:
WWRUG10 Best Customer Service/Support Award
WWRUG09 Innovator of the Year Award
john.sundb...@kineticdata.com
651.556.0930  I  www.kineticdata.com


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kirill Eitvid
Sent: Friday, July 29, 2011 10:51 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARX File Reader Utility

** John,

as far I remember it's the number of days passed since 01.01.1970 for DATE and 
number of seconds since 01.01.1970 00:00:00 for DATETIME. Try it.


-Original Message-
On Fri, Jul 29, 2011 at 7:43 PM, John Sundberg  wrote:
** 
I am getting closer :)


If the .arx value of a DATE field is 2455767  

How does that get converted to human readable?

Meaning -- does anybody know the conversion strategy?


1) Upload (which gets parsed for field names, types etc...) 
https://skitch.com/johnsundberg/fc1ye/kinetic-data-inc

2) Select fields you want to see
https://skitch.com/johnsundberg/fct9m/kinetic-data-inc

3) View
https://skitch.com/johnsundberg/fct95/kinetic-data-inc


4) Party!!!


-John

--
John Sundberg

Kinetic Data, Inc.
Building a Better Service Experience
Recipient of:
WWRUG10 Best Customer Service/Support Award
WWRUG09 Innovator of the Year Award
john.sundb...@kineticdata.com
651.556.0930  I  www.kineticdata.com


-Original Message-
On Jul 24, 2011, at 4:03 PM, Mike Buck wrote:

** 
Thank you

I'll take a look.

Kind regards

-Original Message-
On Sun, Jul 24, 2011 at 11:59 AM, Misi Mladoniczky  wrote:
Hi,

We have a tool that can do something like that, and more.

It is called RRR|ArxToHTML, and can be downloaded from:
https://www.rrr.se/cgi/tools/main#rrrArxToHTML

You will get the best result if you have a def-file with the
form-definition, as it will allow the tool to sort field by the form
layout, use labels instead of database names, selection field values etc.
You will get a result list with the normal entry-list-fields and links to
individual records.

The quick way to use it to convert an ARX-file to a table is to run it
like this:
rrrArxToHTML.exe -a xxx.arx -glf ALL -l xxx.html

This will create a single HTML-file with a table including all fields of
the ARX-file.

       Best Regards - Misi, RRR AB, http://www.rrr.se

Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.

-Original Message-
 It would be SO good to view ARX files, without having to import to the
 target form, in order see all the data.

 Is anyone willing to share a utility, or build one to share, which will
 parse an ARX file and present it in an easy to digest form?

 The data could be presented with column headers in notepad for example, or
 even better in Excel (similar to how a CSV file is presented).

 This would be a really fantastic tool for code reviews and carry out
 pre-deployment checks.

 I really do hope someone is able to help:)

 Thanks very much
 Mike

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Re: ARX File Reader Utility

2011-07-29 Thread John Sundberg
OK - a bit of digging on dates and 4713 -- it appears to be a Julian date.


Solved:

Ruby 


require 'Date'

jruby-1.6.3 :024  Date.jd_to_civil(2455767)
 = [2011, 7, 24] 




-John



On Jul 29, 2011, at 12:01 PM, Grooms, Frederick W wrote:

From the Docs

Date and time fields 
There are three types of date and time fields: 

Date/time fields   
Store calendar dates and time together. You can set the display type to Date 
Only or Time Only so that the user sees only the date or time.
AR System stores date/time values as the integer number of seconds since 
00:00:00 GMT, January 1, 1970. Dates from January 1, 1970 through January 18, 
2038 GMT are valid in date/time fields. 

If the user enters only a time, then the current date is assumed. If the user 
enters only a date, then the time defaults to 12:00:00 AM. 

Date fields   
Store date information only, as the number of days from the beginning of its 
range. Use a Date field when you want to compare two dates or perform 
calculations based on the date, such as calculating the number of days between 
two dates. Users can enter dates from January 1, 4713 B.C. to January 1,  
A.D. in the Date field.

Time fields   
Store time information only, as the number of seconds from 12:00:00 AM. Use a 
time field to compare two times or perform calculations based on time, such as 
the number of seconds elapsed. 
The value in a time field is independent of the time zone. While a date/time 
field adjusts the displayed value to reflect the user's time zone, the time 
value in a time field remains unchanged when displayed on the client. 

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kirill Eitvid
Sent: Friday, July 29, 2011 10:51 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARX File Reader Utility

** John,

as far I remember it's the number of days passed since 01.01.1970 for DATE and 
number of seconds since 01.01.1970 00:00:00 for DATETIME. Try it.


-Original Message-
On Fri, Jul 29, 2011 at 7:43 PM, John Sundberg  wrote:
** 
I am getting closer :)


If the .arx value of a DATE field is 2455767  

How does that get converted to human readable?

Meaning -- does anybody know the conversion strategy?


1) Upload (which gets parsed for field names, types etc...) 
https://skitch.com/johnsundberg/fc1ye/kinetic-data-inc

2) Select fields you want to see
https://skitch.com/johnsundberg/fct9m/kinetic-data-inc

3) View
https://skitch.com/johnsundberg/fct95/kinetic-data-inc


4) Party!!!


-John

--
John Sundberg

Kinetic Data, Inc.
Building a Better Service Experience
Recipient of:
WWRUG10 Best Customer Service/Support Award
WWRUG09 Innovator of the Year Award
john.sundb...@kineticdata.com
651.556.0930  I  www.kineticdata.com


-Original Message-
On Jul 24, 2011, at 4:03 PM, Mike Buck wrote:

** 
Thank you

I'll take a look.

Kind regards

-Original Message-
On Sun, Jul 24, 2011 at 11:59 AM, Misi Mladoniczky  wrote:
Hi,

We have a tool that can do something like that, and more.

It is called RRR|ArxToHTML, and can be downloaded from:
https://www.rrr.se/cgi/tools/main#rrrArxToHTML

You will get the best result if you have a def-file with the
form-definition, as it will allow the tool to sort field by the form
layout, use labels instead of database names, selection field values etc.
You will get a result list with the normal entry-list-fields and links to
individual records.

The quick way to use it to convert an ARX-file to a table is to run it
like this:
rrrArxToHTML.exe -a xxx.arx -glf ALL -l xxx.html

This will create a single HTML-file with a table including all fields of
the ARX-file.

   Best Regards - Misi, RRR AB, http://www.rrr.se

Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.

-Original Message-
 It would be SO good to view ARX files, without having to import to the
 target form, in order see all the data.
 
 Is anyone willing to share a utility, or build one to share, which will
 parse an ARX file and present it in an easy to digest form?
 
 The data could be presented with column headers in notepad for example, or
 even better in Excel (similar to how a CSV file is presented).
 
 This would be a really fantastic tool for code reviews and carry out
 pre-deployment checks.
 
 I really do hope someone is able to help:)
 
 Thanks very much
 Mike

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are

--
John Sundberg

Kinetic Data, Inc.
Building a Better Service Experience
Recipient of:
WWRUG10 Best Customer Service/Support Award
WWRUG09 Innovator of the Year Award

john.sundb...@kineticdata.com
651.556.0930  I  www.kineticdata.com


Re: ARX File Reader Utility

2011-07-29 Thread LJ LongWing
Kirill,

You are correct for Date/Time, but not Date..another post provided the
correct information.

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kirill Eitvid
Sent: Friday, July 29, 2011 9:51 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARX File Reader Utility

 

** John,

 

as far I remember it's the number of days passed since 01.01.1970 for DATE
and number of seconds since 01.01.1970 00:00:00 for DATETIME. Try it.

 

On Fri, Jul 29, 2011 at 7:43 PM, John Sundberg
john.sundb...@kineticdata.com wrote:

** 

I am getting closer :)

 

 

If the .arx value of a DATE field is 2455767  

 

How does that get converted to human readable?

 

Meaning -- does anybody know the conversion strategy?

 

 

1) Upload (which gets parsed for field names, types etc...) 

https://skitch.com/johnsundberg/fc1ye/kinetic-data-inc

 

2) Select fields you want to see

https://skitch.com/johnsundberg/fct9m/kinetic-data-inc

 

3) View

https://skitch.com/johnsundberg/fct95/kinetic-data-inc

 

 

4) Party!!!

 

 

-John

 

 

On Jul 24, 2011, at 4:03 PM, Mike Buck wrote:


** 

Thank you

 

I'll take a look.

 

Kind regards

 

On Sun, Jul 24, 2011 at 11:59 AM, Misi Mladoniczky m...@rrr.se wrote:

Hi,

We have a tool that can do something like that, and more.

It is called RRR|ArxToHTML, and can be downloaded from:
https://www.rrr.se/cgi/tools/main#rrrArxToHTML

You will get the best result if you have a def-file with the
form-definition, as it will allow the tool to sort field by the form
layout, use labels instead of database names, selection field values etc.
You will get a result list with the normal entry-list-fields and links to
individual records.

The quick way to use it to convert an ARX-file to a table is to run it
like this:
rrrArxToHTML.exe -a xxx.arx -glf ALL -l xxx.html

This will create a single HTML-file with a table including all fields of
the ARX-file.

   Best Regards - Misi, RRR AB, http://www.rrr.se http://www.rrr.se/ 

Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.


 It would be SO good to view ARX files, without having to import to the
 target form, in order see all the data.

 Is anyone willing to share a utility, or build one to share, which will
 parse an ARX file and present it in an easy to digest form?

 The data could be presented with column headers in notepad for example, or
 even better in Excel (similar to how a CSV file is presented).

 This would be a really fantastic tool for code reviews and carry out
 pre-deployment checks.

 I really do hope someone is able to help:)

 Thanks very much
 Mike




___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
http://www.arslist.org/ 
 attend wwrug11 www.wwrug.com http://www.wwrug.com/  ARSList: Where the
Answers Are



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
http://www.arslist.org/ 
attend wwrug11 www.wwrug.com http://www.wwrug.com/  ARSList: Where the
Answers Are


_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ 

 

--

John Sundberg

Kinetic Data, Inc.
Building a Better Service Experience
Recipient of:

WWRUG10 Best Customer Service/Support Award

WWRUG09 Innovator of the Year Award

john.sundb...@kineticdata.com
651.556.0930  I   http://www.kineticdata.com/ www.kineticdata.com

 

 

 

 

 

 

 

 

_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ 




-- 
Best regards, Kirill

_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Re: ARX File Reader Utility

2011-07-29 Thread Rick Cook
To track the last time the Cubs won a World Series.

Rick
On Jul 29, 2011 9:12 AM, John Sundberg john.sundb...@kineticdata.com
wrote:


 Question -- has ANYBODY -- EVER -- used any date in BC?

 And if so -- why?



 -John


 On Jul 29, 2011, at 11:50 AM, Kirill Eitvid wrote:

 ** John,

 as far I remember it's the number of days passed since 01.01.1970 for DATE
and number of seconds since 01.01.1970 00:00:00 for DATETIME. Try it.

 On Fri, Jul 29, 2011 at 7:43 PM, John Sundberg 
john.sundb...@kineticdata.com wrote:
 **
 I am getting closer :)


 If the .arx value of a DATE field is 2455767 

 How does that get converted to human readable?

 Meaning -- does anybody know the conversion strategy?


 1) Upload (which gets parsed for field names, types etc...)
 https://skitch.com/johnsundberg/fc1ye/kinetic-data-inc

 2) Select fields you want to see
 https://skitch.com/johnsundberg/fct9m/kinetic-data-inc

 3) View
 https://skitch.com/johnsundberg/fct95/kinetic-data-inc


 4) Party!!!


 -John


 On Jul 24, 2011, at 4:03 PM, Mike Buck wrote:

 **
 Thank you

 I'll take a look.

 Kind regards

 On Sun, Jul 24, 2011 at 11:59 AM, Misi Mladoniczky m...@rrr.se wrote:
 Hi,

 We have a tool that can do something like that, and more.

 It is called RRR|ArxToHTML, and can be downloaded from:
 https://www.rrr.se/cgi/tools/main#rrrArxToHTML

 You will get the best result if you have a def-file with the
 form-definition, as it will allow the tool to sort field by the form
 layout, use labels instead of database names, selection field values etc.
 You will get a result list with the normal entry-list-fields and links to
 individual records.

 The quick way to use it to convert an ARX-file to a table is to run it
 like this:
 rrrArxToHTML.exe -a xxx.arx -glf ALL -l xxx.html

 This will create a single HTML-file with a table including all fields of
 the ARX-file.

 Best Regards - Misi, RRR AB, http://www.rrr.se

 Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
 * RRR|License - Not enough Remedy licenses? Save money by optimizing.
 * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.

 It would be SO good to view ARX files, without having to import to the
 target form, in order see all the data.

 Is anyone willing to share a utility, or build one to share, which will
 parse an ARX file and present it in an easy to digest form?

 The data could be presented with column headers in notepad for example,
or
 even better in Excel (similar to how a CSV file is presented).

 This would be a really fantastic tool for code reviews and carry out
 pre-deployment checks.

 I really do hope someone is able to help:)

 Thanks very much
 Mike


___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 attend wwrug11 www.wwrug.com ARSList: Where the Answers Are



___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 attend wwrug11 www.wwrug.com ARSList: Where the Answers Are

 _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_

 --
 John Sundberg

 Kinetic Data, Inc.
 Building a Better Service Experience
 Recipient of:
 WWRUG10 Best Customer Service/Support Award
 WWRUG09 Innovator of the Year Award

 john.sundb...@kineticdata.com
 651.556.0930 I www.kineticdata.com









 _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_



 --
 Best regards, Kirill

 _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_

 --
 John Sundberg

 Kinetic Data, Inc.
 Building a Better Service Experience
 Recipient of:
 WWRUG10 Best Customer Service/Support Award
 WWRUG09 Innovator of the Year Award

 john.sundb...@kineticdata.com
 651.556.0930 I www.kineticdata.com











___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 attend wwrug11 www.wwrug.com ARSList: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Re: ARX File Reader Utility

2011-07-29 Thread LJ LongWing
J..if I were building an application that tracked historical figures, and
needed to track the birth date of those figures, I would need a date field
that allowed for BC values..I believe the basis for this value was based on
the Julias calendar..where 'day one' is over 6000 years ago..and since
dealing with only the number of days.you can really go back as far as you
want J

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of John Sundberg
Sent: Friday, July 29, 2011 10:12 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARX File Reader Utility

 

** 

 

 

Question -- has ANYBODY -- EVER -- used any date in BC?

 

And if so -- why?

 

 

 

-John

 

 

On Jul 29, 2011, at 11:50 AM, Kirill Eitvid wrote:


** John,

 

as far I remember it's the number of days passed since 01.01.1970 for DATE
and number of seconds since 01.01.1970 00:00:00 for DATETIME. Try it.

 

On Fri, Jul 29, 2011 at 7:43 PM, John Sundberg
john.sundb...@kineticdata.com wrote:

** 

I am getting closer :)

 

 

If the .arx value of a DATE field is 2455767  

 

How does that get converted to human readable?

 

Meaning -- does anybody know the conversion strategy?

 

 

1) Upload (which gets parsed for field names, types etc...) 

https://skitch.com/johnsundberg/fc1ye/kinetic-data-inc

 

2) Select fields you want to see

https://skitch.com/johnsundberg/fct9m/kinetic-data-inc

 

3) View

https://skitch.com/johnsundberg/fct95/kinetic-data-inc

 

 

4) Party!!!

 

 

-John

 

 

On Jul 24, 2011, at 4:03 PM, Mike Buck wrote:


** 

Thank you

 

I'll take a look.

 

Kind regards

 

On Sun, Jul 24, 2011 at 11:59 AM, Misi Mladoniczky m...@rrr.se wrote:

Hi,

We have a tool that can do something like that, and more.

It is called RRR|ArxToHTML, and can be downloaded from:
https://www.rrr.se/cgi/tools/main#rrrArxToHTML

You will get the best result if you have a def-file with the
form-definition, as it will allow the tool to sort field by the form
layout, use labels instead of database names, selection field values etc.
You will get a result list with the normal entry-list-fields and links to
individual records.

The quick way to use it to convert an ARX-file to a table is to run it
like this:
rrrArxToHTML.exe -a xxx.arx -glf ALL -l xxx.html

This will create a single HTML-file with a table including all fields of
the ARX-file.

   Best Regards - Misi, RRR AB, http://www.rrr.se http://www.rrr.se/ 

Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.


 It would be SO good to view ARX files, without having to import to the
 target form, in order see all the data.

 Is anyone willing to share a utility, or build one to share, which will
 parse an ARX file and present it in an easy to digest form?

 The data could be presented with column headers in notepad for example, or
 even better in Excel (similar to how a CSV file is presented).

 This would be a really fantastic tool for code reviews and carry out
 pre-deployment checks.

 I really do hope someone is able to help:)

 Thanks very much
 Mike




___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
http://www.arslist.org/ 
 attend wwrug11 www.wwrug.com http://www.wwrug.com/  ARSList: Where the
Answers Are



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
http://www.arslist.org/ 
attend wwrug11 www.wwrug.com http://www.wwrug.com/  ARSList: Where the
Answers Are


_attend WWRUG11 www.wwrug.com http://www.wwrug.com/  ARSlist: Where the
Answers Are_ 

 

--

John Sundberg

Kinetic Data, Inc.
Building a Better Service Experience
Recipient of:

WWRUG10 Best Customer Service/Support Award

WWRUG09 Innovator of the Year Award

john.sundb...@kineticdata.com
651.556.0930  I   http://www.kineticdata.com/ www.kineticdata.com

 

 

 

 

 

 





 

_attend WWRUG11 www.wwrug.com http://www.wwrug.com/  ARSlist: Where the
Answers Are_ 




-- 
Best regards, Kirill

_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ 

 

--

John Sundberg

Kinetic Data, Inc.
Building a Better Service Experience
Recipient of:

WWRUG10 Best Customer Service/Support Award

WWRUG09 Innovator of the Year Award

john.sundb...@kineticdata.com
651.556.0930  I   http://www.kineticdata.com/ www.kineticdata.com

 

 

 

 

 

 





 

_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


7.6.4 MidTier URL To Incident

2011-07-29 Thread Frank Caruso
ARS 7.6.4
ITSM 7.6.4

I know how to use a URL to open an Incident in a new browser window.
But is there a way to structure a URL so that it opens the incident
record in a Frame in an existing window?

The ITSM 7.6.4 application opens incidents (form a table field) into a
View field on the Overview console form. The URL does not change.
Provide the user a link to an incident which opens in the View field
on Overview console.

Thank you

Frank

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Unisys is looking for a Client Architect with strong BMC Remedy ITSM and SaaS expertise for client-facing solutions role (position is virtual)

2011-07-29 Thread Blumberg, Adam Ross
I am actively recruiting for Unisys and we are looking to identify a Client 
Architect with strong BMC Remedy ITSM and SaaS expertise for this new role.   
Please review the position description below (I have also  attached a copy for 
your convenience).  If you feel your background meets the requirements for  
this opportunity, or if you know of someone who you think would be a strong 
candidate for this role, I appreciate your contacting me directly at 
adam.blumb...@unisys.commailto:adam.blumb...@unisys.com

CLIENT ARCHITECT - Unisys
The location of the role is virtual - Home Based (your home office)
The Client Architect is responsible for scoping, sizing and constructing the 
solution.  This includes creating and updating the standard solution as 
required for all configurations of the SaaS offering.  This is a client facing 
role and therefore this person must have excellent communication skills and be 
customer service oriented.  Deep understanding of SaaS and Remedy ITSM a must.  
Understanding of overall integration technology required.  Customer focus 
skills a must.

-   The Client Architect will act as a recognized authority for leading the 
solution processes of IT Outsourcing sourcing engagements with 
Multinational/theater clients.

-   This critical role supports the regional and global business by driving 
increased win rates for new clients and improving the Unisys ITSM SaaS adoption 
across existing accounts.

-   Within this role, the Architect will create unique value to Unisys 
Outsourcing clients through the development of solutions that utilize our 
standard portfolio offerings whilst applying a consistent solution architecture 
methodology to drive requirements based solution approach.
The Client Architect must have a strong understanding of BMC Remedy and be 
capable of providing the assessment of client requirements, and in turn 
develop, with the architects team, the integrated ( the technical, business and 
service solutions), whilst leading the development of cost estimates and 
commercial solutions. All in order to create a high value service solution to 
the client,
Specific Accountabilities Include (but not limited to):
* Leads the writing of the solution overview and presents the Unisys solution 
to the client;
* Leads the Solution Verification Review (Blue Team Review)
* Coordinates the costing of the Unisys solution, and Customer requirement 
management
* Provides input for internal (e.g. IRT and DRB) and external (e.g. executive 
summary) documentation
* Provides input into the contractual terms and conditions (e.g. SLA 
achievement)
* Participates in the definition of the solution strategy
* Assists Commercial manager with risk management processes and leading 
assumption setting and contingency definitions
* Provides input into the creation of the Statement of Work
* Leads solution review sessions and participation in contract, HR, SLA and SoW 
negotiation




Candidate Qualifications:

 The Client Architect must have:
-  Strong understanding of ITO managed services portfolio offerings and be 
capable of providing the assessment of client requirements, and  the integrated 
 technical, business and service solutions.
-Strong solution design experience, business expertise, and commercial acumen 
to develop leading solutions across Regional and global clients.
-Extensive experience in implementation and planning of BMC Remedy ITSM 
solutions.
- BMC Remedy training certifications
-Deep understanding of integration capabilities.
-Skill in systems mgmt, infrastructure planning, engineering architecture
- Excellent customer service skills a must
- B.S. degree required.
Specific Skills Required:

-   At least 7 years in total working with the BMC AR System and 4 years 
working with the BMC Remedy ITSM applications:  BMC Remedy AR System 
Administration, including all aspects of best practice architecture design, IT 
Service Management 6-7.X Suite including SLM and SRM.  Must have previous hands 
on experience Administering, implementing, and configuring AR System / ITSM
Skills Preferred:
 Formal BMC/Remedy AR System Administration training, Previous Remedy 
Authorized Consultant (RAC) Certification, ITIL: Knowledge, BMC IT Service 
Management 7.5 exposure, ADDM and BPPM exposure.





Adam Blumberg  |  Director, Global Recruiting  |  Corporate Recruiting

Unisys | 801 Lakeview Drive, Ste 100 | Blue Bell, PA 19422 | 215 986 4696 
(Office) | 215 316 1392 (Cell)


[cid:image001.gif@01CC4DED.50745190]


THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY 
MATERIAL and is thus for use only by the intended recipient. If you received 
this in error, please contact the sender and delete the e-mail and its 
attachments from all computers.




___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
inline: 

Re: ARX File Reader Utility - really - date only fields

2011-07-29 Thread Ben Chernys
There are ASR API functions to convert a date field.  

Date fields come in at least three different formats (values and algorithms) 
and so the only way to be accurate is to use the ARS API function.

The date is actually an int of the number of days from
January 1, 4713 BC to January 1,  AD

Date/Time fields and universal and can use the standard time functons to be 
converted.

Cheers
Ben

- --- Original Message --- -
From: Kirill Eitvid
kirill.eit...@gmail.com
To:   arslist@ARSLIST.ORG
Sent: Fri, 29 Jul 2011 19:50:46

John,

as far I remember it's the number of days passed
since 01.01.1970 for DATE
and number of seconds since 01.01.1970 00:00:00 for
DATETIME. Try it.

On Fri, Jul 29, 2011 at 7:43 PM, John Sundberg 
john.sundb...@kineticdata.com wrote:

 **
 I am getting closer :)


 If the .arx value of a DATE field is 2455767 


 How does that get converted to human readable?

 Meaning -- does anybody know the conversion
strategy?


 1) Upload (which gets parsed for field names,
types etc...)

https://skitch.com/johnsundberg/fc1ye/kinetic-data-
inc

 2) Select fields you want to see

https://skitch.com/johnsundberg/fct9m/kinetic-data-
inc

 3) View

https://skitch.com/johnsundberg/fct95/kinetic-data-
inc


 4) Party!!!


 -John


 On Jul 24, 2011, at 4:03 PM, Mike Buck wrote:

 **
 Thank you

 I'll take a look.

 Kind regards

 On Sun, Jul 24, 2011 at 11:59 AM, Misi
Mladoniczky m...@rrr.se wrote:

 Hi,

 We have a tool that can do something like that,
and more.

 It is called RRR|ArxToHTML, and can be
downloaded from:
 https://www.rrr.se/cgi/tools/main#rrrArxToHTML

 You will get the best result if you have a
def-file with the
 form-definition, as it will allow the tool to
sort field by the form
 layout, use labels instead of database names,
selection field values etc.
 You will get a result list with the normal
entry-list-fields and links to
 individual records.

 The quick way to use it to convert an ARX-file
to a table is to run it
 like this:
 rrrArxToHTML.exe -a xxx.arx -glf ALL -l xxx.html


 This will create a single HTML-file with a table
including all fields of
 the ARX-file.

Best Regards - Misi, RRR AB,
http://www.rrr.se

 Products from RRR Scandinavia (Best R.O.I. Award
at WWRUG10):
 * RRR|License - Not enough Remedy licenses? Save
money by optimizing.
 * RRR|Log - Performance issues or elusive bugs?
Analyze your Remedy logs.

  It would be SO good to view ARX files, without
having to import to the
  target form, in order see all the data.
 
  Is anyone willing to share a utility, or build
one to share, which will
  parse an ARX file and present it in an easy to
digest form?
 
  The data could be presented with column
headers in notepad for example,
 or
  even better in Excel (similar to how a CSV
file is presented).
 
  This would be a really fantastic tool for code
reviews and carry out
  pre-deployment checks.
 
  I really do hope someone is able to help:)
 
  Thanks very much
  Mike
 
 

___

  UNSUBSCRIBE or access ARSlist Archives at
www.arslist.org
  attend wwrug11 www.wwrug.com ARSList: Where
the Answers Are
 



___

 UNSUBSCRIBE or access ARSlist Archives at
www.arslist.org
 attend wwrug11 www.wwrug.com ARSList: Where the
Answers Are


 _attend WWRUG11 www.wwrug.com ARSlist: Where the
Answers Are_

 --
 John Sundberg

 Kinetic Data, Inc.
 Building a Better Service Experience
 Recipient of:
 WWRUG10 Best Customer Service/Support Award
 WWRUG09 Innovator of the Year Award

 john.sundb...@kineticdata.com
 651.556.0930  I  www.kineticdata.com









 _attend WWRUG11 www.wwrug.com ARSlist: Where the
Answers Are_




-- 
Best regards, Kirill

___

UNSUBSCRIBE or access ARSlist Archives at
www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the
Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Re: Crystal Reports and Labels

2011-07-29 Thread jham36
I think the labels are just used for display and not when referencing 
anything in the database.  The database name or id would be used.  You can 
even change the label in crystal to something different from what is used in 
Remedy - remove the asterisk if you want.

James

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Re: ARX File Reader Utility - really - date only fields

2011-07-29 Thread Ben Chernys
Addendum:

To call these f()s you do NOT need to have a filled in ARControl struct.  

These f() ignore the control struct and it seems I pass a ptr to random memory 
to the f()

//   from ar.h:
typedef struct ARDateStruct {
  int   year;  /* range: -4912 to  */
  int   month; /* range: 1 to 12   */
  int   day;   /* range: 1 to 31   */
 } ARDateStruct;
  rc =  ARJulianDateToDate(...);

Cheers
Ben
- --- Original Message --- -
From: ben.cher...@softwaretoolhouse.com
To: arslist@ARSLIST.ORG
Sent: Fri, 29 Jul 2011 19:59:38

There are ASR API functions to convert a date
field.  

Date fields come in at least three different
formats (values and algorithms) and so the only way
to be accurate is to use the ARS API function.

The date is actually an int of the number of days
from
January 1, 4713 BC to January 1,  AD

Date/Time fields and universal and can use the
standard time functons to be converted.

Cheers
Ben

- --- Original Message --- -
From: Kirill Eitvid
kirill.eit...@gmail.com
To:   arslist@ARSLIST.ORG
Sent: Fri, 29 Jul 2011 19:50:46

John,

as far I remember it's the number of days passed
since 01.01.1970 for DATE
and number of seconds since 01.01.1970 00:00:00
for
DATETIME. Try it.

On Fri, Jul 29, 2011 at 7:43 PM, John Sundberg 
john.sundb...@kineticdata.com wrote:

 **
 I am getting closer :)


 If the .arx value of a DATE field is 2455767



 How does that get converted to human readable?

 Meaning -- does anybody know the conversion
strategy?


 1) Upload (which gets parsed for field names,
types etc...)

https://skitch.com/johnsundberg/fc1ye/kinetic-data
-
inc

 2) Select fields you want to see

https://skitch.com/johnsundberg/fct9m/kinetic-data
-
inc

 3) View

https://skitch.com/johnsundberg/fct95/kinetic-data
-
inc


 4) Party!!!


 -John


 On Jul 24, 2011, at 4:03 PM, Mike Buck wrote:

 **
 Thank you

 I'll take a look.

 Kind regards

 On Sun, Jul 24, 2011 at 11:59 AM, Misi
Mladoniczky m...@rrr.se wrote:

 Hi,

 We have a tool that can do something like that,

and more.

 It is called RRR|ArxToHTML, and can be
downloaded from:
 https://www.rrr.se/cgi/tools/main#rrrArxToHTML

 You will get the best result if you have a
def-file with the
 form-definition, as it will allow the tool to
sort field by the form
 layout, use labels instead of database names,
selection field values etc.
 You will get a result list with the normal
entry-list-fields and links to
 individual records.

 The quick way to use it to convert an ARX-file
to a table is to run it
 like this:
 rrrArxToHTML.exe -a xxx.arx -glf ALL -l
xxx.html


 This will create a single HTML-file with a
table
including all fields of
 the ARX-file.

Best Regards - Misi, RRR AB,
http://www.rrr.se

 Products from RRR Scandinavia (Best R.O.I.
Award
at WWRUG10):
 * RRR|License - Not enough Remedy licenses?
Save
money by optimizing.
 * RRR|Log - Performance issues or elusive bugs?

Analyze your Remedy logs.

  It would be SO good to view ARX files,
without
having to import to the
  target form, in order see all the data.
 
  Is anyone willing to share a utility, or
build
one to share, which will
  parse an ARX file and present it in an easy
to
digest form?
 
  The data could be presented with column
headers in notepad for example,
 or
  even better in Excel (similar to how a CSV
file is presented).
 
  This would be a really fantastic tool for
code
reviews and carry out
  pre-deployment checks.
 
  I really do hope someone is able to help:)
 
  Thanks very much
  Mike
 
 

__
_

  UNSUBSCRIBE or access ARSlist Archives at
www.arslist.org
  attend wwrug11 www.wwrug.com ARSList: Where
the Answers Are
 



__
_

 UNSUBSCRIBE or access ARSlist Archives at
www.arslist.org
 attend wwrug11 www.wwrug.com ARSList: Where
the
Answers Are


 _attend WWRUG11 www.wwrug.com ARSlist: Where
the
Answers Are_

 --
 John Sundberg

 Kinetic Data, Inc.
 Building a Better Service Experience
 Recipient of:
 WWRUG10 Best Customer Service/Support Award
 WWRUG09 Innovator of the Year Award

 john.sundb...@kineticdata.com
 651.556.0930  I  www.kineticdata.com









 _attend WWRUG11 www.wwrug.com ARSlist: Where
the
Answers Are_




-- 
Best regards, Kirill

__
_

UNSUBSCRIBE or access ARSlist Archives at
www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the
Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Re: ARX File Reader Utility

2011-07-29 Thread Ben Chernys
Again, if you research Julian dates you will see that there are several 
different commonly accepted algorithms - all yeilding different results.

I personally would not trust that the Ruby alogorithm matches the ARS 
algorithm.  So, I would tend to use the ARS algorithm since they have a nice 
f() for converting it anyhow.

I don't mind supplying a small binary that converts these types of dates and 
you can check random (arbirary) dates against Ruby and the binary to see that 
the returned values match (especially for the negative numbers).  Contact me 
off-list if you want it.  It will require API dlls/so and all dependencies of 
that as these incidental functions are not separated in the AR API libs.

Cheers
Ben

- --- Original Message --- -
From: :arslist@ARSLIST.ORG
To: arslist@ARSLIST.ORG
Sent: Fri, 29 Jul 2011 12:26:14

OK - a bit of digging on dates and 4713 -- it
appears to be a Julian date.


Solved:

Ruby 


require 'Date'

jruby-1.6.3 :024  Date.jd_to_civil(2455767)
 = [2011, 7, 24] 




-John



On Jul 29, 2011, at 12:01 PM, Grooms, Frederick W
wrote:

From the Docs

Date and time fields 
There are three types of date and time fields: 

Date/time fields   
Store calendar dates and time together. You can set
the display type to Date Only or Time Only so that
the user sees only the date or time.
AR System stores date/time values as the integer
number of seconds since 00:00:00 GMT, January 1,
1970. Dates from January 1, 1970 through January
18, 2038 GMT are valid in date/time fields. 

If the user enters only a time, then the current
date is assumed. If the user enters only a date,
then the time defaults to 12:00:00 AM. 

Date fields   
Store date information only, as the number of days
from the beginning of its range. Use a Date field
when you want to compare two dates or perform
calculations based on the date, such as calculating
the number of days between two dates. Users can
enter dates from January 1, 4713 B.C. to January 1,
 A.D. in the Date field.

Time fields   
Store time information only, as the number of
seconds from 12:00:00 AM. Use a time field to
compare two times or perform calculations based on
time, such as the number of seconds elapsed. 
The value in a time field is independent of the
time zone. While a date/time field adjusts the
displayed value to reflect the user's time zone,
the time value in a time field remains unchanged
when displayed on the client. 

Fred

-Original Message-
From: Action Request System discussion
list(ARSList) [mailto:arslist@ARSLIST.ORG] On
Behalf Of Kirill Eitvid
Sent: Friday, July 29, 2011 10:51 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARX File Reader Utility

** John,

as far I remember it's the number of days passed
since 01.01.1970 for DATE and number of seconds
since 01.01.1970 00:00:00 for DATETIME. Try it.


-Original Message-
On Fri, Jul 29, 2011 at 7:43 PM, John Sundberg 
wrote:
** 
I am getting closer :)


If the .arx value of a DATE field is 2455767  

How does that get converted to human readable?

Meaning -- does anybody know the conversion
strategy?


1) Upload (which gets parsed for field names, types
etc...) 
https://skitch.com/johnsundberg/fc1ye/kinetic-data-
inc

2) Select fields you want to see
https://skitch.com/johnsundberg/fct9m/kinetic-data-
inc

3) View
https://skitch.com/johnsundberg/fct95/kinetic-data-
inc


4) Party!!!


-John

--
John Sundberg

Kinetic Data, Inc.
Building a Better Service Experience
Recipient of:
WWRUG10 Best Customer Service/Support Award
WWRUG09 Innovator of the Year Award
john.sundb...@kineticdata.com
651.556.0930  I  www.kineticdata.com


-Original Message-
On Jul 24, 2011, at 4:03 PM, Mike Buck wrote:

** 
Thank you

I'll take a look.

Kind regards

-Original Message-
On Sun, Jul 24, 2011 at 11:59 AM, Misi Mladoniczky 
wrote:
Hi,

We have a tool that can do something like that, and
more.

It is called RRR|ArxToHTML, and can be downloaded
from:
https://www.rrr.se/cgi/tools/main#rrrArxToHTML

You will get the best result if you have a def-file
with the
form-definition, as it will allow the tool to sort
field by the form
layout, use labels instead of database names,
selection field values etc.
You will get a result list with the normal
entry-list-fields and links to
individual records.

The quick way to use it to convert an ARX-file to a
table is to run it
like this:
rrrArxToHTML.exe -a xxx.arx -glf ALL -l xxx.html

This will create a single HTML-file with a table
including all fields of
the ARX-file.

   Best Regards - Misi, RRR AB,
http://www.rrr.se

Products from RRR Scandinavia (Best R.O.I. Award at
WWRUG10):
* RRR|License - Not enough Remedy licenses? Save
money by optimizing.
* RRR|Log - Performance issues or elusive bugs?
Analyze your Remedy logs.

-Original Message-
 It would be SO good to view ARX files, without
having to import to the
 target form, in order see all the data.
 
 Is anyone willing to share a utility, or build
one 

use telnet to verify remedy port 0 doesn't work

2011-07-29 Thread maggie2007
Hi All,

Usually we use telnet ip port to verify the connectivity.

But my local Remedy server is using port 0 with port mapper, where telnet
ip 0 doesn't work.

Anybody knows why?

Thanks a lot!

MZ
-- 
View this message in context: 
http://old.nabble.com/use-telnet-to-verify-remedy-port-0-doesn%27t-work-tp32161581p32161581.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Re: ARX File Reader Utility

2011-07-29 Thread John Sundberg
Ben,

Thx...

So far my testing is showing Ruby does a fine job with the Julian date 
conversion.

I am not so sure I am interested in a Remedy Julian function -- is that not the 
same group that wrote the nice GUID generator?

#_ included?

(It is  7 year old bug now)


-John




On Jul 29, 2011, at 2:52 PM, Ben Chernys wrote:

Again, if you research Julian dates you will see that there are several 
different commonly accepted algorithms - all yeilding different results.

I personally would not trust that the Ruby alogorithm matches the ARS 
algorithm.  So, I would tend to use the ARS algorithm since they have a nice 
f() for converting it anyhow.

I don't mind supplying a small binary that converts these types of dates and 
you can check random (arbirary) dates against Ruby and the binary to see that 
the returned values match (especially for the negative numbers).  Contact me 
off-list if you want it.  It will require API dlls/so and all dependencies of 
that as these incidental functions are not separated in the AR API libs.

Cheers
Ben

 - --- Original Message --- -
 From: :arslist@ARSLIST.ORG
 To: arslist@ARSLIST.ORG
 Sent: Fri, 29 Jul 2011 12:26:14
 
 OK - a bit of digging on dates and 4713 -- it
 appears to be a Julian date.
 
 
 Solved:
 
 Ruby 
 
 
 require 'Date'
 
 jruby-1.6.3 :024  Date.jd_to_civil(2455767)
 = [2011, 7, 24] 
 
 
 
 
 -John
 
 
 
 On Jul 29, 2011, at 12:01 PM, Grooms, Frederick W
 wrote:
 
 From the Docs
 
 Date and time fields 
 There are three types of date and time fields: 
 
 Date/time fields   
 Store calendar dates and time together. You can set
 the display type to Date Only or Time Only so that
 the user sees only the date or time.
 AR System stores date/time values as the integer
 number of seconds since 00:00:00 GMT, January 1,
 1970. Dates from January 1, 1970 through January
 18, 2038 GMT are valid in date/time fields. 
 
 If the user enters only a time, then the current
 date is assumed. If the user enters only a date,
 then the time defaults to 12:00:00 AM. 
 
 Date fields   
 Store date information only, as the number of days
 from the beginning of its range. Use a Date field
 when you want to compare two dates or perform
 calculations based on the date, such as calculating
 the number of days between two dates. Users can
 enter dates from January 1, 4713 B.C. to January 1,
  A.D. in the Date field.
 
 Time fields   
 Store time information only, as the number of
 seconds from 12:00:00 AM. Use a time field to
 compare two times or perform calculations based on
 time, such as the number of seconds elapsed. 
 The value in a time field is independent of the
 time zone. While a date/time field adjusts the
 displayed value to reflect the user's time zone,
 the time value in a time field remains unchanged
 when displayed on the client. 
 
 Fred
 
 -Original Message-
 From: Action Request System discussion
 list(ARSList) [mailto:arslist@ARSLIST.ORG] On
 Behalf Of Kirill Eitvid
 Sent: Friday, July 29, 2011 10:51 AM
 To: arslist@ARSLIST.ORG
 Subject: Re: ARX File Reader Utility
 
 ** John,
 
 as far I remember it's the number of days passed
 since 01.01.1970 for DATE and number of seconds
 since 01.01.1970 00:00:00 for DATETIME. Try it.
 
 
 -Original Message-
 On Fri, Jul 29, 2011 at 7:43 PM, John Sundberg 
 wrote:
 ** 
 I am getting closer :)
 
 
 If the .arx value of a DATE field is 2455767  
 
 How does that get converted to human readable?
 
 Meaning -- does anybody know the conversion
 strategy?
 
 
 1) Upload (which gets parsed for field names, types
 etc...) 
 https://skitch.com/johnsundberg/fc1ye/kinetic-data-
 inc
 
 2) Select fields you want to see
 https://skitch.com/johnsundberg/fct9m/kinetic-data-
 inc
 
 3) View
 https://skitch.com/johnsundberg/fct95/kinetic-data-
 inc
 
 
 4) Party!!!
 
 
 -John
 
 --
 John Sundberg
 
 Kinetic Data, Inc.
 Building a Better Service Experience
 Recipient of:
 WWRUG10 Best Customer Service/Support Award
 WWRUG09 Innovator of the Year Award
 john.sundb...@kineticdata.com
 651.556.0930  I  www.kineticdata.com
 
 
 -Original Message-
 On Jul 24, 2011, at 4:03 PM, Mike Buck wrote:
 
 ** 
 Thank you
 
 I'll take a look.
 
 Kind regards
 
 -Original Message-
 On Sun, Jul 24, 2011 at 11:59 AM, Misi Mladoniczky 
 wrote:
 Hi,
 
 We have a tool that can do something like that, and
 more.
 
 It is called RRR|ArxToHTML, and can be downloaded
 from:
 https://www.rrr.se/cgi/tools/main#rrrArxToHTML
 
 You will get the best result if you have a def-file
 with the
 form-definition, as it will allow the tool to sort
 field by the form
 layout, use labels instead of database names,
 selection field values etc.
 You will get a result list with the normal
 entry-list-fields and links to
 individual records.
 
 The quick way to use it to convert an ARX-file to a
 table is to run it
 like this:
 rrrArxToHTML.exe -a xxx.arx -glf ALL -l xxx.html
 
 This will create a single HTML-file with a 

Re: use telnet to verify remedy port 0 doesn't work

2011-07-29 Thread Brien Dieterle
port 0 means it is using the port mapper to dynamically assign any 
port.  You have to query the portmapper to find out what port it is on.  
Take a look at the rpcinfo command available on some OSes


http://technet.microsoft.com/en-us/library/cc779799%28WS.10%29.aspx

something like

rpcinfo -p yourserver

should return
   program vers proto   port
102   tcp111  portmapper
102   udp111  portmapper
3906001   tcp   4406
3906002   tcp   4406
3906003   tcp   4406
3906004   tcp   4406
3906005   tcp   4406
and so on

so try port 4406, in this example, as I believe 390600 is a remedy RPC 
program #


Hope that helps!

Brien






On 7/29/2011 12:00 PM, maggie2007 wrote:

Hi All,

Usually we use telnetip  port  to verify the connectivity.

But my local Remedy server is using port 0 with port mapper, where telnet
ip  0 doesn't work.

Anybody knows why?

Thanks a lot!

MZ


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Friday Humor

2011-07-29 Thread Murnane, Phil
All:

I received an email this week requesting a report of all upcoming scheduled and 
unscheduled maintenance.

:)
--Phil

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Re: Friday Humor

2011-07-29 Thread strauss
You could always send the reply back with all sorts of horrific unscheduled 
maintenance (catastrophic outages) on it... preferably for 2 August when some 
people think that the country will implode.  It depends a lot on the sense of 
humor that you _think_ the recipient has.

Christopher Strauss, Ph.D.
Call Tracking Administration Manager
University of North Texas Computing  IT Center
http://itsm.unt.edu/
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Murnane, Phil
Sent: Friday, July 29, 2011 2:17 PM
To: arslist@ARSLIST.ORG
Subject: Friday Humor

**
All:

I received an email this week requesting a report of all upcoming scheduled and 
unscheduled maintenance.

:)
--Phil
_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Re: ARX File Reader Utility

2011-07-29 Thread Ben Chernys
HI John

NO doubt it is the same group.  :)  

Hard to call an ARS GUID a GUID isn't it?  But if you mean the bug that they 
had of generating bad (SQL) characters, that was fixed.  If you mean that it 
ain't a GUID.  Well. What can we say about that?  They certainly did not copy 
the well document algorithms for generating a GUID now did they?  But then they 
did save a few bytes. :)

It really doesn't matter is the Remedy f() is right or wrong as long as any 
date you feed another f() returns the same integer that the Remedy f() expects 
and vice versa.  If you feed it to the Remedy f() that if there is an error it 
is the fault of the Remedy f().

I presume to test you have a small form that converts the integers to dates and 
vice versa and you compare these results with the Ruby f() returns.  

In any event, it is your utility, so it's your decision.  Just my two cents 
worth.

Meta-Update uses the ARS f() to convert date only fields and the standard c f() 
to convert date/time fields.

BTW: The word Julian used to mean something completly different - at least to 
me:  a readable date in the form YYDDD as used in mainframes before (and 
after!) Y2K - and yes, Meta-Update handles even these types of dates.

Given the history of ARS it is likely that they copied the Oracle algorithm 
anyhow.

Cheers
Ben

- --- Original Message --- -
From: John Sundberg
john.sundb...@kineticdata.com
To:   arslist@ARSLIST.ORG
Sent: Fri, 29 Jul 2011 15:09:21

Ben,

Thx...

So far my testing is showing Ruby does a fine job
with the Julian date conversion.

I am not so sure I am interested in a Remedy Julian
function -- is that not the same group that wrote
the nice GUID generator?

#_ included?

(It is  7 year old bug now)


-John




On Jul 29, 2011, at 2:52 PM, Ben Chernys wrote:

Again, if you research Julian dates you will see
that there are several different commonly accepted
algorithms - all yeilding different results.

I personally would not trust that the Ruby
alogorithm matches the ARS algorithm.  So, I would
tend to use the ARS algorithm since they have a
nice f() for converting it anyhow.

I don't mind supplying a small binary that converts
these types of dates and you can check random
(arbirary) dates against Ruby and the binary to see
that the returned values match (especially for the
negative numbers).  Contact me off-list if you want
it.  It will require API dlls/so and all
dependencies of that as these incidental functions
are not separated in the AR API libs.

Cheers
Ben

 - --- Original Message --- -
 From: :arslist@ARSLIST.ORG
 To: arslist@ARSLIST.ORG
 Sent: Fri, 29 Jul 2011 12:26:14
 
 OK - a bit of digging on dates and 4713 -- it
 appears to be a Julian date.
 
 
 Solved:
 
 Ruby 
 
 
 require 'Date'
 
 jruby-1.6.3 :024  Date.jd_to_civil(2455767)
 = [2011, 7, 24] 
 
 
 
 
 -John
 
 
 
 On Jul 29, 2011, at 12:01 PM, Grooms, Frederick W
 wrote:
 
 From the Docs
 
 Date and time fields 
 There are three types of date and time fields: 
 
 Date/time fields   
 Store calendar dates and time together. You can
set
 the display type to Date Only or Time Only so
that
 the user sees only the date or time.
 AR System stores date/time values as the integer
 number of seconds since 00:00:00 GMT, January 1,
 1970. Dates from January 1, 1970 through January
 18, 2038 GMT are valid in date/time fields. 
 
 If the user enters only a time, then the current
 date is assumed. If the user enters only a date,
 then the time defaults to 12:00:00 AM. 
 
 Date fields   
 Store date information only, as the number of
days
 from the beginning of its range. Use a Date field
 when you want to compare two dates or perform
 calculations based on the date, such as
calculating
 the number of days between two dates. Users can
 enter dates from January 1, 4713 B.C. to January
1,
  A.D. in the Date field.
 
 Time fields   
 Store time information only, as the number of
 seconds from 12:00:00 AM. Use a time field to
 compare two times or perform calculations based
on
 time, such as the number of seconds elapsed. 
 The value in a time field is independent of the
 time zone. While a date/time field adjusts the
 displayed value to reflect the user's time zone,
 the time value in a time field remains unchanged
 when displayed on the client. 
 
 Fred
 
 -Original Message-
 From: Action Request System discussion
 list(ARSList) [mailto:arslist@ARSLIST.ORG] On
 Behalf Of Kirill Eitvid
 Sent: Friday, July 29, 2011 10:51 AM
 To: arslist@ARSLIST.ORG
 Subject: Re: ARX File Reader Utility
 
 ** John,
 
 as far I remember it's the number of days passed
 since 01.01.1970 for DATE and number of seconds
 since 01.01.1970 00:00:00 for DATETIME. Try it.
 
 
 -Original Message-
 On Fri, Jul 29, 2011 at 7:43 PM, John Sundberg 
 wrote:
 ** 
 I am getting closer :)
 
 
 If the .arx value of a DATE field is 2455767 

 
 How does that get converted to human readable?
 
 Meaning -- does anybody 

Re: 7.6.4 MidTier URL To Incident

2011-07-29 Thread jham36
If you are using view fields, you should be able to use an active link to do 
a set fields to the view field.  Set it to the url of the incident.  I 
haven't tried it for this particular case, but I have used the set fields 
with a view field for other things.
I don't think you want to be clicking a url though - maybe a button or a 
selection from a table.

You should be able to find more info in the workflow guide.

James 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Friday Humor - 2

2011-07-29 Thread Phil Bautista
A U.S. Congressman was seated next to a Remedy Consultant on an airplane so
he turned to him and said, Do you want to talk? Flights go quicker if you
strike up a conversation with your fellow passenger.

Obviously annoyed, the Remedy Consultant, who had just started to read his
7.6.04 upgrade document, replied to the total stranger, What would you want
to talk about?

Oh, I don't know, said the congressman. How about global warming,
universal health care, or the debt ceiling? as he smiled smugly.

OK, he said. Those could be interesting topics, but let me ask you a
question first. A horse, a cow, and a deer all eat the same stuff - grass.
Yet a deer excretes little pellets, while a cow turns out a flat patty, and
a horse produces clumps. Why do you suppose that is?

The legislator, visibly surprised by the Remedy Consultant's intelligence,
thinks about it and says, Hmmm, I have no idea.

To which the Remedy Consultant replies, Do you really feel qualified to
discuss global warming, universal health care, or the economy, when you
don't know poop?

 

Think about this when you are on your plane to DC for WWRUG11 in September!

 

Phil Bautista, WWRUG11 Advisory Board

512-731-0304

http://www.linkedin.com/in/philbautista

 http://www.wwrug11.com/contact_phil.html
http://www.wwrug11.com/contact_phil.html

 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Re: Friday Humor - 2

2011-07-29 Thread Meyer, Jennifer L
That's a  good one, Phil.  Although I do know poop, I won't go on about it on 
this thread.

Jennifer Meyer
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Phil Bautista
Sent: Friday, July 29, 2011 4:52 PM
To: arslist@ARSLIST.ORG
Subject: Friday Humor - 2

**
A U.S. Congressman was seated next to a Remedy Consultant on an airplane so he 
turned to him and said, Do you want to talk? Flights go quicker if you strike 
up a conversation with your fellow passenger.

Obviously annoyed, the Remedy Consultant, who had just started to read his 
7.6.04 upgrade document, replied to the total stranger, What would you want to 
talk about?

Oh, I don't know, said the congressman. How about global warming, universal 
health care, or the debt ceiling? as he smiled smugly.

OK, he said. Those could be interesting topics, but let me ask you a 
question first. A horse, a cow, and a deer all eat the same stuff - grass. Yet 
a deer excretes little pellets, while a cow turns out a flat patty, and a horse 
produces clumps. Why do you suppose that is?

The legislator, visibly surprised by the Remedy Consultant's intelligence, 
thinks about it and says, Hmmm, I have no idea.

To which the Remedy Consultant replies, Do you really feel qualified to 
discuss global warming, universal health care, or the economy, when you don't 
know poop?

Think about this when you are on your plane to DC for WWRUG11 in September!

Phil Bautista, WWRUG11 Advisory Board
512-731-0304
http://www.linkedin.com/in/philbautista
http://www.wwrug11.com/contact_phil.html

_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_



E-mail correspondence to and from this address may be subject to the North 
Carolina Public Records Law and may be disclosed to third parties by an 
authorized state official.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Re: Friday Humor - 2

2011-07-29 Thread Stanley Feinstein
Hi Phil,

 

Someone once told me that if you sit next to any of the 535 people in
Congress on a plane that none would say hello.

 

Stan

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Phil Bautista
Sent: Friday, July 29, 2011 1:52 PM
To: arslist@ARSLIST.ORG
Subject: Friday Humor - 2

 

** 

A U.S. Congressman was seated next to a Remedy Consultant on an airplane so
he turned to him and said, Do you want to talk? Flights go quicker if you
strike up a conversation with your fellow passenger.

Obviously annoyed, the Remedy Consultant, who had just started to read his
7.6.04 upgrade document, replied to the total stranger, What would you want
to talk about?

Oh, I don't know, said the congressman. How about global warming,
universal health care, or the debt ceiling? as he smiled smugly.

OK, he said. Those could be interesting topics, but let me ask you a
question first. A horse, a cow, and a deer all eat the same stuff - grass.
Yet a deer excretes little pellets, while a cow turns out a flat patty, and
a horse produces clumps. Why do you suppose that is?

The legislator, visibly surprised by the Remedy Consultant's intelligence,
thinks about it and says, Hmmm, I have no idea.

To which the Remedy Consultant replies, Do you really feel qualified to
discuss global warming, universal health care, or the economy, when you
don't know poop?

 

Think about this when you are on your plane to DC for WWRUG11 in September!

 

Phil Bautista, WWRUG11 Advisory Board

512-731-0304

http://www.linkedin.com/in/philbautista

http://www.wwrug11.com/contact_phil.html

 

  _  

No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1390 / Virus Database: 1518/3796 - Release Date: 07/29/11

_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Write contents of a field to a file

2011-07-29 Thread Shafqat Ayaz
Hi All,
I was wondering what would be the best way to write the contents of a character 
field to a file? The search on the archive keeps on timing out so I am writing 
to the list.
To re-iterate I have a character field the contents of which I would like to 
write to a file in Windows environment. This will be done on the client and not 
the server.
I am looking  to do this only via the User Tool and not through the Mid-Tier at 
the moment.
User Tool v 7.6x, Windows any version ranging from XP to Windows 7, no Windows 
Vista.

Many thanks

 


Shafqat Ayaz   

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are

Re: Friday Humor - 2

2011-07-29 Thread bullcreek.com
Hi Stan,

I can believe that.  The exception to the rule would be the owner of the 
property next to me, the Hon. Lloyd Doggett who along with his wife, Libby, 
sent me (unsolicited) a flag flown over our Nation's Capitol building (with 
certificate) on the event of each of my Daughter's births as well as a personal 
(handwritten) letter of congratulations (he has daughters too) from both of 
them.  Very nice (and fiscally responsible) people and thoughtful considering I 
can't even vote for him (I am not in his district).

Phil Bautista
President / CEO
Bull Creek Data Corporation
www.bullcreek.com
Remedy Approved Consultant (RAC)
512-731-0304
-Original message-
From: Stanley Feinstein st...@projectremedies.com
Date: Fri, 29 Jul 2011 17:02:25 -0400
To: arslist@ARSLIST.ORG
Subject: Re: Friday Humor - 2

 Hi Phil,
 
  
 
 Someone once told me that if you sit next to any of the 535 people in
 Congress on a plane that none would say hello.
 
  
 
 Stan
 
  
 
 From: Action Request System discussion list(ARSList)
 [mailto:arslist@ARSLIST.ORG] On Behalf Of Phil Bautista
 Sent: Friday, July 29, 2011 1:52 PM
 To: arslist@ARSLIST.ORG
 Subject: Friday Humor - 2
 
  
 
 ** 
 
 A U.S. Congressman was seated next to a Remedy Consultant on an airplane so
 he turned to him and said, Do you want to talk? Flights go quicker if you
 strike up a conversation with your fellow passenger.
 
 Obviously annoyed, the Remedy Consultant, who had just started to read his
 7.6.04 upgrade document, replied to the total stranger, What would you want
 to talk about?
 
 Oh, I don't know, said the congressman. How about global warming,
 universal health care, or the debt ceiling? as he smiled smugly.
 
 OK, he said. Those could be interesting topics, but let me ask you a
 question first. A horse, a cow, and a deer all eat the same stuff - grass.
 Yet a deer excretes little pellets, while a cow turns out a flat patty, and
 a horse produces clumps. Why do you suppose that is?
 
 The legislator, visibly surprised by the Remedy Consultant's intelligence,
 thinks about it and says, Hmmm, I have no idea.
 
 To which the Remedy Consultant replies, Do you really feel qualified to
 discuss global warming, universal health care, or the economy, when you
 don't know poop?
 
  
 
 Think about this when you are on your plane to DC for WWRUG11 in September!
 
  
 
 Phil Bautista, WWRUG11 Advisory Board
 
 512-731-0304
 
 http://www.linkedin.com/in/philbautista
 
 http://www.wwrug11.com/contact_phil.html
 
  
 
   _  
 
 No virus found in this message.
 Checked by AVG - www.avg.com
 Version: 10.0.1390 / Virus Database: 1518/3796 - Release Date: 07/29/11
 
 _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ 
 
 
 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Re: Friday Humor - 2

2011-07-29 Thread Stanley Feinstein
Hi Phil,

I guess there's an exception to every rule.  I sat with a Congresswoman from
a district in Missouri once who was nice, but she thought that for most
part, that comment was right on.  She said the flaming nuts (her term)
(however you want to categorize their views on fiscal responsibility), some
of whom were on the same flight, wouldn't talk with anyone.

Have a good weekend Phil.

Stan

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of bullcreek.com
Sent: Friday, July 29, 2011 5:47 PM
To: arslist@ARSLIST.ORG
Subject: Re: Friday Humor - 2

Hi Stan,

I can believe that.  The exception to the rule would be the owner of the
property next to me, the Hon. Lloyd Doggett who along with his wife, Libby,
sent me (unsolicited) a flag flown over our Nation's Capitol building (with
certificate) on the event of each of my Daughter's births as well as a
personal (handwritten) letter of congratulations (he has daughters too) from
both of them.  Very nice (and fiscally responsible) people and thoughtful
considering I can't even vote for him (I am not in his district).

Phil Bautista
President / CEO
Bull Creek Data Corporation
www.bullcreek.com
Remedy Approved Consultant (RAC)
512-731-0304
-Original message-
From: Stanley Feinstein st...@projectremedies.com
Date: Fri, 29 Jul 2011 17:02:25 -0400
To: arslist@ARSLIST.ORG
Subject: Re: Friday Humor - 2

 Hi Phil,
 
  
 
 Someone once told me that if you sit next to any of the 535 people in
 Congress on a plane that none would say hello.
 
  
 
 Stan
 
  
 
 From: Action Request System discussion list(ARSList)
 [mailto:arslist@ARSLIST.ORG] On Behalf Of Phil Bautista
 Sent: Friday, July 29, 2011 1:52 PM
 To: arslist@ARSLIST.ORG
 Subject: Friday Humor - 2
 
  
 
 ** 
 
 A U.S. Congressman was seated next to a Remedy Consultant on an airplane
so
 he turned to him and said, Do you want to talk? Flights go quicker if you
 strike up a conversation with your fellow passenger.
 
 Obviously annoyed, the Remedy Consultant, who had just started to read his
 7.6.04 upgrade document, replied to the total stranger, What would you
want
 to talk about?
 
 Oh, I don't know, said the congressman. How about global warming,
 universal health care, or the debt ceiling? as he smiled smugly.
 
 OK, he said. Those could be interesting topics, but let me ask you a
 question first. A horse, a cow, and a deer all eat the same stuff - grass.
 Yet a deer excretes little pellets, while a cow turns out a flat patty,
and
 a horse produces clumps. Why do you suppose that is?
 
 The legislator, visibly surprised by the Remedy Consultant's intelligence,
 thinks about it and says, Hmmm, I have no idea.
 
 To which the Remedy Consultant replies, Do you really feel qualified to
 discuss global warming, universal health care, or the economy, when you
 don't know poop?
 
  
 
 Think about this when you are on your plane to DC for WWRUG11 in
September!
 
  
 
 Phil Bautista, WWRUG11 Advisory Board
 
 512-731-0304
 
 http://www.linkedin.com/in/philbautista
 
 http://www.wwrug11.com/contact_phil.html
 
  
 
   _  
 
 No virus found in this message.
 Checked by AVG - www.avg.com
 Version: 10.0.1390 / Virus Database: 1518/3796 - Release Date: 07/29/11
 
 _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ 
 
 


___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
-
No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1390 / Virus Database: 1518/3796 - Release Date: 07/29/11

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Re: JOB: Remedy Developers and Consultants Needed Immediately (San Diego, United States, Bahrain)

2011-07-29 Thread Sam Albury
Nice.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Re: JOB: Remedy Developers and Consultants Needed Immediately (San Diego, United States, Bahrain)

2011-07-29 Thread Howard Richter
Sent from Howard's iPad 2a

On Jul 29, 2011, at 7:07 PM, Sam Albury trei...@hotmail.com wrote:

 Nice. 
 
 ___
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
 attend wwrug11 www.wwrug.com ARSList: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are


Re: ITSM multi tenancy - customer company vs operating company needs

2011-07-29 Thread Easter, David
Ø  I recall hearing about a place in 7.6.04 to specify one company as 
hierarchically above another, but have not had time to see if it exists.

New in AR System 7.6.0x is hierarchical groups:

'Hierarchical group relationships for access control

You can now define a parent-child relationship between access control groups to 
simplify permissions management. When this is defined, and when the object 
properties allow for permission inheritance, object permissions assigned to the 
child group are also granted to the parent group. A group hierarchy can also be 
applied dynamically during row-level security processing to grant permission to 
a parent group, if the appropriate object properties are enabled.

See the Form and Application Objects Guide, Using a parent group for 
permissions inheritance.'

17-Aug-2010 What's New: BMC Remedy Action Request System 7.6.03 
PDFhttp://documents.bmc.com/supportu/documents/80/99/168099/168099.pdf


-David J. Easter
Manager of Product Management, Remedy Platform
BMC Software, Inc.

The opinions, statements, and/or suggested courses of action expressed in this 
E-mail do not necessarily reflect those of BMC Software, Inc.  My voluntary 
participation in this forum is not intended to convey a role as a spokesperson, 
liaison or public relations representative for BMC Software, Inc.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew C Goodall
Sent: Thursday, July 28, 2011 02:11 PM
To: arslist@ARSLIST.ORG
Subject: Re: ITSM multi tenancy - customer company vs operating company needs

**
Thanks Strauss, I'll take a look.
Go Mean Green Eagles.

Regards,

Andrew Goodall
Software Engineer 2 | Development Services |  jcpenney . www.jcp.com 
http://www.jcp.com/

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of strauss
Sent: Thursday, July 28, 2011 4:08 PM
To: arslist@ARSLIST.ORG
Subject: Re: ITSM multi tenancy - customer company vs operating company needs


If you don't mind the pain, you could try to digest what we built - documented 
at http://arsweb4.ars.unt.edu/index_prod.htm under the section UNT-Specific 
Documentation for Multi-Tenancy in the UNT BMC Remedy ITSM 7.x system.
It has held up in production for over three years now, so we are carrying it 
over to the upgraded 7.6.04.01 system... as-is.

I have not seen a practical use yet in our environment for the extension to 
Vendor Assignee Groups (60900) in 7.6.04; we continue to push what we need into 
Assignee Groups (112) instead.  Vendor Assignee Groups might turn out to be the 
correct tool to accomplish what you need to do in your environment, however.

I recall hearing about a place in 7.6.04 to specify one company as 
hierarchically above another, but have not had time to see if it exists.  That 
might help me to create a super-company over all of my separate companies 
defined for each directorate in the Computing Center.  Assuming that worked, I 
would be surprised if it could cross company-type boundaries.  I don't even 
know if it made it into the release, given that the multi-tenancy doc has not 
changed since 7.6.00.

Christopher Strauss, Ph.D.
Call Tracking Administration Manager
University of North Texas Computing  IT Center
http://itsm.unt.edu/
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew C Goodall
Sent: Thursday, July 28, 2011 1:44 PM
To: arslist@ARSLIST.ORG
Subject: ITSM multi tenancy - customer company vs operating company needs

**
ITSM 7.5.01

We are a fairly large enterprise and use multi-tenancy to control access to 
multiple operating companies' data.
So we do not give any one unrestricted access to control access to the 
different operating companies.
However, our associates from both companies - particularly our central Service 
Desk work with multiple customer companies and have to open incidents for those 
customers.

BMC support is telling us that we would have to add all those hundreds of 
customer companies to every ones access restrictions for that company to show 
up on the customer selection.

In our current environment, I have a workaround where we add public to those 
customer company records - but this is not sustainable long term.

I was hoping this would have changed in 7.6.04 but it does not, so all I can do 
is open an RFC :(

Does anyone else have this issue with the inflexibility of access restrictions 
between different company types, i.e. needing operating companies separate but 
customer companies open and public?

Does anyone else recommend a solution?
I'm currently adding public manually. But I'm thinking of adding a filter to 
push this on submission of Customer Type Company.


Regards,

Andrew Goodall
Software Engineer 2 | Development Services |  jcpenney . www.jcp.com 
http://www.jcp.com/  |


The information transmitted is intended only for the person or entity to which 
it is 

Re: ITSM multi tenancy - customer company vs operating company needs

2011-07-29 Thread strauss
Thanks for the confirmation of where to look; I have been far too busy swatting 
demonic manifestations in the 7.6.04.01 upgrade experience to try out 
anything new just for fun.

Christopher Strauss, Ph.D.
Call Tracking Administration Manager
University of North Texas Computing  IT Center
http://itsm.unt.edu/
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Easter, David
Sent: Friday, July 29, 2011 7:55 PM
To: arslist@ARSLIST.ORG
Subject: Re: ITSM multi tenancy - customer company vs operating company needs

**

Ø  I recall hearing about a place in 7.6.04 to specify one company as 
hierarchically above another, but have not had time to see if it exists.

New in AR System 7.6.0x is hierarchical groups:

'Hierarchical group relationships for access control

You can now define a parent-child relationship between access control groups to 
simplify permissions management. When this is defined, and when the object 
properties allow for permission inheritance, object permissions assigned to the 
child group are also granted to the parent group. A group hierarchy can also be 
applied dynamically during row-level security processing to grant permission to 
a parent group, if the appropriate object properties are enabled.

See the Form and Application Objects Guide, Using a parent group for 
permissions inheritance.'

17-Aug-2010 What's New: BMC Remedy Action Request System 7.6.03 
PDFhttp://documents.bmc.com/supportu/documents/80/99/168099/168099.pdf


-David J. Easter
Manager of Product Management, Remedy Platform
BMC Software, Inc.

The opinions, statements, and/or suggested courses of action expressed in this 
E-mail do not necessarily reflect those of BMC Software, Inc.  My voluntary 
participation in this forum is not intended to convey a role as a spokesperson, 
liaison or public relations representative for BMC Software, Inc.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew C Goodall
Sent: Thursday, July 28, 2011 02:11 PM
To: arslist@ARSLIST.ORG
Subject: Re: ITSM multi tenancy - customer company vs operating company needs

**
Thanks Strauss, I'll take a look.
Go Mean Green Eagles.

Regards,

Andrew Goodall
Software Engineer 2 | Development Services |  jcpenney . www.jcp.com 
http://www.jcp.com/

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of strauss
Sent: Thursday, July 28, 2011 4:08 PM
To: arslist@ARSLIST.ORG
Subject: Re: ITSM multi tenancy - customer company vs operating company needs


If you don't mind the pain, you could try to digest what we built - documented 
at http://arsweb4.ars.unt.edu/index_prod.htm under the section UNT-Specific 
Documentation for Multi-Tenancy in the UNT BMC Remedy ITSM 7.x system.
It has held up in production for over three years now, so we are carrying it 
over to the upgraded 7.6.04.01 system... as-is.

I have not seen a practical use yet in our environment for the extension to 
Vendor Assignee Groups (60900) in 7.6.04; we continue to push what we need into 
Assignee Groups (112) instead.  Vendor Assignee Groups might turn out to be the 
correct tool to accomplish what you need to do in your environment, however.

I recall hearing about a place in 7.6.04 to specify one company as 
hierarchically above another, but have not had time to see if it exists.  That 
might help me to create a super-company over all of my separate companies 
defined for each directorate in the Computing Center.  Assuming that worked, I 
would be surprised if it could cross company-type boundaries.  I don't even 
know if it made it into the release, given that the multi-tenancy doc has not 
changed since 7.6.00.

Christopher Strauss, Ph.D.
Call Tracking Administration Manager
University of North Texas Computing  IT Center
http://itsm.unt.edu/
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew C Goodall
Sent: Thursday, July 28, 2011 1:44 PM
To: arslist@ARSLIST.ORG
Subject: ITSM multi tenancy - customer company vs operating company needs

**
ITSM 7.5.01

We are a fairly large enterprise and use multi-tenancy to control access to 
multiple operating companies' data.
So we do not give any one unrestricted access to control access to the 
different operating companies.
However, our associates from both companies - particularly our central Service 
Desk work with multiple customer companies and have to open incidents for those 
customers.

BMC support is telling us that we would have to add all those hundreds of 
customer companies to every ones access restrictions for that company to show 
up on the customer selection.

In our current environment, I have a workaround where we add public to those 
customer company records - but this is not sustainable long term.

I was hoping this would have changed in 7.6.04 but it does not, so all I can do 
is open an RFC :(

Does anyone 

Re: Customer search and hover display in Incident form

2011-07-29 Thread strauss
Thanks to your hints I now have the On Hover actions for Customer and Contact 
displaying Login ID and Desk Location, and I have the Auto Complete working for 
Login ID and Direct Contact Login Name.  I rated it Easy-Button easy compared 
to some of the other code I'm working on, directly attributable to your notes.  
The ALs for attaching the menu to Login ID/Name even take care of moving the 
cursor focus to them for me.

I did find a sneaky way to minimize the code for Login ID; use Login ID to 
search CTP:People and return Corporate ID, then throw it into Customer and fire 
the OOTB active link guides used for that field.  It's a similar process for 
HPD:Help Desk Dialog, although you have to backfill Login ID afterwards.  This 
way all of the rest of the searching and field population is  in the hands of 
OOTB guides, including pop-ups in CTM:Search People when you have a login name 
lead to someone with more than one People/User record (multiple corporate ID 
matches).  This saved me from re-developing and implementing all of the custom 
ALs and AL Guides that I built to add Login ID to the Customer and Contact 
search routines in ITSM 7.6.00/7.6.03 during testing.  ANYTHING to make the 
next patch/Sp/upgrade easier than this one.

I still had to use AL and Filter logging via the User Tool to figure most of 
this out - the web substitute is atrocious. That means crashing the User Tool 
several dozen times a day as it struggles to load and operate the Incident 
form, but it beats the heck out of the alternative.  I'm not looking forward to 
fighting the Incident Console, which won't load in the User Tool at all, but 
our helpdesk is going nuts because it mixes Assigned and Owned Incidents 
together with no possible filter (like the Role toggle in 7.0.02/3) and they 
are demanding relief.  At least it was easy to unhide the Assigned Group and 
Owner Group columns for them.

Christopher Strauss, Ph.D.
Call Tracking Administration Manager
University of North Texas Computing  IT Center
http://itsm.unt.edu/
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller
Sent: Wednesday, July 27, 2011 5:19 PM
To: arslist@ARSLIST.ORG
Subject: Re: Customer search and hover display in Incident form

** I may have to copy your notes regarding the Login Name.  We haven't figure 
out the full requirement yet but my users are use to using the person's 
username.

Win 7 and IE 9 should be super speedy.  I have not seen the dialog slowness yet 
(Win 7 / IE 8).  I just did a quick check and the time was nothing like what 
you describe (although the system is not under any load and we have minimal 
config at this point).  I'll keep my eyes open for this.

Jason
On Wed, Jul 27, 2011 at 7:19 AM, strauss 
stra...@unt.edumailto:stra...@unt.edu wrote:
**
Thanks for the information!  I have not looked at any of these features before, 
so it's all new to me.

The Login Name integration is old hat - in ITSM 7.0.02/3 I had to add back in 
BOTH Login Name and Corporate ID, and the custom code to do that is still on 
the server since this is an upgrade.  It's just a question of whether to add 
Login name to the new Customer workflow, or just re-activate the custom ALs for 
Login Name (leaving those for Corporate ID disabled since BMC added that to 
Customer).

The most perplexing part will be adding it to the new HPD:Help Desk Dialogs 
form, since the dialogs used to be part of the base HPD:Help Desk form.  BTW, 
the HPD:Help Desk Dialogs form is turning out to be a lousy design in the new 
mid-tier - it is giving us HUGE performance hits on loading the dialogs, 
whereas the base form and consoles are FAST.  Anything that opens as a dialog 
is a slug, but the HPD:Help Desk Dialogs form takes up to 1 minute to load and 
45 seconds to Save and close (worst times observed in IE9 on Windows 7).

Christopher Strauss, Ph.D.
Call Tracking Administration Manager
University of North Texas Computing  IT Center
http://itsm.unt.edu/
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Jason 
Miller
Sent: Wednesday, July 27, 2011 1:37 AM
To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG
Subject: Re: Customer search and hover display in Incident form

** The hover uses an HTML template that is stored in the AR System Resource 
Definitions form ('Name' = HPDCustomerTooltip.html).  There is an Active Link 
(HPD:INC:HoverField_ContactInfo) that does a Set Fields using the TEMPLATE() 
function to a View Field to call the HTML template.  This Set Fields is where 
you map the fields to the tags in the HTML.  After that there is a Message 
action of Tool Tip to show the hover result.  Some of the details can be found 
on pg. 380 of the 7.6.04 Form and Application Objects Guide.


The Auto Complete only works in MT but it is configured in Dev Studio (pg. 320, 
7.6.04 Form and Application Objects Guide).  It is showing the results of an 

Re: ITSM multi tenancy - customer company vs operating company needs

2011-07-29 Thread Jason Miller
The question is does ITSM take advantage of the feature yet?  I am sure one
could change the Group record for a Company directly to adjust the hierarchy
but I am wondering what kind of unexpected behavior that may cause?

Jason
On Jul 29, 2011 5:54 PM, Easter, David david_eas...@bmc.com wrote:

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are