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.
Anyway to combine these modules into one *.twm? [SOLVED]
-
- Posts: 74
- Joined: Wed Dec 19, 2018 9:27 am
- Location: Philippines
- Contact:
Anyway to combine these modules into one *.twm? [SOLVED]
- Attachments
-
- Thayer.JPG (88.67 KiB) Viewed 4395 times
-
- GRC.JPG (84.45 KiB) Viewed 4395 times
Last edited by malayangbiblia on Thu Mar 28, 2019 3:21 pm, edited 1 time in total.
Edmund
- jonathangkoehn
- Posts: 1261
- Joined: Wed Sep 29, 2010 11:04 pm
- Location: Colorado, United States
- Contact:
Re: Anyway to combine these modules into one *.twm?
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.
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.
Jonathan Koehn @ https://www.thewordbooks.com
TotheWord make resources for theWord
2 Timothy 2:15 “Make every effort to present yourself before God as a proven worker who does not need to be ashamed, teaching the message of truth accurately.” NET2
TotheWord make resources for theWord
2 Timothy 2:15 “Make every effort to present yourself before God as a proven worker who does not need to be ashamed, teaching the message of truth accurately.” NET2
-
- Posts: 74
- Joined: Wed Dec 19, 2018 9:27 am
- Location: Philippines
- Contact:
Re: Anyway to combine these modules into one *.twm?
They are both not encrypted.jonathangkoehn wrote: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.
Edmund
- jonathangkoehn
- Posts: 1261
- Joined: Wed Sep 29, 2010 11:04 pm
- Location: Colorado, United States
- Contact:
Re: Anyway to combine these modules into one *.twm?
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.
Jonathan Koehn @ https://www.thewordbooks.com
TotheWord make resources for theWord
2 Timothy 2:15 “Make every effort to present yourself before God as a proven worker who does not need to be ashamed, teaching the message of truth accurately.” NET2
TotheWord make resources for theWord
2 Timothy 2:15 “Make every effort to present yourself before God as a proven worker who does not need to be ashamed, teaching the message of truth accurately.” NET2
-
- Posts: 74
- Joined: Wed Dec 19, 2018 9:27 am
- Location: Philippines
- Contact:
Re: Anyway to combine these modules into one *.twm?
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.jonathangkoehn wrote: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.
Edmund
Re: Anyway to combine these modules into one *.twm?
I ask because of my curiosity has got the best of me but what is "The Flash"?malayangbiblia wrote:without asking the help of 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.
-
- Posts: 191
- Joined: Fri Aug 13, 2010 10:12 am
Re: Anyway to combine these modules into one *.twm?
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.RevSteve wrote:I ask because of my curiosity has got the best of me but what is "The Flash"?malayangbiblia wrote:without asking the help of The Flash?
(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.")
-
- Posts: 74
- Joined: Wed Dec 19, 2018 9:27 am
- Location: Philippines
- Contact:
Re: Anyway to combine these modules into one *.twm?
You got it bro! Hahahaha....and my kids love it! I hope that SQL script can work just like the Flash...Lol.NorrinRadd wrote: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.RevSteve wrote:I ask because of my curiosity has got the best of me but what is "The Flash"?malayangbiblia wrote:without asking the help of The Flash?
(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.")
Edmund
- jonathangkoehn
- Posts: 1261
- Joined: Wed Sep 29, 2010 11:04 pm
- Location: Colorado, United States
- Contact:
Re: Anyway to combine these modules into one *.twm?
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
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.
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));
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.
Last edited by jonathangkoehn on Sat Mar 23, 2019 10:30 pm, edited 1 time in total.
Jonathan Koehn @ https://www.thewordbooks.com
TotheWord make resources for theWord
2 Timothy 2:15 “Make every effort to present yourself before God as a proven worker who does not need to be ashamed, teaching the message of truth accurately.” NET2
TotheWord make resources for theWord
2 Timothy 2:15 “Make every effort to present yourself before God as a proven worker who does not need to be ashamed, teaching the message of truth accurately.” NET2
- jonathangkoehn
- Posts: 1261
- Joined: Wed Sep 29, 2010 11:04 pm
- Location: Colorado, United States
- Contact:
Re: Anyway to combine these modules into one *.twm?
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
This explains trim more: https://www.w3resource.com/sqlite/core- ... s-trim.php
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, '}');
Jonathan Koehn @ https://www.thewordbooks.com
TotheWord make resources for theWord
2 Timothy 2:15 “Make every effort to present yourself before God as a proven worker who does not need to be ashamed, teaching the message of truth accurately.” NET2
TotheWord make resources for theWord
2 Timothy 2:15 “Make every effort to present yourself before God as a proven worker who does not need to be ashamed, teaching the message of truth accurately.” NET2
- jonathangkoehn
- Posts: 1261
- Joined: Wed Sep 29, 2010 11:04 pm
- Location: Colorado, United States
- Contact:
Re: Anyway to combine these modules into one *.twm?
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.
We will return to this later.
Jonathan Koehn @ https://www.thewordbooks.com
TotheWord make resources for theWord
2 Timothy 2:15 “Make every effort to present yourself before God as a proven worker who does not need to be ashamed, teaching the message of truth accurately.” NET2
TotheWord make resources for theWord
2 Timothy 2:15 “Make every effort to present yourself before God as a proven worker who does not need to be ashamed, teaching the message of truth accurately.” NET2
- jonathangkoehn
- Posts: 1261
- Joined: Wed Sep 29, 2010 11:04 pm
- Location: Colorado, United States
- Contact:
Re: Anyway to combine these modules into one *.twm?
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.
Thanks Rubio for the help
Problem C:
Adding back the }
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.
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 || '}');
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.
Last edited by jonathangkoehn on Sun Mar 24, 2019 12:06 am, edited 2 times in total.
Jonathan Koehn @ https://www.thewordbooks.com
TotheWord make resources for theWord
2 Timothy 2:15 “Make every effort to present yourself before God as a proven worker who does not need to be ashamed, teaching the message of truth accurately.” NET2
TotheWord make resources for theWord
2 Timothy 2:15 “Make every effort to present yourself before God as a proven worker who does not need to be ashamed, teaching the message of truth accurately.” NET2
- jonathangkoehn
- Posts: 1261
- Joined: Wed Sep 29, 2010 11:04 pm
- Location: Colorado, United States
- Contact:
Re: Anyway to combine these modules into one *.twm?
Also don't forget to update the name, and delete the tables:
topics_wordindex
content_search
topics_wordindex
content_search
Jonathan Koehn @ https://www.thewordbooks.com
TotheWord make resources for theWord
2 Timothy 2:15 “Make every effort to present yourself before God as a proven worker who does not need to be ashamed, teaching the message of truth accurately.” NET2
TotheWord make resources for theWord
2 Timothy 2:15 “Make every effort to present yourself before God as a proven worker who does not need to be ashamed, teaching the message of truth accurately.” NET2
-
- Posts: 74
- Joined: Wed Dec 19, 2018 9:27 am
- Location: Philippines
- Contact:
Re: Anyway to combine these modules into one *.twm?
I tried it and it worked, but only for some entries. I'm not sure why.jonathangkoehn wrote:Also don't forget to update the name, and delete the tables:
topics_wordindex
content_search
Edmund
- jonathangkoehn
- Posts: 1261
- Joined: Wed Sep 29, 2010 11:04 pm
- Location: Colorado, United States
- Contact:
Re: Anyway to combine these modules into one *.twm?
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
It didn't copy them?
They are not displaying?
They are displaying incorrectly?
Thank you
Jonathan Koehn @ https://www.thewordbooks.com
TotheWord make resources for theWord
2 Timothy 2:15 “Make every effort to present yourself before God as a proven worker who does not need to be ashamed, teaching the message of truth accurately.” NET2
TotheWord make resources for theWord
2 Timothy 2:15 “Make every effort to present yourself before God as a proven worker who does not need to be ashamed, teaching the message of truth accurately.” NET2