Update PHP Scripts / Automated Data Downloads etc.

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

*Background.

I currently have a server that accesses third party data feeds to populate my database of Mobile Phone Deals.

This is the current way it works:

1. PHP Scripts on my server downloads a ZIP file from a specific Data Feed URL

2. It extracts the ZIP file which contains a CSV file.

3. The Data in the CSV file is then split and imported into the Database into specific fields.

This Process is repeated per Retailer (currently there are 9 retailers).

Most of the CSV data is in singular data points (i.e. a column has only a single value in it) however there are a couple of columns which contains a JSON object with multiple data points in it.

*Database

It is currently configured like this:

DB Name: Feeds

Tables:

- Products – contains all product based information

- Tariffs – contains mobile phone tariff information

- Deals – contains the actual deals information

- Gifts – contains specific free gift information

*Requirements

I need to update the Data Feed Data base with several new requirements:

Req. 1:

Add the following new fields to the Deals table in the Feeds Database

- Tariff Name

- Tariff Minutes

- Tariff Texts

- Tariff Data

- Tariff Type

- Network Name

Req. 2:

Update the Data Feeds script to populate these new fields from the automated data feed. I believe you’ll find the mappings scripts within a file called [login to view URL] located on my server.

*Bidding:

- Tell me the name of the Database to show me you've actually read this brief before you've bid.

- Automated bids and messages will be ignored (and possibly reported to Freelancer if you spam me.)

- Freelancers that show proof of similar work will be shortlisted

- Only bid if you are confident you can do this

- The bid will be the final milestone price. I do not expect to renegotiate once you've been awarded the project.

Good luck

Database Administration Linux MySQL PHP SQL

Project ID: #15137898

About the project

35 proposals Remote project Active 6 years ago

Awarded to:

£25 GBP in 0 days
(16 Reviews)
3.6

35 freelancers are bidding on average £169 for this job

minhhoangduc

Hello, I'm a PHP/Codeigniter/Laravel/Slim Framework CERTIFIED EXPERT developer. And have a lot of experience with System admin + Html + Javascript + CSS + API integration. Your DB name is Feeds. Relevant Skills and E More

£150 GBP in 2 days
(630 Reviews)
8.4
pointlogic

Hello..I have read your project details and i think i can do that well. Relevant Skills and Experience I have in-depth knowledge of php, mysql, javascript , jquery, paypal integrations, API's, css, html, html5, wordpr More

£194 GBP in 5 days
(324 Reviews)
8.1
mrroberto

Mobile Phone Deals. hi, i can help. if you interested, please contact me Relevant Skills and Experience i have all needede expierence Proposed Milestones £222 GBP - escrow

£222 GBP in 5 days
(318 Reviews)
7.6
srinichal

Looking forward to discuss further details about the project Relevant Skills and Experience expertise in custom softwares Proposed Milestones £222 GBP - milestone

£222 GBP in 6 days
(142 Reviews)
7.4
a4logic

Database name = Feeds i know after award project price will not change so i am agree with this price which i bid we worked for uk company like 100+ projects i can show you my portfolio We can give you 100% perfect r More

£222 GBP in 4 days
(152 Reviews)
7.0
pofilippov

DB Name: Feeds. I will do it. Relevant Skills and Experience This is a simple task. I've done it hundreds of times. Proposed Milestones £50 GBP - Pay after I deploy your project on my development server £172 GBP - Af More

£222 GBP in 4 days
(40 Reviews)
6.8
smartwinz

Hi Greeting of the day!! I have very strong PHP, third party data feeds, CSV and MySQL skills.I can able to start working on your project immediately. Relevant Skills and Experience PHP, CSS, HTML, PSD, Website Desig More

£444 GBP in 3 days
(83 Reviews)
7.1
schoudhary1553

Greetings sir, i can help you to complete req1 and req2 and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have the 5 years of More

£250 GBP in 3 days
(73 Reviews)
6.6
skrmm1

Hello. The database name is "Feeds" :) I expect to spend one day examining existing code and make some tests to better understand how it works and then make a backup and start working on the project. Relevant Skills a More

£222 GBP in 4 days
(99 Reviews)
6.5
glennwilkins

(Feeds) pm me i will finish this asap... Relevant Skills and Experience (Feeds) pm me i will finish this asap... Proposed Milestones £120 GBP - (Feeds) pm me i will finish this asap... (Feeds) pm me i will finish th More

£120 GBP in 0 days
(178 Reviews)
6.3
mkjtunna

here is your DB name : DB Name: Feeds i read your project description and would like to help you with it. i have more then 5 years of Web Designing and Development experience. Relevant Skills and Experience i can fin More

£150 GBP in 3 days
(143 Reviews)
6.0
MohanKumar28

Hi, The database is : Feeds. Have gone through the requirements. Will do this. Please contact for further discussions. Thanks, Mohan Relevant Skills and Experience PHP/Mysql Proposed Milestones £111 GBP - Complete More

£111 GBP in 2 days
(106 Reviews)
5.9
RajakScripts

DB name: Feeds. I can help you to accomplish that, very very confident! Just attach the script so I can modify it and then provide you the demo! Relevant Skills and Experience PHP and MySQL are my routine and web scra More

£120 GBP in 3 days
(43 Reviews)
5.8
luminous15

Greetings. The db name is Feeds. I think I can help you out with this task assuming that all the required details are available in the automated feed. Thanks,

£95 GBP in 2 days
(51 Reviews)
6.1
oliviainfotech

Hi greetings of the day I am a Experienced PHP Developer based out in Chennai,India. My experience revolves around development of web and mobile applications,Ecommerce websites. Relevant Skills and Experience I believ More

£250 GBP in 3 days
(73 Reviews)
5.4
shahalam7303

Hello, I have properly gone through your job description and understood your requirements. I'm very eager to work on this project. Relevant Skills and Experience I'm very skilled and expert on Web development, Graphi More

£150 GBP in 3 days
(7 Reviews)
4.9
VirtualBrainInc

I have briefly checked the description on web development, and I can deliver as per the requirements however I need us to discuss for more clarity on the details, deadline and budget as well. Relevant Skills and Exper More

£150 GBP in 3 days
(7 Reviews)
3.9
amitadubey

Feeds I am specializing in web development, web design and app expert.. We offer a wide range of experience & expertise. We provide these services to offshore clients across the globe. experience in web application d More

£220 GBP in 3 days
(29 Reviews)
3.6
navabiradar

Hello! I am a full stack PHP developer. I develop PHP application for e-commerce market place. I use MySQL and MySQL and Postger sql as database. I also have following skills: HTML5 CSS3 Javascript Jquery pHP More

£23 GBP in 1 day
(14 Reviews)
3.4
aggarwalgautam

Name of database is Feeds. I am confident that I can do this job. Relevant Skills and Experience PHP, CodeIgniter, Symfony, SQL, MySQL Proposed Milestones £100 GBP - Will complete and test the task Will love to have More

£100 GBP in 3 days
(3 Reviews)
1.5