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

Megalayer促销:美国圣何塞CN2线路VPS月付48元起/香港VPS月付59元起/香港E3独服月付499元起

Megalayer是新晋崛起的国外服务器商,成立于2019年,一直都处于稳定发展的状态,机房目前有美国机房,香港机房,菲律宾机房。其中圣何塞包括CN2或者国际线路,Megalayer商家提供了一些VPS特价套餐,譬如15M带宽CN2线路主机最低每月48元起,基于KVM架构,支持windows或者Linux操作系统。。Megalayer技术团队行业经验丰富,分别来自于蓝汛、IBM等知名企业。Mega...

DMIT:新推出美国cn2 gia线路高性能 AMD EPYC/不限流量VPS(Premium Unmetered)$179.99/月起

DMIT,最近动作频繁,前几天刚刚上架了日本lite版VPS,正在酝酿上线日本高级网络VPS,又差不多在同一时间推出了美国cn2 gia线路不限流量的美国云服务器,不过价格太过昂贵。丐版只有30M带宽,月付179.99 美元 !!目前美国云服务器已经有个4个套餐,分别是,Premium(cn2 gia线路)、Lite(普通直连)、Premium Secure(带高防的cn2 gia线路),Prem...

BuyVM老牌商家新增迈阿密机房 不限流量 月付2美元

我们很多老用户对于BuyVM商家还是相当熟悉的,也有翻看BuyVM相关的文章可以追溯到2014年的时候有介绍过,不过那时候介绍这个商家并不是很多,主要是因为这个商家很是刁钻。比如我们注册账户的信息是否完整,以及我们使用是否规范,甚至有其他各种问题导致我们是不能购买他们家机器的。以前你嚣张是很多人没有办法购买到其他商家的机器,那时候其他商家的机器不多。而如今,我们可选的商家比较多,你再也嚣张不起来。...

mssql2005为你推荐
温州市网络文明传播志愿者信息登记表yw372:Com我是YW,ZX了吗flashwind用flashwind这个加速器玩游戏,会被盗号吗?会被封号吗?空间文章空间的文章被人推荐有什么好处企业推广推广专员一般每天要做哪些工作重庆网站制作重庆网站制作哪家好,重庆做网站制作的公司有谁比较了解的,应该去哪里做好些?台北市cuteftp解析cuteftp即时通EC营销即时通是什么?做什么的?网上支付功能什么是网银支付
香港服务器租用 万网域名代理 域名服务dns的主要功能为 godaddy域名解析教程 科迈动态域名 windows主机 免费ftp空间 60g硬盘 论坛空间 发包服务器 本网站在美国维护 上海域名 京东商城0元抢购 支付宝扫码领红包 空间首页登陆 杭州电信宽带优惠 腾讯数据库 cdn服务 好看的空间 葫芦机 更多