Archiving system..

[ichiriki]

---

guys..need help.. im working on this system for ojt..this system mainly accepts uploaded files like photos or documents and can be viewed or retrieved by the user..den ila gusto is web based..im making it via php-mysql.. i was hoping nga naay mkatabang nko sa retrieving nga part especially sa documents, gusto tna nko nga naay search engine for the uploaded files and maapil tna niya og search ang mga words etc. sa sulod sa isa ka document file..

any ideas??...(Hoping naa!!..)..^__^

it would be a great help for me..thnx daan guys..i know nga mu gyud mu sa tao nga in need..^__^

[MarkCuering]

bro, hows your based knowledge in PHP-MySQL? as an OJT hindi yata worth na ikaw ang gagawa nyan. it will take sometime. especially in security...checking the uploaded files or security check that you won't get hit by SQL injection, especially if this will be use in public...

for searching a string in word document. I don't know if PHP can handle this, since PHP is designed for Web Application & Server-side scripting.

If you do this in python I can help you, or you may refer to this site: Developer's Guide: Python - Google Documents List Data API - Google Code this module is very reusable, or use the existing COM object provided by microsoft found on their MSDN library...

if you really want to stick in PHP another way is to generate XML file out from the document files uploaded by the users, from there PHP will handle the XML file to do searching and other string manipulation, just stick to W3C standards during converting so you won't get any problems in the end. or you may also use mod_php if you are using Apache as your server Sablotron (opensource) foryour XML and pdflib for convertion any text or graphics but this is a commercial software

and lastly, there's a lotttttttt of CMS (open source) now. which closely related to your goal, all you have to do is to gather those products, combined them and add some features with respect to your needs. GoodLuck!



Mark

[ichiriki]

tnx mark...i have a background on PHP-mysql in one of our db classes we were assigned to make an web-based UI for a specific business..but still we did not go deep to that project..and to this point im the only ojt of our department, i doubt that they are still recruiting..
yah..im also considering security..ive read some security measures that can minimize the threat of SQL injections and also this web-based will be only used in the intranet, so i doubt that anyone would want to tamper with it..i was thinking of adding an entity for my doc files, "description" of the file.. so if ever there is a search request, it will just compare it to the description..

mark can i ask a favor..can you give me a link related to this??plsss plssss plsss..

[MarkCuering]

if will be used only on Intranet then no problem at all, since you can directly grab the person who was doing it through logging's. SQL injection is not that easy, unless majority of the employees are really into that kind of stuffs.

Good option there, placing some "description" on every uploaded document. However thinking of such descriptions is to harsh to users... believe me some of them don't know either what is the correct description to put. Another alternative will be another text field where the users will just copy & paste the content of the document file. you can store the information into an ordinary textfile... some helpful scenario:

1,000 Resumes/CV's being uploaded on the server, together with the description input by the user. some user will put on the description like
"IT Specialist Mark_Cuering_CV_2008", "Juan_Programming CV2008", "Pedro Resume 2008".

if you want to search "Juan" you can't find it... because what is being stored was "Juan_Programming" not unless you will trimmed any special characters on the description such as "_ + = -" etc... and now, what if you want to filter those resumes who have the knowledge of the following "C++" with background "OpenGL" or into ".NET" or came from "ThisCompanyName" so you don't have any choice but to search any related string in every document.

or just searching a contract records, guidelines, procedures, regulations... I need to retrieved a document which I've wrote two years ago. I forgot the filename and description. I forgot how many pages but what left me is only the page 54. hmm.... now I got some other clue... search a document having more than 50 pages with this series of string "My Naughty Dog Eat My Lovely Cat". from there it may help you to find the document, retrieved and modify. upload with the same information having another fieldname "Revision" set to "1" so on my next search, I can give a lesser filter marked the revision field to "1"

google about open source CMS or try Drupal, Joomla, just don't go further like Alfresco or Compiere its too complicated to handle by a single person.

[ichiriki]

tnx mark..i think that "Juan_Programming CV2008" can be searched using the keyword "juan" by using '%asdasda%' to my select algo in mysql..although thnx very much for bringing it up..Yup, i do think that this is a big burden for me since i am the only one to do this project, thats why im keeping it simple at all times, in regard to copying the text and saving it to a text file (i really dont know this...hehe) is it now possible that the contents of the text file would be included in the search?..

[MarkCuering]

let the user copy and paste the content of the uploaded document into an ordinary html textfield. on server side save this as an ordinary txt file and do some reprocess as you wish.