I need an addon that will work with a custom newsletter function that we have added to an osc website.
Create an admin function where admin can download a CSV file (excel spreadsheet), drawing the data from TABLE_NEWSLETTER_MAILLIST. The information shown in the spreadsheet must be :
1. customers_firstname
2. customers_lastname
3. customers_email_address
4. customers_newsletter
Admin can then change information or add new subscribers on the excel spreadsheet, save it as a CSV and upload it again in admin.
This function must use it’s own interface page in admin and look like a normal osc admin page.
The link for this will be added to an existing box in admin (just give us the link and we will add it)
When admin uploads a new excel sheet in admin, it must check that the (customers_firstname + customers_lastname) do not already exist in the database. If the customer is already in the table, then it must not upload them again.
The following fields must be populated in TABLE_NEWSLETTER_MAILLIST as follows:
1. customers_firstname taken from the excel upload
2. customers_lastname taken from the excel upload
3. customers_email_address taken from the excel upload
4. customers_newsletter: taken from the uploaded document
5. Newsletter_type: automatically insert value= 1
6. Customer_country: automatically insert value= 0
7. Customer_province : automatically insert value = 0
8. Process_language : automatically insert value = english
9. Customer_id : Must check if there is already an ID for this customer>0 (not every customer has an ID).
If the customer already exists, check to see if the email address is the same. If it is the same, ignore this customer (insert nothing into the table). If the email address is different, then update this customer’s info (do not insert it as a new entry). If the customer does not exist, INSERT as a new entry with customer_id=0
I m not sure, but the CSV document might need an additional column at the end to indicate that this is the end of the row. Eg. ENDROW
I will need to know how the excel document must be saved for import (tab delimited, comma delimited, etc.)
IMPORTANT
I need this done as if it is a contribution, with clear installation instructions. I will be giving you access to a copy of the real site so that you can access files, upload and test, but I will then need to install this on the live site afterwards. Payment will be held in Escrow/milestone payment until it is installed and working on the live site, which we will do immediately that you give me the information.
Please only bid if you have experience with custom osc add-ons. This site is highly modified.
Please only bid if you will be available on YM during the project and can work hours that are compatible with mine (GMT 8am-8pm). I will be available during these hours in case you have any questions or encounter any problems.