Export script from a Joomla MySQL Database using PHP

  • Posted
  • Proposals 3
  • Remote
  • #30917
  • Archived
Prithviraj M.Alan C.Alan B. have already sent a proposal.
  • 0

Description

Experience Level: Intermediate
I Need a PHP programmer to write a quick export script to pull out and clense data from a customer order database table and export the data into a CSV file for use in an email marketing program. Need a quick turnaround but I figure it should only a be a couple of hours work for an expert. The details are below, I\'ll give you logins for the DB and FTP on a developmment server. Its a Joomla 1.0 site but the export script can sit outside of Joomla admin.

The idea of the script is to export a usable customer list for email marketing. The problem is the way Joomla and the Virtuemart shopping cart works customer data gets stored all over the place. Here\'s an outline of what the script needs to do. If you can find a more efficient way of getting the data I need out thats fine but here\'s the simpliest way I could find:

1) Go to the table called jos_vm_order_user_info where the customer order data data is stored
2) Check if a column called \'extra_field_1 is blank (if its got a \'1\' in it it means that person has opted out of the mailing list so these rows need to be ignored)
3) for all rows where extra_field_1 is blank we need to ignore all entries where the \'email\' field is NULL
4) This data then needs to be de-duplicated to remove duplicates of the user_id so each user_id is only in the list once
5) with whats left we need to export the following fields to a CSV file:
user_id
title
first_name
last_name
email
6) The export contents need to be a CSV file (with a download triggered, not opening in a browser window) where the first row is a column headings then each of the users and their relevant details loaded into seperate rows

The data will then be used by our email marketing software.

Any questions on the brief please let me know. I\'ll need someone who can complete the job within 1-2 days of acceptance. Thanks a lot for your time

Clarification Board

    There are no clarification messages.