Solution for a specific database solution (document analysis)

État: Closed
Prix: $100
Propositions reçues: 9
Gagnant: kabatza

Winner

Résumé du concours

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.

Compétences recommandées

Winner

Publiez un concours comme celui-ci

Commentaire de l'employeur

“The suggested solution was the best I received. ”

lutzzy, Italy.

Tableau de clarification publique

chicong115
- il y a 11 ans
Let's my try
- il y a 11 ans
nblsoft
- il y a 11 ans
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.
- il y a 11 ans
nblsoft
- il y a 11 ans
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?
- il y a 11 ans
1. Titulaire du concours
  - il y a 11 ans
  when i search the term, the matching items (sentences) shall get the character Y in the DB.
  - il y a 11 ans
2. nblsoft
  - il y a 11 ans
  Thank you, I think when you'll do another search, Y and N will change accordingly !
  - il y a 11 ans
swmcdonnell
- il y a 11 ans
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.
- il y a 11 ans
Voir 3 messages supplémentaires
1. nblsoft
  - il y a 11 ans
  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.
  - il y a 11 ans
2. Titulaire du concours
  - il y a 11 ans
  I agree.
  - il y a 11 ans
Titulaire du concours
- il y a 11 ans
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.
- il y a 11 ans
cloudsphere
- il y a 11 ans
Hi could you provide samples for the input files ?
- il y a 11 ans
1. Titulaire du concours
  - il y a 11 ans
  http://www.vondst-law.com/files/Template%20Sourcing%20Agreement%20Dutch%20Outsourcing%20Association%20EN%20(v1).docx
  - il y a 11 ans
Titulaire du concours
- il y a 11 ans
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.
- il y a 11 ans
Voir 2 messages supplémentaires
1. Titulaire du concours
  - il y a 11 ans
  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.
  - il y a 11 ans
2. Titulaire du concours
  - il y a 11 ans
  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.
  - il y a 11 ans
Titulaire du concours
- il y a 11 ans
Any other solutions? Something from the shelf or MS Office centric? Any ideas on requirements for effort or costs?
- il y a 11 ans
kabatza
- il y a 11 ans
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.
- il y a 11 ans
1. kabatza
  - il y a 11 ans
  By host, I mean a remote or local server. Local server can be just about any PC.
  - il y a 11 ans
2. Titulaire du concours
  - il y a 11 ans
  thanks
  - il y a 11 ans
Titulaire du concours
- il y a 11 ans
The source documents are MS Word and7or MS Excel files.
- il y a 11 ans
julio1012
- il y a 11 ans
What type of document is the source?
- il y a 11 ans