Just as a sample:
to convert an eSword 9 topic module (topx) to a TW book, you only need to execut some SQL statements. You can do this as follows:
1. Get an sqlite editor (e.g. sqliteExplorer)
2. Open the .topx file with the editor
3. copy paste the following code (replace the 'My Abbrev' with the abbreviation you want to use in TW)
4. press 'Execute' (F9) in sqliteExplorer
5. Close the file and rename to .twm!
That's all. Of course, after the conversion, you can open TW and update the module to your liking and properly fill in the missing info or create a structured TOC.
If interested, i can post sql commands for the rest of the module types,
Obviously, repeating this for 1000 mods may be harder, but it's very simple to automate. If there is interest i will do.
Sql code to paste:
Code:
create table t(id integer primary key, title text, notes text);
insert into t(title, notes) select title, notes from topics;
drop table topics;
create table topics(id integer primary key, pid integer default 0, subject text, rel_order, content_type string);
CREATE INDEX idx_topics_rel_order on topics(rel_order);
CREATE TABLE content(topic_id integer primary key, data text, data2 blob);
CREATE TABLE config(name text, value text);
insert into config(name,value) values('type',3);
insert into config(name,value) values('user',1);
insert into config(name,value) values('abbrev','My Abbrev');
insert into topics(id, subject) select id, title from t;
insert into content(topic_id, data) select id, notes from t;
drop table t;
Costas
P.S. The above only works for non-encrypted eSword modules. All official eSword9 mods are encrypted, so this will not work (and you shouldn't try in order to respect the author's wish of not tampering his modules)
http://forum.theword.net/viewtopic.php?f=7&t=1119
