data reporting web site

[login to view URL] I want a web site that will allow my hosted Microsoft exchange companies to track email access for any user I want to be able to import and process the raw log files (above hyperlink samples) to the site The log files are space delimited (I attached a sample converted to excel just to make it easier to see the columns) The only columns I’m interested in are: Date Time cs-username c-ip cs(User-Agent) I do not want to display the raw cs-username in the report. When the log file is imported we need to grab three items based on the data in the cs-username column: email address, first name, last name. To extract the data: Strip any leading “Shadik\” If the remaining data is an email address (for example info @[login to view URL]) then run this dos command to extract the first name, last name, and email address: dsquery user -upn info @[login to view URL] | dsget user -fn -ln -upn If the remaining text is NOT an email address (for example alex2) then run this dos command to extract the first name, last name, and email address: dsquery user -samid alex2 | dsget user -fn -ln -upn Based upon the domain name in the email address extracted, create a single username for that domain name, assuming one does not already exist from previous log file imports (domain name will be the username). Data for all similar email addresses will be associated with this single username For example: email address contains @[login to view URL], username [login to view URL] is created Subsequent log files imported detect other email addresses with the same domain;user1 @[login to view URL],user2 @[login to view URL],user3 @[login to view URL] The data for the above new entries will be reported under the same [login to view URL] username upn,fn,ln user1 @[login to view URL],User,One user2 @[login to view URL],User,Two user3 @[login to view URL],User,Three After a cs-username is associated with a user it will permanently be associated to that username for future log file imports (to speed up log file data import and processing) Based on the ‘Time’ column: only one entry per 0:01:00 (one minute), per cs-username, will be imported. Concerning the import and report display for the cs(User-Agent) column: Import all text up till the first “/” labeled as “device” Import all text after the first “/” only until (but not including) the next “+” labeled as “version” All the above data processing will happen automatically with the import and processing of the log file. --------- Once logged in, you will see a list of all email addresses, first and last names with check boxes next to each one There will be a date range selector and a “get email access report” button Only one entry can be checked at a time to get a report The report will display on the screen The onscreen report will be able to be sorted based on any column (ascending or descending) --------- There will be a site admin user which has the functionality to: import and process the raw log files change user passwords enable/disable users (disabled users cannot log into the site) Delete users (deleting a user will also delete all data for that user) Purge data based upon: user/all users and date range User functionality: Change their own password Generate on screen reports A sample skeleton site template is required for approval before and bid is accepted.