gallery database update is project number 311836
posted at Freelancer.com. Click here to post your own project.
Bid Count: 33
Average Bid:
$ 90
09/13/2008 at 11:59 EDT
Project Creator:
expoships
Employer Rating: ![]()
![]()
![]()
![]()
![]()
![]()
![]()
![]()
![]()
(4 reviews)
09/09/2008 at 12:46 EDT:
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
09/09/2008 at 16:26 EDT:
The source we are going to use for the import are these two websites:
Artnet.com
Artinfor.com
Both have over 6000 gallery listings
09/10/2008 at 13:06 EDT:
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)
|
Job Type |
|