CSV file format

edited November -1 in Troubleshooting


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?






Sign In or Register to comment.