DB Migration into Excel
$10-30 USD
Оплачується при отриманні
I have three DB tables with records in the following format:
********
Table 1 - Country:
insert into `countries` (`id`, `iso`, `name`, `nicename`, `iso3`, `numcode`, `phonecode`) values('10','AR','ARGENTINA','Argentina','ARG','32','54');
Table 2 - Region:
insert into `regions` (`id`, `country`, `code`, `name`, `latitude`, `longitude`, `cities`) values('94','AR','01','Buenos Aires','0','0','205');
Table 3 - City:
insert into `cities` (`id`, `country`, `region`, `name`, `latitude`, `longitude`) values('142','AR','01','Azul','[url removed, login to view]','[url removed, login to view]');
********
Each table has 1000's of records. They need to be migrated into excel file with the following 4 columns:
Continent, Country, State/Province, City/Town
At the end each sample row should look like this:
South America, Argentina, Buenos Aires, Azul
* Obviously you will need to add a continent to each country as there is no one presented in the DB.
ID Проекту: #11861350
Про проект
Доручено:
26 фрілансерів(-и) готові виконати цю роботу у середньому за $27
i need to know which database is this currently? secondly what are common fields? or reference fields? currently the set example dont seems to be accurate as in table 1- Ar is ISO in table 2- Ar is country in tab Більше
hello hope you are doing well I am interested to work on this project. Gladly waiting to serve you with my extensive 8+ years skills.
https://www.freelancer.com/u/MohsanEijaz.html I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I Більше
Hi there! Have done this type of work before and am an excel/db expert! Please feel free to ping me with any additional information or with questions if any! Thanks! -Steve
Hi, i understand your task. i can do it and provide you required information in excel as you need. i am a php programmer and expert in database. i can do it in time limit. Thanking you.
Hi, I am a professional freelancer, and I can complete your task effectively and efficiently in a timely manner.
hi I can complete your job easily. Even i can complete your job within 2 hours. Let's discuss rest of the things on chat. Regards
Hi. i was jus t passing by and i noticed your project. seems pretty easy. i can do it right now. Do you need this in some language specifically (PHP, Python)
With 6.5 years work experience, I am confident that I am the best candidate for your vacancy. My Expertise Areas is Email and Contacts Collections ,Scraping data, On/Off line Data Entry, Product Research, Photoshop, Co Більше
i have 6+ years experience and also have a great knowledge in the ms-sql and also in mysql and mongodb.
PHP,PDO, Core-php, CakePHP, CodeIgniter, Laravel, Yii, Mysql, HTML, HTML5, CSS, JavaScript, Angular js, jquery, AJax, Joomla, E-Commerce Wordpress, Woo-commerce, Open-cart And BUG FIXING etc. When we work for clie Більше
We are PR Technologies. We have a team of experienced Java developers, who works together and contribute to Develop Quality Products. So, if you show some trust, then we will guaranteed for a Best products. Thanks & Re Більше
Hey, I will do your work on time with complete requirements. I have knowledge of DB, PHP and also familiar with excel. I will do your work on time with complete requirements.
I have done such projects earlier. Currently working as developer and handling backend too. You will get full support from me in future also. Thank you in advance.