Hello
I would like to differentiate my customers because I have customer with a support subscription and other customer without support subscription , anyone can help me please ?
Thanks
Differentiate customers
Moderator: crythias
-
reneeb
- Znuny guru
- Posts: 5018
- Joined: 13 Mar 2011, 09:54
- Znuny Version: 6.0.x
- Real Name: Renée Bäcker
- Company: Perl-Services.de
- Contact:
Re: Differentiate customers
So what do you want to achieve? Do you want a "label" shown in the customer information? Then add a new column in the customer table and add that new column to the mapping. Do you want different behaviour for those two groups of customers? What should the difference be? You have to post more details...
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Re: Differentiate customers
What I would like would be to differentiate between multiple clients, especially when I need to make month-end statistics
in the ticket information should reveal the information if my clients is managed hosting or not
in the ticket information should reveal the information if my clients is managed hosting or not
-
reneeb
- Znuny guru
- Posts: 5018
- Joined: 13 Mar 2011, 09:54
- Znuny Version: 6.0.x
- Real Name: Renée Bäcker
- Company: Perl-Services.de
- Contact:
Re: Differentiate customers
You didn't answer my questions... But I'll guess you could do this:
* add a column to the customer user called "is_webhosting_customer"
* add a dynamic field for tickets (simple text field)
* create a ticket event module that checks if the column is filled and save the value in the dynamic field
* now you can use that dynamic field in statistics
* add a column to the customer user called "is_webhosting_customer"
* add a dynamic field for tickets (simple text field)
* create a ticket event module that checks if the column is filled and save the value in the dynamic field
* now you can use that dynamic field in statistics
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Re: Differentiate customers
Sorry if I was not very understandable but you understand my request
For the steps to follow:
How to add the column I want for my client?
How to create dynamic field for tickets and ticket events module?
Thanks
For the steps to follow:
How to add the column I want for my client?
How to create dynamic field for tickets and ticket events module?
Thanks
-
reneeb
- Znuny guru
- Posts: 5018
- Joined: 13 Mar 2011, 09:54
- Znuny Version: 6.0.x
- Real Name: Renée Bäcker
- Company: Perl-Services.de
- Contact:
Re: Differentiate customers
1)
a) If customer users are stored in the OTRS DB:
Use HeidiSQL or any other tool to add the column or run "ALTER TABLE customer_user ADD COLUMN is_webhosting_customer SMALLINT NOT NULL DEFAULT 0;" in the mysql/psql client
b) If customer users are stored in LDAP: Add a new attribut to the person. Ask your LDAP admin about that
2) Add the new column to the map, similar as described at http://otrs.github.io/doc/manual/admin/ ... r-ids-ldap
3) Add the Dynamic field: See http://otrs.github.io/doc/manual/admin/ ... ields.html
4) For the event module: If you're using OTRS5, you can follow this instruction: http://otrs.github.io/doc/manual/admin/ ... stomeruser
a) If customer users are stored in the OTRS DB:
Use HeidiSQL or any other tool to add the column or run "ALTER TABLE customer_user ADD COLUMN is_webhosting_customer SMALLINT NOT NULL DEFAULT 0;" in the mysql/psql client
b) If customer users are stored in LDAP: Add a new attribut to the person. Ask your LDAP admin about that
2) Add the new column to the map, similar as described at http://otrs.github.io/doc/manual/admin/ ... r-ids-ldap
3) Add the Dynamic field: See http://otrs.github.io/doc/manual/admin/ ... ields.html
4) For the event module: If you're using OTRS5, you can follow this instruction: http://otrs.github.io/doc/manual/admin/ ... stomeruser
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Re: Differentiate customers
So I created a dynamic field that appears when creating a ticket, through your explanations I managed to see the value of this dynamic field directly in sight of tickets, so when I want to do my final statistics month I add a filter based on the value returned by my dynamic field
Thanks
Thanks