[rt-users] HELP with RT API

[Ken Crocker]

Kevin,

When I used "hard-coded" dates this is what I get:

-bash-3.00$ ./RT-TravelConversion.pl
Use of uninitialized value in concatenation (.) or string at 
/apps/rt/rt-3.6.4/etc/RT_SiteConfig.pm line 35.
Use of uninitialized value in concatenation (.) or string at 
/apps/rt/rt-3.6.4/etc/RT_SiteConfig.pm line 47.
Use of uninitialized value in concatenation (.) or string at 
/apps/rt/rt-3.6.4/etc/RT_SiteConfig.pm line 47.
Subroutine Connect redefined at /apps/rt/rt/lib/RT/Handle_Local.pm line 90.
Subroutine BuildDSN redefined at /apps/rt/rt/lib/RT/Handle_Local.pm line 
121.
Open Date - 2009-08-27 0:00:00 Resolved Date - 2009-08-01 
0:00:00New_Ticket request=1 Ticket 87299 created in queue 'FS-Travel'
Open Date - 2009-08-27 0:00:00 Resolved Date - 2009-08-01 
0:00:00New_Ticket request=2 Ticket 87300 created in queue 'FS-Travel'
Open Date - 2009-08-27 0:00:00 Resolved Date - 2009-08-01 
0:00:00New_Ticket request=4 Ticket 87301 created in queue 'FS-Travel'
Open Date - 2009-08-27 0:00:00 Resolved Date - 2009-08-01 
0:00:00New_Ticket request=5 Ticket 87302 created in queue 'FS-Travel'
Open Date - 2009-08-27 0:00:00 Resolved Date - 2009-08-01 
0:00:00New_Ticket request=5 Ticket 87303 created in queue 'FS-Travel'
Open Date - 2009-08-27 0:00:00 Resolved Date - 2009-08-01 
0:00:00New_Ticket request=5 Ticket 87304 created in queue 'FS-Travel'
Open Date - 2009-08-27 0:00:00 Resolved Date - 2009-08-01 
0:00:00New_Ticket request=5 Ticket 87305 created in queue 'FS-Travel'
Open Date - 2009-08-27 0:00:00 Resolved Date - 2009-08-01 
0:00:00New_Ticket request=6 Ticket 87306 created in queue 'FS-Travel'
Open Date - 2009-08-27 0:00:00 Resolved Date - 2009-08-01 
0:00:00New_Ticket request=7 Ticket 87307 created in queue 'FS-Travel'
Open Date - 2009-08-27 0:00:00 Resolved Date - 2009-08-01 
0:00:00New_Ticket request=8 Ticket 87308 created in queue 'FS-Travel'
Open Date - 2009-08-27 0:00:00 Resolved Date - 2009-08-01 
0:00:00New_Ticket request=9 Ticket 87309 created in queue 'FS-Travel'
Open Date - 2009-08-27 0:00:00 Resolved Date - 2009-08-01 
0:00:00New_Ticket request=10 Ticket 87310 created in queue 'FS-Travel'
-bash-3.00$

The relevant code was:

#   Set Dates
     $opened = '2009-08-27 0:00:00';
     $resolved = '2009-08-01 0:00:00';

  AND

    %ticket_vals =
    (
        Subject => $ISSUE_DESCRIPTION,
        MIMEObj => $mimeObj,
        Creator => 4233,   #API bug won't look up corresponding id for name
        Owner => 4233,
        Requestor => 4233,
        Queue => 14,
        Priority => 3,
        InitialPriority => 3,
        FinalPriority => 3,
        Started => $opened,
        Resolved => $resolved,
        Status => ( "resolved" )
    );
 
    ( $ticketid, $transaction_object, $err ) = $ticket->Create( 
%ticket_vals );
    print "Open Date - ", $opened, " Resolved Date - ", $resolved;
    print "New_Ticket request=", $NUMBER, " $err \n";  #debug
    die "New_Ticket Error: $err \n"   unless $ticketid;

The resulting tickets had nothing in the two date fields I was trying to 
set and the current date in "Created" & "LastUpdated". In my code, you 
can see I "hard-coded" a date/time and it displayed from $opened & 
$resolved, yet nothing in the record.

I don't know what you mean by "warning out". Do you mean just not put 
anything in the fields with code?

Kenn
LBNL

On 8/27/2009 9:18 AM, Kevin Falcone wrote:
> On Thu, Aug 27, 2009 at 08:52:21AM -0700, Ken Crocker wrote:
>   
>>    Kevin,
>>
>>    My log has been on and it gives no errors. This is it (for a small file for testing):
>>
>>    -bash-3.00$ ./RT-TravelConversion.pl
>>    Use of uninitialized value in concatenation (.) or string at
>>    /apps/rt/rt-3.6.4/etc/RT_SiteConfig.pm line 35.
>>    Use of uninitialized value in concatenation (.) or string at
>>    /apps/rt/rt-3.6.4/etc/RT_SiteConfig.pm line 47.
>>    Use of uninitialized value in concatenation (.) or string at
>>    /apps/rt/rt-3.6.4/etc/RT_SiteConfig.pm line 47.
>>    Subroutine Connect redefined at /apps/rt/rt/lib/RT/Handle_Local.pm line 90.
>>    Subroutine BuildDSN redefined at /apps/rt/rt/lib/RT/Handle_Local.pm line 121.
>>    New_Ticket request=1 Ticket 87287 created in queue 'FS-Travel'
>>    New_Ticket request=2 Ticket 87288 created in queue 'FS-Travel'
>>    New_Ticket request=4 Ticket 87289 created in queue 'FS-Travel'
>>    New_Ticket request=5 Ticket 87290 created in queue 'FS-Travel'
>>    New_Ticket request=5 Ticket 87291 created in queue 'FS-Travel'
>>    New_Ticket request=5 Ticket 87292 created in queue 'FS-Travel'
>>    New_Ticket request=5 Ticket 87293 created in queue 'FS-Travel'
>>    New_Ticket request=6 Ticket 87294 created in queue 'FS-Travel'
>>    New_Ticket request=7 Ticket 87295 created in queue 'FS-Travel'
>>    New_Ticket request=8 Ticket 87296 created in queue 'FS-Travel'
>>    New_Ticket request=9 Ticket 87297 created in queue 'FS-Travel'
>>    New_Ticket request=10 Ticket 87298 created in queue 'FS-Travel'
>>    -bash-3.00$
>>
>>    Nothing in those messages syas I have a code problem or anything. You have the code (attached
>>    in last note). The code seems simple enough, I just can't seem to see the problem.
>>     
>
> Kenn
>
> What happened when you started warning out your data and the converted
> data that you're handing to Create?  What happened when you modified
> your code to use a hardcoded date in a known-good format? (As
> suggested in my response)
>
>   
>>  You're not providing any data or logging or error messages
>>  I suggest you warn out the original date, the processed date, the ISO
>>  date and turn your debugging logs on.  You also probably want to start
>>  by getting ticket Create working with hardcoded date strings and then
>>  move on to processing your data.
>>     
>
> -kevin
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090827/2dfbc9c9/attachment.htm>