Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Excel export not all values

Highlighted
Christian Staub
Occasional Advisor

Excel export not all values

I have a view of changes with two CI attached to the changes, and I'd like to export the status of these CI in this view. In the view I see the CI status, but as soon as I export to excel, the status is gone. Also happens with csv, tsv or word. In this view there are about 1500 changes.

Anyone had this problem and knows a solution?

SD 4.5 SP17
2 REPLIES
Michel SILVA SO
Occasional Visitor

Re: Excel export not all values

Hello Christian,
the problem I encountred was trying to export some views in excel format and my excel was empty.

So I tried Export Wizard > To the web > Type: HTML; XSL Style Sheet: Bordered Table > [Location] > Finish, and all the data was displayed.

Select all and copy to Excel.

So have a try wiht the HTML to see if the CI Status field appears correctly. ;o)

Hope this helps,
Rgds,
Michel
Peter Dent
Frequent Visitor

Re: Excel export not all values

Christian,

Another way would be to right click the view, choose Report Type. Right click again and sekect Print Preview...

Then from the print preveiw window, choose Publish and select a location....

Then simply open the HTML file with Excel.
//Add this to "OnDomLoad" event