Solution for a specific database solution (document analysis)

Status: Closed
Prize: $100
Entries Received: 9
Winner: kabatza

Winner

Contest Brief

I need a technical specification for a software solution to support a certain business process that I will describe here. The specification should allow me to post the creation of the software or customization of the solution as a project here on freelancer.com. The specification should include the software that I should use and the coding (language required) as well as the customization (and language required). It should also describe how much effort this would be and what advantages and disadvantages the solution has.

The business process is as follows. (1) I have a document, which includes headers, sentences, tables and images. (2) This document needs to be imported into a DB having each header, sentence, table and image respectively as one entry in the DB. I need to read the text, tables and images in the DB. (3) Each entry automatically has to have the Project name (added manually once at the start), the name of the document (added manually once at the start and the reference of the paragraph in the document (must do that automatically). (4) I have to able to analyze the DB in the following manner. I have to search for a word or string of words and the DB has to add the respective Y/N of the search into the data set of the entry. I also have to search for a word, if another word is in the same sentence, or certain formats like dates, numbers, $ etc. with the same effect. (5) Then I have to manually review each element of the DB for manual Y/N and addition of comments.

Also, the software should have the following characteristics. 1) UI and reports have to look super professional, not like IT but like top notch consultancy. (2) It has to run on every normal windows PC. (3) Using it must not require any specific IT skills but has to be as easy as using an Office program.

I have a solution for this that runs on Excel but lacks the professional look/UI and reporting capabilities. Also it always runs only on a specific version of Excel etc. This is working, but is not polished enough, not flexible enough and not scalable enough.

Recommended Skills

Winner

Post a Contest Like This

Employer Feedback

“The suggested solution was the best I received. ”

lutzzy, Italy.

Public Clarification Board

chicong115
- 11 years ago
Let's my try
- 11 years ago
nblsoft
- 11 years ago
Hi, please select one option to help understand the requirements. Case 1: User searches "Supplier shall" and program searches exact search term and places Y/N. Case 2: User searches "Supplier" and "shall" or "will" and program searches "Supplier shall" or "Supplier will" and places Y and N for any matching string.
- 11 years ago
nblsoft
- 11 years ago
Hi, I just wanted to know that when user searches a term, all matching, semi-matching and non-matching entries will be appended into another table or it will be displayed immediately and will not have a record for searched term?
- 11 years ago
1. Contest Holder
  - 11 years ago
  when i search the term, the matching items (sentences) shall get the character Y in the DB.
  - 11 years ago
2. nblsoft
  - 11 years ago
  Thank you, I think when you'll do another search, Y and N will change accordingly !
  - 11 years ago
swmcdonnell
- 11 years ago
Can you help me understand the big picture? Every sentence needs to be separated or do you want sections to be grouped. For example, a clause under "Term and Termination" would be tagged as a Term and Termination clause, but the entire clause would be stored as a single entry -- not separated out by sentence, but the entire clause could be searched. Or is this not what you're trying to accomplish? Is there any consistency to the format or the files that would enable a program to determine what is a header, etc.? Thanks for explaining.
- 11 years ago
View 3 more messages
1. nblsoft
  - 11 years ago
  I think that when user searches a term, all sentences (records) will be listed followed by Y or N. Y/N represents that required term exists in record or not.
  - 11 years ago
2. Contest Holder
  - 11 years ago
  I agree.
  - 11 years ago
Contest Holder
- 11 years ago
Every sentence needs to be one entry in the DB. Also tables and images. In your example each sentence under the heading "term and termination" shall be one entry with the parameter "is part of the chapter "term and termination". There is no real consistency. Only that the headings will be numbered by numbers or letters and not just stand alone. So they'll all be 1., 1), A., A), A1. etc. or similar and not just "term and termination" as the example goes.
- 11 years ago
cloudsphere
- 11 years ago
Hi could you provide samples for the input files ?
- 11 years ago
1. Contest Holder
  - 11 years ago
  http://www.vondst-law.com/files/Template%20Sourcing%20Agreement%20Dutch%20Outsourcing%20Association%20EN%20(v1).docx
  - 11 years ago
Contest Holder
- 11 years ago
If you know a software that does the job off the shelf, suggest a customization solution of any software suite out there or recommend to code a new software is equally valuable to me.
- 11 years ago
View 2 more messages
1. Contest Holder
  - 11 years ago
  This document needs to be imported into a DB having each header, sentence, table and/or image as one DB entry. Afterwards this has to be analyzed for any number of words or string of words the user chooses. The user might for example choose for "Supplier shall", "Supplier will" and x other words or string of words. In addition the user might want to search for all formats that show a $ sign or a date etc. And then the DB shall report all these analysis in one report.
  - 11 years ago
2. Contest Holder
  - 11 years ago
  The report should look like 1) Name Project, 2) Name document, 3) Reference in document, 4) actual text from document, 5) Deliverables (all entries with "Supplier shall" and Supplier will", 5) Milestones (all entries with a "date" and/or a the word "week" or "month" etc. All this needs to be flexible for the user to customize in a fashion that does not require coding in a simple UI.
  - 11 years ago
Contest Holder
- 11 years ago
Any other solutions? Something from the shelf or MS Office centric? Any ideas on requirements for effort or costs?
- 11 years ago
kabatza
- 11 years ago
Depending on the nature of your work there are many ready made options. Take for example the document verification process many online companies. The customer uploads documents and fill-in a form, then the admin aproves or rejects it and has the option to add a comment as well etc. This is standard web programming. All you need is a host php and mysql for the core functions, and basic html, css and some javascript to make the user interface look nice. It is better to explain to the developper exactly what you want the application to do with specific example cases.
- 11 years ago
1. kabatza
  - 11 years ago
  By host, I mean a remote or local server. Local server can be just about any PC.
  - 11 years ago
2. Contest Holder
  - 11 years ago
  thanks
  - 11 years ago
Contest Holder
- 11 years ago
The source documents are MS Word and7or MS Excel files.
- 11 years ago
julio1012
- 11 years ago
What type of document is the source?
- 11 years ago