Sedang Disiapkan

Database Merge

I have three databases.

1. Properietary: List of cities.(around 40,000) [Cityid1, Country Name, RegionName1, City Name, Citycustomname, countrycode]

2. Maxmind Location: List of Cities with additional fields. (300,000) [cityid2, Countrycode, RegionID, CityName, L1, L2]

3. Maxmind Regions (List of Region Codes, Region Label) [Regionid, RegionName2]

I want one database for 40,000 records as mentioned in database #1. The records from 2 and 3 needs to be merged to appropriate rows in database#1. So in the end, the final database with 40,000 rows will have the following structure.

[Cityid1, Cityid2, CountryName, RegionName1, RegionName2, City Name, CityCustomName, RegionID, L1, L2, Countrycode]

This will require both the SQL skills and Manual data verification. This can be done all manually if required but bulk can be done using the database.

Steps required:

a. Merge #2 and #3 to create a database #4. So that you get the regionname+cityname+countrycode combination.

b. Find through the database, all the records that match countrycode, Regionname, Cityname. Merge this data as specified above. Store this data in table #5.

c. Find through the database, all the records in #1 table that do not exist in table #5. Store these in table #6.

d. Manually update records in table #6.

e. Merge table #5 and table #6 to come up with finalized table.

We have a quick method to check for accuracy for each row and we will NOT pay unless the data is accurate for every row in the database.

These are all cities so Countrycode, Region etc should all match up fairly easily for the MOST part.

Again, we are OK if you wish to update the records in an excel sheet manually. We just want the final data and as we said, we can check for the accuracy of all 40K records in one click of a button if done right so do bid only if you are going to do this properly.

Payment will be done upon data verification and project completion.

Attached is our properietary file.
Maxmind files can be accessed at:
http://geolite.maxmind.com/download/geoip/database/GeoLiteCity_CSV/GeoLiteCity_20120403.zip
http://www.maxmind.com/app/fips10_4 (Please choose the appropriate FIPS file listed according to the data in above file).



Again, we want maxmind columns to be added to the allcities.csv (attached) with appropriate values for the row.
Maxmind data has some 300K or more cities. We only want 34K approximate those are listed in the attached excel to be populated with maxmind data columns.

Note: Chinese City names are URL encoded. In the event that cityname column is encoded, please use the citynameunique column. Remove anything after the first dot (.) and you should get the city name in english.

You have all the information now to give the best possible bid.

Kemahiran: Pemasukan Data, Pemprosesan Data, Excel

Lihat lebih lanjut: l2, data structure through c, database merge, i do not exist, database skills, get the label, data entry through sql, row b, merge data, get data entry done quick, database required in excel, data merge, list excel region country, sql merge data excel, excel right click, list combination excel, merge excel project, region city list, excel sql merge, excel sql create, database sheet, match merge excel, region country list, excel cities list, excel combination list

Tentang Majikan:
( 0 ulasan ) United States

ID Projek: #1596912

17 pekerja bebas membida secara purata $179 untuk pekerjaan ini

diamond247

Expert here, please see the Pm for more details

$30 USD dalam 0 hari
(80 Ulasan)
6.5
bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

$200 USD dalam 7 hari
(60 Ulasan)
6.4
panfreelancer

Hi, I can merge database 2 and 3 into 40,000 records mentioned in database 1. Please check inbox for more. Thank you.

$75 USD dalam 3 hari
(31 Ulasan)
5.1
Nhcuong

Hi i can do it, please send the sample of 3 database and clarify more about step "d. Manually update records in table #6." What do you mean by manually? you need also to lookup information from Internet for they are n Lagi

$250 USD dalam 5 hari
(22 Ulasan)
4.9
Panjtan

Hello Sir, I am interested to work on your project, if you do consider. Regards

$180 USD dalam 5 hari
(21 Ulasan)
4.8
katepesic

Hi, I have experience in this job, please contact me

$250 USD dalam 3 hari
(24 Ulasan)
4.3
zeke

Available to start immediately and finish as soon as possible.

$200 USD dalam 2 hari
(11 Ulasan)
4.3
pablotorres

I can do it !

$125 USD dalam 7 hari
(4 Ulasan)
3.4
manohartvs

Hi There, We can have your master table prepared for you and ensure that the work is accurate before presenting the results to you. For 95% of the task, we endeavor that automation techniques will be used. We will Lagi

$250 USD dalam 4 hari
(3 Ulasan)
2.7
lokeshk9936

Hi, I have gone through the csv's and the fips file. Please see PM.

$75 USD dalam 2 hari
(1 Ulasan)
2.2
pksinghai

I can do the task as you want, we are expert in handling database.

$60 USD dalam 3 hari
(1 Ulasan)
1.4
kishore2903

Hey, will do as per your need.

$240 USD dalam 3 hari
(0 Ulasan)
0.0
jvdeguzmancpa

Good Morning, I have excellent skills in excel. I will not manually merge the data but rather use excel formula and macro to do the job. All 40,000 data can be done in 1 day.

$250 USD dalam sehari
(0 Ulasan)
0.0
namanderaan

Basically, its a simple DATABASE FILE PROCESSING--analysis, extraction, manipulation, & storage of which I'm good at. Backed by 20+ professional IT years you can count on the accuracy and timely delivery of the proj Lagi

$250 USD dalam 2 hari
(0 Ulasan)
0.0
jpr0

I have analyzed your files and can do a good job!!!

$150 USD dalam 2 hari
(0 Ulasan)
0.0
vitaliy1427

I'd like to do this project

$150 USD dalam 3 hari
(0 Ulasan)
0.0
sritechnocrat

Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our Lagi

$300 USD dalam 10 hari
(0 Ulasan)
3.8