Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 02-10-2012, 05:51 PM   #1
read113
Junior Member
read113 began at the beginning.
 
Posts: 5
Karma: 10
Join Date: Jan 2012
Device: none
Question Using Calibre to catalog AudioBooks

I have about 200 audiobooks I would love to put into Calibre but is very manual intensive.

I first create and .m3U for the audiobook then add that to Calibre.

I have installed the "Read mp3 Audiobook metadata" Plugin but I'm not using it right or creating my m3u files so the plugin can read it. I still have to basically manual update the metadata.

Is there a way to import a list of my books in some format that will update better?

All help will be greatly appreciated.

Last edited by read113; 02-10-2012 at 05:54 PM. Reason: bad spellig
read113 is offline   Reply With Quote
Old 02-12-2012, 07:58 AM   #2
transmitthis
Addict
transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.
 
transmitthis's Avatar
 
Posts: 285
Karma: 1003542
Join Date: May 2011
Device: Google Nexus 7 16GB
http://hangvogel.hypermart.net/txt2fil/
Would that help
Then just import the empty txtfiles and update metadata in bulk, maybe add a custom column with a checkbox to denote they are audio files.

edit - changed link to better one, there are many programs that will do same

Last edited by transmitthis; 02-12-2012 at 08:08 AM.
transmitthis is offline   Reply With Quote
Old 02-17-2012, 11:14 AM   #3
read113
Junior Member
read113 began at the beginning.
 
Posts: 5
Karma: 10
Join Date: Jan 2012
Device: none
Do not understand how this would work?

transmitthis; Thank you for your help but I don't see how this works. I followed your link and understand how to created empty files, but how would you import them and get them to run a m3u file.
read113 is offline   Reply With Quote
Old 02-17-2012, 12:17 PM   #4
theducks
Grand Sorcerer
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 14,633
Karma: 5628865
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Maybe you can get Kiwidude to allow Openwith PI to launch your favorite media player for type m3u

for unknown (book) types , could Openwith just call the OS default handler as a "use OS default" for the program
theducks is offline   Reply With Quote
Old 04-10-2012, 05:32 PM   #5
holmgren
Junior Member
holmgren began at the beginning.
 
Posts: 2
Karma: 10
Join Date: Jul 2008
Device: nook simple
Quote:
Originally Posted by transmitthis View Post
http://hangvogel.hypermart.net/txt2fil/
Would that help
Then just import the empty txtfiles and update metadata in bulk, maybe add a custom column with a checkbox to denote they are audio files.

edit - changed link to better one, there are many programs that will do same
I have my list of audiobooks in a text file and need to create a file for each one to add it to Calibre. That program does exactly what I need but is $38 and I only need to use it once. (The shareware version only allows 4 or 5 files to be created). I spent a long time looking for a free program and can't find one. I did find references to making your own .vbs file using fso 'create file', but it's just a little over my head (or maybe a lot) and I can't make it work. Any other/cheaper solutions?

Thanks a lot.
Mary H.
holmgren is offline   Reply With Quote
Old 04-12-2012, 07:09 PM   #6
transmitthis
Addict
transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.
 
transmitthis's Avatar
 
Posts: 285
Karma: 1003542
Join Date: May 2011
Device: Google Nexus 7 16GB
Hi Mary,
Below is the relevant post from this thread http://www.mobileread.com/forums/sho...d.php?t=168064

Just as an update, here is an easy way to do this, instead of messing about with other programs or cmd.

Create a new folder called test in C:\
open your list in excel - see image
Alt+F11 to open up the VBA editor.
Select insert Module - In the box add this code
Code:
Sub Test()
For N = 1 To Cells(Rows.Count, 1).End(xlUp).Row
    Open "C:\temp\" & Cells(N, 1) & ".txt" For Output As #1
    Close #1
Next N
End Sub
switch back to sheet, Alt+F11 (or close editor)
Click on view then macros, and run it

Go to that test folder you created, and you will see its full of txt files (all named from each cell ready for you to add to calibre



Don't ask me about the code, as I just edited some I found, (as you do) and don't fully understand it.

one tip, just use alphanumeric . and - are ok, but dont have a ":" in the text




Oh - while I'm here:
This is probably relevent to anyone coming here from a search
Create File list from folder structure ie Text list of Folders
Quote:
1. run cmd
2. cd to the folder you want the list of (Type CD then space then the folder, for example "CD C:\Storage\BFG\Allthefiles\
3. paste this no quotes "dir /b /s > c:\filelist.txt" then enter
4. list is in c:\filelist.txt

remove the /s if you don't want subdirectories
(PS - send me the txt list if you want and I'll do it for you, then you will only have to do new purchases as you get them)

Last edited by transmitthis; 04-12-2012 at 07:16 PM.
transmitthis is offline   Reply With Quote
Old 04-13-2012, 09:05 AM   #7
JCSullivan
Chief Inspector Gamache
JCSullivan began at the beginning.
 
JCSullivan's Avatar
 
Posts: 123
Karma: 12
Join Date: May 2010
Location: Canada eh!
Device: Viewsonic
@transmitthis

Thanks for the info but I'm missing something - how would you add this to Calibre?

Thanks
JCSullivan is offline   Reply With Quote
Old 04-13-2012, 04:16 PM   #8
transmitthis
Addict
transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.
 
transmitthis's Avatar
 
Posts: 285
Karma: 1003542
Join Date: May 2011
Device: Google Nexus 7 16GB
@JCSullivan Just drag the txt files to main calibre window

The above will get you txt files to add empty book records, you can then get the metadata for them, automatically as normal

Then you create another entry, by making a m3u file of items you want in your VLC player or whatever you use.

Put the m3u playlist file on desktop and just drag it to calibre's main window, check it works, by clicking on the coverview image.

Now you just have to merge the two entries - ie keep the metadata from one and the shortcut from the other - simple (click on the metadata rich entry then ctrclick on the on the m3u entry, press ALT+Shift+M)

For audiobooks, I just have a checkmark column instead - but I use this method for Video playback of series I have kept as it's really useful.
Just click on the image and the series opens up in the player. You can also use it for URL's, to open sites etc.



Probably not explained it very well.

Last edited by transmitthis; 04-13-2012 at 05:20 PM.
transmitthis is offline   Reply With Quote
Old 04-13-2012, 07:39 PM   #9
holmgren
Junior Member
holmgren began at the beginning.
 
Posts: 2
Karma: 10
Join Date: Jul 2008
Device: nook simple
transmitthis
thank you for your reply. But, my audiobook folders are named rather sloppily, like
agatha christie - murder on orient express
agatha christie - partners in crime
and then some have years and series names. No way to import it neatly into excel columns. But I did finally come up with a solution. Elegant it isn't!

Use Karen's directory printer freeware (or something) to generate a text file of folder names only.

agatha christie - murder on orient express
agatha christie - partners in crime


Using Notepad++
hold Alt key down and click/drag mouse in a straight line down in front of the first character in each line. That will leave you with a long skinny cursor blinking.

Type these letters: type nul>"
They will magically appear in front of each line.

type nul>"agatha christie - murder on orient express
type nul>"agatha christie - partners in crime


Then, click edit/select all
then search/replace
on the replace tab enter (.)$ in the find what window and
\1.txt" in the replace with window

In the middle of that tab, put a check mark by In Selection and
at the bottom check the button in front of regular expression.
Click Replace all.

type nul>"agatha christie - murder on orient express.txt"
type nul>"agatha christie - partners in crime.txt"


Now insert as a first line:
@echo off

and I put a last line with the word pause so the cmd window won't close and I can read error messages if any. Save the file with a .bat extension (make sure to select "all" in the drop down box by "save as type". )

@echo off

type nul>"agatha christie - murder on orient express.txt"
type nul>"agatha christie - partners in crime.txt"

pause


Put this file in a folder by itself, double click to run and all the text files should appear in that same folder.

Then you can add them all to Calibre.

This probably looks atrocious to anybody with a lick of programming skills. But I was very proud of myself for figuring it out.

Mary H.
holmgren is offline   Reply With Quote
Old 04-14-2012, 02:32 AM   #10
JCSullivan
Chief Inspector Gamache
JCSullivan began at the beginning.
 
JCSullivan's Avatar
 
Posts: 123
Karma: 12
Join Date: May 2010
Location: Canada eh!
Device: Viewsonic
Quote:
Originally Posted by transmitthis View Post
just drag it to calibre's main window.
Thanks for the trouble of getting a screen shot and the help - it is appreciated.

Telling me I can drag and drop has made it a lot easier.

If you're confident with a expressions can you help with this - I'm trying to get the expression to ignore anything before the author's name.

Thanks
Attached Thumbnails
Click image for larger version

Name:	calibre001.gif
Views:	194
Size:	32.2 KB
ID:	85250  
JCSullivan is offline   Reply With Quote
Old 04-15-2012, 01:38 PM   #11
transmitthis
Addict
transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.
 
transmitthis's Avatar
 
Posts: 285
Karma: 1003542
Join Date: May 2011
Device: Google Nexus 7 16GB
Not sure what you did there Mary, but glad it worked out for you, you could probably have done it easily via dos tree Directory command, and then use the extensive sorting you can do in excel

But that don't really matter as long as you got it done, and bonus learn't a lot doing it too - congrats

@JC - sorry I'm just not confident with expressions, I have a few python books to read but their at the end of my reading list. Ask in a new thread, and you will get noticed and sorted I'm sure.
transmitthis is offline   Reply With Quote
Old 04-17-2012, 03:47 AM   #12
JCSullivan
Chief Inspector Gamache
JCSullivan began at the beginning.
 
JCSullivan's Avatar
 
Posts: 123
Karma: 12
Join Date: May 2010
Location: Canada eh!
Device: Viewsonic
Thanks transmitthis, I've done that.
JCSullivan is offline   Reply With Quote
Reply

Tags
audiobooks, mp3

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Audiobooks saved in Calibre prsnrs Calibre 0 11-08-2011 12:36 PM
Calibre catalog format skipray Library Management 1 02-17-2011 01:10 AM
Calibre as Catalog? jekkii Library Management 11 01-08-2011 12:15 PM
Problem with Catalog in Calibre clockmaker Library Management 1 10-05-2010 06:27 AM
Classic Trook Catalog and Calibre jhempel24 Nook Developer's Corner 2 09-06-2010 11:56 PM


All times are GMT -4. The time now is 11:03 PM.


MobileRead.com is a privately owned, operated and funded community.