XML export
Posted: Wed May 11, 2022 10:07 pm
Hi,
Have you made some other changes to the XML export function? There seems to be some strange behaviour in the 'Location' field...
Most files work fine, they have :
<Location>\\SERVER\Folder\Filename</Location>
as you would expect, but it looks like some are picking up a bit of code instead :
<Location><![CDATA[\\SERVER\Folder\Filename]></Location>
At first glance it looks like it happens when there is an apostrophe ' in the filename, but there might be other instances as well.
(I import the XML into Excel and have some code parse it into a list there, and it was crashing because Excel imports those fields as blanks - it also seems that Predicted_Rating has turned into Predicted but that's not a big problem )
Thanks,
Have you made some other changes to the XML export function? There seems to be some strange behaviour in the 'Location' field...
Most files work fine, they have :
<Location>\\SERVER\Folder\Filename</Location>
as you would expect, but it looks like some are picking up a bit of code instead :
<Location><![CDATA[\\SERVER\Folder\Filename]></Location>
At first glance it looks like it happens when there is an apostrophe ' in the filename, but there might be other instances as well.
(I import the XML into Excel and have some code parse it into a list there, and it was crashing because Excel imports those fields as blanks - it also seems that Predicted_Rating has turned into Predicted but that's not a big problem )
Thanks,