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
华纳云(HNCloud Limited)是一家专业的全球数据中心基础服务提供商,总部在香港,隶属于香港联合通讯国际有限公司,拥有香港政府颁发的商业登记证明,保证用户的安全性和合规性。 华纳云是APNIC 和 ARIN 会员单位。主要提供香港和美国机房的VPS云服务器和独立服务器。商家支持支付宝、网银、Paypal付款。华纳云主要面向国内用户群,所以线路质量还是不错的,客户使用体验总体反响还是比较好...
Megalayer是新晋崛起的国外服务器商,成立于2019年,一直都处于稳定发展的状态,机房目前有美国机房,香港机房,菲律宾机房。其中圣何塞包括CN2或者国际线路,Megalayer商家提供了一些VPS特价套餐,譬如15M带宽CN2线路主机最低每月48元起,基于KVM架构,支持windows或者Linux操作系统。。Megalayer技术团队行业经验丰富,分别来自于蓝汛、IBM等知名企业。Mega...
今天中午的时候看到群里网友在讨论新版本的Apache HTTP Server 2.4.51发布且建议更新升级,如果有服务器在使用较早版本的话可能需要升级安全,这次的版本中涉及到安全漏洞的问题。Apache HTTP 中2.4.50的修复补丁CVE-2021-41773 修复不完整,导致新的漏洞CVE-2021-42013。攻击者可以使用由类似别名的指令配置将URL映射到目录外的文件的遍历攻击。这里...
mssql2005为你推荐
searchaspsqlserver数据库sql server数据库是什么 型数据库重庆杨家坪猪肉摊主杀人重庆九龙坡区治安好么sns网站有哪些中国都有哪些sns网站?还有它们都是哪个类型的?抢米网抢小米手机需要下什么软件 速求购物车在超市、商场中为什么需要使用购物车呢?123456hd有很多App后面都有hd是什么意思123456hd手机卡上出现符号hd怎么取消billboardchina中国有进美国BillBoard榜的人吗无忧登陆无忧登录好吗?
vultr美国与日本 ixwebhosting 嘉洲服务器 网站木马检测工具 刀片式服务器 国外代理服务器软件 电信虚拟主机 网游服务器 四核服务器 免费外链相册 中国联通宽带测速 沈阳idc godaddy退款 magento主机 超低价 卡巴斯基官方下载 日本小学生 海尔t68驱动 电脑主机 主机声音大 更多