|09-25-2008, 11:54 PM||#1|
Join Date: Dec 2007
Location: Sin City
Device: PW2 + HDX 8.9
Is there a program that can read your book file names and make a list?
Let's say I have a folder with all my books, and they have the format Name - Author.prc. Is there a program that will grab that and import into a database automatically with an author and title field?
|09-26-2008, 02:57 AM||#3|
Join Date: May 2006
Device: PocketBook 360, before it was Sony Reader, cassiopeia A-20
If it is Windows do following:
Click on start menu
click on Run
into the text field and press enter.
Now use cd command to switch to the directory where your books are located
cd "C:\Documents and Settings"
(if your files are located no D: or other drive you have to type D: on the commandline first)
(use dir command or dir /w command to see the filenames)
cd "John Smith"
(you need to use quotes "" around the directory name if it contains spaces)
now when you are in the directory, type
dir > my_list_of_books.txt
Now edit your list of books in the text editor or use word processor to write a macro or use some search and replace magic.
If you use Linux or MacOSX you use command ls instead of dir
If you want the dir command to list also the files in your subdirectories, use
dir /s > my_list_of_books.txt
dir /s /b > my_list_of_books.txt
dir /? for other interesting options
(or man ls if you use linux or MacOSX)
If you are scarred to use commandline, install Totalcommander from
and install addon called
You can install the addon just by clicking on the zip file with addon in the TotalCommander
The resulting file can be imported to Excel or OpenOffice.org Calc
If you want to import plain text file into OpenOffice.org Calc call the file list_of_my_files_or_other_name.csv
|09-26-2008, 03:13 AM||#4|
Join Date: Aug 2008
Location: Bålsta, Sweden
Device: BeBook x 2 (Hanlin V3 rebrand), Samsung Omnia
This program prints the filenames
from your selected folder to a textfile, and then I import that file into Excel so I can delete unwanted data and sort on author/filename etc. That works due to the fact that I use a different directory for each author in the format Last Name, First Name and then put the books in there.
Link to dirprinting:
|09-26-2008, 06:50 AM||#5|
Join Date: Aug 2007
Device: iPad, Nexus4, OnePlusOne
I've been using this program LS File List Generator.
It's a small lightweight program which does not require any installation and allows you to generate the list as a Text, Csv or Html file.
The Html is really useful as it creates hyper links to the files itself so you can launch them easily.
I've had it in my digital toolkit for years.
The Only problem I ran into was finding a working mirror of it as the main authors site appears to have gone down.
You can find it here
|09-26-2008, 12:37 PM||#6|
Join Date: Jan 2007
Location: Tampa, FL USA
Device: Kindle Touch
You "may" be able to move this into mobipocket reader... not sure if you consider that a database.
EDIT: What exactly do you mean by a "database"?
|09-26-2008, 12:57 PM||#7|
creator of calibre
Join Date: Oct 2006
Location: Mumbai, India
calibre already can read metadata from file names in a customizable way. see the advanced section of the config dialog.
|Thread Tools||Search this Thread|
|Thread||Thread Starter||Forum||Replies||Last Post|
|How to make a PRC book file in Persian (Farsi)||golagha||iRex||7||01-29-2013 09:19 PM|
|Last read book on top of list||fidjit||Amazon Kindle||12||09-29-2010 07:39 PM|
|PB 360: display series and book # in metadata view of file list||mimosavj||PocketBook||4||05-02-2010 09:10 PM|
|iLiad which program make a new manifest.xml file?||harpum||iRex Developer's Corner||3||06-23-2009 09:45 AM|
|File Names||Vulcan||Sony Reader||4||01-02-2009 04:03 PM|