GetACoder.com

 
 

Home | My Account | Post Job | Browse Jobs | RSS Feeds | Careers New!

 

Call Report Winform .Net Sqlce

 
 
Download the Free Step-by-Step Guide
     
Job Summary:
 
Job Type: Project
Budget: $ 1000-3000
Required Skills: C#, Database Development, Programming, SQL Server, Visual Basic .Net
Attached Files: (None)
 
Status: Work Performed (selected user vnb400)
 
Buyer Summary:
 
Username:
michaelkunz  
Feedback Score: 7.50/107.50/107.50/107.50/107.50/107.50/107.50/107.50/107.50/107.50/10 2 reviews
Award Reliability: 10 posted 2 paid
 
Location: Sydney, NSW, Australia
Member Since: March 10, 2007
 
Invited Users: There are no invited users


Description
------ IMPORTANT------
*** Please provide detailed feedback on specification *** to be considered. Do NOT SPAM with general introductions and company CVs - it will not be considered. Your interest is expressed in detailed questions and feedback on the specification below. Any similar work please quote references ***


------ SPECIFICATION AND DESIRED REPORTS------------------------------
This winform tool is to 223generate224 detailed call detail reports for a telephony system from a CSV file. It should produce reports as given here:

http://www.atcomm.com/reports-index.asp.

1.) report similar to the 223COMPANY-WIDE TELEPHONE EXPENSE224, this is given on link: type, chart E1):
2.) report similar to the 223TEN MOST-EXPENSIVE CALLS224, this is given here (on type, chart E4)

User (high level) specification (typical flow):
-----------------------------------------------
1. Import of data: User 223imports224 CDR file with the call detail records from the telephony server. This is parsed into a 221new224 SQL Compact database file for further processing. This shall be implemented on a winform tab named 223import224. A progress bar shall display the progress and how many records are imported. As well, data validation shall be done with 223sensible224 error correction. So, for example if one line can not be parsed, a error shall be logged (For example in a list box) 226 but then continue. We will provide several CDR reports. The software needs to be written so that it can handle large files ie as StreamReader file.

2. Setting up of parameters in a 2nd tab 223Configuration224. The generation of the report will require parameters, for example:
a. Report Name
b. Report file name
c. A matrix what is regarded as external calls (for example all calls starting with 0), all overseas calls (starting with 00011..), all Local calls (starting with 98 or 99). This shouls be a list of patterns which then classfies a call as internal,external, external-overseas, external local etc205.
d. Report option

3. Generating the report: This shall display a progress bar and and a listbox, similar to below screenshot. We can deliver this code part and icons to accelate development. It now generates the report according to settings as HTML with the charts and ouput as per http://www.atcomm.com/reports-index.asp. In the end it asks the user to open the report to display in web browser. The challenge is to process the data as the CDR data needs to be analysed (see document in 6. below)

Technical specification:
-------------------------
1. Programming Environment: Visual Basic.NET 2008 Express, Windows Form based project
2. Software reads Call Detail Records (CDR) which is a flat, Comma Separated lines in a text file and generates Call reports for a phone system based on user settings
3. The CDR records are first imported into a local SQL Compact Express database (a sdf file); code parts how to import the CDR are avail on the web: a starting point is given here:
http://teneo.wordpress.com/2007/10/09/parsing-cisco-cdr-into-postgresql-db/

4. Then the user can select report options (like period of report, what type of call detail, customization of long distance international prefixes for filtering)
Based on that the report is generated as HTML file with the Charts; The excellent TELERIK package for reporting shall be used: http://www.telerik.com/products/reporting.aspx.

5. The CDR file has a certain structure which is based on a detailed specification by the telephony vendor which needs to be understood to implement above. There are some different cases to consider and it needs a smart person to understand. Please see here for the CDR specification:
6. http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/cdr_def/3_x/CDR.html (There is a more recent one which I will supply --- very similar though)

The detailed requirements and design would need to be defined on the go, as long as the output of the 2 reports is similar as in the links above. Most of the details needed to be clarified 223on the go224.

Code Quality:
---------------
Our expectation is standard structured code quality with comments. Code must be structured according to functions for example (at least):
1.) Class Database which includes the import from CSV to SQL compact
2.) Class HTML which generates the HTML file
3.) Class Analyze CDR which processes the CDR records in the DB (uses Class Database205)
4.) Winform

Testing and accuracy:
------------------------
Our expectation is well tested, stable code which gives accurate results. Please plan time for this as we are not alpha code testers.

Handover and delivery.
---------------------------
After coding and quality has been done; the executable (code protected with obfuscation etc) will be given to us for testing. On our feedback, changes might be required. After successful fixing we will finish the project. The source code as VS project will be delivered and we will pay for it.

Our effort estimates
----------------------
Our estimate is about 12 to 20 days for a good coder. Please state your delivery date and your estimated effort with some explanations.




Reminder
You may not start working in this and any request before your bid is accepted. Users who violate this policy may have their accounts permanently suspended.



 Bids Received (11)   Shortlist (0)   Declined Bids (11)   
Average bid amount:   $2,381.82   Average delivery time:   26 Day(s)
Place Bid | Post Similar Job | Send Request | Contact michaelkunz

Order by:

 

Remember that contacting the other party outside the site (by email, phone, etc.) on all business jobs (before the request is awarded) is a violation of our terms of use. We supervise all site activity for such infringements and can immediately expel transgressors on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thank you for your help.
 

 
send private message
Shortlist
Decline Bid
Premium User  
imprahul  
Sydney, AU
location
US$2,500
bid amount

9.67/109.67/109.67/109.67/109.67/109.67/109.67/109.67/109.67/109.67/10
(21 reviews)

feedback
30 day(s)
delivery time

 
 
Hi, I have 3+ years of experience in C#, VB .NET and SQL Server. I am experienced in Visual Studio 2008 technologies too and have just recently created a large system for creation, parsing and reports generation of EDI files received from courier companies, which are substantially more complex than CDR files. Not only can I create this system, I can also test it professionally as I have about 1 year testing experience too. I have been an integral part of many application and database design teams and can optimize your application as per your requirements (i.e. space or time optimizations). I have also created win forms and windows smart client applications, windows services, WCF services etc, and can make good use of some of these technologies for your meeting your requirements.
Bid Time: 08-04-2009 05:21
 
send private message
Shortlist
Decline Bid
TCT  
madurai, IN
location
US$1,900
bid amount

9.00/109.00/109.00/109.00/109.00/109.00/109.00/109.00/109.00/109.00/10
(15 reviews)

feedback
35 day(s)
delivery time

 
 
Hello, we gonethro your requirement fully. We are very fair for this application.Please open PMB for to show our ability. We have 9+yrs Experienced team in .NET technologies. we did 100+ web applications. so we are very sure & confident on your requirement.During discussion, we can show some demos and coding standards and all. we have clients across the world. We are doing ERP's for Australian & UK based customers.so please allow us to prove our capabilities. Sure we will provide a powerful solution to you. Thanks
Bid Time: 08-05-2009 08:46
 
send private message
 
vnb400  
Mumbai, IN
location
US$2,500
bid amount

9.91/109.91/109.91/109.91/109.91/109.91/109.91/109.91/109.91/109.91/10
(11 reviews)

feedback
20 day(s)
delivery time

 
 
Can be developed in C# or VB.NET and using SQLCE as required.
Bid Time: 08-04-2009 03:19
 
send private message
Shortlist
Decline Bid
sabasak  
Manama, BH
location
US$3,000
bid amount

9.80/109.80/109.80/109.80/109.80/109.80/109.80/109.80/109.80/109.80/10
(5 reviews)

feedback
20 day(s)
delivery time

 
 
Clear with your requirements, ready to start.
Bid Time: 08-04-2009 14:08
 
send private message
Shortlist
Decline Bid
vts2008  
Pune, IN
location
US$2,000
bid amount

8.20/108.20/108.20/108.20/108.20/108.20/108.20/108.20/108.20/108.20/10
(5 reviews)

feedback
45 day(s)
delivery time

 
 
If we understand you correct you are using a dialer to make multiple call. This Dialer gives reports in CSV format and can be at larger scale, if a particular record cannot be imported to the database you want a log created so that you can exactly review the data set which was not imported and the reason for the same. Through this data you want to pull up reports such as CALL TREND, CALL VOLUME, CALL RELEASED, AVG. HOLD TIME, AHT, CALL AREA(LOCAL, INTERNATIONAL, LOMG DISTANCE ETC.. ). Also you want to have the list of file from which a particular report was created. Step 1) Getting the data from the csv file to sql. Step 2) Generation of reports off the uploaded data as per date , time etc... Step 3) Graphical Representation of data in graphical format.
Bid Time: 08-04-2009 03:46
 
send private message
Shortlist
Decline Bid
dhamcoder  
Baroda, IN
location
US$3,000
bid amount

5.00/105.00/105.00/105.00/105.00/105.00/105.00/105.00/105.00/105.00/10
(1 reviews)

feedback
10 day(s)
delivery time

 
 
Hello Sir, We have more than 6 years of experience in Software Fields to work with commercial customers around USA as well as all around Glob. Customer satisfaction is our valuable profit. We have expertise in various domains and having enough work experience in it. We have experience to work with many CMS (Content Management System), Web Technologies ,other Programming Languages, iPhone Software Developement, Database Developement and other Designing related work. We have much experience to work with Joomla, Drupal, VB.net, C#.net, ASP.net,JAVA,J2ME,JSP, VB, PHP, MySQL, MSSQL, C, C++ and Wordpress. Please open PMB for further discussion. Thanks Regards Dhamcoder
Bid Time: 08-05-2009 23:43
 
send private message
Shortlist
Decline Bid
LG23  
Sofia, BG
location
US$3,000
bid amount

(No Feedback Yet)
feedback
40 day(s)
delivery time

 
 
Dear Sir, I am able to finish your project for 0 and 40 work days. I have 10 years experience as programmer, and 5 years experience with .NET! Best regards!
Bid Time: 08-04-2009 04:17
 
send private message
Shortlist
Decline Bid
AspireSC  
Bangalore, IN
location
US$2,000
bid amount

(No Feedback Yet)
feedback
40 day(s)
delivery time

 
 
Please open PM so that we can send you our bid.
Bid Time: 08-04-2009 13:28
 
send private message
Shortlist
Decline Bid
cubaconn  
Miami, US
location
US$3,500
bid amount

(No Feedback Yet)
feedback
7 day(s)
delivery time

 
 
This is a realistic project bid, although you might get lower bids and unrealistic delivery times. I have 12 years of experience as a developer, and among the clients I have work for are, First Premier Partners, Simplikate Systems, Abigail's Michel222s, and Simulart Entertainment and more recently concept applications for Verizon wireless setup boxes, in a company (can222t name it) that is targeted as Verizon Wireless mobile application provider. Please note that due to the fact that I work full time for a software company, I will be unavailable by phone from only be available by mail until 6:30 pm, after that time, I222ll be available by phone at any time, including weekends. Please note that I haven222t updated my profile for almost a year, but I can send screen shoots of recent applications if required.
Bid Time: 08-04-2009 23:11
 
send private message
Shortlist
Decline Bid
ProjectDev4All  
Delhi, IN
location
US$1,800
bid amount

(No Feedback Yet)
feedback
20 day(s)
delivery time

 
 
Hi, I am Interested in this Project & ready to Start it ASAP. We have done this type of before in the Past & have Expertise Team who can make this Project a great success. Please Message us in the chat so that we can Start our conversation regarding this Project. Warm Regards
Bid Time: 08-05-2009 08:38
 
send private message
Shortlist
Decline Bid
intellegent  
karachi, PK
location
US$1,000
bid amount

(No Feedback Yet)
feedback
10 day(s)
delivery time

 
 
I have read the detail of the project & ready to work on it. We will serve you with our best quality. I hope i will hear from you soon. THANKS.....
Bid Time: 08-05-2009 11:44
 
 


 
Get the Free Step-by-Step Guide on How to Use GetACoder
The act of outsourcing jobs has become easy in the past few years thanks to GetACoder. However, our team aims at making the whole process even easier. So, it has now come the time to provide you with a step-by-step guidance on how to use this service and succeed in the outsourcing world totally for FREE.

It doesn't matter if you are a more experienced user or a novice; using GetACoder will become even simpler with the help of this E-book. There are two major sections: a Buyers section and a Coders section.

Buyers will learn:
  • How to outsource safely
  • How to pick the best freelancers
  • How to manage time and money

Coders will learn:

  • How to get the best jobs
  • How to secure their payments
  • How to build a long-lasting relationship with buyers

    ...and MUCH MORE
Clear examples and pictures illustrating key situations, great tips and real testimonies of some of our best users... all in this Outsourcing Guide.  So don't loose the outstanding opportunity to download GetACoder FREE E-book.
The Outsourcing Revolution: Why It Makes Sense and How to Do It Right
The Outsourcing Revolution: Why It Makes Sense and How to Do It Right
What is GetACoder?

GetACoder.comGetACoder is a leading Global Services Marketplace doing business in more than 200 countries. Our unique system accelerates your time to market and provides your business with key competitive advantages. When you use GetACoder you are stretching your budget and saving as much as 60% over traditional outsourcing. GetACoder is changing business, now it's no longer about what you own or build but which resources and talent you can access. With GetACoder you reduce expenses, increase efficiencies, aggressively grow your business, and create a sustainable competitive advantage. GetACoder makes outsourcing to any part of the world an easy task! With GetACoder it's simple to outsource any business request, gain access to global talent and manage jobs online.

One of the main advantages of GetACoder is the low labor cost. The typically rates are about seven times lower than the ones in the US or Europe. Posting a request at GetACoder allows the right professional or company to find you and to bid for your work. We are building a reputation for exceeding our customers' expectations and for becoming an extremely cost effective way to outsource work. Use GetACoder when you want to save money, increase efficiency or accelerate the development of your request. With GetACoder you focus on growing your business and let others do the tedious work. Post your request on GetACoder for free. Find out why people outsource jobs with us day after day.

Thousands of Satisfied Customers - Submit/View Quotes


-GetACoder is certainly a needful website. - sipakseal
-This is a nice and useful site. - johnfrancismoret
-This is a great place to post projects. I have been working on GetACoder for more than 2 years and I know how important this site is. I have created many projects but after joining GetACoder it helped me get world wide exposure. Thanks GetACoder, all credit goes to you. - santosheko
Report Violation    Privacy Policy     Affiliate Program    Terms of Use    Contact Us    Help      GetACoder.com on Facebook      Follow GetACoder on Twitter      GetACoder.com Latest Requests RSS Feed
© 2004-2012 GetACoder. All rights reserved.