How to show Dynamic Field in CSV format

[Gunjan]

Hi,

I want to export Dynamic Fields in CSV format on Customer interface. I have a minor problem. I went to Ticket -> Frontend::Customer::Ticket::ViewSearch and then added the field as follows:

pic.png

but I don't know what should I write in Content column, the field is not exported in csv yet! Please help me!

Thanks!
Gunjan

[reneeb]

As you added the config option you should know why you have chosen a hash. If you just need a list of fields you want to export you could also use an array...

This is an option of stock OTRS. Just insert "1"...

I would recommend that you have a look at the code that is using such config options and don't know what they are for. You want to develop OTRS customizations, so you should know the basic parts of the Perl code. For that example you can look at Kernel/Modules/CustomerTicketSearch.pm (https://github.com/OTRS/otrs/blob/rel-3 ... ch.pm#L108), There you see that the config option is used to filter the DynamicFields. So you can look at Kernel/System/DynamicField.pm method DynamicFieldList. See https://github.com/OTRS/otrs/blob/rel-3 ... ld.pm#L521 In the docs to that module you see

Code: Select all

FieldFilter => { # optional, only active fields (non 0) will be returned
  ItemOne => 1,
  ItemTwo => 2,
  ItemThree => 1,
  ItemFour => 1,
  ItemFive => 0,
},

If you set the field value of the sysconfig option to 0 that field is deactivated for the CSV export (not shown), any other value will activate the field for the export.

[jojo]

try with content 1

[Gunjan]

Hi,

I tried with content '1', but still dynamic fields are not exported in csv format! what do I need to do?

[reneeb]

Then you should debug! Add lots of lines like

Code: Select all

$Self->{LogObject}->Log( Priority => error => Message => "<Message>" );

to the code (Kernel/Modules/CustomerTicketSearch.pm), and replace <Message> with a value that helps you to debug the code.

[jojo]

on my system it works. Check if the name of the field is written correctly

[Gunjan]

Can you please describe the whole procedure once?

[jojo]

Put the name on the left column and the 1 on the right column

[wurzel]

Hi,

... and it is case sensitive, I think

Flo

[Gunjan]

ya I have done the same! I don't know what is the issue then!

[jojo]

Delete Caches.

Are you using the CSV Export on the search? Is your OTRS version the latest one?

[diginin]

Be sure you put it in

SearchCSVDynamicField

and not in

Ticket::Frontend::AgentTicketSearch###Defaults###DynamicField

or

Ticket::Frontend::AgentTicketSearch###DynamicField

[jojo]

Ticket_-__Frontend__Agent__Ticket__ViewSearch_-_SysConfig_-_Admin_-_OTRS.png

[Gunjan]

I am also doing the same but still not visible! One important thing is that I am doing this on customer interface not on agent interface! Does it matter? and it is working for agent interface but not customer interface!

[jojo]

well, this might be a bug then.

Please file it: http://bugs.otrs.org

[diginin]

is it a ticket field, or article?

[Gunjan]

ticket field

[diginin]

what type of field is it drop down, etc....?

[Gunjan]

sorry I din't get it! Can you please explain?

[reneeb]

When you create a dynamic field you have to define what kind (type) of field it is...

[Gunjan]

oh ya it is dropdown.