Importing Bibles from CSV
hey,
it's me again. I just downloaded the very interesting bible converter tool, that converts bibles from csv to sqlite.
well, i've managed to get a bible translation that we use and is avaliable for free from the authors website into csv format.
however, importing will always stop with the notice "I/O Error 32".
well, im not sure whether the problem is me or the software. attached u'll find a screenshot of the csv in notepad.
fyi: that translation is avaliable for the old testament, that s why the screen starts with matthew 1.
and: i would suggest that the converter would accept the bible book number as well as the name. this seems to be more "international" and some files (just like mine) are stored like that. i coulnt find the part of the code yet - if anyone could tell me i will of course submit a patch.
regards,
patrick
it's me again. I just downloaded the very interesting bible converter tool, that converts bibles from csv to sqlite.
well, i've managed to get a bible translation that we use and is avaliable for free from the authors website into csv format.
however, importing will always stop with the notice "I/O Error 32".
well, im not sure whether the problem is me or the software. attached u'll find a screenshot of the csv in notepad.
fyi: that translation is avaliable for the old testament, that s why the screen starts with matthew 1.
and: i would suggest that the converter would accept the bible book number as well as the name. this seems to be more "international" and some files (just like mine) are stored like that. i coulnt find the part of the code yet - if anyone could tell me i will of course submit a patch.
regards,
patrick
Comments
hi patrick, can you e-mail me the csv file please?
it's in one or two other postings, or you could just e-mail support...
but here: raoul(at)openlp.org
Did you use that tool to download a Bible translation to use with Openlp?
If so, would you kindly help me to do the same?
Im interested in add spanish Reina Valera 1960 to use in our church services.
Would also love to know how to add our spanish songs files to the database, are so many I would hate to think will need to copy and paste one by one.
Hi there.
Maybe I am in the wrong section of the forum, but I am looking for an Albanian Bible forum. Please help me find the Albanian bible for openlp and also how can I help with translating the program into Albanian language.
God bless
mrfrodo
hey illir,
im glad to hear, that you want to use openlp.org for your church.
in order to get an albanian bible, i would suggest you download the file http://bibledatabase.org/exec/b_albanian.exe (which installs a albanian bible in tab seperated values format) and convert it to a compatible comma seperated value file by simply opening it with your favourite calculation software (e.g. OpenOffice) and save it as a csv.
Then you can import it from the openlp.org import menu.
To translate the program to the albanian language, please copy the file english.xml from your All Users\Application Files\openlp.org\Languages to albanian.xml and open it with your favorite text editor. Now start translating every Caption attribute and Hint attribute.
When you are finished with either of the two, please send me a copy of your results, so we can include the bible in our downloads and the language in the program.
God bless you and all Albanian christians!
Patrick
Hi joseluis_007. No idea if you can read English, but I ran your comments through google translate so I could read them. I know you are targetting Spanish users with your question, but as the common language amongst the readers here is English, it would also help to include an English translation.
Also posting your email address in a public forum is not recommended if you don't want to be inundated with spam!
You say the script didn't work. Would you be able to give more information as to what you did, and in what way if failed?
(TRANSLATION:
(1) I need to download the King James Bible, 1960 in Spanish but the script does not work, can someone help me lo agradeceria muchoo
(2) if possible I can send the file to my mail <snipped>@hotmail.com if anyone has the King James Bible I openlp.org 1960 for the script works)
I used the script but does not download the second document "bibleverses_60.csv" if you can send me this document, I would greatly appreciate.
blessings
Does anybody know why the script does not work? I have the same problem as Jose Luis... I also wanted to know what should I do to import a file (CSV format)that contains the whole bible. I don't have 'bibleverses' nor 'biblebooks' files, onle one file...
You have to create the other two files yourself. Have a look on the Importing Comma Delimited Files page for what format they must be in.
J Shawn Milburn
Can you Tell Me how to get the NKJV Bible inported into this system
hey alguien puede ayudarme? necesito la biblia reina valera 1960 para usarla en nuestras reuniones en la iglesia.
hey some one help me, i need reina valera 1960 spanish version to use it in our church services.
gracias por su ayuda - thank you for your help