Database of documents: how?

Business software, financial software, etc.
Post Reply
Message
Author
firak
Posts: 175
Joined: Mon 14 Apr 2008, 14:07

Database of documents: how?

#1 Post by firak »

Database of documents: how?

I will appreciate a suggestion for organize a database of documents.

I have 3.000 documents – (pdf, docs, jpg )
The normal folder name– file name hierarchy is not enough for organize them.
I would like to index them in this way:
full path- folder-file name , title, topic1, topic2, comment. - for each doc.

I think I need somthing like didwiki or oofficedatabase. But I don't kow this tools yet, so befoare I will start to learn the use of this tools, my question is : what do you think is the easyest way?

Meybe an xl file is the easyest way? Maybe I can start whith a cosole comand “ls “ somthing to make a text file of the complete index of the docs, and after that I can edit with an oofice XL program.
I will apreciate also a suggestion how to write a console comand that “pipes

disciple
Posts: 6984
Joined: Sun 21 May 2006, 01:46
Location: Auckland, New Zealand

#2 Post by disciple »

Yes, it should be easy to make a comma separated list using basic shell tools. e.g. for all the files in a folder you can do something like this:

Code: Select all

FOLDER=`pwd`
for i in *; do echo $FOLDER/$i,$FOLDER,$i;done
All text editors and spreadsheet programs can use .csv files, and I think any decent database program should be able to import them, should you want to use a database program. But spreadsheets aren't too bad for keeping a small, simple database like that.

The easiest way to deal with all your files at once would probably be using pfind. Increase the maximum allowable number of search results, and then search for * in the place where you keep your documents. Pfind can give you a directory with a symlink to every result. You should be able to string together a command to run there to produce the list without too much difficulty: you'll probably want to use the realpath, basename and dirname commands.
Do you know a good gtkdialog program? Please post a link here

Classic Puppy quotes

ROOT FOREVER
GTK2 FOREVER

User avatar
Flash
Official Dog Handler
Posts: 13071
Joined: Wed 04 May 2005, 16:04
Location: Arizona USA

#3 Post by Flash »

Tree might come pretty close to doing what you want.

disciple
Posts: 6984
Joined: Sun 21 May 2006, 01:46
Location: Auckland, New Zealand

#4 Post by disciple »

disciple wrote:Pfind can give you a directory with a symlink to every result. You should be able to string together a command to run there to produce the list without too much difficulty.
Yes, click the browse button in Pfind, then run this in that directory:

Code: Select all

for i in *; do file=`realpath "$i"`; echo $file,`dirname "$file"`,`basename "$file"`; done>test
Not a particularly efficient way (in particular, Pfind takes a while to build all the symlinks), but easy :)
Do you know a good gtkdialog program? Please post a link here

Classic Puppy quotes

ROOT FOREVER
GTK2 FOREVER

firak
Posts: 175
Joined: Mon 14 Apr 2008, 14:07

#5 Post by firak »

Tanks disiple and flash, that is really what I was searching for!
so I will organize the dosc in the holyady.
P.S.
Wauu! the "Classic Puppy quotes!"
are very funny!

disciple
Posts: 6984
Joined: Sun 21 May 2006, 01:46
Location: Auckland, New Zealand

#6 Post by disciple »

Glad that thread's appreciated.
Do you know a good gtkdialog program? Please post a link here

Classic Puppy quotes

ROOT FOREVER
GTK2 FOREVER

firak
Posts: 175
Joined: Mon 14 Apr 2008, 14:07

#7 Post by firak »

Work in progress:
I created a simple list with pfind,
Edit with XL, in a way I can open it directly from the Spreadsheet.
in this post:
http://www.murga-linux.com/puppy/viewtopic.php?t=74324
screenshot:
http://www.murga-linux.com/puppy/viewto ... h&id=49854

firak
Posts: 175
Joined: Mon 14 Apr 2008, 14:07

#8 Post by firak »

I foud out that this issue is called "Document Management Systems (DMS) .
and the most professinal softweare for that is called "SCAN (Smart Content Aggregation and Navigation) " is aunder Java-based UI - Apache licenze.
Yust for talking, I think I can live whitout it.

Mayou

Mendeley's is what you need

#9 Post by Mayou »

Mendeley's is what you need
Attachments
Mendeleys.jpg
(41.11 KiB) Downloaded 175 times

Post Reply