Jump to content

Please read the Forum Rules before posting.

Photo
- - - - -

Accessing .dctx file through VBA


  • Please log in to reply
4 replies to this topic

#1 diakonos1984

diakonos1984

    New to Bible Support

  • Members
  • Pip
  • 4 posts
Offline

Posted 05 March 2018 - 04:20 AM

I am in the middle of a heavy word study project.  I know e-Sword is not the best software for heavy analytical word studies, but it's free and I like free, so I am trying to work with it.

 

I have already written some MS Word and Excel macros to analyze ALL of the Psalms of David and extract word counts.  The result is an Excel table with the English words and the Strong's Numbers for the Hebrew words with a count of their frequency.  The next step would be to add a column listing the Strong's definition for each of the Strong's Numbers.  With a small project/passage, I would just do this manually, but in analyzing ALL of the Psalms of David I have a list of over 1500 unique Strong's Numbers, and manual analysis is out of the question for all but the most frequenty used words.

 

My thought is to convert the StrongsPlus.dctx module to a format that is readable by Excel VBA and write an Excel macro to extract definitions from appropriate Strong's Numbers.  (I would rather use the NASEC dictionary for several reasons, but it appears to be hidden behind licensing).  Having no prior experience with e-Sword ToolTip Tool NT, my thought is to use it to convert the .dctx module back to an .rtf or something similar that I can process with Excel VBA.

 

And that back-conversion is where I am stuck.

Following the manual for ToolTip Tool, I have run the "Tooltip Existing DCTX File" command, which makes a copy of the file, and names it StrongsPlus_t3.dctx.

I then ran the "Read Dictionary File - Single Block" command on that copy, and I get the error "Error in text filter: Unknown format. (1-1d01)" once at the beginning of the process and once at the end. The resulting document looks like this:

 

 

 

#define description=Strong's Hebrew and Greek Dictionaries

#define abbreviation=Strong+

#define comments=#define version=2

#define strong=1

 

 

 

Because the manual for ToopTip Tool says most errors are related to modules being too large, I split the dictionary into 20 modules, but still get the same error.

 

I tried this process with strong.dctx, but it's locked.

Two questions:

1) Any ideas on what I am doing wrong to get this dictionary converted?

2) Any ideas on a better way to go about this whole project?

Grace and peace.


Edited by diakonos1984, 05 March 2018 - 04:21 AM.


#2 diakonos1984

diakonos1984

    New to Bible Support

  • Members
  • Pip
  • 4 posts
Offline

Posted 10 March 2018 - 12:15 PM

Anybody?



#3 Katoog

Katoog

    e-Sword Fanatic

  • Members (T)
  • PipPipPipPipPip
  • 789 posts
Online

Posted 10 March 2018 - 12:35 PM

Try those parameters for e-Sword 10:

#define description=Strong's Hebrew and Greek Dictionaries
#define abbreviation=Strong+
#define comments=CMTS
#define version=3
#define strong=1
#define nosort=0
รท
 


Edited by Katoog, 10 March 2018 - 12:36 PM.

Restored Holy Bible(8.0) and the Restored Textus Receptus

http://rhb.altervista.org/homepage.htm


#4 Tj Higgins

Tj Higgins

    e-Sword Fanatic

  • Members
  • PipPipPipPipPip
  • 429 posts
Offline

Posted 10 March 2018 - 12:51 PM

First make sure you have the latest version of Tooltip installed.

You did not need to use the "Tooltip Existing DCTX.file" option using this overwrote your original dictionary file so you will need to reinstall the original dictionary module. 

Once the dictionary module is reinstalled, all you have to do is select "Read Dictionary File - single block" this will open the e-Sword folder on your computer which will show you all of the installed dictionary modules. Find the dictionary module and select it to be read by ToolTip. 

Licensed modules cannot not be read into Tooltip, so as long as the module is not licensed Tooltip will open it. 

 

When you get the dictionary file open in Tooltip, you will then click File on the Tooltip Menu and then Save from the file menu to save the file in RTF format


Edited by Tj Higgins, 10 March 2018 - 01:16 PM.


#5 diakonos1984

diakonos1984

    New to Bible Support

  • Members
  • Pip
  • 4 posts
Offline

Posted 05 April 2018 - 05:00 AM

Finally got around to this today...

 

 

First make sure you have the latest version of Tooltip installed.

 

Apparently that was the issue!  We're in!  Thanks for your help!






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users




Similar Topics



Latest Blogs