Em Andamento

Website form submission to database

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

Habilidades: Amazon Web Services, Engenharia, PHP, Gestão de projetos, Arquitetura de software, Teste de Software, Hospedagem Web, Gestão de Site , Teste de Website

Ver mais: website html 5 download, vi build, standard website format, mysql city state database, microsoft project template, microsoft phone number, html code for contact form to email, format mask, download code html website, contact form php download, microsoft project management template, h website, visitor management, sql duplicates, need a web database with user management, microsoft sql website, lead gen, ix, database microsoft sql, database html sql, build database sql, build an html email template, Form Fields, database name email phone number, product sales project php mysql

Acerca do Empregador:
( 11 comentários ) United States

ID do Projeto: #3436898

Premiar a:

witscomputing

See private message.

$297.5 USD em 7 dias
(408 Avaliações)
6.8

20 freelancers are bidding on average $260 for this job

MicroXpress

See private message.

$408 USD in 7 dias
(92 Comentários)
7.3
vektormedia2

See private message.

$318.75 USD in 7 dias
(318 Comentários)
6.9
ofer

See private message.

$391 USD in 7 dias
(161 Comentários)
6.4
beeinfo

See private message.

$272 USD in 7 dias
(101 Comentários)
6.4
JeremCollins

See private message.

$212.5 USD in 7 dias
(76 Comentários)
6.2
grupociberia

See private message.

$255 USD in 7 dias
(124 Comentários)
6.2
dzmitrij

See private message.

$97.75 USD in 7 dias
(71 Comentários)
5.9
webexpertzz

See private message.

$297.5 USD in 7 dias
(82 Comentários)
5.8
instantcodervw

See private message.

$85 USD in 7 dias
(56 Comentários)
5.7
eagleeyesvw

See private message.

$85 USD in 7 dias
(61 Comentários)
4.6
vw7979747vw

See private message.

$212.5 USD in 7 dias
(8 Comentários)
4.3
sharifgd

See private message.

$102 USD in 7 dias
(15 Comentários)
3.6
alienaffili

See private message.

$425 USD in 7 dias
(0 Comentários)
0.0
quastechvw

See private message.

$170 USD in 7 dias
(2 Comentários)
0.0
Amitoracle

See private message.

$424.15 USD in 7 dias
(0 Comentários)
0.0
arkconsulting

See private message.

$425 USD in 7 dias
(6 Comentários)
0.0
leeallan

See private message.

$170 USD in 7 dias
(0 Comentários)
0.0
waqarahmadlx

See private message.

$212.5 USD in 7 dias
(0 Comentários)
0.0
vitesolutions

See private message.

$340 USD in 7 dias
(0 Comentários)
0.0