Exchange Archive

Software Overview:

EZ Exchange Archive is a tool (application) used to archive all email from

an exchange server using a Journal Mailbox and storing it in an SQL Database

so it can be retrieved via a web based frontend (client). All emails will be

kept for 3 years and at anytime an (school) Administrator will be able to

use the Web Client to retrieve any specific person's emails for a period

dating back 3 years.

*Development needs:*

Part 1: Main App

The application will need to extract information from a Journal Mailbox on

exchange, setting up the data in the proper format (Sender / Recipient /

Date / Time / Body of Email Message) after it extracts the data every 10

minutes (estimated) it should delete it from the Journal Mailbox so it does

not get too large, then sends it to the SQL Database in the format mentioned

above.

Part 2: Web Front End

Once the data has been sent to the SQL Database, a web based frontend will

be needed to access this data. The user should be able to log into this site

(frontend client) then enter search criteria (the email address of the

person in question and a date range if necessary). The application should be

able to retrieve the data in a format that can be viewed, printed and/or

exported to a file format. Also it will need a tools area to setup features

such as UserID and Passwords, export file locations, etc.

Part 3: Installation of the Application

Installation will need to be easy and have the following questions (for the

person installing) +

Server Name

Domain Name or Work Group

Mail Server Name or IP

Mail Server Journal Email Address

Mail Server Journal User and Password

SQL Data Base Name and Location or IP

SQL User and Pass

Admin User and Password for the program itself

When this App installs it can it setup IIS so that the web based

front end just works with out much configuration (is this possible?)

Part 4: Sales/Marketing Product (application) Website

I will create most of the website in which we sell the Application on myself

so as to cut costs. I plan to dev in standard HTML/PHP/CSS with a PayPalPro

merchant solution integrated to handle the transactions. Assistance with the

site may be need (include in quote) for the renewal process - how can we do

this? (see example site below for ideas perhaps)

Example (function only) site:

I have purchased software from this site in the past and it seems

like it may be a good way for us to do it as well -

http://www.spamfighter.com/. If you would like to download and purchase

their application please let me know and I will pay for it so you can test

how their "system" works (downloading trial from site, purchasing license

from site, renewals, etc)

Technical: SQL

As far as SQL it should be an option weather then have their own SQL Server

or I'm hoping we can include a free SQL with our application to make setup

much easier - do you know of a good free one? Would this work:

http://www.microsoft.com/sql/editions/express/default.mspx ?

1) Search should be, User email Address located on the exchange box, Date

and or range of dates.

2) Only an administrator can delete anything from the database

3) yes sounds good but not important for the beta

4) It needs to archive everything that comes in and out of the journal email

box on the exchange server.