Export script from a Joomla MySQL Database using PHP
4988
$$
- Posted:
- Proposals: 3
- Remote
- #30917
- Archived
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
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
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
John M.
98% (39)Projects Completed
59
Freelancers worked with
55
Projects awarded
47%
Last project
8 Jul 2019
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies