176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

MySQL/Fusion Table Sync
Sign in to Add to Watch List

IT & Programming > Web Programming

View Change History

The client has made the following changes to the job.

Description
Date
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Mon, Jan 16, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

I have a MySQL table (master) and a Google Fusion Table (slave) that I need to keep in sync. To do this, I have a PHP script that I run periodically with with a cron job. This script is inefficient and I am seeking a programmer to rebuild it with the functionality detailed below, and with a good framework to easily allow further modifications.

I am using the fusion-tables-client-php library (  [obscured]  /p/fusion-tables-client-php/) to streamline the process.

Using the data in the attached places.sql, the following events need to happen:

ID 1: I need to update the Fusion Table using the id_fusion id. Once that is done I need to update the fusion_sync date in my MySQL table to the current time.

ID 2: I need to add this entry into my Fusion Table. Once I do that, I need to update my MySQL table row with the new Fusion Table id of this corresponding row. Lastly, I need to update the MySQL row's fusion_sync with the current time.

ID 3: Nothing needs to happen. The fusion_sync dat...

Sign in or Register to see more

Job ID: 28115810
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 India  |  
Successive Software an ISO 9001:2008 certified global consulting and IT services company highly skilled 100+ IT experts in PHP, ASP.NET, Java, Ruby...
6
  |  
 4.9   |  Private   |  2 Jobs
Bid ID: 28132871  |  Submitted: Jan 17, 2012 10:33 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »