Bulk load options in a dynamic field

Moderator: crythias

Post Reply
luisjf
Znuny newbie
Posts: 55
Joined: 06 Jul 2010, 19:32
Znuny Version: 3.1.2

Bulk load options in a dynamic field

Post by luisjf »

Hello good day, my question is this, if I created a dynamic field with a dropdown, I can somehow make massive load of options? I have seen that the field is stored in database but the options are not used to store, seemed to be loaded in a binary, if someone can help me would greatly appreciate ..
Production Environment: OTRS 3.1.12, ITSM-OTRS 3.1.2, Debian Squeeze, Postgresql 8.4, Apache 2
Development Environment: OTRS 3.1.12, ITSM-OTRS 3.1.2, Debian Squeeze, Postgresql 8.4, Apache 2
massimobianchi
Znuny newbie
Posts: 67
Joined: 02 Apr 2012, 12:18
Znuny Version: 3.1.14
Real Name: Massimo Bianchi
Company: NPO Sistemi S.p.A.
Contact:

Re: Bulk load options in a dynamic field

Post by massimobianchi »

Hello,
I'm looking too at this kind of feature. Does anyone have a clue ?
Thanks,
Massimo
Massimo Bianchi
skype: massimo.bianchi
OTRS:3.1.14, ITSM:3.1.8, httpd, mysql, Centos 6.3 on X86_64
massimobianchi
Znuny newbie
Posts: 67
Joined: 02 Apr 2012, 12:18
Znuny Version: 3.1.14
Real Name: Massimo Bianchi
Company: NPO Sistemi S.p.A.
Contact:

Re: Bulk load options in a dynamic field

Post by massimobianchi »

Well.... i DID find a way, but it's a bad trick

1) Create the dropdown via admin gui
2) using a db tool (MySQL WorkBench in my case) have a look at the "config" value in the Dynamic_Field table.
Content is:

---
DefaultValue: ''
Link: ''
PossibleNone: 0
PossibleValues:
1: 001
TranslatableValues: 0

3) using excel or any other method, generate a numbered list and substitute "1: 001" with your values. over 500 in my case
4) save and apply
5) delete storable cache with
/opt/otrs/bin/otrs.DeleteCache.pl

Enjoy your new values.
Massimo Bianchi
skype: massimo.bianchi
OTRS:3.1.14, ITSM:3.1.8, httpd, mysql, Centos 6.3 on X86_64
Post Reply