Jump to content

diakonos1984

Member Since 19 Sep 2015
Offline Last Active Aug 17 2023 07:50 PM
-----

#33260 Accessing .dctx file through VBA

Posted by diakonos1984 on 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!




#32924 Accessing .dctx file through VBA

Posted by diakonos1984 on 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.