Find Jobs
Hire Freelancers

Osc mod - upload newsletter address book

$30-250 USD

Slutfört
Publicerad nästan 14 år sedan

$30-250 USD

Betalning vid leverans
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

Om projektet

2 anbud
Distansprojekt
Senaste aktivitet 14 år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
Tilldelad till:
Använd avatar
Will be done.
$100 USD Om 2 dagar
5,0 (143 omdömen)
6,2
6,2
2 frilansar lägger i genomsnitt anbud på $150 USD för detta uppdrag
Använd avatar
Thanks for invitation ready to start now
$199 USD Om 3 dagar
5,0 (144 omdömen)
6,8
6,8

Om kunden

Flagga för SOUTH AFRICA
Johannesburg, South Africa
5,0
47
Verifierad betalningsmetod
Medlem sedan juni 10, 2008

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.