arsperl-users — Discussions regarding the use of ARSperl

[Arsperl-users] Manually passing arguments to a cgi program

[Steve M. <ste...@ch...>]

Can anyone help me with the syntax for passing arguments to a cgi program via the unix command line? Someone else is writing the web interface to the program and I don't want to wait to get the debugging started.
 
 
Thanks!

[Arsperl-users] Cannot connect to remote server

[Wesley S. <wes...@or...>]

All,

we currently have an issue with ARS perl and setting up the connection
with our Remedy server.

With this sample script we are trying to connect to the server:

use strict;

my ($server, $account, $password, $port) = ("my-server.wanadoo.nl", "username", "passwd", 20320);

my $c = ars_Login($server, $account, $password, undef, undef, $port, undef);

print STDERR $ars_errstr . "\n" if $ars_errstr;

Its working for one box, but on another box we get the following error:

   [ERROR] Message not in catalog; Message number = 150 () (ARERR #150


What can explain this?

ARS perl is compiled against the 7.0 API on the box which returns the
error. 
ARS perl is compiled against the 6.3 API on the box where we don't have
any problems.

As far as I understood, we should be able to connect eventhough we are
using the 7.0 API and are using 6.3 on our Remedy server.


Cheers,
Wesley

-- 
Orange Nederland Breedband BV, http://www.orange.nl & http://www.equant.nl & http://www.euronet.nl
Wesley Schwengle, Jr. System Administrator, IT Operations - Business Systems
Muiderstraat 1, P.o. BOX 10241 , 1001 EE Amsterdam
T:+31 (0)20 535 52 55, F:+31 (0)20 535 57 49

Re: [Arsperl-users] Function to Close a ticket

[Richard H. <ric...@ho...>]

All you need to do is call ars_MergeEntry and change the Status field to th=
e value representing 'Closed'. E.g. you would write:
=20
my $response =3D ars_MergeEntry(
     $ctrl,
     $schema,
     1028,
     1,
     $ticket_number,
     $status_field_id,
     N
);
=20
where N is the numeric value corresponding to "Closed" (BTW, the above assu=
mes that 1 is the field-id of the "ticket number" field).
=20
Cheers,
=20
Richard.
=20



> Date: Mon, 12 Nov 2007 14:37:34 -0500> From: ra...@co...> To: arsperl-=
us...@ar...> Subject: [Arsperl-users] Function to Close a ticket> > H=
i: is there a function in ARS Perl that can be used to update the > Status =
to Closed in the help desk?> > Thanks> > ----------------------------------=
---------------------------------------> This SF.net email is sponsored by:=
 Splunk Inc.> Still grepping through log files to find problems? Stop.> Now=
 Search log events and configuration files using AJAX and a browser.> Downl=
oad your FREE copy of Splunk now >> http://get.splunk.com/> _______________=
________________________________> Arsperl-users mailing list> Arsperl-users=
@arsperl.org> https://lists.sourceforge.net/lists/listinfo/arsperl-users
_________________________________________________________________
The next generation of MSN Hotmail has arrived - Windows Live Hotmail
http://www.newhotmail.co.uk=

Re: [Arsperl-users] Function to Close a ticket

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

Yep.
ars_SetEntry

Basic sketch of the program would need to do at least these things..

1) login to ARS
2) Have (be supplied) or find the Entry ID(Request ID, record ID,
field 1 value) for the record of interest
3) call the ars_SetEntry function to update any/all fields that need
to be changed.
4) logout

In sort that should get the job done.

I think part #3 should be something like....

$r = ars_SetEntry($ctrl, $schema, $entryid, 0, 7, 5);

Assuming your 'Status' field is Field id 7 and your "Closed" value is value 5.

HTH.

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

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap.... Pick two.



On Nov 12, 2007 2:37 PM, Ravi <ra...@co...> wrote:
> Hi: is there a function in ARS Perl that can be used to update the
> Status to Closed in the help desk?
>
> Thanks

[Arsperl-users] Function to Close a ticket

[Ravi <ra...@co...>]

Hi: is there a function in ARS Perl that can be used to update the 
Status to Closed in the help desk?

Thanks

[Arsperl-users] Out of Office

[Thomas B. <BE...@SL...>]

Thank you for your message.  I am currently out of the office
attending a conference the week of Oct. 29th, returning to the office
on Monday, Nov. 5th.  I will not be checking e-mail on a regular
basis.  Your message has been saved and will be read upon my return.

[Arsperl-users] ARSPerl Install Problem memcluster.c:355: REQUIRE(freelists != NULL)

[Boisen, J. P. <boi...@ma...>]

Our system administrators changed our host from Solaris 9 to Solaris 10
and ARSPerl no longer works.  I have tried re-installing various
versions from ARSPerl 1.83 to 1.90.  I am receiving the following error
during make test.  Any help would be appreciated.

**** ERROR MESSAGE ****
memcluster.c:355: REQUIRE(freelists !=3D NULL)

**** System Information ****
Solaris 10
Remedy 6.03
Tried ARSPerl versions 1.83, 1.85, and 1.90

Thanks,
Jeff

Re: [Arsperl-users] Need assitance in Installing ARSperl

[Thilo S. <thi...@ap...>]

Generally, you have to use same compiler (or compiler version) for 
ARSperl that the perl interpreter itself was compiled with. You can 
check this by executing "perl -V".


VS, Shreyas wrote:
> Hi All,
> 
> Can you please assist me in installing ARSperl as I am getting the 
> following error.
> 
> ------------------------------------------
> $ make
> Skip blib/lib/ARSnt-h.pm (unchanged)
> Skip blib/lib/ARS.pm (unchanged)
> Skip blib/lib/ARSOOmsgs.pm (unchanged)
> Skip blib/lib/ARSnparm.pm (unchanged)
> Skip blib/lib/ARSarerrno-h.pm (unchanged)
> Skip blib/lib/ARSar-h.pm (unchanged)
> Skip blib/lib/ARSnterrno-h.pm (unchanged)
> Skip blib/lib/ARSOOform.pm (unchanged)
> Skip blib/lib/ARSOOsup.pm (unchanged)
>         gcc -c -I/usr/ar/api/include -D_POSIX_C_SOURCE=199506L 
> -D_HPUX_SOURCE -L/lib/pa1.1 -DUINT32_MAX_BROKEN -mpa-risc-1-1 -fPIC 
> -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE 
> -D_FILE_OFFSET_BITS=64 -O    -DVERSION=\"1.82\"  -DXS_VERSION=\"1.82\" 
> -fPIC -I/opt/perl/lib/5.6.1/PA-RISC1.1-thread-multi/CORE -g  -DARS32  
> -DARS452  -DPERL_PATCHLEVEL_IS=6 -DPERL_SUBVERSION_IS=1 
> -DPERL_BASEREV_IS=50  ARS.c
> 
> In file included from 
> /opt/perl/lib/5.6.1/PA-RISC1.1-thread-multi/CORE/perl.h:713,
>                  from support.h:70,
>                  from ARS.xs:26:
> /usr/include/sys/socket.h:484: parse error before "sendfile"
> /usr/include/sys/socket.h:484: parse error before "bsize_t"
> /usr/include/sys/socket.h:486: parse error before "sendpath"
> /usr/include/sys/socket.h:486: parse error before "bsize_t"
> *** Error exit code 1
> 
> Stop.
> ---------------------------------------------
> 
> It will be nice if you can help me out as it is quite urgent.
> 
> Thanks.
> 
> Regards,
> *Shreyas VS*
> OHS Development Team.
> Infosys Technologies Limited, Mysore, India
> Desk: +91-821-4071614
> 
> 
> 
> 
> *************************************************************************************
> The message is intended for the named addressee only and may not be 
> disclosed to or used by anyone else, nor may it be copied in any way.
> 
> The contents of this message and its attachments are confidential and 
> may also be subject to legal privilege. If you are not the named 
> addressee and/or have received this message in error, please advise us 
> by e-mailing sec...@co... and delete the message and any 
> attachments without retaining any copies.
> 
> Internet communications are not secure and COLT does not accept 
> responsibility for this message, its contents nor responsibility for any 
> viruses.
> 
> No contracts can be created or varied on behalf of COLT 
> Telecommunications, its subsidiaries or affiliates ("COLT") and any 
> other party by email Communications unless expressly agreed in writing 
> with such other party.
> 
> Please note that incoming emails will be automatically scanned to 
> eliminate potential viruses and unsolicited promotional emails. For more 
> information refer to www.colt.net or contact us on +44(0)20 7390 3900.
> 
> 
> ------------------------------------------------------------------------
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users

Re: [Arsperl-users] Need assitance in Installing ARSperl

[VS, S. <Shr...@co...>]

Hi,

I am using HP-UX.
Will this be of any help?

Regards,
Shreyas VS
OHS Development Team.
>Infosys Technologies Limited, Mysore, India
>Desk: +91-821-4071614
>


-----Original Message-----
From: ars...@ar...
[mailto:ars...@ar...] On Behalf Of Axton
Sent: 23 October 2007 16:22
To: ARSperl User Discussion
Subject: Re: [Arsperl-users] Need assitance in Installing ARSperl


What platform and OS?  I've had better luck with native compilers on
many platforms (e.g., SUNWspro's cc on Solaris).

Axton Grams

On 10/23/07, VS, Shreyas <Shr...@co...> wrote:
>
>
>
> Hi All,
>
> Can you please assist me in installing ARSperl as I am getting the=20
> following error.
>
> ------------------------------------------
> $ make
> Skip blib/lib/ARSnt-h.pm (unchanged)
> Skip blib/lib/ARS.pm (unchanged)
> Skip blib/lib/ARSOOmsgs.pm (unchanged)
> Skip blib/lib/ARSnparm.pm (unchanged)
> Skip blib/lib/ARSarerrno-h.pm (unchanged)
> Skip blib/lib/ARSar-h.pm (unchanged)
> Skip blib/lib/ARSnterrno-h.pm (unchanged)
> Skip blib/lib/ARSOOform.pm (unchanged)
> Skip blib/lib/ARSOOsup.pm (unchanged)
>         gcc -c -I/usr/ar/api/include -D_POSIX_C_SOURCE=3D199506L=20
> -D_HPUX_SOURCE -L/lib/pa1.1 -DUINT32_MAX_BROKEN -mpa-risc-1-1 -fPIC=20
> -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE
> -D_FILE_OFFSET_BITS=3D64 -O    -DVERSION=3D\"1.82\"  -DXS_VERSION=3D\"1.8=
2\"
-fPIC
> -I/opt/perl/lib/5.6.1/PA-RISC1.1-thread-multi/CORE -g  -DARS32 =20
> -DARS452 -DPERL_PATCHLEVEL_IS=3D6 -DPERL_SUBVERSION_IS=3D1=20
> -DPERL_BASEREV_IS=3D50  ARS.c
>
> In file included from=20
> /opt/perl/lib/5.6.1/PA-RISC1.1-thread-multi/CORE/perl.h:713,
>                  from support.h:70,
>                  from ARS.xs:26:
> /usr/include/sys/socket.h:484: parse error before "sendfile"
> /usr/include/sys/socket.h:484: parse error before "bsize_t"
> /usr/include/sys/socket.h:486: parse error before "sendpath"
> /usr/include/sys/socket.h:486: parse error before "bsize_t"
> *** Error exit code 1
>
> Stop.
> ---------------------------------------------
>
> It will be nice if you can help me out as it is quite urgent.
>
> Thanks.
>
> Regards,
> Shreyas VS
> OHS Development Team.
> Infosys Technologies Limited, Mysore, India
> Desk: +91-821-4071614
>
>
> **********************************************************************
> ***************
>  The message is intended for the named addressee only and may not be
> disclosed to or used by anyone else, nor may it be copied in any way.
>
>  The contents of this message and its attachments are confidential and

> may also be subject to legal privilege. If you are not the named=20
> addressee and/or have received this message in error, please advise us

> by e-mailing sec...@co... and delete the message and any=20
> attachments without retaining any copies.
>
>  Internet communications are not secure and COLT does not accept=20
> responsibility for this message, its contents nor responsibility for=20
> any viruses.
>
>  No contracts can be created or varied on behalf of COLT=20
> Telecommunications, its subsidiaries or affiliates ("COLT") and any=20
> other party by email Communications unless expressly agreed in writing

> with such other party.
>
>  Please note that incoming emails will be automatically scanned to=20
> eliminate potential viruses and unsolicited promotional emails. For=20
> more information refer to www.colt.net or contact us on +44(0)20 7390=20
> 3900.
>
> ----------------------------------------------------------------------
> ---
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a
browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
>
>

------------------------------------------------------------------------
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Arsperl-users mailing list
Ars...@ar...
https://lists.sourceforge.net/lists/listinfo/arsperl-users


***************************************************************************=
**********
The message is intended for the named addressee only and may not be disclos=
ed to or used by anyone else, nor may it be copied in any way.=20

The contents of this message and its attachments are confidential and may a=
lso be subject to legal privilege.  If you are not the named addressee and/=
or have received this message in error, please advise us by e-mailing secur=
it...@co... and delete the message and any attachments without retaining a=
ny copies.=20

Internet communications are not secure and COLT does not accept responsibil=
ity for this message, its contents nor responsibility for any viruses.=20

No contracts can be created or varied on behalf of COLT Telecommunications,=
 its subsidiaries or affiliates ("COLT") and any other party by email Commu=
nications unless expressly agreed in writing with such other party. =20

Please note that incoming emails will be automatically scanned to eliminate=
 potential viruses and unsolicited promotional emails. For more information=
 refer to www.colt.net or contact us on +44(0)20 7390 3900.

Re: [Arsperl-users] Need assitance in Installing ARSperl

[Axton <axt...@gm...>]

What platform and OS?  I've had better luck with native compilers on
many platforms (e.g., SUNWspro's cc on Solaris).

Axton Grams

On 10/23/07, VS, Shreyas <Shr...@co...> wrote:
>
>
>
> Hi All,
>
> Can you please assist me in installing ARSperl as I am getting the following
> error.
>
> ------------------------------------------
> $ make
> Skip blib/lib/ARSnt-h.pm (unchanged)
> Skip blib/lib/ARS.pm (unchanged)
> Skip blib/lib/ARSOOmsgs.pm (unchanged)
> Skip blib/lib/ARSnparm.pm (unchanged)
> Skip blib/lib/ARSarerrno-h.pm (unchanged)
> Skip blib/lib/ARSar-h.pm (unchanged)
> Skip blib/lib/ARSnterrno-h.pm (unchanged)
> Skip blib/lib/ARSOOform.pm (unchanged)
> Skip blib/lib/ARSOOsup.pm (unchanged)
>         gcc -c -I/usr/ar/api/include -D_POSIX_C_SOURCE=199506L
> -D_HPUX_SOURCE -L/lib/pa1.1 -DUINT32_MAX_BROKEN -mpa-risc-1-1 -fPIC
> -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE
> -D_FILE_OFFSET_BITS=64 -O    -DVERSION=\"1.82\"  -DXS_VERSION=\"1.82\" -fPIC
> -I/opt/perl/lib/5.6.1/PA-RISC1.1-thread-multi/CORE -g  -DARS32  -DARS452
> -DPERL_PATCHLEVEL_IS=6 -DPERL_SUBVERSION_IS=1 -DPERL_BASEREV_IS=50  ARS.c
>
> In file included from
> /opt/perl/lib/5.6.1/PA-RISC1.1-thread-multi/CORE/perl.h:713,
>                  from support.h:70,
>                  from ARS.xs:26:
> /usr/include/sys/socket.h:484: parse error before "sendfile"
> /usr/include/sys/socket.h:484: parse error before "bsize_t"
> /usr/include/sys/socket.h:486: parse error before "sendpath"
> /usr/include/sys/socket.h:486: parse error before "bsize_t"
> *** Error exit code 1
>
> Stop.
> ---------------------------------------------
>
> It will be nice if you can help me out as it is quite urgent.
>
> Thanks.
>
> Regards,
> Shreyas VS
> OHS Development Team.
> Infosys Technologies Limited, Mysore, India
> Desk: +91-821-4071614
>
>
> *************************************************************************************
>  The message is intended for the named addressee only and may not be
> disclosed to or used by anyone else, nor may it be copied in any way.
>
>  The contents of this message and its attachments are confidential and may
> also be subject to legal privilege. If you are not the named addressee
> and/or have received this message in error, please advise us by e-mailing
> sec...@co... and delete the message and any attachments without
> retaining any copies.
>
>  Internet communications are not secure and COLT does not accept
> responsibility for this message, its contents nor responsibility for any
> viruses.
>
>  No contracts can be created or varied on behalf of COLT Telecommunications,
> its subsidiaries or affiliates ("COLT") and any other party by email
> Communications unless expressly agreed in writing with such other party.
>
>  Please note that incoming emails will be automatically scanned to eliminate
> potential viruses and unsolicited promotional emails. For more information
> refer to www.colt.net or contact us on +44(0)20 7390 3900.
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
>
>

Re: [Arsperl-users] Can't load ARS.dll

[Andreas F. <an...@th...>]

*bump*

Were sitting here enjoying my day and that everything solved out pretty nice
when the damn thing all of the sudden just crashed.

I'm getting the same message in the apache error log but now it complains
about a file called MSVCR71.dll which even doesn't seem to be a part of the
c api.

According to a forum on idg.se it's a windows dll part of Windows,
Microsoft(R) C Runtime Library, version 7.1.

Anyway. I tried to search for it on the local computer and I found it. I
thought what the hell and copied it over to the %win%/system32 and it
worked. That however made it complain about MSVCP71.dll. Again, i found it
and thought what the hell and copied. It worked, it doesn't complain about
anything any longer.

Is there anything you shouldn't install for arsperl because everything was
working fine without them for 10 min before it crashed?

2007/10/22, Andreas Falk <an...@th...>:
>
> Actually it works if i put the following dll's in "
> C:/Perl/site/lib/auto/ARS/".
>
> arapi70.dll
> arutl70.dll
> icuin32.dll
> icuuc32.dll
> icudt32.dll
> arrpc70.dll
>
> But it wonder why it doesn't find them without them there. I mean, they
> path environ var is pointing to the right dir and shouldn't that be enough?
>
> // Andreas
>
> 2007/10/22, Andreas Falk <an...@th...>:
> >
> > Hehe thanks :)
> >
> > Tried to run perl -e "use ARS;" from the commend line and it says that
> > it can't find arapi70.dll which i can't understant since i've put the
> > path to it in the path environ var.
> >
> > I'll do what you say and check if that works.
> >
> > // Andreas
> >
> > 2007/10/21, Michiel Beijen < mic...@gm...>:
> > >
> > > And for your issue:
> > > Are you able to run a small script like this from the command line:
> > > (c:\perl\bin\perl.exe myscript.pl)
> > > -----
> > > use ARS;
> > > $v = ars_APIVersion();
> > > print "This installation of ARSperl was compiled against ARS API
> > > version $v\n";
> > > ----
> > > This will probably give you an idea as to what actually is wrong with
> > > your setup.
> > >
> > > You might want to move the ARS dll files into the
> > > C:\Perl\site\lib\auto\ARS directory.
> > >
> > > Regards,
> > >
> > > Michiel
> > >
> > > On 10/20/07, Andreas Falk < an...@th...> wrote:
> > > > Well yea, that is a bit too obvious unfortunately.
> > > >
> > > > I didn't compile it myself. I got the ppd version from sourceforge.
> > > And yes
> > > > the file is there. Also got the c api installed correctly. It's in
> > > c:/arsapi
> > > > and i've set the path environment variable to point there.
> > > >
> > > > It's a windows computer, forgot to mention that but I'm not sure how
> > > much it
> > > > matters.
> > > >
> > > > I've never used this type of mailing list before so I'm not sure if
> > > this
> > > > will be a whole new post now... Hope not.. Point in the right
> > > direction if i
> > > > do wrong :)
> > > >
> > > > // Andreas
> > > >
> > > >
> > > > > Maybe a little too obvious; but have you compiled ARSperl? Is the
> > > file
> > > > > that is mentioned: 'C:/Perl/site/lib/auto/ARS/ARS
> > > > > .dll', present on
> > > >  > your webserver?
> > > > > You can try and download the pre-compiled ARSperl version from
> > > > sourceforge.
> > > > >
> > > > > Regards,
> > > > >
> > > > > Michiel.
> > > >
> > > >
> > > -------------------------------------------------------------------------
> > > > This SF.net email is sponsored by: Splunk Inc.
> > > > Still grepping through log files to find problems?  Stop.
> > > > Now Search log events and configuration files using AJAX and a
> > > browser.
> > > > Download your FREE copy of Splunk now >> http://get.splunk.com/
> > > > _______________________________________________
> > > > Arsperl-users mailing list
> > > > Ars...@ar...
> > > > https://lists.sourceforge.net/lists/listinfo/arsperl-users
> > > >
> > > >
> > >
> > >
> > > --
> > > Met vriendelijke groet / Kind regards
> > > Michiel Beijen
> > > ______________________________________________________
> > > MANSOLUTIONS
> > > Energieweg 60-62
> > > 3771 NA Barneveld
> > > The Netherlands
> > > Tel. +31-(0)612968592
> > > Mail mic...@ma...
> > > Internet http://bsm.mansolutions.nl
> > >
> > > -------------------------------------------------------------------------
> > >
> > > This SF.net email is sponsored by: Splunk Inc.
> > > Still grepping through log files to find problems?  Stop.
> > > Now Search log events and configuration files using AJAX and a
> > > browser.
> > > Download your FREE copy of Splunk now >> http://get.splunk.com/
> > > _______________________________________________
> > > Arsperl-users mailing list
> > > Ars...@ar...
> > > https://lists.sourceforge.net/lists/listinfo/arsperl-users
> > >
> >
> >
>

Re: [Arsperl-users] Can't load ARS.dll

[Andreas F. <an...@th...>]

Actually it works if i put the following dll's in "
C:/Perl/site/lib/auto/ARS/".

arapi70.dll
arutl70.dll
icuin32.dll
icuuc32.dll
icudt32.dll
arrpc70.dll

But it wonder why it doesn't find them without them there. I mean, they path
environ var is pointing to the right dir and shouldn't that be enough?

// Andreas

2007/10/22, Andreas Falk <an...@th...>:
>
> Hehe thanks :)
>
> Tried to run perl -e "use ARS;" from the commend line and it says that it
> can't find arapi70.dll which i can't understant since i've put the path to
> it in the path environ var.
>
> I'll do what you say and check if that works.
>
> // Andreas
>
> 2007/10/21, Michiel Beijen <mic...@gm...>:
> >
> > And for your issue:
> > Are you able to run a small script like this from the command line:
> > (c:\perl\bin\perl.exe myscript.pl)
> > -----
> > use ARS;
> > $v = ars_APIVersion();
> > print "This installation of ARSperl was compiled against ARS API version
> > $v\n";
> > ----
> > This will probably give you an idea as to what actually is wrong with
> > your setup.
> >
> > You might want to move the ARS dll files into the
> > C:\Perl\site\lib\auto\ARS directory.
> >
> > Regards,
> >
> > Michiel
> >
> > On 10/20/07, Andreas Falk < an...@th...> wrote:
> > > Well yea, that is a bit too obvious unfortunately.
> > >
> > > I didn't compile it myself. I got the ppd version from sourceforge.
> > And yes
> > > the file is there. Also got the c api installed correctly. It's in
> > c:/arsapi
> > > and i've set the path environment variable to point there.
> > >
> > > It's a windows computer, forgot to mention that but I'm not sure how
> > much it
> > > matters.
> > >
> > > I've never used this type of mailing list before so I'm not sure if
> > this
> > > will be a whole new post now... Hope not.. Point in the right
> > direction if i
> > > do wrong :)
> > >
> > > // Andreas
> > >
> > >
> > > > Maybe a little too obvious; but have you compiled ARSperl? Is the
> > file
> > > > that is mentioned: 'C:/Perl/site/lib/auto/ARS/ARS
> > > > .dll', present on
> > >  > your webserver?
> > > > You can try and download the pre-compiled ARSperl version from
> > > sourceforge.
> > > >
> > > > Regards,
> > > >
> > > > Michiel.
> > >
> > >
> > -------------------------------------------------------------------------
> > > This SF.net email is sponsored by: Splunk Inc.
> > > Still grepping through log files to find problems?  Stop.
> > > Now Search log events and configuration files using AJAX and a
> > browser.
> > > Download your FREE copy of Splunk now >> http://get.splunk.com/
> > > _______________________________________________
> > > Arsperl-users mailing list
> > > Ars...@ar...
> > > https://lists.sourceforge.net/lists/listinfo/arsperl-users
> > >
> > >
> >
> >
> > --
> > Met vriendelijke groet / Kind regards
> > Michiel Beijen
> > ______________________________________________________
> > MANSOLUTIONS
> > Energieweg 60-62
> > 3771 NA Barneveld
> > The Netherlands
> > Tel. +31-(0)612968592
> > Mail mic...@ma...
> > Internet http://bsm.mansolutions.nl
> >
> > -------------------------------------------------------------------------
> >
> > This SF.net email is sponsored by: Splunk Inc.
> > Still grepping through log files to find problems?  Stop.
> > Now Search log events and configuration files using AJAX and a browser.
> > Download your FREE copy of Splunk now >> http://get.splunk.com/
> > _______________________________________________
> > Arsperl-users mailing list
> > Ars...@ar...
> > https://lists.sourceforge.net/lists/listinfo/arsperl-users
> >
>
>

Re: [Arsperl-users] Can't load ARS.dll

[Andreas F. <an...@th...>]

Hehe thanks :)

Tried to run perl -e "use ARS;" from the commend line and it says that it
can't find arapi70.dll which i can't understant since i've put the path to
it in the path environ var.

I'll do what you say and check if that works.

// Andreas

2007/10/21, Michiel Beijen <mic...@gm...>:
>
> And for your issue:
> Are you able to run a small script like this from the command line:
> (c:\perl\bin\perl.exe myscript.pl)
> -----
> use ARS;
> $v = ars_APIVersion();
> print "This installation of ARSperl was compiled against ARS API version
> $v\n";
> ----
> This will probably give you an idea as to what actually is wrong with
> your setup.
>
> You might want to move the ARS dll files into the
> C:\Perl\site\lib\auto\ARS directory.
>
> Regards,
>
> Michiel
>
> On 10/20/07, Andreas Falk <an...@th...> wrote:
> > Well yea, that is a bit too obvious unfortunately.
> >
> > I didn't compile it myself. I got the ppd version from sourceforge. And
> yes
> > the file is there. Also got the c api installed correctly. It's in
> c:/arsapi
> > and i've set the path environment variable to point there.
> >
> > It's a windows computer, forgot to mention that but I'm not sure how
> much it
> > matters.
> >
> > I've never used this type of mailing list before so I'm not sure if this
> > will be a whole new post now... Hope not.. Point in the right direction
> if i
> > do wrong :)
> >
> > // Andreas
> >
> >
> > > Maybe a little too obvious; but have you compiled ARSperl? Is the file
> > > that is mentioned: 'C:/Perl/site/lib/auto/ARS/ARS
> > > .dll', present on
> >  > your webserver?
> > > You can try and download the pre-compiled ARSperl version from
> > sourceforge.
> > >
> > > Regards,
> > >
> > > Michiel.
> >
> >
> -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Splunk Inc.
> > Still grepping through log files to find problems?  Stop.
> > Now Search log events and configuration files using AJAX and a browser.
> > Download your FREE copy of Splunk now >> http://get.splunk.com/
> > _______________________________________________
> > Arsperl-users mailing list
> > Ars...@ar...
> > https://lists.sourceforge.net/lists/listinfo/arsperl-users
> >
> >
>
>
> --
> Met vriendelijke groet / Kind regards
> Michiel Beijen
> ______________________________________________________
> MANSOLUTIONS
> Energieweg 60-62
> 3771 NA Barneveld
> The Netherlands
> Tel. +31-(0)612968592
> Mail mic...@ma...
> Internet http://bsm.mansolutions.nl
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
>

Re: [Arsperl-users] Can't load ARS.dll

[Michiel B. <mic...@gm...>]

And for your issue:
Are you able to run a small script like this from the command line:
(c:\perl\bin\perl.exe myscript.pl)
-----
use ARS;
$v = ars_APIVersion();
print "This installation of ARSperl was compiled against ARS API version $v\n";
----
This will probably give you an idea as to what actually is wrong with
your setup.

You might want to move the ARS dll files into the
C:\Perl\site\lib\auto\ARS directory.

Regards,

Michiel

On 10/20/07, Andreas Falk <an...@th...> wrote:
> Well yea, that is a bit too obvious unfortunately.
>
> I didn't compile it myself. I got the ppd version from sourceforge. And yes
> the file is there. Also got the c api installed correctly. It's in c:/arsapi
> and i've set the path environment variable to point there.
>
> It's a windows computer, forgot to mention that but I'm not sure how much it
> matters.
>
> I've never used this type of mailing list before so I'm not sure if this
> will be a whole new post now... Hope not.. Point in the right direction if i
> do wrong :)
>
> // Andreas
>
>
> > Maybe a little too obvious; but have you compiled ARSperl? Is the file
> > that is mentioned: 'C:/Perl/site/lib/auto/ARS/ARS
> > .dll', present on
>  > your webserver?
> > You can try and download the pre-compiled ARSperl version from
> sourceforge.
> >
> > Regards,
> >
> > Michiel.
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
>
>


-- 
Met vriendelijke groet / Kind regards
Michiel Beijen
______________________________________________________
MANSOLUTIONS
Energieweg 60-62
3771 NA Barneveld
The Netherlands
Tel. +31-(0)612968592
Mail mic...@ma...
Internet http://bsm.mansolutions.nl

Re: [Arsperl-users] Can't load ARS.dll

[Michiel B. <mic...@gm...>]

Hi Andreas, just hit Reply...you did a good job!

Regards,

Michiel.

On 10/20/07, Andreas Falk <an...@th...> wrote:
> Well yea, that is a bit too obvious unfortunately.
>
> I didn't compile it myself. I got the ppd version from sourceforge. And yes
> the file is there. Also got the c api installed correctly. It's in c:/arsapi
> and i've set the path environment variable to point there.
>
> It's a windows computer, forgot to mention that but I'm not sure how much it
> matters.
>
> I've never used this type of mailing list before so I'm not sure if this
> will be a whole new post now... Hope not.. Point in the right direction if i
> do wrong :)
>
> // Andreas
>
>
> > Maybe a little too obvious; but have you compiled ARSperl? Is the file
> > that is mentioned: 'C:/Perl/site/lib/auto/ARS/ARS
> > .dll', present on
>  > your webserver?
> > You can try and download the pre-compiled ARSperl version from
> sourceforge.
> >
> > Regards,
> >
> > Michiel.
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
>
>

Re: [Arsperl-users] Can't load ARS.dll

[Andreas F. <an...@th...>]

Well yea, that is a bit too obvious unfortunately.

I didn't compile it myself. I got the ppd version from sourceforge. And yes
the file is there. Also got the c api installed correctly. It's in c:/arsapi
and i've set the path environment variable to point there.

It's a windows computer, forgot to mention that but I'm not sure how much it
matters.

I've never used this type of mailing list before so I'm not sure if this
will be a whole new post now... Hope not.. Point in the right direction if i
do wrong :)

// Andreas

> Maybe a little too obvious; but have you compiled ARSperl? Is the file
> that is mentioned: 'C:/Perl/site/lib/auto/ARS/ARS> .dll', present on
> your webserver?
> You can try and download the pre-compiled ARSperl version from
sourceforge.
>
> Regards,
>
> Michiel.
<http://bsm.mansolutions.nl/>

Re: [Arsperl-users] Problem from web or cron

[Brad O'H. <br...@uf...>]

Mark,

  Thilo was polite enough to answer an email directly to him, below is 
his suggestion:

You might try the following:

Assuming that '800000101' is a date or date/time field, specify the date 
in the qualifier string as an integer (epoch time for date/time fields, 
see recent arsperl-users thread about date conversion for date fields).

Furthermore, it looks like '800006010' might be a selection field. If 
this is the case, specify the corresponding integer values of "Problem" 
and "Informational" here as well.

my $date    = '10/19/2007';
my $query    = qq/('Ticket Type' = "Problem" OR 'Ticket Type' = "Informational") AND 'Log Date' = "$date"/;

my $remdate =  (int( $epoch_time / 86400 ) + 2440588) - 1;
my $query    = qq/('800006010' = "Problem" OR '800006010' = "Informational") AND '800000101' = $remdate/;

For some reason, from the command line the first query gets converted to an integer but from cron job it does not.  Could it be a path problem to ARS.so?

Anyway, thanks to Thilo it is working if I convert the date.  Thanks very much!

Brad



Vaughan, Mark wrote:
> Have you verified that you are logging in to ARS as the same user?
>
> As a test, try changing your qual in the cron to directly select one of
> those records that shows up interactively.
>
> Mark Vaughan
> TTS Development
> Comcast Cable Corporation
> 720.268.8591
> -----Original Message-----
> From: ars...@ar...
> [mailto:ars...@ar...] On Behalf Of Thilo Stapff
> Sent: Thursday, October 18, 2007 2:36 AM
> To: Brad O'Hara; ARSperl User Discussion
> Subject: Re: [Arsperl-users] Problem from web or cron
>
> You might try the following:
>
> Assuming that '800000101' is a date or date/time field, specify the date
>
> in the qualifier string as an integer (epoch time for date/time fields, 
> see recent arsperl-users thread about date conversion for date fields).
>
> Furthermore, it looks like '800006010' might be a selection field. If 
> this is the case, specify the corresponding integer values of "Problem" 
> and "Informational" here as well.
>
>
> Regards,
> Thilo Stapff
>
>
> Brad O'Hara wrote:
>   
>> COMMAND LINE:
>> Started at Wed Oct 17 14:35:00 EDT 2007
>>
>> after login errstr=><
>> q=>('800006010' = "Problem" OR '800006010' = "Informational") AND 
>> '800000101' = "10/16/2007"<
>> after load qual errstr=><
>> qual=>ARQualifierStructPtr=SCALAR(0x89ae9b0)<
>> after get list errstr=><
>> number entries=>19<
>> CNS-00000000061
>> CNS-00000000062
>> CNS-00000000063
>> CNS-00000000064
>> CNS-00000000065
>> CNS-00000000066
>> CNS-00000000067
>> CNS-00000000068
>> CNS-00000000069
>> CNS-00000000070
>> CNS-00000000071
>> CNS-00000000072
>> CNS-00000000073
>> CNS-00000000075
>> CNS-00000000076
>> CNS-00000000077
>> CNS-00000000078
>> CNS-00000000079
>> CNS-00000000080
>>
>> CRON:
>> Started at Wed Oct 17 14:43:02 EDT 2007
>>
>> after login errstr=><
>> q=>('800006010' = "Problem" OR '800006010' = "Informational") AND 
>> '800000101' = "10/16/2007"<
>> after load qual errstr=><
>> qual=>ARQualifierStructPtr=SCALAR(0x98d8810)<
>> after get list errstr=><
>> number entries=>0<
>>
>> Thanks sooo much for your help!  This is driving me crazy.  Notice I
>>     
> get 
>   
>> logged in and the qualifier is built fine, but I get no entries.  I 
>> attached the entire script if that helps.
>>
>> Brad
>>
>> Thilo Stapff wrote:
>>     
>>> Would it be possible to insert some debug statements to see how far
>>>       
> it 
>   
>>> gets (especially checking for $ars_errstr after every ARS API call)?
>>>
>>> I don't know where the output from cron jobs goes, but there should
>>>       
> be 
>   
>>> a log file for this. Or maybe the output can be explicitly redirected
>>>       
>
>   
>>> in the cron job definition?
>>>
>>> Do you know if the script gets started at all?
>>>
>>>
>>> Regards,
>>> Thilo Stapff
>>>
>>>
>>> Brad O'Hara wrote:
>>>       
>>>> Sorry to bother you directly, I posted this to the list without a 
>>>> response :-( and noticed you answer most questions.
>>>> I am using ARSperl 1.90 against a v7.01 server.
>>>>
>>>> Not sure what I am doing wrong!  I have the following code that 
>>>> retrieves entries when run from the command line, but not from a 
>>>> crontab entry.
>>>>
>>>> my $c = ars_Login(&CCACHE::SERVER, &CCACHE::USERNAME, 
>>>> &CCACHE::PASSWORD);
>>>> my $query    = qq/('800006010' = "Problem" OR '800006010' = 
>>>> "Informational") AND '800000101' = "$date"/;
>>>>
>>>> ($qual = ars_LoadQualifier($c, $schema, $query));
>>>>
>>>> # Get Requests
>>>> my (%entries = ars_GetListEntry($c, $schema, $qual, 0, 0)) ;
>>>>
>>>> if ( %entries ) {
>>>>  my (%values, %ticket);
>>>>  foreach $entry_id (sort keys %entries) {
>>>>  }
>>>> }
>>>> else { #nothing returned }
>>>>
>>>> The only thing I could think of was a path difference, however, I
>>>>         
> set 
>   
>>>> $ENV{'PATH'} = to the same as the shell path.
>>>>
>>>> Any help is greatly appreciated.
>>>>
>>>>         
>>>       
>
>
> ------------------------------------------------------------------------
> -
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
>
>   

-- 
Brad O'Hara                         E-mail:  br...@uf...
IT Expert                            Voice: (352)392-2061
Computing and Networking Services   Suncom: 622-2061
University of Florida                  Fax: (352)392-9440

Re: [Arsperl-users] Can't load ARS.dll

[Michiel B. <mic...@gm...>]

Maybe a little too obvious; but have you compiled ARSperl? Is the file
that is mentioned: 'C:/Perl/site/lib/auto/ARS/ARS.dll', present on
your webserver?
You can try and download the pre-compiled ARSperl version from sourceforge.

Regards,

Michiel.

On 10/19/07, Andreas Falk <an...@th...> wrote:
> Hi
>
> I'm getting this message in my apache error log when i try to execute any of
> my scripts.
>
> Premature end of script headers: List.pl
> Can't load 'C:/Perl/site/lib/auto/ARS/ARS.dll' for module
> ARS: load_file:The specified module could not be found at
> C:/Perl/lib/DynaLoader.pm line 229.
> at C:/Apache2.2/htdocs/List.pl line 16
> Compilation failed in require at C:/Apache2.2/htdocs/List.pl line 16.
> BEGIN failed--compilation aborted at C:/Apache2.2/htdocs/List.pl line 16.
>
> I've searched around on the mailing list and tried some solutions but it
> didn't fix it.
>
> I'm using the following versions.
>
>  * ActivePerl 5.8.8.822
>  * ARS API 7.0.1
>  * ARSPerl 1.90
>  * Apache 2.2.6
>
> Got any ideas? I'm close to giving up after fighting this problem for two
> days.
>
> // Andreas
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
>
>


-- 
Met vriendelijke groet / Kind regards
Michiel Beijen
______________________________________________________
MANSOLUTIONS
Energieweg 60-62
3771 NA Barneveld
The Netherlands
Tel. +31-(0)612968592
Mail mic...@ma...
Internet http://bsm.mansolutions.nl

[Arsperl-users] Can't load ARS.dll

[Andreas F. <an...@th...>]

Hi

I'm getting this message in my apache error log when i try to execute any of
my scripts.

Premature end of script headers: List.pl
Can't load 'C:/Perl/site/lib/auto/ARS/ARS.dll' for module ARS: load_file:The
specified module could not be found at C:/Perl/lib/DynaLoader.pm line 229.
at C:/Apache2.2/htdocs/List.pl line 16
Compilation failed in require at C:/Apache2.2/htdocs/List.pl line 16.
BEGIN failed--compilation aborted at C:/Apache2.2/htdocs/List.pl line 16.

I've searched around on the mailing list and tried some solutions but it
didn't fix it.

I'm using the following versions.

 * ActivePerl 5.8.8.822
 * ARS API 7.0.1
 * ARSPerl 1.90
 * Apache 2.2.6

Got any ideas? I'm close to giving up after fighting this problem for two
days.

// Andreas

Re: [Arsperl-users] Problem from web or cron

[Vaughan, M. <Mar...@ca...>]

Have you verified that you are logging in to ARS as the same user?

As a test, try changing your qual in the cron to directly select one of
those records that shows up interactively.

Mark Vaughan
TTS Development
Comcast Cable Corporation
720.268.8591
-----Original Message-----
From: ars...@ar...
[mailto:ars...@ar...] On Behalf Of Thilo Stapff
Sent: Thursday, October 18, 2007 2:36 AM
To: Brad O'Hara; ARSperl User Discussion
Subject: Re: [Arsperl-users] Problem from web or cron

You might try the following:

Assuming that '800000101' is a date or date/time field, specify the date

in the qualifier string as an integer (epoch time for date/time fields,=20
see recent arsperl-users thread about date conversion for date fields).

Furthermore, it looks like '800006010' might be a selection field. If=20
this is the case, specify the corresponding integer values of "Problem"=20
and "Informational" here as well.


Regards,
Thilo Stapff


Brad O'Hara wrote:
> COMMAND LINE:
> Started at Wed Oct 17 14:35:00 EDT 2007
>=20
> after login errstr=3D><
> q=3D>('800006010' =3D "Problem" OR '800006010' =3D "Informational") =
AND=20
> '800000101' =3D "10/16/2007"<
> after load qual errstr=3D><
> qual=3D>ARQualifierStructPtr=3DSCALAR(0x89ae9b0)<
> after get list errstr=3D><
> number entries=3D>19<
> CNS-00000000061
> CNS-00000000062
> CNS-00000000063
> CNS-00000000064
> CNS-00000000065
> CNS-00000000066
> CNS-00000000067
> CNS-00000000068
> CNS-00000000069
> CNS-00000000070
> CNS-00000000071
> CNS-00000000072
> CNS-00000000073
> CNS-00000000075
> CNS-00000000076
> CNS-00000000077
> CNS-00000000078
> CNS-00000000079
> CNS-00000000080
>=20
> CRON:
> Started at Wed Oct 17 14:43:02 EDT 2007
>=20
> after login errstr=3D><
> q=3D>('800006010' =3D "Problem" OR '800006010' =3D "Informational") =
AND=20
> '800000101' =3D "10/16/2007"<
> after load qual errstr=3D><
> qual=3D>ARQualifierStructPtr=3DSCALAR(0x98d8810)<
> after get list errstr=3D><
> number entries=3D>0<
>=20
> Thanks sooo much for your help!  This is driving me crazy.  Notice I
get=20
> logged in and the qualifier is built fine, but I get no entries.  I=20
> attached the entire script if that helps.
>=20
> Brad
>=20
> Thilo Stapff wrote:
>> Would it be possible to insert some debug statements to see how far
it=20
>> gets (especially checking for $ars_errstr after every ARS API call)?
>>
>> I don't know where the output from cron jobs goes, but there should
be=20
>> a log file for this. Or maybe the output can be explicitly redirected

>> in the cron job definition?
>>
>> Do you know if the script gets started at all?
>>
>>
>> Regards,
>> Thilo Stapff
>>
>>
>> Brad O'Hara wrote:
>>> Sorry to bother you directly, I posted this to the list without a=20
>>> response :-( and noticed you answer most questions.
>>> I am using ARSperl 1.90 against a v7.01 server.
>>>
>>> Not sure what I am doing wrong!  I have the following code that=20
>>> retrieves entries when run from the command line, but not from a=20
>>> crontab entry.
>>>
>>> my $c =3D ars_Login(&CCACHE::SERVER, &CCACHE::USERNAME,=20
>>> &CCACHE::PASSWORD);
>>> my $query    =3D qq/('800006010' =3D "Problem" OR '800006010' =3D=20
>>> "Informational") AND '800000101' =3D "$date"/;
>>>
>>> ($qual =3D ars_LoadQualifier($c, $schema, $query));
>>>
>>> # Get Requests
>>> my (%entries =3D ars_GetListEntry($c, $schema, $qual, 0, 0)) ;
>>>
>>> if ( %entries ) {
>>>  my (%values, %ticket);
>>>  foreach $entry_id (sort keys %entries) {
>>>  }
>>> }
>>> else { #nothing returned }
>>>
>>> The only thing I could think of was a path difference, however, I
set=20
>>> $ENV{'PATH'} =3D to the same as the shell path.
>>>
>>> Any help is greatly appreciated.
>>>
>>
>>
>=20


------------------------------------------------------------------------
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Arsperl-users mailing list
Ars...@ar...
https://lists.sourceforge.net/lists/listinfo/arsperl-users

[Arsperl-users] Problem from web or cron

[Brad O'H. <br...@uf...>]

All,

  Not sure what I am doing wrong!  I have the following code that 
retrieves entries when run from the command line, but not from a crontab 
entry.

my $c = ars_Login(&CCACHE::SERVER, &CCACHE::USERNAME, &CCACHE::PASSWORD);
my $query    = qq/('800006010' = "Problem" OR '800006010' = 
"Informational") AND '800000101' = "$date"/;

($qual = ars_LoadQualifier($c, $schema, $query));

# Get Requests
my (%entries = ars_GetListEntry($c, $schema, $qual, 0, 0)) ;

if ( %entries ) {
   my (%values, %ticket);
   foreach $entry_id (sort keys %entries) {
   }
}
else { #nothing returned }

The only thing I could think of was a path difference, however, I set 
$ENV{'PATH'} = to the same as the shell path.

Any help is greatly appreciated.

Brad

-- 
Brad O'Hara                         E-mail:  br...@uf...
IT Expert                            Voice: (352)392-2061
Computing and Networking Services   Suncom: 622-2061
University of Florida                  Fax: (352)392-9440

Re: [Arsperl-users] Problem from web or cron

[Thilo S. <thi...@ap...>]

You might try the following:

Assuming that '800000101' is a date or date/time field, specify the date 
in the qualifier string as an integer (epoch time for date/time fields, 
see recent arsperl-users thread about date conversion for date fields).

Furthermore, it looks like '800006010' might be a selection field. If 
this is the case, specify the corresponding integer values of "Problem" 
and "Informational" here as well.


Regards,
Thilo Stapff


Brad O'Hara wrote:
> COMMAND LINE:
> Started at Wed Oct 17 14:35:00 EDT 2007
> 
> after login errstr=><
> q=>('800006010' = "Problem" OR '800006010' = "Informational") AND 
> '800000101' = "10/16/2007"<
> after load qual errstr=><
> qual=>ARQualifierStructPtr=SCALAR(0x89ae9b0)<
> after get list errstr=><
> number entries=>19<
> CNS-00000000061
> CNS-00000000062
> CNS-00000000063
> CNS-00000000064
> CNS-00000000065
> CNS-00000000066
> CNS-00000000067
> CNS-00000000068
> CNS-00000000069
> CNS-00000000070
> CNS-00000000071
> CNS-00000000072
> CNS-00000000073
> CNS-00000000075
> CNS-00000000076
> CNS-00000000077
> CNS-00000000078
> CNS-00000000079
> CNS-00000000080
> 
> CRON:
> Started at Wed Oct 17 14:43:02 EDT 2007
> 
> after login errstr=><
> q=>('800006010' = "Problem" OR '800006010' = "Informational") AND 
> '800000101' = "10/16/2007"<
> after load qual errstr=><
> qual=>ARQualifierStructPtr=SCALAR(0x98d8810)<
> after get list errstr=><
> number entries=>0<
> 
> Thanks sooo much for your help!  This is driving me crazy.  Notice I get 
> logged in and the qualifier is built fine, but I get no entries.  I 
> attached the entire script if that helps.
> 
> Brad
> 
> Thilo Stapff wrote:
>> Would it be possible to insert some debug statements to see how far it 
>> gets (especially checking for $ars_errstr after every ARS API call)?
>>
>> I don't know where the output from cron jobs goes, but there should be 
>> a log file for this. Or maybe the output can be explicitly redirected 
>> in the cron job definition?
>>
>> Do you know if the script gets started at all?
>>
>>
>> Regards,
>> Thilo Stapff
>>
>>
>> Brad O'Hara wrote:
>>> Sorry to bother you directly, I posted this to the list without a 
>>> response :-( and noticed you answer most questions.
>>> I am using ARSperl 1.90 against a v7.01 server.
>>>
>>> Not sure what I am doing wrong!  I have the following code that 
>>> retrieves entries when run from the command line, but not from a 
>>> crontab entry.
>>>
>>> my $c = ars_Login(&CCACHE::SERVER, &CCACHE::USERNAME, 
>>> &CCACHE::PASSWORD);
>>> my $query    = qq/('800006010' = "Problem" OR '800006010' = 
>>> "Informational") AND '800000101' = "$date"/;
>>>
>>> ($qual = ars_LoadQualifier($c, $schema, $query));
>>>
>>> # Get Requests
>>> my (%entries = ars_GetListEntry($c, $schema, $qual, 0, 0)) ;
>>>
>>> if ( %entries ) {
>>>  my (%values, %ticket);
>>>  foreach $entry_id (sort keys %entries) {
>>>  }
>>> }
>>> else { #nothing returned }
>>>
>>> The only thing I could think of was a path difference, however, I set 
>>> $ENV{'PATH'} = to the same as the shell path.
>>>
>>> Any help is greatly appreciated.
>>>
>>
>>
> 

Re: [Arsperl-users] Inserting a date in ARSPerl

[Axton <axt...@gm...>]

"I don't know why they chose 4713 BC as the starting year."

http://en.wikipedia.org/wiki/Julian_Period

Axton

On 10/17/07, Thilo Stapff <thi...@ap...> wrote:
> The BMC "Form and Application Objects" Guide says:
>
> Users can enter dates from January 1, 4713 B.C. to January 1, 9999 A.D.
>
>
> 2440588 is the difference (in days) between January 1, 1970 AD and
> January 1, 4713 BC.
> I don't know why they chose 4713 BC as the starting year.
>
>
> Regards,
> Thilo Stapff
>
>
> Pittman, Timothy wrote:
> > Thanks.  That worked.  I understand where 86400 came from, but what is
> > the significance of 2440588?
> >
> > Tim Pittman
> > Project Engineer
> > Respironics, Inc.
> >
> > -----Original Message-----
> > From: ars...@ar...
> > [mailto:ars...@ar...] On Behalf Of Thilo Stapff
> > Sent: Wednesday, October 17, 2007 1:03 PM
> > To: ARSperl User Discussion
> > Subject: Re: [Arsperl-users] Inserting a date in ARSPerl
> >
> >
> > Unfortunately, date fields (unlike date/time fields) are only supported
> > since ARSperl version 1.90
> >
> > The value has to be an integer which can be computed from an epoch
> > timestamp by
> >
> > int( $epoch_time / 86400 ) + 2440588
> >
> >
> > Regards,
> > Thilo Stapff
> >
> >
> > Pittman, Timothy wrote:
> >> I have been having considerable difficulty trying to use ARSPerl to
> >> create an entry with a date.  My web page is prompting the user to
> > enter
> >> a date, which I'm assuming will be in the format mm/dd/yyyy.  I am
> > using
> >> the perl module ParseDate to attempt to figure out what they enter.
> > In
> >> any case, I need to convert this user-entered value into some format
> >> that ars_CreateEntry can deal with.  My code does this:
> >>
> >>      ($entryId = ars_CreateEntry($ctrl, $shopSchema,
> >>              $sf{"Description"}, $details,
> >>              ... various fields you don't care about...
> >>              $sf{"Date Required"}, "$date1",
> >>              ... more fields...
> >>              $sf{"Status"}, "Submitted"))
> >>              or print  "\n<p>[ERROR]\tCould not add shop order due to
> >> $ars_errstr<b><br>\n";
> >>
> >> I have tried numerous ways of formatting the date field $date1 above
> > to
> >> attempt to get it to shop up in the proper format in Remedy.  I have
> >> tried numerous variations of the following:
> >> A string (i.e. "10/17/2007")
> >> An integer (converted via timelocal and others to epoch time)
> >>
> >> I either end up with the date 1/1/9999 or 1/1/4713 B.C. in my date
> >> field. I have searched everywhere on the net that I can find and
> > nothing
> >> has helped. Does anyone know what to do to a user-entered date to make
> >> ars_CreateEntry accept it properly?
> >>
> >> This is running on a Win2K server with ARSPerl 1.82 against a Remedy
> > 6.0
> >> system on Oracle.
> >>
> >> Thanks, Tim
> >>
> >
> > ========================================================================
> > CONFIDENTIALITY NOTICE
> > ----------------------
> > This message, together with any attachments, may be legally privileged
> > and is confidential information intended only for the use of the
> > individual or entity to which it is addressed.  It is exempt from
> > disclosure under applicable law including court orders.  If you are not
> > the intended recipient, you are hereby notified that any use,
> > dissemination, distribution or copy of this message, or any attachment,
> > is strictly prohibited.  If you have received this message in error,
> > please notify the original sender and delete this message, along with
> > any attachments, from your computer.
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Splunk Inc.
> > Still grepping through log files to find problems?  Stop.
> > Now Search log events and configuration files using AJAX and a browser.
> > Download your FREE copy of Splunk now >> http://get.splunk.com/
> > _______________________________________________
> > Arsperl-users mailing list
> > Ars...@ar...
> > https://lists.sourceforge.net/lists/listinfo/arsperl-users
> >
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
>

Re: [Arsperl-users] Inserting a date in ARSPerl

[Thilo S. <thi...@ap...>]

The BMC "Form and Application Objects" Guide says:

Users can enter dates from January 1, 4713 B.C. to January 1, 9999 A.D.


2440588 is the difference (in days) between January 1, 1970 AD and 
January 1, 4713 BC.
I don't know why they chose 4713 BC as the starting year.


Regards,
Thilo Stapff


Pittman, Timothy wrote:
> Thanks.  That worked.  I understand where 86400 came from, but what is
> the significance of 2440588?
> 
> Tim Pittman
> Project Engineer
> Respironics, Inc.
>  
> -----Original Message-----
> From: ars...@ar...
> [mailto:ars...@ar...] On Behalf Of Thilo Stapff
> Sent: Wednesday, October 17, 2007 1:03 PM
> To: ARSperl User Discussion
> Subject: Re: [Arsperl-users] Inserting a date in ARSPerl
> 
> 
> Unfortunately, date fields (unlike date/time fields) are only supported 
> since ARSperl version 1.90
> 
> The value has to be an integer which can be computed from an epoch 
> timestamp by
> 
> int( $epoch_time / 86400 ) + 2440588
> 
> 
> Regards,
> Thilo Stapff
> 
> 
> Pittman, Timothy wrote:
>> I have been having considerable difficulty trying to use ARSPerl to
>> create an entry with a date.  My web page is prompting the user to
> enter
>> a date, which I'm assuming will be in the format mm/dd/yyyy.  I am
> using
>> the perl module ParseDate to attempt to figure out what they enter.
> In
>> any case, I need to convert this user-entered value into some format
>> that ars_CreateEntry can deal with.  My code does this:
>>
>> 	($entryId = ars_CreateEntry($ctrl, $shopSchema, 
>> 		$sf{"Description"}, $details,
>> 		... various fields you don't care about...
>> 		$sf{"Date Required"}, "$date1", 
>> 		... more fields...
>> 		$sf{"Status"}, "Submitted")) 
>> 		or print  "\n<p>[ERROR]\tCould not add shop order due to
>> $ars_errstr<b><br>\n";
>>
>> I have tried numerous ways of formatting the date field $date1 above
> to
>> attempt to get it to shop up in the proper format in Remedy.  I have
>> tried numerous variations of the following: 
>> A string (i.e. "10/17/2007")
>> An integer (converted via timelocal and others to epoch time)
>>
>> I either end up with the date 1/1/9999 or 1/1/4713 B.C. in my date
>> field. I have searched everywhere on the net that I can find and
> nothing
>> has helped. Does anyone know what to do to a user-entered date to make
>> ars_CreateEntry accept it properly?
>>
>> This is running on a Win2K server with ARSPerl 1.82 against a Remedy
> 6.0
>> system on Oracle.
>>
>> Thanks, Tim
>>
> 
> ========================================================================
> CONFIDENTIALITY NOTICE
> ----------------------
> This message, together with any attachments, may be legally privileged
> and is confidential information intended only for the use of the
> individual or entity to which it is addressed.  It is exempt from
> disclosure under applicable law including court orders.  If you are not
> the intended recipient, you are hereby notified that any use,
> dissemination, distribution or copy of this message, or any attachment,
> is strictly prohibited.  If you have received this message in error,
> please notify the original sender and delete this message, along with
> any attachments, from your computer.
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
> 

Re: [Arsperl-users] Inserting a date in ARSPerl

[Pittman, T. <Tim...@re...>]

Thanks.  That worked.  I understand where 86400 came from, but what is
the significance of 2440588?

Tim Pittman
Project Engineer
Respironics, Inc.
=20
-----Original Message-----
From: ars...@ar...
[mailto:ars...@ar...] On Behalf Of Thilo Stapff
Sent: Wednesday, October 17, 2007 1:03 PM
To: ARSperl User Discussion
Subject: Re: [Arsperl-users] Inserting a date in ARSPerl


Unfortunately, date fields (unlike date/time fields) are only supported=20
since ARSperl version 1.90

The value has to be an integer which can be computed from an epoch=20
timestamp by

int( $epoch_time / 86400 ) + 2440588


Regards,
Thilo Stapff


Pittman, Timothy wrote:
> I have been having considerable difficulty trying to use ARSPerl to
> create an entry with a date.  My web page is prompting the user to
enter
> a date, which I'm assuming will be in the format mm/dd/yyyy.  I am
using
> the perl module ParseDate to attempt to figure out what they enter.
In
> any case, I need to convert this user-entered value into some format
> that ars_CreateEntry can deal with.  My code does this:
>=20
> 	($entryId =3D ars_CreateEntry($ctrl, $shopSchema,=20
> 		$sf{"Description"}, $details,
> 		... various fields you don't care about...
> 		$sf{"Date Required"}, "$date1",=20
> 		... more fields...
> 		$sf{"Status"}, "Submitted"))=20
> 		or print  "\n<p>[ERROR]\tCould not add shop order due to
> $ars_errstr<b><br>\n";
>=20
> I have tried numerous ways of formatting the date field $date1 above
to
> attempt to get it to shop up in the proper format in Remedy.  I have
> tried numerous variations of the following:=20
> A string (i.e. "10/17/2007")
> An integer (converted via timelocal and others to epoch time)
>=20
> I either end up with the date 1/1/9999 or 1/1/4713 B.C. in my date
> field. I have searched everywhere on the net that I can find and
nothing
> has helped. Does anyone know what to do to a user-entered date to make
> ars_CreateEntry accept it properly?
>=20
> This is running on a Win2K server with ARSPerl 1.82 against a Remedy
6.0
> system on Oracle.
>=20
> Thanks, Tim
>=20

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
CONFIDENTIALITY NOTICE
----------------------
This message, together with any attachments, may be legally privileged
and is confidential information intended only for the use of the
individual or entity to which it is addressed.  It is exempt from
disclosure under applicable law including court orders.  If you are not
the intended recipient, you are hereby notified that any use,
dissemination, distribution or copy of this message, or any attachment,
is strictly prohibited.  If you have received this message in error,
please notify the original sender and delete this message, along with
any attachments, from your computer.