arsperl-users — Discussions regarding the use of ARSperl

Re: [Arsperl-users] Displaying label value in reports

[STANISLAW C. B. 7. L. <SCH...@bl...>]

One way would be having a hash with database name as keys and label name as 
values. You can read this hash from config file.                                
Stan Cholodnjak 
----- Original Message -----
From: Gary Shoemaker  <ars...@ar...>
At:  7/ 6 12:58

> I have a report that uses 'ars_GetFieldTable' to get a hash of keys
> and values.  I print them out in the report.  The issue is that some
> of the labels are not name the same as the database name.  How can I
> get the display label value instead of the database name?
>
> Gary Shoemaker
> Sandia National Laboratories
> (505) 284-1481
> gs...@sa...
>

[Arsperl-users] Displaying label value in reports

[Shoemaker, G. <gs...@sa...>]

> I have a report that uses 'ars_GetFieldTable' to get a hash of keys
> and values.  I print them out in the report.  The issue is that some
> of the labels are not name the same as the database name.  How can I
> get the display label value instead of the database name?
>=20
> Gary Shoemaker
> Sandia National Laboratories
> (505) 284-1481
> gs...@sa...
>=20

[Arsperl-users] ARFPERL plugin error while starting

[Syed B. (sbasith) <sb...@ci...>]

Hi,
=20
I get this error with arfperl plugin when starting the server=20
=20
 390695 : An error has occurred while loading a plug-in. (ARERR 8756)=20

ld.so.1: /apps/arsystem/remedy/bin/arplugin: fatal: relocation error:
file /apps/arsystem/remedy/bin/arfperl.so: symbol bootDynaLoader:
referenced symbol not found=20
=20
I have the latest arfperl for solaris downloaded and I was able to
compile arfperl wihtout any problem.=20
=20
Server                     : 6.00.01 Patch 1394
Operating System : Sun OS 5.8
Hardware               : sun4u
=20
Thanks
=20
Syed Abdul Basith

[Arsperl-users] Any one who compiled arfperl for solaris

[Syed B. (sbasith) <sb...@ci...>]

Hi,
=20
I want to compile the arfperl for solaris for ARS 6.0, I downloaded the
files from the remedy site, any pointers will be appreciated. We already
have compiled ARSPERL and do not have any problem using it.=20
=20
Thanks
Syed Abdul Basith

Re: [Arsperl-users] I would like to know how to specify a differe nt port (I'm using 9005 instead of 9000)

[Hupo P. <hp...@gm...>]

I  exported ARTCPPORT=3D9005 and the connection it is working know.

Failed 1/13 test scripts, 92.31% okay. 1/166 subtests failed, 99.40% okay.
make: *** [test_dynamic] Error 11

looks pretty well.

Thank you very much. Hugo

On 6/29/05, Stapff, Thilo <thi...@ma...> wrote:
>=20
>=20
> You may specify the port as the 6th parameter of the ars_Login-call (see =
the
> manual):=20
>=20
> ars_Login( $server, $user, $passwd, undef, undef, $port )=20
>=20
> As an alternative you may set the ARTCPPORT-Variable in the system
> environment before you start the script (or "make test"). In the "bash"
> shell this would be:
>=20
> export ARTCPPORT=3D9005=20
>=20
>=20
> Regards=20
> Thilo=20
>=20
>=20
> -----Urspr=FCngliche Nachricht-----=20
> Von: Hupo Perez [mailto:hp...@gm...]=20
> Gesendet: Mittwoch, 29. Juni 2005 15:47=20
> An: ars...@ar...=20
> Betreff: [Arsperl-users] I would like to know how to specify a different
> port (I'm using 9005 instead of 9000)=20
>=20
> I downloaded ARSperl-1.83 in my redhat 7.3 with ARS 6.0.=20
>=20
> Note: of course my make test it is failing (I changed Makefile.PL file=20
> and  config.cache has got the server_name, admin_user_name and=20
> admin_passwd)=20
>=20
> Thanks in advance. Hugo=20
>=20
>=20
>=20
> -------------------------------------------------------=20
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies=20
> from IBM. Find simple to follow Roadmaps, straightforward articles,=20
> informative Webcasts and more! Get everything you need to get up to=20
> speed, fast.
> http://ads.osdn.com/?ad_idt77&alloc_id=16492&op=3Dclick=20
> _______________________________________________=20
> Arsperl-users mailing list=20
> Ars...@ar...=20
> https://lists.sourceforge.net/lists/listinfo/arsperl-users

Re: [Arsperl-users] I would like to know how to specify a different port (I'm using 9005 instead of 9000)

[Hupo P. <hp...@gm...>]

I installed but it is still failing. Where should I modified the ARS
port number (I'm using 9005 instead of 9000)?

Thanks. Hugo

On 6/29/05, Hupo Perez <hp...@gm...> wrote:
> I will try it.
>=20
> Thanks.
>=20
> On 6/29/05, Jeff Murphy <jcm...@je...> wrote:
> > On Wed, 2005-06-29 at 10:46 -0300, Hupo Perez wrote:
> > > I downloaded ARSperl-1.83 in my redhat 7.3 with ARS 6.0.
> > >
> > > Note: of course my make test it is failing (I changed Makefile.PL fil=
e
> > > and  config.cache has got the server_name, admin_user_name and
> > > admin_passwd)
> > >
> >
> > try 1.84, i fixed the Makefile.PL to correct the autosplit problem
> > that's been bothering people.
> >
> > jeff
> >
> >
> >
> >
> >
> >
> >
> > -------------------------------------------------------
> > SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> > from IBM. Find simple to follow Roadmaps, straightforward articles,
> > informative Webcasts and more! Get everything you need to get up to
> > speed, fast. http://ads.osdn.com/?ad_id=3D7477&alloc_id=3D16492&op=3Dcl=
ick
> > _______________________________________________
> > Arsperl-users mailing list
> > Ars...@ar...
> > https://lists.sourceforge.net/lists/listinfo/arsperl-users
> >
>

AW: [Arsperl-users] I would like to know how to specify a differe nt port (I'm using 9005 instead of 9000)

[Stapff, T. <thi...@ma...>]

You may specify the port as the 6th parameter of the ars_Login-call =
(see the
manual):=20

ars_Login( $server, $user, $passwd, undef, undef, $port )

As an alternative you may set the ARTCPPORT-Variable in the system
environment before you start the script (or "make test"). In the "bash"
shell this would be:

export ARTCPPORT=3D9005


Regards
Thilo


-----Urspr=FCngliche Nachricht-----
Von: Hupo Perez [mailto:hp...@gm...]=20
Gesendet: Mittwoch, 29. Juni 2005 15:47
An: ars...@ar...
Betreff: [Arsperl-users] I would like to know how to specify a =
different
port (I'm using 9005 instead of 9000)

I downloaded ARSperl-1.83 in my redhat 7.3 with ARS 6.0.

Note: of course my make test it is failing (I changed Makefile.PL file
and  config.cache has got the server_name, admin_user_name and
admin_passwd)

Thanks in advance. Hugo



-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id=16492&op=3Dclick
_______________________________________________
Arsperl-users mailing list
Ars...@ar...
https://lists.sourceforge.net/lists/listinfo/arsperl-users

Re: [Arsperl-users] I would like to know how to specify a different port (I'm using 9005 instead of 9000)

[Hupo P. <hp...@gm...>]

I will try it.

Thanks.

On 6/29/05, Jeff Murphy <jcm...@je...> wrote:
> On Wed, 2005-06-29 at 10:46 -0300, Hupo Perez wrote:
> > I downloaded ARSperl-1.83 in my redhat 7.3 with ARS 6.0.
> >
> > Note: of course my make test it is failing (I changed Makefile.PL file
> > and  config.cache has got the server_name, admin_user_name and
> > admin_passwd)
> >
>=20
> try 1.84, i fixed the Makefile.PL to correct the autosplit problem
> that's been bothering people.
>=20
> jeff
>=20
>=20
>=20
>=20
>=20
>=20
>=20
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=3D7477&alloc_id=3D16492&op=3Dclic=
k
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
>

Re: [Arsperl-users] I would like to know how to specify a different port (I'm using 9005 instead of 9000)

[Jeff M. <jcm...@je...>]

On Wed, 2005-06-29 at 10:46 -0300, Hupo Perez wrote:
> I downloaded ARSperl-1.83 in my redhat 7.3 with ARS 6.0.
> 
> Note: of course my make test it is failing (I changed Makefile.PL file
> and  config.cache has got the server_name, admin_user_name and
> admin_passwd)
> 

try 1.84, i fixed the Makefile.PL to correct the autosplit problem
that's been bothering people.

jeff

[Arsperl-users] I would like to know how to specify a different port (I'm using 9005 instead of 9000)

[Hupo P. <hp...@gm...>]

I downloaded ARSperl-1.83 in my redhat 7.3 with ARS 6.0.

Note: of course my make test it is failing (I changed Makefile.PL file
and  config.cache has got the server_name, admin_user_name and
admin_passwd)

Thanks in advance. Hugo

Re: [Arsperl-users] specifying sort order ...

[Carey M. B. <bla...@gm...>]

Andrew,

  Since this is not an ARSPerl question, but definitely an ARS
question then it is likely better suited for the ARSlist.
(www.arslist.org) In the future you might try there for such ARS
"topics". (I have cross posted my response.)


But here is my two cents on the question:

1) ARS only allows you to have one "order by" clause per form. (And it
is applied to all queries on the form.) It is the form's property for
"Sort order".

   This is a bit inflexible, but can be worked around with filter
looping or direct SQL approaches.


2) Instead of using RDBMS specific solutions for your SQL... use ARS
tools to do simpler translations to keep things a bit more portable.
(Just in case you ever need to switch from Oracle to DB2, or DB2 to
Informix, etc...)


Who to do that you ask... read on...

Filter looping:

With a Goto:
  Filter looping can repeatedly walk the table to get the "first
matching" record and you may be able to use the define "form sort
order" to allow you to "select the next bigger" (or smaller) record.
This is somewhat dependent on the sort order providing some
integer/character value that will consistently order the records and
prevent you from seeing the same record in the filter looping process.
The default sort order for the form is Ascending 'Entry ID'. (field 1)
So if you have no other sort settings on the form, use that order to
your advantage and keep the last matching 'Entry ID' value and in your
loop find the next record using "bla... bla .. bla... AND 'Entry ID' >
$tempEntryID$".

With a table field/Filter guide over a table field:
   However, if your on an ARS version that does server side table
fields then you might also perfer to set up a table field and walk it
instead of walking the form. A table field can also set a sort order
for the data. (But a SetField action can not.  A fairly silly
inconsistency that we all hope will we corrected in future ARS
versions.)


Direct SQL approaches:

   Selection fields are a bit of a pain when it come to using their
values in direct SQL. This is because ARS "sees" what the
number/mapped text values are in it's design. But there are a few ways
to help translate things to make them much easier to deal with in
future modifications.

) Selection field too temp integer field.
   This will get the numeric value for the selected value of the
selection field. The temp field could later be used in Direct SQL, Run
process, etc.. actions. This is nice when you want the number from a
selection field.

) Selection field to a temp Character field.
  This will get the string value for the selected value of the selection fi=
eld.

When changes are made to the source selection field in the cases
above... there is no additional work needed for these solutions.


) Selection field to Selection field.
    This is nice to translate "Label" values to their "actual values".
Then you can move the value to a character field to show the "actual
values" as text values.
   Sure this requires you to maintain two selection fields when
changes are made, but it is a better option, IMHO, than using RDBMS
value translation/decode options.


Also... Form names can/do change over time. So you might want to also
lookup the value from a config form so that data can be updated to
"fix" the SQL when you later change the form name and forget to
correct your SQL in the workflow. Changing data during the day is not
a big deal. Changing an ARS object outside of a change window... could
get someone in trouble. :)





Oh and at the risk of this sounding rude.... but I am only poking a
bit of fun about this.

"Rome built daily."  (Apparenly not in ARS... :)

--=20
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS =3D Action Request System(Remedy)

Solution =3D People + Process + Tools
Fast, Accurate, Cheap.... Pick two.
Never ascribe to malice, that which can be explained by incompetence.

On 6/28/05, Andrew Hicox <an...@hi...> wrote:
> Hello everyone:
>=20
> I realize this is a little off topic, as it doesn't relate directly to
> arsperl, but I'm sure someone here knows the answer:
>=20
> the short question:
>=20
>        is there some way, inside an ARS QBE string, to specify the order =
in
> which results
>        should be returned, similar to SQL's "order by" clause?
>=20
> the long question:
>=20
> I need to create a filter that will check for duplicate entries in a
> form. When a new record is created in the form, the filter should fire,
> and place the most recent duplicate entry's entryID in a field in the
> new record.
>=20
> This should be no sweat, just select entries with identical field
> values, sort by date descending and "if multiple entries match: use
> first", no? My problem is that I can't figure how to get remedy to
> order by date descending. I tried setting this in the sort pane of the
> form's 'properties' dialog, to no avail. I had thought to just use a
> straight SQL query, but then I'll have to use big nasty oracle decode()
> blocks to match dropdown menu value, and I don't fancy having to find
> each and every one of those and modifiy it if I have to add another
> menu value.
>=20
> It's a long story, but the company I'm working for won't pay for a
> supportweb account, and I can't seem to google ANY documentation on
> this.
>=20
> I call upon the vast knowledge of the group in my pitiful struggle.
>=20
> thank you all in advance,
>=20
> -Andrew ;-)
>=20
> ###################################################
> ## Andrew N. Hicox
> ## Hicox Information Systems Development
> ## [voice]: 703-367-9085
> ## [email]: an...@hi...
> ## [web]: http://hicox.com
> ##
> ## Rome built daily.
###################################################

[Arsperl-users] specifying sort order ...

[Andrew H. <an...@hi...>]

Hello everyone:

I realize this is a little off topic, as it doesn't relate directly to 
arsperl, but I'm sure someone here knows the answer:

the short question:
	
	is there some way, inside an ARS QBE string, to specify the order in 
which results
	should be returned, similar to SQL's "order by" clause?

the long question:

I need to create a filter that will check for duplicate entries in a 
form. When a new record is created in the form, the filter should fire, 
and place the most recent duplicate entry's entryID in a field in the 
new record.

This should be no sweat, just select entries with identical field 
values, sort by date descending and "if multiple entries match: use 
first", no? My problem is that I can't figure how to get remedy to 
order by date descending. I tried setting this in the sort pane of the 
form's 'properties' dialog, to no avail. I had thought to just use a 
straight SQL query, but then I'll have to use big nasty oracle decode() 
blocks to match dropdown menu value, and I don't fancy having to find 
each and every one of those and modifiy it if I have to add another 
menu value.

It's a long story, but the company I'm working for won't pay for a 
supportweb account, and I can't seem to google ANY documentation on 
this.

I call upon the vast knowledge of the group in my pitiful struggle.

thank you all in advance,

-Andrew ;-)

###################################################
## Andrew N. Hicox
## Hicox Information Systems Development
## [voice]: 703-367-9085
## [email]: an...@hi...
## [web]: http://hicox.com
##
## Rome built daily.
###################################################

Re: [Arsperl-users] ARSPerl and Remedy Encryption (v5.1.2)

[Quanah Gibson-M. <qu...@st...>]

--On Thursday, June 16, 2005 6:33 AM -0400 Chris Smith 
<chr...@du...> wrote:

>
> Hello,
> We just purchased the performance encryption pack for our 5.1.2 server.
> I noticed that ARSPerl v1.82 supports encryption. Anybody know if I can
> use this version for the 5.1.2 encryption product?

Chris,

The only trick to using encryption with the perl module is to compile it 
against the encryption library, so it should work regardless of the version 
you have.

--Quanah

--
Quanah Gibson-Mount
Principal Software Developer
ITSS/Shared Services
Stanford University
GnuPG Public Key: http://www.stanford.edu/~quanah/pgp.html

"These censorship operations against schools and libraries are stronger
than ever in the present religio-political climate. They often focus on
fantasy and sf books, which foster that deadly enemy to bigotry and blind
faith, the imagination." -- Ursula K. Le Guin

[Arsperl-users] ARSPerl and Remedy Encryption (v5.1.2)

[Chris S. <chr...@du...>]

Hello,
We just purchased the performance encryption pack for our 5.1.2 server. 
I noticed that ARSPerl v1.82 supports encryption. Anybody know if I can 
use this version for the 5.1.2 encryption product?

Thanks,
Chris Smith

Re: [Arsperl-users] AR_RETURN_WARNING

[Carey M. B. <bla...@gm...>]

Amen,

Your very welcome.

  ARSPerl is a smaller (sub set) of the Remedy ARS universe. While it
is a Perl rapper around the C API, most people here only really use
the Perl wrapper and not the C API directly. However there are those
that maintain ARSPerl itself that lurk here and they certainly use the
C API. :) So it is not bad to post messages about the C API here, but
you have a smaller set of people to pull information from.

On the other hand.... www.arslist.org is a more general mailing list
for "all things Remedy" and has a larger user subscription. So your a
bit more likely to find people who use any given part of ARS there.

Both groups are good groups of people and rarely do they give you a
hard time about asking "newbie questions". So feel free to ask
anything ARS related. Use which ever list you choose, but ARSPerl
things are more likely to be answered correctly and directly by those
that develop that tool here. Most other things are "best" routed to
www.ARSlist.org.

Happy developing. :)

--=20
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS =3D Action Request System(Remedy)

Solution =3D People + Process + Tools
Fast, Accurate, Cheap.... Pick two.
Never ascribe to malice, that which can be explained by incompetence.

http://www.fellowshipchurch.com


On 6/15/05, Amen Asemota <aas...@ho...> wrote:
> I just want to say a very big thank you to you. I decided to use
> ARGetListEntryWithFields and I dont get that error any more. It's working
> very well now.
>=20
> Thanks for letting me know about the www.arslist.org . It's been very
> helpful to me. I am kind of new in Remedy and didn't know that site exist=
.
>=20
> Once againthank you and I appreciate all your help.
>=20
> Amen.
>=20
> >From: Carey Matthew Black <bla...@gm...>
> >Reply-To: ars...@ar...
> >To: ars...@ar...
> >Subject: Re: [Arsperl-users] AR_RETURN_WARNING
> >Date: Tue, 14 Jun 2005 08:50:49 -0500
> >
> >Amen,
> >
> >  Not really sure why you think an ARSPerl list is the right place to
> >post an ARS C API question.... ( I would think www.arslist.org would
> >have been a better choice.)
> >
> >
> >However, with that said, I will still take a stab at the problem. It
> >sounds like ...
> >
> >Your using the ARGetListEntry function and the AREntryListFieldList
> >structure is being truncated because the form is configured with to
> >many fields in the Results list.
> >
> >First, if this is the case then, this should be a safe error to
> >ignore. (unless you are only getting your data from the
> >AREntryListFieldList structure. If you are doing that then I would
> >suggest you use the ARGetListEntryWithFields function anyway.) The
> >reason you can safely ignore it is that when you later call the
> >ARGetEntry function you get all the details anyway.
> >
> >
> >On the other hand... You might also be seeing that the ARGetListEntry
> >function is only returning a subset of the actual number of records
> >found on the form.(100 of 1000000) If so then check your maxRetrieve
> >value in the function and the Server's configuration for
> >AR_SERVER_INFO_MAX_ENTRIES. That setting might be what your being
> >limited by too. If so then reuse the ARGetListEntry with a setting for
> >->firstRetrieve and set it to the max Entry ID that was returned by
> >the previous call to ARGetListEntry and repeat until you get zero
> >records from the query.
> >
> >
> >HTH.
> >
> >--
> >Carey Matthew Black
> >Remedy Skilled Professional (RSP)
> >ARS =3D Action Request System(Remedy)
> >
> >Solution =3D People + Process + Tools
> >Fast, Accurate, Cheap.... Pick two.
> >Never ascribe to malice, that which can be explained by incompetence.
> >
> >http://www.fellowshipchurch.com
> >
> >
> >
> >
> >
> >On 6/13/05, Amen Asemota <aas...@ho...> wrote:
> > > Hi,
> > >
> > > I am trying to run a C program in Unix to retrieve data from remedy. =
It
> > > compiles ok but when I run it, I get the error message below. Is ther=
e a
> >way
> > > to change the Maximum return in a query to say up to a 1000?.
> > >
> > > ERROR: DTR-Workorder Get List Entry: 'WO Status' =3D "Closed" AND 'Ac=
tion'
> >!=3D
> > > $NULL$ AND ('Asset Updated?' =3D "No" OR 'Asset Updated?' =3D $NULL$)
> > > Number of items in Status List: 1
> > > Message Type: WARNING Message Number: 8911
> > > Message: Some of the fields have been truncated from the results list
> > > because the total length of the fields and separators is greater than
> >the
> > > maximum allowed
> > > Appended Message:
> > >
> > > Please help!!!
> > >
> > > Thank you.
> > >
> > > Amen.

Re: [Arsperl-users] AR_RETURN_WARNING

[Amen A. <aas...@ho...>]

I just want to say a very big thank you to you. I decided to use 
ARGetListEntryWithFields and I dont get that error any more. It's working 
very well now.

Thanks for letting me know about the www.arslist.org . It's been very 
helpful to me. I am kind of new in Remedy and didn't know that site exist.

Once againthank you and I appreciate all your help.

Amen.

>From: Carey Matthew Black <bla...@gm...>
>Reply-To: ars...@ar...
>To: ars...@ar...
>Subject: Re: [Arsperl-users] AR_RETURN_WARNING
>Date: Tue, 14 Jun 2005 08:50:49 -0500
>
>Amen,
>
>  Not really sure why you think an ARSPerl list is the right place to
>post an ARS C API question.... ( I would think www.arslist.org would
>have been a better choice.)
>
>
>However, with that said, I will still take a stab at the problem. It
>sounds like ...
>
>Your using the ARGetListEntry function and the AREntryListFieldList
>structure is being truncated because the form is configured with to
>many fields in the Results list.
>
>First, if this is the case then, this should be a safe error to
>ignore. (unless you are only getting your data from the
>AREntryListFieldList structure. If you are doing that then I would
>suggest you use the ARGetListEntryWithFields function anyway.) The
>reason you can safely ignore it is that when you later call the
>ARGetEntry function you get all the details anyway.
>
>
>On the other hand... You might also be seeing that the ARGetListEntry
>function is only returning a subset of the actual number of records
>found on the form.(100 of 1000000) If so then check your maxRetrieve
>value in the function and the Server's configuration for
>AR_SERVER_INFO_MAX_ENTRIES. That setting might be what your being
>limited by too. If so then reuse the ARGetListEntry with a setting for
>->firstRetrieve and set it to the max Entry ID that was returned by
>the previous call to ARGetListEntry and repeat until you get zero
>records from the query.
>
>
>HTH.
>
>--
>Carey Matthew Black
>Remedy Skilled Professional (RSP)
>ARS = Action Request System(Remedy)
>
>Solution = People + Process + Tools
>Fast, Accurate, Cheap.... Pick two.
>Never ascribe to malice, that which can be explained by incompetence.
>
>http://www.fellowshipchurch.com
>
>
>
>
>
>On 6/13/05, Amen Asemota <aas...@ho...> wrote:
> > Hi,
> >
> > I am trying to run a C program in Unix to retrieve data from remedy. It
> > compiles ok but when I run it, I get the error message below. Is there a 
>way
> > to change the Maximum return in a query to say up to a 1000?.
> >
> > ERROR: DTR-Workorder Get List Entry: 'WO Status' = "Closed" AND 'Action' 
>!=
> > $NULL$ AND ('Asset Updated?' = "No" OR 'Asset Updated?' = $NULL$)
> > Number of items in Status List: 1
> > Message Type: WARNING Message Number: 8911
> > Message: Some of the fields have been truncated from the results list
> > because the total length of the fields and separators is greater than 
>the
> > maximum allowed
> > Appended Message:
> >
> > Please help!!!
> >
> > Thank you.
> >
> > Amen.
>
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by: NEC IT Guy Games.  How far can you 
>shotput
>a projector? How fast can you ride your desk chair down the office luge 
>track?
>If you want to score the big prize, get to know the little guy.
>Play to win an NEC 61" plasma display: http://www.necitguy.com/?r
>_______________________________________________
>Arsperl-users mailing list
>Ars...@ar...
>https://lists.sourceforge.net/lists/listinfo/arsperl-users

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

Re: [Arsperl-users] make error for perl API on SUSE 64 bits

[Carey M. B. <bla...@gm...>]

Stanislaw,

  To my knowledge Remedy has yet to move there code to 64 bit. So the
ARSPerl wrapper would still use the 32 bit C libs on any supported
platform.

--=20
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS =3D Action Request System(Remedy)

Solution =3D People + Process + Tools
Fast, Accurate, Cheap.... Pick two.
Never ascribe to malice, that which can be explained by incompetence.

http://www.fellowshipchurch.com



On 6/14/05, STANISLAW CHOLODNJAK, BLOOMBERG/ 731 LEXIN
<SCH...@bl...> wrote:
> Is Perl API available for Linux suse 64 bits? Thanks -Stan Cholodnjak

[Arsperl-users] make error for perl API on SUSE 64 bits

[STANISLAW C. B. 7. L. <SCH...@bl...>]

Is Perl API available for Linux suse 64 bits? Thanks -Stan Cholodnjak

Re: [Arsperl-users] AR_RETURN_WARNING

[Carey M. B. <bla...@gm...>]

Amen,

 Not really sure why you think an ARSPerl list is the right place to
post an ARS C API question.... ( I would think www.arslist.org would
have been a better choice.)


However, with that said, I will still take a stab at the problem. It
sounds like ...

Your using the ARGetListEntry function and the AREntryListFieldList
structure is being truncated because the form is configured with to
many fields in the Results list.

First, if this is the case then, this should be a safe error to
ignore. (unless you are only getting your data from the
AREntryListFieldList structure. If you are doing that then I would
suggest you use the ARGetListEntryWithFields function anyway.) The
reason you can safely ignore it is that when you later call the
ARGetEntry function you get all the details anyway.


On the other hand... You might also be seeing that the ARGetListEntry
function is only returning a subset of the actual number of records
found on the form.(100 of 1000000) If so then check your maxRetrieve
value in the function and the Server's configuration for
AR_SERVER_INFO_MAX_ENTRIES. That setting might be what your being
limited by too. If so then reuse the ARGetListEntry with a setting for
->firstRetrieve and set it to the max Entry ID that was returned by
the previous call to ARGetListEntry and repeat until you get zero
records from the query.


HTH.

--=20
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS =3D Action Request System(Remedy)

Solution =3D People + Process + Tools
Fast, Accurate, Cheap.... Pick two.
Never ascribe to malice, that which can be explained by incompetence.

http://www.fellowshipchurch.com





On 6/13/05, Amen Asemota <aas...@ho...> wrote:
> Hi,
>=20
> I am trying to run a C program in Unix to retrieve data from remedy. It
> compiles ok but when I run it, I get the error message below. Is there a =
way
> to change the Maximum return in a query to say up to a 1000?.
>=20
> ERROR: DTR-Workorder Get List Entry: 'WO Status' =3D "Closed" AND 'Action=
' !=3D
> $NULL$ AND ('Asset Updated?' =3D "No" OR 'Asset Updated?' =3D $NULL$)
> Number of items in Status List: 1
> Message Type: WARNING Message Number: 8911
> Message: Some of the fields have been truncated from the results list
> because the total length of the fields and separators is greater than the
> maximum allowed
> Appended Message:
>=20
> Please help!!!
>=20
> Thank you.
>=20
> Amen.

[Arsperl-users] AR_RETURN_WARNING

[Amen A. <aas...@ho...>]

Hi,

I am trying to run a C program in Unix to retrieve data from remedy. It 
compiles ok but when I run it, I get the error message below. Is there a way 
to change the Maximum return in a query to say up to a 1000?.

ERROR: DTR-Workorder Get List Entry: 'WO Status' = "Closed" AND 'Action' != 
$NULL$ AND ('Asset Updated?' = "No" OR 'Asset Updated?' = $NULL$)
Number of items in Status List: 1
Message Type: WARNING Message Number: 8911
Message: Some of the fields have been truncated from the results list 
because the total length of the fields and separators is greater than the 
maximum allowed
Appended Message:

Please help!!!

Thank you.

Amen.

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

RE: [Arsperl-users] REmedy problem

[PC W. <PC...@TE...>]

I guess the text file should be created in the owner's home directory.

Regards
PC=20

-----Original Message-----
From: ars...@ar... =
[mailto:ars...@ar...] On Behalf Of Amen Asemota
Sent: Thursday, June 09, 2005 18:20
To: ars...@ar...
Subject: RE: [Arsperl-users] REmedy problem

yes it does.

Amen.

>From: Steve McDonald <ste...@ch...>
>Reply-To: ars...@ar...
>To: ars...@ar...
>Subject: RE: [Arsperl-users] REmedy problem
>Date: Thu, 09 Jun 2005 13:28:54 -0700
>
>Does the script user(remedy install user) have permissions to create=20
>files in the specified location?
>
>-----Original Message-----
>From: ars...@ar...
>[mailto:ars...@ar...] On Behalf Of Amen Asemota
>Sent: Thursday, June 09, 2005 1:21 PM
>To: ars...@ar...
>Subject: RE: [Arsperl-users] REmedy problem
>
>Yes it does. I do have another problem though. It is supposed to be=20
>creating
>
>a text file also but it's not doing that. It just sets the field and=20
>that's it.
>
>Thanks.
>
>Amen.
>
> >From: "PC Wai" <PC...@TE...>
> >Reply-To: ars...@ar...
> >To: <ars...@ar...>
> >Subject: RE: [Arsperl-users] REmedy problem
> >Date: Thu, 9 Jun 2005 09:03:33 -0700
> >
> >Hi Amen,
> >
> >Just a wild guess. Does your Remedy owner have execution permission=20
> >to
>the
> >script and the modules?
> >
> >Regards
> >PC
> >
> >-----Original Message-----
> >From: ars...@ar...=20
> >[mailto:ars...@ar...] On Behalf Of Amen Asemota
> >Sent: Thursday, June 09, 2005 08:53
> >To: ars...@ar...
> >Subject: RE: [Arsperl-users] REmedy problem
> >
> >
> >Yes it does it prints out the word "Sent" and it also creates a txt=20
> >file which we also need.
> >
> >Amen.
> > >From: Steve McDonald <ste...@ch...>
> > >Reply-To: ars...@ar...
> > >To: ars...@ar...
> > >Subject: RE: [Arsperl-users] REmedy problem
> > >Date: Thu, 09 Jun 2005 08:20:22 -0700
> > >
> > >Does this script work from the command line?
> > >
> > >-----Original Message-----
> > >From: ars...@ar...=20
> > >[mailto:ars...@ar...] On Behalf Of Amen Asemota
> > >Sent: Thursday, June 09, 2005 6:42 AM
> > >To: ars...@ar...
> > >Subject: Re: [Arsperl-users] REmedy problem
> > >
> > >Hi Carey and Steve,
> > >
> > >Here is my Code :
> > >
> > >#!/usr/bin/perl
> > >
> > >#use strict 'vars';
> > >my $status =3D "Active";
> > >my $count3 =3D 0;
> > >my $countDTR =3D 0;
> > >my @save_DTR;
> > >my @save_entry;
> > >my @save_type;
> > >my @save_PartNumber;
> > >my @save_ProductName;
> > >my @save_qty;
> > >my @save_unitCost;
> > >my @save_ExtendedCost;
> > >my $save_filename;
> > >my $DTR =3D "DTR";
> > >my $flag =3D 1;
> > >my $flag2 =3D "Sent" ;
> > >
> > >use arControl;
> > >my $server =3D $arControl::SERVER;
> > >my $username =3D $arControl::USERNAME; my $pw =3D $arControl::PW; =
use=20
> > >ARS;
> > >#open(TXT,">datafile.txt") ||die printf "unable to open flat=20
> > >file\n";
> > >
> > ># text file opened
> > >#printf "The datafile has been opened\n"; $ctrl =3D=20
> > >ars_Login($server,$username,$pw)||die printf "AR Server login=20
> > >Error\n"; #$query =3D "'650001031' !=3D \$NULL\$"; #my $query =3D=20
> > >"'Assigned To' !=3D \$NULL\$"; my $query =3D "'PO Flag?'!=3D =
\$NULL\$";=20
> > >my $qual =3D ars_LoadQualifier($ctrl, "Schema",$query);
> > >if(!defined($qual))
> > >{
> > >         $error =3D "Unable to create Schema Load qualifier=20
> > >$ars_errstr"; }
> > >
> > ># created the qualifier
> > >#printf "Qualifier has been created\n"; %firstentry =3D=20
> > >ars_GetListEntry($ctrl,"Schema",$qual,0);
> > >#getting DTR numbers
> > >#printf "DTR numbers being retrieved\n"; foreach $entryId (sort=20
> > >keys
> > >%firstentry) {
> > >     %firstvalue =3D ars_GetEntry($ctrl,"Schema", $entryId, =
650001006);
> > >     foreach $entryId (sort keys %firstvalue)
> > >     {
> > >        $save_DTR{$countDTR} =3D $firstvalue{650001006};
> > >        $save_entry{$countDTR} =3D $entryId;
> > >#      printf $save_DTR{$countDTR};
> > >        $countDTR++;
> > >       }
> > >}
> > >#printf("DTR count=3D%d\n",$countDTR); # creating the header file=20
> > >print TXT "H","0001","0000000","000000","000","0000000000";
> > >print TXT "00000","00000","00000000"; # Retrieving the Items for=20
> > >this DTR  table
> > >
> > >$qualb =3D ars_LoadQualifier($ctrl,"Schema2", "1=3D1");
> > >if(!defined($qualb))
> > >         {
> > >                 $error =3D "Unable to create Schema2  Load qual=20
> > >ifier $ars_errstr";
> > >         }
> > >for($count3 =3D 0; $count3 < $countDTR; $count3++) {# printf("next=20
> > >DTR=3D%s\n",$save_DTR{$count3}); $save_filename =3D=20
> > >$DTR.$save_DTR{$count3};
> > >open(TXT,">$save_filename.txt") ||die printf "unable to open flat=20
> > >file\n"; #printf($save_filename, "\n"); %second =3D=20
> > >ars_GetListEntry($ctrl,"Schema2",$qualb, 0); my $allHWSW=3D0; my=20
> > >$prtHWSW=3D0;
> > >
> > >foreach $entryId(sort keys %second)
> > >{      $allHWSW++;
> > >         #Gets table information
> > >         %secondvalue =3D ars_GetEntry($ctrl,"Schema2",$entryId,
> > >650008002,8,7,650008003,650008007,
> > >                  650008016,650008005,650008004,650008015);
> > >        if(($secondvalue{650008002} eq $save_DTR{$count3}) &&=20
> > >(($secondvalue{6500 08015} =3D=3D 0) && ($secondvalue{7} =3D=3D =
0)))
> > >               { $prtHWSW++;
> > >                  $save_type{$count3}=3D $secondvalue{8};
> > >                  $save_PartNumber{$count3} =3D =
$secondvalue{650008003};
> > >                  $save_ProductName{$count3} =3D =
$secondvalue{650008007};
> > >                  $save_qty{$count3} =3D $secondvalue{650008016};
> > >                  $save_unitCost{$count3} =3D =
$secondvalue{650008005};
> > >                  $save_extendedCost{$count3} =3D
>$secondvalue{650008004};
> > >                  $save_WO{$count3} =3D $secondvalue{650008015};
> > >                  $save_Status{$count3} =3D $secondvalue{7};
> > >                 #send items to file
> > >                 print TXT $save_DTR{$count3};
> > >                 print TXT "L","0001","0000000","000000","000","0";
> > >                 print TXT $save_type{$count3};
> > >                 print TXT $save_PartNumber{$count3};
> > >                 print TXT $save_ProductName{$count3},"  ";
> > >                 print TXT $save_qty{$count3},"  ";
> > >                 print TXT $save_unitCost{$count3},"  ";
> > >                 print TXT $save_extendedCost{$count3};
> > >                 #$count3++;
> > >            }
> > >   }
> > >#printf("   allHWSW=3D%d prtHWSW=3D%d\n",$allHWSW,$prtHWSW);
> > >close(TXT);
> > >}
> > >
> > >#close(TXT);
> > >ars_Logoff($ctrl);
> > >print "Sent \n";
> > >exit(0);
> > >
> > >
> > >
> > >
> > >Then in the Remedy filter i enter the process $PROCESS$=20
> > >/path/file.pl because I want it to Set a text field in the filter=20
> > >to "Sent". With the exit(0), I am still getting the same error msg. =

> > >This script compiles with no
> > >
> > >problem in Unix and it prints out Sent to the STDOUT but when I use =

> > >it in the set field it keep getting the error ARERR [38]=20
> > >Filter/escalation 'set field' process returned an error.
> > >
> > >
> > >
> > >Thanks.
> > >
> > >Amen.
> > >
> > > >From: Carey Matthew Black <bla...@gm...>
> > > >Reply-To: ars...@ar...
> > > >To: ars...@ar...
> > > >Subject: Re: [Arsperl-users] REmedy problem
> > > >Date: Wed, 8 Jun 2005 11:04:16 -0500
> > > >
> > > >Amen,
> > > >
> > > >Make sure your script always exits with status zero.
> > > >exit(0);
> > > >If you do not exit with a status of zero then the ARS server will =

> > > >throw an exception.
> > > >
> > > >print anything to STDOUT that you want to to end up in the field.
> > > >
> > > >A simple example would be:
> > > >#! /usr/bin/perl
> > > >print "The fields new value is this whole string"; exit(0);
> > > >
> > > >
> > > >Also .. in the filter.. make sure you fully qualify the path to=20
> > > >the perl script and maybe even perl itself.
> > > >
> > > >/path/to/myscript/junk.pl
> > > >
> > > >or maybe...
> > > >
> > > >/usr/bin/perl /path/to/myscript/junk.pl
> > > >
> > > >
> > > >You can also run Filter logs and check the arerror.log for more=20
> > > >details on what the ARS server is seeing from the script too.
> > > >
> > > >Hope that helps.
> > > >
> > > >--
> > > >Carey Matthew Black
> > > >Remedy Skilled Professional (RSP) ARS =3D Action Request=20
> > > >System(Remedy)
> > > >
> > > >Solution =3D People + Process + Tools Fast, Accurate, Cheap....=20
> > > >Pick two.
> > > >Never ascribe to malice, that which can be explained by =
incompetence.
> > > >
> > > >http://www.fellowshipchurch.com
> > > >
> > > >On 6/8/05, Amen Asemota <aas...@ho...> wrote:
> > > > > Hi,
> > > > >
> > > > > I am trying to run a perl script in a filter but i keep=20
> > > > > getting ARERR
> > > >[38]
> > > > > Filter/escalation 'set field' process returned an error.
> > > > >
> > > > > Iam trying to use the $PROCESS$ command to set a field .=20
> > > > > Please
> >help..
> > > > >
> > > > > ______________________________________________________________
> > > > > ___ Express yourself instantly with MSN Messenger! Download=20
> > > > > today it's
> > >FREE!
> > > > > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01
> > > > > /
> > > > >
> > > > >
> > > > >
> > > > > -------------------------------------------------------
> > > > > This SF.Net email is sponsored by: NEC IT Guy Games.  How far=20
> > > > > can you
> > > >shotput
> > > > > a projector? How fast can you ride your desk chair down the=20
> > > > > office
> > >luge
> > > >track?
> > > > > If you want to score the big prize, get to know the little =
guy.
> > > > > Play to win an NEC 61" plasma display:
> > > > > http://www.necitguy.com/?r=3D20
> > > > > _______________________________________________
> > > > > Arsperl-users mailing list
> > > > > Ars...@ar...
> > > > > https://lists.sourceforge.net/lists/listinfo/arsperl-users
> > > > >
> > > >
> > > >
> > > >
> > > >-------------------------------------------------------
> > > >This SF.Net email is sponsored by: NEC IT Guy Games.  How far can =

> > > >you shotput a projector? How fast can you ride your desk chair=20
> > > >down the office luge track?
> > > >If you want to score the big prize, get to know the little guy.
> > > >Play to win an NEC 61" plasma display: http://www.necitguy.com/?r =

> > > >_______________________________________________
> > > >Arsperl-users mailing list
> > > >Ars...@ar...
> > > >https://lists.sourceforge.net/lists/listinfo/arsperl-users
> > >
> > >_________________________________________________________________
> > >Express yourself instantly with MSN Messenger! Download today it's
>FREE!
> > >http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
> > >
> > >
> > >
> > >-------------------------------------------------------
> > >This SF.Net email is sponsored by: NEC IT Guy Games.  How far can=20
> > >you shotput a projector? How fast can you ride your desk chair down =

> > >the office luge track?
> > >If you want to score the big prize, get to know the little guy.
> > >Play to win an NEC 61" plasma display:=20
> > >http://www.necitguy.com/?r=3D20=20
> > >_______________________________________________
> > >Arsperl-users mailing list
> > >Ars...@ar...
> > >https://lists.sourceforge.net/lists/listinfo/arsperl-users
> > >
> > >
> > >
> > >-------------------------------------------------------
> > >This SF.Net email is sponsored by: NEC IT Guy Games.  How far can=20
> > >you shotput a projector? How fast can you ride your desk chair down =

> > >the office luge track?
> > >If you want to score the big prize, get to know the little guy.
> > >Play to win an NEC 61" plasma display:=20
> > >http://www.necitguy.com/?r=3D20=20
> > >_______________________________________________
> > >Arsperl-users mailing list
> > >Ars...@ar...
> > >https://lists.sourceforge.net/lists/listinfo/arsperl-users
> >
> >_________________________________________________________________
> >Express yourself instantly with MSN Messenger! Download today it's =
FREE!
> >http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
> >
> >
> >
> >-------------------------------------------------------
> >This SF.Net email is sponsored by: NEC IT Guy Games.  How far can you =

> >shotput a projector? How fast can you ride your desk chair down the
>office
> >luge track?
> >If you want to score the big prize, get to know the little guy.
> >Play to win an NEC 61" plasma display: =
http://www.necitguy.com/?r=3D20=20
> >_______________________________________________
> >Arsperl-users mailing list
> >Ars...@ar...
> >https://lists.sourceforge.net/lists/listinfo/arsperl-users
> >
> >
> >
> >-------------------------------------------------------
> >This SF.Net email is sponsored by: NEC IT Guy Games.  How far can you =

> >shotput a projector? How fast can you ride your desk chair down the=20
> >office luge track?
> >If you want to score the big prize, get to know the little guy.
> >Play to win an NEC 61" plasma display: http://www.necitguy.com/?r=20
> >_______________________________________________
> >Arsperl-users mailing list
> >Ars...@ar...
> >https://lists.sourceforge.net/lists/listinfo/arsperl-users
>
>_________________________________________________________________
>Express yourself instantly with MSN Messenger! Download today it's =
FREE!
>http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by: NEC IT Guy Games.  How far can you=20
>shotput a projector? How fast can you ride your desk chair down the=20
>office luge track?
>If you want to score the big prize, get to know the little guy.
>Play to win an NEC 61" plasma display: http://www.necitguy.com/?r=3D20=20
>_______________________________________________
>Arsperl-users mailing list
>Ars...@ar...
>https://lists.sourceforge.net/lists/listinfo/arsperl-users
>
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by: NEC IT Guy Games.  How far can you=20
>shotput a projector? How fast can you ride your desk chair down the=20
>office luge track?
>If you want to score the big prize, get to know the little guy.
>Play to win an NEC 61" plasma display: http://www.necitguy.com/?r=3D20=20
>_______________________________________________
>Arsperl-users mailing list
>Ars...@ar...
>https://lists.sourceforge.net/lists/listinfo/arsperl-users

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE! =

http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/



-------------------------------------------------------
This SF.Net email is sponsored by: NEC IT Guy Games.  How far can you =
shotput a projector? How fast can you ride your desk chair down the =
office luge track?
If you want to score the big prize, get to know the little guy. =20
Play to win an NEC 61" plasma display: http://www.necitguy.com/?r=3D20 =
_______________________________________________
Arsperl-users mailing list
Ars...@ar...
https://lists.sourceforge.net/lists/listinfo/arsperl-users

Re: [Arsperl-users] ARSPerl 1.83 against 6.3?

[JoAnne M. <jo...@oi...>]

Thanks - It gives me hope!!

Did you have to do much tweaking?
We are running 6.3 on RHEL AS3 with Perl 5.86.

When I run "make test", I get many "dubious" results.  It seems to be having
an issue with Object Locking...

(sorry I did not sign my last post -)
JoAnne Martone
UMASS Amherst


----- Original Message ----- 
From: "Mark Vaughan" <Mar...@ev...>
To: <ars...@ar...>
Sent: Friday, June 10, 2005 12:05 PM
Subject: RE: [Arsperl-users] ARSPerl 1.83 against 6.3?


I am using 1.83 on a 6.3 server running Solaris 5.8 with Perl 5.6.1.

HTH,
Mark

Mark Vaughan

Programmer III



Direct: +1 303 802 2426

Cell: +1 303 601 4434

Fax: +1 303 802 1420

mar...@ev...

Evolving Systems, Inc.

9777 Pyramid Court, Suite 100, Englewood, CO USA 80112

www.evolving.com


-----Original Message-----
From: ars...@ar...
[mailto:ars...@ar...] On Behalf Of JoAnne Martone
Sent: Friday, June 10, 2005 9:33 AM
To: AR...@AR...; ars...@ar...
Subject: [Arsperl-users] ARSPerl 1.83 against 6.3?

Anyone have success with ARSPerl on a 6.3 server yet?

RE: [Arsperl-users] ARSPerl 1.83 against 6.3?

[Mark V. <Mar...@ev...>]

I am using 1.83 on a 6.3 server running Solaris 5.8 with Perl 5.6.1.

HTH,
Mark

Mark Vaughan

Programmer III

=20

Direct: +1 303 802 2426

Cell: +1 303 601 4434

Fax: +1 303 802 1420

mar...@ev...

Evolving Systems, Inc.=20

9777 Pyramid Court, Suite 100, Englewood, CO USA 80112

www.evolving.com


-----Original Message-----
From: ars...@ar...
[mailto:ars...@ar...] On Behalf Of JoAnne Martone
Sent: Friday, June 10, 2005 9:33 AM
To: AR...@AR...; ars...@ar...
Subject: [Arsperl-users] ARSPerl 1.83 against 6.3?

Anyone have success with ARSPerl on a 6.3 server yet?

I didnt fully read an email from Matt Reinfeld several months back
titled
"ARSPerl 1.81 for ARS 6.x" and believed that we were all set for 6.x,
but
within the email he was very clear that it was good to go for 6.1 only.





-------------------------------------------------------
This SF.Net email is sponsored by: NEC IT Guy Games.  How far can you
shotput
a projector? How fast can you ride your desk chair down the office luge
track?
If you want to score the big prize, get to know the little guy. =20
Play to win an NEC 61" plasma display: http://www.necitguy.com/?r=3D20
_______________________________________________
Arsperl-users mailing list
Ars...@ar...
https://lists.sourceforge.net/lists/listinfo/arsperl-users
This e-mail and any attachments may be confidential and/or legally privil=
eged. If you have received this e-mail and you are not a named addressee,=
 please inform Evolving Systems TIS at ti...@ev... and then delete t=
he e-mail from your system. If you are not a named addressee you must not=
 use, disclose, distribute, copy, print or rely on this e-mail. To ensure=
 regulatory compliance and for the protection of our clients and business=
, Evolving Systems may monitor and read e-mails sent to and from its serv=
ers. Although Evolving Systems routinely screens for viruses, addressees =
should scan this e-mail and any attachments for viruses. Evolving Systems=
 makes no representation or warranty as to the absence of viruses in this=
 e-mail or any attachments.=20

Registered Office: 9777 Mt. Pyramid Ct Suite 100, Englewood, CO 80112

[Arsperl-users] ARSPerl 1.83 against 6.3?

[JoAnne M. <jo...@oi...>]

Anyone have success with ARSPerl on a 6.3 server yet?

I didnt fully read an email from Matt Reinfeld several months back titled
"ARSPerl 1.81 for ARS 6.x" and believed that we were all set for 6.x, but
within the email he was very clear that it was good to go for 6.1 only.

RE: [Arsperl-users] REmedy problem

[Amen A. <aas...@ho...>]

yes it does.

Amen.

>From: Steve McDonald <ste...@ch...>
>Reply-To: ars...@ar...
>To: ars...@ar...
>Subject: RE: [Arsperl-users] REmedy problem
>Date: Thu, 09 Jun 2005 13:28:54 -0700
>
>Does the script user(remedy install user) have permissions to create files
>in the specified location?
>
>-----Original Message-----
>From: ars...@ar...
>[mailto:ars...@ar...] On Behalf Of Amen Asemota
>Sent: Thursday, June 09, 2005 1:21 PM
>To: ars...@ar...
>Subject: RE: [Arsperl-users] REmedy problem
>
>Yes it does. I do have another problem though. It is supposed to be 
>creating
>
>a text file also but it's not doing that. It just sets the field and that's
>it.
>
>Thanks.
>
>Amen.
>
> >From: "PC Wai" <PC...@TE...>
> >Reply-To: ars...@ar...
> >To: <ars...@ar...>
> >Subject: RE: [Arsperl-users] REmedy problem
> >Date: Thu, 9 Jun 2005 09:03:33 -0700
> >
> >Hi Amen,
> >
> >Just a wild guess. Does your Remedy owner have execution permission to 
>the
> >script and the modules?
> >
> >Regards
> >PC
> >
> >-----Original Message-----
> >From: ars...@ar...
> >[mailto:ars...@ar...] On Behalf Of Amen Asemota
> >Sent: Thursday, June 09, 2005 08:53
> >To: ars...@ar...
> >Subject: RE: [Arsperl-users] REmedy problem
> >
> >
> >Yes it does it prints out the word "Sent" and it also creates a txt file
> >which we also need.
> >
> >Amen.
> > >From: Steve McDonald <ste...@ch...>
> > >Reply-To: ars...@ar...
> > >To: ars...@ar...
> > >Subject: RE: [Arsperl-users] REmedy problem
> > >Date: Thu, 09 Jun 2005 08:20:22 -0700
> > >
> > >Does this script work from the command line?
> > >
> > >-----Original Message-----
> > >From: ars...@ar...
> > >[mailto:ars...@ar...] On Behalf Of Amen Asemota
> > >Sent: Thursday, June 09, 2005 6:42 AM
> > >To: ars...@ar...
> > >Subject: Re: [Arsperl-users] REmedy problem
> > >
> > >Hi Carey and Steve,
> > >
> > >Here is my Code :
> > >
> > >#!/usr/bin/perl
> > >
> > >#use strict 'vars';
> > >my $status = "Active";
> > >my $count3 = 0;
> > >my $countDTR = 0;
> > >my @save_DTR;
> > >my @save_entry;
> > >my @save_type;
> > >my @save_PartNumber;
> > >my @save_ProductName;
> > >my @save_qty;
> > >my @save_unitCost;
> > >my @save_ExtendedCost;
> > >my $save_filename;
> > >my $DTR = "DTR";
> > >my $flag = 1;
> > >my $flag2 = "Sent" ;
> > >
> > >use arControl;
> > >my $server = $arControl::SERVER;
> > >my $username = $arControl::USERNAME;
> > >my $pw = $arControl::PW;
> > >use ARS;
> > >#open(TXT,">datafile.txt") ||die printf "unable to open flat file\n";
> > >
> > ># text file opened
> > >#printf "The datafile has been opened\n"; $ctrl =
> > >ars_Login($server,$username,$pw)||die printf "AR Server login Error\n";
> > >#$query = "'650001031' != \$NULL\$"; #my $query = "'Assigned To' !=
> > >\$NULL\$"; my $query = "'PO Flag?'!= \$NULL\$"; my $qual =
> > >ars_LoadQualifier($ctrl, "Schema",$query);
> > >if(!defined($qual))
> > >{
> > >         $error = "Unable to create Schema Load qualifier $ars_errstr";
> > >}
> > >
> > ># created the qualifier
> > >#printf "Qualifier has been created\n"; %firstentry =
> > >ars_GetListEntry($ctrl,"Schema",$qual,0);
> > >#getting DTR numbers
> > >#printf "DTR numbers being retrieved\n"; foreach $entryId (sort keys
> > >%firstentry) {
> > >     %firstvalue = ars_GetEntry($ctrl,"Schema", $entryId, 650001006);
> > >     foreach $entryId (sort keys %firstvalue)
> > >     {
> > >        $save_DTR{$countDTR} = $firstvalue{650001006};
> > >        $save_entry{$countDTR} = $entryId;
> > >#      printf $save_DTR{$countDTR};
> > >        $countDTR++;
> > >       }
> > >}
> > >#printf("DTR count=%d\n",$countDTR);
> > ># creating the header file
> > >print TXT "H","0001","0000000","000000","000","0000000000";
> > >print TXT "00000","00000","00000000";
> > ># Retrieving the Items for this DTR  table
> > >
> > >$qualb = ars_LoadQualifier($ctrl,"Schema2", "1=1");
> > >if(!defined($qualb))
> > >         {
> > >                 $error = "Unable to create Schema2  Load qual ifier
> > >$ars_errstr";
> > >         }
> > >for($count3 = 0; $count3 < $countDTR; $count3++) {# printf("next
> > >DTR=%s\n",$save_DTR{$count3}); $save_filename =
> > >$DTR.$save_DTR{$count3};
> > >open(TXT,">$save_filename.txt") ||die printf "unable to open flat
> > >file\n"; #printf($save_filename, "\n"); %second =
> > >ars_GetListEntry($ctrl,"Schema2",$qualb, 0); my $allHWSW=0; my
> > >$prtHWSW=0;
> > >
> > >foreach $entryId(sort keys %second)
> > >{      $allHWSW++;
> > >         #Gets table information
> > >         %secondvalue = ars_GetEntry($ctrl,"Schema2",$entryId,
> > >650008002,8,7,650008003,650008007,
> > >                  650008016,650008005,650008004,650008015);
> > >        if(($secondvalue{650008002} eq $save_DTR{$count3}) &&
> > >(($secondvalue{6500 08015} == 0) && ($secondvalue{7} == 0)))
> > >               { $prtHWSW++;
> > >                  $save_type{$count3}= $secondvalue{8};
> > >                  $save_PartNumber{$count3} = $secondvalue{650008003};
> > >                  $save_ProductName{$count3} = $secondvalue{650008007};
> > >                  $save_qty{$count3} = $secondvalue{650008016};
> > >                  $save_unitCost{$count3} = $secondvalue{650008005};
> > >                  $save_extendedCost{$count3} = 
>$secondvalue{650008004};
> > >                  $save_WO{$count3} = $secondvalue{650008015};
> > >                  $save_Status{$count3} = $secondvalue{7};
> > >                 #send items to file
> > >                 print TXT $save_DTR{$count3};
> > >                 print TXT "L","0001","0000000","000000","000","0";
> > >                 print TXT $save_type{$count3};
> > >                 print TXT $save_PartNumber{$count3};
> > >                 print TXT $save_ProductName{$count3},"  ";
> > >                 print TXT $save_qty{$count3},"  ";
> > >                 print TXT $save_unitCost{$count3},"  ";
> > >                 print TXT $save_extendedCost{$count3};
> > >                 #$count3++;
> > >            }
> > >   }
> > >#printf("   allHWSW=%d prtHWSW=%d\n",$allHWSW,$prtHWSW);
> > >close(TXT);
> > >}
> > >
> > >#close(TXT);
> > >ars_Logoff($ctrl);
> > >print "Sent \n";
> > >exit(0);
> > >
> > >
> > >
> > >
> > >Then in the Remedy filter i enter the process $PROCESS$ /path/file.pl
> > >because I want it to Set a text field in the filter to "Sent". With the
> > >exit(0), I am still getting the same error msg. This script compiles
> > >with no
> > >
> > >problem in Unix and it prints out Sent to the STDOUT but when I use it
> > >in the set field it keep getting the error ARERR [38] Filter/escalation
> > >'set field' process returned an error.
> > >
> > >
> > >
> > >Thanks.
> > >
> > >Amen.
> > >
> > > >From: Carey Matthew Black <bla...@gm...>
> > > >Reply-To: ars...@ar...
> > > >To: ars...@ar...
> > > >Subject: Re: [Arsperl-users] REmedy problem
> > > >Date: Wed, 8 Jun 2005 11:04:16 -0500
> > > >
> > > >Amen,
> > > >
> > > >Make sure your script always exits with status zero.
> > > >exit(0);
> > > >If you do not exit with a status of zero then the ARS server will
> > > >throw an exception.
> > > >
> > > >print anything to STDOUT that you want to to end up in the field.
> > > >
> > > >A simple example would be:
> > > >#! /usr/bin/perl
> > > >print "The fields new value is this whole string"; exit(0);
> > > >
> > > >
> > > >Also .. in the filter.. make sure you fully qualify the path to the
> > > >perl script and maybe even perl itself.
> > > >
> > > >/path/to/myscript/junk.pl
> > > >
> > > >or maybe...
> > > >
> > > >/usr/bin/perl /path/to/myscript/junk.pl
> > > >
> > > >
> > > >You can also run Filter logs and check the arerror.log for more
> > > >details on what the ARS server is seeing from the script too.
> > > >
> > > >Hope that helps.
> > > >
> > > >--
> > > >Carey Matthew Black
> > > >Remedy Skilled Professional (RSP)
> > > >ARS = Action Request System(Remedy)
> > > >
> > > >Solution = People + Process + Tools
> > > >Fast, Accurate, Cheap.... Pick two.
> > > >Never ascribe to malice, that which can be explained by incompetence.
> > > >
> > > >http://www.fellowshipchurch.com
> > > >
> > > >On 6/8/05, Amen Asemota <aas...@ho...> wrote:
> > > > > Hi,
> > > > >
> > > > > I am trying to run a perl script in a filter but i keep getting
> > > > > ARERR
> > > >[38]
> > > > > Filter/escalation 'set field' process returned an error.
> > > > >
> > > > > Iam trying to use the $PROCESS$ command to set a field . Please
> >help..
> > > > >
> > > > > _________________________________________________________________
> > > > > Express yourself instantly with MSN Messenger! Download today it's
> > >FREE!
> > > > > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
> > > > >
> > > > >
> > > > >
> > > > > -------------------------------------------------------
> > > > > This SF.Net email is sponsored by: NEC IT Guy Games.  How far can
> > > > > you
> > > >shotput
> > > > > a projector? How fast can you ride your desk chair down the office
> > >luge
> > > >track?
> > > > > If you want to score the big prize, get to know the little guy.
> > > > > Play to win an NEC 61" plasma display:
> > > > > http://www.necitguy.com/?r=20
> > > > > _______________________________________________
> > > > > Arsperl-users mailing list
> > > > > Ars...@ar...
> > > > > https://lists.sourceforge.net/lists/listinfo/arsperl-users
> > > > >
> > > >
> > > >
> > > >
> > > >-------------------------------------------------------
> > > >This SF.Net email is sponsored by: NEC IT Guy Games.  How far can you
> > > >shotput a projector? How fast can you ride your desk chair down the
> > > >office luge track?
> > > >If you want to score the big prize, get to know the little guy.
> > > >Play to win an NEC 61" plasma display: http://www.necitguy.com/?r
> > > >_______________________________________________
> > > >Arsperl-users mailing list
> > > >Ars...@ar...
> > > >https://lists.sourceforge.net/lists/listinfo/arsperl-users
> > >
> > >_________________________________________________________________
> > >Express yourself instantly with MSN Messenger! Download today it's 
>FREE!
> > >http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
> > >
> > >
> > >
> > >-------------------------------------------------------
> > >This SF.Net email is sponsored by: NEC IT Guy Games.  How far can you
> > >shotput a projector? How fast can you ride your desk chair down the
> > >office luge track?
> > >If you want to score the big prize, get to know the little guy.
> > >Play to win an NEC 61" plasma display: http://www.necitguy.com/?r=20
> > >_______________________________________________
> > >Arsperl-users mailing list
> > >Ars...@ar...
> > >https://lists.sourceforge.net/lists/listinfo/arsperl-users
> > >
> > >
> > >
> > >-------------------------------------------------------
> > >This SF.Net email is sponsored by: NEC IT Guy Games.  How far can you
> > >shotput a projector? How fast can you ride your desk chair down the
> > >office luge track?
> > >If you want to score the big prize, get to know the little guy.
> > >Play to win an NEC 61" plasma display: http://www.necitguy.com/?r=20
> > >_______________________________________________
> > >Arsperl-users mailing list
> > >Ars...@ar...
> > >https://lists.sourceforge.net/lists/listinfo/arsperl-users
> >
> >_________________________________________________________________
> >Express yourself instantly with MSN Messenger! Download today it's FREE!
> >http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
> >
> >
> >
> >-------------------------------------------------------
> >This SF.Net email is sponsored by: NEC IT Guy Games.  How far can you
> >shotput a projector? How fast can you ride your desk chair down the 
>office
> >luge track?
> >If you want to score the big prize, get to know the little guy.
> >Play to win an NEC 61" plasma display: http://www.necitguy.com/?r=20
> >_______________________________________________
> >Arsperl-users mailing list
> >Ars...@ar...
> >https://lists.sourceforge.net/lists/listinfo/arsperl-users
> >
> >
> >
> >-------------------------------------------------------
> >This SF.Net email is sponsored by: NEC IT Guy Games.  How far can you
> >shotput
> >a projector? How fast can you ride your desk chair down the office luge
> >track?
> >If you want to score the big prize, get to know the little guy.
> >Play to win an NEC 61" plasma display: http://www.necitguy.com/?r
> >_______________________________________________
> >Arsperl-users mailing list
> >Ars...@ar...
> >https://lists.sourceforge.net/lists/listinfo/arsperl-users
>
>_________________________________________________________________
>Express yourself instantly with MSN Messenger! Download today it's FREE!
>http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by: NEC IT Guy Games.  How far can you
>shotput
>a projector? How fast can you ride your desk chair down the office luge
>track?
>If you want to score the big prize, get to know the little guy.
>Play to win an NEC 61" plasma display: http://www.necitguy.com/?r=20
>_______________________________________________
>Arsperl-users mailing list
>Ars...@ar...
>https://lists.sourceforge.net/lists/listinfo/arsperl-users
>
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by: NEC IT Guy Games.  How far can you 
>shotput
>a projector? How fast can you ride your desk chair down the office luge 
>track?
>If you want to score the big prize, get to know the little guy.
>Play to win an NEC 61" plasma display: http://www.necitguy.com/?r=20
>_______________________________________________
>Arsperl-users mailing list
>Ars...@ar...
>https://lists.sourceforge.net/lists/listinfo/arsperl-users

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/