View Single Post
Old 09-26-2008, 02:57 AM   #3
kacir
Wizard
kacir ought to be getting tired of karma fortunes by now.kacir ought to be getting tired of karma fortunes by now.kacir ought to be getting tired of karma fortunes by now.kacir ought to be getting tired of karma fortunes by now.kacir ought to be getting tired of karma fortunes by now.kacir ought to be getting tired of karma fortunes by now.kacir ought to be getting tired of karma fortunes by now.kacir ought to be getting tired of karma fortunes by now.kacir ought to be getting tired of karma fortunes by now.kacir ought to be getting tired of karma fortunes by now.kacir ought to be getting tired of karma fortunes by now.
 
kacir's Avatar
 
Posts: 3,412
Karma: 8096045
Join Date: May 2006
Device: PocketBook 360, before it was Sony Reader, cassiopeia A-20
Quote:
Originally Posted by GatorDeb View Post
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?

Thanks!
What operating system do you use?

If it is Windows do following:
Click on start menu
click on Run
type:
cmd
into the text field and press enter.

Now use cd command to switch to the directory where your books are located
Like this
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"
cd books
(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
or
dir /s /b > my_list_of_books.txt

see
dir /? for other interesting options
(or man ls if you use linux or MacOSX)

If you are scarred to use commandline, install Totalcommander from
http://www.ghisler.com/
and install addon called
Catalog
or
DiskDir
or
DiskDir Extended
from
http://www.ghisler.com/plugins.htm
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
kacir is offline   Reply With Quote