Annulé

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.

Compétences : .NET, ASP, Programmation C#, SQL, Design de site internet

en voir plus : 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

Concernant l'employeur :
( 0 commentaires ) United States

Nº du projet : #1615537

37 freelance font une offre moyenne de $6080 pour ce travail

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 40 jours
(84 Commentaires)
8.5
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 50 jours
(268 Commentaires)
8.8
qitsol

We are interested, see your inbox.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 45 jours
(99 Commentaires)
7.0
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 45 jours
(6 Commentaires)
6.9
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 90 jours
(57 Commentaires)
6.8
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 72 jours
(6 Commentaires)
6.5
anuj20071

Pls cehck PM

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 50 jours
(37 Commentaires)
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, Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 35 jours
(33 Commentaires)
6.4
AmirAly

Kindly Check PMB

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(25 Commentaires)
5.4
afoash

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(1 Évaluation)
4.5
krypitol56

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 40 jours
(7 Commentaires)
3.7
JavaPSFTConstnt

Hi, Please check your inbox. Thanks !

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 40 jours
(1 Évaluation)
3.2
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 20 jours
(1 Évaluation)
2.9
parama4u

Hi, Ready to start. Please Check PMB

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(3 Commentaires)
2.4
petterpp1

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(1 Évaluation)
2.3
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 9 jours
(2 Commentaires)
2.1
Vinss11

Hello, I am technology expert having 6+ years experience in Software Industry. I have worked for many Australian and US Clients. I also have expert team for Website development, Web site Designing and Mobile App Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 55 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 14 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 45 jours
(0 Commentaires)
0.0
venkat1202

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 12 jours
(0 Commentaires)
0.0