Import: Import Customers, Sales Person, Store, ERPSales records to temporary tables.
Verfy:Verify Process, Verify dependent columns such as Customer, Sales Person, Store exists and verification rules .
Store Import to Archive
Use an Archive file name indicating the Import series. i. e. Customers_YYYYMMDD_HHMM.
Set an Import Status indicator for Pass/Fail
View/Edit: The user will be able to view the Import status and update the record.
The user will be able to re-run the Import Process.
Post: Imports that Pass the verify process will be posted to the database.
You should have the ability to complete this request based on the examples provided and the files attached and knowledge of what typical import applications do in the subject matter area. Specific technical specifications are not available.
Modification :add the Import with Verification and History and the sql to populate the tables from the attached application files and Excel layout file. And Just add Import on the application menu.
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 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).
SQL Server 2005
Visual Studio .net 2005