- Thread starter
- #21
I can confirm the bug with your catalog XML DB but not using my own catalog (even with some of the same Movie titles!) Furthermore, it applies not only to the single quote (') but to many punctuation marks like dashes, colons, etc.
Here's what I did:
I am stabbing in the dark here, but since I know you created the original xml file by converting a list of data in a .doc file, I wonder if it used non ASCII (i.e. extended) characters for punctuation. I know Word will do that for quotes and dashes if enabled in Word Setup. It only seems to have trouble with punctuation in the Titles, not in data you grabbed.
To support my hypothesis, when I open your XML in Notepad++ none of the single quotes display. So it is obviously an unknown character. So I opened your 'good' XML, that displays the punctuation, in Notepad and used Find/Replace to change all the single quotes to ASCII ones and all the emdashes to normal dashes. Then I opened it in MF and Updated Online Availability and the titles remained correct. There may be a few more you need to change, unless you know a good way to save the XML file converting all those odd characters to standard ASCII. I would have thought saving it as a text file in Open Office would have done that!
Nevertheless, My Films should support extended characters so I am still not sure why it is not recognizing them and converting them to a question mark. It seems AMCU does but MP GUI does not. I don't see anything in the log files but that means little perhaps Guzzi can spot something.
In the meantime I hope that helps with workaround for now.
Here's what I did:
- Opened your movies.amc catalog you posted previously in catalogs.zip (because punctuation was correct there)
- Saved it as XML in AMC - so far so good
- Opened in MF GUI - still good
- Update online availability - punctuation marks change to ? and XML catalog is saved that way
I am stabbing in the dark here, but since I know you created the original xml file by converting a list of data in a .doc file, I wonder if it used non ASCII (i.e. extended) characters for punctuation. I know Word will do that for quotes and dashes if enabled in Word Setup. It only seems to have trouble with punctuation in the Titles, not in data you grabbed.
To support my hypothesis, when I open your XML in Notepad++ none of the single quotes display. So it is obviously an unknown character. So I opened your 'good' XML, that displays the punctuation, in Notepad and used Find/Replace to change all the single quotes to ASCII ones and all the emdashes to normal dashes. Then I opened it in MF and Updated Online Availability and the titles remained correct. There may be a few more you need to change, unless you know a good way to save the XML file converting all those odd characters to standard ASCII. I would have thought saving it as a text file in Open Office would have done that!
Nevertheless, My Films should support extended characters so I am still not sure why it is not recognizing them and converting them to a question mark. It seems AMCU does but MP GUI does not. I don't see anything in the log files but that means little perhaps Guzzi can spot something.
In the meantime I hope that helps with workaround for now.