Stats. Hos to use an external field imported to MySql?

Hi all, I downloaded from another database to MySql some fields related with our customers as "Building". I want to use this information in my stats but I can not get this field. Any idea about how to get this field information in our stats? We are looking for the number of tickets by Building (We need to know hoy many tickets are coming from the different buildings) Thanks in advance Raoul

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi Raoul,
I downloaded from another database to MySql some fields related with our customers as "Building". I want to use this information in my stats but I can not get this field. Any idea about how to get this field information in our stats? We are looking for the number of tickets by Building (We need to know hoy many tickets are coming from the different buildings)
Sorry, there is no possibility to use the 'Building'data of users form scratch in a dynamic ticket stats. Our preferred solution is to write a event module (http://doc.otrs.org/developer/2.3/en/html/x543.html#ticket-module-event) which generates an entry in a Freetextfield with the name of the affected Building. And Freetextfields are usable in the stats generator. Otherwise you can implement a static stats (http://doc.otrs.org/developer/2.3/en/html/x499.html#static-stats). I hope this helps. ((enjoy)) Thomas -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJ9wyt5VEHpl41kC8RAhZhAJ0dxeBXb7pzDt4ruRBIcRJCpxzOUQCgjDWc xbOCVSKS/GBF6nsemmw4IhY= =zJ6a -----END PGP SIGNATURE-----
participants (2)
-
Le machito
-
Thomas Raith