Wednesday, November 6, 2013

Invalid Characters in MIF data load

MIF loading framework is XML-based, thus when loading flat data the first step taken by the framework is to convert the flat structure to a hierarchical XML structure.

We should be aware that some of the invalid characters [ < ,  > , ' , &, "] need to be avoided in flat file.
If you place a character like "<" inside an XML element, it will generate an error because the parser interprets it as the start of a new element.
When these characters are used in the flat file, we need to replace them with the entity references.
&lt;         <    less than
&gt;        >    greater than
&amp;    &    ampersand
&apos;    '    apostrophe
&quot;    "    quotation mark


Incorrect Data: "Multiple Assets & Locations"
Correct Data: "Multiple Assets &amp; Locations"


http://www.w3schools.com/xml/xml_syntax.asp
http://goo.gl/tyuncl