Bulk load options in a dynamic field
Moderator: crythias
Bulk load options in a dynamic field
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
Development Environment: OTRS 3.1.12, ITSM-OTRS 3.1.2, Debian Squeeze, Postgresql 8.4, Apache 2
-
- 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
Hello,
I'm looking too at this kind of feature. Does anyone have a clue ?
Thanks,
Massimo
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
skype: massimo.bianchi
OTRS:3.1.14, ITSM:3.1.8, httpd, mysql, Centos 6.3 on X86_64
-
- 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
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.
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
skype: massimo.bianchi
OTRS:3.1.14, ITSM:3.1.8, httpd, mysql, Centos 6.3 on X86_64