May 19, 2012  
   Login  
Forum  
 
ForumForumEnesys RS Data ...Enesys RS Data ...Support - RS Da...Support - RS Da...Special Characters in Column NamesSpecial Characters in Column Names
Previous Previous
 
Next Next
New Post
 5/29/2009 7:22 PM
 

I have a survey that contains a lot of question mark characters.  Enysis doesn't appear to support these in the 2.x version I'm using.  Is there anything special I can do to work around this?

 <?xml version="1.0" encoding="utf-8"?>
<root xmlns="http://enesyssoftware.com/schemas">

 <list title="PACE Usage" relativeSiteUrl="/sites/IMR_Analytics" useDisplayName="true"
    tableName="PACE Usage" stripHtml="true">
<fields>Created By,How do you interact with IM&R PACE?</fields>
  <query>

  </query>
 </list>

</root>

Results in error:  An error occurred whil parsing EntityName.  Line 6, position 48.  (System.Xml)

 

 

New Post
 6/1/2009 2:57 PM
 

Hi,

This problem has been fixed in version 3.1.
As a workaround, you can use the column’s internal names instead of the display name.

I would recommend in any cases this approach because by using display name, any change in the column’s name would break your report.

Regards,


Frederic LATOUR
ENESYS
New Post
 6/3/2009 12:21 PM
 

Hi jmccall,

Your error occurs because the "&" character is not a valid character in a XML element. You have two solutions to use a "&" character in the query:

  • Use "&amp;" instead of "&":
    <fields>Created By,How do you interact with IM&amp;R PACE?</fields>
  • Use "<![CDATA[    ]]>" inside the xml element:
    <fields><![CDATA[ Created By,How do you interact with IM&R PACE? ]]></fields>

As Frederic said, it is not recommended to use display name, you would rather use internal name.

Regards,
Marien MONNIER
Enesys

Previous Previous
 
Next Next
ForumForumEnesys RS Data ...Enesys RS Data ...Support - RS Da...Support - RS Da...Special Characters in Column NamesSpecial Characters in Column Names

 
You need to login for posting to the forums.
If you don't have a login, click here to register.
 
Copyright 2010 Enesys - All rights reserved Terms Of UsePrivacy Statement