The web-based system will provide a simple interface that will allow the user to browse their directory structure and select a PDF file to import into an Access database. The Access database structure will consist of a field named LINE with a data type of ‘text.’ Each individual row or line that is displayed when viewing the PDF file will be converted to text and entered as a separate record in the Access database’s LINE field. The system must work with the sample files provided. Images do not need to be imported.
o The interface shall be a simple HTML page with a plain white background.
o The interface shall contain a ‘browse’ button, a ‘filename’ text field, and a ‘process’ button.
o The interface shall contain a ‘browse’ button that will allow the user to navigate through their computer’s directory structure and select a PDF file to process.
o The interface shall contain a ‘filename’ text field that will be populated with the directory and name of the selected file.
o Once the selected file has been imported, a popup window will appear containing the text ‘Successfully Processed’.
• Access Table
o The PDF data shall be transferred to a Microsoft Access 2010 database file.
o The Access database shall be resident on the web server’s drive.
o A new database file shall be created for each PDF file processed.
o The Access database filename shall be the first five letters of the imported PDF file concatenated with the date/time stamp at the moment the ‘process’ button was selected.
o The Access database shall contain one text field named ‘line’.
o The Access database structure will consist of a field named LINE with a data type of ‘text.’
• Data Import
o The PDF file data shall be imported into the Access database.
o Each individual row or line that is displayed when viewing the PDF file shall be converted to text and entered as a separate record in the Access database’s LINE field.
o All special and unprintable characters shall be removed from the line prior to entry in the Access database.
o Images do not need to be imported.
o The program shall work properly with the two sample PDF files to be provided.
• Confidentiality and Ownership
o Developer agrees to keep all information and data furnished by Contractor as confidential and proprietary, and shall not divulge same to any outside source without Contractor’s express written permission.
o Contractor shall retain all intellectual property rights with respect to all materials related to this project.
o Contractor retains full and sole ownership of all software products including source code and other related materials developed in association with this project.
8 freelancers are bidding on average $217 for this job
Dear Sir, I have +5 year experiences in ms access database development. To Provide Quality, Modular , Result Oriented , CLient Satisfection Work Thanks & Regards HGDumaswala
I will bring over 20 years programming experience with PDF Processing skills to bear on this role. Please contact me if you have questions on any or all aspects of my offer.