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


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

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 [login to view URL]

$800 USD 7 päivässä
(0 Arvostelua)

23 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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 [login to view URL], Russia. I graduated from the [login to view URL] 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)