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!