In Progress

Traffic Mail Web Application

Purpose: Develop tool for staff to use to prepare solicitation letters to prospects who have received traffic tickets. Data arrives in CSV format and is uploaded to existing db.

Already Completed: Head attorney for firm is a former ASP programmer and has written a basic VB6 app to upload the data to the MSSQLExpress server. DB triggers have already been written to put the data in the correct tables. An intranet site has been setup (on the same machine as the SQLServer), templates developed etc in Dreamweaver MX.

Scope of Work: Develop ASP or ASP.NET web front end for data entry and data retrieval for staff use (ie. user friendly). It should integrate with MS Word 2000's mailmerge feature so that the user can select the letter to be used for a particular criminal charge. Additionally we will need to print envelopes from the same mailmerge. Each day's campaign will be a new marketing campaign. The SQL query for the various mailmerges will only pull traffic tickets which are 21 days prior to trial date AND do not already have a marketing campaign associated with the record. When a prospect has been sent a letter, we will give the prospect a marketing campaign id. This will be fairly evident when you see the data structure.

Once letters have been snail-mailed, prospects will hopefully call us. We need a way to find that prospect in the db, see the criminal charges and contact info for the prospect, and the ability to mark in the campaign table if the prospect has hired us. Additionally, we need to convert prospect to client in our [url removed, login to view] table (a lookup table).

Finally, we need to some basic reports for management purposes so that I can send my attorneys to the correct court (by county) to handle the tickets on a particular day. Phase 2 would have a way for the attorney or staff to enter the disposition of the ticket into the db. Phase 3 would be an export of new client to Quickbooks via their API.

Here are the list items on the website for application tasks.

Upload File from [url removed, login to view]

Create Form Letters for all traffic tickets except DWI

Create Form Letters for DWI

Create Marketing Campaign

Mark Tickets as Processed

Incoming Prospect/Client

Search

Case Summary

Code Requirements: Code needs to be written in ASP (preferred) or ASP.NET 2.0. Code MUST Be documented in English and block formatted. Code should be as efficient as possible and have proper error handling. Include files or the ASP.Net equivalent should be used when possible to minimize code changes and web design changes. I would like the files to be readily transferable from web server to web server without having to load COM objects or special DLLs or having custom web server configuration files.

Data Structure: To be shared upon request.

Security: This is an internal application. Ideally, it uses MS Domain security (ie. Integrated Windows Security). In connection setup, I would like advice on a secure way to hide db connection passwords as I never understood that very well.

This application will eventually be integrated with a contact management tool which uses the same db tables etc. Data structure is already in place.

I am paying a monthly fee for the data stream of traffic violations so I would like to get letters out very soon to start recouping my costs.

The developer will be working on a development server set in the DMZ of my network. If developer is using ASP.Net, then developer will need to configure web server for .Net. Latest .Net service packs are already installed.

Access will be via remote desktop connection.

Payment: I got burned by the previous service provider whom I paid half the money and he did nothing for 2 months (even though he was a toprated provider). Therefore, payment will not be released until work is done.

Skills: ASP, Visual Basic

See more: you mail, written letters, who needs to design web, which application do i need to design a website, web visual design, web traffic com, web tool design, web templates create, web structure design, web site error, website design templates for asp net, web site design costs, website by traffic, website api request programmer, web search tool, web programmer find, web mark, web format, web design uses, web design templates code, web design & programmer, web design mx, web design mail, web design info block, web design from start

About the Employer:
( 0 reviews ) Carrboro, United States

Project ID: #193707

Awarded to:

Finexpert

We are a company able to do this work in a very short time. look at our profile [url removed, login to view]

$800 USD in 7 days
(0 Reviews)
0.0

23 freelancers are bidding on average $1124 for this job

lightcresent

Check PMB for Details... Thanks

$1001 USD in 21 days
(101 Reviews)
7.1
pgcoding

please check pmb.

$1100 USD in 30 days
(9 Reviews)
6.2
Maestros

Plz Chk PMB

$1450 USD in 30 days
(17 Reviews)
6.2
inavigator

it is really bad to hear about your past experience. we can do this, we already done similar type of task. please check PMB

$1500 USD in 30 days
(4 Reviews)
6.2
dsendra

We can code this project. We have 16+ years of programming experience and over 8 in ASP/PHP. We are also database programming experts, bearing years of knowledge on the subject. Our price: $ 790 to code this project. P More

$300 USD in 25 days
(13 Reviews)
4.6
SICS

We can do this

$1300 USD in 30 days
(4 Reviews)
4.4
QualityService

We can do this project within time; please see PMB for more details.

$1500 USD in 30 days
(2 Reviews)
4.2
StanKryloff

Hello!!! My name is Stan Kryloff. I'm a 33-year-old Web Developer from [url removed, login to view], Russia. I graduated from the [url removed, login to view] Electrotechnical University in 1997. Since 1997 I'm working in aviation enterprise (dev More

$1000 USD in 30 days
(2 Reviews)
3.9
ranganathp

Can help... check my reviews... costs more...

$1500 USD in 30 days
(3 Reviews)
3.7
animeshtyagi

Dear Sir, We have developed 4 traffic mails Web application Please check PMB........Regards,Animesh

$1000 USD in 25 days
(3 Reviews)
3.1
SoftSandila

all payments through escrow only with partial payments being released step by step. regards adnan

$1100 USD in 18 days
(3 Reviews)
3.1
xueyonglantian03

We have abundant experience in developing websites and can complete this project in the least time, meanwhile we can give you our best quotes and delivery, and the project quality can also be guaranteed .We sincerely w More

$780 USD in 20 days
(1 Review)
2.8
abelsoftcons

Hello We are a 5 year old software development firm based in Mumbai, India. We have a good bit knowledge of the police working system in USA, we were a 3 party vendor for Enforsys a few years back. Please check PM for More

$1000 USD in 25 days
(0 Reviews)
0.0
pbarbas

Top quality work. See PM please.

$1450 USD in 35 days
(0 Reviews)
0.0
ahmedlatif

i think we have a good team to finish this project before the end time

$1100 USD in 20 days
(0 Reviews)
0.0
nitinsharma23

i can build the project in maximum 30 days on getting the confirmation and all specification about the project.

$500 USD in 30 days
(0 Reviews)
0.0
ixoye4u

This bid is for 30 hours of my time. I can start now. I have 7 years experience with ASP and SQL Server working at a 5 billion dollar company.

$1350 USD in 28 days
(0 Reviews)
0.0
K20Italia

Your problem found its solution! Please choose us, and you will have a perfect work in time.

$700 USD in 20 days
(0 Reviews)
0.0
teamj001

Pls refer to PM.

$990 USD in 30 days
(0 Reviews)
0.0
lilysoft

Our Developemt Tearm will delivery the code to you in time, with a suitable price and all the Copy Right of the Code, also we will provide the great customer services for our clients, and love to have a long time relat More

$1500 USD in 28 days
(0 Reviews)
0.0