How can you make a list of your Logos 4 library?
I want to make a list of my Logos 4 library and print it.
Comments
-
You can print a bibliography from the Collections window.
Here's how to make a collection of the entire library and print it:
http://wiki.logos.com/Bibliography#How_to_create_a_Bibliography_of_all_my_books
MacBook Pro (2019), ThinkPad E540
0 -
You probably need the list for a project, so the above bibliography approach is best.
But for anyone else, Mark Barnes' utility is really good:
http://www.4-14.org.uk/logos/logos4-bibliographic-reportHis puts it into an HTML view, which is really nice. I wanted to line them up for personal viewing, so I copies all the JPGs from Mark's output into an RTF file and then sorted for my own use (I'm getting non-young and can't remember exactly what I've got where). Both approaches are great
."If myth is ideology in narrative form, then scholarship is myth with footnotes." B. Lincolm 1999.
0 -
Thanks guys! I really appreciate your inputs :-)
0 -
Peace to all! *smile*
Is there a way to get my bibliography into an Excel file in the Excel columns?
Philippians 4: 4 Rejoice in the Lord always; again I will say, Rejoice. 5 Let your reasonableness be known to everyone. The Lord is at hand..........
0 -
Milford Charles Murray said:
Peace to all! *smile*
Is there a way to get my bibliography into an Excel file in the Excel columns?
Just use Mark's online tool, and download your list as a CSV (comma separated values) file. This can be opened in Excel, and formatted as needed.
"As any translator will attest, a literal translation is no translation at all."
0 -
Milford ... if you're super-lazy like me, you can also just export the collection out to the clipboard and then paste into Excel. Doesn't delimit it but the delimiters are not consistent anyway.
"If myth is ideology in narrative form, then scholarship is myth with footnotes." B. Lincolm 1999.
0 -
Milford Charles Murray said:
Is there a way to get my bibliography into an Excel file in the Excel columns?
Hi Milford,
There are 2 other ways to do this other than mentioned above:
1. You can use Print/Export from a collection in which you have added all resources, see this wiki page http://wiki.logos.com/Bibliography. If you use Copy to clipboard, then you can paste it into an Excel document.
2. Or you can get a Bibliography with most of the details for each book (e.g. Logos IDs, Dates, etc) by using SQLite Browser.
a. Open C:\Users\<User Name>\AppData\Local\Logos4\Data\<Random String>\LibraryCatalog\catalog.db via SQLite Browser.
1. Select the Browse Data tab
2. Then select Records table
3. Next click on File.
4. In the drop down click on Export
5. Then click on Table as CSV file.
6. In the pop-up window, select Records.
7. Then click on the Export button.8. Then you will be prompted for a file location & filename. Select where you want your CSV file saved.
b. Now you can open your CSV file via Excel. i generally delete several columns which i don't want and then rearrange the columns that are left. And then save the file as an Excel document.
EDIT: this method also shows books that you have hidden via Program Settings.
0 -
Paul and Denise and Steve! *smile*
You blow my mind! !!!! Thank you so much! Truly appreciated!
Now I have my work cut out for me.
Peace to all!
Philippians 4: 4 Rejoice in the Lord always; again I will say, Rejoice. 5 Let your reasonableness be known to everyone. The Lord is at hand..........
0 -
I nominate Steve to update the wiki with the browser method. Unless it's already there and I didn't see it. Great explanation.
"If myth is ideology in narrative form, then scholarship is myth with footnotes." B. Lincolm 1999.
0 -
Denise Barnhart said:
I nominate Steve to update the wiki with the browser method. Unless it's already there and I didn't see it.
Denise,
i have added a section in the Bibliography wiki page for alternate methods. It is probably best for the average user to use the tools that Logos has provided, so as to prevent some users from damaging their L4 install.
New wiki article: Other methods
0 -
Well-done! Steve, thank you; and we most certainly appreciate you even when we're not expressing it!
*smile*
Peace! and Joy Always!
Philippians 4: 4 Rejoice in the Lord always; again I will say, Rejoice. 5 Let your reasonableness be known to everyone. The Lord is at hand..........
0 -
Am I missing something here? I keep getting referred to these upcoming features of L4 but I can't find a mention anywhere of a simple citation feature that will be added. Does anyone know if there is actually something other than a 20 step process in the works?
0 -
Blair said:
Am I missing something here? I keep getting referred to these upcoming features of L4 but I can't find a mention anywhere of a simple citation feature that will be added. Does anyone know if there is actually something other than a 20 step process in the works?
Apologies - not understand reference to upcoming features of L4.
Observation: 20 step process includes creating a Collection (also useful for Passage Guide sections plus searching). Wiki has Example Collections
Once collection created, process becomes open Collection, Print/Export. then click Bibliography only, followed by choosing Print, Export, or Save As.
Have option to choose from 10 Citation styles (click on style for drop-down menu).
While reading a single resource, do have simple option for Citation by clicking (i):
Click Copy then paste citation:
Runge, S. E. (2010). A Discourse Grammar of the Greek New Testament: A Practical Introduction for Teaching and Exegesis. Bellingham, WA: Logos Research Systems, Inc.
Option: can click "APA Style (4th Ed)" for drop down list of 10 Citation styles. To return to resource, click Done.
Keep Smiling [:)]
0 -
Keep Smiling:
You've got me smiling.
Thanks.
0 -
I'm certain this is simple but I've had no success following Mark Barnes instructions. Can anyone walk me through it step by step?
0 -
Gregg Farah said:
I'm certain this is simple but I've had no success following Mark Barnes instructions. Can anyone walk me through it step by step?
Wiki has step by step example => http://wiki.logos.com/Bibliography#How_to_create_a_Bibliography_of_all_my_books
If have question(s) about step(s), please ask.
This forum thread includes more examples and discussions.
Keep Smiling [:)]
0 -
thanks for the reply, but I'm actually trying tofgure out the bib feature from mark barnes' website. thanks!
0 -
The sqlite thing could be improved into a small tool for viewing Logos4 catalog.db without breaking any data, I guess.
I am returning to this topic now that my two computers show difference in number of resources (2425 and 2424). I exported the library as TXT and will use windiff on the second machine later.
JesusChrist.ru - Russian Christian Portal, with free Bible software; Timh.ru - blog
0 -
Hey guys! I've used SQLite Browser to export my database into a CSV file... here's the question... I ESPECIALLY need this file to include the book's ISBN number, although I don't seem to see it... is it there somewhere and am I just missing it?
The reason I ask is because I use Library Express as my main library cataloguing program (because I also have many non-Logos books, naturally!) so they have told me they are able to import my Logos bibliography (I sent it to them as a BibTex file...). Great! This will save me having to manually enter 3940 books... [:|]
However, having the ISBN there as well will also allow me, once it has been imported, to simply click on a book and it will go update its information from the web, including book cover and description, so I won't have to do that either, but I need the CSV file to include the ISBN, see?
Can anyone help? THANKS! [H]
0 -
Hi Carmen
Carmen Gauvin-O'Donnell said:I ESPECIALLY need this file to include the book's ISBN number, although I don't seem to see it... is it there somewhere and am I just missing it?
Sorry, but Logos doesn't hold ISBN numbers.
Graham
0 -
Steve, I know that your post is old, but I have used it successfully in the past in order to create an excel spreadsheet with many more fields than the current Logos 5 bib. feature supports.
It worked fine with earlier files, and I can see the files fine on SQL Browser (one record per line), but when I export to the .csv format and then import from excel, each record is occupying about 6 rows of the spreadsheet! I am not sure if Logos's catalog.db file structure changed, or what happened, but it is very frustrating. as I have over 9000 books, manually getting rid of these extra rows would be a horrendous task.
Any ideas to suggest? Are you still using this method successfully? I want an updated list of resources, with all the fields that Logos stores in the catalog.db file that are helpful to me.
Thanks!
Todd
0 -
In 6.0, there is a new "Export" feature in the Library and Collections panels that can save to CSV.
We plan to bring that back to 5.2b also but it's not available there yet.
0 -
Great--thanks!
Will it include the information in the catalog.db file such as the series, etc.?
Hope so!
Todd
0 -
Todd Beall said:
Will it include the information in the catalog.db file such as the series, etc.?
Yes, it will include all that information.
0 -
Hi Todd,
Todd Beall said:Any ideas to suggest? Are you still using this method successfully? I want an updated list of resources, with all the fields that Logos stores in the catalog.db file that are helpful to me.
i have built a window's utility (LLR) which is free (see this forum post or just jump directly to the website). It will work fine with L4 & L5. It also allows you to list most of the useful fields in the catalog.db file (not all fields are really useful for us). The program will also generate a csv file which can be read directly into Excel (which sounds like what you are looking for).
Bradley's suggestion will work also when Logos (Faithlife) finishes their update for L5. So you could wait until then or in the mean time try my utility.
If you have any questions about LLR, please drop me an email (per the forum post mentioned above).
0 -
Ok, I have upgraded to 6, and I don't see that option. "save to CSV." Perhaps I am looking in the wrong place. I created a bibliography of all my works, then went to the print/export option, where I see the same options as in Logos 5: rtf, text, html, XPS, Bibtex, refer/bib, RTS, and Word. Am I looking in the wrong place?
Thanks!
0 -
Todd Beall said:
Ok, I have upgraded to 6, and I don't see that option. "save to CSV." Perhaps I am looking in the wrong place. I created a bibliography of all my works, then went to the print/export option, where I see the same options as in Logos 5: rtf, text, html, XPS, Bibtex, refer/bib, RTS, and Word. Am I looking in the wrong place?
Thanks!
No need to create a bibliography first. Simply open your library, click the book icon next to the word library, click print/export in the dropdown, in the print/export screen choose save as file: spreadsheet located on the right hand side, in the save as dialogue box choose save as Excel or CSV and a location of course. That’s all there is to it. Good luck!
And thank you for asking the question because I didn't realize we could do this now. [:)]
Logos Series X Pastor’s Library | Logos 3 Leader’s Library | 4 Portfolio | 5 Platinum | 6 Feature Crossgrade | 7 Essential | 8 M & W Platinum and Academic Professional | 9 Academic Professional and Messianic Jewish Diamond
0 -
Ah...now I see it! Odd that the print/export options are different on this page than on the bibliography page, but I am not complaining!
Thanks!
Todd
0
