Table Mapping

this tab lets you edit and delete the default existing table column mappings you can also create, modify, and delete the custom table column mappings click "select table definition" drop down menu to select the table definition, in which you want to create, edit, and delete the table column mappings the default table column mappings are available only in "defaulttabledefinition" create table mapping administrator needs to follow below steps to create a new mapping click"create new mapping" button following pop up named "create table mapping wizard" is displayed on the screen administrator needs to fill the following details in order to create a new mapping mapping name provide a mapping name campaign type select the campaign type from the provided drop down it contains the following options interactive voice application outbound voice campaign interaction campaign parallel predictive voice campaign ivr campaign voice blast campaign chat campaign mapping sequence by default, the following two mapping sequences are displayed here searchable (licensable 5 to 10 fields) it lets you add the searchable and optional columns in the mapping it is not necessary to create the searchable fields through this feature the column on which the searchable field is applied, the column becomes searchable, means a search bar appears on the column which allows the user to search for any of the data buy the license to increase the number of searchable fields after purchasing the license, run the following query insert into system configuration parameter(name,type,value,default value) values ('maxsearchablefieldsallowed','integer','\<number of searchable fields>','\<number of searchable fields>'); the maximum number of searchable fields (after both license and configuration) is 10 after purchasing licenses, perform the configuration to increase the number of fields, if any step missed then number of fields will not increase contact either marketing department or services team of ameyo phone (licensable 5 to 50 fields) it lets you add the mandatory columns in the mapping it is mandatory for the user to fill these columns buy the license to increase the number of phone fields after purchasing the license, run the following query insert into system configuration parameter(name,type,value,default value) values ('max phone allowed','integer','\<number of phone fields>','\<number of phone fields>'); the maximum number of phone fields (after both license and configuration) is 50 after purchasing licenses, perform the configuration to increase the number of fields, if any step missed then number of fields will not increase contact either marketing department or services team of ameyo ilterable it lets you add the filterable columns in the mapping the user can leave these columns blank through this feature the administrator now have another filter field through which he can filter for the required voicelogs buy the license to increase the number of filterable fields after purchasing the license, run the following query insert into system configuration parameter(name,type,value,default value) values ('maxfilterablefieldsallowed','integer','\<number of filterable fields>','\<number of filterable fields>'); the maximum number of filterable fields (after both license and configuration) is 10 after purchasing licenses, perform the configuration to increase the number of fields, if any step missed then number of fields will not increase contact either marketing department or services team of ameyo you have to click "add" for a mapping sequence to add its column you cannot edit or delete the column mappings here attribute user can select the attributes for the added column mappings it has the following options twitter timezone facebook name phone1 phone2 phone3 phone4 phone5 email type you have to select the types of these attributes for the added column mappings following screenshot shows the sample table mapping for a custom "test1" table definition click "save" to create the table mapping alternatively, you can click "cancel" to discard the changes following screenshot shows two newly created table mappings modify table mapping perform the following steps to edit a table mapping select the table definition in "select table definition" drop down menu the mappings of selected definition are displayed select a table and click "edit" you can change the following fields here mapping name change the name of the mapping mapping of attributes you can change the mapping of attributes click "save" to save and apply the changes you cannot change the table definition name and campaign type attributes cannot be added, edited, or deleted delete table column mapping perform the following steps to delete a table column mapping it is recommended not to delete the default table column mappings available in the default table definition (defaulttabledefintion) select the table definition in "select table definition" drop down menu select the mapping and click "delete" it shows the following warning message click "yes" to delete the selected mapping you can click "no" to not delete the mapping