Home Analyst Portal

Has anyone has issues with exporting the "All Open Service Requests" view?

Mark_JonesMark_Jones Customer IT Monkey ✭
We are having issues with an XML error when we attempt this export. The export process for All Open Unassigned Incidents is working fine.

Here is the XML error from Excel:

<?xml
version="1.0" encoding="UTF-8"
standalone="true"?&gt;<a rel="nofollow" title="Link: null">&lt;recoveryLog xmlns="<b>http://schemas.openxmlformats.org/spreadsheetml/2006/main</b>"&gt;</a>&lt;logFileName&gt;error111520_01.xml&lt;/logFileName&gt;&lt;summary&gt;Errors
were detected in file 'C:\Users\jonesmw\Desktop\All Open Service Requests.xlsx'&lt;/summary&gt;<a rel="nofollow" title="Link: null">&lt;removedParts summary="<b>Following is a list of removed parts:</b>"&gt;</a>&lt;removedPart&gt;Removed Part: /xl/sharedStrings.xml
part with XML error. (Strings)
Illegal xml character. Line 2, column 9319.&lt;/removedPart&gt;&lt;/removedParts&gt;<a rel="nofollow" title="Link: null">&lt;removedRecords summary="<b>Following is a list of removed records:</b>"&gt;</a>&lt;removedRecord&gt;Removed Records: Cell information
from /xl/worksheets/sheet1.xml part&lt;/removedRecord&gt;&lt;/removedRecords&gt;&lt;/recoveryLog&gt;

Any ideas would be appreciated!

Mark

Best Answer

  • Mark_JonesMark_Jones Customer IT Monkey ✭
    Accepted Answer
    @donson_pham,
    I have not had a chance. Buried in another project for a while and the person attempting this has left the agency. It's on the back burner.

Answers

  • damon_mulligandamon_mulligan Cireson Consultant Advanced IT Monkey ✭✭✭
    @Mark_Jones
    I see you are trying to export the view. How are you trying this? You can just copy and paste to excel. Another option would be to create  a custom view. I assume there might be properties in the default view you may not care about, and additional ones you would like to add anyway. Than see if you can export your custom view. 
  • Justin_WorkmanJustin_Workman Cireson Support Super IT Monkey ✭✭✭✭✭
    @Mark_Jones
    I've tried exporting a Service Request saved search and the spreadsheet worked fine.  Can you provide more info about the view you're trying to export?
  • Mark_JonesMark_Jones Customer IT Monkey ✭
    @Justin_Workman
    It's been a while since I have looked at this. Let me go back and refresh my memory. I'll post a reply by the first of next week. Thanks for responding.
    Mark
  • donson_phamdonson_pham Member Adept IT Monkey ✭✭
    Hi @Mark_Jones just curious on if you were able to find this out? 
  • Mark_JonesMark_Jones Customer IT Monkey ✭
    Accepted Answer
    @donson_pham,
    I have not had a chance. Buried in another project for a while and the person attempting this has left the agency. It's on the back burner.
Sign In or Register to comment.