Quote:
Originally Posted by BetterRed
@DedTV - Suggestion
Have you considered using a copy of the calibre database «metadata.db» as a resource to assist you in getting the job done.
|
I used SQLite Admin to dump several tables to clean up titles and authors. I should have also used it to get the list of existing tags as it would have saved me a few minutes of removing the dupes.
If I knew SQL (or databases) better I could probably do a lot more to help myself but the limit of my "expertise" with SQL beyond simple SELECT queries is Googling to find a query that does what I need to do.
I'm even worse with Access and am only using it because I found a step by step guide to sorting a flatfile database into tables which works better than trying to do it with Excel as I was trying to do first.
Edit: Decided to play around with it and I've gotten close. The best I could do is get is (what I think is) the counts via a "select tag, count(*) from books_tags_link group by tag;" query but I haven't figured out how to link that up with a query to link it with the actual tag name.
Although, thinking about it, I could simply just export the tag table and the result of the query and match them up in Excel.
Yup. That worked!