while exporting excel only few fields are exported

[gomathysanjana]

I have tried to export excel of Data Review Task table while doing so all the fields are not getting exported only 5 fields are exported. Does anyone come across this issue? What may be the reason for this? Can anybody assist me on this? Thanks in advance

[Rajendra Bagade]

Update or insert following property and try.

Name : glide.export.excel.force_xlsx

Type : true:false

Value:true

For more details go through

http://wiki.servicenow.com/index.php?title=Available_System_Properties#gsc.tab=0

Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.

Thanks

Rajendra

[gomathysanjana]

Hi Tracey,

I have checked sys_dictionary list there are no attributes which prevent the fields from exporting

[gomathysanjana]

Any thoughts here?

[The SN Nerd]

What are you using to export to excel?

Have you tried the following?

/nav_to.do?uri=cert_task.do?sysparm_query=active=false%26sysparm_view=view_with_your_fields%26CSV

where view_with_your_fields is a view that has all the fields you want to export?

Is there any report_on ACL's on fields that may be restricting access?

[gomathysanjana]

Hi Paul,

I am clear about report_on ACLs. One more thing in Data review tasks there is a section called Dirx role assignments Under that there are few columns of which only 6 columns are getting exported leaving other columns. What may be the reason I have checked for sys_dictionary attributes nothing is preventing from exporting. But am not able to export all the fields