
Hi all, I have an already running system, and would like to set a specific CustomerID to some old tickets. Problem is, I can't go picking and editing them one by one, that would take ages. So I tried searching, then Bulk-editing them, but couldn't edit the cusomterID. Any thoughts and/or ideas? Thanks and Best Regards, Muhammad El-Sergani.

customerID is assigned with the customer in the ticket. Basically, if the
customer doesn't have the CustomerID you wan't, you will need to fix that,
then re-assign the customer to the ticket.
http://forums.otrs.org/viewtopic.php?f=60&t=7531
http://forums.otrs.org/viewtopic.php?f=60&t=7531I suppose if you want to
do it en masse, you can update the customerId field via SQL UPDATE command,
http://forums.otrs.org/viewtopic.php?f=61&t=5931#p23875 but if you mess with
the database on your own like that, it's up to you not to mess things up.
On Sun, Apr 17, 2011 at 12:35 PM, Muhammad El-Sergani
Hi all,
I have an already running system, and would like to set a specific CustomerID to some old tickets. Problem is, I can't go picking and editing them one by one, that would take ages. So I tried searching, then Bulk-editing them, but couldn't edit the cusomterID.
Any thoughts and/or ideas?
Thanks and Best Regards, Muhammad El-Sergani.
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

Or you could use a Generic Agent (I think). (Probably safest bet).
On Sun, Apr 17, 2011 at 2:06 PM, Gerald Young
customerID is assigned with the customer in the ticket. Basically, if the customer doesn't have the CustomerID you wan't, you will need to fix that, then re-assign the customer to the ticket. http://forums.otrs.org/viewtopic.php?f=60&t=7531
http://forums.otrs.org/viewtopic.php?f=60&t=7531I suppose if you want to do it en masse, you can update the customerId field via SQL UPDATE command, http://forums.otrs.org/viewtopic.php?f=61&t=5931#p23875 but if you mess with the database on your own like that, it's up to you not to mess things up.
On Sun, Apr 17, 2011 at 12:35 PM, Muhammad El-Sergani
wrote: Hi all,
I have an already running system, and would like to set a specific CustomerID to some old tickets. Problem is, I can't go picking and editing them one by one, that would take ages. So I tried searching, then Bulk-editing them, but couldn't edit the cusomterID.
Any thoughts and/or ideas?
Thanks and Best Regards, Muhammad El-Sergani.
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
participants (2)
-
Gerald Young
-
Muhammad El-Sergani