Puppy Linux Discussion Forum Forum Index Puppy Linux Discussion Forum
Puppy HOME page : puppylinux.com
"THE" alternative forum : puppylinux.info
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

The time now is Mon 01 Sep 2014, 17:08
All times are UTC - 4
 Forum index » Advanced Topics » Additional Software (PETs, n' stuff) » Business
Database of documents: how?
Post new topic   Reply to topic View previous topic :: View next topic
Page 1 of 1 [8 Posts]  
Author Message
firak

Joined: 14 Apr 2008
Posts: 174

PostPosted: Mon 05 Dec 2011, 12:37    Post subject:  Database of documents: how?
Subject description: I will appreciate a suggestion for a database of docs
 

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” the list of the documents (in folder and subfolder) – in to a text file.
Back to top
View user's profile Send private message 
disciple

Joined: 20 May 2006
Posts: 6430
Location: Auckland, New Zealand

PostPosted: Mon 05 Dec 2011, 23:23    Post subject:  

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

_________________
DEATH TO SPREADSHEETS
- - -
Classic Puppy quotes
- - -
Beware the demented serfers!
Back to top
View user's profile Send private message 
Flash
Official Dog Handler


Joined: 04 May 2005
Posts: 11032
Location: Arizona USA

PostPosted: Tue 06 Dec 2011, 00:57    Post subject:  

Tree might come pretty close to doing what you want.
Back to top
View user's profile Send private message 
disciple

Joined: 20 May 2006
Posts: 6430
Location: Auckland, New Zealand

PostPosted: Tue 06 Dec 2011, 06:16    Post subject:  

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

_________________
DEATH TO SPREADSHEETS
- - -
Classic Puppy quotes
- - -
Beware the demented serfers!
Back to top
View user's profile Send private message 
firak

Joined: 14 Apr 2008
Posts: 174

PostPosted: Tue 06 Dec 2011, 16:11    Post subject:  

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!
Back to top
View user's profile Send private message 
disciple

Joined: 20 May 2006
Posts: 6430
Location: Auckland, New Zealand

PostPosted: Tue 06 Dec 2011, 20:43    Post subject:  

Glad that thread's appreciated.
_________________
DEATH TO SPREADSHEETS
- - -
Classic Puppy quotes
- - -
Beware the demented serfers!
Back to top
View user's profile Send private message 
firak

Joined: 14 Apr 2008
Posts: 174

PostPosted: Sat 17 Dec 2011, 02:05    Post subject:  

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/viewtopic.php?mode=attach&id=49854
Back to top
View user's profile Send private message 
firak

Joined: 14 Apr 2008
Posts: 174

PostPosted: Tue 03 Jan 2012, 16:19    Post subject:  

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.
Back to top
View user's profile Send private message 
Display posts from previous:   Sort by:   
Page 1 of 1 [8 Posts]  
Post new topic   Reply to topic View previous topic :: View next topic
 Forum index » Advanced Topics » Additional Software (PETs, n' stuff) » Business
Jump to:  

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum


Powered by phpBB © 2001, 2005 phpBB Group
[ Time: 0.0587s ][ Queries: 12 (0.0069s) ][ GZIP on ]