Find Jobs
Hire Freelancers

Import XML file into Mysql Database with php or python

$30-250 SGD

Completed
Posted about 10 years ago

$30-250 SGD

Paid on delivery
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.
Project ID: 5290929

About the project

38 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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, 4500 requests could take a while). To write the code you need shouldn't take more than a couple hours, and I'm fairly certain I can have working code for you later on this evening. The only real question I have is whether you are using any of these XML fields as a primary key, or whether you are using the SKU as a natural key for each stock item, or are you using a surrogate primary key? Would it be possible to show me a full XML feed, as well as what fields you have in your stock table? Thanks a lot, John
$155 SGD in 0 day
5.0 (2 reviews)
2.0
2.0
38 freelancers are bidding on average $215 SGD for this job
User Avatar
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 satisfactorily completed. I estimate a 4-5 day turnaround (including weekends) on this project. ftp details to your site will be required. Contact me at your soonest convenience so we may get your solution delivered quickly. Thanks, coderXO
$500 SGD in 7 days
4.9 (596 reviews)
8.0
8.0
User Avatar
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. Thanks. Kind Regards, Rajesh Soni
$927 SGD in 2 days
4.9 (480 reviews)
7.4
7.4
User Avatar
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 days
5.0 (156 reviews)
7.3
7.3
User Avatar
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 days
4.9 (241 reviews)
7.2
7.2
User Avatar
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 days
4.9 (202 reviews)
6.9
6.9
User Avatar
A proposal has not yet been provided
$154 SGD in 3 days
4.6 (119 reviews)
6.8
6.8
User Avatar
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 in a variety of vertical business segments. Apart from that, I have more than 8 years of expertise in Designing, Development on PHP, MySQL, Apache Solr, CouchDB, HTML, CSS, SEO, Smarty, AJAX, jQuery, Google APIs, Oscommerce and customised ecommerce based projects as well as most of the payment gateways and many other Open Source Technologies and frameworks. Key features why you should consider me for your work - 1. First of all, I am working independently as freelancer, so no restrictions on working hours 2. Always discuss the project deeply before start so that the development would be fast and on-time. 3. Timing: I am online 8-10 hours daily from 9:30 AM to 8.00 PM (IST). 4. Prompt reply through Email or IM. 5. Having a staging server to show the development/updates to client(if required). 6. Development option : per hour, per week, per month, per project. Looking forward for an positive response and a long business relationship. Regards, Nand
$250 SGD in 3 days
4.9 (99 reviews)
6.1
6.1
User Avatar
Hello, I am an expert in PHP & XML with over 10 years of experience. Ready to start. Thanks, Alex
$120 SGD in 3 days
5.0 (90 reviews)
5.9
5.9
User Avatar
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 awesome. I am able to understand and visualize what you are looking for.
$250 SGD in 7 days
5.0 (66 reviews)
5.9
5.9
User Avatar
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 to communicate with you for this. Could you please initiate a chat session for this.
$130 SGD in 3 days
5.0 (56 reviews)
5.6
5.6
User Avatar
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 days
5.0 (14 reviews)
5.5
5.5
User Avatar
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 days
4.9 (41 reviews)
5.5
5.5
User Avatar
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 days
4.7 (30 reviews)
5.3
5.3
User Avatar
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 days
5.0 (24 reviews)
5.0
5.0
User Avatar
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 transaction, delete all data, insert everything from file and commit. Unless there are some unique identifiers generated for new columns, doing this way would be safer and transaction will take care of data being available all the time (assuming you use innodb or something else with row-level locks).
$110 SGD in 3 days
5.0 (10 reviews)
4.8
4.8
User Avatar
Hello Greetings! We went through your project description and came to the conclusion that this project has two parts. First, XML parsing and second, storage of parsed data into MYSQL database based on add/delete/modify business rules. This project needs technical skill set like Testing, PHP,XML, MYSQL and SQL together with strong algorithmic/logical sense for successful delivery. Perfexus team possesses necessary skill set and is highly interested in doing this project. We are a group of individuals having expertise in diverse sectors like Product Development, IT Services, Finance, Marketing, Sales, etc. We work in field of programming, testing, documentation, and data entry. We can deliver your work as per requirement which will be professional, accurate and presentable. Based on our experience we can also suggest some changes which will add value to your application. If you show interest we can discuss this project further. Thanks Perfexus Team
$333 SGD in 10 days
5.0 (1 review)
4.7
4.7
User Avatar
A proposal has not yet been provided
$255 SGD in 5 days
5.0 (6 reviews)
4.6
4.6
User Avatar
hello i can develop python script for this . i completed many projects on bot with mysql database connection from python . i can provide this script exactly as you described . thank you
$130 SGD in 2 days
5.0 (13 reviews)
4.5
4.5
User Avatar
client - read xml and make a record server - recieve the record and insert/ update. also update another table to indicate item was found deleter - delete all not found items in the related table.
$247 SGD in 10 days
5.0 (3 reviews)
4.5
4.5
User Avatar
Hello...I have an experience of more than 4 years in web development and maintenance. I have in-depth knowledge of php, mysql, jquery, paypal integrations, API's, css, html, html5. We have gone through the details you have provided and would be pleased to work on this with you to deliver the results that you have expected and We are sure you will not be disappointed if you give us this opportunity. Our team is experienced, creative & efficient enough to get your job done well. If you have any questions or wish to discuss your project further then please let me know here, we will update you speedy and concise reply with proper manner. I look forward to work on this.
$164 SGD in 3 days
4.7 (21 reviews)
4.0
4.0

About the client

Flag of SINGAPORE
Balmain, Singapore
5.0
22
Payment method verified
Member since May 21, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.