Closed

Simple MySql Query Script Needed

This project was awarded to lightcresent for $125 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $250 USD
Total Bids
40
Project Description

Here’s what we need built:

I need a MySql query script witten that will do the following:

1- Query a Magento database every night and write the information to 2 tab delimited text files (one of the text files needs 16 fields queried, the other 2 fields).
2- Email these files to an email address.

The information is information related to Magento orders that were processed in the last 24 hours.

Please see the attached text file that is formatted the way that I need it, only the fileds with MANDATORY in them need to be filled in, just leave the others blank.

IMPORTANT NOTE: The headers in the test files are the SQL Field names in the Magento MySql database, the header information IS NOT necessary in the final product.

When completed, it will work like this:

The script is setup on a chron job, every night (once every 24 hours) the script will execute and create the new files, it will then email the results to an email address.

I need this setup and turned around quickly and will give a bonus for it being done early.

Please, do not bid if you cannot meet the deadlines, I'm sorry for the quick turnaround but this is urgent.

Ultimately we are looking for professionals that we can work with in the future, please keep this in mind.

THIS PROJECT MUST BE COMPLETED IN 2 DAYS MAXIMUM!

If you can turn this around in less than 2 days I will pay a generous bonus!

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online