The face of the Call Center business is changing!Written by Richard Logan
Conservative consumers, shifting economic conditions and increasingly competitive business conditions are making it easier than ever to get new customers. These factors are also making it harder than ever to keep your customers. Customer loyalty isn't something easily given, it is something that is earned.The fight for customer loyalty is nothing new to contact center professionals, but changing face of contact center industry is. Database integration with predictive dialer systems has been designed for next generation of contact centers and new breed of contact center professional. Database technologies and evolving team management strategies will lead industry into next phase of contact center growth. The driving force behind these changes is FTC Legislation also an expansion/revision in basic call center objectives. Measures of success in call center operations have changed dramatically in last decade. While once only call completions or number of orders were primary measure, depending on call center function, customer centric measures are now focus Predictive dialing is changing almost as fast as traditional dialers bring screen pops to an agent's desktop. The US market, which is leader in terms of installed systems, is in a period of transition. Predictive Dialing started off as a way to attract new customers and to sell new ideas, but that model does not fit well in today's marketplace. Instead, companies are implementing database enabled predictive dialers in innovative ways, calling airline consumers if their flights are late, alerting utility customers to power shortages, reminding drivers to get their annual checkup, and even notifying retail customers when a package will be shipped late. Does that mean that consumers can say goodbye to someone asking for "the man or woman of house," or having someone stumble with a long last name? Probably not, but there will be a drastic change over next five years in which predictive dialers will migrate from being used for primarily outbound sales activity to being used for proactive outbound/inbound blending, IVR and more in customer service arena.
| | How to Save an Image in a SQL Server Database?Written by Balaji B
Most of web applications have a lot of images used in it. These images are usually stored in a web server folder and they are accessed by giving relative path to file with respect to root folder of website. .Net being platform for distributed application now, ASP.Net can be used to store images that are small to be stored in a database like SQL Server 2000 and later versions. For this purpose SQL Server database provides a data type called “image” which is used to store images in database.To access these images stored in database we will be using ADO.Net classes. To find out how to insert and retrieve an image in to SQL Server database, you can create a .aspx page which can have a HTMLInputFile control which is used to select image file that is to be saved in database. You can also create a textbox control in which you can add image name or some comment or an image id for image saved. Use a button control to upload image to database. Namespaces like System.Data.SqlClient, System.Drawing, System.Data, System.IO, and System.Drawing.Imaging are used in this task. In OnClick property of button you can write following code to upload an image to database. // create a byte[] for image file that is uploaded int imagelen = Upload.PostedFile.ContentLength; byte[] picbyte = new byte[imagelen]; Upload.PostedFile.InputStream.Read (picbyte, 0, imagelen); // Insert image and image id into database SqlConnection conn = new SqlConnection (@"give connection string here..."); try { conn.Open (); SqlCommand cmd = new SqlCommand ("insert into ImageTable " + "(ImageField, ImageID) values (@pic, @imageid)", conn); cmd.Parameters.Add ("@pic", picbyte); cmd.Parameters.Add ("@imageid", lblImageID.Text); cmd.ExecuteNonQuery (); } finally { conn.Close (); } You can also write above code in a function and call that function in OnClick event of upload button. The code given above performs following steps in process of inserting an image into database.
|