Thanks a lot for your answer Roberto! I got it now. I was changing the table customer_user only and the old tickets were gone. I had to change the tickets, too !!!
Best regards, Sven On Wednesday 28 September 2005 15:26, Roberto Giana wrote: > Hi Sven > > The easiest way would be to login as an admin and use "Customer Users" > for edditing the user. There you can fill in the CustomerId manually. > > If you have a bunch of users to update/import you could use the > "syncuser_csv2otrs.pl" script. Unfortuantely it doesn't update the > CustomerId field. But it schouldn't be a problem to extend the script to > do this. > > Alternatively you could do a 'mysql -u root -p otrs -B -N -e "select * > from customer_user;" >/tmp/customer_user.txt' which dumps the entire > customer_user table as a tab-delimited CSV file, then edit the values in > the file regarding to your needs with some scripts, awk, vi, Notepad or > Excel and then reimport all the values with 'mysqlimport -u root -p -r > -v otrs /tmp/customer_user.txt'. > Keep in mind that mysqlimport uses the file name to determine the name > of the target table. So the file name has to start with "customer_user"! > > And as usual before you start: Be shure that you have a working backup! :-):-) > > > Best regards > Roberto > > [EMAIL PROTECTED] wrote: > >Hi, > > > >but how can I set this CustomerID value "automatically/manually" ? > > > >regards, > > > >Sven > > > >On Wednesday 28 September 2005 12:11, Roberto Giana wrote: > >>Hi Camilla > >> > >>It's the feature you are looking for. ;-);-) > >>All customers with the same CustomerID value can see each others tickets > >>as "company ticket". If you use for example a support contract number as > >>CustomerID each customer user under the same contract can see the > >>corresponding tickets as "company ticket". > >>Hope this helps. > >> > >> > >>Best regards > >>Roberto > >> > >>Camilla Krag Jensen wrote: > >>>I am wondering what the 'company ticket' icon in the customer > >>>interface is for? Can anyone tell me the difference between a ticket > >>>and a company ticket? > >>> > >>>:-) > >> > >>_______________________________________________ > >>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 > >>Support oder Consulting für Ihr OTRS System? > > _______________________________________________ > 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 > Support oder Consulting für Ihr OTRS System? > => http://www.otrs.de/ -- ----------------------------------------------------------------------- See our FAQs at: http://www.snom.com/faq0.html?&L=1 Whitepapers at: http://www.snom.com/white_papers.html ----------------------------------------------------------------------- snom technology AG Gradestraße 46 D-12347 Berlin Sven Fischer fax +49 30 39833111 mailto:[EMAIL PROTECTED] http://www.snom.com ----------------------------------------------------------------------- _______________________________________________ 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 Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/