Database import from EasySlides

[mr-aleks]

Doesn't import our databases from EasySlides. I see an error in the debug file.

Apr 26, 2022 9:21:44 PM org.quelea.services.importexport.EasySlidesParser getSongs WARNING: Something went wrong importing easyslides songs org.xml.sax.SAXParseException; lineNumber: 6; columnNumber: 20; Character reference "&# at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(Unknown Source) at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(Unknown Source) at org.quelea.services.importexport.EasySlidesParser.getSongs(EasySlidesParser.java:57) at org.quelea.services.importexport.ImportDialog$1.run(ImportDialog.java:201)

I would really like to try to use this program, but without our songs it is impossible. Help me please. I will leave the links below for the song base files. Song database with Easislides 4.0.5 https://drive.google.com/file/d/1gUEFSFKwYUmTj3BefgG3Eskudq6d2yyM/view?usp=sharing Song database with Easyslides 5.0.1 https://drive.google.com/file/d/1Srct5dnztoZxkng3vKsSsLuBLwa6WtDB/view?usp=sharing

[DeeTigIT]

Is your xml-export ok? If I open Export_2022-04-23_Наши-Песни.xml in Notepad++ v7.8.7 (with XMLTools 3.1.1.13 plugin) and perform a xml syntax check an error is given.

Importing this Export_2022-04-23_Наши-Песни.xml in an empty Quelea database with the just released Quelea 2022.0 cross-paltform fails.

After brute-force manually editing this file (until it's error free in Notepad) it can be imported in Quelea:

Original file

[Fatal Error] :8:20: Character reference "&#x0" is an invalid XML character. 2022-04-30T16:27:13.584+0200 WARNING Something went wrong importing easyslides songs org.xml.sax.SAXParseException; lineNumber: 8; columnNumber: 20; Character reference "&#x0" is an invalid XML character.

Edited file

[mr-aleks]

Thank you very much for the information, I deleted the first 11 songs with incorrect characters, but the plugin still shows that the xml needs to be corrected, I don’t understand the meaning of the rest of the errors that it shows me. I have no experience with this plugin. Perhaps you could share the edited xml file?

[mr-aleks]

I got it. In another program, I realized what the problem was. There were strange characters in the entire database. Something like "" and "". Once again, thank you very much!!

[DeeTigIT]

I'm glad to hear you can move on. And thanks for the XML Notepad screenshot. I'll add that program to my utils.