Sedang Disiapkan

gallery database update

need to update information in our exisiting data base from information available on the web.

exisiting database appox. 9110

outside databases; 6-7,000 about 1/3 of these will be new listings most will be comparing our contact information with that on the internet.

The database is a MS SQL Server Ver. 9.00.2047.00, Product Level: SP1, Edition: Standard Edition. The database has 94 tables total.

We need to update our: contact_tbl table (and any related table, if necessary) by:

1)Cleaning up duplicate entries from the contact_tbl table.

2)Comparing existing contact entries with another third party database vendor that will provide additional contacts to the contact_tbl table then:

a. Make sure the contacts being imported from this other DB don’t make duplicate entries.

b. If a contact already exists inside the contact_tbl table (or related tables, if necessary), then update their information with the vendor database.

The number of contacts being imported from the verdor DB is less than 10K

The source we are going to use for the import are these two websites:

Artnet.com
Artinfor.com

Both have over 6000 gallery listings

One of the websites has been changed:

Instead of Artinfor.com it will be artinfo.com

To access the information we need follow these steps.

For Arnet.com:

1) go to: http://www.artnet.com/net/galleries/gallery_home.aspx

2) Click on the "ALL" links for "Fine Art Galleries", "Design Galleries", "Decorative Art & Antiques Galleries"

We need all those galleries listings in our database.

For Artinfo.com:

1) Go to: http://www.artinfo.com/galleryguide/

2) Click on each of the areas on the world map: "North America", "Europe", "Middle East", "Asia", "Australia", "Africa" and "South America".

We need all the galleries there too.

We will let know more details on how to access our database so you can perform the import (with no duplicates and any existing entry should be updated with the info on these two websites)

Kemahiran: Pemprosesan Data

Lihat lebih lanjut: update gallery database, web gallery, c update, need gallery, contact data base, database processing, database contact, update data, need contact database, database information, web update, update information, internet database, data update, update web database, update gallery, gallery database, update database, expoships, comparing databases

Tentang Majikan:
( 5 ulasan ) Bonita Springs, United States

ID Projek: #311836

Dianugerahkan kepada:

Obialo

Hi, kindly see your PM, thanks

$100 USD dalam 5 hari
(12 Ulasan)
4.7

31 pekerja bebas membida secara purata $95 untuk pekerjaan ini

algie123

Hello! Please check PMB for details of my bid. Thank you and regards, Algie.

$2 USD dalam sehari
(26 Ulasan)
4.8
maribel1218

Dear Sir and Ma'am Kindly refer to PM for details of my bid. Thank you

$30 USD dalam 0 hari
(5 Ulasan)
4.4
EServe

Please check PM.

$125 USD dalam 7 hari
(6 Ulasan)
4.1
edatawiz

Hi - Thanks for posting this project. please check your pmb for details.

$100 USD dalam 10 hari
(7 Ulasan)
3.4
codernow

I can process it for you. Please choose me for you job. Thanks in advance

$130 USD dalam 5 hari
(0 Ulasan)
0.0
nihar74

Dear Sir, I am a 11 yrs experience Data Manager having vast experience in multiple databases (MS SQL,Access & Oracle), Pls get the opportunity to work for you.

$100 USD dalam 8 hari
(0 Ulasan)
0.0
amit240881

Please check the PMB

$1 USD dalam sehari
(0 Ulasan)
0.0
siddharthbhatta

I will need the database schema Tables Datatypes Constraints (DDL) will be OK I will do it using JDBC-ODBC for you. Writing check conditions as mentioned ...

$1 USD dalam 7 hari
(0 Ulasan)
0.0
aashishm

Hi I am new to this forum. I have experience in MS SQL. From the first instance what i feel is this work can be completed within 5 days even if it has dependencies on multiple tables.

$200 USD dalam 5 hari
(0 Ulasan)
0.0
programmerhb

Sir I have a very good experience in data warehousing, so by looking at your requirements this shouldn't be a problem to me. Thanks

$20 USD dalam sehari
(0 Ulasan)
0.0
abdesignllc

I'm certified MSSQL administrator. I have been working ORACLE and MySQL database since 2004. Thanks

$50 USD dalam 2 hari
(0 Ulasan)
0.0
ebenezerc

Hi I can do this project and complete within 7 days.

$100 USD dalam 7 hari
(0 Ulasan)
0.0
DataGurus

This can be done in a couple of hours.

$85 USD dalam sehari
(0 Ulasan)
0.0
johnsonsv

Hi, I am very much Interested in your project. Thanks, Johnson

$1 USD dalam 0 hari
(0 Ulasan)
0.0
san0425

Hi, I am working in a BPO sector from last 3 years. you can send me details so that i can start my work as soon as possible... Please send me sample work, i will do without any charge... After satisfaction only you Lagi

$100 USD dalam 7 hari
(0 Ulasan)
0.0
hemantnyadav

I need to know how much u need Regular Update

$200 USD dalam 30 hari
(0 Ulasan)
0.0
rhondalam

Please check PM. Thanks!

$10 USD dalam 3 hari
(0 Ulasan)
0.0
shalishalu

we have a very good setup and have a good [url removed, login to view] can give you this perfectly done with quality chk

$110 USD dalam 5 hari
(0 Ulasan)
0.0
lcn1

let me try this. please contact me sir. Thanks.

$250 USD dalam 10 hari
(0 Ulasan)
0.0
ffwd

Data processing is what we I are good at. I'm a little unclear on exactly where the contact info is on the web. It sounds like it is in several databases. If so, the cost may be a little lower. Thank you for considerin Lagi

$250 USD dalam sehari
(0 Ulasan)
0.0