I'm trying to export data into xml (to open in excel), but it runs into problems with a couple (at least) film titles; it's always possible of course that it's a bug in excel
![Smile :)](./images/smilies/icon_smile.gif)
.
Opening either as "an XML table" or "use the XML source task pane" throws up errors; but only gives the type of error and a location; if you "open as a read only workbook", as well as the description and location of the error, it gives you the actual line that's the problem (so you can see which film it is).
So, one film that creates an error is "The Assemblage of the Crystal Sphere: A D&D Story", with the error
File cannot be opened because:
A semi colon character was expected
Line 165, Position 59
<Title>The Assemblage of the Crystal Sphere: A D&D Story</Title>
and another one, selecting a different set of films is "14 Amazons <Shi si nu ying hao>", which gives
File cannot be opened because:
Missing equals sign between attribute and attribute value.
Line 42005, Position 35
<Title>14 Amazons <Shi si nu ying hao></Title>
These appear to be more or less the only films that create errors in my collection; at least, filtering the list by year 2009-2015, 1973-2007, and 1880-1971 all export fine, when exporting title, popularity, rating, and genres anyway. There might be other films in 2008 and 1972 with problems of course.
I'm guessing it's something to do with the special characters in the title, but I don't really know a lot about xml.
Experimentally I tried exporting plot as well; and now another one at least throws up an error, "The Hired Hand" - this one seems to be about length, perhaps, as the plot text is truncated?
File cannot be opened because:
Whitespace is not allowed at this location.
Line 443, Position 825
<Plot>Peter Fonda's superb yet little-seen directorial debut subverts the machismo of the Western genre with a quiet, understated tale of relationships and loyalty in the Wild West. Fonda stars as Harry Collings, a drifter who has been roaming from town to town with his close friend and fellow wanderer Arch Harris (Warren Oates). Collings is haunted by memories of the wife (Verna Bloom) and daughter he abandoned and decides to make amends and return to them, offering penance by working on the family farmstead as a hired hand. But his newfound domesticity is threatened when Arch is ta
That's only about 60% of the plot, there's 40% more that doesn't show, in the error text at least.
"Plot" can also throw up one of the other errors as well, Altar (2014) gives :
File cannot be opened because:
A semi colon character was expected
Line 218, Position 141.
<plot>The Hamilton family move into a large country house on the Yorkshire Moors to supervise its restoration from a dilapidated B&B to the original Victorian grandeur. When Meg Hamilton, wife, mother and renovation expert first loses her London team after an accident, then a local Yorkshire team too superstitious to continue, she's forced to carry on alone. The discovery of a secret attic room, a Rosicrucian mosaic, a bricked up root cellar and many other unexplainable events gradually convince Meg, her husband Alec and children Penny and Harper, that they're not only restoring the house,
which is truncated as well, but here I guess the & in B&B is the problem? and if that was fixed it might give the whitespace error instead...
Not tremendously important probably, I don't know how much this feature is used (or like I said if it's not an excel problem instead), but thought I would bring it up.
Thanks,