Quote:
Originally Posted by GatorDeb
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