1-- ---------------------------------------------------------- 2-- driver: postgresql 3-- ---------------------------------------------------------- 4SET standard_conforming_strings TO ON; 5-- ---------------------------------------------------------- 6-- insert into table valid 7-- ---------------------------------------------------------- 8INSERT INTO valid (name, create_by, create_time, change_by, change_time) 9 VALUES 10 ('valid', 1, current_timestamp, 1, current_timestamp); 11-- ---------------------------------------------------------- 12-- insert into table valid 13-- ---------------------------------------------------------- 14INSERT INTO valid (name, create_by, create_time, change_by, change_time) 15 VALUES 16 ('invalid', 1, current_timestamp, 1, current_timestamp); 17-- ---------------------------------------------------------- 18-- insert into table valid 19-- ---------------------------------------------------------- 20INSERT INTO valid (name, create_by, create_time, change_by, change_time) 21 VALUES 22 ('invalid-temporarily', 1, current_timestamp, 1, current_timestamp); 23-- ---------------------------------------------------------- 24-- insert into table users 25-- ---------------------------------------------------------- 26INSERT INTO users (first_name, last_name, login, pw, valid_id, create_by, create_time, change_by, change_time) 27 VALUES 28 ('Admin', 'OTRS', 'root@localhost', 'roK20XGbWEsSM', 1, 1, current_timestamp, 1, current_timestamp); 29-- ---------------------------------------------------------- 30-- insert into table groups 31-- ---------------------------------------------------------- 32INSERT INTO groups (name, comments, valid_id, create_by, create_time, change_by, change_time) 33 VALUES 34 ('users', 'Group for default access.', 1, 1, current_timestamp, 1, current_timestamp); 35-- ---------------------------------------------------------- 36-- insert into table groups 37-- ---------------------------------------------------------- 38INSERT INTO groups (name, comments, valid_id, create_by, create_time, change_by, change_time) 39 VALUES 40 ('admin', 'Group of all administrators.', 1, 1, current_timestamp, 1, current_timestamp); 41-- ---------------------------------------------------------- 42-- insert into table groups 43-- ---------------------------------------------------------- 44INSERT INTO groups (name, comments, valid_id, create_by, create_time, change_by, change_time) 45 VALUES 46 ('stats', 'Group for statistics access.', 1, 1, current_timestamp, 1, current_timestamp); 47-- ---------------------------------------------------------- 48-- insert into table group_user 49-- ---------------------------------------------------------- 50INSERT INTO group_user (user_id, group_id, permission_key, create_by, create_time, change_by, change_time) 51 VALUES 52 (1, 1, 'rw', 1, current_timestamp, 1, current_timestamp); 53-- ---------------------------------------------------------- 54-- insert into table group_user 55-- ---------------------------------------------------------- 56INSERT INTO group_user (user_id, group_id, permission_key, create_by, create_time, change_by, change_time) 57 VALUES 58 (1, 2, 'rw', 1, current_timestamp, 1, current_timestamp); 59-- ---------------------------------------------------------- 60-- insert into table group_user 61-- ---------------------------------------------------------- 62INSERT INTO group_user (user_id, group_id, permission_key, create_by, create_time, change_by, change_time) 63 VALUES 64 (1, 3, 'rw', 1, current_timestamp, 1, current_timestamp); 65-- ---------------------------------------------------------- 66-- insert into table link_type 67-- ---------------------------------------------------------- 68INSERT INTO link_type (name, valid_id, create_by, create_time, change_by, change_time) 69 VALUES 70 ('Normal', 1, 1, current_timestamp, 1, current_timestamp); 71-- ---------------------------------------------------------- 72-- insert into table link_type 73-- ---------------------------------------------------------- 74INSERT INTO link_type (name, valid_id, create_by, create_time, change_by, change_time) 75 VALUES 76 ('ParentChild', 1, 1, current_timestamp, 1, current_timestamp); 77-- ---------------------------------------------------------- 78-- insert into table link_state 79-- ---------------------------------------------------------- 80INSERT INTO link_state (name, valid_id, create_by, create_time, change_by, change_time) 81 VALUES 82 ('Valid', 1, 1, current_timestamp, 1, current_timestamp); 83-- ---------------------------------------------------------- 84-- insert into table link_state 85-- ---------------------------------------------------------- 86INSERT INTO link_state (name, valid_id, create_by, create_time, change_by, change_time) 87 VALUES 88 ('Temporary', 1, 1, current_timestamp, 1, current_timestamp); 89-- ---------------------------------------------------------- 90-- insert into table ticket_state_type 91-- ---------------------------------------------------------- 92INSERT INTO ticket_state_type (name, comments, create_by, create_time, change_by, change_time) 93 VALUES 94 ('new', 'All new state types (default: viewable).', 1, current_timestamp, 1, current_timestamp); 95-- ---------------------------------------------------------- 96-- insert into table ticket_state_type 97-- ---------------------------------------------------------- 98INSERT INTO ticket_state_type (name, comments, create_by, create_time, change_by, change_time) 99 VALUES 100 ('open', 'All open state types (default: viewable).', 1, current_timestamp, 1, current_timestamp); 101-- ---------------------------------------------------------- 102-- insert into table ticket_state_type 103-- ---------------------------------------------------------- 104INSERT INTO ticket_state_type (name, comments, create_by, create_time, change_by, change_time) 105 VALUES 106 ('closed', 'All closed state types (default: not viewable).', 1, current_timestamp, 1, current_timestamp); 107-- ---------------------------------------------------------- 108-- insert into table ticket_state_type 109-- ---------------------------------------------------------- 110INSERT INTO ticket_state_type (name, comments, create_by, create_time, change_by, change_time) 111 VALUES 112 ('pending reminder', 'All ''pending reminder'' state types (default: viewable).', 1, current_timestamp, 1, current_timestamp); 113-- ---------------------------------------------------------- 114-- insert into table ticket_state_type 115-- ---------------------------------------------------------- 116INSERT INTO ticket_state_type (name, comments, create_by, create_time, change_by, change_time) 117 VALUES 118 ('pending auto', 'All ''pending auto *'' state types (default: viewable).', 1, current_timestamp, 1, current_timestamp); 119-- ---------------------------------------------------------- 120-- insert into table ticket_state_type 121-- ---------------------------------------------------------- 122INSERT INTO ticket_state_type (name, comments, create_by, create_time, change_by, change_time) 123 VALUES 124 ('removed', 'All ''removed'' state types (default: not viewable).', 1, current_timestamp, 1, current_timestamp); 125-- ---------------------------------------------------------- 126-- insert into table ticket_state_type 127-- ---------------------------------------------------------- 128INSERT INTO ticket_state_type (name, comments, create_by, create_time, change_by, change_time) 129 VALUES 130 ('merged', 'State type for merged tickets (default: not viewable).', 1, current_timestamp, 1, current_timestamp); 131-- ---------------------------------------------------------- 132-- insert into table ticket_state 133-- ---------------------------------------------------------- 134INSERT INTO ticket_state (name, comments, type_id, valid_id, create_by, create_time, change_by, change_time) 135 VALUES 136 ('new', 'New ticket created by customer.', 1, 1, 1, current_timestamp, 1, current_timestamp); 137-- ---------------------------------------------------------- 138-- insert into table ticket_state 139-- ---------------------------------------------------------- 140INSERT INTO ticket_state (name, comments, type_id, valid_id, create_by, create_time, change_by, change_time) 141 VALUES 142 ('closed successful', 'Ticket is closed successful.', 3, 1, 1, current_timestamp, 1, current_timestamp); 143-- ---------------------------------------------------------- 144-- insert into table ticket_state 145-- ---------------------------------------------------------- 146INSERT INTO ticket_state (name, comments, type_id, valid_id, create_by, create_time, change_by, change_time) 147 VALUES 148 ('closed unsuccessful', 'Ticket is closed unsuccessful.', 3, 1, 1, current_timestamp, 1, current_timestamp); 149-- ---------------------------------------------------------- 150-- insert into table ticket_state 151-- ---------------------------------------------------------- 152INSERT INTO ticket_state (name, comments, type_id, valid_id, create_by, create_time, change_by, change_time) 153 VALUES 154 ('open', 'Open tickets.', 2, 1, 1, current_timestamp, 1, current_timestamp); 155-- ---------------------------------------------------------- 156-- insert into table ticket_state 157-- ---------------------------------------------------------- 158INSERT INTO ticket_state (name, comments, type_id, valid_id, create_by, create_time, change_by, change_time) 159 VALUES 160 ('removed', 'Customer removed ticket.', 6, 1, 1, current_timestamp, 1, current_timestamp); 161-- ---------------------------------------------------------- 162-- insert into table ticket_state 163-- ---------------------------------------------------------- 164INSERT INTO ticket_state (name, comments, type_id, valid_id, create_by, create_time, change_by, change_time) 165 VALUES 166 ('pending reminder', 'Ticket is pending for agent reminder.', 4, 1, 1, current_timestamp, 1, current_timestamp); 167-- ---------------------------------------------------------- 168-- insert into table ticket_state 169-- ---------------------------------------------------------- 170INSERT INTO ticket_state (name, comments, type_id, valid_id, create_by, create_time, change_by, change_time) 171 VALUES 172 ('pending auto close+', 'Ticket is pending for automatic close.', 5, 1, 1, current_timestamp, 1, current_timestamp); 173-- ---------------------------------------------------------- 174-- insert into table ticket_state 175-- ---------------------------------------------------------- 176INSERT INTO ticket_state (name, comments, type_id, valid_id, create_by, create_time, change_by, change_time) 177 VALUES 178 ('pending auto close-', 'Ticket is pending for automatic close.', 5, 1, 1, current_timestamp, 1, current_timestamp); 179-- ---------------------------------------------------------- 180-- insert into table ticket_state 181-- ---------------------------------------------------------- 182INSERT INTO ticket_state (name, comments, type_id, valid_id, create_by, create_time, change_by, change_time) 183 VALUES 184 ('merged', 'State for merged tickets.', 7, 1, 1, current_timestamp, 1, current_timestamp); 185-- ---------------------------------------------------------- 186-- insert into table salutation 187-- ---------------------------------------------------------- 188INSERT INTO salutation (name, text, content_type, comments, valid_id, create_by, create_time, change_by, change_time) 189 VALUES 190 ('system standard salutation (en)', 'Dear <OTRS_CUSTOMER_REALNAME>, 191 192Thank you for your request. 193 194', 'text/plain; charset=utf-8', 'Standard Salutation.', 1, 1, current_timestamp, 1, current_timestamp); 195-- ---------------------------------------------------------- 196-- insert into table signature 197-- ---------------------------------------------------------- 198INSERT INTO signature (name, text, content_type, comments, valid_id, create_by, create_time, change_by, change_time) 199 VALUES 200 ('system standard signature (en)', ' 201Your Ticket-Team 202 203 <OTRS_Agent_UserFirstname> <OTRS_Agent_UserLastname> 204 205-- 206 Super Support - Waterford Business Park 207 5201 Blue Lagoon Drive - 8th Floor & 9th Floor - Miami, 33126 USA 208 Email: hot@example.com - Web: http://www.example.com/ 209--', 'text/plain; charset=utf-8', 'Standard Signature.', 1, 1, current_timestamp, 1, current_timestamp); 210-- ---------------------------------------------------------- 211-- insert into table system_address 212-- ---------------------------------------------------------- 213INSERT INTO system_address (value0, value1, comments, valid_id, queue_id, create_by, create_time, change_by, change_time) 214 VALUES 215 ('otrs@localhost', 'OTRS System', 'Standard Address.', 1, 1, 1, current_timestamp, 1, current_timestamp); 216-- ---------------------------------------------------------- 217-- insert into table follow_up_possible 218-- ---------------------------------------------------------- 219INSERT INTO follow_up_possible (name, comments, valid_id, create_by, create_time, change_by, change_time) 220 VALUES 221 ('possible', 'Follow-ups for closed tickets are possible. Ticket will be reopened.', 1, 1, current_timestamp, 1, current_timestamp); 222-- ---------------------------------------------------------- 223-- insert into table follow_up_possible 224-- ---------------------------------------------------------- 225INSERT INTO follow_up_possible (name, comments, valid_id, create_by, create_time, change_by, change_time) 226 VALUES 227 ('reject', 'Follow-ups for closed tickets are not possible. No new ticket will be created.', 1, 1, current_timestamp, 1, current_timestamp); 228-- ---------------------------------------------------------- 229-- insert into table follow_up_possible 230-- ---------------------------------------------------------- 231INSERT INTO follow_up_possible (name, comments, valid_id, create_by, create_time, change_by, change_time) 232 VALUES 233 ('new ticket', 'Follow-ups for closed tickets are not possible. A new ticket will be created.', 1, 1, current_timestamp, 1, current_timestamp); 234-- ---------------------------------------------------------- 235-- insert into table queue 236-- ---------------------------------------------------------- 237INSERT INTO queue (name, group_id, system_address_id, salutation_id, signature_id, follow_up_id, follow_up_lock, unlock_timeout, comments, valid_id, create_by, create_time, change_by, change_time) 238 VALUES 239 ('Postmaster', 1, 1, 1, 1, 1, 0, 0, 'Postmaster queue.', 1, 1, current_timestamp, 1, current_timestamp); 240-- ---------------------------------------------------------- 241-- insert into table queue 242-- ---------------------------------------------------------- 243INSERT INTO queue (name, group_id, system_address_id, salutation_id, signature_id, follow_up_id, follow_up_lock, unlock_timeout, comments, valid_id, create_by, create_time, change_by, change_time) 244 VALUES 245 ('Raw', 1, 1, 1, 1, 1, 0, 0, 'All default incoming tickets.', 1, 1, current_timestamp, 1, current_timestamp); 246-- ---------------------------------------------------------- 247-- insert into table queue 248-- ---------------------------------------------------------- 249INSERT INTO queue (name, group_id, system_address_id, salutation_id, signature_id, follow_up_id, follow_up_lock, unlock_timeout, comments, valid_id, create_by, create_time, change_by, change_time) 250 VALUES 251 ('Junk', 1, 1, 1, 1, 1, 0, 0, 'All junk tickets.', 1, 1, current_timestamp, 1, current_timestamp); 252-- ---------------------------------------------------------- 253-- insert into table queue 254-- ---------------------------------------------------------- 255INSERT INTO queue (name, group_id, system_address_id, salutation_id, signature_id, follow_up_id, follow_up_lock, unlock_timeout, comments, valid_id, create_by, create_time, change_by, change_time) 256 VALUES 257 ('Misc', 1, 1, 1, 1, 1, 0, 0, 'All misc tickets.', 1, 1, current_timestamp, 1, current_timestamp); 258-- ---------------------------------------------------------- 259-- insert into table standard_template 260-- ---------------------------------------------------------- 261INSERT INTO standard_template (name, text, content_type, template_type, valid_id, create_by, create_time, change_by, change_time) 262 VALUES 263 ('empty answer', '', 'text/plain; charset=utf-8', 'Answer', 1, 1, current_timestamp, 1, current_timestamp); 264-- ---------------------------------------------------------- 265-- insert into table standard_template 266-- ---------------------------------------------------------- 267INSERT INTO standard_template (name, text, content_type, template_type, valid_id, create_by, create_time, change_by, change_time) 268 VALUES 269 ('test answer', 'Some test answer to show how a standard template can be used.', 'text/plain; charset=utf-8', 'Answer', 1, 1, current_timestamp, 1, current_timestamp); 270-- ---------------------------------------------------------- 271-- insert into table queue_standard_template 272-- ---------------------------------------------------------- 273INSERT INTO queue_standard_template (queue_id, standard_template_id, create_by, create_time, change_by, change_time) 274 VALUES 275 (1, 1, 1, current_timestamp, 1, current_timestamp); 276-- ---------------------------------------------------------- 277-- insert into table queue_standard_template 278-- ---------------------------------------------------------- 279INSERT INTO queue_standard_template (queue_id, standard_template_id, create_by, create_time, change_by, change_time) 280 VALUES 281 (2, 1, 1, current_timestamp, 1, current_timestamp); 282-- ---------------------------------------------------------- 283-- insert into table queue_standard_template 284-- ---------------------------------------------------------- 285INSERT INTO queue_standard_template (queue_id, standard_template_id, create_by, create_time, change_by, change_time) 286 VALUES 287 (3, 1, 1, current_timestamp, 1, current_timestamp); 288-- ---------------------------------------------------------- 289-- insert into table queue_standard_template 290-- ---------------------------------------------------------- 291INSERT INTO queue_standard_template (queue_id, standard_template_id, create_by, create_time, change_by, change_time) 292 VALUES 293 (4, 1, 1, current_timestamp, 1, current_timestamp); 294-- ---------------------------------------------------------- 295-- insert into table auto_response_type 296-- ---------------------------------------------------------- 297INSERT INTO auto_response_type (name, comments, valid_id, create_by, create_time, change_by, change_time) 298 VALUES 299 ('auto reply', 'Automatic reply which will be sent out after a new ticket has been created.', 1, 1, current_timestamp, 1, current_timestamp); 300-- ---------------------------------------------------------- 301-- insert into table auto_response_type 302-- ---------------------------------------------------------- 303INSERT INTO auto_response_type (name, comments, valid_id, create_by, create_time, change_by, change_time) 304 VALUES 305 ('auto reject', 'Automatic reject which will be sent out after a follow-up has been rejected (in case queue follow-up option is "reject").', 1, 1, current_timestamp, 1, current_timestamp); 306-- ---------------------------------------------------------- 307-- insert into table auto_response_type 308-- ---------------------------------------------------------- 309INSERT INTO auto_response_type (name, comments, valid_id, create_by, create_time, change_by, change_time) 310 VALUES 311 ('auto follow up', 'Automatic confirmation which is sent out after a follow-up has been received for a ticket (in case queue follow-up option is "possible").', 1, 1, current_timestamp, 1, current_timestamp); 312-- ---------------------------------------------------------- 313-- insert into table auto_response_type 314-- ---------------------------------------------------------- 315INSERT INTO auto_response_type (name, comments, valid_id, create_by, create_time, change_by, change_time) 316 VALUES 317 ('auto reply/new ticket', 'Automatic response which will be sent out after a follow-up has been rejected and a new ticket has been created (in case queue follow-up option is "new ticket").', 1, 1, current_timestamp, 1, current_timestamp); 318-- ---------------------------------------------------------- 319-- insert into table auto_response_type 320-- ---------------------------------------------------------- 321INSERT INTO auto_response_type (name, comments, valid_id, create_by, create_time, change_by, change_time) 322 VALUES 323 ('auto remove', 'Auto remove will be sent out after a customer removed the request.', 1, 1, current_timestamp, 1, current_timestamp); 324-- ---------------------------------------------------------- 325-- insert into table auto_response 326-- ---------------------------------------------------------- 327INSERT INTO auto_response (type_id, system_address_id, name, text0, text1, content_type, comments, valid_id, create_by, create_time, change_by, change_time) 328 VALUES 329 (1, 1, 'default reply (after new ticket has been created)', 'This is a demo text which is send to every inquiry. 330It could contain something like: 331 332Thanks for your email. A new ticket has been created. 333 334You wrote: 335<OTRS_CUSTOMER_EMAIL[6]> 336 337Your email will be answered by a human ASAP 338 339Have fun with OTRS! :-) 340 341Your OTRS Team 342', 'RE: <OTRS_CUSTOMER_SUBJECT[24]>', 'text/plain', '', 1, 1, current_timestamp, 1, current_timestamp); 343-- ---------------------------------------------------------- 344-- insert into table auto_response 345-- ---------------------------------------------------------- 346INSERT INTO auto_response (type_id, system_address_id, name, text0, text1, content_type, comments, valid_id, create_by, create_time, change_by, change_time) 347 VALUES 348 (2, 1, 'default reject (after follow-up and rejected of a closed ticket)', 'Your previous ticket is closed. 349 350-- Your follow-up has been rejected. -- 351 352Please create a new ticket. 353 354Your OTRS Team 355', 'Your email has been rejected! (RE: <OTRS_CUSTOMER_SUBJECT[24]>)', 'text/plain', '', 1, 1, current_timestamp, 1, current_timestamp); 356-- ---------------------------------------------------------- 357-- insert into table auto_response 358-- ---------------------------------------------------------- 359INSERT INTO auto_response (type_id, system_address_id, name, text0, text1, content_type, comments, valid_id, create_by, create_time, change_by, change_time) 360 VALUES 361 (3, 1, 'default follow-up (after a ticket follow-up has been added)', 'Thanks for your follow-up email 362 363You wrote: 364<OTRS_CUSTOMER_EMAIL[6]> 365 366Your email will be answered by a human ASAP. 367 368Have fun with OTRS! 369 370Your OTRS Team 371', 'RE: <OTRS_CUSTOMER_SUBJECT[24]>', 'text/plain', '', 1, 1, current_timestamp, 1, current_timestamp); 372-- ---------------------------------------------------------- 373-- insert into table auto_response 374-- ---------------------------------------------------------- 375INSERT INTO auto_response (type_id, system_address_id, name, text0, text1, content_type, comments, valid_id, create_by, create_time, change_by, change_time) 376 VALUES 377 (4, 1, 'default reject/new ticket created (after closed follow-up with new ticket creation)', 'Your previous ticket is closed. 378 379-- A new ticket has been created for you. -- 380 381You wrote: 382<OTRS_CUSTOMER_EMAIL[6]> 383 384Your email will be answered by a human ASAP. 385 386Have fun with OTRS! 387 388Your OTRS Team 389', 'New ticket has been created! (RE: <OTRS_CUSTOMER_SUBJECT[24]>)', 'text/plain', '', 1, 1, current_timestamp, 1, current_timestamp); 390-- ---------------------------------------------------------- 391-- insert into table ticket_type 392-- ---------------------------------------------------------- 393INSERT INTO ticket_type (name, valid_id, create_by, create_time, change_by, change_time) 394 VALUES 395 ('Unclassified', 1, 1, current_timestamp, 1, current_timestamp); 396-- ---------------------------------------------------------- 397-- insert into table ticket_priority 398-- ---------------------------------------------------------- 399INSERT INTO ticket_priority (name, valid_id, create_by, create_time, change_by, change_time) 400 VALUES 401 ('1 very low', 1, 1, current_timestamp, 1, current_timestamp); 402-- ---------------------------------------------------------- 403-- insert into table ticket_priority 404-- ---------------------------------------------------------- 405INSERT INTO ticket_priority (name, valid_id, create_by, create_time, change_by, change_time) 406 VALUES 407 ('2 low', 1, 1, current_timestamp, 1, current_timestamp); 408-- ---------------------------------------------------------- 409-- insert into table ticket_priority 410-- ---------------------------------------------------------- 411INSERT INTO ticket_priority (name, valid_id, create_by, create_time, change_by, change_time) 412 VALUES 413 ('3 normal', 1, 1, current_timestamp, 1, current_timestamp); 414-- ---------------------------------------------------------- 415-- insert into table ticket_priority 416-- ---------------------------------------------------------- 417INSERT INTO ticket_priority (name, valid_id, create_by, create_time, change_by, change_time) 418 VALUES 419 ('4 high', 1, 1, current_timestamp, 1, current_timestamp); 420-- ---------------------------------------------------------- 421-- insert into table ticket_priority 422-- ---------------------------------------------------------- 423INSERT INTO ticket_priority (name, valid_id, create_by, create_time, change_by, change_time) 424 VALUES 425 ('5 very high', 1, 1, current_timestamp, 1, current_timestamp); 426-- ---------------------------------------------------------- 427-- insert into table ticket_lock_type 428-- ---------------------------------------------------------- 429INSERT INTO ticket_lock_type (name, valid_id, create_by, create_time, change_by, change_time) 430 VALUES 431 ('unlock', 1, 1, current_timestamp, 1, current_timestamp); 432-- ---------------------------------------------------------- 433-- insert into table ticket_lock_type 434-- ---------------------------------------------------------- 435INSERT INTO ticket_lock_type (name, valid_id, create_by, create_time, change_by, change_time) 436 VALUES 437 ('lock', 1, 1, current_timestamp, 1, current_timestamp); 438-- ---------------------------------------------------------- 439-- insert into table ticket_lock_type 440-- ---------------------------------------------------------- 441INSERT INTO ticket_lock_type (name, valid_id, create_by, create_time, change_by, change_time) 442 VALUES 443 ('tmp_lock', 1, 1, current_timestamp, 1, current_timestamp); 444-- ---------------------------------------------------------- 445-- insert into table ticket_history_type 446-- ---------------------------------------------------------- 447INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 448 VALUES 449 ('NewTicket', 1, 1, current_timestamp, 1, current_timestamp); 450-- ---------------------------------------------------------- 451-- insert into table ticket_history_type 452-- ---------------------------------------------------------- 453INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 454 VALUES 455 ('FollowUp', 1, 1, current_timestamp, 1, current_timestamp); 456-- ---------------------------------------------------------- 457-- insert into table ticket_history_type 458-- ---------------------------------------------------------- 459INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 460 VALUES 461 ('SendAutoReject', 1, 1, current_timestamp, 1, current_timestamp); 462-- ---------------------------------------------------------- 463-- insert into table ticket_history_type 464-- ---------------------------------------------------------- 465INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 466 VALUES 467 ('SendAutoReply', 1, 1, current_timestamp, 1, current_timestamp); 468-- ---------------------------------------------------------- 469-- insert into table ticket_history_type 470-- ---------------------------------------------------------- 471INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 472 VALUES 473 ('SendAutoFollowUp', 1, 1, current_timestamp, 1, current_timestamp); 474-- ---------------------------------------------------------- 475-- insert into table ticket_history_type 476-- ---------------------------------------------------------- 477INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 478 VALUES 479 ('Forward', 1, 1, current_timestamp, 1, current_timestamp); 480-- ---------------------------------------------------------- 481-- insert into table ticket_history_type 482-- ---------------------------------------------------------- 483INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 484 VALUES 485 ('Bounce', 1, 1, current_timestamp, 1, current_timestamp); 486-- ---------------------------------------------------------- 487-- insert into table ticket_history_type 488-- ---------------------------------------------------------- 489INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 490 VALUES 491 ('SendAnswer', 1, 1, current_timestamp, 1, current_timestamp); 492-- ---------------------------------------------------------- 493-- insert into table ticket_history_type 494-- ---------------------------------------------------------- 495INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 496 VALUES 497 ('SendAgentNotification', 1, 1, current_timestamp, 1, current_timestamp); 498-- ---------------------------------------------------------- 499-- insert into table ticket_history_type 500-- ---------------------------------------------------------- 501INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 502 VALUES 503 ('SendCustomerNotification', 1, 1, current_timestamp, 1, current_timestamp); 504-- ---------------------------------------------------------- 505-- insert into table ticket_history_type 506-- ---------------------------------------------------------- 507INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 508 VALUES 509 ('EmailAgent', 1, 1, current_timestamp, 1, current_timestamp); 510-- ---------------------------------------------------------- 511-- insert into table ticket_history_type 512-- ---------------------------------------------------------- 513INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 514 VALUES 515 ('EmailCustomer', 1, 1, current_timestamp, 1, current_timestamp); 516-- ---------------------------------------------------------- 517-- insert into table ticket_history_type 518-- ---------------------------------------------------------- 519INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 520 VALUES 521 ('PhoneCallAgent', 1, 1, current_timestamp, 1, current_timestamp); 522-- ---------------------------------------------------------- 523-- insert into table ticket_history_type 524-- ---------------------------------------------------------- 525INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 526 VALUES 527 ('PhoneCallCustomer', 1, 1, current_timestamp, 1, current_timestamp); 528-- ---------------------------------------------------------- 529-- insert into table ticket_history_type 530-- ---------------------------------------------------------- 531INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 532 VALUES 533 ('AddNote', 1, 1, current_timestamp, 1, current_timestamp); 534-- ---------------------------------------------------------- 535-- insert into table ticket_history_type 536-- ---------------------------------------------------------- 537INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 538 VALUES 539 ('Move', 1, 1, current_timestamp, 1, current_timestamp); 540-- ---------------------------------------------------------- 541-- insert into table ticket_history_type 542-- ---------------------------------------------------------- 543INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 544 VALUES 545 ('Lock', 1, 1, current_timestamp, 1, current_timestamp); 546-- ---------------------------------------------------------- 547-- insert into table ticket_history_type 548-- ---------------------------------------------------------- 549INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 550 VALUES 551 ('Unlock', 1, 1, current_timestamp, 1, current_timestamp); 552-- ---------------------------------------------------------- 553-- insert into table ticket_history_type 554-- ---------------------------------------------------------- 555INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 556 VALUES 557 ('Remove', 1, 1, current_timestamp, 1, current_timestamp); 558-- ---------------------------------------------------------- 559-- insert into table ticket_history_type 560-- ---------------------------------------------------------- 561INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 562 VALUES 563 ('TimeAccounting', 1, 1, current_timestamp, 1, current_timestamp); 564-- ---------------------------------------------------------- 565-- insert into table ticket_history_type 566-- ---------------------------------------------------------- 567INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 568 VALUES 569 ('CustomerUpdate', 1, 1, current_timestamp, 1, current_timestamp); 570-- ---------------------------------------------------------- 571-- insert into table ticket_history_type 572-- ---------------------------------------------------------- 573INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 574 VALUES 575 ('PriorityUpdate', 1, 1, current_timestamp, 1, current_timestamp); 576-- ---------------------------------------------------------- 577-- insert into table ticket_history_type 578-- ---------------------------------------------------------- 579INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 580 VALUES 581 ('OwnerUpdate', 1, 1, current_timestamp, 1, current_timestamp); 582-- ---------------------------------------------------------- 583-- insert into table ticket_history_type 584-- ---------------------------------------------------------- 585INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 586 VALUES 587 ('LoopProtection', 1, 1, current_timestamp, 1, current_timestamp); 588-- ---------------------------------------------------------- 589-- insert into table ticket_history_type 590-- ---------------------------------------------------------- 591INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 592 VALUES 593 ('Misc', 1, 1, current_timestamp, 1, current_timestamp); 594-- ---------------------------------------------------------- 595-- insert into table ticket_history_type 596-- ---------------------------------------------------------- 597INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 598 VALUES 599 ('SetPendingTime', 1, 1, current_timestamp, 1, current_timestamp); 600-- ---------------------------------------------------------- 601-- insert into table ticket_history_type 602-- ---------------------------------------------------------- 603INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 604 VALUES 605 ('StateUpdate', 1, 1, current_timestamp, 1, current_timestamp); 606-- ---------------------------------------------------------- 607-- insert into table ticket_history_type 608-- ---------------------------------------------------------- 609INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 610 VALUES 611 ('TicketDynamicFieldUpdate', 1, 1, current_timestamp, 1, current_timestamp); 612-- ---------------------------------------------------------- 613-- insert into table ticket_history_type 614-- ---------------------------------------------------------- 615INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 616 VALUES 617 ('WebRequestCustomer', 1, 1, current_timestamp, 1, current_timestamp); 618-- ---------------------------------------------------------- 619-- insert into table ticket_history_type 620-- ---------------------------------------------------------- 621INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 622 VALUES 623 ('TicketLinkAdd', 1, 1, current_timestamp, 1, current_timestamp); 624-- ---------------------------------------------------------- 625-- insert into table ticket_history_type 626-- ---------------------------------------------------------- 627INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 628 VALUES 629 ('TicketLinkDelete', 1, 1, current_timestamp, 1, current_timestamp); 630-- ---------------------------------------------------------- 631-- insert into table ticket_history_type 632-- ---------------------------------------------------------- 633INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 634 VALUES 635 ('SystemRequest', 1, 1, current_timestamp, 1, current_timestamp); 636-- ---------------------------------------------------------- 637-- insert into table ticket_history_type 638-- ---------------------------------------------------------- 639INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 640 VALUES 641 ('Merged', 1, 1, current_timestamp, 1, current_timestamp); 642-- ---------------------------------------------------------- 643-- insert into table ticket_history_type 644-- ---------------------------------------------------------- 645INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 646 VALUES 647 ('ResponsibleUpdate', 1, 1, current_timestamp, 1, current_timestamp); 648-- ---------------------------------------------------------- 649-- insert into table ticket_history_type 650-- ---------------------------------------------------------- 651INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 652 VALUES 653 ('Subscribe', 1, 1, current_timestamp, 1, current_timestamp); 654-- ---------------------------------------------------------- 655-- insert into table ticket_history_type 656-- ---------------------------------------------------------- 657INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 658 VALUES 659 ('Unsubscribe', 1, 1, current_timestamp, 1, current_timestamp); 660-- ---------------------------------------------------------- 661-- insert into table ticket_history_type 662-- ---------------------------------------------------------- 663INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 664 VALUES 665 ('TypeUpdate', 1, 1, current_timestamp, 1, current_timestamp); 666-- ---------------------------------------------------------- 667-- insert into table ticket_history_type 668-- ---------------------------------------------------------- 669INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 670 VALUES 671 ('ServiceUpdate', 1, 1, current_timestamp, 1, current_timestamp); 672-- ---------------------------------------------------------- 673-- insert into table ticket_history_type 674-- ---------------------------------------------------------- 675INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 676 VALUES 677 ('SLAUpdate', 1, 1, current_timestamp, 1, current_timestamp); 678-- ---------------------------------------------------------- 679-- insert into table ticket_history_type 680-- ---------------------------------------------------------- 681INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 682 VALUES 683 ('ArchiveFlagUpdate', 1, 1, current_timestamp, 1, current_timestamp); 684-- ---------------------------------------------------------- 685-- insert into table ticket_history_type 686-- ---------------------------------------------------------- 687INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 688 VALUES 689 ('EscalationSolutionTimeStop', 1, 1, current_timestamp, 1, current_timestamp); 690-- ---------------------------------------------------------- 691-- insert into table ticket_history_type 692-- ---------------------------------------------------------- 693INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 694 VALUES 695 ('EscalationResponseTimeStart', 1, 1, current_timestamp, 1, current_timestamp); 696-- ---------------------------------------------------------- 697-- insert into table ticket_history_type 698-- ---------------------------------------------------------- 699INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 700 VALUES 701 ('EscalationUpdateTimeStart', 1, 1, current_timestamp, 1, current_timestamp); 702-- ---------------------------------------------------------- 703-- insert into table ticket_history_type 704-- ---------------------------------------------------------- 705INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 706 VALUES 707 ('EscalationSolutionTimeStart', 1, 1, current_timestamp, 1, current_timestamp); 708-- ---------------------------------------------------------- 709-- insert into table ticket_history_type 710-- ---------------------------------------------------------- 711INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 712 VALUES 713 ('EscalationResponseTimeNotifyBefore', 1, 1, current_timestamp, 1, current_timestamp); 714-- ---------------------------------------------------------- 715-- insert into table ticket_history_type 716-- ---------------------------------------------------------- 717INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 718 VALUES 719 ('EscalationUpdateTimeNotifyBefore', 1, 1, current_timestamp, 1, current_timestamp); 720-- ---------------------------------------------------------- 721-- insert into table ticket_history_type 722-- ---------------------------------------------------------- 723INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 724 VALUES 725 ('EscalationSolutionTimeNotifyBefore', 1, 1, current_timestamp, 1, current_timestamp); 726-- ---------------------------------------------------------- 727-- insert into table ticket_history_type 728-- ---------------------------------------------------------- 729INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 730 VALUES 731 ('EscalationResponseTimeStop', 1, 1, current_timestamp, 1, current_timestamp); 732-- ---------------------------------------------------------- 733-- insert into table ticket_history_type 734-- ---------------------------------------------------------- 735INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 736 VALUES 737 ('EscalationUpdateTimeStop', 1, 1, current_timestamp, 1, current_timestamp); 738-- ---------------------------------------------------------- 739-- insert into table ticket_history_type 740-- ---------------------------------------------------------- 741INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 742 VALUES 743 ('TitleUpdate', 1, 1, current_timestamp, 1, current_timestamp); 744-- ---------------------------------------------------------- 745-- insert into table ticket_history_type 746-- ---------------------------------------------------------- 747INSERT INTO ticket_history_type (name, valid_id, create_by, create_time, change_by, change_time) 748 VALUES 749 ('EmailResend', 1, 1, current_timestamp, 1, current_timestamp); 750-- ---------------------------------------------------------- 751-- insert into table article_sender_type 752-- ---------------------------------------------------------- 753INSERT INTO article_sender_type (name, valid_id, create_by, create_time, change_by, change_time) 754 VALUES 755 ('agent', 1, 1, current_timestamp, 1, current_timestamp); 756-- ---------------------------------------------------------- 757-- insert into table article_sender_type 758-- ---------------------------------------------------------- 759INSERT INTO article_sender_type (name, valid_id, create_by, create_time, change_by, change_time) 760 VALUES 761 ('system', 1, 1, current_timestamp, 1, current_timestamp); 762-- ---------------------------------------------------------- 763-- insert into table article_sender_type 764-- ---------------------------------------------------------- 765INSERT INTO article_sender_type (name, valid_id, create_by, create_time, change_by, change_time) 766 VALUES 767 ('customer', 1, 1, current_timestamp, 1, current_timestamp); 768-- ---------------------------------------------------------- 769-- insert into table ticket 770-- ---------------------------------------------------------- 771INSERT INTO ticket (tn, queue_id, ticket_lock_id, user_id, responsible_user_id, ticket_priority_id, ticket_state_id, title, timeout, until_time, escalation_time, escalation_response_time, escalation_update_time, escalation_solution_time, create_by, create_time, change_by, change_time) 772 VALUES 773 ('2015071510123456', 2, 1, 1, 1, 3, 1, 'Welcome to OTRS!', 0, 0, 0, 0, 0, 0, 1, current_timestamp, 1, current_timestamp); 774-- ---------------------------------------------------------- 775-- insert into table communication_channel 776-- ---------------------------------------------------------- 777INSERT INTO communication_channel (name, module, package_name, channel_data, valid_id, create_by, create_time, change_by, change_time) 778 VALUES 779 ('Email', 'Kernel::System::CommunicationChannel::Email', 'Framework', '--- 780ArticleDataArticleIDField: article_id 781ArticleDataTables: 782- article_data_mime 783- article_data_mime_plain 784- article_data_mime_attachment 785- article_data_mime_send_error 786', 1, 1, current_timestamp, 1, current_timestamp); 787-- ---------------------------------------------------------- 788-- insert into table communication_channel 789-- ---------------------------------------------------------- 790INSERT INTO communication_channel (name, module, package_name, channel_data, valid_id, create_by, create_time, change_by, change_time) 791 VALUES 792 ('Phone', 'Kernel::System::CommunicationChannel::Phone', 'Framework', '--- 793ArticleDataArticleIDField: article_id 794ArticleDataTables: 795- article_data_mime 796- article_data_mime_plain 797- article_data_mime_attachment 798- article_data_mime_send_error 799', 1, 1, current_timestamp, 1, current_timestamp); 800-- ---------------------------------------------------------- 801-- insert into table communication_channel 802-- ---------------------------------------------------------- 803INSERT INTO communication_channel (name, module, package_name, channel_data, valid_id, create_by, create_time, change_by, change_time) 804 VALUES 805 ('Internal', 'Kernel::System::CommunicationChannel::Internal', 'Framework', '--- 806ArticleDataArticleIDField: article_id 807ArticleDataTables: 808- article_data_mime 809- article_data_mime_plain 810- article_data_mime_attachment 811- article_data_mime_send_error 812', 1, 1, current_timestamp, 1, current_timestamp); 813-- ---------------------------------------------------------- 814-- insert into table communication_channel 815-- ---------------------------------------------------------- 816INSERT INTO communication_channel (name, module, package_name, channel_data, valid_id, create_by, create_time, change_by, change_time) 817 VALUES 818 ('Chat', 'Kernel::System::CommunicationChannel::Chat', 'Framework', '--- 819ArticleDataArticleIDField: article_id 820ArticleDataTables: 821- article_data_otrs_chat 822', 1, 1, current_timestamp, 1, current_timestamp); 823-- ---------------------------------------------------------- 824-- insert into table article 825-- ---------------------------------------------------------- 826INSERT INTO article (ticket_id, communication_channel_id, article_sender_type_id, is_visible_for_customer, create_by, create_time, change_by, change_time) 827 VALUES 828 (1, 1, 3, 1, 1, current_timestamp, 1, current_timestamp); 829-- ---------------------------------------------------------- 830-- insert into table article_data_mime 831-- ---------------------------------------------------------- 832INSERT INTO article_data_mime (article_id, a_from, a_to, a_subject, a_body, a_message_id, incoming_time, content_path, create_by, create_time, change_by, change_time) 833 VALUES 834 (1, 'OTRS Feedback <marketing@otrs.com>', 'Your OTRS System <otrs@localhost>', 'Welcome to OTRS!', 'Welcome to the OTRS Group’s community! 835 836Thank you for installing ((OTRS)) Community Edition, the world’s most popular open source service management software. It’s available in 40 languages and used by more than 170,000 companies worldwide. 837 838Please be aware that we do not offer official vendor support for the ((OTRS)) Community Edition. 839 840Resources for ((OTRS)) Community Edition Users 841 842You can find updates and patches for ((OTRS)) Community Edition at https://community.otrs.com/download-otrs-community-edition/. 843 844Find help and exchange ideas in our knowledge base at https://community.otrs.com/open-source/. Here, you’ll be able to take part of the OTRS Group’s Community and take advantage of our blog posts. You can report a bug, suggest a feature or discover online documentation. 845 846Mailing lists are also available at https://lists.otrs.org/ 847 848Interested in OTRS? We offer professional service management solutions too. 849 850To get the most up-to-date version of OTRS and to receive the best possible support for your business, we recommend that you use our fully-managed version of OTRS: https://otrs.com/how-to-buy/. 851 852With this version, you’ll gain access to: 853 854- Exclusive features that are only available to OTRS users 855- The OTRS Feature Add-ons 856- Business process management support 857- Included professional services – training, support and consulting 858- All the latest security updates and patches 859- Implementation and configuration by our experts 860 861Find more information about OTRS support and consulting by visiting https://otrs.com/otrs-solutions/. 862 863Ready to get started with fully-managed OTRS instead? -> Contact Sales: https://otrs.com/contact/ 864 865Best regards and ((enjoy)) ((OTRS)) Community Edition, 866 867Your OTRS Team 868', '<007@localhost>', 1436949030, '2015/07/15', 1, current_timestamp, 1, current_timestamp); 869-- ---------------------------------------------------------- 870-- insert into table article_data_mime_plain 871-- ---------------------------------------------------------- 872INSERT INTO article_data_mime_plain (article_id, body, create_by, create_time, change_by, change_time) 873 VALUES 874 (1, 'From: OTRS Feedback <marketing@otrs.com> 875To: Your OTRS System <otrs@localhost> 876Subject: Welcome to OTRS! 877Content-Type: text/plain; charset=utf-8 878Content-Transfer-Encoding: 8bit 879 880Welcome to the OTRS Group’s community! 881 882Thank you for installing ((OTRS)) Community Edition, the world’s most popular open source service management software. It’s available in 40 languages and used by more than 170,000 companies worldwide. 883 884Please be aware that we do not offer official vendor support for the ((OTRS)) Community Edition. 885 886Resources for ((OTRS)) Community Edition Users 887 888You can find updates and patches for ((OTRS)) Community Edition at https://community.otrs.com/download-otrs-community-edition/. 889 890Find help and exchange ideas in our knowledge base at https://community.otrs.com/open-source/. Here, you’ll be able to take part of the OTRS Group’s Community and take advantage of our blog posts. You can report a bug, suggest a feature or discover online documentation. 891 892Mailing lists are also available at https://lists.otrs.org/ 893 894Interested in OTRS? We offer professional service management solutions too. 895 896To get the most up-to-date version of OTRS and to receive the best possible support for your business, we recommend that you use our fully-managed version of OTRS: https://otrs.com/how-to-buy/. 897 898With this version, you’ll gain access to: 899 900- Exclusive features that are only available to OTRS users 901- The OTRS Feature Add-ons 902- Business process management support 903- Included professional services – training, support and consulting 904- All the latest security updates and patches 905- Implementation and configuration by our experts 906 907Find more information about OTRS support and consulting by visiting https://otrs.com/otrs-solutions/. 908 909Ready to get started with fully-managed OTRS instead? -> Contact Sales: https://otrs.com/contact/ 910 911Best regards and ((enjoy)) ((OTRS)) Community Edition, 912 913Your OTRS Team 914', 1, current_timestamp, 1, current_timestamp); 915-- ---------------------------------------------------------- 916-- insert into table ticket_history 917-- ---------------------------------------------------------- 918INSERT INTO ticket_history (name, history_type_id, ticket_id, type_id, article_id, priority_id, owner_id, state_id, queue_id, create_by, create_time, change_by, change_time) 919 VALUES 920 ('New Ticket [2015071510123456] created.', 1, 1, 1, 1, 3, 1, 1, 1, 1, current_timestamp, 1, current_timestamp); 921-- ---------------------------------------------------------- 922-- insert into table notification_event 923-- ---------------------------------------------------------- 924INSERT INTO notification_event (name, valid_id, comments, create_by, create_time, change_by, change_time) 925 VALUES 926 ('Ticket create notification', 1, '', 1, current_timestamp, 1, current_timestamp); 927-- ---------------------------------------------------------- 928-- insert into table notification_event_item 929-- ---------------------------------------------------------- 930INSERT INTO notification_event_item (notification_id, event_key, event_value) 931 VALUES 932 (1, 'VisibleForAgent', '1'); 933-- ---------------------------------------------------------- 934-- insert into table notification_event_item 935-- ---------------------------------------------------------- 936INSERT INTO notification_event_item (notification_id, event_key, event_value) 937 VALUES 938 (1, 'VisibleForAgentTooltip', 'You will receive a notification each time a new ticket is created in one of your "My Queues" or "My Services".'); 939-- ---------------------------------------------------------- 940-- insert into table notification_event_item 941-- ---------------------------------------------------------- 942INSERT INTO notification_event_item (notification_id, event_key, event_value) 943 VALUES 944 (1, 'Events', 'NotificationNewTicket'); 945-- ---------------------------------------------------------- 946-- insert into table notification_event_item 947-- ---------------------------------------------------------- 948INSERT INTO notification_event_item (notification_id, event_key, event_value) 949 VALUES 950 (1, 'Recipients', 'AgentMyQueues'); 951-- ---------------------------------------------------------- 952-- insert into table notification_event_item 953-- ---------------------------------------------------------- 954INSERT INTO notification_event_item (notification_id, event_key, event_value) 955 VALUES 956 (1, 'Recipients', 'AgentMyServices'); 957-- ---------------------------------------------------------- 958-- insert into table notification_event_item 959-- ---------------------------------------------------------- 960INSERT INTO notification_event_item (notification_id, event_key, event_value) 961 VALUES 962 (1, 'SendOnOutOfOffice', '1'); 963-- ---------------------------------------------------------- 964-- insert into table notification_event_item 965-- ---------------------------------------------------------- 966INSERT INTO notification_event_item (notification_id, event_key, event_value) 967 VALUES 968 (1, 'Transports', 'Email'); 969-- ---------------------------------------------------------- 970-- insert into table notification_event_item 971-- ---------------------------------------------------------- 972INSERT INTO notification_event_item (notification_id, event_key, event_value) 973 VALUES 974 (1, 'AgentEnabledByDefault', 'Email'); 975-- ---------------------------------------------------------- 976-- insert into table notification_event 977-- ---------------------------------------------------------- 978INSERT INTO notification_event (name, valid_id, comments, create_by, create_time, change_by, change_time) 979 VALUES 980 ('Ticket follow-up notification (unlocked)', 1, '', 1, current_timestamp, 1, current_timestamp); 981-- ---------------------------------------------------------- 982-- insert into table notification_event_item 983-- ---------------------------------------------------------- 984INSERT INTO notification_event_item (notification_id, event_key, event_value) 985 VALUES 986 (2, 'VisibleForAgent', '1'); 987-- ---------------------------------------------------------- 988-- insert into table notification_event_item 989-- ---------------------------------------------------------- 990INSERT INTO notification_event_item (notification_id, event_key, event_value) 991 VALUES 992 (2, 'VisibleForAgentTooltip', 'You will receive a notification if a customer sends a follow-up to an unlocked ticket which is in your "My Queues" or "My Services".'); 993-- ---------------------------------------------------------- 994-- insert into table notification_event_item 995-- ---------------------------------------------------------- 996INSERT INTO notification_event_item (notification_id, event_key, event_value) 997 VALUES 998 (2, 'Events', 'NotificationFollowUp'); 999-- ---------------------------------------------------------- 1000-- insert into table notification_event_item 1001-- ---------------------------------------------------------- 1002INSERT INTO notification_event_item (notification_id, event_key, event_value) 1003 VALUES 1004 (2, 'Recipients', 'AgentOwner'); 1005-- ---------------------------------------------------------- 1006-- insert into table notification_event_item 1007-- ---------------------------------------------------------- 1008INSERT INTO notification_event_item (notification_id, event_key, event_value) 1009 VALUES 1010 (2, 'Recipients', 'AgentWatcher'); 1011-- ---------------------------------------------------------- 1012-- insert into table notification_event_item 1013-- ---------------------------------------------------------- 1014INSERT INTO notification_event_item (notification_id, event_key, event_value) 1015 VALUES 1016 (2, 'Recipients', 'AgentMyQueues'); 1017-- ---------------------------------------------------------- 1018-- insert into table notification_event_item 1019-- ---------------------------------------------------------- 1020INSERT INTO notification_event_item (notification_id, event_key, event_value) 1021 VALUES 1022 (2, 'Recipients', 'AgentMyServices'); 1023-- ---------------------------------------------------------- 1024-- insert into table notification_event_item 1025-- ---------------------------------------------------------- 1026INSERT INTO notification_event_item (notification_id, event_key, event_value) 1027 VALUES 1028 (2, 'SendOnOutOfOffice', '1'); 1029-- ---------------------------------------------------------- 1030-- insert into table notification_event_item 1031-- ---------------------------------------------------------- 1032INSERT INTO notification_event_item (notification_id, event_key, event_value) 1033 VALUES 1034 (2, 'LockID', '1'); 1035-- ---------------------------------------------------------- 1036-- insert into table notification_event_item 1037-- ---------------------------------------------------------- 1038INSERT INTO notification_event_item (notification_id, event_key, event_value) 1039 VALUES 1040 (2, 'Transports', 'Email'); 1041-- ---------------------------------------------------------- 1042-- insert into table notification_event_item 1043-- ---------------------------------------------------------- 1044INSERT INTO notification_event_item (notification_id, event_key, event_value) 1045 VALUES 1046 (2, 'AgentEnabledByDefault', 'Email'); 1047-- ---------------------------------------------------------- 1048-- insert into table notification_event 1049-- ---------------------------------------------------------- 1050INSERT INTO notification_event (name, valid_id, comments, create_by, create_time, change_by, change_time) 1051 VALUES 1052 ('Ticket follow-up notification (locked)', 1, '', 1, current_timestamp, 1, current_timestamp); 1053-- ---------------------------------------------------------- 1054-- insert into table notification_event_item 1055-- ---------------------------------------------------------- 1056INSERT INTO notification_event_item (notification_id, event_key, event_value) 1057 VALUES 1058 (3, 'VisibleForAgent', '1'); 1059-- ---------------------------------------------------------- 1060-- insert into table notification_event_item 1061-- ---------------------------------------------------------- 1062INSERT INTO notification_event_item (notification_id, event_key, event_value) 1063 VALUES 1064 (3, 'VisibleForAgentTooltip', 'You will receive a notification if a customer sends a follow-up to a locked ticket of which you are the ticket owner or responsible.'); 1065-- ---------------------------------------------------------- 1066-- insert into table notification_event_item 1067-- ---------------------------------------------------------- 1068INSERT INTO notification_event_item (notification_id, event_key, event_value) 1069 VALUES 1070 (3, 'Events', 'NotificationFollowUp'); 1071-- ---------------------------------------------------------- 1072-- insert into table notification_event_item 1073-- ---------------------------------------------------------- 1074INSERT INTO notification_event_item (notification_id, event_key, event_value) 1075 VALUES 1076 (3, 'Recipients', 'AgentOwner'); 1077-- ---------------------------------------------------------- 1078-- insert into table notification_event_item 1079-- ---------------------------------------------------------- 1080INSERT INTO notification_event_item (notification_id, event_key, event_value) 1081 VALUES 1082 (3, 'Recipients', 'AgentResponsible'); 1083-- ---------------------------------------------------------- 1084-- insert into table notification_event_item 1085-- ---------------------------------------------------------- 1086INSERT INTO notification_event_item (notification_id, event_key, event_value) 1087 VALUES 1088 (3, 'Recipients', 'AgentWatcher'); 1089-- ---------------------------------------------------------- 1090-- insert into table notification_event_item 1091-- ---------------------------------------------------------- 1092INSERT INTO notification_event_item (notification_id, event_key, event_value) 1093 VALUES 1094 (3, 'SendOnOutOfOffice', '1'); 1095-- ---------------------------------------------------------- 1096-- insert into table notification_event_item 1097-- ---------------------------------------------------------- 1098INSERT INTO notification_event_item (notification_id, event_key, event_value) 1099 VALUES 1100 (3, 'LockID', '2'); 1101-- ---------------------------------------------------------- 1102-- insert into table notification_event_item 1103-- ---------------------------------------------------------- 1104INSERT INTO notification_event_item (notification_id, event_key, event_value) 1105 VALUES 1106 (3, 'LockID', '3'); 1107-- ---------------------------------------------------------- 1108-- insert into table notification_event_item 1109-- ---------------------------------------------------------- 1110INSERT INTO notification_event_item (notification_id, event_key, event_value) 1111 VALUES 1112 (3, 'Transports', 'Email'); 1113-- ---------------------------------------------------------- 1114-- insert into table notification_event_item 1115-- ---------------------------------------------------------- 1116INSERT INTO notification_event_item (notification_id, event_key, event_value) 1117 VALUES 1118 (3, 'AgentEnabledByDefault', 'Email'); 1119-- ---------------------------------------------------------- 1120-- insert into table notification_event 1121-- ---------------------------------------------------------- 1122INSERT INTO notification_event (name, valid_id, comments, create_by, create_time, change_by, change_time) 1123 VALUES 1124 ('Ticket lock timeout notification', 1, '', 1, current_timestamp, 1, current_timestamp); 1125-- ---------------------------------------------------------- 1126-- insert into table notification_event_item 1127-- ---------------------------------------------------------- 1128INSERT INTO notification_event_item (notification_id, event_key, event_value) 1129 VALUES 1130 (4, 'VisibleForAgent', '1'); 1131-- ---------------------------------------------------------- 1132-- insert into table notification_event_item 1133-- ---------------------------------------------------------- 1134INSERT INTO notification_event_item (notification_id, event_key, event_value) 1135 VALUES 1136 (4, 'VisibleForAgentTooltip', 'You will receive a notification as soon as a ticket owned by you is automatically unlocked.'); 1137-- ---------------------------------------------------------- 1138-- insert into table notification_event_item 1139-- ---------------------------------------------------------- 1140INSERT INTO notification_event_item (notification_id, event_key, event_value) 1141 VALUES 1142 (4, 'Events', 'NotificationLockTimeout'); 1143-- ---------------------------------------------------------- 1144-- insert into table notification_event_item 1145-- ---------------------------------------------------------- 1146INSERT INTO notification_event_item (notification_id, event_key, event_value) 1147 VALUES 1148 (4, 'Recipients', 'AgentOwner'); 1149-- ---------------------------------------------------------- 1150-- insert into table notification_event_item 1151-- ---------------------------------------------------------- 1152INSERT INTO notification_event_item (notification_id, event_key, event_value) 1153 VALUES 1154 (4, 'SendOnOutOfOffice', '1'); 1155-- ---------------------------------------------------------- 1156-- insert into table notification_event_item 1157-- ---------------------------------------------------------- 1158INSERT INTO notification_event_item (notification_id, event_key, event_value) 1159 VALUES 1160 (4, 'Transports', 'Email'); 1161-- ---------------------------------------------------------- 1162-- insert into table notification_event_item 1163-- ---------------------------------------------------------- 1164INSERT INTO notification_event_item (notification_id, event_key, event_value) 1165 VALUES 1166 (4, 'AgentEnabledByDefault', 'Email'); 1167-- ---------------------------------------------------------- 1168-- insert into table notification_event 1169-- ---------------------------------------------------------- 1170INSERT INTO notification_event (name, valid_id, comments, create_by, create_time, change_by, change_time) 1171 VALUES 1172 ('Ticket owner update notification', 1, '', 1, current_timestamp, 1, current_timestamp); 1173-- ---------------------------------------------------------- 1174-- insert into table notification_event_item 1175-- ---------------------------------------------------------- 1176INSERT INTO notification_event_item (notification_id, event_key, event_value) 1177 VALUES 1178 (5, 'Events', 'NotificationOwnerUpdate'); 1179-- ---------------------------------------------------------- 1180-- insert into table notification_event_item 1181-- ---------------------------------------------------------- 1182INSERT INTO notification_event_item (notification_id, event_key, event_value) 1183 VALUES 1184 (5, 'Recipients', 'AgentOwner'); 1185-- ---------------------------------------------------------- 1186-- insert into table notification_event_item 1187-- ---------------------------------------------------------- 1188INSERT INTO notification_event_item (notification_id, event_key, event_value) 1189 VALUES 1190 (5, 'SendOnOutOfOffice', '1'); 1191-- ---------------------------------------------------------- 1192-- insert into table notification_event_item 1193-- ---------------------------------------------------------- 1194INSERT INTO notification_event_item (notification_id, event_key, event_value) 1195 VALUES 1196 (5, 'Transports', 'Email'); 1197-- ---------------------------------------------------------- 1198-- insert into table notification_event 1199-- ---------------------------------------------------------- 1200INSERT INTO notification_event (name, valid_id, comments, create_by, create_time, change_by, change_time) 1201 VALUES 1202 ('Ticket responsible update notification', 1, '', 1, current_timestamp, 1, current_timestamp); 1203-- ---------------------------------------------------------- 1204-- insert into table notification_event_item 1205-- ---------------------------------------------------------- 1206INSERT INTO notification_event_item (notification_id, event_key, event_value) 1207 VALUES 1208 (6, 'Events', 'NotificationResponsibleUpdate'); 1209-- ---------------------------------------------------------- 1210-- insert into table notification_event_item 1211-- ---------------------------------------------------------- 1212INSERT INTO notification_event_item (notification_id, event_key, event_value) 1213 VALUES 1214 (6, 'Recipients', 'AgentResponsible'); 1215-- ---------------------------------------------------------- 1216-- insert into table notification_event_item 1217-- ---------------------------------------------------------- 1218INSERT INTO notification_event_item (notification_id, event_key, event_value) 1219 VALUES 1220 (6, 'SendOnOutOfOffice', '1'); 1221-- ---------------------------------------------------------- 1222-- insert into table notification_event_item 1223-- ---------------------------------------------------------- 1224INSERT INTO notification_event_item (notification_id, event_key, event_value) 1225 VALUES 1226 (6, 'Transports', 'Email'); 1227-- ---------------------------------------------------------- 1228-- insert into table notification_event 1229-- ---------------------------------------------------------- 1230INSERT INTO notification_event (name, valid_id, comments, create_by, create_time, change_by, change_time) 1231 VALUES 1232 ('Ticket new note notification', 1, '', 1, current_timestamp, 1, current_timestamp); 1233-- ---------------------------------------------------------- 1234-- insert into table notification_event_item 1235-- ---------------------------------------------------------- 1236INSERT INTO notification_event_item (notification_id, event_key, event_value) 1237 VALUES 1238 (7, 'Events', 'NotificationAddNote'); 1239-- ---------------------------------------------------------- 1240-- insert into table notification_event_item 1241-- ---------------------------------------------------------- 1242INSERT INTO notification_event_item (notification_id, event_key, event_value) 1243 VALUES 1244 (7, 'Recipients', 'AgentOwner'); 1245-- ---------------------------------------------------------- 1246-- insert into table notification_event_item 1247-- ---------------------------------------------------------- 1248INSERT INTO notification_event_item (notification_id, event_key, event_value) 1249 VALUES 1250 (7, 'Recipients', 'AgentResponsible'); 1251-- ---------------------------------------------------------- 1252-- insert into table notification_event_item 1253-- ---------------------------------------------------------- 1254INSERT INTO notification_event_item (notification_id, event_key, event_value) 1255 VALUES 1256 (7, 'Recipients', 'AgentWatcher'); 1257-- ---------------------------------------------------------- 1258-- insert into table notification_event_item 1259-- ---------------------------------------------------------- 1260INSERT INTO notification_event_item (notification_id, event_key, event_value) 1261 VALUES 1262 (7, 'SendOnOutOfOffice', '1'); 1263-- ---------------------------------------------------------- 1264-- insert into table notification_event_item 1265-- ---------------------------------------------------------- 1266INSERT INTO notification_event_item (notification_id, event_key, event_value) 1267 VALUES 1268 (7, 'Transports', 'Email'); 1269-- ---------------------------------------------------------- 1270-- insert into table notification_event 1271-- ---------------------------------------------------------- 1272INSERT INTO notification_event (name, valid_id, comments, create_by, create_time, change_by, change_time) 1273 VALUES 1274 ('Ticket queue update notification', 1, '', 1, current_timestamp, 1, current_timestamp); 1275-- ---------------------------------------------------------- 1276-- insert into table notification_event_item 1277-- ---------------------------------------------------------- 1278INSERT INTO notification_event_item (notification_id, event_key, event_value) 1279 VALUES 1280 (8, 'VisibleForAgent', '1'); 1281-- ---------------------------------------------------------- 1282-- insert into table notification_event_item 1283-- ---------------------------------------------------------- 1284INSERT INTO notification_event_item (notification_id, event_key, event_value) 1285 VALUES 1286 (8, 'VisibleForAgentTooltip', 'You will receive a notification if a ticket is moved into one of your "My Queues".'); 1287-- ---------------------------------------------------------- 1288-- insert into table notification_event_item 1289-- ---------------------------------------------------------- 1290INSERT INTO notification_event_item (notification_id, event_key, event_value) 1291 VALUES 1292 (8, 'Events', 'NotificationMove'); 1293-- ---------------------------------------------------------- 1294-- insert into table notification_event_item 1295-- ---------------------------------------------------------- 1296INSERT INTO notification_event_item (notification_id, event_key, event_value) 1297 VALUES 1298 (8, 'Recipients', 'AgentMyQueues'); 1299-- ---------------------------------------------------------- 1300-- insert into table notification_event_item 1301-- ---------------------------------------------------------- 1302INSERT INTO notification_event_item (notification_id, event_key, event_value) 1303 VALUES 1304 (8, 'SendOnOutOfOffice', '1'); 1305-- ---------------------------------------------------------- 1306-- insert into table notification_event_item 1307-- ---------------------------------------------------------- 1308INSERT INTO notification_event_item (notification_id, event_key, event_value) 1309 VALUES 1310 (8, 'Transports', 'Email'); 1311-- ---------------------------------------------------------- 1312-- insert into table notification_event_item 1313-- ---------------------------------------------------------- 1314INSERT INTO notification_event_item (notification_id, event_key, event_value) 1315 VALUES 1316 (8, 'AgentEnabledByDefault', 'Email'); 1317-- ---------------------------------------------------------- 1318-- insert into table notification_event 1319-- ---------------------------------------------------------- 1320INSERT INTO notification_event (name, valid_id, comments, create_by, create_time, change_by, change_time) 1321 VALUES 1322 ('Ticket pending reminder notification (locked)', 1, '', 1, current_timestamp, 1, current_timestamp); 1323-- ---------------------------------------------------------- 1324-- insert into table notification_event_item 1325-- ---------------------------------------------------------- 1326INSERT INTO notification_event_item (notification_id, event_key, event_value) 1327 VALUES 1328 (9, 'Events', 'NotificationPendingReminder'); 1329-- ---------------------------------------------------------- 1330-- insert into table notification_event_item 1331-- ---------------------------------------------------------- 1332INSERT INTO notification_event_item (notification_id, event_key, event_value) 1333 VALUES 1334 (9, 'Recipients', 'AgentOwner'); 1335-- ---------------------------------------------------------- 1336-- insert into table notification_event_item 1337-- ---------------------------------------------------------- 1338INSERT INTO notification_event_item (notification_id, event_key, event_value) 1339 VALUES 1340 (9, 'Recipients', 'AgentResponsible'); 1341-- ---------------------------------------------------------- 1342-- insert into table notification_event_item 1343-- ---------------------------------------------------------- 1344INSERT INTO notification_event_item (notification_id, event_key, event_value) 1345 VALUES 1346 (9, 'SendOnOutOfOffice', '1'); 1347-- ---------------------------------------------------------- 1348-- insert into table notification_event_item 1349-- ---------------------------------------------------------- 1350INSERT INTO notification_event_item (notification_id, event_key, event_value) 1351 VALUES 1352 (9, 'OncePerDay', '1'); 1353-- ---------------------------------------------------------- 1354-- insert into table notification_event_item 1355-- ---------------------------------------------------------- 1356INSERT INTO notification_event_item (notification_id, event_key, event_value) 1357 VALUES 1358 (9, 'LockID', '2'); 1359-- ---------------------------------------------------------- 1360-- insert into table notification_event_item 1361-- ---------------------------------------------------------- 1362INSERT INTO notification_event_item (notification_id, event_key, event_value) 1363 VALUES 1364 (9, 'LockID', '3'); 1365-- ---------------------------------------------------------- 1366-- insert into table notification_event_item 1367-- ---------------------------------------------------------- 1368INSERT INTO notification_event_item (notification_id, event_key, event_value) 1369 VALUES 1370 (9, 'Transports', 'Email'); 1371-- ---------------------------------------------------------- 1372-- insert into table notification_event 1373-- ---------------------------------------------------------- 1374INSERT INTO notification_event (name, valid_id, comments, create_by, create_time, change_by, change_time) 1375 VALUES 1376 ('Ticket pending reminder notification (unlocked)', 1, '', 1, current_timestamp, 1, current_timestamp); 1377-- ---------------------------------------------------------- 1378-- insert into table notification_event_item 1379-- ---------------------------------------------------------- 1380INSERT INTO notification_event_item (notification_id, event_key, event_value) 1381 VALUES 1382 (10, 'Events', 'NotificationPendingReminder'); 1383-- ---------------------------------------------------------- 1384-- insert into table notification_event_item 1385-- ---------------------------------------------------------- 1386INSERT INTO notification_event_item (notification_id, event_key, event_value) 1387 VALUES 1388 (10, 'Recipients', 'AgentOwner'); 1389-- ---------------------------------------------------------- 1390-- insert into table notification_event_item 1391-- ---------------------------------------------------------- 1392INSERT INTO notification_event_item (notification_id, event_key, event_value) 1393 VALUES 1394 (10, 'Recipients', 'AgentResponsible'); 1395-- ---------------------------------------------------------- 1396-- insert into table notification_event_item 1397-- ---------------------------------------------------------- 1398INSERT INTO notification_event_item (notification_id, event_key, event_value) 1399 VALUES 1400 (10, 'Recipients', 'AgentMyQueues'); 1401-- ---------------------------------------------------------- 1402-- insert into table notification_event_item 1403-- ---------------------------------------------------------- 1404INSERT INTO notification_event_item (notification_id, event_key, event_value) 1405 VALUES 1406 (10, 'SendOnOutOfOffice', '1'); 1407-- ---------------------------------------------------------- 1408-- insert into table notification_event_item 1409-- ---------------------------------------------------------- 1410INSERT INTO notification_event_item (notification_id, event_key, event_value) 1411 VALUES 1412 (10, 'OncePerDay', '1'); 1413-- ---------------------------------------------------------- 1414-- insert into table notification_event_item 1415-- ---------------------------------------------------------- 1416INSERT INTO notification_event_item (notification_id, event_key, event_value) 1417 VALUES 1418 (10, 'LockID', '1'); 1419-- ---------------------------------------------------------- 1420-- insert into table notification_event_item 1421-- ---------------------------------------------------------- 1422INSERT INTO notification_event_item (notification_id, event_key, event_value) 1423 VALUES 1424 (10, 'Transports', 'Email'); 1425-- ---------------------------------------------------------- 1426-- insert into table notification_event 1427-- ---------------------------------------------------------- 1428INSERT INTO notification_event (name, valid_id, comments, create_by, create_time, change_by, change_time) 1429 VALUES 1430 ('Ticket escalation notification', 1, '', 1, current_timestamp, 1, current_timestamp); 1431-- ---------------------------------------------------------- 1432-- insert into table notification_event_item 1433-- ---------------------------------------------------------- 1434INSERT INTO notification_event_item (notification_id, event_key, event_value) 1435 VALUES 1436 (11, 'Events', 'NotificationEscalation'); 1437-- ---------------------------------------------------------- 1438-- insert into table notification_event_item 1439-- ---------------------------------------------------------- 1440INSERT INTO notification_event_item (notification_id, event_key, event_value) 1441 VALUES 1442 (11, 'Recipients', 'AgentMyQueues'); 1443-- ---------------------------------------------------------- 1444-- insert into table notification_event_item 1445-- ---------------------------------------------------------- 1446INSERT INTO notification_event_item (notification_id, event_key, event_value) 1447 VALUES 1448 (11, 'Recipients', 'AgentWritePermissions'); 1449-- ---------------------------------------------------------- 1450-- insert into table notification_event_item 1451-- ---------------------------------------------------------- 1452INSERT INTO notification_event_item (notification_id, event_key, event_value) 1453 VALUES 1454 (11, 'SendOnOutOfOffice', '1'); 1455-- ---------------------------------------------------------- 1456-- insert into table notification_event_item 1457-- ---------------------------------------------------------- 1458INSERT INTO notification_event_item (notification_id, event_key, event_value) 1459 VALUES 1460 (11, 'OncePerDay', '1'); 1461-- ---------------------------------------------------------- 1462-- insert into table notification_event_item 1463-- ---------------------------------------------------------- 1464INSERT INTO notification_event_item (notification_id, event_key, event_value) 1465 VALUES 1466 (11, 'Transports', 'Email'); 1467-- ---------------------------------------------------------- 1468-- insert into table notification_event 1469-- ---------------------------------------------------------- 1470INSERT INTO notification_event (name, valid_id, comments, create_by, create_time, change_by, change_time) 1471 VALUES 1472 ('Ticket escalation warning notification', 1, '', 1, current_timestamp, 1, current_timestamp); 1473-- ---------------------------------------------------------- 1474-- insert into table notification_event_item 1475-- ---------------------------------------------------------- 1476INSERT INTO notification_event_item (notification_id, event_key, event_value) 1477 VALUES 1478 (12, 'Events', 'NotificationEscalationNotifyBefore'); 1479-- ---------------------------------------------------------- 1480-- insert into table notification_event_item 1481-- ---------------------------------------------------------- 1482INSERT INTO notification_event_item (notification_id, event_key, event_value) 1483 VALUES 1484 (12, 'Recipients', 'AgentMyQueues'); 1485-- ---------------------------------------------------------- 1486-- insert into table notification_event_item 1487-- ---------------------------------------------------------- 1488INSERT INTO notification_event_item (notification_id, event_key, event_value) 1489 VALUES 1490 (12, 'Recipients', 'AgentWritePermissions'); 1491-- ---------------------------------------------------------- 1492-- insert into table notification_event_item 1493-- ---------------------------------------------------------- 1494INSERT INTO notification_event_item (notification_id, event_key, event_value) 1495 VALUES 1496 (12, 'SendOnOutOfOffice', '1'); 1497-- ---------------------------------------------------------- 1498-- insert into table notification_event_item 1499-- ---------------------------------------------------------- 1500INSERT INTO notification_event_item (notification_id, event_key, event_value) 1501 VALUES 1502 (12, 'OncePerDay', '1'); 1503-- ---------------------------------------------------------- 1504-- insert into table notification_event_item 1505-- ---------------------------------------------------------- 1506INSERT INTO notification_event_item (notification_id, event_key, event_value) 1507 VALUES 1508 (12, 'Transports', 'Email'); 1509-- ---------------------------------------------------------- 1510-- insert into table notification_event 1511-- ---------------------------------------------------------- 1512INSERT INTO notification_event (name, valid_id, comments, create_by, create_time, change_by, change_time) 1513 VALUES 1514 ('Ticket service update notification', 1, '', 1, current_timestamp, 1, current_timestamp); 1515-- ---------------------------------------------------------- 1516-- insert into table notification_event_item 1517-- ---------------------------------------------------------- 1518INSERT INTO notification_event_item (notification_id, event_key, event_value) 1519 VALUES 1520 (13, 'VisibleForAgent', '1'); 1521-- ---------------------------------------------------------- 1522-- insert into table notification_event_item 1523-- ---------------------------------------------------------- 1524INSERT INTO notification_event_item (notification_id, event_key, event_value) 1525 VALUES 1526 (13, 'VisibleForAgentTooltip', 'You will receive a notification if a ticket''s service is changed to one of your "My Services".'); 1527-- ---------------------------------------------------------- 1528-- insert into table notification_event_item 1529-- ---------------------------------------------------------- 1530INSERT INTO notification_event_item (notification_id, event_key, event_value) 1531 VALUES 1532 (13, 'Events', 'NotificationServiceUpdate'); 1533-- ---------------------------------------------------------- 1534-- insert into table notification_event_item 1535-- ---------------------------------------------------------- 1536INSERT INTO notification_event_item (notification_id, event_key, event_value) 1537 VALUES 1538 (13, 'Recipients', 'AgentMyServices'); 1539-- ---------------------------------------------------------- 1540-- insert into table notification_event_item 1541-- ---------------------------------------------------------- 1542INSERT INTO notification_event_item (notification_id, event_key, event_value) 1543 VALUES 1544 (13, 'SendOnOutOfOffice', '1'); 1545-- ---------------------------------------------------------- 1546-- insert into table notification_event_item 1547-- ---------------------------------------------------------- 1548INSERT INTO notification_event_item (notification_id, event_key, event_value) 1549 VALUES 1550 (13, 'Transports', 'Email'); 1551-- ---------------------------------------------------------- 1552-- insert into table notification_event_item 1553-- ---------------------------------------------------------- 1554INSERT INTO notification_event_item (notification_id, event_key, event_value) 1555 VALUES 1556 (13, 'AgentEnabledByDefault', 'Email'); 1557-- ---------------------------------------------------------- 1558-- insert into table notification_event 1559-- ---------------------------------------------------------- 1560INSERT INTO notification_event (name, valid_id, comments, create_by, create_time, change_by, change_time) 1561 VALUES 1562 ('Appointment reminder notification', 1, '', 1, current_timestamp, 1, current_timestamp); 1563-- ---------------------------------------------------------- 1564-- insert into table notification_event_item 1565-- ---------------------------------------------------------- 1566INSERT INTO notification_event_item (notification_id, event_key, event_value) 1567 VALUES 1568 (14, 'VisibleForAgent', '1'); 1569-- ---------------------------------------------------------- 1570-- insert into table notification_event_item 1571-- ---------------------------------------------------------- 1572INSERT INTO notification_event_item (notification_id, event_key, event_value) 1573 VALUES 1574 (14, 'VisibleForAgentTooltip', 'You will receive a notification each time a reminder time is reached for one of your appointments.'); 1575-- ---------------------------------------------------------- 1576-- insert into table notification_event_item 1577-- ---------------------------------------------------------- 1578INSERT INTO notification_event_item (notification_id, event_key, event_value) 1579 VALUES 1580 (14, 'Events', 'AppointmentNotification'); 1581-- ---------------------------------------------------------- 1582-- insert into table notification_event_item 1583-- ---------------------------------------------------------- 1584INSERT INTO notification_event_item (notification_id, event_key, event_value) 1585 VALUES 1586 (14, 'Recipients', 'AppointmentAgentReadPermissions'); 1587-- ---------------------------------------------------------- 1588-- insert into table notification_event_item 1589-- ---------------------------------------------------------- 1590INSERT INTO notification_event_item (notification_id, event_key, event_value) 1591 VALUES 1592 (14, 'SendOnOutOfOffice', '1'); 1593-- ---------------------------------------------------------- 1594-- insert into table notification_event_item 1595-- ---------------------------------------------------------- 1596INSERT INTO notification_event_item (notification_id, event_key, event_value) 1597 VALUES 1598 (14, 'Transports', 'Email'); 1599-- ---------------------------------------------------------- 1600-- insert into table notification_event_item 1601-- ---------------------------------------------------------- 1602INSERT INTO notification_event_item (notification_id, event_key, event_value) 1603 VALUES 1604 (14, 'AgentEnabledByDefault', 'Email'); 1605-- ---------------------------------------------------------- 1606-- insert into table notification_event_item 1607-- ---------------------------------------------------------- 1608INSERT INTO notification_event_item (notification_id, event_key, event_value) 1609 VALUES 1610 (14, 'NotificationType', 'Appointment'); 1611-- ---------------------------------------------------------- 1612-- insert into table notification_event 1613-- ---------------------------------------------------------- 1614INSERT INTO notification_event (name, valid_id, comments, create_by, create_time, change_by, change_time) 1615 VALUES 1616 ('Ticket email delivery failure notification', 1, '', 1, current_timestamp, 1, current_timestamp); 1617-- ---------------------------------------------------------- 1618-- insert into table notification_event_item 1619-- ---------------------------------------------------------- 1620INSERT INTO notification_event_item (notification_id, event_key, event_value) 1621 VALUES 1622 (15, 'AgentEnabledByDefault', 'Email'); 1623-- ---------------------------------------------------------- 1624-- insert into table notification_event_item 1625-- ---------------------------------------------------------- 1626INSERT INTO notification_event_item (notification_id, event_key, event_value) 1627 VALUES 1628 (15, 'ArticleAttachmentInclude', '0'); 1629-- ---------------------------------------------------------- 1630-- insert into table notification_event_item 1631-- ---------------------------------------------------------- 1632INSERT INTO notification_event_item (notification_id, event_key, event_value) 1633 VALUES 1634 (15, 'ArticleCommunicationChannelID', '1'); 1635-- ---------------------------------------------------------- 1636-- insert into table notification_event_item 1637-- ---------------------------------------------------------- 1638INSERT INTO notification_event_item (notification_id, event_key, event_value) 1639 VALUES 1640 (15, 'Events', 'ArticleEmailSendingError'); 1641-- ---------------------------------------------------------- 1642-- insert into table notification_event_item 1643-- ---------------------------------------------------------- 1644INSERT INTO notification_event_item (notification_id, event_key, event_value) 1645 VALUES 1646 (15, 'LanguageID', 'en'); 1647-- ---------------------------------------------------------- 1648-- insert into table notification_event_item 1649-- ---------------------------------------------------------- 1650INSERT INTO notification_event_item (notification_id, event_key, event_value) 1651 VALUES 1652 (15, 'RecipientGroups', '2'); 1653-- ---------------------------------------------------------- 1654-- insert into table notification_event_item 1655-- ---------------------------------------------------------- 1656INSERT INTO notification_event_item (notification_id, event_key, event_value) 1657 VALUES 1658 (15, 'Recipients', 'AgentResponsible'); 1659-- ---------------------------------------------------------- 1660-- insert into table notification_event_item 1661-- ---------------------------------------------------------- 1662INSERT INTO notification_event_item (notification_id, event_key, event_value) 1663 VALUES 1664 (15, 'Recipients', 'AgentOwner'); 1665-- ---------------------------------------------------------- 1666-- insert into table notification_event_item 1667-- ---------------------------------------------------------- 1668INSERT INTO notification_event_item (notification_id, event_key, event_value) 1669 VALUES 1670 (15, 'TransportEmailTemplate', 'Default'); 1671-- ---------------------------------------------------------- 1672-- insert into table notification_event_item 1673-- ---------------------------------------------------------- 1674INSERT INTO notification_event_item (notification_id, event_key, event_value) 1675 VALUES 1676 (15, 'Transports', 'Email'); 1677-- ---------------------------------------------------------- 1678-- insert into table notification_event_item 1679-- ---------------------------------------------------------- 1680INSERT INTO notification_event_item (notification_id, event_key, event_value) 1681 VALUES 1682 (15, 'VisibleForAgent', '0'); 1683-- ---------------------------------------------------------- 1684-- insert into table notification_event_message 1685-- ---------------------------------------------------------- 1686INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 1687 VALUES 1688 (1, 'text/plain', 'en', 'Ticket Created: <OTRS_TICKET_Title>', 'Hi <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 1689 1690ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] has been created in queue <OTRS_TICKET_Queue>. 1691 1692<OTRS_CUSTOMER_REALNAME> wrote: 1693<OTRS_CUSTOMER_BODY[30]> 1694 1695<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 1696 1697-- <OTRS_CONFIG_NotificationSenderName>'); 1698-- ---------------------------------------------------------- 1699-- insert into table notification_event_message 1700-- ---------------------------------------------------------- 1701INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 1702 VALUES 1703 (2, 'text/plain', 'en', 'Unlocked Ticket Follow-Up: <OTRS_CUSTOMER_SUBJECT[24]>', 'Hi <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 1704 1705the unlocked ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] received a follow-up. 1706 1707<OTRS_CUSTOMER_REALNAME> wrote: 1708<OTRS_CUSTOMER_BODY[30]> 1709 1710<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 1711 1712-- <OTRS_CONFIG_NotificationSenderName>'); 1713-- ---------------------------------------------------------- 1714-- insert into table notification_event_message 1715-- ---------------------------------------------------------- 1716INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 1717 VALUES 1718 (3, 'text/plain', 'en', 'Locked Ticket Follow-Up: <OTRS_CUSTOMER_SUBJECT[24]>', 'Hi <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 1719 1720the locked ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] received a follow-up. 1721 1722<OTRS_CUSTOMER_REALNAME> wrote: 1723<OTRS_CUSTOMER_BODY[30]> 1724 1725<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 1726 1727-- <OTRS_CONFIG_NotificationSenderName>'); 1728-- ---------------------------------------------------------- 1729-- insert into table notification_event_message 1730-- ---------------------------------------------------------- 1731INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 1732 VALUES 1733 (4, 'text/plain', 'en', 'Ticket Lock Timeout: <OTRS_TICKET_Title>', 'Hi <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 1734 1735ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] has reached its lock timeout period and is now unlocked. 1736 1737<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 1738 1739-- <OTRS_CONFIG_NotificationSenderName>'); 1740-- ---------------------------------------------------------- 1741-- insert into table notification_event_message 1742-- ---------------------------------------------------------- 1743INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 1744 VALUES 1745 (5, 'text/plain', 'en', 'Ticket Owner Update to <OTRS_OWNER_UserFullname>: <OTRS_TICKET_Title>', 'Hi <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 1746 1747the owner of ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] has been updated to <OTRS_TICKET_OWNER_UserFullname> by <OTRS_CURRENT_UserFullname>. 1748 1749<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 1750 1751-- <OTRS_CONFIG_NotificationSenderName>'); 1752-- ---------------------------------------------------------- 1753-- insert into table notification_event_message 1754-- ---------------------------------------------------------- 1755INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 1756 VALUES 1757 (6, 'text/plain', 'en', 'Ticket Responsible Update to <OTRS_RESPONSIBLE_UserFullname>: <OTRS_TICKET_Title>', 'Hi <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 1758 1759the responsible agent of ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] has been updated to <OTRS_TICKET_RESPONSIBLE_UserFullname> by <OTRS_CURRENT_UserFullname>. 1760 1761<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 1762 1763-- <OTRS_CONFIG_NotificationSenderName>'); 1764-- ---------------------------------------------------------- 1765-- insert into table notification_event_message 1766-- ---------------------------------------------------------- 1767INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 1768 VALUES 1769 (7, 'text/plain', 'en', 'Ticket Note: <OTRS_AGENT_SUBJECT[24]>', 'Hi <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 1770 1771<OTRS_CURRENT_UserFullname> wrote: 1772<OTRS_AGENT_BODY[30]> 1773 1774<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 1775 1776-- <OTRS_CONFIG_NotificationSenderName>'); 1777-- ---------------------------------------------------------- 1778-- insert into table notification_event_message 1779-- ---------------------------------------------------------- 1780INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 1781 VALUES 1782 (8, 'text/plain', 'en', 'Ticket Queue Update to <OTRS_TICKET_Queue>: <OTRS_TICKET_Title>', 'Hi <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 1783 1784ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] has been updated to queue <OTRS_TICKET_Queue>. 1785 1786<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 1787 1788-- <OTRS_CONFIG_NotificationSenderName>'); 1789-- ---------------------------------------------------------- 1790-- insert into table notification_event_message 1791-- ---------------------------------------------------------- 1792INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 1793 VALUES 1794 (9, 'text/plain', 'en', 'Locked Ticket Pending Reminder Time Reached: <OTRS_TICKET_Title>', 'Hi <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 1795 1796the pending reminder time of the locked ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] has been reached. 1797 1798<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 1799 1800-- <OTRS_CONFIG_NotificationSenderName>'); 1801-- ---------------------------------------------------------- 1802-- insert into table notification_event_message 1803-- ---------------------------------------------------------- 1804INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 1805 VALUES 1806 (10, 'text/plain', 'en', 'Unlocked Ticket Pending Reminder Time Reached: <OTRS_TICKET_Title>', 'Hi <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 1807 1808the pending reminder time of the unlocked ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] has been reached. 1809 1810<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 1811 1812-- <OTRS_CONFIG_NotificationSenderName>'); 1813-- ---------------------------------------------------------- 1814-- insert into table notification_event_message 1815-- ---------------------------------------------------------- 1816INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 1817 VALUES 1818 (11, 'text/plain', 'en', 'Ticket Escalation! <OTRS_TICKET_Title>', 'Hi <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 1819 1820ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] is escalated! 1821 1822Escalated at: <OTRS_TICKET_EscalationDestinationDate> 1823Escalated since: <OTRS_TICKET_EscalationDestinationIn> 1824 1825<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 1826 1827-- <OTRS_CONFIG_NotificationSenderName>'); 1828-- ---------------------------------------------------------- 1829-- insert into table notification_event_message 1830-- ---------------------------------------------------------- 1831INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 1832 VALUES 1833 (12, 'text/plain', 'en', 'Ticket Escalation Warning! <OTRS_TICKET_Title>', 'Hi <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 1834 1835ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] will escalate! 1836 1837Escalation at: <OTRS_TICKET_EscalationDestinationDate> 1838Escalation in: <OTRS_TICKET_EscalationDestinationIn> 1839 1840<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 1841 1842 1843-- <OTRS_CONFIG_NotificationSenderName>'); 1844-- ---------------------------------------------------------- 1845-- insert into table notification_event_message 1846-- ---------------------------------------------------------- 1847INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 1848 VALUES 1849 (13, 'text/plain', 'en', 'Ticket Service Update to <OTRS_TICKET_Service>: <OTRS_TICKET_Title>', 'Hi <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 1850 1851the service of ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] has been updated to <OTRS_TICKET_Service>. 1852 1853<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 1854 1855-- <OTRS_CONFIG_NotificationSenderName>'); 1856-- ---------------------------------------------------------- 1857-- insert into table notification_event_message 1858-- ---------------------------------------------------------- 1859INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 1860 VALUES 1861 (14, 'text/html', 'en', 'Reminder: <OTRS_APPOINTMENT_TITLE>', 'Hi <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>,<br /> 1862<br /> 1863appointment "<OTRS_APPOINTMENT_TITLE>" has reached its notification time.<br /> 1864<br /> 1865Description: <OTRS_APPOINTMENT_DESCRIPTION><br /> 1866Location: <OTRS_APPOINTMENT_LOCATION><br /> 1867Calendar: <span style="color: <OTRS_CALENDAR_COLOR>;">■</span> <OTRS_CALENDAR_CALENDARNAME><br /> 1868Start date: <OTRS_APPOINTMENT_STARTTIME><br /> 1869End date: <OTRS_APPOINTMENT_ENDTIME><br /> 1870All-day: <OTRS_APPOINTMENT_ALLDAY><br /> 1871Repeat: <OTRS_APPOINTMENT_RECURRING><br /> 1872<br /> 1873<a href="<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentAppointmentCalendarOverview;AppointmentID=<OTRS_APPOINTMENT_APPOINTMENTID>" title="<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentAppointmentCalendarOverview;AppointmentID=<OTRS_APPOINTMENT_APPOINTMENTID>"><OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentAppointmentCalendarOverview;AppointmentID=<OTRS_APPOINTMENT_APPOINTMENTID></a><br /> 1874<br /> 1875-- <OTRS_CONFIG_NotificationSenderName>'); 1876-- ---------------------------------------------------------- 1877-- insert into table notification_event_message 1878-- ---------------------------------------------------------- 1879INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 1880 VALUES 1881 (1, 'text/plain', 'de', 'Ticket erstellt: <OTRS_TICKET_Title>', 'Hallo <OTRS_NOTIFICATION_RECIPIENT_UserFirstname> <OTRS_NOTIFICATION_RECIPIENT_UserLastname>, 1882 1883das Ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] wurde in der Queue <OTRS_TICKET_Queue> erstellt. 1884 1885<OTRS_CUSTOMER_REALNAME> schrieb: 1886<OTRS_CUSTOMER_BODY[30]> 1887 1888<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 1889 1890-- <OTRS_CONFIG_NotificationSenderName>'); 1891-- ---------------------------------------------------------- 1892-- insert into table notification_event_message 1893-- ---------------------------------------------------------- 1894INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 1895 VALUES 1896 (2, 'text/plain', 'de', 'Nachfrage zum freigegebenen Ticket: <OTRS_CUSTOMER_SUBJECT[24]>', 'Hallo <OTRS_NOTIFICATION_RECIPIENT_UserFirstname> <OTRS_NOTIFICATION_RECIPIENT_UserLastname>, 1897 1898zum freigegebenen Ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] gibt es eine Nachfrage. 1899 1900<OTRS_CUSTOMER_REALNAME> schrieb: 1901<OTRS_CUSTOMER_BODY[30]> 1902 1903<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 1904 1905-- <OTRS_CONFIG_NotificationSenderName>'); 1906-- ---------------------------------------------------------- 1907-- insert into table notification_event_message 1908-- ---------------------------------------------------------- 1909INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 1910 VALUES 1911 (3, 'text/plain', 'de', 'Nachfrage zum gesperrten Ticket: <OTRS_CUSTOMER_SUBJECT[24]>', 'Hallo <OTRS_NOTIFICATION_RECIPIENT_UserFirstname> <OTRS_NOTIFICATION_RECIPIENT_UserLastname>, 1912 1913zum gesperrten Ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] gibt es eine Nachfrage. 1914 1915<OTRS_CUSTOMER_REALNAME> schrieb: 1916<OTRS_CUSTOMER_BODY[30]> 1917 1918<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 1919 1920-- <OTRS_CONFIG_NotificationSenderName>'); 1921-- ---------------------------------------------------------- 1922-- insert into table notification_event_message 1923-- ---------------------------------------------------------- 1924INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 1925 VALUES 1926 (4, 'text/plain', 'de', 'Ticketsperre aufgehoben: <OTRS_TICKET_Title>', 'Hallo <OTRS_NOTIFICATION_RECIPIENT_UserFirstname> <OTRS_NOTIFICATION_RECIPIENT_UserLastname>, 1927 1928die Sperrzeit des Tickets [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] ist abgelaufen. Es ist jetzt freigegeben. 1929 1930<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 1931 1932-- <OTRS_CONFIG_NotificationSenderName>'); 1933-- ---------------------------------------------------------- 1934-- insert into table notification_event_message 1935-- ---------------------------------------------------------- 1936INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 1937 VALUES 1938 (5, 'text/plain', 'de', 'Änderung des Ticket-Besitzers auf <OTRS_OWNER_UserFullname>: <OTRS_TICKET_Title>', 'Hallo <OTRS_NOTIFICATION_RECIPIENT_UserFirstname> <OTRS_NOTIFICATION_RECIPIENT_UserLastname>, 1939 1940der Besitzer des Tickets [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] wurde von <OTRS_CURRENT_UserFullname> geändert auf <OTRS_TICKET_OWNER_UserFullname>. 1941 1942<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 1943 1944-- <OTRS_CONFIG_NotificationSenderName>'); 1945-- ---------------------------------------------------------- 1946-- insert into table notification_event_message 1947-- ---------------------------------------------------------- 1948INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 1949 VALUES 1950 (6, 'text/plain', 'de', 'Änderung des Ticket-Verantwortlichen auf <OTRS_RESPONSIBLE_UserFullname>: <OTRS_TICKET_Title>', 'Hallo <OTRS_NOTIFICATION_RECIPIENT_UserFirstname> <OTRS_NOTIFICATION_RECIPIENT_UserLastname>, 1951 1952der Verantwortliche für das Ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] wurde von <OTRS_CURRENT_UserFullname> geändert auf <OTRS_TICKET_RESPONSIBLE_UserFullname>. 1953 1954<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 1955 1956-- <OTRS_CONFIG_NotificationSenderName>'); 1957-- ---------------------------------------------------------- 1958-- insert into table notification_event_message 1959-- ---------------------------------------------------------- 1960INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 1961 VALUES 1962 (7, 'text/plain', 'de', 'Ticket-Notiz: <OTRS_AGENT_SUBJECT[24]>', 'Hallo <OTRS_NOTIFICATION_RECIPIENT_UserFirstname> <OTRS_NOTIFICATION_RECIPIENT_UserLastname>, 1963 1964<OTRS_CURRENT_UserFullname> schrieb: 1965<OTRS_AGENT_BODY[30]> 1966 1967<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 1968 1969-- <OTRS_CONFIG_NotificationSenderName>'); 1970-- ---------------------------------------------------------- 1971-- insert into table notification_event_message 1972-- ---------------------------------------------------------- 1973INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 1974 VALUES 1975 (8, 'text/plain', 'de', 'Ticket-Queue geändert zu <OTRS_TICKET_Queue>: <OTRS_TICKET_Title>', 'Hallo <OTRS_NOTIFICATION_RECIPIENT_UserFirstname> <OTRS_NOTIFICATION_RECIPIENT_UserLastname>, 1976 1977das Ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] wurde in die Queue <OTRS_TICKET_Queue> verschoben. 1978 1979<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 1980 1981-- <OTRS_CONFIG_NotificationSenderName>'); 1982-- ---------------------------------------------------------- 1983-- insert into table notification_event_message 1984-- ---------------------------------------------------------- 1985INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 1986 VALUES 1987 (9, 'text/plain', 'de', 'Erinnerungszeit des gesperrten Tickets erreicht: <OTRS_TICKET_Title>', 'Hallo <OTRS_NOTIFICATION_RECIPIENT_UserFirstname> <OTRS_NOTIFICATION_RECIPIENT_UserLastname>, 1988 1989die Erinnerungszeit für das gesperrte Ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] wurde erreicht. 1990 1991<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 1992 1993-- <OTRS_CONFIG_NotificationSenderName>'); 1994-- ---------------------------------------------------------- 1995-- insert into table notification_event_message 1996-- ---------------------------------------------------------- 1997INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 1998 VALUES 1999 (10, 'text/plain', 'de', 'Erinnerungszeit des freigegebenen Tickets erreicht: <OTRS_TICKET_Title>', 'Hallo <OTRS_NOTIFICATION_RECIPIENT_UserFirstname> <OTRS_NOTIFICATION_RECIPIENT_UserLastname>, 2000 2001die Erinnerungszeit für das freigegebene Ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] wurde erreicht. 2002 2003<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2004 2005-- <OTRS_CONFIG_NotificationSenderName>'); 2006-- ---------------------------------------------------------- 2007-- insert into table notification_event_message 2008-- ---------------------------------------------------------- 2009INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2010 VALUES 2011 (11, 'text/plain', 'de', 'Ticket-Eskalation! <OTRS_TICKET_Title>', 'Hallo <OTRS_NOTIFICATION_RECIPIENT_UserFirstname> <OTRS_NOTIFICATION_RECIPIENT_UserLastname>, 2012 2013das Ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] ist eskaliert! 2014 2015Eskaliert am: <OTRS_TICKET_EscalationDestinationDate> 2016Eskaliert seit: <OTRS_TICKET_EscalationDestinationIn> 2017 2018<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2019 2020-- <OTRS_CONFIG_NotificationSenderName>'); 2021-- ---------------------------------------------------------- 2022-- insert into table notification_event_message 2023-- ---------------------------------------------------------- 2024INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2025 VALUES 2026 (12, 'text/plain', 'de', 'Ticket-Eskalations-Warnung! <OTRS_TICKET_Title>', 'Hallo <OTRS_NOTIFICATION_RECIPIENT_UserFirstname> <OTRS_NOTIFICATION_RECIPIENT_UserLastname>, 2027 2028das Ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] wird bald eskalieren! 2029 2030Eskalation um: <OTRS_TICKET_EscalationDestinationDate> 2031Eskalation in: <OTRS_TICKET_EscalationDestinationIn> 2032 2033<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2034 2035 2036-- <OTRS_CONFIG_NotificationSenderName>'); 2037-- ---------------------------------------------------------- 2038-- insert into table notification_event_message 2039-- ---------------------------------------------------------- 2040INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2041 VALUES 2042 (13, 'text/plain', 'de', 'Ticket-Service aktualisiert zu <OTRS_TICKET_Service>: <OTRS_TICKET_Title>', 'Hallo <OTRS_NOTIFICATION_RECIPIENT_UserFirstname> <OTRS_NOTIFICATION_RECIPIENT_UserLastname>, 2043 2044der Service des Tickets [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] wurde geändert zu <OTRS_TICKET_Service>. 2045 2046<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2047 2048-- <OTRS_CONFIG_NotificationSenderName>'); 2049-- ---------------------------------------------------------- 2050-- insert into table notification_event_message 2051-- ---------------------------------------------------------- 2052INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2053 VALUES 2054 (14, 'text/html', 'de', 'Erinnerung: <OTRS_APPOINTMENT_TITLE>', 'Hallo <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>,<br /> 2055<br /> 2056Termin "<OTRS_APPOINTMENT_TITLE>" hat seine Benachrichtigungszeit erreicht.<br /> 2057<br /> 2058Beschreibung: <OTRS_APPOINTMENT_DESCRIPTION><br /> 2059Standort: <OTRS_APPOINTMENT_LOCATION><br /> 2060Kalender: <span style="color: <OTRS_CALENDAR_COLOR>;">■</span> <OTRS_CALENDAR_CALENDARNAME><br /> 2061Startzeitpunkt: <OTRS_APPOINTMENT_STARTTIME><br /> 2062Endzeitpunkt: <OTRS_APPOINTMENT_ENDTIME><br /> 2063Ganztägig: <OTRS_APPOINTMENT_ALLDAY><br /> 2064Wiederholung: <OTRS_APPOINTMENT_RECURRING><br /> 2065<br /> 2066<a href="<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentAppointmentCalendarOverview;AppointmentID=<OTRS_APPOINTMENT_APPOINTMENTID>" title="<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentAppointmentCalendarOverview;AppointmentID=<OTRS_APPOINTMENT_APPOINTMENTID>"><OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentAppointmentCalendarOverview;AppointmentID=<OTRS_APPOINTMENT_APPOINTMENTID></a><br /> 2067<br /> 2068-- <OTRS_CONFIG_NotificationSenderName>'); 2069-- ---------------------------------------------------------- 2070-- insert into table notification_event_message 2071-- ---------------------------------------------------------- 2072INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2073 VALUES 2074 (1, 'text/plain', 'es_MX', 'Se ha creado un ticket: <OTRS_TICKET_Title>', 'Hola <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2075 2076el ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] se ha creado en la fila <OTRS_TICKET_Queue>. 2077 2078<OTRS_CUSTOMER_REALNAME> escribió: 2079<OTRS_CUSTOMER_BODY[30]> 2080 2081<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2082 2083-- <OTRS_CONFIG_NotificationSenderName>'); 2084-- ---------------------------------------------------------- 2085-- insert into table notification_event_message 2086-- ---------------------------------------------------------- 2087INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2088 VALUES 2089 (2, 'text/plain', 'es_MX', 'Seguimiento a ticket desbloqueado: <OTRS_CUSTOMER_SUBJECT[24]>', 'Hola <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2090 2091el ticket desbloqueado [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] recibió un seguimiento. 2092 2093<OTRS_CUSTOMER_REALNAME> escribió: 2094<OTRS_CUSTOMER_BODY[30]> 2095 2096<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2097 2098-- <OTRS_CONFIG_NotificationSenderName>'); 2099-- ---------------------------------------------------------- 2100-- insert into table notification_event_message 2101-- ---------------------------------------------------------- 2102INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2103 VALUES 2104 (3, 'text/plain', 'es_MX', 'Seguimiento a ticket bloqueado: <OTRS_CUSTOMER_SUBJECT[24]>', 'Hola <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2105 2106el ticket bloqueado [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] recibió un seguimiento. 2107 2108<OTRS_CUSTOMER_REALNAME> escribió: 2109<OTRS_CUSTOMER_BODY[30]> 2110 2111<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2112 2113-- <OTRS_CONFIG_NotificationSenderName>'); 2114-- ---------------------------------------------------------- 2115-- insert into table notification_event_message 2116-- ---------------------------------------------------------- 2117INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2118 VALUES 2119 (4, 'text/plain', 'es_MX', 'Terminó tiempo de bloqueo: <OTRS_TICKET_Title>', 'Hola <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2120 2121el ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] ha alcanzado su tiempo de espera como bloqueado y ahora se encuentra desbloqueado. 2122 2123<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2124 2125-- <OTRS_CONFIG_NotificationSenderName>'); 2126-- ---------------------------------------------------------- 2127-- insert into table notification_event_message 2128-- ---------------------------------------------------------- 2129INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2130 VALUES 2131 (5, 'text/plain', 'es_MX', 'Actualización del propietario de ticket a <OTRS_OWNER_UserFullname>: <OTRS_TICKET_Title>', 'Hola <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2132 2133el propietario del ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] se ha modificado a <OTRS_TICKET_OWNER_UserFullname> por <OTRS_CURRENT_UserFullname>. 2134 2135<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2136 2137-- <OTRS_CONFIG_NotificationSenderName>'); 2138-- ---------------------------------------------------------- 2139-- insert into table notification_event_message 2140-- ---------------------------------------------------------- 2141INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2142 VALUES 2143 (6, 'text/plain', 'es_MX', 'Actualización del responsable de ticket a <OTRS_RESPONSIBLE_UserFullname>: <OTRS_TICKET_Title>', 'Hola <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2144 2145el agente responsable del ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] se ha modificado a <OTRS_TICKET_RESPONSIBLE_UserFullname> por <OTRS_CURRENT_UserFullname>. 2146 2147<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2148 2149-- <OTRS_CONFIG_NotificationSenderName>'); 2150-- ---------------------------------------------------------- 2151-- insert into table notification_event_message 2152-- ---------------------------------------------------------- 2153INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2154 VALUES 2155 (7, 'text/plain', 'es_MX', 'Nota de ticket: <OTRS_AGENT_SUBJECT[24]>', 'Hola <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2156 2157<OTRS_CURRENT_UserFullname> escribió: 2158<OTRS_AGENT_BODY[30]> 2159 2160<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2161 2162-- <OTRS_CONFIG_NotificationSenderName>'); 2163-- ---------------------------------------------------------- 2164-- insert into table notification_event_message 2165-- ---------------------------------------------------------- 2166INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2167 VALUES 2168 (8, 'text/plain', 'es_MX', 'La fila del ticket ha cambiado a <OTRS_TICKET_Queue>: <OTRS_TICKET_Title>', 'Hola <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2169 2170el ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] ha cambiado de fila a <OTRS_TICKET_Queue>. 2171 2172<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2173 2174-- <OTRS_CONFIG_NotificationSenderName>'); 2175-- ---------------------------------------------------------- 2176-- insert into table notification_event_message 2177-- ---------------------------------------------------------- 2178INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2179 VALUES 2180 (9, 'text/plain', 'es_MX', 'Recordatorio pendiente en ticket bloqueado se ha alcanzado: <OTRS_TICKET_Title>', 'Hola <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2181 2182el tiempo del recordatorio pendiente para el ticket bloqueado [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] se ha alcanzado. 2183 2184<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2185 2186-- <OTRS_CONFIG_NotificationSenderName>'); 2187-- ---------------------------------------------------------- 2188-- insert into table notification_event_message 2189-- ---------------------------------------------------------- 2190INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2191 VALUES 2192 (10, 'text/plain', 'es_MX', 'Recordatorio pendiente en ticket desbloqueado se ha alcanzado: <OTRS_TICKET_Title>', 'Hola <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2193 2194el tiempo del recordatorio pendiente para el ticket desbloqueado [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] se ha alcanzado. 2195 2196<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2197 2198-- <OTRS_CONFIG_NotificationSenderName>'); 2199-- ---------------------------------------------------------- 2200-- insert into table notification_event_message 2201-- ---------------------------------------------------------- 2202INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2203 VALUES 2204 (11, 'text/plain', 'es_MX', '¡Escalación de ticket! <OTRS_TICKET_Title>', 'Hola <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2205 2206el ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] se ha escalado! 2207 2208Escaló: <OTRS_TICKET_EscalationDestinationDate> 2209Escalado desde: <OTRS_TICKET_EscalationDestinationIn> 2210 2211<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2212 2213-- <OTRS_CONFIG_NotificationSenderName>'); 2214-- ---------------------------------------------------------- 2215-- insert into table notification_event_message 2216-- ---------------------------------------------------------- 2217INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2218 VALUES 2219 (12, 'text/plain', 'es_MX', 'Aviso de escalación de ticket! <OTRS_TICKET_Title>', 'Hola <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2220 2221el ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] se encuentra proximo a escalar! 2222 2223Escalará: <OTRS_TICKET_EscalationDestinationDate> 2224Escalará en: <OTRS_TICKET_EscalationDestinationIn> 2225 2226<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2227 2228 2229-- <OTRS_CONFIG_NotificationSenderName>'); 2230-- ---------------------------------------------------------- 2231-- insert into table notification_event_message 2232-- ---------------------------------------------------------- 2233INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2234 VALUES 2235 (13, 'text/plain', 'es_MX', 'El servicio del ticket ha cambiado a <OTRS_TICKET_Service>: <OTRS_TICKET_Title>', 'Hola <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2236 2237el servicio del ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] se ha cambiado a <OTRS_TICKET_Service>. 2238 2239<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2240 2241-- <OTRS_CONFIG_NotificationSenderName>'); 2242-- ---------------------------------------------------------- 2243-- insert into table notification_event_message 2244-- ---------------------------------------------------------- 2245INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2246 VALUES 2247 (1, 'text/plain', 'zh_CN', '票据编制 工单已创建:<OTRS_TICKET_Title>', '您好 <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2248 2249票据工单 [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] 已在等待队列 已在队列<OTRS_TICKET_Queue> 中被编制完成。中被创建完成 2250 2251<OTRS_CUSTOMER_REALNAME> 写道: 2252<OTRS_CUSTOMER_BODY[30]> 2253 2254<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2255 2256-- <OTRS_CONFIG_NotificationSenderName>'); 2257-- ---------------------------------------------------------- 2258-- insert into table notification_event_message 2259-- ---------------------------------------------------------- 2260INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2261 VALUES 2262 (2, 'text/plain', 'zh_CN', '解锁票据的后续作业解锁工单的后续: <OTRS_CUSTOMER_SUBJECT[24]>', '您好<OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2263 2264解锁票据解锁工单[<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] 已获得一项后续作业。 2265 2266<OTRS_CUSTOMER_REALNAME> 写道: 2267<OTRS_CUSTOMER_BODY[30]> 2268 2269<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2270 2271-- <OTRS_CONFIG_NotificationSenderName>'); 2272-- ---------------------------------------------------------- 2273-- insert into table notification_event_message 2274-- ---------------------------------------------------------- 2275INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2276 VALUES 2277 (3, 'text/plain', 'zh_CN', '加锁票据的后续作业 锁定工单后续:<OTRS_CUSTOMER_SUBJECT[24]>', '您好 <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2278 2279加锁票据锁定工单 [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] 已获得一项后续作业。 2280 2281<OTRS_CUSTOMER_REALNAME> 写道: 2282<OTRS_CUSTOMER_BODY[30]> 2283 2284<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2285 2286-- <OTRS_CONFIG_NotificationSenderName>'); 2287-- ---------------------------------------------------------- 2288-- insert into table notification_event_message 2289-- ---------------------------------------------------------- 2290INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2291 VALUES 2292 (4, 'text/plain', 'zh_CN', '票据加锁超时工单锁定超时:<OTRS_TICKET_Title>', '您好 <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2293 2294票据工单 [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] 已达到其锁定时限,现在解锁。 2295 2296<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2297 2298-- <OTRS_CONFIG_NotificationSenderName>'); 2299-- ---------------------------------------------------------- 2300-- insert into table notification_event_message 2301-- ---------------------------------------------------------- 2302INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2303 VALUES 2304 (5, 'text/plain', 'zh_CN', '票据的拥有人升级为工单所有者更新为 <OTRS_OWNER_UserFullname>: <OTRS_TICKET_Title>', '您好 <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2305 2306票据的所有人工单的所有者 [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] 已被该信为 <OTRS_TICKET_OWNER_UserFullname> 的 <OTRS_CURRENT_UserFullname>。 2307 2308<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2309 2310-- <OTRS_CONFIG_NotificationSenderName>'); 2311-- ---------------------------------------------------------- 2312-- insert into table notification_event_message 2313-- ---------------------------------------------------------- 2314INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2315 VALUES 2316 (6, 'text/plain', 'zh_CN', '票据的负责人 工单负责人更新为<OTRS_RESPONSIBLE_UserFullname>: <OTRS_TICKET_Title>', '您好 <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2317 2318工单的负责人 [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] 已被升级为 已被更新为 <OTRS_TICKET_RESPONSIBLE_UserFullname> 的 <OTRS_CURRENT_UserFullname>. 2319 2320<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2321 2322-- <OTRS_CONFIG_NotificationSenderName>'); 2323-- ---------------------------------------------------------- 2324-- insert into table notification_event_message 2325-- ---------------------------------------------------------- 2326INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2327 VALUES 2328 (7, 'text/plain', 'zh_CN', '票据备注工单备注:<OTRS_AGENT_SUBJECT[24]>', '您好 <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2329 2330<OTRS_CURRENT_UserFullname> 写道: 2331<OTRS_AGENT_BODY[30]> 2332 2333<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2334 2335-- <OTRS_CONFIG_NotificationSenderName>'); 2336-- ---------------------------------------------------------- 2337-- insert into table notification_event_message 2338-- ---------------------------------------------------------- 2339INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2340 VALUES 2341 (8, 'text/plain', 'zh_CN', '票据序列已升级为工单队列更新为<OTRS_TICKET_Queue>: <OTRS_TICKET_Title>', '您好 <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2342 2343票据工单 [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] 已被升级为序列已被更新为队列 <OTRS_TICKET_Queue>。 2344 2345<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2346 2347-- <OTRS_CONFIG_NotificationSenderName>'); 2348-- ---------------------------------------------------------- 2349-- insert into table notification_event_message 2350-- ---------------------------------------------------------- 2351INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2352 VALUES 2353 (9, 'text/plain', 'zh_CN', '已达到锁定票据即将到期的提醒时间已到达锁定工单挂起提醒时间:<OTRS_TICKET_Title>', '您好 <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2354 2355锁定票据即将到期的提醒时间锁定工单挂起提醒时间 [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] 已到达。 2356 2357<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2358 2359-- <OTRS_CONFIG_NotificationSenderName>'); 2360-- ---------------------------------------------------------- 2361-- insert into table notification_event_message 2362-- ---------------------------------------------------------- 2363INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2364 VALUES 2365 (10, 'text/plain', 'zh_CN', '未锁定票据即将到期的提醒时间已到已到未锁定工单的挂起提醒时间:<OTRS_TICKET_Title>', '您好 <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2366 2367未锁定票据即将到期的提醒时间未锁定工单的挂起提醒时间 [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] 已到已到达。 2368 2369<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2370 2371-- <OTRS_CONFIG_NotificationSenderName>'); 2372-- ---------------------------------------------------------- 2373-- insert into table notification_event_message 2374-- ---------------------------------------------------------- 2375INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2376 VALUES 2377 (11, 'text/plain', 'zh_CN', '票据升级!工单升级!<OTRS_TICKET_Title>', '您好 <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2378 2379票据工单 [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] 已被升级! 2380 2381升级地点升级开始时间:<OTRS_TICKET_EscalationDestinationDate> 2382升级开始时间升级在:<OTRS_TICKET_EscalationDestinationIn>内 2383 2384<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2385 2386-- <OTRS_CONFIG_NotificationSenderName>'); 2387-- ---------------------------------------------------------- 2388-- insert into table notification_event_message 2389-- ---------------------------------------------------------- 2390INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2391 VALUES 2392 (12, 'text/plain', 'zh_CN', '工单升级警告Ticket Escalation Warning! <OTRS_TICKET_Title>', '您好 <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2393 2394票据工单 [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] 将升级! 2395 2396升级地点升级开始时间:<OTRS_TICKET_EscalationDestinationDate> 2397升级开始时间升级在:<OTRS_TICKET_EscalationDestinationIn>内 2398 2399<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2400 2401 2402-- <OTRS_CONFIG_NotificationSenderName>'); 2403-- ---------------------------------------------------------- 2404-- insert into table notification_event_message 2405-- ---------------------------------------------------------- 2406INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2407 VALUES 2408 (13, 'text/plain', 'zh_CN', '票据服务升级为工单服务更新为<OTRS_TICKET_Service>: <OTRS_TICKET_Title>', '您好 <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2409 2410票据服务工单服务 [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] 已被升级为已被更新为 <OTRS_TICKET_Service>。 2411 2412<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2413 2414-- <OTRS_CONFIG_NotificationSenderName>'); 2415-- ---------------------------------------------------------- 2416-- insert into table notification_event_message 2417-- ---------------------------------------------------------- 2418INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2419 VALUES 2420 (1, 'text/plain', 'pt_BR', 'Ticket criado: <OTRS_TICKET_Title>', 'Oi <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2421 2422o ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] foi criado na fila <OTRS_TICKET_Queue>. 2423 2424<OTRS_CUSTOMER_REALNAME> escreveu: 2425<OTRS_CUSTOMER_BODY[30]> 2426 2427<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2428 2429-- <OTRS_CONFIG_NotificationSenderName>'); 2430-- ---------------------------------------------------------- 2431-- insert into table notification_event_message 2432-- ---------------------------------------------------------- 2433INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2434 VALUES 2435 (2, 'text/plain', 'pt_BR', 'Acompanhamento do ticket desbloqueado: <OTRS_CUSTOMER_SUBJECT[24]>', 'Oi <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2436 2437o ticket desbloqueado [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] recebeu uma resposta. 2438 2439<OTRS_CUSTOMER_REALNAME> escreveu: 2440<OTRS_CUSTOMER_BODY[30]> 2441 2442<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2443 2444-- <OTRS_CONFIG_NotificationSenderName>'); 2445-- ---------------------------------------------------------- 2446-- insert into table notification_event_message 2447-- ---------------------------------------------------------- 2448INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2449 VALUES 2450 (3, 'text/plain', 'pt_BR', 'Acompanhamento do ticket bloqueado: <OTRS_CUSTOMER_SUBJECT[24]>', 'Oi <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2451 2452o ticket bloqueado [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] recebeu uma resposta. 2453 2454<OTRS_CUSTOMER_REALNAME> escreveu: 2455<OTRS_CUSTOMER_BODY[30]> 2456 2457<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2458 2459-- <OTRS_CONFIG_NotificationSenderName>'); 2460-- ---------------------------------------------------------- 2461-- insert into table notification_event_message 2462-- ---------------------------------------------------------- 2463INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2464 VALUES 2465 (4, 'text/plain', 'pt_BR', 'Tempo limite de bloqueio do ticket: <OTRS_TICKET_Title>', 'Oi <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2466 2467o ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] atingiu o seu período de tempo limite de bloqueio e agora está desbloqueado. 2468 2469<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2470 2471-- <OTRS_CONFIG_NotificationSenderName>'); 2472-- ---------------------------------------------------------- 2473-- insert into table notification_event_message 2474-- ---------------------------------------------------------- 2475INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2476 VALUES 2477 (5, 'text/plain', 'pt_BR', 'Atualização de proprietário de ticket para <OTRS_OWNER_UserFullname>: <OTRS_TICKET_Title>', 'Oi <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2478 2479o proprietário do ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] foi atualizado para <OTRS_TICKET_OWNER_UserFullname> por <OTRS_CURRENT_UserFullname>. 2480 2481<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2482 2483-- <OTRS_CONFIG_NotificationSenderName>'); 2484-- ---------------------------------------------------------- 2485-- insert into table notification_event_message 2486-- ---------------------------------------------------------- 2487INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2488 VALUES 2489 (6, 'text/plain', 'pt_BR', 'Atualização de responsável de ticket para <OTRS_RESPONSIBLE_UserFullname>: <OTRS_TICKET_Title>', 'Oi <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2490 2491o agente responsável do ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] foi atualizado para <OTRS_TICKET_RESPONSIBLE_UserFullname> por <OTRS_CURRENT_UserFullname>. 2492 2493<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2494 2495-- <OTRS_CONFIG_NotificationSenderName>'); 2496-- ---------------------------------------------------------- 2497-- insert into table notification_event_message 2498-- ---------------------------------------------------------- 2499INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2500 VALUES 2501 (7, 'text/plain', 'pt_BR', 'Observação sobre o ticket: <OTRS_AGENT_SUBJECT[24]>', 'Oi <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2502 2503<OTRS_CURRENT_UserFullname> escreveu: 2504<OTRS_AGENT_BODY[30]> 2505 2506<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2507 2508-- <OTRS_CONFIG_NotificationSenderName>'); 2509-- ---------------------------------------------------------- 2510-- insert into table notification_event_message 2511-- ---------------------------------------------------------- 2512INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2513 VALUES 2514 (8, 'text/plain', 'pt_BR', 'Atualização da fila do ticket para <OTRS_TICKET_Queue>: <OTRS_TICKET_Title>', 'Oi <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2515 2516o ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] foi atualizado na fila <OTRS_TICKET_Queue>. 2517 2518<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2519 2520-- <OTRS_CONFIG_NotificationSenderName>'); 2521-- ---------------------------------------------------------- 2522-- insert into table notification_event_message 2523-- ---------------------------------------------------------- 2524INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2525 VALUES 2526 (9, 'text/plain', 'pt_BR', 'Tempo de Lembrete de Pendência do Ticket Bloqueado Atingido: <OTRS_TICKET_Title>', 'Oi <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2527 2528o tempo de lembrete pendente do ticket bloqueado [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] foi atingido. 2529 2530<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2531 2532-- <OTRS_CONFIG_NotificationSenderName>'); 2533-- ---------------------------------------------------------- 2534-- insert into table notification_event_message 2535-- ---------------------------------------------------------- 2536INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2537 VALUES 2538 (10, 'text/plain', 'pt_BR', 'Tempo de Lembrete Pendente do Ticket Desbloqueado Atingido: <OTRS_TICKET_Title>', 'Oi <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2539 2540o tempo de lembrete pendente do ticket desbloqueado [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] foi atingido. 2541 2542<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2543 2544-- <OTRS_CONFIG_NotificationSenderName>'); 2545-- ---------------------------------------------------------- 2546-- insert into table notification_event_message 2547-- ---------------------------------------------------------- 2548INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2549 VALUES 2550 (11, 'text/plain', 'pt_BR', 'Escalonamento do ticket! <OTRS_TICKET_Title>', 'Oi <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2551 2552o ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] foi escalonado! 2553 2554Escalonado em: <OTRS_TICKET_EscalationDestinationDate> 2555Escalonado desde: <OTRS_TICKET_EscalationDestinationIn> 2556 2557<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2558 2559-- <OTRS_CONFIG_NotificationSenderName>'); 2560-- ---------------------------------------------------------- 2561-- insert into table notification_event_message 2562-- ---------------------------------------------------------- 2563INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2564 VALUES 2565 (12, 'text/plain', 'pt_BR', 'Aviso de escalonamento do ticket! <OTRS_TICKET_Title>', 'Oi <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2566 2567o ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] será escalonado! 2568 2569Escalonamento em: <OTRS_TICKET_EscalationDestinationDate> 2570Escalonamento em: <OTRS_TICKET_EscalationDestinationIn> 2571 2572<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2573 2574 2575-- <OTRS_CONFIG_NotificationSenderName>'); 2576-- ---------------------------------------------------------- 2577-- insert into table notification_event_message 2578-- ---------------------------------------------------------- 2579INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2580 VALUES 2581 (13, 'text/plain', 'pt_BR', 'Atualização do serviço do ticket para <OTRS_TICKET_Service>: <OTRS_TICKET_Title>', 'Oi <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2582 2583o serviço do ticket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] foi atualizado para <OTRS_TICKET_Service>. 2584 2585<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2586 2587-- <OTRS_CONFIG_NotificationSenderName>'); 2588-- ---------------------------------------------------------- 2589-- insert into table notification_event_message 2590-- ---------------------------------------------------------- 2591INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2592 VALUES 2593 (1, 'text/plain', 'hu', 'Jegy létrehozva: <OTRS_TICKET_Title>', 'Kedves <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>! 2594 2595A(z) [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] jegy létrejött a következő várólistában: <OTRS_TICKET_Queue>. 2596 2597<OTRS_CUSTOMER_REALNAME> ezt írta: 2598<OTRS_CUSTOMER_BODY[30]> 2599 2600<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2601 2602-- <OTRS_CONFIG_NotificationSenderName>'); 2603-- ---------------------------------------------------------- 2604-- insert into table notification_event_message 2605-- ---------------------------------------------------------- 2606INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2607 VALUES 2608 (2, 'text/plain', 'hu', 'Feloldott jegy követése: <OTRS_CUSTOMER_SUBJECT[24]>', 'Kedves <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>! 2609 2610A feloldott [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] jegy egy követő üzenetet kapott. 2611 2612<OTRS_CUSTOMER_REALNAME> ezt írta: 2613<OTRS_CUSTOMER_BODY[30]> 2614 2615<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2616 2617-- <OTRS_CONFIG_NotificationSenderName>'); 2618-- ---------------------------------------------------------- 2619-- insert into table notification_event_message 2620-- ---------------------------------------------------------- 2621INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2622 VALUES 2623 (3, 'text/plain', 'hu', 'Zárolt jegy követése: <OTRS_CUSTOMER_SUBJECT[24]>', 'Kedves <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>! 2624 2625A zárolt [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] jegy egy követő üzenetet kapott. 2626 2627<OTRS_CUSTOMER_REALNAME> ezt írta: 2628<OTRS_CUSTOMER_BODY[30]> 2629 2630<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2631 2632-- <OTRS_CONFIG_NotificationSenderName>'); 2633-- ---------------------------------------------------------- 2634-- insert into table notification_event_message 2635-- ---------------------------------------------------------- 2636INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2637 VALUES 2638 (4, 'text/plain', 'hu', 'Jegyzár időkorlát: <OTRS_TICKET_Title>', 'Kedves <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>! 2639 2640A(z) [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] jegy elérte a zárolás időkorlátjának időtartamát, és most feloldásra került. 2641 2642<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2643 2644-- <OTRS_CONFIG_NotificationSenderName>'); 2645-- ---------------------------------------------------------- 2646-- insert into table notification_event_message 2647-- ---------------------------------------------------------- 2648INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2649 VALUES 2650 (5, 'text/plain', 'hu', 'Jegytulajdonos frissítés <OTRS_OWNER_UserLastname> <OTRS_OWNER_UserFirstname> ügyintézőre: <OTRS_TICKET_Title>', 'Kedves <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>! 2651 2652A(z) [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] jegy tulajdonosát <OTRS_CURRENT_UserLastname> <OTRS_CURRENT_UserFirstname> frissítette <OTRS_OWNER_UserLastname> <OTRS_OWNER_UserFirstname> ügyintézőre. 2653 2654<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2655 2656-- <OTRS_CONFIG_NotificationSenderName>'); 2657-- ---------------------------------------------------------- 2658-- insert into table notification_event_message 2659-- ---------------------------------------------------------- 2660INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2661 VALUES 2662 (6, 'text/plain', 'hu', 'Jegyfelelős frissítés <OTRS_RESPONSIBLE_UserLastname> <OTRS_RESPONSIBLE_UserFirstname> ügyintézőre: <OTRS_TICKET_Title>', 'Kedves <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>! 2663 2664A(z) [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] jegy felelős ügyintézőjét <OTRS_CURRENT_UserLastname> <OTRS_CURRENT_UserFirstname> frissítette <OTRS_RESPONSIBLE_UserLastname> <OTRS_RESPONSIBLE_UserFirstname> ügyintézőre. 2665 2666<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2667 2668-- <OTRS_CONFIG_NotificationSenderName>'); 2669-- ---------------------------------------------------------- 2670-- insert into table notification_event_message 2671-- ---------------------------------------------------------- 2672INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2673 VALUES 2674 (7, 'text/plain', 'hu', 'Új jegyzet: <OTRS_AGENT_SUBJECT[24]>', 'Kedves <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>! 2675 2676<OTRS_CURRENT_UserLastname> <OTRS_CURRENT_UserFirstname> ezt írta: 2677<OTRS_AGENT_BODY[30]> 2678 2679<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2680 2681-- <OTRS_CONFIG_NotificationSenderName>'); 2682-- ---------------------------------------------------------- 2683-- insert into table notification_event_message 2684-- ---------------------------------------------------------- 2685INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2686 VALUES 2687 (8, 'text/plain', 'hu', 'Jegy várólista frissítés <OTRS_TICKET_Queue> várólistára: <OTRS_TICKET_Title>', 'Kedves <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>! 2688 2689A(z) [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] jegyet áthelyezték a következő várólistába: <OTRS_TICKET_Queue>. 2690 2691<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2692 2693-- <OTRS_CONFIG_NotificationSenderName>'); 2694-- ---------------------------------------------------------- 2695-- insert into table notification_event_message 2696-- ---------------------------------------------------------- 2697INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2698 VALUES 2699 (9, 'text/plain', 'hu', 'Zárolt jegy „emlékeztető függőben” ideje elérve: <OTRS_TICKET_Title>', 'Kedves <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>! 2700 2701A zárolt [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] jegy elérte az „emlékeztető függőben” idejét. 2702 2703<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2704 2705-- <OTRS_CONFIG_NotificationSenderName>'); 2706-- ---------------------------------------------------------- 2707-- insert into table notification_event_message 2708-- ---------------------------------------------------------- 2709INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2710 VALUES 2711 (10, 'text/plain', 'hu', 'Feloldott jegy „emlékeztető függőben” ideje elérve: <OTRS_TICKET_Title>', 'Kedves <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>! 2712 2713A feloldott [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] jegy elérte az „emlékeztető függőben” idejét. 2714 2715<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2716 2717-- <OTRS_CONFIG_NotificationSenderName>'); 2718-- ---------------------------------------------------------- 2719-- insert into table notification_event_message 2720-- ---------------------------------------------------------- 2721INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2722 VALUES 2723 (11, 'text/plain', 'hu', 'Jegyeszkaláció! <OTRS_TICKET_Title>', 'Kedves <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>! 2724 2725A(z) [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] jegy eszkalálódott! 2726 2727Eszkaláció időpontja: <OTRS_TICKET_EscalationDestinationDate> 2728Eszkaláció óta eltelt idő: <OTRS_TICKET_EscalationDestinationIn> 2729 2730<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2731 2732-- <OTRS_CONFIG_NotificationSenderName>'); 2733-- ---------------------------------------------------------- 2734-- insert into table notification_event_message 2735-- ---------------------------------------------------------- 2736INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2737 VALUES 2738 (12, 'text/plain', 'hu', 'Jegyeszkaláció figyelmeztetés! <OTRS_TICKET_Title>', 'Kedves <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>! 2739 2740A(z) [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] jegy eszkalálódni fog! 2741 2742Eszkaláció időpontja: <OTRS_TICKET_EscalationDestinationDate> 2743Eszkalációig fennmaradó idő: <OTRS_TICKET_EscalationDestinationIn> 2744 2745<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2746 2747 2748-- <OTRS_CONFIG_NotificationSenderName>'); 2749-- ---------------------------------------------------------- 2750-- insert into table notification_event_message 2751-- ---------------------------------------------------------- 2752INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2753 VALUES 2754 (13, 'text/plain', 'hu', 'Jegyszolgáltatás frissítve <OTRS_TICKET_Service> szolgáltatásra: <OTRS_TICKET_Title>', 'Kedves <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>! 2755 2756A(z) [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] jegy szolgáltatása frissítve lett a következőre: <OTRS_TICKET_Service>. 2757 2758<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2759 2760-- <OTRS_CONFIG_NotificationSenderName>'); 2761-- ---------------------------------------------------------- 2762-- insert into table notification_event_message 2763-- ---------------------------------------------------------- 2764INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2765 VALUES 2766 (14, 'text/html', 'hu', 'Emlékeztető: <OTRS_APPOINTMENT_TITLE>', 'Kedves <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>!<br /> 2767<br /> 2768A következő esemény elérte az értesítési idejét: <OTRS_APPOINTMENT_TITLE><br /> 2769<br /> 2770Leírás: <OTRS_APPOINTMENT_DESCRIPTION><br /> 2771Hely: <OTRS_APPOINTMENT_LOCATION><br /> 2772Naptár: <span style="color: <OTRS_CALENDAR_COLOR>;">■</span> <OTRS_CALENDAR_CALENDARNAME><br /> 2773Kezdési dátum: <OTRS_APPOINTMENT_STARTTIME><br /> 2774Befejezési dátum: <OTRS_APPOINTMENT_ENDTIME><br /> 2775Egész napos: <OTRS_APPOINTMENT_ALLDAY><br /> 2776Ismétlődés: <OTRS_APPOINTMENT_RECURRING><br /> 2777<br /> 2778<a href="<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentAppointmentCalendarOverview;AppointmentID=<OTRS_APPOINTMENT_APPOINTMENTID>" title="<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentAppointmentCalendarOverview;AppointmentID=<OTRS_APPOINTMENT_APPOINTMENTID>"><OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentAppointmentCalendarOverview;AppointmentID=<OTRS_APPOINTMENT_APPOINTMENTID></a><br /> 2779<br /> 2780-- <OTRS_CONFIG_NotificationSenderName>'); 2781-- ---------------------------------------------------------- 2782-- insert into table notification_event_message 2783-- ---------------------------------------------------------- 2784INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2785 VALUES 2786 (1, 'text/plain', 'sr_Cyrl', 'Oтворен тикет: <OTRS_TICKET_Title>', 'Здраво <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2787 2788тикет [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] је отворен у реду <OTRS_TICKET_Queue>. 2789 2790<OTRS_CUSTOMER_REALNAME> је написао/ла: 2791<OTRS_CUSTOMER_BODY[30]> 2792 2793<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2794 2795-- <OTRS_CONFIG_NotificationSenderName>'); 2796-- ---------------------------------------------------------- 2797-- insert into table notification_event_message 2798-- ---------------------------------------------------------- 2799INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2800 VALUES 2801 (2, 'text/plain', 'sr_Cyrl', 'Наставак откључаног тикета: <OTRS_CUSTOMER_SUBJECT[24]>', 'Здраво <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2802 2803откључани тикет [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] је примио наставак. 2804 2805<OTRS_CUSTOMER_REALNAME> је написао/ла: 2806<OTRS_CUSTOMER_BODY[30]> 2807 2808<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2809 2810-- <OTRS_CONFIG_NotificationSenderName>'); 2811-- ---------------------------------------------------------- 2812-- insert into table notification_event_message 2813-- ---------------------------------------------------------- 2814INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2815 VALUES 2816 (3, 'text/plain', 'sr_Cyrl', 'Наставак закључаног тикета: <OTRS_CUSTOMER_SUBJECT[24]>', 'Здраво <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2817 2818закључани тикет [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] је примио наставак. 2819 2820<OTRS_CUSTOMER_REALNAME> је написао/ла: 2821<OTRS_CUSTOMER_BODY[30]> 2822 2823<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2824 2825-- <OTRS_CONFIG_NotificationSenderName>'); 2826-- ---------------------------------------------------------- 2827-- insert into table notification_event_message 2828-- ---------------------------------------------------------- 2829INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2830 VALUES 2831 (4, 'text/plain', 'sr_Cyrl', 'Истек закључаног тикета: <OTRS_TICKET_Title>', 'Здраво <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2832 2833тикет [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] је достигао време откључавања. 2834 2835<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2836 2837-- <OTRS_CONFIG_NotificationSenderName>'); 2838-- ---------------------------------------------------------- 2839-- insert into table notification_event_message 2840-- ---------------------------------------------------------- 2841INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2842 VALUES 2843 (5, 'text/plain', 'sr_Cyrl', 'Промена власника тикета на <OTRS_OWNER_UserFullname>: <OTRS_TICKET_Title>', 'Здраво <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2844 2845власник тикета [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] је промењен на <OTRS_TICKET_OWNER_UserFullname> од стране <OTRS_CURRENT_UserFullname>. 2846 2847<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2848 2849-- <OTRS_CONFIG_NotificationSenderName>'); 2850-- ---------------------------------------------------------- 2851-- insert into table notification_event_message 2852-- ---------------------------------------------------------- 2853INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2854 VALUES 2855 (6, 'text/plain', 'sr_Cyrl', 'Промена одговорног за тикет на <OTRS_RESPONSIBLE_UserFullname>: <OTRS_TICKET_Title>', 'Здраво <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2856 2857одговорни оператер тикета [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] је промењен на <OTRS_TICKET_RESPONSIBLE_UserFullname> од стране <OTRS_CURRENT_UserFullname>. 2858 2859<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2860 2861-- <OTRS_CONFIG_NotificationSenderName>'); 2862-- ---------------------------------------------------------- 2863-- insert into table notification_event_message 2864-- ---------------------------------------------------------- 2865INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2866 VALUES 2867 (7, 'text/plain', 'sr_Cyrl', 'Напомена тикета: <OTRS_AGENT_SUBJECT[24]>', 'Здраво <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2868 2869<OTRS_CURRENT_UserFullname> је написао/ла: 2870<OTRS_AGENT_BODY[30]> 2871 2872<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2873 2874-- <OTRS_CONFIG_NotificationSenderName>'); 2875-- ---------------------------------------------------------- 2876-- insert into table notification_event_message 2877-- ---------------------------------------------------------- 2878INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2879 VALUES 2880 (8, 'text/plain', 'sr_Cyrl', 'Промена реда тикета у <OTRS_TICKET_Queue>: <OTRS_TICKET_Title>', 'Здраво <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2881 2882тикету [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] је промењен ред у <OTRS_TICKET_Queue>. 2883 2884<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2885 2886-- <OTRS_CONFIG_NotificationSenderName>'); 2887-- ---------------------------------------------------------- 2888-- insert into table notification_event_message 2889-- ---------------------------------------------------------- 2890INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2891 VALUES 2892 (9, 'text/plain', 'sr_Cyrl', 'Истек закључаног тикета на чекању: <OTRS_TICKET_Title>', 'Здраво <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2893 2894време закључаног тикета на чекању [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] је достигнуто. 2895 2896<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2897 2898-- <OTRS_CONFIG_NotificationSenderName>'); 2899-- ---------------------------------------------------------- 2900-- insert into table notification_event_message 2901-- ---------------------------------------------------------- 2902INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2903 VALUES 2904 (10, 'text/plain', 'sr_Cyrl', 'Истек откључаног тикета на чекању: <OTRS_TICKET_Title>', 'Здраво <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2905 2906време откључаног тикета на чекању [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] је достигнуто. 2907 2908<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2909 2910-- <OTRS_CONFIG_NotificationSenderName>'); 2911-- ---------------------------------------------------------- 2912-- insert into table notification_event_message 2913-- ---------------------------------------------------------- 2914INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2915 VALUES 2916 (11, 'text/plain', 'sr_Cyrl', 'Ескалација тикета! <OTRS_TICKET_Title>', 'Здраво <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2917 2918тикет [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] је ескалирао! 2919 2920Време ескалације: <OTRS_TICKET_EscalationDestinationDate> 2921Ескалиран од: <OTRS_TICKET_EscalationDestinationIn> 2922 2923<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2924 2925-- <OTRS_CONFIG_NotificationSenderName>'); 2926-- ---------------------------------------------------------- 2927-- insert into table notification_event_message 2928-- ---------------------------------------------------------- 2929INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2930 VALUES 2931 (12, 'text/plain', 'sr_Cyrl', 'Упозорење на ескалацију тикета! <OTRS_TICKET_Title>', 'Здраво <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2932 2933тикет [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] ће ескалирати! 2934 2935Време ескалације: <OTRS_TICKET_EscalationDestinationDate> 2936Ескалира за: <OTRS_TICKET_EscalationDestinationIn> 2937 2938<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2939 2940 2941-- <OTRS_CONFIG_NotificationSenderName>'); 2942-- ---------------------------------------------------------- 2943-- insert into table notification_event_message 2944-- ---------------------------------------------------------- 2945INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2946 VALUES 2947 (13, 'text/plain', 'sr_Cyrl', 'Промена сервиса тикета на <OTRS_TICKET_Service>: <OTRS_TICKET_Title>', 'Здраво <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2948 2949сервис тикета [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] је промењен на <OTRS_TICKET_Service>. 2950 2951<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2952 2953-- <OTRS_CONFIG_NotificationSenderName>'); 2954-- ---------------------------------------------------------- 2955-- insert into table notification_event_message 2956-- ---------------------------------------------------------- 2957INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2958 VALUES 2959 (14, 'text/html', 'sr_Cyrl', 'Подсетник: <OTRS_APPOINTMENT_TITLE>', 'Здраво <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>,<br /> 2960<br /> 2961време је за обавештење у вези термина "<OTRS_APPOINTMENT_TITLE>".<br /> 2962<br /> 2963Опис: <OTRS_APPOINTMENT_DESCRIPTION><br /> 2964Локација: <OTRS_APPOINTMENT_LOCATION><br /> 2965Календар: <span style="color: <OTRS_CALENDAR_COLOR>;">■</span> <OTRS_CALENDAR_CALENDARNAME><br /> 2966Датум почетка: <OTRS_APPOINTMENT_STARTTIME><br /> 2967Датум краја: <OTRS_APPOINTMENT_ENDTIME><br /> 2968Целодневно: <OTRS_APPOINTMENT_ALLDAY><br /> 2969Понављање: <OTRS_APPOINTMENT_RECURRING><br /> 2970<br /> 2971<a href="<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentAppointmentCalendarOverview;AppointmentID=<OTRS_APPOINTMENT_APPOINTMENTID>" title="<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentAppointmentCalendarOverview;AppointmentID=<OTRS_APPOINTMENT_APPOINTMENTID>"><OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentAppointmentCalendarOverview;AppointmentID=<OTRS_APPOINTMENT_APPOINTMENTID></a><br /> 2972<br /> 2973-- <OTRS_CONFIG_NotificationSenderName>'); 2974-- ---------------------------------------------------------- 2975-- insert into table notification_event_message 2976-- ---------------------------------------------------------- 2977INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2978 VALUES 2979 (1, 'text/plain', 'sr_Latn', 'Otvoren tiket: <OTRS_TICKET_Title>', 'Zdravo <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2980 2981tiket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] je otvoren u redu <OTRS_TICKET_Queue>. 2982 2983<OTRS_CUSTOMER_REALNAME> je napisao/la: 2984<OTRS_CUSTOMER_BODY[30]> 2985 2986<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 2987 2988-- <OTRS_CONFIG_NotificationSenderName>'); 2989-- ---------------------------------------------------------- 2990-- insert into table notification_event_message 2991-- ---------------------------------------------------------- 2992INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 2993 VALUES 2994 (2, 'text/plain', 'sr_Latn', 'Nastavak otključanog tiketa: <OTRS_CUSTOMER_SUBJECT[24]>', 'Zdravo <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 2995 2996otključani tiket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] je primio nastavak. 2997 2998<OTRS_CUSTOMER_REALNAME> je napisao/la: 2999<OTRS_CUSTOMER_BODY[30]> 3000 3001<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 3002 3003-- <OTRS_CONFIG_NotificationSenderName>'); 3004-- ---------------------------------------------------------- 3005-- insert into table notification_event_message 3006-- ---------------------------------------------------------- 3007INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 3008 VALUES 3009 (3, 'text/plain', 'sr_Latn', 'Nastavak zaključanog tiketa: <OTRS_CUSTOMER_SUBJECT[24]>', 'Zdravo <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 3010 3011zaključani tiket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] je primio nastavak. 3012 3013<OTRS_CUSTOMER_REALNAME> je napisao/la: 3014<OTRS_CUSTOMER_BODY[30]> 3015 3016<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 3017 3018-- <OTRS_CONFIG_NotificationSenderName>'); 3019-- ---------------------------------------------------------- 3020-- insert into table notification_event_message 3021-- ---------------------------------------------------------- 3022INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 3023 VALUES 3024 (4, 'text/plain', 'sr_Latn', 'Istek zaključanog tiketa: <OTRS_TICKET_Title>', 'Zdravo <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 3025 3026tiket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] je dostigao vreme otključavanja. 3027 3028<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 3029 3030-- <OTRS_CONFIG_NotificationSenderName>'); 3031-- ---------------------------------------------------------- 3032-- insert into table notification_event_message 3033-- ---------------------------------------------------------- 3034INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 3035 VALUES 3036 (5, 'text/plain', 'sr_Latn', 'Promena vlasnika tiketa na <OTRS_OWNER_UserFullname>: <OTRS_TICKET_Title>', 'Zdravo <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 3037 3038vlasnik tiketa [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] je promenjen na <OTRS_TICKET_OWNER_UserFullname> by <OTRS_CURRENT_UserFullname>. 3039 3040<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 3041 3042-- <OTRS_CONFIG_NotificationSenderName>'); 3043-- ---------------------------------------------------------- 3044-- insert into table notification_event_message 3045-- ---------------------------------------------------------- 3046INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 3047 VALUES 3048 (6, 'text/plain', 'sr_Latn', 'Promena odgovornog za tiket na <OTRS_RESPONSIBLE_UserFullname>: <OTRS_TICKET_Title>', 'Zdravo <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 3049 3050odgovorni operater tiketa [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] je promenjen na <OTRS_TICKET_RESPONSIBLE_UserFullname> by <OTRS_CURRENT_UserFullname>. 3051 3052<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 3053 3054-- <OTRS_CONFIG_NotificationSenderName>'); 3055-- ---------------------------------------------------------- 3056-- insert into table notification_event_message 3057-- ---------------------------------------------------------- 3058INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 3059 VALUES 3060 (7, 'text/plain', 'sr_Latn', 'Napomena tiketa: <OTRS_AGENT_SUBJECT[24]>', 'Zdravo <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 3061 3062<OTRS_CURRENT_UserFullname> je napisao/la: 3063<OTRS_AGENT_BODY[30]> 3064 3065<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 3066 3067-- <OTRS_CONFIG_NotificationSenderName>'); 3068-- ---------------------------------------------------------- 3069-- insert into table notification_event_message 3070-- ---------------------------------------------------------- 3071INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 3072 VALUES 3073 (8, 'text/plain', 'sr_Latn', 'Promena reda tiketa u <OTRS_TICKET_Queue>: <OTRS_TICKET_Title>', 'Zdravo <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 3074 3075tiketu [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] je promenjen red u <OTRS_TICKET_Queue>. 3076 3077<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 3078 3079-- <OTRS_CONFIG_NotificationSenderName>'); 3080-- ---------------------------------------------------------- 3081-- insert into table notification_event_message 3082-- ---------------------------------------------------------- 3083INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 3084 VALUES 3085 (9, 'text/plain', 'sr_Latn', 'Istek zaključanog tiketa na čekanju: <OTRS_TICKET_Title>', 'Zdravo <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 3086 3087vreme zaključanog tiketa na čekanju [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] je dostignuto. 3088 3089<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 3090 3091-- <OTRS_CONFIG_NotificationSenderName>'); 3092-- ---------------------------------------------------------- 3093-- insert into table notification_event_message 3094-- ---------------------------------------------------------- 3095INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 3096 VALUES 3097 (10, 'text/plain', 'sr_Latn', 'Istek otključanog tiketa na čekanju: <OTRS_TICKET_Title>', 'Zdravo <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 3098 3099vreme otključanog tiketa na čekanju [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] je dostignuto. 3100 3101<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 3102 3103-- <OTRS_CONFIG_NotificationSenderName>'); 3104-- ---------------------------------------------------------- 3105-- insert into table notification_event_message 3106-- ---------------------------------------------------------- 3107INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 3108 VALUES 3109 (11, 'text/plain', 'sr_Latn', 'Eskalacija tiketa! <OTRS_TICKET_Title>', 'Zdravo <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 3110 3111tiket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] je eskalirao! 3112 3113Vreme eskalacije: <OTRS_TICKET_EscalationDestinationDate> 3114Eskaliran od: <OTRS_TICKET_EscalationDestinationIn> 3115 3116<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 3117 3118-- <OTRS_CONFIG_NotificationSenderName>'); 3119-- ---------------------------------------------------------- 3120-- insert into table notification_event_message 3121-- ---------------------------------------------------------- 3122INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 3123 VALUES 3124 (12, 'text/plain', 'sr_Latn', 'Upozorenje na eskalaciju tiketa! <OTRS_TICKET_Title>', 'Zdravo <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 3125 3126tiket [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] će eskalirati! 3127 3128Vreme eskalacije: <OTRS_TICKET_EscalationDestinationDate> 3129Eskalira za: <OTRS_TICKET_EscalationDestinationIn> 3130 3131<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 3132 3133 3134-- <OTRS_CONFIG_NotificationSenderName>'); 3135-- ---------------------------------------------------------- 3136-- insert into table notification_event_message 3137-- ---------------------------------------------------------- 3138INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 3139 VALUES 3140 (13, 'text/plain', 'sr_Latn', 'Promena servisa tiketa na <OTRS_TICKET_Service>: <OTRS_TICKET_Title>', 'Zdravo <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 3141 3142servis tiketa [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] je promenjen na <OTRS_TICKET_Service>. 3143 3144<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID> 3145 3146-- <OTRS_CONFIG_NotificationSenderName>'); 3147-- ---------------------------------------------------------- 3148-- insert into table notification_event_message 3149-- ---------------------------------------------------------- 3150INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 3151 VALUES 3152 (14, 'text/html', 'sr_Latn', 'Podsetnik: <OTRS_APPOINTMENT_TITLE>', 'Zdravo <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>,<br /> 3153<br /> 3154vreme je za obaveštenje u vezi termina "<OTRS_APPOINTMENT_TITLE>".<br /> 3155<br /> 3156Opis: <OTRS_APPOINTMENT_DESCRIPTION><br /> 3157Lokacije: <OTRS_APPOINTMENT_LOCATION><br /> 3158Kalendar: <span style="color: <OTRS_CALENDAR_COLOR>;">■</span> <OTRS_CALENDAR_CALENDARNAME><br /> 3159Datum početka: <OTRS_APPOINTMENT_STARTTIME><br /> 3160Datum kraja: <OTRS_APPOINTMENT_ENDTIME><br /> 3161Celodnevno: <OTRS_APPOINTMENT_ALLDAY><br /> 3162Ponavljanje: <OTRS_APPOINTMENT_RECURRING><br /> 3163<br /> 3164<a href="<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentAppointmentCalendarOverview;AppointmentID=<OTRS_APPOINTMENT_APPOINTMENTID>" title="<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentAppointmentCalendarOverview;AppointmentID=<OTRS_APPOINTMENT_APPOINTMENTID>"><OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentAppointmentCalendarOverview;AppointmentID=<OTRS_APPOINTMENT_APPOINTMENTID></a><br /> 3165<br /> 3166-- <OTRS_CONFIG_NotificationSenderName>'); 3167-- ---------------------------------------------------------- 3168-- insert into table notification_event_message 3169-- ---------------------------------------------------------- 3170INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 3171 VALUES 3172 (15, 'text/plain', 'en', 'Email Delivery Failure', 'Hi <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>, 3173 3174Please note, that the delivery of an email article of [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] has failed. Please check the email address of your recipient for mistakes and try again. You can manually resend the article from the ticket if required. 3175 3176Error Message: 3177<OTRS_AGENT_TransmissionStatusMessage> 3178 3179<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>;ArticleID=<OTRS_AGENT_ArticleID> 3180 3181-- <OTRS_CONFIG_NotificationSenderName>'); 3182-- ---------------------------------------------------------- 3183-- insert into table notification_event_message 3184-- ---------------------------------------------------------- 3185INSERT INTO notification_event_message (notification_id, content_type, language, subject, text) 3186 VALUES 3187 (15, 'text/plain', 'hu', 'E-mail kézbesítési hiba', 'Kedves <OTRS_NOTIFICATION_RECIPIENT_UserFirstname>! 3188 3189Felhívjuk a figyelmét, hogy a(z) [<OTRS_CONFIG_Ticket::Hook><OTRS_CONFIG_Ticket::HookDivider><OTRS_TICKET_TicketNumber>] jegy e-mail bejegyzésének kézbesítése nem sikerült. Ellenőrizze, hogy nincs-e a címzett e-mail címében hiba, és próbálja meg újra. Kézileg is újraküldheti a bejegyzést a jegyből, ha szükséges. 3190 3191Hibaüzenet: 3192<OTRS_AGENT_TransmissionStatusMessage> 3193 3194<OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias>index.pl?Action=AgentTicketZoom;TicketID=<OTRS_TICKET_TicketID>;ArticleID=<OTRS_AGENT_ArticleID> 3195 3196-- <OTRS_CONFIG_NotificationSenderName>'); 3197-- ---------------------------------------------------------- 3198-- insert into table dynamic_field 3199-- ---------------------------------------------------------- 3200INSERT INTO dynamic_field (internal_field, name, label, field_order, field_type, object_type, config, valid_id, create_by, create_time, change_by, change_time) 3201 VALUES 3202 (1, 'ProcessManagementProcessID', 'Process', 1, 'ProcessID', 'Ticket', '--- 3203DefaultValue: '''' 3204', 1, 1, current_timestamp, 1, current_timestamp); 3205-- ---------------------------------------------------------- 3206-- insert into table dynamic_field 3207-- ---------------------------------------------------------- 3208INSERT INTO dynamic_field (internal_field, name, label, field_order, field_type, object_type, config, valid_id, create_by, create_time, change_by, change_time) 3209 VALUES 3210 (1, 'ProcessManagementActivityID', 'Activity', 1, 'ActivityID', 'Ticket', '--- 3211DefaultValue: '''' 3212', 1, 1, current_timestamp, 1, current_timestamp); 3213SET standard_conforming_strings TO ON; 3214