Reporting Application
$500-650 USD
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
Project ID: #3399088