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

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

38 freelance ont fait une offre moyenne de 6052 $ 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

5000 $ USD en 40 jours
(62 Commentaires)
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 Plus

5000 $ USD en 50 jours
(103 Commentaires)
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 Plus

8000 $ USD en 90 jours
(49 Commentaires)
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 Plus

8500 $ USD en 45 jours
(5 Commentaires)
6.4
qitsol

We are interested, see your inbox.

8400 $ USD en 45 jours
(91 Commentaires)
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 Plus

13600 $ USD en 72 jours
(6 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

5777 $ USD en 35 jours
(32 Commentaires)
6.3
anuj20071

Pls cehck PM

5000 $ USD en 50 jours
(22 Commentaires)
5.7
AmirAly

Kindly Check PMB

5000 $ USD en 15 jours
(16 Commentaires)
5.1
afoash

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

5000 $ USD en 15 jours
(1 Commentaire)
4.5
krypitol56

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

5000 $ USD en 40 jours
(7 Commentaires)
3.7
amfuries

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

5000 $ USD en 40 jours
(6 Commentaires)
3.9
petterpp1

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

5000 $ USD en 30 jours
(1 Commentaire)
2.4
parama4u

Hi, Ready to start. Please Check PMB

6000 $ USD en 30 jours
(1 Commentaire)
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 Plus

5000 $ USD en 45 jours
(0 Commentaires)
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 en 20 jours
(0 Commentaires)
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 en 9 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

5000 $ 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

7500 $ 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.

5000 $ USD en 12 jours
(0 Commentaires)
0.0