Making a collection from books listed in concordance under "works cited"

Bernhard
Bernhard Member Posts: 662 ✭✭
edited November 21 in English Forum

I had asked this question here: https://community.logos.com/forums/p/65323/1314476.aspx#1314476 , but I wondered if I can increase my chance of finding a solution by opening a new thread.

I would like to tag all books that are included in the "index of Bible studies" that I have created by using the tool Richard offers in the thread above.

In the concordance tool, I can get a list of works cited in the resulting PB. But how can I use this information to tag the books and/or make a collection? There does not seem to be any way to do that inside Logos. Or can you think of one?

I have experimented a bit with using the export function and trying to convert the information to a search string for a collection. But I have hit several roadblocks on the way, among them were deficiencies in the citation style used in the concordance (for example, commas used between last and first name of the author, but at the same also between several authors - why is this different than in a Bibliography document?). 

Tagged:

Comments

  • NB.Mick
    NB.Mick MVP Posts: 15,973

    Bernhard said:

    In the concordance tool, I can get a list of works cited in the resulting PB. But how can I use this information to tag the books and/or make a collection? There does not seem to be any way to do that inside Logos. Or can you think of one?

    No, the concordance is a crazy powerful tool but it is bad at exporting the results in a meaningful way. 

    I have no idea where, but I think the lastrun concordances are stored someplace, and I would guess that in reality the list stores book-IDs (LLS:xxxxxxx). I would also gues that collections (at least the "plus-books) are stored in that same format, so it might be possible for a SQL coder to extract that info from the concordance and put it into a collection within the database. I'm not suggesting people should do that, it's just what my brain comes up with. Easier than to work with the concordance might be to simply fetch the LLS codes from the word document (some macro or tool to extract those from the L4 links in the PB source, then removing duplicates should also give that nice list of >2500 books).

    The manual way would be to open the library, sort by author, locate the books from the concordance list by headings which is sorted by author, and drag them over one by one (those you own) - in a shared collection others could do the same for remaining titles they own, if you keep a google doc or something like that to tick off the books. It's quite a bit of work this way. 

    Have joy in the Lord! Smile

  • Bernhard
    Bernhard Member Posts: 662 ✭✭

    NB.Mick said:

    Easier than to work with the concordance might be to simply fetch the LLS codes from the word document (some macro or tool to extract those from the L4 links in the PB source, then removing duplicates should also give that nice list of >2500 books).

    Good pointers. Getting into SQL seems too much for me at this point. Isolating the LLS codes from the docx would be quite straight forward, but where to go from there? Those codes seem to work in the go box, but neither in a library search nor in the collection tool.

  • Bernhard
    Bernhard Member Posts: 662 ✭✭

    Bernhard said:

    Isolating the LLS codes from the docx would be quite straight forward, but where to go from there?

    I think I have found a solution by having Excel looking up the details of the book in an XML-export of my library. I just need to make Excel then build me the appropriate search string to use. I'll keep you posted.

  • Bernhard
    Bernhard Member Posts: 662 ✭✭

    Bernhard said:

    I think I have found a solution by having Excel looking up the details of the book in an XML-export of my library. I just need to make Excel then build me the appropriate search string to use. I'll keep you posted.

    I have posted a link to my Excel file that can build a search string to help with tagging (and making a collection) here:  https://community.logos.com/forums/p/65323/1315717.aspx#1315717