Đã Hủy

Excel to SQL import and export w/ data management interface

Willing to pay more for expedited quality delivery. Please let me know your estimated time needed.

This project will handle imports of excel files into a database repository that will also need to be built on MS SQL 2008 R2. It will allow the user to map the fields in the Excel file to available fields in the DB (the imported Excel files may have several different formats). Once the mapping is done for a file, this mapping should be saved in the application to select for future imports. This import will also allow the user to append metadata to the import; such as an expiration date or file source; these fields would be predefined via an area in the import section of the application.

They application will also handle exports to an Excel file that a user can select the criteria of the records to be exported. The application will store in a table the number of records that happened in the export and a hyperlink to the file. This functionality will do a concatenation of all the records in both the Master and Company repositories.

The user will also be able to use a % slider to do "De-duplication" on records in the database. Upon finding duplicates, the user will be able to select the record they want to retain, the other records will be moved to an archive (see below). This functionality will do a concatenation of all the records in both the Master and Company repositories.

The application will have a simple admin area where they can add users, and set the users permissions (Admin or User).

The Database will have 3 repositories, the Master Repository, the Company Repository, and the Archive. All records will sit in the Master repository unless they have been flagged to be moved. The Databases should use a star-schema.

The application have a section that will allow the user to select records to flag them to be moved to the Company Repository.

Kỹ năng: .NET, ASP, Lập trình C#, SQL, Thiết kế trang web

Xem thêm: data import export interface, sql 2008, excel interface sql 2008, excel sql interface, where is w, repository.db, import ms project, formats in excel, finding net, excel to application, db import export, 5 and below, all star management, master excel, star w, sql import, sql duplicates, Sql 2012, records management , r2, master data, import/export, import sql, import export, import excel

Về Bên Thuê:
( 0 nhận xét ) United States

Mã Dự Án: #1615537

38 freelancer đang chào giá trung bình $6052 cho công việc này

krishdts

Hello ,we have gone through your project named Excel to SQL import and export w/ data management interface and we like to convey that we have already done similar kind of projects before also. We can address any conce Thêm

$5000 USD trong 40 ngày
(62 Đánh Giá)
8.2
dswtechnologies

We have gone through your requirement and we do have 5 years of experience and assure you the product of your choice and will complete the work on time with excellent quality, please do check your inbox for more detail Thêm

$5000 USD trong 50 ngày
(103 Đánh Giá)
7.5
sandeep25101982

Hi, We have excellent .Net,ASP.net,MVC,WCF,WPF,Silverlight,sharepoint and PHP expertise. Please have a look at private message for relevant work done. Awaiting a positive response from your end and looking forward Thêm

$8000 USD trong 90 ngày
(49 Đánh Giá)
6.6
WBMEDIA

Hi there, We would love to talk with you about your project! I am sure you will be bombarded with very low bids & constant messages for your project, by providers promising the earth, but in reality providing low qu Thêm

$8500 USD trong 45 ngày
(5 Đánh Giá)
6.4
qitsol

We are interested, see your inbox.

$8400 USD trong 45 ngày
(91 Đánh Giá)
6.3
surajitmitra

Hello Eric, Thank you for taking my call a while back and as suggested by you I am sharing my queries here with a brief about our company. The bid is certainly a placeholders bid and I will give a firm estimate once Thêm

$13600 USD trong 72 ngày
(6 Đánh Giá)
6.2
WebBizSolution

I run European website design firm with years of design experience personally developing over 300+ websites. I can also provide a list of references from past customers if you'd like. I'm not the cheapest you'll find, Thêm

$5777 USD trong 35 ngày
(32 Đánh Giá)
6.3
anuj20071

Pls cehck PM

$5000 USD trong 50 ngày
(22 Đánh Giá)
5.7
AmirAly

Kindly Check PMB

$5000 USD trong 15 ngày
(16 Đánh Giá)
5.1
afoash

I'm ready and interested to build the application Please Check PM

$5000 USD trong 15 ngày
(1 Đánh Giá)
4.5
krypitol56

We are a two man development team out of WI, USA. Please see PM.

$5000 USD trong 40 ngày
(7 Đánh Giá)
3.7
amfuries

################### ******************* PLEASE CHECK THE PM **************** #############

$5000 USD trong 40 ngày
(6 Đánh Giá)
3.9
petterpp1

***** Dear. Please check your PMB. Best regards. Petter. *****

$5000 USD trong 30 ngày
(1 Đánh Giá)
2.4
parama4u

Hi, Ready to start. Please Check PMB

$6000 USD trong 30 ngày
(1 Đánh Giá)
1.4
milinkatwala

I have work with excel file in for the insurance [url removed, login to view] adnin site template is create for the excel file so that when excel is select and start process the if template is match,according to the template data is in Thêm

$5000 USD trong 45 ngày
(0 Đánh Giá)
0.0
PurpleDev

SQL MICROSOFT CERTIFIED PROFESSIONAL DEVELOPER (70-433 / 70-516 / 70-511 Exams) Six year in SQL development. I've see ppt documentation. I'm ready to start

$6000 USD trong 20 ngày
(0 Đánh Giá)
2.8
AramAr

Hi,I'm experienced programmer and system administrator (Yerevan State University master degree) and I can do this work with good quality. Contacts skype aramaram155 mobile +37498333397

$5000 USD trong 9 ngày
(0 Đánh Giá)
0.0
WebLancer82

Solid Experience working with SQL Server , .NET , Excel . I have been working on such application for dataware house department in my company for more than 3 years . I Developed such application However , the feature Thêm

$5000 USD trong 14 ngày
(0 Đánh Giá)
0.0
boliv

Have implemented a similar kind of functionality in my past wprk ex. Have recently joined the freelancer community, have an experience of 2 years in .NET and SQL in a reputed indian IT company. You can message me f Thêm

$7500 USD trong 45 ngày
(0 Đánh Giá)
0.0
venkat1202

I can Import/Export excell sheets into DB and Data Validation, eliminate Duplicate records. and i can deliver on time.

$5000 USD trong 12 ngày
(0 Đánh Giá)
0.0