Reporting Application

Completed Posted Nov 17, 2008 Paid on delivery
Completed Paid on delivery

We receive Syslog messages from multiple routers. We want a web application that will allow us to view the information after manipulation. We want to have thresholds that we can set for notification and color coding.

A sample message is as follows:

Nov 18 01:00:14 [login to view URL] 2008 4500 mand: Advanced MOS (v1.5);STR=1226969781;STP=1226970014;Call ID=1307;SRC=[login to view URL];SDD=95256340;DST=[login to view URL];DDD=150-Prod_Hawaii;MOS=3.86;BTC=0;PJ=0.00;PPL=0.00;LP=0;RR=11628;SRE=11628;OOP=1;PD=0.77;MPJ=37.97;MNJ=-21.03;CLP=0;PLB=0.00;

We would want to be able to associate the IP [login to view URL] with a particular customer to group their messages if their IP address ever changes.

Can use Windows but would prefer Linux. Can be Perl but would prefer Ruby or PHP. Must use MySQL for the backend.

## Deliverables

Web Pages:

Page 1 - Add/Edit/Delete Customers

Page 2 - Associate Customers with 1 or more IP addresses that we have received messages from

Page 3 - View grid of all records for a particular customer. Able to sort and filter by all fields in the grid

Page 4 - Setup thresholds for coloring the grid squares and email notification per customer

I can provide mochups of what I want the web pages to look like.

I have live data that you can use to test with.

4-5 Syslog messages come in per database record. The first and last message can come hours apart. They have a unique record and definitive beginning and end message. The application will process each record as it comes in, updating the DB with the new information.

* * *This broadcast message was sent to all bidders on Tuesday Nov 25, 2008 9:29:02 PM:

Aloha, I have uploaded an Excel spreadsheet with four worksheets, one for each web page. Let me know if you have any questions. I will be selecting the bidder on 11/30/2008. Aloha, Matt

* * *This broadcast message was sent to all bidders on Tuesday Nov 25, 2008 9:31:30 PM:

The file attachment is a ZIP file. The .zip extension is not attached when you download it. -Matt

* * *This broadcast message was sent to all bidders on Wednesday Nov 26, 2008 2:39:54 PM:

Aloha Bidders, There was a question as to what I meant by a 'calendar app'. I am looking for something similar to what [login to view URL] has on their site when you go to enter a day for a reservation. When you click the box, you get an applet pop up that lets you scroll though the months & days and select a day. Please let me know if you have any other questions. I will be selecting the coder on 11/30/2008. Thank you for your interest. Aloha, Matt

Engineering MySQL Perl PHP Project Management Ruby on Rails Software Architecture Software Testing Web Hosting Website Management Website Testing

Project ID: #3399088

About the project

28 proposals Remote project Active Dec 1, 2008

Awarded to:

kieranj

See private message.

$467.5 USD in 14 days
(46 Reviews)
6.6

28 freelancers are bidding on average $484 for this job

smartprovw

See private message.

$552.5 USD in 14 days
(261 Reviews)
7.4
rgdavis

See private message.

$552.5 USD in 14 days
(35 Reviews)
7.4
mojocodersvw

See private message.

$552.5 USD in 14 days
(78 Reviews)
6.6
Coding4C

See private message.

$425 USD in 14 days
(121 Reviews)
6.2
asawyer13

See private message.

$510 USD in 14 days
(58 Reviews)
5.8
moranzz

See private message.

$467.5 USD in 14 days
(8 Reviews)
5.3
c0nvurs3

See private message.

$446.25 USD in 14 days
(14 Reviews)
4.9
INNOSolution

See private message.

$425 USD in 14 days
(40 Reviews)
5.0
lsampsl

See private message.

$425 USD in 14 days
(71 Reviews)
4.8
shirishgoyal

See private message.

$510 USD in 14 days
(8 Reviews)
4.5
mtyaka

See private message.

$425 USD in 14 days
(12 Reviews)
4.2
wynstvw

See private message.

$425 USD in 14 days
(18 Reviews)
4.5
YourProgrammer

See private message.

$425 USD in 14 days
(2 Reviews)
3.3
murp3433vw

See private message.

$425 USD in 14 days
(3 Reviews)
2.8
xflyer

See private message.

$467.5 USD in 14 days
(1 Review)
2.2
vw6655367vw

See private message.

$510 USD in 14 days
(3 Reviews)
2.0
nanocomputer

See private message.

$552.5 USD in 14 days
(9 Reviews)
3.5
kaha6uc

See private message.

$467.5 USD in 14 days
(1 Review)
0.8
vw7046128vw

See private message.

$552.5 USD in 14 days
(2 Reviews)
2.2
vw7087026vw

See private message.

$552.5 USD in 14 days
(0 Reviews)
0.0