Microsoft Excel 2003 errors with "Problems During load" when trying to open a list of objects exported from Service Desk Manager (SDM).

book

Article ID: 50369

calendar_today

Updated On:

Products

CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

Description:

This situation manifests itself when you have a list of objects (ex: Incidents) and one of the fields contains a special characters in it, such as ']' or '<' (see Figure 1 below in which the field contains the text, 'Problem]will<occur on Excel2003').

When you export the list using the 'Export' button, you cannot open the resulting .XLS file using Microsoft Excel 2003. Instead, you receive the 'Problems During Load' popup message shown in Figure 2.

Figure 1. The field in an item in a list contains special characters.

<Please see attached file for image>

Figure 1

Figure 2. Microsoft Excel 2003 cannot handle the special characters.

<Please see attached file for image>

Figure 2

If you open the exported .XLS file using a text editor, for this example, you may see the following:

<Data ss:Type="String"><![CDATA[Problem]will<occur on Excel2003]]></Data>

Solution:

Microsoft Excel 2003 cannot handle such special characters as a value. It misunderstands them to be special tag characters and so it cannot open the file properly. That's why the error. This is a limitation with Excel, and not with SDM.

Microsoft Excel 2007 on the other hand handles this better and it recognizes the characters properly.

So, the alternative is to use Microsoft Excel 2007 to open the file.

Environment

Release:
Component: ARGIS

Attachments

1558698712927000050369_sktwi1f5rjvs16odw.gif get_app
1558698711177000050369_sktwi1f5rjvs16odv.gif get_app