Find Jobs
Hire Freelancers

Comparison Script -- PHP/MySQL and MS SQL

$30-250 USD

完了済み
投稿日: 約12年前

$30-250 USD

完了時にお支払い
Objective: To determine the success rate of our client's direct mail marketing campaigns by comparing the mailing lists against the order database in an ERP. Background: Our client purchases targeted marketing lists from third party companies. These lists include first name, last name, and address information. We currently receive the list--which include multiple list sources--in a comma delimited file with at .txt extension. Current Setup: We currently have a MySQL database storing these mailing list names/addresses and campaign information. We have a quickie custom written upload utility that parses the .txt file and writes information to this database. (The current schema of this database is below.) This information is then processed by our current script which compares the mailing database against the order entry system database. The ERP database currently runs off a separate MS SQL server (which we can replicate to MySQL or leave in place on the MS SQL server). The system compares mailing list information to our names in the ERP. There are two tables in the ERP that are used for our date of creation and our demographic information. If we find the mailing list address and name in our order entry database then a match is found. We can currently pick which mailing list we want and run a scan on just that mailing list. We can also narrow the searches down by the date the customer was created in our order entry system. Current Issues: The system that we have now is very slow and doesn't seem to be accurately matching. I suspect that there are some major bugs in the system. New System Requirements: Rewrite of the analysis script to be more accurate and provide a way to email/download reports. These reports should output the criteria that was used during the scan and list out the mailing list id number along with the number of matches that it finds. We also need a selectable setting that would allow us the ability to set a parameter to do “fuzzy matching” We were trying to use the Levenshtein Distance Algorithm, but we are open to other ideas as to how to do fuzzy matching. Database Name: Mailer Table Name: campaign Fields: campaignID campaign_name campaign_tollfree_number campaign_start_date Table Name: customer_info Fields: customerId customer_firstname customer_lastname customer_street1 customer_street2 customer_city customer_state customer_zipcode plus4 campaignID mailinglistID
プロジェクト ID: 1423584

プロジェクトについて

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

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
アワード者:
ユーザーアバター
I have over six years of experience working with .Net, ASP, SQL, Soap and ASP.Net. See PMB for full qualifications
$200 USD 7日以内
5.0 (2 レビュー)
3.2
3.2
この仕事に7人のフリーランサーが、平均$261 USDで入札しています
ユーザーアバター
Hi ready to start Thanks
$180 USD 8日以内
4.9 (154 レビュー)
6.8
6.8
ユーザーアバター
Thanks for your post, kindly have a look on our PMB.
$300 USD 6日以内
4.3 (34 レビュー)
6.3
6.3
ユーザーアバター
Hello, im highly interested in your project. let's start now. Regards.
$200 USD 4日以内
4.7 (33 レビュー)
5.1
5.1
ユーザーアバター
Hi sir, I am an expert in PHP/MySql. I understand your need clearly and I am interested on this project. Lets have the work. Thanks. J.Sutharsan.
$200 USD 7日以内
5.0 (10 レビュー)
4.4
4.4
ユーザーアバター
We can do this project with in 15 dayas
$250 USD 15日以内
5.0 (1 レビュー)
1.1
1.1
ユーザーアバター
Hi, plz check the PMB for more detail Thanks
$250 USD 10日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

UNITED STATESのフラグ
Ashland, United States
5.0
26
お支払い方法確認済み
メンバー登録日:10月 6, 2009

クライアント確認

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