176985602337900

Find freelancers. Lose those costly delays.

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

or, Register with Elance »

CSV into MySQL script fix/modification required
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

Job canceled.

Oct 29, 2009
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Tue, Oct 27, 2009
  • 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 PHP script that is designed to retrieve a comma delimited CSV file from 4 different affiliate accounts, then insert the data into specific MySQL database tables.

What I need:
1. One of the CSVs no longer gets inserted into the database correctly, I believe the structure of it has changed and currently, nothing gets inserted at all. I need my PHP script fixed so it will insert the CSV data as required.


2. The PHP script requests a CSV file for the entire current month's data of each affiliate account each day, it then truncates the specified tables and inserts the new data.
I need the script modified to create month-specific tables on the 1st of each month, eg. table names: 2009_January, 2009_February, 2009_March, etc. and also retrieve the previous month's data and update the previous month's table. (as final stats are often delayed by 24 hours).

This will allow me to store and retrieve data for any specific month.


I will provide:
The PHP script I use to retrieve and ...

Sign in or Register to see more

Desired Skills
MySQL Administration, PHP
Job ID: 18267931
 
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 United States  |  
Expert programmer and web developer specializing in PHP, C#, SQL, LAMP and general web development.
6
  |  
 5.0   |  Private   |  7 Jobs
Bid ID: 18270846  |  Submitted: Oct 27, 2009 15:43 ET 
Proposal SEALED

 Russia  |  
WebMakers is a group of IT-professionals who know the value of a good web-based product: from a simple business-card web site to a complex...
2
  |  
 5.0   |  Private   |  1 Jobs
Bid ID: 18269773  |  Submitted: Oct 27, 2009 13:37 ET 
Proposal SEALED

 India  |  
We are having 10+ years of experience in website design, web development, mobile application, mobile APP & SEO. We are excellent in communication...
5
  |  
 4.6   |  Private   |  5 Jobs   |  1 verified credential(s)
Bid ID: 18269027  |  Submitted: Oct 27, 2009 11:58 ET 
Proposal SEALED

 Germany
ToasterNET is a German-based software and web development firm that specializes in Cloud Server Infrastructure, Cloud Technology Consulting,...
1
  |  
 5.0   |  $55 Earnings   |  0 Jobs
Bid ID: 18268800  |  Submitted: Oct 27, 2009 11:34 ET 
Proposal SEALED

We have completed about 110 projects valued at US$135,159 in elance during our last 12 years in elance. Yes for *TWELVE* long years we have been...
2
  |  
 0.0   |  $0 Earnings   |  0 Jobs   |  5 verified credential(s)
Bid ID: 18268783  |  Submitted: Oct 27, 2009 11:32 ET 
Proposal SEALED

 India  |  
Perfect Info Media determinedly balanced to deliver latest invention of products and services in Web Designing & Development, Software Applications...
Skills: PHP, PHP5
1
  |  
 0.0   |  $200 Earnings   |  0 Jobs
Bid ID: 18268541  |  Submitted: Oct 27, 2009 11:05 ET 
Proposal SEALED

 India  |  
Dedicated Email Server (SMTP) provider with or without Email Blasting Software. Expienrced in Interspire Email Marketer, and have developed own...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 18268528  |  Submitted: Oct 27, 2009 11:03 ET 
Proposal SEALED

 Poland  |  
Experienced programmer highly interested in web development. M
2
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 18268159  |  Submitted: Oct 27, 2009 10:18 ET 
Proposal SEALED

 India  |  
* Strong in building bots / scraper / crawlers / spiders / harvesting program development. I can scrape from any website including those involves...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 18268131  |  Submitted: Oct 27, 2009 10:16 ET 
Proposal SEALED

 Romania  |  
You will find I am a hard working programmer that likes what I do. I have a long list of satisfied clients on Elance, I hope my work, and...
3
  |  
 4.1   |  Private   |  21 Jobs   |  1 verified credential(s)
Bid ID: 18268125  |  Submitted: Oct 27, 2009 10:15 ET 
Proposal SEALED

 India
Supremetech is a leading global web application, E-commerce and software development offshore services provider, offering a wide array of solutions...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 18268090  |  Submitted: Oct 27, 2009 10:12 ET 
Proposal SEALED

 Ukraine  |  
Webdeveloper
Skills: PHP
1
  |  
 4.5   |  $1,390 Earnings   |  3 Jobs
Bid ID: 18268068  |  Submitted: Oct 27, 2009 10:09 ET 
Proposal SEALED
Elance is now an Upwork company.
Upwork is the choise of 4M+ clients. Get started working on Upwork today.
Are you ready to post a job like this one?
Post a Similar Job »