Find Jobs
Hire Freelancers

Convert XML shop offer data to SQL Statements

€30-250 EUR

Completed
Posted over 12 years ago

€30-250 EUR

Paid on delivery
Get shop offers with XML from affiliate networks and convert them to SQL Statements (in mySQL Format). Your job is to write and deliver code in JAVA (PHP and Perl if not possible) that does the following: - Get offer data of six product categories from four partner shops of two affiliate networks (Zanox & Tradedoubler) on a daily basis. - The data are accessible in XML format in zipped files up to 18 MB size. XML is up to 240 MB. - You will get a list of XML tags for data extraction and a definition of a SQL [login to view URL] is validated with a schema. SQL should be importable on developer db. - The target data will be a SQL import file (UTF8). Enclosed you will find an import scheme for the Zanox affiliate-network (that still might be subject to changes).
Project ID: 1254353

About the project

19 proposals
Remote project
Active 12 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 am confident to handle your project. Please check your inbox, thank you.
€150 EUR in 4 days
4.7 (121 reviews)
6.2
6.2
19 freelancers are bidding on average €183 EUR for this job
User Avatar
Highly skilled Java Programmer here. Done similar jobs in past. Ready to take of this project. Please provide sample xml file.
€250 EUR in 3 days
4.8 (550 reviews)
7.7
7.7
User Avatar
I can do this for you. See PM for details.
€150 EUR in 3 days
5.0 (389 reviews)
7.3
7.3
User Avatar
I can deliver a perl script or PHP for the same
€250 EUR in 5 days
4.8 (147 reviews)
7.4
7.4
User Avatar
Please check PMB.
€200 EUR in 7 days
4.8 (115 reviews)
7.1
7.1
User Avatar
I have done similar project
€250 EUR in 5 days
4.7 (19 reviews)
6.8
6.8
User Avatar
I am very good expertise in web/Xml technologies but new to freelancer. I can finish this project efficiently
€120 EUR in 3 days
5.0 (13 reviews)
5.7
5.7
User Avatar
hi can u please give a sample along with sample output
€200 EUR in 15 days
4.9 (31 reviews)
5.5
5.5
User Avatar
Greetings. I'll write a well-structured application for exporting the necessary data to SQL. The application will consist of four modules - an unzipper, a parser, a mapper and a sql generator. I'll make the 'xml tag - table field' mapping easily customizable, in case the table structure or xml schema changes in the future. Depending on your needs, the scheduling mechanism can be made internal (in the application itself) or external (calls to the application from the operational system or another application).
€150 EUR in 3 days
5.0 (2 reviews)
4.5
4.5
User Avatar
I am an experienced JAVA developer. I can complete this work using JAVA. Please check PM
€150 EUR in 3 days
5.0 (8 reviews)
4.2
4.2
User Avatar
Please see your PM, thanks.
€150 EUR in 3 days
5.0 (7 reviews)
4.0
4.0
User Avatar
please refer PMB for details
€150 EUR in 4 days
5.0 (2 reviews)
3.6
3.6
User Avatar
am ready and done such requirements
€180 EUR in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
HELLO SIR PLEASE CHECK PMB
€220 EUR in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Sir/Madam, Please check your PMB.
€150 EUR in 3 days
0.0 (1 review)
0.0
0.0
User Avatar
Hello, I'm ready to deliver a Java/Groovy solution (depending on your choice).
€100 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi , I am ready to do the job for you .
€180 EUR in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
periodic cron job runs every x number of minutes, invokes perl script to go through the downloads list you provide, fetch each .zip file, extract xml files, parse each of those for desired information and then prepare INSERT statements to join into a .sql text file which will be loadable into your db using your standard mysql command line tools. I have experience with all of this as well as related CPAN modules for handling zip and xml files plus extensive experience hand crafting custom SQL statements for mysql. Also lots of other experience with all things related to web automation.
€250 EUR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Sir, This is Chirag Sathvara from Gujarat Technologies PVT LTD. And My Designation is Branch Development Manager out here. Company Introduction - Gujarat Technologies PVT LTD was incorporated in the year 2006. In the year 2006, Gujarat Technologies PVT LTD started their first international assignment. The company pioneered the global delivery model for IT services with their first offshore client in 2006. In the year 2008, the company set up first IT R & D division, the Gujarat Technologies PVT LTD Research Design and Development Center at Ahmedabad. In the year 2009, the company opened their new corporate training facility at Ahmedabad. In the year 2010, We started virtualization of business. We want to work on your project, For Any Queries Message us. Regards Chirag Sathvara Gujarat Technologies PVT LTD
€225 EUR in 20 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GERMANY
Weilheim, Germany
5.0
17
Payment method verified
Member since May 3, 2011

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.