Hi. We are trying to implement in one our system interface to OTRS. We decide to use perl interface described on dev.otrs.org . In attachment is my perl script to create TT. This ticket is created but with many errors (second attachment) and cannot be viewed via web because problem with ArticleID. Thanks Juraj Bobek. ____________________________________________________________________________ ___________________ CreateTicket2.pl: #!/usr/bin/perl -w use File::Basename; use FindBin qw($RealBin); use lib dirname($RealBin); use lib dirname($RealBin)."/Kernel/cpan-lib"; use Kernel::Config; use Kernel::System::Time; use Kernel::System::Log; use Kernel::System::DB; use Kernel::System::Ticket; my $ConfigObject = Kernel::Config->new(); my $TimeObject = Kernel::System::Time->new( ConfigObject => $ConfigObject, ); my $LogObject = Kernel::System::Log->new( ConfigObject => $ConfigObject, ); my $DBObject = Kernel::System::DB->new( ConfigObject => $ConfigObject, LogObject => $LogObject, ); my $TicketObject = Kernel::System::Ticket->new( ConfigObject => $ConfigObject, LogObject => $LogObject, DBObject => $DBObject, ); my $TicketID = $TicketObject->TicketCreate( TN => $TicketObject->TicketCreateNumber(), QueueID => 123, # or Queue => 'SomeQueue' Lock => 'unlock', GroupID => 1, Priority => '3 normal' # or PriorityID => 2, State => 'new', # or StateID => 5, CustomerNo => '123465', CustomerUser => 'customer@example.com', UserID => 123, # new owner CreateUserID => 123, ); print "Ticket added. Ticket ID is $TicketID"; # -- exit (0); ____________________________________________________________________________ _______________ Error: Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004 Message: No such TicketID (26)! Traceback (8901): Module: Kernel::System::Ticket::TicketGet (v1.19) Line: 566 Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3025 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 345 Module: ./CreateTicket2.pl (v) Line: 39 Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004 Message: No such TicketID (26)! Traceback (8901): Module: Kernel::System::Ticket::TicketGet (v1.19) Line: 566 Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3030 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 345 Module: ./CreateTicket2.pl (v) Line: 39 Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004 Message: No such TicketID (26)! Traceback (8901): Module: Kernel::System::Ticket::TicketGet (v1.19) Line: 566 Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3035 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 345 Module: ./CreateTicket2.pl (v) Line: 39 Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Ticket.pm line 3039. Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Ticket.pm line 3039. Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Ticket.pm line 3039. DBD::mysql::db do failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' , , 1, current_timestamp, 1000, current_timestamp, 1000)' at at /opt/otrs/Kernel/System/DB.pm line 376. Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004 Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' , , 1, current_timestamp, 1000, current_timestamp, 1000)' at, SQL: 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, queue_id, owner_id, priority_id, state_id, valid_id, create_time, create_by, change_time, change_by) VALUES ('%%200411041028%%inms%%3 normal%%new%%26', 1, 26, 0, 5, , , , 1, current_timestamp, 1000, current_timestamp, 1000)' Traceback (8901): Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3048 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 345 Module: ./CreateTicket2.pl (v) Line: 39 Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004 Message: No such TicketID (26)! Traceback (8901): Module: Kernel::System::Ticket::TicketGet (v1.19) Line: 566 Module: Kernel::System::Ticket::TicketQueueID (v1.19) Line: 608 Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3020 Module: Kernel::System::Ticket::SetCustomerData (v1.19) Line: 878 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 353 Module: ./CreateTicket2.pl (v) Line: 39 Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004 Message: No such TicketID (26)! Traceback (8901): Module: Kernel::System::Ticket::TicketGet (v1.19) Line: 566 Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3025 Module: Kernel::System::Ticket::SetCustomerData (v1.19) Line: 878 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 353 Module: ./CreateTicket2.pl (v) Line: 39 Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004 Message: No such TicketID (26)! Traceback (8901): Module: Kernel::System::Ticket::TicketGet (v1.19) Line: 566 Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3030 Module: Kernel::System::Ticket::SetCustomerData (v1.19) Line: 878 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 353 Module: ./CreateTicket2.pl (v) Line: 39 Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004 Message: No such TicketID (26)! Traceback (8901): Module: Kernel::System::Ticket::TicketGet (v1.19) Line: 566 Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3035 Module: Kernel::System::Ticket::SetCustomerData (v1.19) Line: 878 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 353 Module: ./CreateTicket2.pl (v) Line: 39 Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Ticket.pm line 3039. Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Ticket.pm line 3039. Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Ticket.pm line 3039. Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Ticket.pm line 3039. DBD::mysql::db do failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' , , , 1, current_timestamp, 1000, current_timestamp, 1000)' at /opt/otrs/Kernel/System/DB.pm line 376. Use of uninitialized value in concatenation (.) or string at /opt/otrs/Kernel/System/Log.pm line 134. ERROR: ?LogPrefix?-10 Perl: 5.8.3 OS: linux Time: Thu Nov 4 13:16:14 2004 Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' , , , 1, current_timestamp, 1000, current_timestamp, 1000)' , SQL: 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, queue_id, owner_id, priority_id, state_id, valid_id, create_time, create_by, change_time, change_by) VALUES ('%%CustomerID=1002\;CustomerUser=jurko@sk15392c.siemens-pse.sk\;', 21, 26, 0, , , , , 1, current_timestamp, 1000, current_timestamp, 1000)' Traceback (8901): Module: Kernel::System::Ticket::HistoryAdd (v1.19) Line: 3048 Module: Kernel::System::Ticket::SetCustomerData (v1.19) Line: 878 Module: Kernel::System::Ticket::TicketCreate (v1.19) Line: 353 Module: ./CreateTicket2.pl (v) Line: 39 ___________________________________________ S pozdravom (Mit freundlichem Gruß / kind regards) Dipl. Ing. Juraj Bobek Siemens Program and System Engineering s.r.o. IT Developer SMC BI ZA Tel.: +421(41)5055828 Fax: +421(41)5055809 mailto:Juraj.Bobek@siemens.com