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


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.

Taidot: ASP, Visual Basic

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) Carrboro, United States

Projektin tunnus: #193707

Myönnetty käyttäjälle:


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 7 päivässä
(0 arvostelua)

23 freelancers are bidding on average $1124 for this job


Check PMB for Details... Thanks

1001 $ USD 21 päivässä
(101 arvostelua)

please check pmb.

1100 $ USD 30 päivässä
(9 arvostelua)

Plz Chk PMB

1450 $ USD 30 päivässä
(17 arvostelua)

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 30 päivässä
(4 arvostelua)

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 Lisää

300 $ USD 25 päivässä
(13 arvostelua)

We can do this

1300 $ USD 30 päivässä
(4 arvostelua)

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

1500 $ USD 30 päivässä
(2 arvostelua)

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 Lisää

1000 $ USD 30 päivässä
(2 arvostelua)

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

1500 $ USD 30 päivässä
(3 arvostelua)

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

1000 $ USD 25 päivässä
(3 arvostelua)

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

1100 $ USD 18 päivässä
(3 arvostelua)

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 Lisää

780 $ USD 20 päivässä
(1 arvostelu)

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 Lisää

1000 $ USD 25 päivässä
(0 arvostelua)

Top quality work. See PM please.

1450 $ USD 35 päivässä
(0 arvostelua)

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

1100 $ USD 20 päivässä
(0 arvostelua)

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

500 $ USD 30 päivässä
(0 arvostelua)

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 28 päivässä
(0 arvostelua)

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

700 $ USD 20 päivässä
(0 arvostelua)

Pls refer to PM.

990 $ USD 30 päivässä
(0 arvostelua)

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 Lisää

1500 $ USD 28 päivässä
(0 arvostelua)