I gang

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)

Færdigheder: Databehandling

Se mere: 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

Om arbejdsgiveren:
( 5 bedømmelser ) Bonita Springs, United States

Projekt-ID: #311836

Tildelt til:

Obialo

Hi, kindly see your PM, thanks

$100 USD in 5 dage
(12 bedømmelser)
4.7

31 freelancers are bidding on average $95 for this job

algie123

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

$2 USD på 1 dag
(26 bedømmelser)
4.8
maribel1218

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

$30 USD in 0 dage
(5 bedømmelser)
4.4
EServe

Please check PM.

$125 USD in 7 dage
(6 bedømmelser)
4.1
edatawiz

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

$100 USD in 10 dage
(7 bedømmelser)
3.4
codernow

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

$130 USD in 5 dage
(0 bedømmelser)
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 in 8 dage
(0 bedømmelser)
0.0
amit240881

Please check the PMB

$1 USD på 1 dag
(0 bedømmelser)
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 in 7 dage
(0 bedømmelser)
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 in 5 dage
(0 bedømmelser)
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 på 1 dag
(0 bedømmelser)
0.0
abdesignllc

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

$50 USD in 2 dage
(0 bedømmelser)
0.0
ebenezerc

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

$100 USD in 7 dage
(0 bedømmelser)
0.0
DataGurus

This can be done in a couple of hours.

$85 USD på 1 dag
(0 bedømmelser)
0.0
johnsonsv

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

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

$100 USD in 7 dage
(0 bedømmelser)
0.0
hemantnyadav

I need to know how much u need Regular Update

$200 USD in 30 dage
(0 bedømmelser)
0.0
rhondalam

Please check PM. Thanks!

$10 USD in 3 dage
(0 bedømmelser)
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 in 5 dage
(0 bedømmelser)
0.0
lcn1

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

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

$250 USD på 1 dag
(0 bedømmelser)
0.0