(old)Puppy Linux Discussion Forum

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

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: 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.

Tree might come pretty close to doing what you want.

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: Not a particularly efficient way (in particular, Pfind takes a while to build all the symlinks), but easy

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!

Glad that thread's appreciated.

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

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.

Mendeley's is what you need