I'll leave the question alone as to the value of a relational database
for this data over using the SWORD API.
You can do this a few ways depending on your familiarity of tools.
If you can process raw text files, you can use of one the SWORD provided
export utilities to produce plain text data from a SWORD module:
mod2osis, mod2imp.
If you are familiar with programming you can use your favorite
programming language and the SWORD bindings for such with a simple loop
like:
#include <swmgr.h>
#include <swmodule.h>
using namespace sword;
SWMgr library;
SWModule &book = *(library.getModuleByName("KJV"));
const char *sql = "insert into bookdata (bookid, entrykey, entrydata)
values (?, ?, ?)";
// "prepare" your sql statement
for (book = TOP; !book.Error(); book++) {
// sqlStatement.bind(1, "KJV");
// sqlStatement.bind(2, module.KeyText());
// sqlStatement.bind(3, module.getRawEntry());
// sqlStatement.execute();
}
//sqlStatement.commit();
Hope this helps. Please consider using / contributing to the usefulness
of the API itself to meet your purposes. I'm sure your additions would
add to the usefulness of the project for many others after you.
-Troy.
lumin8 wrote:
> I am interested transferring a couple of the Sword bible and lexicon
> modules into a relational database (mysql most likely) for my own
> indexing purposes.
>
> Is there already a tool available that can move the data over? If
> not, what would be the best way of accomplishing this?
>
> Thanks so much,
> nathan
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> sword-devel mailing list: sword-devel@crosswire.org
> http://www.crosswire.org/mailman/listinfo/sword-devel
> Instructions to unsubscribe/change your settings at above page
_______________________________________________
sword-devel mailing list: sword-devel@crosswire.org
http://www.crosswire.org/mailman/listinfo/sword-devel
Instructions to unsubscribe/change your settings at above page
