Lukket

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: asp.net, 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.

Færdigheder: .NET, Visual Basic

Se mere: write get pay, write copy online, wholesale job description, visual basic programmer job, via our escrow system, vb programmers online, vb programmer online job, vb programmer job, vb net programmers, uses of data structure, use paypal as escrow, use of data structure, use escrow to import, use escrow online payment, use an escrow system to payment, spreadsheet script, site to get programmers, should you have any questions, questions to, questions of data structure, questions for programmers, programmers pay, programmers in the area, programmers help, programmers excel

Om arbejdsgiveren:
( 2 bedømmelser ) Philadelphia, United States

Projekt-ID: #78018

19 freelancere byder i gennemsnit $71 for dette job

meetesh

plz check my PMB

$100 USD in 7 dage
(77 bedømmelser)
8.1
HeoQue

consider it done , maximum accurany. Thanks!

$70 USD in 7 dage
(51 bedømmelser)
6.7
lightcresent

check PMB for Details....

$75 USD på 1 dag
(27 bedømmelser)
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 [url removed, login to view] and [url removed, login to view] [screenanme:wsh2]. I ha Mere

$99.95 USD in 3 dage
(28 bedømmelser)
5.6
momleetech

We can do it.

$70 USD in 6 dage
(8 bedømmelser)
3.7
vshree

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

$70 USD in 5 dage
(17 bedømmelser)
4.5
shashulog

Plz check PM kindly I am sending u some work

$60 USD in 4 dage
(1 bedømmelse)
2.8
wasimsohail

Please see PM for details

$40 USD in 3 dage
(1 bedømmelse)
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 Mere

$100 USD in 10 dage
(1 bedømmelse)
1.9
sibsankar

Dear sir, I, sib sankar Bhattacharya is a team leader of my [url removed, login to view] 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. Mere

$50 USD in 6 dage
(2 bedømmelser)
2.2
ocherk

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

$100 USD in 12 dage
(0 bedømmelser)
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 [url removed, login to view] You can dow Mere

$85 USD in 2 dage
(0 bedømmelser)
0.0
balavelocity

Hai, I will do this [url removed, login to view]'s say when to start. Thanks & Regards, Balamurugan

$60 USD in 15 dage
(0 bedømmelser)
1.0
nlvinh

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

$50 USD in 5 dage
(0 bedømmelser)
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 Mere

$50 USD in 7 dage
(0 bedømmelser)
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 Mere

$75 USD in 3 dage
(0 bedømmelser)
0.0
multylines

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

$70 USD in 3 dage
(0 bedømmelser)
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 Mere

$90 USD in 3 dage
(0 bedømmelser)
0.0
antosubhakar

Hi, interested to do

$35 USD in 5 dage
(0 bedømmelser)
0.0