Data Import Project
$100-500 USD
Pago na entrega
Application is needed to read in a multiude of documents in varying formats and type. This will allow data from multiple companies to be inported into a new payroll system.
Extract core pieces of data and export it into a Excel spreadsheet in a specified format.
The app will have to handle a wide variety of import documents from Excel Spreadsheets (.XLS and .XLA), text (.HTM and .TXT), PDF, Word (.DOC).
I realise that with the free text files will not be able to automate the imports, but can you let me know which ones you can work with, specifically the PDF and Word docs.
It must allow the user to set up the criteria for importing from these files and from new as yet unknown formats.
Where it is not possible to automate the import, for example when data cannot be extracted from the file or the data in is free text format, the app must notify the user.
From each file, you must import the following data
First Name
Surname
Hours
Pay Rate
Additional fields may be required.
An audit trail of all imports must be kept detailing which files have been imported, the number of records imported and the totals for each file. This should be stored in a SQL Server 2000 database.
I have attached samples of the types of file that need to be imported.
As part of your bid can you let me know which files you think you will be able to import and which you won't.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
VB or VB.NET preferred but if you think you can do a better job in a different language let me know.
SQL Server 2000
Must run on Windows 2000 and Windows XP
ID do Projeto: #3669435