Solution for a specific database solution (document analysis)

Status: Closed
Hadiah: $100
Penyertaan Diterima: 9
Pemenang: kabatza

Winner

Ringkasan Peraduan

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.

Kemahiran Disyorkan

Winner

Siarkan Peraduan Seperti Ini

Maklum Balas Majikan

“The suggested solution was the best I received. ”

lutzzy, Italy.

Papan Penjelasan Umum

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