Website form submission to database

完了済み 投稿 Jul 11, 2011 着払い
完了済み 着払い

We require a new method to retain the records of visitors that submit the request form on our websites.

We currently have 34 micro websites on a shared server that all utilize a standard asp/html template. With the exception of some text and images they're all virtually identical. On those websites is a small lead gen form that, when submitted, emails the visitor's contact info to the sales person setup for that website. We need to now have the form save the visitor's record in a central database. Then records can then be exported to a .csv file - See the detailed description.

Also, I should have been more clear... We also need the database to be created in this project - the complete solution

## Deliverables

We require a new method to retain the records of visitors that submit the request form on our websites.

We currently have 34 micro websites on a shared server that all utilize a standard html template. With the exception of some text and images they're all virtually identical. On those websites is a small lead gen form that, when submitted, emails the visitor's contact info to the sales person setup for that website.

**What we need is:**

A central database to retain the values. This can be built using MySql.

(1) For all of the fields in the request form to be required, i.e. an alert will display if anyone of the fields has no entry. The fields are: Name, Email, Phone number, City, State (drop-down), and product interest (drop-down). Also, the phone number field needs to mask as the user enter their phone number to the (xxx) xxx-xxxx format.

(2) This form needs to continue to email visitor contact info to a designated email address when submitted (no change in current email function).

(3) When submitted this form needs to save the record in a central database (DB).

(4) Also, I should have been more clear... We also need the database to be created in this project - the complete solution. Forms, function and database.

**Database requirements:**

(1) Datebase built using MySQL for when the visitor enters values into the form fields on the form (all will be required) and submits.

(2) The visitor record is stored in the database with a timestamp (date & time). The form values as well as a unique ID value (for that particular website form), lead type value, and lead source value are stored.

(3) Download DB records: At set times (i.e. 11AM and 6PM) the database should automatically generate a .csv file and make it available for download (FTP). The download will happen manually so there may be times when there are multiple .csv files waiting. ALL records that are not flagged will be included on .csv file and stored in determined location.

(4) All records that are included on their corresponding .csv file will be flagged (so they will not be duplicated on next .csv file).

(5) Values that will be include:

a. BranchNumber

b. CustomerNam

c. CustomerEmail

d. CustomerPhone

e. CustomerCity

f. CustomerState

g. ProductsOfInterest

h. LeadType

i. LeadSource

The sites are in ASP and the database can be built in mySql

(1) Must be able to build a Microsoft SQL database that will:

a. Retain the forms values submitted from the web lead forms. About 35 forms that are identical except for the unique ID number and product options.

b. Generate a .csv file for export containing the visitor records NOT flagged as included in previous export .scv file (i.e. new records only, no duplicates).

c. Generate the .csv file at 11am and 6pm EST

d. Records to contain the values for:

i. Unique form ID number (sent in from each form for each domain)

ii. VisitorName (form field value)

iii. VisitorEmail (form field value)

iv. VisitorPhone (form field value)

v. VisitorCity (form field value)

vi. VisitorState (drop-down menu value)

vii. ProductInterest (drop-down menu value)

viii. LeadType (value will always be "website")

ix. LeadSource (value will always be "usiwebsite")

e. Flags visitor records that have been included in previous .csv files so they are not included in additional .csv files (i.e. No duplicate records exported - new records only).

(2) Must be able to build the web lead form in .asp that will:

a. Save the form values to the database referenced above including the unique form ID when submitted.

b. Email the form field values to an email address designated somewhere where it can be updated.

c. Make the six user input values required before submitting. Otherwise displays an alert.

d. Mask the Phone number field so that it automatically places the parenthesis in the area code, (i.e. 8011234567, 801-123-4567, [url removed, login to view] or any other combination is displayed on the form and saved in the database as (801) 123-4567

アマゾンウェブサービス エンジニアリング PHP プロジェクト管理 ソフトウェアアーキテクチャ ソフトウェアテスト ウェブホスティング ウェブサイト管理 ウェブサイトのテスト

プロジェクトID: #3436898

プロジェクトについて

20個の提案 リモートプロジェクト アクティブ Jul 19, 2011

アワード:

witscomputing

See private message.

$297.5 USD 7日以内
(408レビュー)
6.8

20人のフリーランサーが、平均$260 で、この仕事に入札しています。

MicroXpress

See private message.

$408 USD 7日以内
(92件のレビュー)
7.3
vektormedia2

See private message.

$318.75 USD 7日以内
(318件のレビュー)
6.9
ofer

See private message.

$391 USD 7日以内
(161件のレビュー)
6.4
beeinfo

See private message.

$272 USD 7日以内
(101件のレビュー)
6.4
JeremCollins

See private message.

$212.5 USD 7日以内
(76件のレビュー)
6.2
grupociberia

See private message.

$255 USD 7日以内
(124件のレビュー)
6.2
dzmitrij

See private message.

$97.75 USD 7日以内
(71件のレビュー)
5.9
webexpertzz

See private message.

$297.5 USD 7日以内
(82件のレビュー)
5.8
instantcodervw

See private message.

$85 USD 7日以内
(56件のレビュー)
5.7
eagleeyesvw

See private message.

$85 USD 7日以内
(61件のレビュー)
4.6
vw7979747vw

See private message.

$212.5 USD 7日以内
(8件のレビュー)
4.3
sharifgd

See private message.

$102 USD 7日以内
(15件のレビュー)
3.6
waqarahmadlx

See private message.

$212.5 USD 7日以内
(0件のレビュー)
0.0
leeallan

See private message.

$170 USD 7日以内
(0件のレビュー)
0.0
arkconsulting

See private message.

$425 USD 7日以内
(6件のレビュー)
0.0
Amitoracle

See private message.

$424.15 USD 7日以内
(0件のレビュー)
0.0
quastechvw

See private message.

$170 USD 7日以内
(2件のレビュー)
0.0
alienaffili

See private message.

$425 USD 7日以内
(0件のレビュー)
0.0
vitesolutions

See private message.

$340 USD 7日以内
(0件のレビュー)
0.0