Find Jobs
Hire Freelancers

Large XML File Parse / MYSQL Database Insertion PHP Script

$10-100 USD

Closed
Posted over 8 years ago

$10-100 USD

Paid on delivery
I need a PHP script that will automatically download a LARGE (up to 2.7GB) zipped XML file from this site, under the current year (2015): [login to view URL] The file downloaded needs to be the one with the newest posting date. The script will need to unzip, parse, and insert records into the attached database. The operations should go something like this: 1.) Temporarily turn off all foreign key constraints. 2.) TRUNCATE all database tables that will have data inserted into them, **leaving any extras alone**. 3.) Insert parsed data. 4.) Turn foreign key constraints back on. Database Structure: The database was originally created using exported CSV files that created tables for the various child elements. Several of these are 1:N (one to many) intermediary tables that only contain numeric ID's. **These relationships must be maintained**. Currently all table primary ID's are set to auto increment. If you need to make any changes to the database to get this to work, feel free to do so. The XML files for this project are very large, you will most likely need to use a streamer to parse the data. I would also like the script to temporarily raise all necessary server resources to deal with the operation (ie, time outs, max execution times, memory, etc). Possible resources for dealing with XML size: [login to view URL] [login to view URL] I have attached all project files (XML, DTD, Database SQL file, Database Schema PDF).
Project ID: 8911665

About the project

8 proposals
Remote project
Active 8 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
8 freelancers are bidding on average $217 USD for this job
User Avatar
Hello! With 98% to 99% completion rate, 850+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page https://www.freelancer.com/u/rajeshsonisl.html !!)... you can never go wrong choosing me :) I am available to get started on your project right away. I look forward to your reply. Thanks. Kind Regards, Rajesh Soni
$578 USD in 3 days
5.0 (1024 reviews)
8.8
8.8
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 3-4 day turnaround (including weekends) on this project. ftp details to your server will be required. Contact me at your soonest convenience so we may get your solution delivered quickly. Thanks, coderXO
$300 USD in 5 days
4.9 (792 reviews)
8.3
8.3
User Avatar
Dear Sir/Madam, I Have already read your project description & fully understand this project for you. Also I have solid experienced professional in-house team of designers, developers and coders. We are offering best price in this market & providing best quality of work for you. Please check your PMB for more details & award me for this project. ~~~~~~~~~~~~~~~~~Few reasons to select us as a service provide~~~~1. Post delivery free bug fixing support.------- 2. Industry standard modern design.------- 3. Secure coding SQL injection and XSS (cross site scripting),------- 4. Well documented code.------- 5. Regular work update. ~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~ Thanks with Regards
$100 USD in 3 days
5.0 (411 reviews)
8.0
8.0
User Avatar
HI, I will create a code in php which will download the zip files which contains xml data then unzip and then upload to database. Thanks
$88 USD in 1 day
4.9 (24 reviews)
5.7
5.7
User Avatar
hands on experience in Linux platform and php development will provide you excellent documentation and support feel free to contact me in case of any queries
$350 USD in 10 days
5.0 (1 review)
2.7
2.7
User Avatar
Hello, We have Experienced Professionals with 12 years of Web Development & Designing, Application Development, Desktop Application, ERP Software, Android App. Development. I-phone Development expertise. We have worked on several UK, USA, CANADA, AUSTRALIA, INDIA, and SOUTH AFRICA
$61 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi. I am a Senior VB.NET Developer living in Paris, I have read your specifications and i want to realize your application. i have already developed several applications which parse CSV, TXT, or DAT files and imported all their data into an SQL Database. In my Folio you'ill find for example CSV Importer DB Tool i have develop in WPF Full MVVM using Sage API which allowed the user to select a folder, select several CSV files. and click to load them and calulate and preformat them before inserting into the SQlServer database. That's why if you choose my bid i can customize this software to match with your need. I invite you to see in my folio the kind of application i have realize for an idea. You can contact me for any questions else. Kind regards
$200 USD in 3 days
0.0 (1 review)
0.0
0.0
User Avatar
I've been working with SQL databases, and MySql in particular, for more than 3 years and have enough experience to write the PHP script you need.
$61 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Salt Lake City, United States
5.0
4
Payment method verified
Member since Oct 24, 2015

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.