Once upon a time I needed to change the merging of an article into the wrong ticket. After an analysis of the database discovered that …
update article set ticket_id=<ticket_id> where id=<article_id>; I don’t know if this is still valid… I was working with an old DB version at the time. May allow you to program your modifications. Of course start with a back-up of the DB, and optimally test on a non-production instance. gl From: otrs [mailto:[email protected]] On Behalf Of Gerald Young Sent: Thursday, November 29, 2018 8:47 AM To: User questions and discussions about OTRS. <[email protected]> Subject: Re: [otrs] Merge tickets that start with same string Ok, fair. I have a thought about select id, TN, title from ticket [optional:where title like 'needle%'] and then use otrs.Console.pl <http://otrs.Console.pl> to ticket merge. In excel, this could concatenate ticket numbers or id's in individual commands to copy paste to shell command line. Pick a single destination to merge to per criteria. I am not at a desk, but am writing to point toward an option. Test one to make sure the command line works as expected. On Thu, Nov 29, 2018, 8:20 AM William Edwards | Cyberfusion <[email protected] <mailto:[email protected]> wrote: For 8000 tickets? :) Met vriendelijke groet, with kind regards, William Edwards Cyberfusion - Hosting voor webbureaus en bedrijfskritische applicaties W. https://www.cyberfusion.nl/ E. [email protected] <mailto:[email protected]> T. 040 - 711 44 96 From: Gerald Young <[email protected] <mailto:[email protected]> > To: User questions and discussions about OTRS. <[email protected] <mailto:[email protected]> > Sent: 29/11/2018 1:53 PM Subject: Re: [otrs] Merge tickets that start with same string Maybe search, checkbox and bulk actions may be useful. On Thu, Nov 29, 2018, 7:16 AM William Edwards <[email protected] <mailto:[email protected]> wrote: I have imported tickets from our previous ticket system into OTRS. Every single reply is its own ticket with one article right now. I need to merge these replies together into the tickets that they are about to complete the migration. Each ticket starts with a ticket number. Looking at the ticket number and merging every ticket that starts with that in the subject would do the trick. Before I start typing this: has anyone made a tool to achieve this before so I don’t have to reinvent the wheel? --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
