Kapalı

write script to compare and import data from excel based files / catalogs into MsSql 2005 database

We are looking to have someone write a script / app that will import data from one database / spreadsheet into it’s proper placement into our site’s existing MsSql 2005 database.

Here’s more details on the task we are trying to achieve.

We are an online record store. For each product in the store, we have the following fields which we fill out for every product that is added to the database:

Stock #

Artist

Album Title

Record Label

Format

Customer Price

Wholesale Price

Item Description

Now, we recently added a “UPC (barcode #)” field to all products, so this field is empty for all existing products.

We have excel / database files that we obtained from the manufacturers, which list mostly the same fields we use, but also has the corresponding UPC #.

The script would need to compare the artist from the manufacturer’s database to the artist in our database, and if a match is made, then it would move onto the album title, and if that matches, then it would compare the record label field and if that matches, then it would copy the UPC # from the manufacturer’s database and insert it into the corresponding spot in the UPC field for that particular product in our database.

Now – there are some exceptions that would have to be noted, else the number of correct matches will be significantly small. PLEASE VIEW THE ATTACHED DOCUMENT for a more comprehensive overview of potential errors as well as a list of exceptions that will need to be made to avoid these possible errors. There are also samples of the excel files / database that you will be running the script against.

Now, I understand to get complete accuracy will be virtually impossible, so I’m not looking for 100% accuracy, but something that would generate approximately 85%-90% accurate results would be sufficient.

Also – if you need help figuring out the structure of our current database since it uses a custom built system, should you have any questions about the design and structure of the cart and database, the original programmer of the cart will be available over email and sometimes AIM / Yahoo IM to answer any questions to assist you in completing this project.

Consideration will go towards programmers who have previously done other database import projects. Sending us examples of previous work in this area will also benefit your chances of getting the job. If we are satisfied with your work, there will be many more small projects in the near future that will be available first to you. Programmers with strong knowledge of the following fields will receive first consideration for the job: [url removed, login to view], VB, C#, javascript, MsSql 2005, and html.

For payment, I will pay through the escrow system, or via paypal if you'd like after full completion of the job.

Beceriler: .NET, Visual Basic

Daha fazlasını görün: write get pay, write copy online, wholesale job description, visual basic programmer job, via escrow system, uses data structure, use data structure, use escrow import, use escrow online payment, use escrow system payment, spreadsheet script, site get programmers, questions to, questions data structure, programmers pay, programmers area, programmers help, programmers excel, programmers database, programmer net email, programmer help online, programmer spreadsheet, products manufacturers, product label design price, product artist

İşveren Hakkında:
( 2 değerlendirme ) Philadelphia, United States

Proje NO: #78018

19 freelancer bu iş için ortalamada 71$ teklif veriyor

meetesh

plz check my PMB

in 7 gün içinde100$ USD
(77 Değerlendirme)
8.1
HeoQue

consider it done , maximum accurany. Thanks!

in 7 gün içinde70$ USD
(51 Değerlendirme)
6.7
lightcresent

check PMB for Details....

1 gün içinde 75$ USD
(27 Değerlendirme)
6.4
wsh2

Where in Philly are you? I was born and raised there.. . I now reside in Easton PA. Hello, my name is Bill. I am a programming expert / mentor with www.experts-exchange.com and www.vbcity.com [screenanme:wsh2]. I ha Daha fazlası

in 3 gün içinde99.95$ USD
(28 Değerlendirme)
5.6
momleetech

We can do it.

in 6 gün içinde70$ USD
(8 Değerlendirme)
3.7
vshree

I have the 8 years of experience in developement and design field. Waiting for your response. Regards Sandesh M M

in 5 gün içinde70$ USD
(17 Değerlendirme)
4.5
shashulog

Plz check PM kindly I am sending u some work

in 4 gün içinde60$ USD
(1 Değerlendirme)
2.8
wasimsohail

Please see PM for details

in 3 gün içinde40$ USD
(1 Değerlendirme)
1.8
Evgene

Hi! I'm ready to do it. Your proposal is very detailed and i understand quite everything. And i'm sure, i can complete this project in 10 days, but i'll charge at least $150. I prefer escrow. I have experience in .ne Daha fazlası

in 10 gün içinde100$ USD
(1 Değerlendirme)
1.9
sibsankar

Dear sir, I, sib sankar Bhattacharya is a team leader of my team.after see your project requrement i can assure you that i can submit your project with in 6 days with 100% accuracy. I am waiting for your repply. Daha fazlası

in 6 gün içinde50$ USD
(2 Değerlendirme)
2.2
ocherk

Hi, I see what do you want. I can do this project. See PM. Regards.

in 12 gün içinde100$ USD
(0 Değerlendirme)
3.0
dunderwood

Dear Sir or Madam: Thank you for your posting. I have completed a project similar to the one you posted in the past and have a demo available on my website at http://dev.davidunderwood.org/exceltosql.aspx You can dow Daha fazlası

in 2 gün içinde85$ USD
(0 Değerlendirme)
0.0
balavelocity

Hai, I will do this job.Let's say when to start. Thanks & Regards, Balamurugan

in 15 gün içinde60$ USD
(0 Değerlendirme)
1.0
nlvinh

Hi, I have done some same projects in C#. This is my avantage.

in 5 gün içinde50$ USD
(0 Değerlendirme)
0.0
vetalik

I can do it. I will write one class for getting data from Excel, one to analize where and what to place, and a main onne wich will do the job. I can't show you anything, because i'm a new on GetAFreeLancer, and my data Daha fazlası

in 7 gün içinde50$ USD
(0 Değerlendirme)
0.0
instance1

GOOD QUALITY WORK WITH INTIME DELIVERY OF THE PRODUCT . 100% GUARANTEED OF HIGH QUALITY PROFESSIONAL WORK, AS WE ARE THE EXPERTISE IN JAVA/J2EE , JSP , EJB, ASP,PHP,Flash,Banner design,Website design, STRUTS FRAME WORK Daha fazlası

in 3 gün içinde75$ USD
(0 Değerlendirme)
0.0
multylines

There is no problem to convert your data from excel to MSSql.

in 3 gün içinde70$ USD
(0 Değerlendirme)
3.0
yogeshpasrija

My Self Yogesh Pasrija located at Delhi, INDIA. I have about 7 years of professional IT industry experience with expertise in technical and professional account management for solutions for Web, Databases, A Daha fazlası

in 3 gün içinde90$ USD
(0 Değerlendirme)
0.0
antosubhakar

Hi, interested to do

in 5 gün içinde35$ USD
(0 Değerlendirme)
0.0