Question about metadata from filenames

alex_s · 07-24-2015, 04:15 PM

Hi! It's my first time posting here so I apologize in advance if this is not the correct place to post this.
I have a big collection of book having the following filename format:
<author last name>, <first name> - <title>.

Can someone tell me or give me a hint how can I add the book in the calibre library and make it extract the author name and title correctly (author = first name last name and author sort = last, first).
Thank you!

eschwartz · 07-24-2015, 06:20 PM

I assume the embedded metadata is not correct?

Preferences ==> Adding books
Uncheck "Read metadata from file contents rather than file name"

Second half of the screen, "Configure metadata from file name", will allow you to use a regular expression to match the metadata.

The default is:

Code:

(?P<title>.+) - (?P<author>[^_]+)

You probably want:

Code:

(?P<author_sort>[^_]+) - (?P<title>.+)

EDIT: Arghhhh! Doesn't look like it recognizes "author_sort"...

You may just have to rename the files using a bulk file renamer to swap the "LN, FN" to "FN LN".
Or use the Quality Check plugin to set the author from the author_sort, after importing.

Either way, use the regex:

Code:

(?P<author>[^_]+) - (?P<title>.+)

alex_s · 07-24-2015, 06:38 PM

Thanks a lot! QC plugin is great. I'll just add them as they are and then swap with the plugin. Thanks again

eschwartz · 07-24-2015, 06:41 PM

Happy to help.

theducks · 07-24-2015, 07:23 PM

In addition to the Pattern by eschwartz

Preference: Adding Books: <top right> (Change the state of the tick if needed) Swap Author First and Last

eschwartz · 07-26-2015, 10:49 PM

Well, now, you'd think I'd notice something like that.

theducks · 07-26-2015, 11:25 PM

Quote:

Originally Posted by eschwartz

Well, now, you'd think I'd notice something like that.

It hides under the Mouse pointer all the time. I 'KNOW' a setting is there somewhere, I just can't seem to find it when I look... until... I move the mouse to leave the form

BetterRed · 07-27-2015, 03:22 AM

Quote:

Originally Posted by theducks

It hides under the Mouse pointer all the time. I 'KNOW' a setting is there somewhere, I just can't seem to find it when I look... until... I move the mouse to leave the form

my mouse pointer positions itself over the greyed out Apply Button (which is the default 'OK' button) - just like all well behaved Windows programs do

BR

eschwartz · 07-27-2015, 03:48 AM

My mouse pointer points to wherever I put it. (Yes, even on the odd occasion I use Windows. I would notice unusual behavior like that.)

Isn't there a setting that makes it snap to the confirmation button?

BetterRed · 07-27-2015, 07:55 AM

Quote:

Originally Posted by eschwartz

Isn't there a setting that makes it snap to the confirmation button?

Of course, puzzled why 4 the ducks it lands on the swap names checkbox - maybe it's made from cheese

theducks · 07-27-2015, 09:41 AM

Quote:

Originally Posted by BetterRed

my mouse pointer positions itself over the greyed out Apply Button (which is the default 'OK' button) - just like all well behaved Windows programs do

BR

I believe that is a 3rd party (driver) feature, snap to default

Dell Mouse on XP where you left it. Kensington Expert Mouse Pro (early 10 button version) on same, Snaps to button

Logitec mouse on W7, where I left it
(there is no Expert Mouse Pro specific driver for W7. uses Generic Wheel Mouse)

eschwartz · 07-27-2015, 10:14 AM

Quote:

Originally Posted by BetterRed

Of course, puzzled why 4 the ducks it lands on the swap names checkbox - maybe it's made from cheese

Perhaps it was a joke about how the mouse always manages to coincidentally be in the worst place.

MartyTX · 07-27-2015, 10:16 AM

Quote:

Originally Posted by theducks

I believe that is a 3rd party (driver) feature, snap to default

Dell Mouse on XP where you left it. Kensington Expert Mouse Pro (early 10 button version) on same, Snaps to button

Logitec mouse on W7, where I left it
(there is no Expert Mouse Pro specific driver for W7. uses Generic Wheel Mouse)

Another big player in the mouse game is Microsoft:
Comes with "IntelliPoint" driver that has "snap to" option: "Automatically move pointer to the default button in a dialog box".

Works with XP and Vista. Other devices in house are mouseless laptops on W7 and W8; don't know about Microsoft compatibility with them.

theducks · 07-27-2015, 10:20 AM

Quote:

Originally Posted by eschwartz

Perhaps it was a joke about how the mouse always manages to coincidentally be in the worst place.

That one

I tend to move my mouse to the right to get it out of the text.

FWIW I also moved the commonly use button (menu) bars in Sigil and the calibre-viewer to the right edge so I don't need to cross over

BetterRed · 07-27-2015, 05:51 PM

I use a $2 generic mouse (looks like a VeeDub beetle) with the out-of-the box driver, cp->mouse->pointer options->snap to is set, I also use the Cursor Hider gadget to auto-hide the pointer when its not needed.

But back on topic - that checkbox is easily missed, IMO it should align with the "Mark newly added books" checkbox, it's a bit like a shag on a rock out there in right field

07-24-2015, 04:15 PM	#1
alex_s Junior Member Posts: 2 Karma: 10 Join Date: Jul 2015 Device: Kindle	Question about metadata from filenames Hi! It's my first time posting here so I apologize in advance if this is not the correct place to post this. I have a big collection of book having the following filename format: <author last name>, <first name> - <title>. Can someone tell me or give me a hint how can I add the book in the calibre library and make it extract the author name and title correctly (author = first name last name and author sort = last, first). Thank you!

07-24-2015, 06:20 PM	#2
eschwartz Ex-Helpdesk Junkie Posts: 19,421 Karma: 85400180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	I assume the embedded metadata is not correct? Preferences ==> Adding books Uncheck "Read metadata from file contents rather than file name" Second half of the screen, "Configure metadata from file name", will allow you to use a regular expression to match the metadata. The default is: Code: (?P<title>.+) - (?P<author>[^_]+) You probably want: Code: (?P<author_sort>[^_]+) - (?P<title>.+) EDIT: Arghhhh! Doesn't look like it recognizes "author_sort"... You may just have to rename the files using a bulk file renamer to swap the "LN, FN" to "FN LN". Or use the Quality Check plugin to set the author from the author_sort, after importing. Either way, use the regex: Code: (?P<author>[^_]+) - (?P<title>.+) Last edited by eschwartz; 07-24-2015 at 06:25 PM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Readers, Filenames and Metadata	RedCanyoneer	General Discussions	36	09-16-2011 02:54 PM
Seriously, how to parse metadata from filenames	charlweed	Calibre	7	07-18-2011 01:58 PM
Filenames to metadata, preserving filenames.	nitrogun	Calibre	5	09-13-2010 10:50 PM
batch metadata editing possible from filenames?	caponesan	Reading and Management	3	09-03-2009 12:50 PM
libprs500 metadata from filenames	Dan23	Calibre	2	06-29-2008 06:04 PM

07-24-2015, 06:38 PM	#3
alex_s Junior Member Posts: 2 Karma: 10 Join Date: Jul 2015 Device: Kindle	Thanks a lot! QC plugin is great. I'll just add them as they are and then swap with the plugin. Thanks again

07-24-2015, 06:41 PM	#4
eschwartz Ex-Helpdesk Junkie Posts: 19,421 Karma: 85400180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	Happy to help.

07-24-2015, 07:23 PM	#5
theducks Well trained by Cats Posts: 31,047 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	In addition to the Pattern by eschwartz Preference: Adding Books: <top right> (Change the state of the tick if needed) Swap Author First and Last

07-26-2015, 10:49 PM	#6
eschwartz Ex-Helpdesk Junkie Posts: 19,421 Karma: 85400180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	Well, now, you'd think I'd notice something like that.

07-27-2015, 03:48 AM	#9
eschwartz Ex-Helpdesk Junkie Posts: 19,421 Karma: 85400180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	My mouse pointer points to wherever I put it. (Yes, even on the odd occasion I use Windows. I would notice unusual behavior like that.) Isn't there a setting that makes it snap to the confirmation button?

07-27-2015, 05:51 PM	#15
BetterRed null operator (he/him) Posts: 21,718 Karma: 29711016 Join Date: Mar 2012 Location: Sydney Australia Device: none	I use a $2 generic mouse (looks like a VeeDub beetle) with the out-of-the box driver, cp->mouse->pointer options->snap to is set, I also use the Cursor Hider gadget to auto-hide the pointer when its not needed. But back on topic - that checkbox is easily missed, IMO it should align with the "Mark newly added books" checkbox, it's a bit like a shag on a rock out there in right field

Advert

Advert