[otrs] OTRS as a lightweight CRM ?

2008-07-23 Thread Andrew Stesin
Dear OTRS gurus, is OTRS suitable for use as a CRM system, or does it lack some critical CRM functionality? Maybe some add-on exists (like ITSM) which makes a lightweight CRM system from OTRS ? Thanks in advanse! Andrew ___ OTRS mailing list: otrs -

Re: [otrs] OTRS as a lightweight CRM ?

2008-07-23 Thread Andrew Stesin
The question of where the distinct border between CRM functionality and other OSS/BSS systems functionality is seems to be not so simple. What I mean, that CRM is some subset of functionality, described in TMForum's recent document GB929 R3 Vesion 3.2 TM Forum Applications Framework (TAM). The

[otrs] Permissions to work with customer database? Which flag?

2008-04-07 Thread Andrew Stesin
permission, so Ok). How can I also give agents from subsidiaries their permissions to work with customer database? Fill in person's data, edit etc. and set up customer for their tickets? Which flag(s) should I set for this? Thanks in advanse! Andrew Stesin

Re: [otrs] [ Is there any easy way to show tickets closed in a week? ]

2008-03-06 Thread Andrew Stesin
2008/3/6, Andrew Stesin [EMAIL PROTECTED]: 4. The day after: - write `2008.03.06' into cell A2 - we are making a daily report for Sorry for misprint, of course we are working with 3-rd row now, need to be A3 :) ___ OTRS mailing list: otrs - Webpage

Re: [otrs] [ Is there any easy way to show tickets closed in a week? ]

2008-03-06 Thread Andrew Stesin
It's easy but needs a bit of daily work. 1. Establish some timestamp at which daily data is to be taken. Say 8:00. 2. Take Excel and create a table with the following columns: - column A: date - column B: the rest taken - column C: new - column D: closed - column E: the rest given 3. Let's

[otrs] Splitting ticket with attachment - how?

2008-03-06 Thread Andrew Stesin
Hello friends, just a small and maybe silly question. Suppose we got a ticket with an attachment. I want to split it in the way that I have 2 tickets both with that very same attachment in them. The best way is to have 2 tickets with a link to the single file inside both. How this can be done?

[otrs] Need suggestion with DBD::mysql, mysql-5.0 and connection limit

2007-06-04 Thread Andrew Stesin
get a migration tool to import all the current ticket database? And will 2.2 work in Ukrainian or in Russian for us? Thank you! WBR, Andrew Stesin ___ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs

Re: [otrs] Need suggestion with DBD::mysql, mysql-5.0 and connection limit

2007-06-04 Thread Andrew Stesin
Dear Nils, thank you so much! Your answer was extremely helpful (or maybe I was too stupid, let's be honest). But just straight bumping max_connections up in my.cnf didn't help alot: now we are running with LA above 40.0 and the whole system is a bit slow. And even much worse it is, we are now