hi, i'm trying to add cities and regions of some counties in the middle east in a my website database from another file that has the same tables (country,regions,cities) but different colmns and format.
you have to put the city# and then the city name in the fallowing format:
(511903, 782777, 'Dasman - دسمان', 'dasman', 'KW', 1),
(511904, 782777, 'Sharq - شرق', 'sharq', 'KW', 1),
also regions and countries need to be added in the same way:
(782777, 'KW', 'Kuwait city - مدينة الكويت', 'kuwait-city', 1),
(782778, 'KW', 'Hawalli - حولي', 'hawalli', 1),
i already did Lebanon and Kuwait.
i need the fallowing counties also:
Bahrain - البحرين
Egypt - مصر
Jordan - الآردن
Oman - عمان
Qatar - قطر
Saudia Arabia - السعودية
Syria - سوريا
UAE - الإمارات
Yemen - اليمن
Iraq - العراق
Palestine - فلسطين
Algeria - الجزائر
Morocco - المغرب
Libya - ليبيا
Tunisia - تونس
Sudan - السودان
please note that you can get the cities from the sql file attached with the post.
you can convert both to an excel-sheet format using this method:
[login to view URL]
and then export back to mysql using the same tool.
(estimated work time of the task 2 hours)
attached is the file that needs to be updated with the lists that already have been entered.
also note that if there are any errors you should do the debugging.
please let me know if more information is needed as i will be in contact with you.
Kind Regards,
Abdulrahman
hello, i can help you convert sql to excel and change format same you want, please contact with me to start, i will complete fast and good for you.
kind regards
$55 USD in 1 day
4.9 (165 reviews)
6.7
6.7
19 freelancers are bidding on average $95 USD for this job
Hello SIr,
I will create a script that will copy all your cities from one table to another
also it will check for duplicate entries and will not save same data more than one time.
I am expert level of web developer and i have already build many web bots that doing same kind of work.
Lets have quick conversation to discuss more before starting.
Thank You
I have been using mysql and sql in general for a long time now. Feel free to message me so that we can talk more about this project. Thank you and have a nice day.
Hi
I am an SQL/MySQL expert with good Excel skills. I can import the records from the SQL file to my MySQL server and then take it to an Excel file. From here I can convert the data to the format you need for your database, and send it as SQL file or can help you to import the data to your tables, if you can give me the access. Look forward to hear from you.
Thanks
Roni
Assalam-o-Alaikum Abdulrahman . . . . . how are you doing. Let me help you with this. This definitely is a simple and small task and I can fix this for you as soon as you assign me this task. The only delay would be me getting the notification of you assigning me the task and me getting online :)
Looking Forward to hear from you.
JazakAllah
PS: its done already (There is no data of Palestine in the files you gave)
Hi,
I have studied the materials you supplied and know I have a better understanding what needs to be done to accomplish your goals. I have already completed a lot of similar projects in the past. I would be delighted to work with you on this project.
High lights of expertise are:- C++, C#, Programming,, Java, JavaScript, Python, PHP, MySQL, linux, HTML, website designing and Development, Web Scraping, Software Architecture and development.
I am eager to hear your comments and answer.
I hope you will massage me.
Hello,
I can convert the database as per your requirement. I can start the work for project right now. Let me know if you are interested.
Thank You
Mayank Verma
i have been working in plsql and sql for 3+ years and can do this task in the provided time.
Resolved this type of issues and have been worked on the middle east projects so i have better idea about this
Hello, we are a web agency creating websites & mobile applications for Android & iOS. We would be happy to assist you. If you would like to see a part of our work and the quality, visit our website at https://webdal.ro. Hoping to collaborate and offer you qualitative work. Best regards, D. Alex - CEO Webdal International