Edit a Dynamic Field from the back end?

Moderator: crythias

Locked
JeremyB3ntham
Znuny newbie
Posts: 38
Joined: 15 Mar 2015, 10:31
Znuny Version: v4.0.5 (Debian)

Edit a Dynamic Field from the back end?

Post by JeremyB3ntham »

Is it possible to edit a Dynamic Field from the back end:

So, say I have a field set up with lots of drop down options. I want to add lots more rows, but doing it through the GUI can take time, so I wonder if the data is stored on a file somewhere in the system that can be edited?
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Edit a Dynamic Field from the back end?

Post by jojo »

actually there is only the option to use the frontend
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
griffin
Znuny newbie
Posts: 20
Joined: 29 Apr 2015, 19:51
Znuny Version: 3.3.8
Real Name: Marcos

Re: Edit a Dynamic Field from the back end?

Post by griffin »

actually this is possible. I loaded loooooooots of data into a dynamic field on the backend.

For starters i loaded a couple on the frontend so as to get the field slightly filled up.

Then went into the database.
Ran

Code: Select all

SELECT * FROM dynamic_field;
found the dynamic field i needed and edited the field "config" with similar format as the previously loaded.

Once done, i ran the script file in the bin folder.
otrs.DeleteCache.pl

This solved my data loading in the backend.

If you need to update this regularly, thats gonna be tough.
OTRS: 4.0.8
Database: MySQL
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Edit a Dynamic Field from the back end?

Post by jojo »

Inserting data directly into database is not intented and might be dangerous as data might get corrupt. So I would not consider it as a back tool and I strongly advice not to manipulate the database directly
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
griffin
Znuny newbie
Posts: 20
Joined: 29 Apr 2015, 19:51
Znuny Version: 3.3.8
Real Name: Marcos

Re: Edit a Dynamic Field from the back end?

Post by griffin »

that is only for initial edition... not as a constant thing.

populating data via web when data is in the hundreds of rows is slow. Its for a 1 time thing mostly
OTRS: 4.0.8
Database: MySQL
JeremyB3ntham
Znuny newbie
Posts: 38
Joined: 15 Mar 2015, 10:31
Znuny Version: v4.0.5 (Debian)

Re: Edit a Dynamic Field from the back end?

Post by JeremyB3ntham »

Okay, cheers guys. I'll carry on using the front end then. Shame they don't have an official way of doing it though.
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Edit a Dynamic Field from the back end?

Post by jojo »

you're free to contribute or to send an order for such a functionality
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
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: Edit a Dynamic Field from the back end?

Post by reneeb »

You could generate a json file and then use http://opar.perl-services.de/dist/Impor ... elds-4.0.1 To get an idea of the JSON schema you could export some sample fields...
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
Locked