Find Jobs
Hire Freelancers

Osc mod - upload newsletter address book

$30-250 USD

Completed
Posted almost 14 years ago

$30-250 USD

Paid on delivery
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.
Project ID: 691594

About the project

2 proposals
Remote project
Active 14 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Will be done.
$100 USD in 2 days
5.0 (143 reviews)
6.2
6.2
2 freelancers are bidding on average $150 USD for this job
User Avatar
Thanks for invitation ready to start now
$199 USD in 3 days
5.0 (144 reviews)
6.8
6.8

About the client

Flag of SOUTH AFRICA
Johannesburg, South Africa
5.0
47
Payment method verified
Member since Jun 10, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.