Project T... -- 2
£250-750 GBP
Paid on delivery
We would like to thank everyone that previously bid on this project, particularly those that expressed an interest and provided feedback. Since the original project description was posted we have reviewed our requirements and have extensively revised our description of the features being requested. Please take a look at the summary below and ask any questions.
Overview
> This description provides an overview of the required solution; a more detailed version will be shared with a shortlist of developers to enable them to ask questions and provide more accurate quotes.
> The expected output of this piece of work will be Proof of Concept (PoC) that has been designed to test the feasibility of integrating the various elements set out below. The PoC will also be used to demonstrate the solution to prospective clients and to identify candidates that will be considered when building the MVP and subsequent iterations.
Overview of features
1. Files will be placed on an SFTP server (manually).
2. A manually triggered process will scan the SFTP server, identifying new batch folders and files, and storing details about the contents in a database.
3. Use an established API to pass .pdf files to an OCR type service.
4. Receive data (API) from the OCR type service and record it appropriately in a database.
5. Provide reports.
Detailed description the process and requirements
Files will be placed on the SFTP server (manually).
> .xls and .pdf files will be placed on an SFTP server using an FTP client.
> SFTP server directory structure: The directory structure on the SFTP server will be: xxx_Id\zzz_Id\Filename
> .xls SUBMISSION file: There will be a single .xls file in each directory on the SFTP server. The .xls file will contain the ‘master data’ against which all other data will be verified. The .xls file contains a row of data (a record) for each MEASURE. For PoC, each .xls file will contain 1 – 10 MEASURE records.
> .pdf DOCUMENT files: A predetermined file naming convention is applied to DOCUMENT files. For the purpose of the PoC, DOCUMENT files will be named using the file naming convention: AAA_BBB_DocumentType.
> For each record in the .xls file (i.e. each MEASURE) three .pdf files will be uploaded to the SFTP server.
> A manually triggered process will scan the SFTP server, identifying new batch folders and files, and storing details about the contents in a database.
- Record data from the .xls file in a database
- Record file metadata from .pdf files in a database
Use an existing API to pass .pdf files to an OCR type service.
> Use the API provided by the OCR type service provider to upload documents for digitalization.
Receive data (API) from the OCR type service and record it appropriately in a database.
Provide reports.
> The report is to be placed in a folder on the SFTP server.
> Determine the DOCUMENT types required for each MEASURE based on the simple criteria that will be provided.
> Identify any missing DOCUMENT types.
> Report the DOCUMENTS that were presented but did not conform to a defined template.
> Report the data elements in the .xls file that match (or otherwise) those returned from the OCR type service (API)
Project ID: #5931849
About the project
17 freelancers are bidding on average £746 for this job
Hi, our team is interested in your project. We already implemented a lot of project by C# using MS SQL databases. To implement your task there are 2 options. 1) create a desktop application worked on server directly More
Just like the old proposal: The plan is to use rb-inotify as part of the worker to watch directory changes. After that will do xls parsing and send PDF to an OCR server. What's the format for those files? And do More
Hello, I have reviewed your project posting and are very much excited to assist you in your project. I would appreciate if we can connect over private message or other medium to discuss about the project and provid More
Hi, An ASP.NET,c#,vb ,SqlServer,JQuery,Javascript expert here. Please feel free to discuss the project with me so that i can wrap it up in a timely manner as per your requirements. I would like to have a detailed d More
Hey Daniel, I’m a Ruby on Rails developer with 3 years of experience and I’m able to develop it for you. I’ve already worked with lots of APIs, OCR processing, PDF generation and I have experience deploying big apps More
Dear Client, Please send me your skype id or contact no. so that we can discuss and start working on your project. I have strong experience of more than 3 years working on complex web application. I have expertise in R More