pressingmssql2005

mssql2005  时间:2021-05-05  阅读:()
MizuCallcenterPlatformTutorialAboutThisisaquickintroductionforunderstandingtheMizuCallcenterplatform.
TheMizuCallcenterisbasedontheMizuManagewiththeadditionofthefollowingfunctionalitiesandmodules:Anewtypeofuserscalled"operators"(thesearemostlythesameasVoIPenduserswithafewadditionalpropertieslikeassignedcampaignandtheyaretreatedspeciallybythemizuserver)Campaign:youcanrundifferentcampaignssimultaneously(withdifferentbusinesslogic,differentsettings,scripts,GUI,clientsandoperators)MAgent:clientapplicationfortheoperators.
Traditionalcallcentersuseastandardvoipclient(softphoneorhardwarephone)andusuallyaseparatewebbasedCRMfrontend.
TheMAgentclientapplicationhasalltheseintegratedinasingleapplicationallowingeasierusageandcontrol.
MAgentLite:ifyouwishtokeepyouroldCRM(moredetailsbelow)GUI:supervisorscancreateadifferentuserinterfaceforeachcampaignbyusingthe"GUIdesigner"formfromtheMManageapplication.
ThiswillbevisiblefortheagentontheQuestionnaireform(fromtheMAgentapplication)Script:eachcampaigncanhavedifferentbusinesslogic.
Thiscanbedefinedusingthe"Script"formfromtheMManageCallcenterstatistics:statisticsbycampaignoragent(availablephonenumbers,totalcalls,"successful"calls,agentworktime,etc)Predictivedialer:aserversidedialertoautomaticallydialthephonenumbersbasedontheavailableagentsandpreviousstatisticshistory.
Thepurposeistoreducetheoperatorwaittimetotheminimumbyeliminatingconnectandringtimes.
TermsCallcenters:http://en.
wikipedia.
org/wiki/Call_centreOutboundcallcenter:Operatorswillcallclients(phonenumbers)forexampletosellsomethingInboundcallcenter:Clientscallstooperators.
CallsarehandledbyIVR.
Forexample:receptionistsOperators:PeopleworkingasagentsClients:CalledpeopleincaseofoutboundcallcenterorcallerpeopleincaseofinboundcallcenterCRM:databasebacked(callcenterspecifictablesandstoredprocedures)andfrontend(MizuManageandMAgent)FeaturesEasyInstallationoftheclientapplications:afterdownloading,installationtakesonlyafewminute.
Installationisjustassimpleasanyotherwindowsprogram:nextnextnextfinish.
Nootherconfigurationisrequiredbydefault.
AutomaticCallDistribution:simpleautomaticdialing,powerdialing,predictivedialing,predictiveintelligentdialingCallRecording:allcallscanberecordedandstoredRealtimecallcheckout:supervisorscanlistentotheongoingcallsrealtimeCustomizableScripts:scripttree,withanynumberofbranches,answers,andreasoncodes.
CustomizableGUI:MAgentGUIcanbecompletelydesignedfromMizuManageCustomizableIVR:anynumberoflanguages,anynumberofbranches,calltransferstotheoperatorsStatisticgeneration:customerstatistics,operatorstatistics,callrelatedstatistics,worktimestatistics,campaignstatisticsInvitationletter:customizationandautomaticprintingVirtualCallCenter:moreserveronthesamehardware(completelyseparatedsoftwareanddatabase)WorksfrombehindfirewallswithdynamicIPaddresses:theclientdoesn'trequirepublicIPaddressesAutomaticdialing:Theoperatordoesn'thavetopressabuttonfordialing,itisallautomaticDatabasedialing:Theoperatorcansearchinthedatabase(byaddress,name,ageetc.
)andwithpressingjustonebutton,theoperatorcancallbackhisclient.
Manualdialing:withthisfeaturetheoperatorcandialanybodybyhisnumber,ifshe/heisallowedtodoso.
Callbackscanbescheduled:theoperatorcancreateacallbackiftheclientrequiresso.
AutomaticCallDistributoronthecallcenterserverwillplacethecalls,asmanytimesandintervals,asitisconfigured.
InstallFollowtheMizuVoIPServertutorialtoinstalltheservice.
TheonlydifferenceisthatyoumustenabletheCallcenterINandOUTmodulesintheConfigurationWizard(thiscanbeenabledalsoanytimelateraftertheinstallfromtheMizuManageapplication->Configmenu).
InadditionyouwillhavetoinstalltheMAgentorMAgentLightapplicationforeachdesktopusedbytheoperators(thesearenativeWindowsapplicationsbuthavebeentestedandworksalsounderLinuxbyWine).
WorkflowSystemadministratorswillcreatetheproperVoIPsetup(peers,routingandothersettings)andwillmonitorthesoftswitch(failedroutes,etc)Callcentersupervisorswilladdtheagentusers,createcampaigns,scripts,GUIandwatchcallcenterstatisticsAgentswillusetheMAgentapplicationtoperformtheirwork(ortheMAgentLightifathirdpartyCRMisused)Callscanbeinitiatedbythreeways(configurablegloballyorbycampaign):1.
predictivedialerbytheserver2.
automaticcallsfromtheMAgentQuestionnaireform3.
manualcalls(fromthe"Callsfromdatabase"or"Manualcall"form)SoftwarecomponentsApplicationServerThecallcenterserveriscompletelyintegratedwithoursoftswitchserverplatform.
Minimumrequirementswith50agents:Windows2003/2008/2012/2016/2019,1GBRAM,DualCoreCPU,20GBHDDTheserverishandlingthecallscomingfromtheMAgents,MAgentwillquerytheserverforphonenumberstocallorthecallsareinitiatedfromthepredictivedialeranddroppedtotheMAgentswhentheyarealreadyconnected.
TheCallcenterOutmodulemustbeenabled(canbeenabledfromtheconfigurationwizard)DatabaseThedatabasebackendisusedtostoreCDRrecords,usertablesandotherdata.
Minimumrequirementswith50agents:MSSQL2005/2008/2012/2014/2016/2017/2019,2GBRAM,DualCoreCPU,128GBHDD.
ForsimpleusagethereisnoanyskillsrequiredbutforadvancedusageyoumightneedsomebasicSQLknowledge.
Themostimportantcallcenterspecifictablesare:tb_cclient:usuallyalargetablecontainingalltheavailableclients(phonenumber,name,addressandotherdetails)tb_cccampaigns:containourcampaignsettings(campaignname,settings)tb_ccampain_clients:eachcampaignhasitsownassignedclients.
Theapplicationsareworkingmainlywiththistable.
Herewestorethedataforclientsrelatedtoacampaign.
Forexamplethenumberofcallattempts,whetherwehavesuccessfullysoldsomethingfortheclient,datathattheoperatorswillenterfromMizuManage,andotherdetails.
tb_ccscripts:scriptworkflowtb_ccscript_answers:dataselectedorenteredbytheoperatorswhilenavigationtroughthescripttb_gui:eachcampaigncanpresentaseparateinterfaceintheMAgentapplicationMizuManageApplicationusedbytheadministratorsandsupervisorstosetupandmonitorthecampaigns(scripts,GUIbuilder,MAgentsettings,clientdatabase,assignclientstocampaigns,statistics,etc)MAgentApplicationusedbytheagents(operators)tomakeorreceivecallsandloadandenterdatafrom/tothedatabase.
ThisisbasicallyaVOIPclientandaCRMfrontendcoupledinoneapplication.
OnthefirstloginthedatabaseIP,port,usernameandpasswordisrequired.
Thiscanbesavedandonsubsequentloginsonlytheagentusernameandpasswordisrequired.
FromMAgenttheagentsareabletodothefollowingtasks:-Login/Logoff(Filemenu)-Changetheirowncampaign(ifallowed)Makecalls:-ByrunningtheQuestionnaireform(thisisthemostimportantform.
MostoftheactivityshouldbedonefromhereanditsGUIandscriptcanbebuiltbythesupervisorsfromtheMizuManageapplication)-Callfromdatabase(ifallowed).
Userscansearchandselectaclientandcalldirectlyfromhere.
-Manualcall:islikeasoftphonewithbasiccallcontrolfunctionsDuringcallstheycanselectvariousactions(Actionsmenu)likeHoldDTMForcalltransfer.
Agentalsocanseetheirownstatistics(fromtheDatamenu)orsetupMAgentpreferences(fromtheConfigmenu)MAgentLightYoumightchoosetouseouradvancedsoftswitchplatformwithyouroldCRM.
InthiscaseyoucanusetheMAgentLightapplicationtoautomatesometasks.
CanbeusedtomonitorcallcentercallstatusandperformautomaticCRMrequests.
ForthisaseparateVoIPphoneandaseparateCRMfrontendmustbeused(preferablyawebbasedfrontendsoitcanbecontrolledbytheapplication)Theonlydisadvantageisthatyourclientsdatabasewillbeduplicated(storedinyourCRM,butyouneedtoalsoimportthemtotheMizuplatform–tb_cclientdatabasetable)BasicsettingsTobeabletousethecallcenterfunctionality,thesemodulesmustbeenabledfirstontheserverside.
ForthisyoucanusetheConfigurationWizardfromMManageConfigmenuandmakesurethattheCallcenterInandOutmodulesareenabled(checkifyourlicenseallowsthis,otherwiseenablingthemoduleswillnothaveanyeffect).
Ifthecallcentermodulesareenabledthenyouareallowedtosetupsomebasicsettingsdirectlyfromthewizard("Callcenter"and"Predictivedialer"pages).
Therearemanyotheroptionsthatcanbesetonsystemlevelusingthe"Configuration"form(select"callcenter"intheCategoryFilter)Incomingcallscanbehandledinmanydifferentways:routethecallnormallytothecallednumberrouteincomingcallstoagents(ortoagroupofagents)aspecial"Callback"numbercanbespecifiedandincomingcallscanbetreatedaftertheconfiguration(routetofreeoperator,orroutetoapredefinednumber)handletheincomingcallsbyanIVRIncomingunknownnumberscanbeautomaticallystoredintothedatabaseandascheduledcallbackcanbeinitiatedautomaticallyandassignedtoafreeoperator.
Formaximumperformance,youcanalsorestrictthemaxring-timeandthework-timeallowedfortheoperatorsbetweentwocalls(administrativetasksintheCRM).
Whenthetimeoutwillelapse,thenextcallwillbeinitiatedautomaticallywithoutanyinteractionneededfromtheagent.
Youcanalsodefinehowmuchtimethesystemwillrecallaclientandwhatistheminimumintervalbetweentworecalls.
Theserecallsareforthenotconnectedorfailedcalls,butagentareallowedtocreatemanualrecallsiffurtherdiscussionwithaclientisrequired.
OutgoingcampaignsYouwillhavetowalkthroughthefollowingconfigoptiontosetupyourcallcenter:1.
CallRoutingHereyouhavetodoexactlythesamestepslikefortheVoIPsoftswitch.
FollowtheRoutingandtheAdminGuide.
2.
ScriptThescriptisaconvenientwayto"drive"youroperatorstroughyourbusinesslogic.
Forsimplecampaignthereisnoneedforascript,butifagentshavetoaskmanyquestionsthanthescriptcaneasetheirwork.
Forthisyouwillhavetousethe"Scripts"formfromtheMizuManageapplication.
Addanewscriptormodifyanexistingone.
Pleasenote,thatthereare2typesofscripts:IVRscripts(usedbytheserverforincomingIVRcalls)andclientsidescripts.
Don'tuseserversideactionsinclientsidescripts!
3.
GUIUsethe"GUIdesigner"formforthistask.
Evenifyoudon'tcreateanycustomizedGUI,thedefaultGUIwillbeloaded.
OntheGUIyoushouldputonlythemostcommonfieldsthatshouldbevisiblefortheagentallthetime(likethenameofthecampaign,thecalledphonenumberandanyotherfieldthatisimportantforyouractivity)4.
CampaignUsethe"Campaigns"form:clickonthe+signtoaddanewrecord.
SetanynamethenassociateitwithascriptandaGUIandsetitstypeto"Callcenter(OUT)".
Therestofthefieldsareoptional.
5.
OperatorsFromthe"Usersanddevices"formyouneedtoaddyouragentswithusertypesetas"Operator".
Theseusersarelike"Endusers"withafewcallcenterspecificsettings.
Themostimportantfieldsherearethe"username"whichmustbeauniquestring,thepasswordandthecampaignwheretheoperatorisassigned.
6.
ClientsClientsareactuallythephonenumberstheagentshavetocallandtheyarestoredinthetb_cclienttable.
Usethe"Clients"formtoaddclientsandputitincampaigns.
Userscanbeinsertedinthefollowingways:manuallyfromtheClientformimportClientsbutton(Clientform->operations)usingtheExport/ImportwizardfromtheFilemenuworkingdirectlywiththedatabase(usetheSQLServerManagementStudio)Ontheclientformyoucanperformvariousfiltering,theonthe"Operations"formyoucanassignthelistedrecordtoacampaign.
Alsofromthisformyoucanviewdetailsabouteachusertogetherwithcampaignactivity(howmanytimesitwascalled,whenitwascalledlasttime,ifthe"offer"was"accepted"or"rejected"andotherdetails)7.
MAgentAftertheoperatorwilllogintotheMManageapplicationandopenthe"Questionnaire"theywillseetheGUIandScriptyouhavepreviouslyassignedforthecampaignandthecallsarestartedautomatically(bytheMAgentapplicationorbytheserversidepredictivedialer)8.
QuotasThismodulehavetobeusedonlyifyouneedtobuildrepresentativestatisticsoryouneedtotargetdifferenttypeofuserswithdifferentcampaigns.
9.
PresentationandchecklistsThesemoduleshavebeenbuiltforthespecificneedforinvitationbasedcampaigns.
(Whenclientsareinvitedtoaneventandyoucantrackthelocationsandinvitationsusingthesetwoform)10.
MonitoringUsethe"Callcenterstatistics"formtomonitorthecallcenteractivity.
Statisticsareavailableforcampaignsandagentswithdifferentgroupingortimeinterval.
AnycustomstatisticscanbeeasilywritteninSQLandstoredinthe"DirectQuery"formforquickaccess.
AgentwillbeabletoseetheirownstatisticsusingtheMAgentapplication.
Additionallyacallhistorycanbequeriedforeachclient(phonenumber)usingthe"ClientHistory"formorbyoperatorsfromtheMAgent(onlytheirownclients)TechnicaldetailsThetb_cclienttableisusuallyahugetablewhichcontainsallclientswithoneormoreassignedphonenumbersandoptionallyotherclientspecificdetailslikename,address,age,etc.
Youcancreateanynewfieldinthistablespecifictoyourneeds.
Afteryouhaveimportedyourclientstothistable,youcanmakevariousfilteringonitandassignapartofthemtoaspecificcampaign.
Forthisthetb_ccampaign_clientstableisused.
Allcampaignspecificfieldsshouldbeinthistableandclientrelatedpermanentfieldsintb_cclienttable.
Youcanputanyfieldfromthetb_cclientortb_ccampaign_clientsdirectlytotheMAgentQuestionnaireformtobeaccessiblebyoperators(read/writeorread-only)withtheGUIdesignerorthescripteditor.
Fieldscanbechangedalsofromthescriptautomatically(byusingSQLupdateactions)WhetheryouusetheautomaticdialerfunctionalityoftheMAgentorthepredictivedialer,thenextclienttobecalledisloadedfromtb_ccampaign_clientstableafterasophisticatedalgorithmwhichwilltakecareforalltheparametersyouhavedefinedongloballevel(Configurationsform)orcampaignlevel(Campaignform).
Themostimportantparametersarethefollowing:whetherthesystemmobileorlandlinenumbersarefavorized(ifbothareset;afterthefirstcalltoaclientusuallythenumberwherewehavereacheditlasttimeisfavorizedautomatically)howmuchtimeswealreadyhavecalledtheclientandwhenwasthelastcallwhetherwehavetoredialtheclient(redialsetbytheagents)whethertherecallscanbeassignedtoanyagentoronlyfortheagentwhomadethepreviouscall(orfirstwetrytheoriginalagent,thenaftersometimetheclientcanbeassignedtoanyotheragent-forexampleiftheoriginalagentisnotworkingforthecompanyanymore)anyquotayouhavedefineontheQuotasformclientcallorder(random,databaseorder,etc)anyotherconfigurationparameteryouhavespecifiedClientscanalsobemarkedas"robinson".
Thismeansthatacertainclientdoesn'ttoleratecallcenterdisturbsandthesystemwillmarkthemtobenotrecalledanymore.
Ifcallsareinitiatedbythepredictivedialer,theagentwillgetonlyconnectedcall(thedrawbackisthattheywillhearonlyashortbeepinsteadoftheringtoneandthentheyhavetoanswerimmediately)Thepredictivedialerisbasedonsophisticatedstatisticshistorytodeterminewhenandhowmuchcallitshouldinitiate.
Thisisdependingonthenumberofagent,numberofcurrentcalls,numberofpreviouscalls,ASR,ACDinthelast10minute/lasthour/lastday/lastmonthinaweightedcalculation,maxringtimeandwaittimesettingsandallotherpredictivedialersettingsyouset.
Thepurposetoreduceoperatorwaittimetominimumwithminimaloverdialing(whenthecallisconnectedbutthereisnofreeoperatoranymore).
Themoreoperatorsyouhave,thebetterthepredictivedialerwillwork.
Theresultofacallandtherelatedstatisticscanbeachievedbythefollowingways:Usingcompleted/accepted/rejected.
ThisisthemosteasiestandconvenientwaytostorethecallresultandcanbedonebyusingtheacceptandrejectscriptactionsordirectlyfromtheGUI(rejectbuttonforquickaccess).
Youcanalsomarkonescriptactiontobethe"competitionquestion"whichmeansthattheconversationhasarrivedtoapointwhenwecansaythatitwascompleted.
(forexamplethecallwasnotrejectedimmediatelybythecalledparty)Thiscanbethesameordifferentfromthe"accepted"action)Forthisyouhavebuilt-instatisticsintheMManageapplication.
OntheScriptformyoucanfindaspecialfieldnamed"endcode".
Insomeitemsyoucanfillthisvalueandthatwillmeanthedegreeinthescriptuntiltheconversationhasarrived.
Youcanmakeanyfurtherquerybasedonthisfield(tb_ccscript_processing.
endcode)Usingfieldsfromtb_ccampaign_clientstostoretheresult.
Forexampleifyousellproducts,youcanstorethepurchasedproductnameinaseparatefieldthenyoucanmakeyourreportsandstatisticsbasedonthisfield(ifemptytherewasnotproductsold…meansa"failed"call)Usingtb_ccscript_processingtable:eachscriptitemaccessedbytheagentcanbestoredinthistable("ivr_storecscriptanswers"globalconfigoption)andqueriedafteryourneeds.
Thiswillofferthemostdetailswiththecostofmorespaceandprocessingresourcesneeded.
Usingyourowntable(s)andfield(s).
Youcanaddanynewtabletothedatabaseandstoretheimportantresultsinthistableinsteadofusingthebuilt-intables.
Youcanalsouseanycombinationofthepreviousmethodstoachieveyourbusinessgoals.
Forexamplethemostimportantstatisticscanbebuiltaftertheaccepted/rejectedflagbutifmoredetailedstatisticsareneededyouwillbeabletousetheothermethodsanytime.
TestYoucanlaunchacampaignintestmode.
Forthisgotothecampaignsettings(Detailspage)andselectthe"Test"checkbox.
Thismeansthatthenumbersinthecampaignwillbecalledinanendlessloop(willberesetafterallnumbersarealreadycalled).
ForexampleyoucanaddafewtestnumberisthiscampaignandlaunchoneormoreMAgenttocallthesenumbers.
Neverenablethisoptionforlivecampaigns(becauseimportantdataislostwhentheresetismade).
AnothertestoptionistotestyourGUIandscriptwithouteventuallytomakeanoutgoingcall.
Forthisyouhavetoselectthe"Test"optionontheMAgentloginform.
IncomingcampaignsThisisdocumentedintheIVRguide.
Thebasicstepsarethefollowings:1.
Setuppropercallhandlingandrouting(Trafficsenders,SIPservers,Routing)2.
CreateaIVR(IVRform)3.
MakeacampaignandassigntheexistingIVRforit(Campaignsform)4.
CreateanIVRusersandassigntheIVRforit(UsersandDevicesform)5.
Createoperatorsandassignsomeoperatorstothiscampaign(UsersandDevicesform)6.
Operatorsnowcanlaunchtheclientapplicationandwaitforincomingcalls(MAgent)FormoredetailsusetheAdminGuideorcontactoursupport.
CopyrightMizutechSRL

spinservers($89/月),圣何塞10Gbps带宽服务器,达拉斯10Gbps服务器

spinservers是Majestic Hosting Solutions LLC旗下站点,主要提供国外服务器租用和Hybrid Dedicated等产品的商家,数据中心包括美国达拉斯和圣何塞机房,机器一般10Gbps端口带宽,高配置硬件,支持使用PayPal、信用卡、支付宝或者微信等付款方式。目前,商家针对部分服务器提供优惠码,优惠后达拉斯机房服务器最低每月89美元起,圣何塞机房服务器最低每月...

CloudCone:洛杉矶MC机房KVM月付1.99美元起,支持支付宝/PayPal

CloudCone是一家成立于2017年的国外VPS主机商,提供独立服务器租用和VPS主机,其中VPS基于KVM架构,多个不同系列,譬如常规VPS、大硬盘VPS等等,数据中心在洛杉矶MC机房。商家2021年Flash Sale活动继续,最低每月1.99美元,支持7天退款到账户,支持使用PayPal或者支付宝付款,先充值后下单的方式。下面列出几款VPS主机配置信息。CPU:1core内存:768MB...

10gbiz($2.36/月),香港/洛杉矶CN2 GIA线路VPS,香港/日本独立服务器

10gbiz发布了9月优惠方案,针对VPS、独立服务器、站群服务器、高防服务器等均提供了一系列优惠方面,其中香港/洛杉矶CN2 GIA线路VPS主机4折优惠继续,优惠后最低每月仅2.36美元起;日本/香港独立服务器提供特价款首月1.5折27.43美元起;站群/G口服务器首月半价,高防服务器永久8.5折等。这是一家成立于2020年的主机商,提供包括独立服务器租用和VPS主机等产品,数据中心包括美国洛...

mssql2005为你推荐
支付宝注册网站在哪里注册支付宝瑞东集团福能集团是一个什么企业?discuz论坛discuz论坛要怎么弄dedecms采集织梦后台怎么采集图片网页计数器HTML静态网页中如何加计数器上传软件怎样蓝牙面对面传软件ftp工具ftp软件有哪些怎样显示隐藏文件夹如何显示隐藏的文件夹英文谷歌优化英文谷歌优化怎么做?东莞金盾网东莞哪个医院看男科好?
视频空间租用 lunarpages 163网 香港新世界电讯 patcha 私有云存储 丹弗 200g硬盘 免费吧 腾讯实名认证中心 爱奇艺vip免费领取 卡巴斯基破解版 联通网站 重庆电信服务器托管 什么是web服务器 lamp是什么意思 蓝队云 cx域名 server2008 超低价 更多