CSV file format

cowjam

Hello, I'm trying import a UK version of the NIV. Testament and Books seem to work fine, but I'm having trouble with the verses. It errors on import, saying there's an SQL logic error or database missing. When I have a look at what's been imported, it's just the first verse of Genesis and it ends in \n1 when it's in ANSI, but looks as it should in Unicode. An example of my verses file follows, and is how the manual says it should be (bookID, chapter, verse, text: 1,1,1,"In the beginning God created the heavens and the earth." 1,1,2,"Now the earth was formless and empty, darkness was over the surface of the deep, and the Spirit of God was hovering over the waters." 1,1,3,"And God said, ""Let there be light,"" and there was light." Any ideas what the problem is? Thanks, Sam

raoul

There's a bug in the CSV library that openlp.org uses (it's a 3rd party component). We are aware of it, and there's another release in the pipeline to fix that and one or two other problems. Try using an earlier version of openlp.org (like 1.2.1) for the moment.

cowjam

Thanks Raoul, that's sorted it. Sam