Tamamlanmış

Import XML file into Mysql Database with php or python

Provide a modular command line PHP or python tool (script/s) that parses an XML file (example of structure attached) containing a list of approximately 4500 products with details from one of our vendors and update a Mysql database based on the following rules.

a) if the product does not exist in the database then insert the full record

b) if the product exists and there are no changes then ignore the record

c) if the product exists and one or more of the details have changed, then update the changed fields only. Do not update the entire record.

d) If the product is in the database but not in the XML file delete the record

The item to field mappings will be provided prior to the start of the work.

Deliverables:

1) Tool to import / update / delete records in mysql database from XML based upon above rules.

2) Tool can be written in either PHP or Python.

3) Provide source code for all components that go together to create import tool

4) if tool is made of multiple components all scripts to be contained within a logical directory structure

Happy to answer any questions about the project prior to start.

Beceriler: MySQL, PHP, Python, XML

Daha fazlasını gör: python import xml mysql, python logical and, d python, database scripts with php and mysql, python 3, one line php, import XML, php xml delete, together mysql, import xml file mysql database php, script update database mysql, mysql database import, mysql insert multiple records, insert multiple records, mysql multiple insert, php insert xml, update mysql xml, project 4500, xml import mysql php, import tool

İşveren Hakkında:
( 22 değerlendirme ) Balmain, Singapore

Proje NO: #5290929

Seçilen:

robinsjp

Hi, I work as a project manager in an online retail firm, and I've written several PHP scripts of this nature. I know how optimise insert/update statements for speed (if you process the data line by kind of blindly Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 155%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(2 Değerlendirme)
2.0

Bu iş için 38 freelancer ortalamada $215 teklif veriyor

toinnisfree

I have read your project details, and I am interested in offering my services. I provide 100% satisfaction guaranteed on all my work. Milestone is required to begin; to be released when the job has been satisfactor Daha Fazla

$500 SGD in 7 gün içinde
(596 Değerlendirme)
8.0
SigmaVisual

Dear Client, I can help in your project. We have already experience of working on similar projects. Please see below to get idea of our experience: Amazon/Ebay Bots: [login to view URL] Daha Fazla

$144 SGD in 3 gün içinde
(251 Değerlendirme)
7.9
rajeshsonisl

Hello, With 99% completion rate, 650+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 !!)... you can never go wrong choosing me :) I look forward to your reply. Daha Fazla

$927 SGD in 2 gün içinde
(480 Değerlendirme)
7.4
tlchung

skilled php developer here, have done over 500+ php project for my clients, i can do the import script for you, let start now.

$126 SGD in 2 gün içinde
(156 Değerlendirme)
7.3
gopalvora

Hi ready to start i had more than 5 year experience in the php ,mysql , jquery etc.. so let me know your view Thanks

$144 SGD in 6 gün içinde
(241 Değerlendirme)
7.2
eperfections

Dear Sir, I am TOP RANKED programmer with 600+ reviews on this site. I can write this tool to import xml with rules in PHP. Please award me this project.

$144 SGD in 3 gün içinde
(202 Değerlendirme)
6.9
michale21

A proposal has not yet been provided

$154 SGD in 3 gün içinde
(119 Değerlendirme)
6.8
seekdeveloper

Hi, I have read your post and understood your requirement. I have good experience in handling XML//PHP/Python/Wordpress /Magento/Joomla/Drupal/ HTML5/CSS3Yii framework/Javascript/MySQL/ Kindly go through my Daha Fazla

$515 SGD in 5 gün içinde
(40 Değerlendirme)
6.7
CodingExpertz

Hi, I looked your posting and I am very much interested to work with you ...I am an India based software professional providing a range of IT services and solutions that address the technology needs of your company Daha Fazla

$250 SGD in 3 gün içinde
(99 Değerlendirme)
6.1
cheapexcell

Hello, I am an expert in PHP & XML with over 10 years of experience. Ready to start. Thanks, Alex

$120 SGD in 3 gün içinde
(90 Değerlendirme)
5.9
sunilexpert

I am an expert web developer with 8+ years of developing dynamic web applications and websites. I have experience in PHP, MySQL, Ajax, Javascript etc. You can see feedback against my profile they are always awes Daha Fazla

$250 SGD in 7 gün içinde
(66 Değerlendirme)
5.9
sinharavi

I have 5 years industrial experience in Python+Mysql, and interested in taking this project. I will do this project using Python language. I need some clarification in some of the points of this project. I need t Daha Fazla

$130 SGD in 3 gün içinde
(56 Değerlendirme)
5.6
pixelbypixelsl

PHP / mySQL expert - I can help build this for you without any problem at all. Let me know if you have any questions at all.

$250 SGD in 3 gün içinde
(14 Değerlendirme)
5.5
suriyant

With strong experience in Python. I can do this. Please keep me into your consideration. Look forward to working with you. Thank you.

$147 SGD in 3 gün içinde
(41 Değerlendirme)
5.5
trkr

Hi, How will you run this script from command line i mean what kind of modularity do you need? e.g. /bin/bash/php [login to view URL] Is mysql table ready? If yes, are there any more fields that needs Daha Fazla

$222 SGD in 3 gün içinde
(43 Değerlendirme)
5.3
tanveerjavaid

Hi I am experienced programmer and ready to start work today.. I will do it using php.. so please response. thanks

$155 SGD in 3 gün içinde
(30 Değerlendirme)
5.3
mituld

Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start thanks

$164 SGD in 5 gün içinde
(24 Değerlendirme)
5.0
NTechcorporate

Hi, Hope you are doing well! We have gone through your requirement and we understand that you are looking for highly skilled, qualified, and experience Python development team for your project. Our developer Daha Fazla

$309 SGD in 4 gün içinde
(5 Değerlendirme)
5.0
M5L2764K

Hi, I have about 10 year experience with Python and different databases. I've also done some scripts like this before. I just wonder: if database content must exactly match content of XML file why not start a tra Daha Fazla

$110 SGD in 3 gün içinde
(10 Değerlendirme)
4.8
Batista111

Hi, I understand your requirements. Will import the XML into MySQL following all the rules mentioned by you. Please come on chat for further discussion. I can deliver the project within time upto you satisfactio Daha Fazla

$147 SGD in 3 gün içinde
(21 Değerlendirme)
4.9