Find Jobs
Hire Freelancers

Osc mod - upload newsletter address book

$30-250 USD

完了済み
投稿日: 14年近く前

$30-250 USD

完了時にお支払い
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.
プロジェクト ID: 691594

プロジェクトについて

2個の提案
リモートプロジェクト
アクティブ 14年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
アワード者:
ユーザーアバター
Will be done.
$100 USD 2日以内
5.0 (143 レビュー)
6.2
6.2
この仕事に2人のフリーランサーが、平均$150 USDで入札しています
ユーザーアバター
Thanks for invitation ready to start now
$199 USD 3日以内
5.0 (144 レビュー)
6.8
6.8

クライアントについて

SOUTH AFRICAのフラグ
Johannesburg, South Africa
5.0
47
お支払い方法確認済み
メンバー登録日:6月 10, 2008

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。