Anyway to combine these modules into one *.twm? [SOLVED]

[malayangbiblia]

Is there a quick way to combine these 2 modules into one without asking the help of The Flash?

http://www.wordmodules.com/the-word-mod ... k-lexicon/
http://www.wordmodules.com/the-word-mod ... criptures/

There is a condensed version available from the same site but it only deals with NT.

[jonathangkoehn]

Are either one encrypted? If not then some sql with SQLite Expert Personal should make it possible

If all the strongs numbers are the same it shouldn't be bad and if not there will just be some extras in the topic list.

[malayangbiblia]

Are either one encrypted? If not then some sql with SQLite Expert Personal should make it possible

If all the strongs numbers are the same it shouldn't be bad and if not there will just be some extras in the topic list.

They are both not encrypted.

[jonathangkoehn]

Ah good - once you have SQLite Expert Personal I can get you some code that could help you go in the right direction. That way you won't need me if you want to do similar with other ones in the future.

[malayangbiblia]

Ah good - once you have SQLite Expert Personal I can get you some code that could help you go in the right direction. That way you won't need me if you want to do similar with other ones in the future.

Thank you brother. I've not seen any tutorials regarding this so far in the forum or I guess, I haven't spent more time. And this wonderful site: http://www.thewordtutorial.com/ is sadly down for sometime now.

[RevSteve]

without asking the help of The Flash?

I ask because of my curiosity has got the best of me but what is "The Flash"?

On combining, you can do a simple combine inside of TheWord but it is more or less a "blind combine" and you can have multiple duplicate topics.

Good to see Jonathan doesn't mind helping out with this.

I have some sql commands also that I learned them on my own but I don't know if they are "best method" for dealing with this.
Therefore Jonathan's will be the way to go.

One of these days, Jonathan, I may want to compare what you have with mine...but I don't have an immediate need right now.

[NorrinRadd]

without asking the help of The Flash?

I ask because of my curiosity has got the best of me but what is "The Flash"?

Classic "speedster" superhero. In the Golden Age, Jay Garrick. In the Silver and Bronze Ages, Barry Allen. I stopped following comics regularly shortly after the end of the Bronze Age (ca. late '80s), but I think since then Wally West and maybe even Bart Allen have had turns as The Flash, before a reboot to Barry.

(One might guess from my username that I'm a bit of a comics nerd. "Norrin Radd" was the "civilian" name of the Silver Surfer, Sky-Rider of the Spaceways, wielder of the Power Cosmic, rebellious former herald of the world-eater Galactus.)

(ETA: I kind of neglected the contextually important point that The Flash is "The Fastest Man Alive.")

[malayangbiblia]

without asking the help of The Flash?

I ask because of my curiosity has got the best of me but what is "The Flash"?

Classic "speedster" superhero. In the Golden Age, Jay Garrick. In the Silver and Bronze Ages, Barry Allen. I stopped following comics regularly shortly after the end of the Bronze Age (ca. late '80s), but I think since then Wally West and maybe even Bart Allen have had turns as The Flash, before a reboot to Barry.

(One might guess from my username that I'm a bit of a comics nerd. "Norrin Radd" was the "civilian" name of the Silver Surfer, Sky-Rider of the Spaceways, wielder of the Power Cosmic, rebellious former herald of the world-eater Galactus.)

(ETA: I kind of neglected the contextually important point that The Flash is "The Fastest Man Alive.")

You got it bro! Hahahaha....and my kids love it! I hope that SQL script can work just like the Flash...Lol.

[jonathangkoehn]

This is a good place to start: https://www.tutorialspoint.com/sqlite/


What you can do with Sqlite Expert Personal is join to databases together to work with them.
(Always back up first) (Btw if there is much rtf in the content this could get more complicated, because the closing } of RTF causes anything after it not to display.)

You'll be doing something like this:
1. Copy one of the dictionaries I did Thayers and change name (Note Thayers appears to need to be converted to RTF in theWORD)
2. Open in SQL Expert Personal (You have to change the file type to All files)
3. File->Attach database the other file I did grc
4. Check if the topics->subjects match up between the Thayers and GRC (They don't directly so more work Thayers is G1, G2, G3 grc is G1, G10, G100 Rarely would they match up)
5. You could get GRC to have the same order as Thayers (more work, could be nice for grc if you choose to use it separately. However since that is not our purpose we will go another way.)
6. If they had matched it would be like

Code: Select all

UPDATE content SET data = ( data || (SELECT data FROM [grc.dct].content WHERE topic_id = [grc.dct].content.topic_id));

7. However they don't and Thayers has RTF } at the end.
A. We need to remove the }
B. We need to match based off of the subjects that are the same not the topic_ids
C: Add back }

I'll add more in next post Lord willing.

[jonathangkoehn]

Problem A: Solution
It appears in Thayers that } is the last character in the data column of table content.
So we can use this SQL

Code: Select all

UPDATE content SET data = trim(data, '}');

This explains trim more: https://www.w3resource.com/sqlite/core- ... s-trim.php

[jonathangkoehn]

Since we removed } and grc does not appear to have much RTF we will have to add } back later on after we get the data merged.
We will return to this later.

[jonathangkoehn]

Problem B:
We need to Match Thayer and grc subject and get the data from the contents.

We already can merge the data from each one. Thanks to Rubio we have various changes to make it work.

Code: Select all

UPDATE content AS c1 SET data = ( c1.data || (SELECT c2.data FROM [grc.dct].content AS c2, [grc.dct].topics AS t2 WHERE c2.topic_id = t2.id  AND t2.subject = (SELECT subject FROM topics AS t3 WHERE t3.id = c1.topic_id)));

Thanks Rubio for the help


Problem C:
Adding back the }

Code: Select all

UPDATE content set data = ( data || '}');

Problem D:
The greek in GRC is different than \u#### code so it won't come up right. However the concordance entries still are there. Perhaps the rtf header can be changed.

[jonathangkoehn]

Also don't forget to update the name, and delete the tables:
topics_wordindex
content_search

[malayangbiblia]

Also don't forget to update the name, and delete the tables:
topics_wordindex
content_search

I tried it and it worked, but only for some entries. I'm not sure why.

[jonathangkoehn]

Please explain a bit more. How did it now work?
It didn't copy them?
They are not displaying?
They are displaying incorrectly?

Thank you